SUMMARY

• Excellent Data Warehousing and Analytics Consultant with 9 years of experience in Banking, Healthcare, Manufacturing, Pharmaceuitcal and Financial Services Domain
• Excellent communication skills - dealt with financial, pricing and marketing analysts, accountants, bio-statisticians and statisticians and senior level management; Presented several documents to such audience
• Strong command of Software Development Life Cycle (SDLC) and Data Warehousing concepts; Conducted requirements gathering, building specifications, coding, testing and implementation
• Conducted statistical analysis, financial calculations and reporting; Developed Value at Risk using Monte-Carlo methods
• Strong programming experience in BASE SAS 9.2, SAS EBI 9.2 and DI Studio 4.2. Proficient in Enterprise Miner 6.2, Futrix, JMP 7 programming
• Built Excel models to support Academic Research in Accounting & Finance. Used SPSS to analyze data
• Dealt with submitting jobs remotely using FTP, parallel jobs using SAS MPConnect, rsubmit in SAS scripts and qsub in Unix scripts SAS v9.1. Used Unisys Autosys to schedule jobs and Shell scripts
• Good understanding of various documents such as Protocol, CRF, DMP, SAP and SOP in clinical trials; Solid understanding of drug development process - conducting clinical trials, collection (paper CRF, eCRF (EDC, RDC)), analyses and presentation of data.
• Familiar with FDA regulations, Good Clinical Practice (GCP), International Conference of Harmonization (ICH), ICD-9 codes, Pharmacopeia and other terminologies.
• Wrote edit checks codes using ClinPlus, and performed stat review for data integrity and to proof read the inconsistency in data

TECHNICAL SKILLS

SAS: Base SAS 9.0/9.1.3/9.2/9.3, SAS/SQL, SAS/ODS, SAS/Macros, SAS/ACCESS, SAS/CONNECT, SAS/STAT, SAS/GRAPH, SAS MPConnect and SAS ODBC.

EBI(9.1): SAS Web Report Studio 3.1, SAS Olap Cube Studio 9.1, SAS Information Map Studio 3.1, SAS Enterprise Guide 4.1, SAS Information Delivery Portal, SAS Olap Viewer for Java, SAS Data Integration Studio 4.2

OS: Windows Xp/NT 2000/9x/2003, Sun Solaris 5.9, HP Unix, WAS (IBM Websphere Application Server) and IBM AIX

DB: Teradata 14.1, Oracle 8i/9i/10g, DB2 7.1, MS Access 2000, MS SQL Server 2003 and Sybase.

Tools: Visual SourceSafe, Rational Clearcase, Clearquest, Quest Toad 9.6.1 for Oracle, Rapid SQL, Hummingbird, FTP, PGP, SQL Loader, MS Visio and MS-Office 2003.

Languages: HTML5, SQL, PL/SQL, VBA, C, C++, Python, R, SPSS

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

SAS/Tableau Consultant

Responsibilities:

• Develop dashboards, KPIs, graphics using Tableau and SAS VA 3.1 for HMI’s media clients
• Write custom sql code to calculate metrics like conversion rate, click-through rate, spend pacing, cost per click/engagement and other metrics
• Debug data issues as per business team’s guidance
• Designed stories, dashboards, worksheets in tableau and their interaction for client presentation
• Used templates and custom colors and layouts to enhance the look and feel of the tableau workbooks
• Resolve data discrepancies between automated dashboards and existing MS Excel dashboards
• Automate approved reports in both Tableau 9.1 and SAS VA 3.1
• Administer security settings using SAS MC 9.4 and Tableau server
• Managed metadata registration of sas tables and sas libraries

Environment: MS SQLServer 2014, Tableau 9.1, SAS Visual Analytics 3.1, SAS EG 5.1, SAS Management Console 9.4, SAS Base 9.2

Confidential, New York, NY

Senior SAS Consultant

Responsibilities:

