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: Excel Power Query, Tableau, SAS-EG, SAS DI, SAS Visual Analytics, Arc GIS, OBIEE, Toad, 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 the ETL and data transfer.
• Defined data requirements, modeled and designed the new data structures, source to target mapping for AWS Redshift/Tableau based projects.
• Creation of BRDs including the identification of key data elements, data definitions and business rules.
• Creation of 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

Responsibilities:

• SAS Metadata Server, SAS EG, SAS DI, SAS Visual Analytics, Teradata.
• Creation of SAS stored processes for SAS Visual Analytics reports using SAS EG.
• Creation of automated processes using SAS EG and SAS DI to process raw data and load LASR and Teradata tables.
• Create parameterized stored processes for reports created in SAS Visual Analytics on the metadata server.
• Develop automated data extraction programs/routines for reporting.
• Creation of Excel reports using Excel Power Query.
• Program reports, including listings, summary tables and graphics, for assigned studies and projects.
• 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 Analys

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, N.J

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 reports 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 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 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.
• Was a member of the HIV project committee - identified new members having HIV including the level of illness. Provided medical, pharmacy and demographic information on new members.
• Was a member of the Behavioral Health committee-identified new candidates for QARR/HEDIS studies and reported to the committee on the status of these members.

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 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, N.Y

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, N.Y

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.
• Bergen County Community College, Paramus, NJ evening teaching Fall 2005 - Spring 2006
• Taught a core course in Base SAS with an emphasis on obtaining certification through the SAS Institute. Course was designed by myself.

Confidential, Fort Lee, N.J

Programmer analyst

Responsibilities:

• Performed design and testing of programs and processes related to EDI reporting on IBM mainframe.
• Quikjobs, SAS, SQL and Report Writer were used.
• Assisted with issue tracking, data investigation, root cause analysis and problem resolution.
• Data was analyzed and reported as specified by HIPAA using ANSI X12 834 EDI standards. Output reports were tested for government compliance usingClarediaweb-basedtesting facility.
• All data mapping and data dependencies were examined using proc freq, proc tabulate andin-housetesting programs.
• Parallel testing was performed on new programs against production programs. A validation program was written to examine the integrity of output report data.

Confidential, Trenton, NJ

Mainframe/Unix Programmer

Responsibilities:

• Writing and testing of batch and CICS programs written in COBOL and Natural was performed. Reporting using base SAS, SAS macros onUnix (Red Hat) were performed. Use of Expediter
• Intertest and SPUFI were used to test programs.Syncsort, generation of GDG and VSAM data sets was performed. Unix SAS, Proc Report., Proc Plot, Proc Chart, Proc CPORT CIMPORT.
• Creation of VSAM files, repro of flat files into VSAM files and verifying them was performed. Testing of programs againstAdabase, Unix shell scripting was performed.