*Hi,
We have an urgent opening for an SAS Developer. Please review the
requirement carefully. Below is a brief summary of the resume of the person
we placed recently. Please let me know if you have anyone. Rate is 40.00
Thanks. Reply at [email protected] ONLY**
SAS Developer
MICHIGAN
6 Months +
$40/hr C2C
Start ASAP
PROFESSIONAL SUMMARY:*
- Around 7 years of experience in Financial, Pharmaceutical, Healthcare
and Retail Industry; working in a fast paced environment, wherein expertise
acquired through practical proficiency, can be put to the best use possible
for the organization's escalation.
- Certified SAS programmer with extensive knowledge of different
financial models, projections, DSS [Decision Support Systems] and
documentation.
- Working experience in different Phases of Clinical trials including,
but not limited to, analyzing data, sorting raw data, cleaning and storing
sorted data and generating appropriate reports.
- Extensive SAS programming experience with SAS Base, SAS Macros, SAS
SQL, SAS Stat, SAS Graph, SAS Enterprise Guide and SAS ACCESS in Windows,
UNIX and Mainframe environments.
- Practical knowledge of and expertise in the SAS programming language,
especially Data step programming, report generation(ODS) and writing
reusable standardized code.
- Strong background in and adequate exposure to statistics procedures
offered by SAS including, but not limited to, Proc Summary, Proc Means, Proc
Freq.
- Comprehensive programming experience with SAS procedures such as SORT,
SUMMARY, MEANS, FREQ, IMPORT, EXPORT, CONTENTS, PRINT, TABULATE, REPORT,
SQL, TRANSPOSE, FORMAT, PLOT, CHART, DATASETS, ACCESS, DBLOAD and
UNIVARIATE.
- Strong ad-hoc queries skills for statistical analysis in vital
statistics.
- Experience in statistical practices like T-Test, Correlation, and
Linear Regression, Chi-Square Test etc. using SAS tools such as ANOVA, REG,
GLM and Cluster.
- Extensive experiences in applying SAS procedures such as import,
export, read and/or write data from raw / delimited files, MS Excel
Spreadsheets and MS Access Tables.
- Proficient in Internet and Intranet technologies e.g. HTML.
- Professional Debugging, Revision and Testing of all deliverables,
including Production Code, to abide by QC Checks, Execution standards and
Maintenance requirements.
- Capable of executing a number of projects simultaneously with ease.
- Extremely adaptable with the ability to be productive and efficient
under high stress and in fast paced environments.
- Highly organized and motivated team player with distinctive analytical
and communication skills.
- Willing to take on extra responsibilities to get work done.
- Enthusiastic, innovative, versatile, quick learner, challenge oriented
and extremely adaptable.
- Excellent oral, written organization and multitasking skills with
proven ability to learn, program and use new technologies.
*TECHNICAL SKILLs:*
Operating Systems
UNIX, Windows, MVS
Statistical Software
SAS/ BASE, SAS/STAT, SAS/MACRO, SAS/GRAPH, SAS/ODS, SAS/ACCESS, SAS/Connect,
SAS/Enterprise Guide, SAS/ETL, MATLAB
Programming Languages
SQL, PL/SQL, C, C++, Visual Basic , Java, Asp.net
RDBMS
Oracle, MS Access, and MS SQL Server
Application Software
MS Office, Microsoft Visual Studio
* *
*EDUCATION:*
MS in Computer Science - Bachelors in Engineering, India
*PROFESSIONAL EXPERIENCE:*
03/08 - present
DirecTV, El Segundo, CA
Business Analyst / SAS Programmer
The project involved analyzing databases of customer performance data to
prepare statistical data models incorporating factors like higher response
rates, reduced defaults and decreased delinquencies among new customers for
making better decisions. As a team member involved in development and
implementation of a pilot project reporting risk measures at user-specified
levels of aggregation such as: firm-wide, by location, by region using
cross-classification variables.
Responsibilities:
- Used SAS/ACCESS to extract data from relational database management
system (Teradata) using SAS.
- Maintaining large datasets, combining data from various sources in
varying formats to create SAS datasets and / or ASCII files by using Set and
Merge for generating Reports and Graphs.
- Prepared new datasets from raw data files using Import techniques and
modified existing datasets using Set, Merge, Sort and Update, Formats,
Functions and conditional statements.
- Validated, documented and tested component programs in an efficient
manner for inclusion in integrated reports.
- Performed extraction, transformation and loading from large Teradata
tables using PROC/SQL insert into statement.
- Performed statistical data analysis, generated reports, listings and
graphs using SAS/Base, SAS/Macros, SAS/SQL, SAS/Access and SAS/Graph.
- Worked with complex datasets to extract customized reports using
procedures such as SQL, FREQ, SORT, REPORT and MEANS creating a preferred
list of customers as per the given requirements.
- Developed reports using PROC REPORT, PROC TABULATE and DATA _NULL_.
- Performed data analysis mainly using Regression and ANOVA (Proc REG,
Proc GLM, and Proc ANOVA).
- Created reports in the style format (RTF, PDF and HTML) using ODS
statements.
- Involved in requirements gathering and project documentation.
- Effectively prepared various performance reports and presentations.
- Revised and automated daily, weekly, monthly and quarterly reports to
run more efficiently and provide more meaningful information vital to the
overall strategies.
*Environment: SAS/ACCESS, SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH,
SAS/SQL, SAS/Enterprise Guide, Teradata, MS OFFICE.*
12/06 - 02/08
Office of Mental Health, Albany, NY
SAS Programmer/Analyst
The Office of Mental Health (OMH) is part of New York State's mental health
system which serves more than 500,000 individuals each year. The Office of
Mental Health operates psychiatric centers across the State, and also
regulates, certifies and oversees more than 2,500 programs, which are
operated by local governments and nonprofit agencies. These programs include
various inpatient and outpatient programs, emergency, community support,
residential and family care programs. It also maintains health data sets and
publishes several quarterly and annual surveys and reports.
Responsibilities:
- Used SAS/BASE, Macros to develop dynamic SAS programs to extract,
validate data from raw data sets for Statistical analysis.
* *
*PROFESSIONAL EXPERIENCE (CONTINUED):*
12/06 - 02/08 (CONTINUED)
Office of Mental Health, Albany, NY
SAS
Programmer/Analyst
- Extracted data from Oracle, using SQL pass through facility of SAS/
ACCESS, for further analysis.
- Extensively used SAS procedures like means, frequency and other
statistical calculations for Data validation.
- Developed SAS programs using Base SAS for tabulation counts,
correlations and check for dispersion for normality using PROC Means, PROC
Tabulate and PROC Univariate.
- Generated reports for different requirements such as Medicine usage,
Monthly Orders, Dispensed Medicines, Daily IV Reports, Dispensed medicines
from pharmacy to nursing units, Anesthesia Daily Report etc.
- Generated graphs using SAS/GRAPH and the Proc Gchart, GPlot.
- Conducted statistical modeling for both continuous and categorical
data, including linear regression, nonlinear regression, ANOVA, GLM model,
repeated measure, nonparametric regression, classification tree etc.
- Created Database Reports using SQL for various Health care Products
such as Medicaid, Medicare and other Third Party Providers.
- Created state wise and regional wise reports using analysis output and
export them to web enabled format using SAS Output Delivery System (ODS).
- Prepared documentation based on the standard operating procedures (SOP)
and quality control methods were adopted for every system development life
cycle activities.
*Environment: SAS (Base, Macros, SQL), SAS/ETL, SAS/GRAPH, SAS/ACCESS,
SAS/CONNECT, SAS/STAT, Excel, Access, Oracle, PL/SQL, Windows XP*
07/05 - 11/06
ROSS Stores, Pleasanton, CA
SAS Programmer/analyst
ROSS is a well renowned apparel selling organization.
Responsibilities:
- Worked for inventory management project.
- Coding based on operations inventory strategy algorithms.
- Generating clusters based on store level information.
- Generating seasonality curves and elasticity curves using SAS/GRAPH.
- Responsible for the Design, Development and maintenance of ES tool
(seasonality and elasticity).
- Automated many of the MATLAB / TERADATA scripts which are run
periodically in SAS using SAS/MACROS.
- Extracted the data from Teradata by connecting through SAS using SAS
pass through facility for analysis purposes.
- Uploaded many tables in Teradata using SAS and PROC/SQL insert into.
Since SAS/ACCESS doesn't support the DBLOAD Procedure used the conventional
data step procedure to get the job done.
- Have written error detection programs for checking the errors in the
log and notifying the concerned people at the production level.
- Generation of store average using MATLAB and SAS.
- Worked on many ad -hoc queries.
*Environment: SAS, TERADATA, MATLAB, SAS/SQL, SAS/MACROS, SAS/CONNECT,
SAS/GRAPH, SAS/STAT, Windows*
* *
*PROFESSIONAL EXPERIENCE (CONTINUED):*
05/04 - 06/05
Washington MUTUAL, SEATTLE, WA
SAS programmer/Analyst
Washington Mutual bank is one of the biggest banks in the western part of
USA.
Responsibilities:
- Worked for contact management group as a marketing analyst.
- Creating SAS data set from flat files, excel files and from oracle,
Oracle was our main data base.
- Performed QC Checks for out put files and loaded them into History
Database.
- Generate waterfall report by passing them through suppressions, and the
user requested analysis.
- Development of standard SAS macros to be used throughout out the
marketing campaigns.
- Create electronic data sets (i.e. SAS transport files) for electronic
submissions to the marketing vendor.
- Created SAS MACROS and SAS/GRAPHS, used PROC REPORT to generate
reports.
- Used PROC SQL for connecting to oracle, used connect to ODBC through
PROC SQL to get the job done.
- Preliminary data validation is performed using PROC COMPARE of BASE
SAS.
- Loading the results generated into a database called TCH so that the
campaign is tracked of the actual results.
- Extensive usage of ODS statement for creating rtf, html files.
- Used DDE (Dynamic Data Exchange) to send the information to excel.
*Environment: SAS/BASE, SAS/SQL, SAS/MACROS, SAS/STAT, SAS/GRAPH, Microsoft
Access, Oracle, Windows, UNIX*
06/03 - 04/04
Seattle Genetics, Seattle, WA
SAS Programmer
Responsibilities:
- Prepared, processed and analyzed clinical data required for analysis
of clinical trials for Phase I studies with SAS performing
ETL-Extraction/Transformation/Loading. Data was collected in CRF and sent to
us as raw data.
- Interacted with data management team to understand the data and query
requirements.
- Extracted and maintained SAS data sets from the raw data.
- Created SAS Customized Reports using the Data _Null_ technique for FDA
evaluations.
- Prepared tables like subject disposition, Laboratory summary.
- Used SAS procedures like SUMMARY, MEANS and TABULATE for analysis and
report generation.
- PROC SQL is used for querying and reporting.
- Provided SAS programming and statistical support to the clinical
studies.
- Created Summary and tabular reports using Proc Report.
- Generated SAS graphs and listings as per the SAP and mock tables.
- Prepared safety reports according to the protocol.
*Environment: Base SAS, SAS/Macro, SAS/SQL, SAS/Graphs, SAS/STAT, MS-EXCEL,
HTML, Oracle, UNIX*
* *
*PROFESSIONAL EXPERIENCE (CONTINUED):*
08/02 - 03/03
Wipro, Mumbai, India
SAS Developer
Wipro's client ICICI Prudential Life Insurance Company provides services to
an array of clients, including individual investors, small businesses,
corporations, financial institutions, governments and government agencies.
The aim of the project was to assess strategies by letting you profile
customers who have purchased numerous policies. You can then assign similar
analytics to other customers in order to determine which ones are good
candidates for additional product offers.
Responsibilities:
- Involved in developing programs and applications using SAS for data
extraction, creating SAS data sets and performing statistical analysis to
aid in marketing and financial decisions.
- Interfaced with Marketing and Financial departments to develop required
applications for performing complicated analysis like customer retention
analysis, identifying cross-sell opportunities, portfolio performance
tracking, calculating moving averages etc.
- Extracted and transferred source data from different databases like
Oracle, Access into Oracle database.
- Used PROC SQL for ad hoc report programming, to perform the tasks like
data manipulation of multiple views in Oracle, creation of the ad hoc
reports of market research data, preplanning and doing ad hoc joining of
multiple Oracle views.
- Generated SAS MACROS and several PL/SQL stored procedures for
reusability and minimize data processing.
- Effectively prepared and published various performance reports and
presentations.
- Ensured quality of dataset at the protocol level while working to
deliver competitive advantage and cost efficiency to the company as a whole.
- Generated graphs using SAS/GRAPH and the SAS Graphics Editor.
- Developed routine SAS macros to create tables, graphs and listings.
- Created SAS MACROS and SAS GRAPHICS.
- Performed rigorous User Acceptance Testing for various applications and
reports.
- Provide user training to managers and other analysts. Record feedback
for from users for enhancements on current versions of products.
*Environment: SAS/SQL, SAS/MACROS, SAS/BASE, SAS/STAT, SAS/GRAPH, HTML,
ASP, Oracle, Mainframe*
**
*Regards
Santosh
Delight Consulting Services LLC.
Phone: 248-680-6684 ext 300 / 307
**Cell: 248-875-2277
Fax: 248-498-6195
Email:[email protected] <email%[email protected]>
**
*
--
Regards
Santosh
Delight Consulting Services LLC.
2565 S. Rochester Road,
Suite# 107A,
Rochester, MI 48307.
Phone: 248-680-6684 ext 300 / 307
Cell: 248-875-2277
Fax: 248-498-6195
Email:[email protected] <email%[email protected]>
[email protected]
Note: We respect your Online Privacy.
This is not an unsolicited mail. Under Bill s.1618 Title III passed by the
105th U.S. Congress this mail cannot be considered Spam as long as we
include Contact information and a method to be removed from our mailing
list. If you are not interested in receiving our e-mails then please reply
with a "remove" in the subject line and mention all the e-mail addresses to
be removed with any e-mail addresses which might be diverting the e-mails to
you.
--
You received this message because you are subscribed to the Google Groups "SAP
BASIS" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sap-basis?hl=en.
