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

WORK HISTORY:

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 the 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: Tableau 10.5, Arc GIS, Aginity Workbench for Redshift v4.9, Sql Developer, Siebel, Oracle.

Confidential

Data Steward

Environment: SAS Metadata Server, SAS EG, SAS DI, SAS Visual Analytics, Teradata.

Responsibilities:

• Create parameterized stored processes for reports created in SAS Visual Analytics on the 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 with 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 the 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 the use of SAS system to interns and new employees.

Confidential

Senior Data Analyst

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.

Confidential

Senior Reporting Analyst

Responsibilities:

• Company created aweb-basedinformation system based on Quadramedbackendto be interfaced with the 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 the most suitable projects for HHC to participate in, including cost and utilization analysis of hospital claims data.
• The 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. The Oracle database was a dimensional database designed for Oracle Explorer.
• Created stored procedures used to load web pages per requirements. The stored procedures were used to bring in data and images stored on a Unix system.
• This involved the 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, Franklin Lakes, NJ

Database Programmer/DBA

Responsibilities:

• Designed and managed a Medicare Part D Broker database. This was created as per senior management.
• Performed weekly audits per CMS requirements against the Broker database.
• Created loading processes from an IBM mainframe into the Broker database.
• Accompanied senior management on CMS audits to answer all questions pertaining to data management.
• Created SOP’s for the maintenance and daily loading and auditing of the 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 the 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 with 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 Confidential employees on Teradata and SAS.

Confidential, Brooklyn, NY

Sr. Reporting Analyst

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 the 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 the Readmissions project team - this role identified the readmission rate among members having COPD, asthma, pneumonia, CAD, CHF. Provided demographic information to the Readmission committee to improve aftercare and rates of readmission.
• Conducted KPI reporting, scorecard reporting, and program performance reporting for physicians in Access.

Confidential, Manhattan, NY

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 with 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.

Confidential

Programmer

Responsibilities:

• Interfaced SAS Enterprise Guide with Oracle data bases.
• Performed parallel testing on the new and legacy system.
• Validation was performed to verify the integrity of data tables and output report data of the new system.

Confidential, Manhattan, NY

Database Manager

Responsibilities:

• Managed, maintained and updated the demographics, trending and historical databases and automated reporting software used by the membership, marketing/sales and actuarial depts.
• Managed, maintained and updated the sales department database and website.
• The databases were on an IBM mainframe in DB2, VSAM, SAS and flat file format.
• Created reports for actuarial, marketing/sales and membership depts. such as rates of enrollment and renewal and sales commissions owed.
• Performed production and ad-hoc reporting using Business Objects, SAS, Excel/VBA macros to produce custom reports for users.
• Managed monthly, daily, hourly job streams on the mainframe.
• Assisted in HEDIS audits of information practices, control procedures, and data integrity.

Confidential, Manhattan, NY

Programmer analyst

Responsibilities:

• Performed medical claims analysis and reporting using SAS,CognosImpromptu, MS Office reporting tools.
• Performed HEDIS/QARR analysis using IBM mainframe and PC SAS.
• Wrote programs to NYS DOH and NCQA specifications.
• Conducted quarterly HEDIS reporting on quality measures per NCQA specifications.
• Streamlined quarterly data exchange processes with NYC Immunization Registry and Lead Registry.
• Assisted in using membership data for HIP's outreach programs.
• Reports were created usingCognosImpromptu, Crystal Reports, and SAS.