SUMMARY:

• 11 years of total IT experience with wide experience in various technologies and Applications, which constitutes 7+ years of onsite (US) experience.
• Pharma domain specialist.
• Experience in clinical trials with Oncology knowledge, Supply chain(Manufacturing, Demand and supply, Inventory) and Market research analysis (Sales, Ex - factory sales, Rx, DDD, activity, alignment and open payments), Plan of Care, Patient vistis, schedules, ICD10.
• SAS Developer with experience in Base and Advanced SAS, SAS DI, SAS BI and SAS Administration.
• Experience in the areas of Enterprise Application/Data Integration and reporting tools.
• Experience in comprehending and maintaining complex enterprise IT architecture with wide variety of applications.
• Experience in Pharma and Insurance (Life sciences & Health care) domains.
• Certified Base and Advanced SAS programmer.
• Excellent knowledge in Base and Advanced SAS programming, merging SAS data sets, Macro facility, SAS Functions, storing and managing data in SAS files.
• Experience in Base SAS, Advanced SAS and SAS DI tool (ETL).
• Below are the SAS tools which I have used while doing a developments in SAS.
• SAS V9.4 (Base and Advanced) FOR WINDOWS AND LINUX - (SAS/Access, SAS/Connect, Macros, procedures, Creation of datasets etc)
• SAS DI Studio 4.9
• SAS Management Console 9.4
• Enterprise Guide 7.1
• Extensively used PROC SQL in extracting data from relational databases like Oracle, Netezza
• Expertise in using various SAS procedures like Proc Sort, Contents, Transpose, Print, Format, Export Report, Summary, Tabulate, Datasets, Freq, Means, Gplot and etc.
• Ability to handle multiple tasks individually as well as in a team.
• Expertise in different methods of data extraction and reporting (SAS, Business Objects,Excel)
• Expertise with IOM (Integrated Object Model) SAS servers.
• Monitoring Data flow in live production environments (UNIX batch jobs)
• Problem Management, Issue resolution, System fixes and enhancements.
• Coordination with various functional and technical - onsite and offshore teams.
• Possess strong ability to quickly adapt to new applications and platforms.
• Experience in SAS Administration activities using SAS Management Console.
• Knowledge of Tableau desktop.
• Knowledge of SAS XML mapper.
• Knowledge of grid architecture (Grid control server, Grid nodes, Grid clients, Grid manager module and etc.), grid computing and General parallel File system (GPFS).
• Kno wledge of DataFlux dfPower Studio (dfpower architect for quality, dfpower profile configurator for profiling).
• Knowledge of Hadoop transformations like Hadoop container, Pig, Hive, Hadoop File Reader and Hadoop File Writer.

TECHNICAL SKILLS:

SAS Products: SAS V9.4, Base SAS, SAS Macros, SAS-DI, SAS-BI, SAS-OA, SAS Management Console and Flow Mananger.

Reporting/Analytics Tools: BO-XI, spotfire

Languages: HTML, XML, UNIX Shell script, Batch script, PL/SQL, VB, PHP

Operating Systems: UNIX, Windows

Database: Oracle, Netezza, MS Access, DB2

Tools: TOAD 7.2, Reflection 8.0.3, SSH Secure Shell, FileZilla, Putty, Excel

ERP: SAP APO/ECC Demand Management related Job monitoring, Data extraction and reporting, SAP ECC - Integration of Inbound and outbound logistics with Third party Warehouse Management systems.

Web Technologies: VB, VB Script, .NET, HTML, ColdFusion, Java

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Responsibilities:

• SAS DI, SAS Developer and Admin roles.
• Support existing SAS DI Jobs.
• Delivering varies type of reports using Base & Advanced SAS oracle and DB2.
• Modification of existing Reports, development of new Reports and testing using Base and Advanced SAS.
• Generating SAS datasets from tables in Database using SAS/Access, set, infile (flat files), merge and hash.
• Using procs like print, sort, means, transpose, export and etc.
• Extract data from oracle Data access using implicit and explicit pass-through SQL.
• Production support issues Analysis and Fix.
• Customer Communication.
• Status Reporting.

