SUMMARY

• 7+ years of experience in analyzing and reporting various data - longitudinal, survival, discrete, and others using SAS in Windows and UNIX environments.
• Strong experience in Data analysis and Reporting in finance, healthcare/Biotech and marketing sectors.
• Proficiency in PROC SQL, SAS Arrays, SAS Base procedures, summary and reporting procedures.
• Experienced in producing RTF, PDF, HTML files using SAS ODS facility.
• Strong experience in extracting, retrieving data, SAS data repositories from different environments such as Access, SQL, and Oracle databases using TOAD, SQL and Oracle libname engine
• Strong experience in UNIX shell scripting.
• Experience in editing/modifying SAS programs by checking data inconsistencies.
• Strong experience in developing SAS database and designing datasets for SAS statistical analysis.
• Expertise in using various SAS report generating procedures like PROC SUMMARY, PROC REPORT, PROC SQL, PROC MIXED, PROC GENMOD, PROC NLMIXED, PROC GLIMMIX, PROC UNIVARIATE, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE, PROC GLM, PROC SURVEYREG, PROC SURVEYSELECT.
• Significant experience in requirement gathering, building, designing and testing the application to meet the functional Design and Business Process Design.
• Strong experience in developing SAS database and designing datasets for SAS statistical analysis.
• Excellent in Data interpretation, supporting statistical methodologies and Statistical Analysis Plan (SAP).
• Experience in Data Cleansing, Data Archival, ad-hoc reporting and coding utilizing SAS in Windows and UNIX Environments.
• Excellent team player and quick learner to new application, environment and systems.
• Highly motivated individual with excellent organizational and interpersonal skills.

TECHNICAL EXPERTISE

Statistical Tools: SAS/Base, SAS/Stat, SAS/Macro, SAS/SQL, SAS/Graph, SAS/ODS, SAS/Connect, SAS/Access, SPSS, R

Operating Systems: Windows, Unix (Unix shell scripting).

Databases: Oracle, MS SQL, Teradata, DB2

Certifications: SAS Base Certified, SAS Advanced Certified.

Business Intelligence Tools: TABLEAU, IBM-Cognos

Programming languages: Python, C, C++, Java

PROFESSIONAL EXPERIENCE

SAS Programmer

Confidential, Atlanta, GA

Responsibilities:

• Involved in Data Analysis, Data preparation and Graphical Presentation with extensive use of SAS Base, SAS Macro and SAS Enterprise Guide.
• Documented the developed macros explaining the functionality of the macro and also developed complex SAS Macros to simplify SAS code and effectively reduce coding time.
• Experience in editing/modifying SAS programs by checking data consistencies and unanimities.
• Reviewed market data to verify integrity and consistency for completeness, accuracy and suitability.
• Developed SQL queries to generate daily, weekly, monthly and quarterly reports and used SAS Macros and system options to automate the process.
• Conducted multivariate segmentation analysis, performance analysis and forecasting.
• Generated reports using various SAS procedures such as PROC FREQ, PROC MEANS, PROC TABULATE, PROC ANOVA, PROC SUMMARY, PROC REPORT, PROC SQL, PROC MIXED, PROC GENMOD, PROC NLMIXED, PROC GLIMMIX, PROC UNIVARIATE, PROC TRANSPOSE, and PROC GLM.
• Provided analytic, statistical and technical thought leadership on projects, developed and recommended solutions.
• Professional Debugging, Revision and Testing of all deliverables, including Production Code, to abide by QC Checks, Execution standards and Maintenance requirements.
• Created ad-hoc reports as per business requirements.
• Generated highly customized reports in the form of listing, HTML, RTF and PDF using SAS ODS, PROC REPORT, PROC TABULATE, and PROC SQL.

SAS Programmer

Confidential, NC

Responsibilities:

• Acted as liaison between various Survey/Research providers to meet specific data needs and gather business and technical requirements from both formal and informal sessions.
• Extracted the data from the Oracle database using SAS/SQL (Pass through facility) and created various datasets for sales analysis.
• Automation of Data Extraction, Transformation and Loading the results to final datasets using Oracle, SAS and SQL.
• Maintained and enhanced existing SAS reporting programs for marketing campaigns and post campaign analysis.
• Designed, developed, implemented and maintained targeted marketing campaigns and analytic programs. Ensured integrity of campaigns and analysis through rigorous attention to detail and validation of data.
• Preview Statistical Analysis and planning.
• Created reports in RTF, PDF and HTML formats using ODS statements.
• Understand and document in house SAS optimization program and generate reports as per schedule
• Interact with field teams to understand business process and make recommendations on model enhancements.
• Report management on model performance and reporting.
• Analyzed response and sales results and draft summary reports on campaign performance.

SAS Programmer/ Marketing Analyst

Confidential, TX

Responsibilities:

• Extracted data from the database using SAS/Access, SQL pass through facility and create SAS datasets and generate reports.
• Involved in update and maintenance of data warehouse and generation of various sales and marketing reports.
• Gather information and generate reports regarding selling patterns, traffic volumes, geographic divides and seasonal swings.
• Conducted thorough analysis on historical data to generate seasonality of demand index profiles.
• Performed complex statistical analysis using PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG and PROC ANOVA.
• Analyzed response and sale results and draft summary reports on campaign performance.Worked with large customer response and sales data sets.
• Validated, documented and tested component programs in an efficient manner for inclusion in integrated reports.

SAS Programmer/Business Analyst

Confidential

Responsibilities:

• Extracted data from different sources like Teradata, Excel and test files using SAS Access facility and SQL scripts.
• Conducted data quality checks and prepared data for modeling.
• Involved in standardizing reporting procedures for graphical and tabular reports.
• Created various pivot tables and generated reports in using VLOOKUP, HLOOKUP, Get Pivot Data and CHOOSE functions of Excel.
• Used various VBA functions like Date Diff, Date Serial, Month Name and Weekday Name for automation of Excel reports.
• Worked on MIS reports to analyze financial and business results of the company.
• Developed SQL queries to generate daily, weekly, monthly and quarterly reports and used SAS Macros to and system options to automate the process.
• Involved in statistical analysis using various SAS products SAS/BASE, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/MACROS etc.
• Wrote programs in SAS to generate reports, HTML listings and tables using SAS ODS.
• Automated report procedures using Scripts in Unix Environment.
• Worked with Clinical research staff to provide SAS programming support to Clinical study group.
• Prepared, documented and tested required programs and procedure data displays in an efficient manner for inclusion in integrated Clinical, statistical reports and other similar reports.
• Processed the data in SAS for the given requirement using SAS programming concepts.
• Imported and Exported data files to and from SAS using Proc Import and Proc Export from
• Excel and various delimited text based data files such as .TXT (tab delimited) and .CSV (Comma delimited) files into SAS datasets for analysis.
• Transformed and manipulated data using different SAS functions
• Generated reports using Proc Tabulate, Proc Report, Data Null, SAS arrays, Proc SQL, and SAS Macros.