TECHNICAL SKILLS

Databases: AWS Redshift, Oracle 11g/12c, SQL Server, Teradata

Languages: SQL, SAS, Python, PL/SQL, T - SQL, C#, AWK, SED, Unix shell scripting, PERL, Java, JavaScript

BI tools: Tableau, Arc GIS, OBIEE, ExcelPower Query,Toad, SAS-EG, SQL Developer,Queryman, Business Objects, Alteryx, SSIS, SSRS, Siebel

Operating Systems: Linux, IBM z/OS, Windows

Current Interests: Full Stack technologies utilizing JavaScript, HTML5, Python, R

PROFESSIONAL EXPERIENCE

Confidential

Business analyst/ Data analyst

Responsibilities:

• Migration of data warehouse from Oracle Business Intelligence, OBIEE to AWS Redshfit.
• Data modeling and analysis of old and new data warehouse systems.
• Gathering user requirements of key stake holders including business users and IT migration team who will be performing teh ETL and data transfer.
• Creation of BRDs, Test Plans and Test Cases for migration of data from Oracle OBIEE to AWS Redshift.
• Testing of new AWS Redshift data warehouse and applications.
• Geo-mapping using Arc GIS, creation of new sections and subsections on global scale.
• Creating and testing dashboards and reports in Tableau.
• Tools used, Tableau 10.5, Arc GIS, Aginity Workbench for Redshift v4.9, Sql Developer, Siebel, Oracle.

Confidential

Data Steward

Responsibilities:

• SAS Metadata Server, SAS EG, SAS DI, SAS Visual Analytics, Teradata.
• Create parameterized stored processes for reports created in SAS Visual Analytics on teh metadata serverin a GMPmedical devicemanufacturing environment.
• Development of strategic plans for new projects and serve in an advisory capacity on database procedures and best practices.
• Assist in establishing procedures and best practices for implementation of data standards.
• Ensure compliance wif external and internal regulations and policies governing data management and data systems, including but not limited to good clinical practice (GCP), Food and Drug Administration (FDA) and organizational standard operating procedures (SOPs).
• Provide consultation and administer training for users on teh operation of Teradata applications and SAS applications such as Visual Analyzer and Enterprise Guide.
• Troubleshoot system/software problems through resolution.
• Develop data extraction programs/routines for data transfer to authorized agencies or individuals.
• Develop standard and ad hoc stored processes and reports for monitoring data integrity and for project management purposes.
• Program reports, including listings, summary tables and graphics, for assigned studies and projects.
• Creating ETL processes using SAS DI to load data into Teradata tables.Analysis of data to find outliers of manufacturing and clinical data in a c-GMP manufacturing environment.
• Provide seminars and instruction in teh use of SAS system to interns and new employees.

Confidential

Senior Data Analyst for Marketing Dept.

Responsibilities:

• Marketing analysis and reporting usingTableau, SQL,Oracle Eloqua, SQL Server, Azure, Excel pivot tables.
• Tableau:Interactivegeo-mapping, ‘what-if’ scenarios, parameterized reports in Tableau.
• Embedding interactive Tableau workbooks into web pages using JavaScript.
• Market segmentation, customer targeting/selection, implementation of process improvements, analysis of email marketing campaign outcomes for different marketing segments using Oracle Eloqua.
• Sample interactive Tableau workbook embedded using JavaScript in a web Confidential

Confidential

Seniorreportinganalyst

Responsibilities:

• Company created aweb-basedinformation system based on Quadramedbackendto be interfaced wif teh new system for use by physicians and health care workers in a hospital setting.
• Healthcare claims analysis and reconciliation of patient medical data from different facilities.
• Data miningand reportingusing Tableau and Oracle SQL.
• Research and reporting on medical claims data for New York State DSRIP project was performed to locate teh most suitable projects for HHC to participate in, including cost and utilization analysis of hospital claims data.
• Teh system had an Oracle 12c, SQL Server and Unix back end and ASP.net front end. SAS EG 7.1 and Tableau was also used extensively to analyze data. Teh Oracle database was a dimensional database designed for Oracle Explorer.
• Created stored procedures used to load web pages per requirements. Teh stored procedures were used to bring in data and images stored on a Unix system.
• dis involved teh use of SQL and regular expressions to extract medical data from electronic medical records for presentation in theweb-basedsystem. BFILES are used to load image data such as X-rays etc.
• Created stored procedures and functions using T-SQL on SQL Server 2012.
• Use of Alteryx and Tableau for data blending of patient information from different facilities andforresearch.
• Mapping external files and loading into database tables using ETL.
• Performed analysis and flow charting of processes written in Java/Unix.

