SUMMARY:

• Abo ve 7 years of experience in various SAS applications for interactive/dynamic reports generation in Marketing and Financial Analysis 
• Experience in SAS/BASE , SAS/SQL , SAS/MACROS , SAS/ODS , SAS/GRAPH , SAS/INDEXES , SAS/STAT , SAS/ETL , SAS/ACCESS , SAS/CONNECT , SAS/ENTERPRISE GUIDE , SAS/OLAP, SAS BI , SAS/ASSIST, and SAS/TOOLS in WINDOWS and UNIX environments.
• Exposure to SAS Programming, Merging SAS Data Sets, Macro Facility, Preparing Datasets, Producing Reports, Validating Reports, SAS Formats, SAS Informants, SAS Functions, Storing and Managing Data in SAS environment.
• Solid understanding of statistical concepts and various statistical procedures such as proc SQL, proc report, proc tabulate, proc plot, proc chart, proc format, proc import, proc export, proc print, proc sort, proc compare, proc append, proc connect, etc. and SAS/STAT procedures such as proc freq, proc means, proc ANOVA, proc Corr, proc Reg, proc Univariate, etc.
• Good knowledge in Clinical Data Validation, clinical phases (I, II, III, IV), and Clinical Data Interchange Standards Consortium (CDISC) SDTM mapping of clinical trial data to generate SAS compliant datasets as per CDISC standards.
• SAS programming including analysis of clinical trial data and generating reports, tables, listings, graph and summaries as per company standards and in compliance with 21 CFR Part 11, FDA and other GCP Guidelines.
• Good knowledge of data extraction and sorting data from various databases like Oracle, DB2 and MS Access.
• Experience delivering output in different formats including HTML, RTF, PDF, and creating Custom reports using SAS ODS facility, Proc Report and SQL pass through facility.
• Experience modifying existing SAS programs and creating new programs using SAS Macros to improve efficiency and consistency of results.
• Effective team player with excellent analytical , problem solving , communication and interpersonal skills , with ability to interact with individuals at all levels. Hard working , ethical and highly result oriented .

TECHNICAL SKILLS:

Statistical Software:  SAS V9.2, SAS V9.1, SAS V8.2, SAS V8.1 (Base SAS, SAS/MACRO, SAS/Connect, SAS/SQL, SAS/OLAP, SAS/STAT, SAS/Indexes, SAS/GRAPH, SAS/ODS, SAS/Access, SAS/Assist, SAS Enterprise Guide), SAS EG 4.3, SPSS

Databases:  MS Access, SQL Server, DB2, Oracle, SQL queries.

Tools: SAS, SQL, MS Office 2003/2007, MS Access, Excel, Word, PowerPoint, SPSS, StarTeam, Adobe Insight, Salesforce, RTC, Control - M, Hadoop, BO

SAS Procedures:  Print, Printo, Frequency, Means, Summary, Tabulate, Chart, Gchart, Plot, Gplot, Univariate, Corr, Contents, Compare, Append, Copy, Datasets, Format, Options, Sort, Transpose, Report, SQL, ANOVA, Reg, Setinit, Import, Export

Operating Systems:  Windows 2000/NT/XP/Vista, UNIX, MSDOS, Mainframe

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, TX

Data Science Analyst/Report Developer

Responsibilities:

