SUMMARY

• Certified Professional with 8+ years of experience as Data Analyst
• 8+ Years’ experience within benefits and clinical domain
• Primary contributor to Pricing, Annual enrollment and premium set up modules of health & welfare benefits
• 8+ Years of experience in developing& supporting client/server applications using SQL Server, Oracle, and Sybase
• Generated reports using PROC REPORT,DATA NULL and PROC TABULATE for customized report writing
• Experience in SAS to import and export to another file formats, including delimited files, MS Access table, PDF
• Working knowledge on SAS Macros for generic coding and reusable modules
• Experience in producing HTML, CSV, RTF and ODF formatted files using SAS/ODS
• Generated daily, weekly and monthly reports using PROC REPORT and SQL
• Good working knowledge on clinical trials projects (Phase I, II, III, IV) with Bio - Statisticians, Data Managers and Statistical programmersto create and analyze the clinical data and generate datasets, reports, tables, listings and graph according to SOPs and departmental guidelines
• Working knowledge of CDISC standards(SDTM, ADAM, Define.xml), ICH, GCP&Drug Development Process
• Sound knowledge of statistical procedures like PROC ANCOVA, PROC CORR, PROC GLM, PROC GENMOD, PROC MIXED, PROC MEANS and PROC UNIVARIATE
• Strong experience in creating Ad Hoc, parameterized, Linked, Snapshots, Drilldown and Drill through reports
• Generated reports usingReporting Services, Report Model and ad-hoc reporting usingReport Builder
• Experienced in Dimensional Modeling, designing of STAR, SNOW FLAKE Schemas
• Extensively worked on ETL mappings, analysis and documentation of relational and OLAP reports requirements
• Experienced SQL developer in data handling (SQL/T-SQL, Stored Procedures, Triggers, Views, Cursors, Indexes and Tables), maintaining Data Integrity, and strong in Query Optimization
• Strong working knowledge of fact tables, cubes, dimensions, and measures metrics usingSSAS
• Specialist by AMCAT (Aspiring minds computer adaptive test)
• Articulate documentation -Test Plan, Strategy, Cases, Requirement Traceability Matrix, and defect Summary Report
• Strong knowledge in SDLC & STLC. Played roles in projects lead by Agile, Scrum, RAD, V - Model and Water-Fall
• Knowledge of OLAP database development including KPIs, Data mining, working withslowly changing dimensions
• Well-acquainted with Production Support Environment with a proven ability to work in a fast-paced environment
• Good analytical skills and fast in learning and adapting new technology and business knowledge

TECHNICAL SKILLS

Business Intelligence Tools: MS BIDS, SQL Server Management Studio, SQL Server Analysis Services (SSAS), SAS, Integration Services (SSIS), Reporting Services (SSRS), Power Pivot, Share Point, SQL Profiler, Report Builder, Tableau, DW Manager, TFS, VSS

SAS 9.2: Base, Procs, Macros, Access, Graph, Report, Connect, Transpose, ODS, STAT, Contents, Import, Export, Tabulate, Plot, Means

Databases: SQL Server 05/08/2012, Sybase, DB2, Oracle, MS Access, Mainframes

Languages: PL/SQL, T-SQL, Basic VB.Net and C#, Core JAVA, HTML, XML, Java Script

Operating System: Windows 9X/XP/7/NT/Server 2000, VM Ware, Unix \ Linux

Testing Tools: ECHO, Maestro, HP Quality Center (ALM), Mercury QC, Bugzilla, JIRA, SQL Utility Tool, Conversation (Configuration Management Tool), Workbench, ATCI

Office Applications & Tools: MS Office Suite,Edit plus, SSMS, BIDS, VMWARE, Eclipse, Compare, Visual Studio

Test Strategies and Stages: Functional Testing, Integration testing, Web testing, Database Testing, GUI Testing, AD HOC Testing, Regression Testing, User Acceptance Testing, Reporting and tracking defects

PROFESSIONAL EXPERIENCE

Confidential

SAS/ Statistical Programmer

Responsibilities:

• Worked on Cardiovascular therapeutic area
• Analyzed the Clinical data for Phase III and Phase IV
• Extracted views to datasets for different end-points using system level extraction process
• Extensively used Dynamic Data Exchange for importing data in Excel sheets into SAS
• Assisted in data cleaning and validation.Tested and debugged macros
• Produced customized report as per the instructions from the PoC
• Programmed datasets using mapping specifications, define specifications from CRF data & managed SDTM database for several protocols
• Created concise and unambiguous technical documents like code specifications, program documentation, TLG annotations
• Assisted in the design of Statistical plans and Case Report Forms (CRF) for clinical studies
• Worked in different clinical trials SDTM domain like Demographics (DM), Adverse Event (AE), Serious Adverse Event (SAE), Concomitant (CM), Exposure (EX), Findings (EG, LB, IE, PE, QS, SC, VS, DA)
• Used SAS for processing data, SQL queries, data analysis, generating reports, & statistical analyses
• Good Knowledge in developing Define.xml and validation using Open CDISC validator
• Performed data analysis, statistical analysis, generated reports, tables, listings and graphs using SAS tools- SAS/Base, SAS/Macros,SAS/Graph andSAS/SQL
• Performed relevant statistical analysis on the data collected during Clinical Trials
• Ensured analysis data and programming code meet regulatory and company standards (PROTOCOL) and are consistently structured to permit efficient programming, reporting and review
• Created SAS programs for generating data listings for data review meetings
• Documented macro functionality and macro parameters defined for future reference
• Developed routine SAS macros to create tables, graphs and listings for inclusion in Clinical study reports and regulatory submissions
• Used Output Delivery System(ODS) facility to write custom safety and efficacy reports directing SAS output to RTF, PDF and HTML files
• Conducted and generated the Regressions, Correlation studies and Analysis of Variance using PROC REG, PROC CORR, PROC GLM, PROC ANOVA
• Extensively worked on SASBASE, STAT, MACROS, ODS, PROC REPORT, PROC TABULATE, PROC GCHART, PROC GPLOT, PROC SQL and various SAS PROC
• Good understanding of standards specific to clinical trials, such as CDISC, SDTM, MedDRA
• Processed data collection and maintained the daily error log for cleaning the data