• Develop sas programs, shell scripts as per business requirements for compliance programs
• Implemented a unix/sas/sql based alert generation model for lookback transactions as part of JPMC audit program
• Documented the existing SAS server architecture and file layout for sas remediation plan
• Maintain existing legacy infrastructure like Fortent, Sonar and HALO and ensure smooth transition to newer AML (anti money laundering) tools like MANTAS and Actimize
• Build sql scripts and database objects for audit purposes
• Answer adhoc queries and requests for information on retail, commercial and business transactions
• Interviewed and mentored junior staff on taking responsibilities within the IT infrastructure
• Responded to business’ ad-hoc queries regarding JPMC customers, transactions, alerts and data
• Planned for transition from existing tools/infrastructure like crontab to future state tools like control-m

Environment: Databases: Teradata 14.0, DB2 7.1, Oracle 11i SQL Tools: Toad for db2, Toad for oracle, Teradata SQL Assistant

Confidential, Perrysville, OH

Senior SAS EBI/DI Consultant

Responsibilities:

• Developing SAS stored procedures for reporting Manufacturing Plant Metrics using WRS/IDP
• Assisting administrator with troubleshooting SAS EBI and DI Studio configuration issues
• Taking part in designing ACTs (Access Control Templates) for setting up SAS security policies
• Configuring security, metadata setup, SAS WRS and IDP pages for different teams like Quality & Reliability, Manufacturing Engineering and Design Engineering within Confidential
• Creating stored procedures to run dashboards, indicators, ranges and gages
• Used SAS ABM to create a robust cost accounting model
• Designed the costing paths from source to destination accounts and mapped them to the measures and hierarchies
• Managed assignments between resources, cost centers and activities using SAS ABM 7.1
• Building Information Maps to source data from data warehouse and migrate it to ODS (Operational Delivery Store)
• Providing administrative support for SAS MC and web based tools
• Helping in building statistical models for calculating the temperature of ovens in the manufacturing plant
• Translating JMP scripts to sas code and performing user defined reporting capabilities

Environment: JMP 10, SAS DI Studio 4.2, SAS EG 5.1 SAS IMAP Studio 4.31, SAS Locale Setup Manager 3.1, SAS MC 9.3, SAS Model Manager 12.1, SAS OLAP Cube Studio 4.3, SAS Personal Login Manager 9.3, SAS Workflow Studio 1.2 Utilities, SAS Manage 64 bit, SAS Installation Qualification Tool 9.3, SAS Integration Technologies ConfigurationSAS Web Report Studio 4.3, SAS Information Delivery Portal 4.3, SAS BI Dashboard 4.31, Stored Process Web Application SAS Enterprise Miner 12, SAS Activity Based Management 7.1, SAS Model Manager, MS SQL Server 2012

Confidential, Baltimore, MD

SAS EBI/DI Consultant

Responsibilities:

• Ran attribution programs for different states to identify the provider of choice for Confidential members
• Developed and tested sql scripts on Teradata Data Warehouse implementations as a part of the move from regional warehouses to enterprise warehouse
• Provided enhancements to the existing reporting process which saw savings in processing speed of up to 30%
• Answered business questions on the PCMH (Patient Centered Medical Home), PC2, ACO (Accountable Care Organization) reporting procedures
• Built the NCQA/HEDIS quality scorecards for some of Confidential programs
• Working on CMS’ innovative CPCI (Comprehensive Primary Care Initiative) to build programs to track member usage and payments

Environment: SAS/Base v9.2., SAS/SQL, SAS/Macros, Unix, Teradata Enterprise Data Warehouse (EDWARD), Telnet, MS Visio, IPSwitch, SAS Web Report Studio 4.2, SAS Information Map Studio 4.2

Confidential, Baltimore, MD

SAS EBI/DI Consultant

Responsibilities:

• Developed SQL queries for answering business questions on Medicare and Medicaid programs
• Built and validated Information Map using complex joins on 45 tables related to Part D insurance plans
• Maintained SAS database in a SDLC environment (Dev, Validation and Production)
• Created SAS process flows in DI Studio to extract data from the database into sas datasets
• Documented source-to- Confidential transformations as per business requirements
• Maintained the metadata definitions for required tables, datasets and code using Import/Export Metadata wizards
• Used source designer wizards and Confidential table wizards to create the transformations
• Ran code in both PC SAS 9.2 and SAS EG 4.3 and validated the results
• Assisted in validating WAS (IBM Websphere Application Server) hot fixes by running reports in WRS and IDP
• Created Stored Processes to run real-time reports based on Teradata Tables
• Worked on projects like DSH (Disproportionate Share of Hospitals), PADS (Phase 1 Analytical Data Store), Medicare FFS Ratebook for bidding processes on Fee-For-Service Plans and Part D plans.
• Validated ACO (Affordable Care Organizations) data structures being built for the new legislation
• Ran SAS code inside JCL scripts on mainframe

Environment: SAS/Base v9.2., SAS/SQL, SAS/Macros, DB2, Oracle 11i, IBM Websphere, Teradata 13, Windows NT 2000, MS Visio, SAS/ODS, MS Office 2003, SAS Web Report Studio 4.2, SAS Information Map Studio 4.2, SAS OLAP Cube Studio 4.2, SAS Data Integration Studio 4.2, SAS EG 4.2, Teradata SQL Assistant, SAS Enterprise Miner 6.1, SAS Mainframe 9.1.3

Confidential, Golden Valley, MN

SAS EBI/DI Consultant

Responsibilities:

• Served as the Web Administrator for SAS WRS 3.1 and SAS IDP 3.4
• Maintained SAS inventory in a SDLC environment (Dev, Test, Preproduction and Production)
• Liaised with SAS Institute resources to resolve environment and coding issues
• Listed the appropriate user lists for availing access to the IMaps within WRS 3.1
• Coordinated with SAS Admin team to resolve issues on IBM Websphere like plugins (WAS) - timeouts for long running reports
• Reduced time in migrating code in SDLC environment by showing the efficient processes
• Interacted with SAS BI admin team to maintain metadata profiles for maintaining jobs
• Built OLAP Cubes from reporting schema tables using both detailed tables and summarized tables using Cube Designer and PROC OLAP
• Registered the tables not already existing in metadata using Source Designer
• Developed heirarchies and dimensions for drill down based on requirements
• Used drill-through capability for some of the cubes
• Created bookmarks for highly scrutinized aggregations
• Created and updated information maps in SAS Information Map Studio 3.1 belonging to each subject area (Health Assessments, Incentives, Online Health Coaches)
• Tested Information Maps in IMS 3.1 before surfacing them in SAS Web Report Studio 3.1
• Built Imaps accessing both oracle tables and OLAP Cubes' heirarchies and measures
• Created filters on Imaps that can be surfaced in WRS
• Displayed report information through bar-graphs and pie-charts in SAS WRS 3.1 for users and modified the properties of the bar-graphs and pie-charts
• Included company logo to show on the report in WRS 3.1 by using the banner option in the Header Section (from a list of admin controlled images)
• Created user-driven prompts to filter the data shown in the Web Reports (eg. Client for which the report has to be generated)
• Created custom measures that would be calculate based on run time based on fields selected (eg percentage)
• Customized the sas - javascript code to build cascading prompt functionality in SAS 9.1.3
• Developed and tested 15 stored process reports generating detailed and summarized information
• Created or updated existing stored process reports using EG
• Created several PROC SQL scripts to run on the databases using PC SAS 9.2
• Converted PC SAS 9.2 code into stored processes using EG
• Created several Proof-of-Concepts using MS - Add In to generate stored process output
• Built DI jobs to clean and standardize clinical data and update it in the relevant schemas and tables
• Updated aggregate tables, dimensional tables and fact tables in the reporting schema
• Used Data Exchange Specification documents to create new or update existing etl jobs
• Imported user-written code to generate DI transformations
• Created transformations between source and Confidential tables
• Ran proc format code to edit the data values into the required format
• Extracted data from text files containing delimited data
• Scheduled jobs using DI studio and LSF by creating workflows in LSF
• Used ER diagrams to ensure the referential integrity between primary keys and secondary keys
• Performed routine data checks for data loaded into staging area and reporting area
• Troubleshot errors related with ETL jobs with assistance from offshore team