Confidential, N.J

Database Programmer/DBA

Responsibilities:

• Designed and managed a Medicare Part D Broker database. dis was created as per senior management.
• Performed weekly audits per CMS requirements against teh Broker database.
• Created loading processes from an IBM mainframe into teh Broker database.
• Accompanied senior management on CMS audits to answer all questions pertaining to data management.
• Created SOP’s for teh maintenance and daily loading and auditing of teh Broker database.
• Reconciled member accounts using CMS Medicare D database based in Washington D.C. and Express Scripts FACETS database.
• Analyzed outcomes for sales campaigns for teh marketing dept.using SAS
• Designed and developed database reporting interfaces using SAS EG and ExcelPower Query/VBA in a Teradata environment to support marketing, actuarial and Medicare D enrollment and eligibility.
• Creation of base SAS and SAS macro programs.
• Implementation of Teradata based analytic solutions via Teradata SQL stored procedures.
• Interfaced wif users to determine requirements for data, reports and training.
• Designed processes tomap,extract, transform, cleanse and load data.
• Maintained, updated and tested SQL on IBM mainframe using BTEQ.
• Documented processes by creating SOP’s and flow charts.
• Designed and provided training sessions for Medco employees on Teradata and SAS.

Confidential, Brooklyn, N.Y

Sr.ReportingAnalyst

Responsibilities:

• Performed medical, financial and risk analysis reportingusingMedstat,ViPS, Business Objects, SQL Server 2008 and Microsoft reporting tools against a Facets database on SQL Server.
• Medical loss ratio reporting, benchmarking of primary care physicians, PCPs, pay per performance measures for PCPs, member utilization andcost monitoring, over billing monitoring, relative risk comparisons vs. cost of providers and detection for teh early intervention for members was performed.
• QARR/HEDIS formatted reporting to New York State SSRS was performed.
• PCP report cards and pay for performance using SSRS was performed.
• Financial Reporting including medical loss ratio and claims analysis using Excel Power Query and Excel templates.
• Managed, maintained and updated a reporting database in SQL Server2008.
• Was a member of teh Readmissions project team - dis role identified teh readmission rate among members having COPD, asthma, pneumonia, CAD, CHF. Provided demographic information to teh Readmission committee to improve aftercare and rates of readmission.
• Conducted KPI reporting, scorecard reporting, and program performance reporting for physicians in Access.
• Was a member of teh HIV project committee - identified new members having HIV including teh level of illness. Provided medical, pharmacy and demographic information on new members.
• Was a member of teh Behavioral Health committee-identified new candidates for QARR/HEDIS studies and reported to teh committee on teh status of these members.
• Performed independent research for M.D. usingMedstat.

Confidential, Manhattan, N.Y

Sr. Data Analyst/Programmer

Responsibilities:

• Performed data extraction and reporting as per user and government requirements such as QARR/HEDIS MEDS II using SAS EG wif an Oracle back end.
• Designed and implemented production and ad-hoc reports per user and government requirements using McKesson CRMS, SAS, SSRS Report Designer and Report Builder against a SQL Server back end.
• Performed analysis and reporting of claims data using SSRS for marketing/sales including changes in enrollment and renewal rates.
• Reports were created for internal and external users.
• Designed and created user interfaces such as ASP.NET web pages, Perlcgi, and SAS AF screens for user report generation.
• Scheduled data loading using SSIS from Excel, Access and delimited flat files into SQL Server warehouse.
• Performed government reporting such as MEDS II, QARR, HEDIS, ANSI X12 834 EDI, HL7 reporting.