Confidential

SAS Programmer

Responsibilities:

• Imported SAS datasets from SASManagement Console to SASInformation Map Studio
• Involved in writing code using Base SAS, SAS/Macros to extract, clean and validate data from tables
• Worked with various SAS products SAS/BASE, SAS/STAT, SAS/GRAPH, and SAS MACROS
• Produced listings, summary, tables using different SAS/reporting tools like Proc Report, Proc tabulation and data null as per the requirement
• Extracted customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT, and PROC MEANS for creating preferred list of customers as per given requirements from business analysts
• UsedSAS/Base and SAS/Macro facility to develop efficient SAS code
• Developed parameterized reports, linked reports, matrix and tabular reports using Report Builder
• Experience in configuring and deployingSSRSreports onto Microsoft Office SharePoint Server
• Created reports in SSRS with properties likechartcontrols, filters, Interactive Sort, SQL parameters
• Developed SAS programs ad-hoc reports and edit checks using SAS BASE, STATand GRAPH
• Modified existing datasets usingSASSet, Merge, Sort, Update and Conditional statement
• Inspected reports for data inconsistencies and fixed bugs in SAS report
• Created user friendly macros and replaced the codes with macros to reduce code redundancy
• Performed QC, data validation and edit checks using various SAS procedures & macro facility
• Producedad hoc reportsin SAS using .txt files upon request for in-depth analysis
• Generated Graphs, listings, PDF and RTF files using various Base SAS Procedures
• Format the data using PROC FORMAT, PROC APPEND and MERGE statement
• Regular interaction with analysts to perform in-depth quantitative data analysis with the use of Base SASandSAS/Macros for ad hoc jobs
• Created SAS datasets from Microsoft Excel files using Proc Import and Import Wizard
• Created mapping specifications for raw and analysis datasets
• Reviewed protocols, case report forms, statistical analysis plans
• Performed QC, Data validation and edit checks using various procedures & macro facility

Confidential

Sr. Setup Configuration Specialist

Responsibilities:

• Configuredvarious interfaces of Hewitt proprietary tool, TBA (Total Benefits Administration)
• Created Metadata repository for health plans and various key metrics
• Accessing data from oracle database and SAS database
• Created new SDTM and analysis datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update, and conditional statements.
• Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/ Base and SAS/ Macro facility
• Transferred and Migrated Data from one platform to another to be used for further analysis.
• Created health plan comparison charts and uploaded those knowledge documents into Lotus notes
• Designed complex and custom reports using SSRS with drilldown features, sub reports, charts
• Involved in client status reporting and worked closely with business analyst and metadata expert
• Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP
• Implemented approved change control in master setupdev, QA and staging database
• Performed component testing for plan and pricing changes using GUI, Web and Personal statements
• Executed Provisions migration jobs from Dev to QA, and performed integration testing
• Generatedconfiguration controlfiles for external clients as per internal compliance report
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems
• Created SSISmappingdocument and developed dataflow workflows using advancedSQL queries
• Analyzed and tuned SQL objectsusing SQL Profiler, Query Analyzer, Database Tuning Advisor
• Supported team in resolving Report related issues and created various reports such as Cross-Tab, Conditional,Drill-down,Top N, Summary, OLAP and Sub reports
• Inspected reports for data inconsistencies and fixed bugs in SSRS report
• Involved in Writing SQL Queries, Views and Stored Procedures on SQL Server 2008
• Prepared tableau workbook files for analysis of plan enrollments by organization cost unit
• Reviewed &Tested packages, fixed bugs using Business Intelligence Development Studio
• Generated monthly and quarterly reports as bar charts for the management
• Performed and involved with team on Black Box, Integration and Regression testing
• Tested existing SSAS Cubes, Facts and Dimension tables
• Functional and Non Functional testing, Web testing, and Compatibility testing and bug reporting
• Validated ETL Process for data cleansing,and SSRS reports for business checks, Data Quality, format validations, data profiling, loss of data, and inaccurate data
• Validated data elements mapping/transformation logic, referential integrityamong tables

Confidential

Setup Configuration Specialist

Responsibilities:

• WorkedasConfiguration controller (CC) and involved in defect prevention activities
• Developed ETL transformation using Joiner, Aggregator, Lookup, Sort, Derived Column, Pivot, Character Map, Copy Column, Audit, Script Component, Script Task, Expression tasks
• Transformed data from MS SQL Server 2005 to MS SQL Server 2008 using OLE DB connection by creating various SSIS packages
• Extracted required data from various flat files and relational databases using SQL
• Developed data manipulation scripts to fix data issues
• Used analytical and ranking functionssuch asRow number, Rank, Dense Rank and NTile
• Implemented error handling techniques such as Try and catch, @@error in SQL objects
• Developedstored procedures to apply business logic and do calculations on raw data
• Created test cases and executed configuration updates for pricing and premium modules
• Played role of work assignment to the team in absence of Project Lead
• Performed Integration testing coveringcore functional aspects of the system

Confidential

Setup Configuration Specialist

Responsibilities:

• Performed various activities in analysis, design and development of database
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, and Views
• Created complex SQL code using Inner, Outer join and update queries
• Createdtable constraints and triggers to apply business rules
• Prepared summarized reports to provide dashboard level information
• Gave presentations on Database management system