Environment: SAS/Base v9.1.3/9.2, SAS/SQL, SAS/Macros, DB2, Sun Solaris 5.9, Oracle 10g, Windows NT 2000, MS Visio, SAS/ODS, MS Office 2003, SAS Web Report Studio 3.1, SAS Information Map Studio 3.1, SAS OLAP Cube Studio 9.1, SAS Data Integration Studio 3.4, SAS EG 4.1, Toad for Oracle 9.6.1, Aqua Data Studio, IBM Websphere, SAS Mainframe 9.1.3

Confidential, Minneapolis, MN

SAS Consultant

Responsibilities:

• Extract data from various sources like csv files, access databases, excel spreadsheets into SAS in proper formats
• Mapped several marketing datasets to the campaign-channel
• Held several meetings with business users to extract data from FOCUS datamart
• Built data requests using metadata and data dictionaries

Environment: SAS EG 4.1, SAS/Base v9.1.3, SAS/OR, SAS/ODS, SAS Enterprise Miner 6.1, SAS Decision Trees

Confidential, Minneapolis, MN

SAS BI/DI Consultant

Responsibilities:

• Used Prospective and Retrospective data from CMS to calculate the contributions from Ovations Medicare & Retirement Group
• Used PCP and Network data from COSMOS, UHG's corporate database to calculate the payments and membership for Medicare Retirees
• Built OLAP cubes to breakdown the payments by company,group id and member for UHG actuaries
• Analyzed existing reporting process for Medicare Finance group; Automated the entire process in SAS to generate deliverables (vouchers and journal entries); Saved processing time of 10 business days; Created Pivot to analyze current bids and formulate 2010 year end bid process
• Held user meetings with accountants to research data issues and apply rules based on research
• Used ARM logs to record the high usage patterns of OLAP cube queries
• Compared three different data sources for a monthly membership of 1.8 million members for a feasibility study
• Included data mappings from PeopleSoft 8 to PeopleSoft 9 to enable smooth migration of code
• Built hash joins to reduce time taken by SQL joins
• Developed processes in SAS ABM to build the journal entries, A/P, G/L entries and other accounting procedures
• Assisted in DI Studio design meetings to build the SAS data mart
• Built OLAP cubes, Information Maps and Web Reports for Ancillary Cap, Additional Compensation projects; Applied drill down, drill through and cascading filters

Environment: SAS/Base v9.1.3., SAS ABM 6.2, SAS/SQL, SAS/Macros, DB2, Oracle 10g, Windows NT 2000, MS Visio, SAS/ODS, MS Office 2003, SAS Web Report Studio 3.1, SAS Information Map Studio 3.1, SAS OLAP Cube Studio 9.1, SAS Data Integration Studio 3.4, SAS EG 4.1, Toad for Oracle 9.6.1

Confidential, Princeton, NJ

SAS Programmer

Responsibilities:

• Modeled the financial impact of marketing programs, promotional offers and sales strategy. Analyzed the downside risk of losing customer base using the trends
• Analyzed existing reporting processes to identify bottlenecks and improve efficiency. Built stored procedures and VB macros to automate reports. Registered processes with SAS Metadata Server
• Administered the corporate security model using SAS Management Console
• Designed User Interface using SAS Information Delivery Portal. Displayed summary statistics reports
• Held user meetings with statisticians to conduct design of experiments
• Defined defects, sample size for marketing tests on Direct Mail outside and internal lists; Created sas datasets to be used in JMP
• Interacted regularly with the financial and marketing analysts for data analysis and presentation of reports
• Discussed with marketing analysts to run correlation tests and regression models on customer data
• Ran Pearson correlation tests to identify similar marketing segments In JMP. Helped segmentation efforts to group individual customers into different segments
• Wrote, tested and implemented SQL queries on DB2 and Oracle databases
• Used SAS Enterprise Miner 6.1 to build nodes for decision modeling and decision trees to model marketing strategy
• Built the SEMMA approach with co-workers for Direct Mail Response model
• Collaborated with vendors to resolve data discrepancies for monthly reports