• Mainly responsible for UDA (User Defined Application) Clearinghouse project at Enterprise level by delivering different reports, dashboards, and marketing lists to clients.
• Experience with Control-M environment to run all SAS and Mainframe jobs in UCH area.
• Working to gather, document and understand high level business requirements for the purpose of implementing sales and marketing solutions by using SAS environment.
• Automated ID verification manual stored process in SQL to fetch live data in EFCM area.
• Working closely with SAS Governance team to lead SAS Life Cycle Management initiative to automate all manual SAS codes run by analysts or users and to schedule in Control-M environment.
• Optimizing and automating existing reports to minimize errors and enhance performance by converting and data submission requirements.
• Develop new SAS macros for data acquisition and develop data source documentation.
• Creating outbound dialer list for sales and marketing campaigns by running SAS jobs into Mainframe.
• Using Advance SAS procedures such as SAS MACRO, ODS, PROC SQL, PROC REPORT, PROC SUMMARY, PROC SORT, etc.
• Enhancing reports through the use of user-defined formats, titles, footnotes and SAS System reporting and generating reports using ODS statements.
• Analysing new business requirements and coming up with design solutions.
• Handling critical issues and providing support during implementation into production.
• Programming and development in Base SAS, SAS web portal, and Enterprise Guide 4.3 .
• Partnering with the advanced analytics and report analysis teams to understand reporting requirements and transform requirements into production SAS code.
• Authoring complex SQL queries for data extractions from the enterprise data warehouse and master custdata file.
• Supporting the analysis of risk ranking for reports and dashboards and mitigating the risk by implementing platforms and techniques.
• Creating, evaluating and implementing predictive SAS models by applying different statistical methods.

Environment: SAS 9.2, SAS EG 4.3, SAS/Tools, SAS/Base, SAS/Macro, SAS/SQL, SAS/Graph, SAS/Access SAS/ODS, SAS/BI, SAS/Connect, MS-Excel, MS-Access, Adobe Insight, Salesforce, Starteam, oracle, Mainframe (TSO) and Windows XP

Confidential, Bloomfield, CT

Sr. Developer/Analyst

Responsibilities:

• Primarily responsible for CAP/EICO (requestor backend) assignments.
• Working with SAS ETL tool for querying data from different sources such as Oracle , DB2 , and access and convert raw data to SAS datasets .
• Responsibility includes building new tables and data source from DB2 and SAS datasets .
• Construct metric , extract , xml , auto-text , metadata and data source for different projects.
• Develop programs to create PowerPoint and Excel output for Confidential clients and customers.
• Review codes/programs for end-to-end testing and run requests to test different output reports in SAS Enterprise Guide .
• Produce dynamic report and create Java-excel Bridge for formatting excels report.
• Upload the all programs and data tables to SAS server using FTP protocol and prepare move up document for project release.
• Mostly working with PROC SQL and Macro procedures by using different joining logics .
• Create and modify procedures to solve complex problems considering computer equipment capacity and limitations, operating time, and form of desired results.
• Key responsibilities include designing , coding , testing , debugging , and documenting programs and perform systems analysis functions.
• Generate reports and graphs from datasets for final deliverables by using different procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE, Proc SQL, Macros, and PROC REPORT.
• Mostly responsible for designing, coding and testing a series of SAS programs for validating and reporting of healthcare and clinical SAS data .
• Used SAS/ODS to generate reports on HTML web format as well as in RTF and PDF formats.
• Work with clinical reporting data to generate statistical tables, graphs and listing summaries.
• Provide consulting services/technical support related to SAS.
• Focused on SAS delivery in a timely manner.
• Prepare flowcharts indicating the input data sets, sorting and merging techniques.
• Create programs using DO LOOPS , ARRAY , and SAS/STAT to manipulate numerical data and scientific data .

Environment: SAS 9.1.3, SAS/Tools, SAS/Base, SAS Enterprise Guide, SAS/SQL, SAS/Macro, SAS/ETL, SAS/Graph, SAS/Access SAS/ODS, SAS/STAT, SAS/Connect, MS-Excel, oracle, DB2, UNIX and Windows XP, Ultra Edit, Informatica.

Confidential, Tampa, FL

SAS Analyst/Developer

Responsibilities:

