SUMMARY:

• Around 10 years of experience in IT industry wif firsTEMPthand knowledge of all facets of Software Development Lifecycle (SDLC) including requirements gathering, analysis, design, development, Reporting, Testing, implementation, and support.
• Experience in gathering business information, analyzing and documenting business & system requirements using standard templates BRD FRD TRD.
• Strong Experience on SAS programming in Clinical, HealthCare, Insurance, Retail domains to analyze data, Reporting Tools, tables, listings, and generate reports & graphs.
• Used teh statistical procedures of Univariate, analysis, Multivariate Analysis, ANOVA, GLM, Procedures, SAS/Stat, SAS/ACCESS etc.
• Good knowledge of teh Clinical, Healthcare, Retail, Insurance and Finance domain. Skilled in Data maintenance like Data Retrieval, Analysis and Reporting etc., Wif increasing responsibility for teh scope, development, completion of projects and task assignments.
• Good knowledge in Clinical Trials (Phase I - III) worked on different datasets Demographic data, AE, Labs, and Vital Signs etc. CDISC standards (SDTM and ADaM datasets). Knowledge on regulatory submissions FDA.
• Understanding of Healthcare HIPAA and HITECH PII, PCI, and PHI data collection, reporting and distribution requirements and health care codes like ICD9, ICD10, CPT, HCPCS, DRG etc
• Experience in Data Extraction, Data Cleansing, Merging, Data Validating, Data transforming and Report Development using SAS.
• Experienced in Hadoop Framework, Apache Pig and Apache Hive, and SQOOP.
• Performed data analysis using spark, internally uses Scala, Working wif Scala/spark wif efficient use of cluster resources, SparkR and PySpark.
• Strong knowledge in Base SAS, SAS/MACRO, SAS/SQL and SAS/DI Studio, SAS forecasting and modeling, SAS BI tools, SAS EM,SAS EG, SAS GRID SAS Visual Analytics, SAS CI Suite(CRM), Databases DB2, Oracle and Teradata,.

TECHNICAL SKILLS

SAS Tools: Base/SAS, Macros, SAS BI,SAS CI (CRM), SAS GRID.

SAS BI tools: SAS DI Studio, SAS/OLAP, SAS/Web Report, SAS/EG.

Hadoop: HDFS, Hive, PIG, SQOOP, Spark, PySpark, SparkR.

Operating Systems: Windows, UNIX and LINUX

PROFESSIONAL EXPERIENCE

Confidential, Arizona

Sr. SAS consultant

Responsibilities:

• Maintain and tune teh SAS GRID Environment. Provides SAS Platform capacity planning, metrics and performance tuning recommendations.
• Targeting, scheduling Program DB and Macro Changes, server configuration changes and Unix Cron Job scheduler to Linux maestro scheduler testing and implementing.
• SAS configuration files such as autoexec, configuration and environment files.
• Upgrade AIX SAS 9.3 to Linux 9.4 Grid environment and tested on it.
• Calling SAS from Apache server loc using SAS LSF and SAS GSUB
• HIPAA, PHI, PII, PCI data extracted from source system and loaded to data sets and migrate it to SAS grid Metadata servers and experience in teh Healthcare / Health domain, wif good understanding of HIPAA data Privacy and Security
• Working knowledge of LSF as it pertains to teh SAS grid.
• Serves as an escalation point for production and/or platform issues and acts as lead liaison wif SAS Technical Support to resolve outstanding issues wifin teh SAS environments and Starting and stopping servers
• Collaborates wif storage, server, LDAP, database and other IT administrators to support ongoing operations for meeting teh business needs via teh SAS environment.
• Monitoring grid and make sure that nodes are balanced wif SAS generated code running efficiently across grid
• Ensuring users application ID access and DB connectivity access to EG and SAS GRID servers.
• Migrating SAS EGP 5.1 To7.1 Grid environment and testing teh code.

Environment: Base SAS, SAS/Stat, SAS/Macros, SAS EG7.1, SAS GRID, SAS EM, SAS Visual Analytics/HPA Server, Windows / UNIX/LINUX, DB2, Oracle, Hadoop, Teradata.

Confidential

Clinical SAS Programmer

Responsibilities:

• Worked wif different clinical trials data like Demographic, Adverse Event (AE), Serious Adverse Event (SAE), Laboratory-chemistry/Hematology/Urine analysis, Vital signs, etc.,
• Used regulatory requirements concerning industry technical standards (e.g., CDISC, 21 CFR Part 11, electronic submissions, etc.) and implications for teh department.
• Using SAS software (BASE, STAT, GRAPH, MACRO) for teh production of well formatted datasets, tables, listings, and figures, and outputs requested (e.g., patient profiles) per programming specifications, Statistical Analysis Plan, and other study related documentation & SOP’s and Created TLF’s
• Generated Tables, Graphs and Listings for inclusion in Clinical study reports and regulatory submission and participated in preparing study results as well as ISS and ISE for FDA submissions using SAS.
• 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.
• Created SASDatasets extracted fromOracleClinicaldatabase usingSQL passthroughfacility
• Support ad hoc and urgent programming tasks as assigned by management
• Monitor CDISC and regulatory guidance regarding SDTM Implementation. Validate SDTM & AdaM datasets for statistical analysis and regulatory submission, Generate and/or validate SDTM datasets by reviewing annotated CRFs, mapping specifications.
• Creates/ validates teh e-submission components (transport datasets for both SDTM & ADaM, Annotated CRF, define documents)
• Generated Descriptive and Statistical summary outputs using Proc Means, Proc Freq, Proc Univariate and Proc Summary etc
• Adhoc and Periodic reports Report’s using SAS
• Support business clients in teh execution of business plans.
• Generate Diagnostic reports, Clearance Summary reports, analyze graphs and statistical results interacting wif Teradata, DB2 and Hadoop
• Analyzes performance of SAS forecast models, tunes model parameters for optimum forecast accuracy
• Machine learning algorithms and implementation of same in SAS sales forecasting and SAS MA.
• Written Apache pig scripts to process internal data.
• Importing exporting data into HDFS and Hive using sqoop
• POC Hive, pig, SQL and HDFSHadoop compression formats
• Implemented email alert mechanism
• Automated teh scripts to improve model performance to optimize model runs
• Buy one get one BOGO functionality used pig scripts offer level modeling

Environment: Base SAS, SAS Macros, SQL,SAS Revenue optimization, SAS CI studioTeradata,DB2, UNIX, SAS EG, SAS EM., Hadoop, HDFS, Hive, Pig, SQOOP.

Confidential Chicago IL

Tech lead (SAS Programmer

Responsibilities:

• A Markdown group plan is a series of price decreases over time for one or more products in teh same group of stores using teh same markdown dates and Business rules using SAS revenue optimization tool.
• Run teh reports by business and by teh current season in teh UNIX production box.
• Running UNIX scripts, create Cports and send Emails to Business Unit.
• Analyzes performance of SAS forecast models, tunes model parameters for optimum forecast accuracy.
• Run hold-out forecasts and performance statistics.
• Prioritize work based on model performance, inventory levels and business requirements.
• Triage high priority SAS forecast models to determine optimum performance parameters.
• Analyze results for a variety of mathematical and statistical algorithms
• Support business clients in teh execution of business plans.
• Ensure adherence to SHC standards
• Developing Technical Documents to create ETL jobs to load data into Data warehouse based on Business Requirements.
• Generate Ad-hoc reports and Periodic reports and Update periodic data into CDMDB (DB2) database consists of Atlas, Archive and Chief from Claims Data Warehouse for FFIC (Fireman Funds Insurance Corporation) is child Company of Allianz.
• Extracting data from Flat files into SAS system and update periodical data.
• Generating periodic reports using Base SAS and Macros fetching from DB2.
• Develop new one time Ad-hoc queries/reports and create Periodic reports using base SAS and macros.
• Create jobs to populate target data from source data by applying transformations: Append, data transfer, data validation, Extract, SQL join, splitter, summary etc
• Create and maintain teh table metadata. Developing ETL Jobs by using various Transformations to load data into CDW.

Environment: Base SAS, SAS Macros, SQL, SAS ETL, MS Excel

Confidential

Clinical SAS Programmer

Responsibilities:

• Clinical study Phase-3 for testing defined doses of teh new drug and to compare teh efficiency wif respect to Placebo. Safety and Efficacy reports were generated based on teh SAP
• Responsible for Checking teh completeness, accuracy and consistency of teh data.
• Creating SAS datasets by extracting data from Excel, Flat files into SAS system.
• Merging and summarizing data using DATA Step, Proc SQL, and Proc Format, Proc sort, Proc Freq, Proc Means, Proc Summary, Proc Univariateandgenerated statistical reports.
• Designed and developed SAS programs enhanced and converted teh macros for teh system to reduced coding time and make it easy to maintain and reusable.
• Used Proc Report, Proc Tabulate and Null to generate teh tables and Listing reports.
• Developed SAS programs, using ODS to produce HTML reports and output datasets and developed Macros to generate customized reports using PROC REPORT.
• Extracting data from MS- Excel using PROC IMPORT. Used SAS/ACCESS to extract data from Oracle and Cleaning, manipulating, Validation of data using Data step and Base SAS procedures.
• Analysis was based (Bio equivalent study Antibiotic Salmetrol-HFA) on teh observations from CRF's .Reports includes history, analysis, follow-up visit, and drug safety reports and Monitoring teh Clinical Phase
• Prepared new Datasets from raw data files and modified existing datasets using Set, Merge, Sort, and Update, Formats, Functions and conditional statements.
• Created daily, weekly, monthly and quarterly reports for teh management team
• Created tabular reports using Base SAS & SAS/Reports procedures.

Environment: SAS, (Base SAS, Macros), SAS SQL, Clinical SAS, MS Excel.