Environment: SAS/Base v9.1.3., SAS/Graph, SAS/SQL, SAS/Macros, DB2, Oracle 10g, Windows NT 2000, MS Visio, SAS/ODS, Brio, MS Office 2003, Crystal Reports, SAS Web Report Studio 3.1, SAS Information Map Studio 3.1, SAS OLAP Cube Studio 9.1, SAS Data Integration Studio 3,4, SAS EG 4.1, SAS EMiner 6.1

Confidential, Harrisburg, PA

SAS Consultant

Responsibilities:

• Led an offshore team located in India to analyze the code and give feedback; Supported an inventory of 300+ SAS programs
• Built quantitative approach to analyze the economic impact of Price Erosion and generated Price Variance charts for a McKinsey team
• Ran data extraction, model development, validation and presentation for senior management
• Developed pricing workflows for different business units
• Used different report templates like crosstab,list, bar graphs, pie charts to show financial data; Used Crystal Reports to develop reports
• Modified production environment codes by checking in and out and tested the production moves; Used Microsoft Visual SourceSafe to track errors and modifications done to the code
• Created views and indexes on SAS datasets to enhance the speed and performance of the SAS programs; Built parm files in VB Script and controlled these parm files in the VB scripts itself
• Interfaced with the testing team to improve the code performance and reduce the errors
• Recommended tuning SAS/Proc SQL code to improve the performance by using THREADS option
• Executed data exchange between SAP and SAS systems; Used Mercator MQ Series for exchange

Environment: Windows NT, SAS 9.1, Oracle 9i, SQL Developer, SAS Access, SAS Connect, Microsoft Visual Source Safe, DB2, SAP Systems, Mercator MQ Series, Crystal Reports, ControlM, Hummingbird, Toad, DB2

Confidential, East Hanover, NJ

SAS Consultant

Responsibilities:

• Developed SAS reports for NDA submission as per company’s standards and FDA regulations
• Generated data sets from the raw data sets after a thorough review of the Protocol, DMP, CRF and SOP
• Formatted RTF, HTML and PDF reports using SAS output delivery system (ODS)
• Extensively used existing complex Macros, modified existing Macros and developed Macros to be used in SAS programming for data cleaning, analysis and for report generation
• Imported raw data from Excel, Access formats into SAS datasets using Dynamic Data Exchange (DDE) feature of SAS
• Executed Quality Control macros on sample datasets to gauge the quality standards of vendor data
• Performed edit checks on the data in ClinPlus to check for and to generate the queries
• Prepared subject audit sheets to verify with CRF
• Generated graphs using Proc GLPOT, GLMP/ANOVA
• Performing statistics analysis illustrated in diagrams, reports, charts, graphics using SAS/STAT Procedures: UNIVARIATE, GLM, ANOVA, REG, CORR, TTEST

Environment: Windows NT 2000, SAS 9.1, SAS/Stat, SAS/Graph, ClinPlus.

Confidential, Binghamton, NY

Research Assistant

Responsibilities:

• Supported faculty’s research in Accounting & Finance; Built complex excel models to refine and validate data. Used SPSS and simple statistical procedures to analyze the data
• Examined the compliance of more than 500 mutual fund and publicly listed company ownership details
• Conducted due diligence on the Sarbanes-Oxley compliance on more than 1200 publicly listed companies’ Audit Committee Information
• Research published by School faculty in top Accounting and Finance Journals
• Extracted data from SEC filings using tools like Lexis-Nexis and Factiva