• Perform a Sizing of the SAS Enterprise and SAS Connect server environments, existing and new user groups data sizes/processing needs to determine appropriate hardware/software upgrades required to support an additional users.
• Create statement of understanding (SoU), project plan, and sizing recommendation report along with estimates.
• Experience with SAS ETL tool for pulling data from different sources such as Oracle, RDBMS, and access and upload the client data to SAS server using PgP and FTP protocol and convert raw data to datasets.
• Generate reports and graphs from datasets for final deliverables by using different procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE, and PROC REPORT.
• Designed, built and tested a series of SAS programs for validating and reporting of SAS data.
• Used SAS/ODS to generate reports on HTML web format as well as in RTF and PDF formats.
• Analyze the current CPU/USER activity reports under maximum CPU utilization and comparison of the Reports obtained.
• Used to work on previously coded programs and modify it according to client requirements and then generate the reports.
• Used to create and load data into a DBMS table from a SAS data set by using DBLOAD procedure.
• Experience with integration of data analysis, data management, data designing and data mining by using SAS Business Intelligence (BI).
• Work with Health and welfare data to generate statistical tables, graphs and listing summaries.
• Experience in SAS programming using different SAS procedures in UNIX and Windows environment.
• Usually used Base SAS, SAS/Macros, SAS/SQL, SAS/Graph, and SAS/ Stat.
• Perform recommended hardware and software upgrades.
• Experience for up-gradation of SAS software from version 9.1.3 to version 9.2.
• Understand the structure and definitions of SAS components such as library, catalog, customised jobs, schedulers, stored and compiled macros etc.
• Finalize the best approach solution for migration (depends on the architecture and environment).
• Worked in various operating systems like UNIX, Windows and KornShell scripting.

Environment: SAS 9.2, SAS EG 4.1, SAS/Tools, SAS/Base, SAS/Macro, SAS/SQL, SAS/Graph, SAS/Access SAS/ODS, SAS/BI, SAS/ETL, SAS/STAT, SAS/Connect, MS-Excel, MS-Access, UNIX and Windows XP

Confidential, Berlin, CT

Sr. SAS Programmer/Analyst

Responsibilities:

• Worked with a team of Statisticians and Data Managers for Generating Safety and Efficiency tables by leading all projects.
• Gathered and transformed data from flat files using SAS/ACCESS.
• Created and Modify SAS Macros for Data Cleaning, Validation, Analysis and Report generation.
• Drew flowcharts indicating the input data sets, sorting and merging techniques.
• Wrote code using SAS/Base and SAS/Macros to extract clean and validate data from flat file, Excel file, Teradata, RDBMS, Access Database, and Oracle Database using SAS ETL and dbload processes.
• Experience with integration of statistical analysis, data mining, forecasting, and optimization by using SAS Enterprise Business Intelligence (EBI).
• Extensively using DO LOOPS, ARRAY, and SAS/STAT to manipulate numerical data and scientific data by using KornShell scripting.
• Developed and improved the efficiency of programs through the use of SAS macros and SAS/SQL.
• Write Procedural Language SQL (PL/SQL) query for data manipulation and data analysis .
• Used many Base SAS procedures for analysis, management, presentation and access of the data.
• Used many Base SAS functions for data cleaning.
• Experience with data extraction and manipulation on different software such as UNIX, Mainframe, and Microsoft Windows.
• Experience in building, maintaining, and managing SAS OLAP cubes for multidimensional data.
• Introduced new variables with existing variables based on business logics using keep and drop statements.
• Modified standard programs to generate data sets for statistical data analysis, generate listings, summaries, tables, graphs and reports for analyzing data results in compliance with relevant SOPs as per SAP.
• Produced Reports, Listings, Tabulations and Summaries of the data using procedures such as PROC MEANS, PROC SUMMARY, PROC UNIVARIATE, PROC TABULATE, and PROC REG.
• Creating routine and ad-hoc reports using PROC PRINT, PROC FREQ, PROC CHART and PROC REPORT.
• Extensively using PROC GPLOT and PROC GCHART for generating graphs and plots.
• Formatted HTML, RTF and PDF reports, using SAS Output Delivery System (ODS).
• Preliminary data validation and data correction of data using PROC COMPARE and PROC CORR.
• Making summary presentations of business highlights to senior management.
• Documenting process flow, improving and updating procedures for existing SAS applications.
• Interacted with other team members to discuss the required development to be implemented in coding to improve the functionality and effectiveness.

Environment: SAS 9.2, SAS 9.1.3, SAS/Tools, SAS/Base, SAS/Macro, SAS/Graph, SAS/SQL, PL/SQL, SAS/Access SAS/ODS, SAS/BI, SAS/ETL, SAS/STAT, SAS/Connect, MS SQL server, MS-Excel, oracle, UNIX and Windows XP