Environment: SAS V9.4- SAS DI studio 4.9, Management Console,Base and Advanced SAS,SAS EG 7.1, Oracle 11G, Toad, DB2, windows server 2012 and Vista plus.

Confidential, Smyrna, GA

Responsibilities:

• SAS DI consultant role.
• Analysing Business requirements and developing SAS DI Jobs.
• Ensures adherence to locally defined standards for all developed components.
• Development of SAS DI jobs to Extract, Load and transfer (ELT) data from different sources to Netezza.
• Creation of Job flows and schedule jobs using Schedule Manager.
• Execution of Flows using Flow Manager in Development environment.
• Creation of Promotional document and Operational guide.
• Supports the migration activities (deployment instructions).
• Study existing ELT architecture and rules to fit development into it.
• Customer Communication.
• Status Reporting.

Environment: SAS V9.4- SAS DI studio 4.9, Management Console, Flow Manager, Base and Advanced SAS,SAS EG, Oracle 11G, Netezza, Aginity work bench, Cognos, Qlikview(Integration testing purpose).

Confidential

Responsibilities:

• Project Management, technical architect and SAS admin.
• Technical involvement of phase1.
• Coordination of offshore and onshore.
• Review of architectural documents.
• Team Development: individual goal setting, mentoring, performance measurement.
• Customer Communication.
• Status Reporting
• Involved in SAS server installation.
• Managing different SAS servers.
• Created custom and project repositories using Metadata manager.
• Created groups and users using User manager.
• Created of Servers using Server manager.
• Created Libraries using Library manager.

Environment: SAS v9.3 for Linux, SAS-BI (9.3), SAS DI(4.3), SAS EG, SAS OA, Oracle 11G,SAVI, WINSCP

Confidential, Indianapolis, Indiana

Responsibilities:

• Translating customer requirements into technical requirements.
• To develop activity reports (Calls, Details and Samples) for various sales forces along with customer and alignment information using SAS. These reports enable them keeping a track of activities conducted by sales representatives to promote their brand products.
• To develop Rx reports for Sales forces to know the Rx count trend for Physicians at different alignment levels (Territory to Division) and Rx count trend for insurance plans.
• Developing structured and efficient reports for analyzing the sales trend.
• Maintenance and Execution of SAS Data warehousing for Marketing & sales.
• Delivering varies type of reports using SAS, Oracle and Netezza.
• Using procs like print, sort, sql, summary, transpose, export and etc.
• Coordination with offshore team.
• Using SAS/Connect (Signon with TCP) to connect PC SAS and Linux.
• Working with Linux shell programs to execute SAS programs.
• Generating SAS datasets from tables in Database using SAS/Access. Extract data from oracle, Netezza and flat files.
• Data access using implicit and explicit pass-through SQL.

Environment: SAS v9.3 for Windows and Linux, Base SAS, SAS Macro, SAS/SQL, SAS/Access, SAS/Connect, LINUX, Oracle 10G, Netezza, TOAD, SSH Secure Shell, FileZilla and MS- Excel.

Confidential, Indianapolis, Indiana

Responsibilities:

• Involved in managing randomized phase clinical trials data.
• Created electronic datasets (i.e., SAS Transport Files) for FDA submission by using XPORT library and proc copy.
• Created SDTM datasets and ADaM datasets according to CDISC standards.
• Validation of CDISC SDTM and ADAM datasets.
• Generated reports on AE (Adverse Events), Demographics, Laboratory test results, concomitant medication tables by referring to the Statistical Analysis Plan and the Mock up Shells.
• Extracted data from Oracle using SQL Pass through facility and generated ad-hoc reports.
• Created macros and extensively used existing macros and developed SAS.
• Experience in creation of define.xml according to Metadata.
• Generated summary reports, listing and graphs using procedures like PRINT, REPORT, CONTENTS, FORMAT, MEANS, FREQ, TABULATE, SQL, UNIVARIATE, NPAR1WAY, GPLOT and GHART.
• Created SAS data sets and generated listings, Analysis Data Sets(ADS), graphs and tables (TLG) as per Statistical Analysis Plan (SAP)

Environment: SAS v9.2 for Windows, Base SAS, SAS Macro, SAS/SQL, SAS/Access, SAS/Connect, Oracle clinical, TOAD and MS- Excel.