SUMMARY:

• In - depth experience of database structures, theories, principles and practices pertaining to OLTP & OLAP. Solid experience on data extraction for analysis from Oracle, MS SQL Server, MS Access and Vertica (50 million records per day) using SQL. Knowledge of on premise MS SQL Server Database migration to Microsoft Azure SQL and AWS RDS.
• Worked on Stored Procedure, Functions, Views, Joins, Unions, Triggers & performance tuning.
• Skilled in BI reporting tools i.e. IBM Cognos Studios, SQL Server Reporting Services (SSRS) via Visual Studio BIDS/SSDT, SAP Crystal Reports & SAP BOBI (Webi & Explorer). Knowledge of Tableau & Power BI Desktop.
• Experience in migrating of MS Access table data to Oracle & MS SQL Server with the front end still being in MS Access.
• Working experience on validation, cleanup, and formatting of data - Data Scrubbing/Wrangling/Cleansing.
• ETL/ELT - SQL Server Integration Services (SSIS) via Visual Studio BIDS/SSDT & Oracle SQL Loader.
• Experience in Data Modeling/Data Architect pertaining to BI. Building Data Marts - Star Schema & Snow Flake Schema. Maintained data models in Erwin.
• Meta Data experience on Cognos Framework Manager & SAP Universe UDT/IDT. Knowledge of SSAS.
• Strong experience with KPI, Business Score Cards and Performance Management.
• Excellent Experience of Microsoft Excel plus VBA (i.e. Macros) pertaining to MS Office products (MS Access, MS Word, MS Power Point) and VBA for automation reporting - Dashboards. Pivot Table & Power Pivot (Data Model).
• Data Analysis via Pareto/Comparison/Trend/Ranking/Variances/Frequency/Correlation Analysis. Descriptive and Inferential/Predictive Statistics using Excel. Plus, knowledge of R (R Studio) inrelation to Vectors, Materices, Data Frames, Subsets, Functions and Visualizations via GGPlot2, MatPlot & QPlot.
• Knowledge of building build data models via Excel self-service BI Tools (Power View, Power Query, and Power Map).
• Experience of ERP Systems i.e. People Soft and ADP in relation to reporting.
• Exposed to Siemens Financial Data & McKesson’s (HCI) Clinical Data. Pulled data from Lawson..

TECHNICAL SKILLS:

Databases: MS Access, MS SQL Server, Oracle 8 to 12c, Vertica, MS Azure SQL & AWS RDS.

BI Reporting Tools: SAP Crystal Report, SAP Webi, SAP Design Studio, SQL Server Reporting Services (SSRS) via Visual Studio BIDS/SSDT or Report Builder, Microsoft SQL Server Mobile Report Publisher, ADP ReportSmith 3.10, PeopleSoft Query Manager 8.49, IBM Cognos Report Studio 8.4/10.1, IBM Cognos Query Studio 8.4/10.1, IBM Analysis Studio 8.4, IBM Cognos Business Insight 10.1, IBM Cognos Advance Business Insight 10.1 and IBM Cognos Connections 8.4/10.1.

Data Analysis Tools: SAS 9.1 and MS Excel Pivot tables & Power Pivot. Plus Descriptive and Inferential/Predictive Statistics (Distribution, Probability. Correlation, Linear Regression, Standard Deviation, Mean, Mode, Median, Kurtosis, Skewness and Count etc.) using Excel Analysis ToolPak, Toad for Oracle Data Analysis.

ETL Tools: SQL Server Integration Services (SSIS) via Visual Studio BIDS/SSDT, Oracle SQL Loader & Microsoft SQL Server Migration Assistant for Access.

Visualization Tools: Tableau, Power BI Desktop, SAP Explorer & Power View.

Modeling Tools: Erwin 8 & MySQL Workbench

Multidimensional/Cube Tools: Cognos Transformer, SSAS & Oracle EPM System Essbase.

Meta Data Tools: Cognos Framework Manager & SAP BO UDT/IDT.

Programming/Scripting Languages: VBA/Macros, ANSI 92 SQL, R (R Studio) & UNIX Shell Scripting.

Software Applications: SharePoint, Putty, SSH Secure, Cigwin, Telnet, Exceed X Windows, Tight VNC, WinMerge, Lotus Notes 6.5, Outlook, Vi editor, Citrix Program Neighborhood 6.0, MS Project, Visio, Word Perfect Office (WordPerfect, Quattro and Presentations), OnDemand, Monarch, PowerBuilder, Toad, OpenOffice (Writer, Calc, Impress and Base), Microsoft Office (MS Word, MS Excel, MS Access, MS PowerPoint, MS Outlook, MS Project and MS Visio) & TextPad/NotePad ++.

Platforms: UNIX Sun OS 5.10, Windows XP Home/Vista/7/8.1/10.1, Windows workstations XP Pro/7 Pro/8.1Pro, Windows servers 4.0 to 2012, DOS 6.0 and Windows Terminal Server Editions for Thin Clients (WYSE terminals).

Enterprise Resource Planning Systems (HR Modules): People Soft 9.0 & ADP 3.10 in relation to reporting.

Cloud Computing Applications: Google Drive (Google Docs) & Office 365.

Cloud Services: AWS & Microsoft Azure.

PROFESSIONAL EXPERIENCE:

Confidential

SQL Developer/Data Analyst/Report Writer/DBA

Responsibilities:

• Maintained, modified and developed SQL script (i.e. materialized views, with clauses, regular expressions and PL/SQL) in Oracle via Toad 12.0 for reports such as Term Conversions Current Monthly Daily, UL to UL Conversions, Daily Automation, fmis trm conv mv, Recurring Premiums etc.
• Build and maintained reports (i.e. CCR Sales, Life Products, Trm Conv Curr MTD Daily etc) using crystal reports 2008. Plus published them.
• Worked on migrating MS Access data tables to MS SQL Server to meet company’s new Enterprise Database Management System security initiative. This entailed migrating data from MS Access to MS SQL Server then re-linking it back to their respective MS Access objects. Plus resolved data type conversion issues and used Pass-Through queries in Ms Access to delete and recreate tables in MS SQL server to match the existing functionality that exited in Ms Access databases prior to migration. Took on the role of sysadmin in MS SQL Server at unit (local), model (development) & production environments for creation of databases and their objects. Detached & attached databases to different server environments. Plus, creation of logins (Windows Authentication or SQL Server Authentication), users and assigning permissions. Also, created and scheduled backup plans and ODBC file dsn connections. Based on BRD & FRD developed via JAD Session/Scribe.
• Worked on MS Excel pivot table reports (i.e. YTD, Life Insurance Sales, Monthly Paid Cases etc) that pulled data from Oracle using ODBC and MS Excel Connection Properties - Command Type SQL and inputting SQL in it. Also took existing mock pivot table reports in Excel that were later transformed into summarized Crystal Reports.
• Migrated MS Access data tables to Oracle 11g via Toad and then linking them back to Ms Access Objects. Resolved MS Access data types conversions issues to Oracle i.e. Auto Number, Yes/No and default dates by adding default values to tables at creation time, adding constraints, sequences, triggers and changing data types. Tested on exporting tables to MS Excel then creating csv files and using Oracle SQL Loader to import data into Oracle.
• Developed Archive Medical Claims database (5 million Records) for the sole purpose to access EOBs (Eligibility of Benefits) on policy holders for auditing and regulatory purposes. To achieve this, two things had to be done, one move large amount of data received from TPA (Third Party Administrator) on their Association in MS Excel format to MS SQL Server 2014 using SSIS and massage it to requirements. Secondly create an MS Access database with the necessary queries, forms and macros that will consume the tables created in MS SQL Server 2014 through linking. Added print functionality to forms. Developed the BRD & FRD via JAD Secession/Facilitator.
• Performed Cube finalization & archiving using Oracle Essbase Administration Services tool version 11 on a quarterly basis. Verified the finalization of the cube via Oracle Essbase Sheet Add-In for Excel version 11. Also involved in the of this process.
• Provided support to users on MS Excel, Crystal Reports, MS Access, Toad, SQL scripts & on all the MS Access databases data tables that were migrated to Oracle (11g) and MS SQL Server (2012/2014) as back ends and involved in knowledge transfer .

Confidential

Data Reporting Analyst

Responsibilities:

• Build DSRIP (Delivery System Reform Incentive Payment) KPI’s/Measures. Tools used Toad for Oracle, Oracle SQL Developer, SQL Server Management Studio, SSIS (Control Flow i.e. - Sources/Destinations OLE DB/.csv/.txt/.xls, Execute SQL Task, File System Task, Script Task & Containers - Sequence/For Loop/Foreach Loop. Data Flow Components i.e. - Conditional Split, Data Conversion, Derived Column, Lookup, Merge, Merge Join, Multicast, Sort, Union All & Fuzzy Lookup), SSRS & MS Excel. All done in accordance to BRD, FRD developed via JAD Sessions/Scribe.
• Build & Maintained SAP Universes and SAP Explorer Dashboards to track submitted transactions to Siemens that were rejected. Provided information via dashboard to appropriate departments about the errors and avoiding revenue losses. To accomplish the above, tables were created in MS SQL Server 2012 Database using DDL statements. Then populated via SSIS packages that received data from Siemens. Automated the process and in case of failure, user was informed via email. Plus, used MS Excel to validate data in case of SSIS process failure. Then build the Universe in SAP IDT and finally developed reports in SAP Explorer. Based on BRD & FRD.
• Updated code in SAP Webi & SAP Crystal to accommodate for the new ICD10 code changes. Validated the update SQL code in Toad for Oracle which accessed McKesson Clinical Data.
• Build Webi reports for clients on Webi desktop rich client and published to repository. Plus provided support to power user who accessed their reports on BI Launch Pad via Lan Desk.
• Modified & Maintained existing McKesson HCI Audit Universes (Active & Archive) - application level audits by adding derived tables to show patient charting level audits. Then build Webi reports for audit department and provided support on them.
• Participated in the update of SAP BOBI 4.0 production servers to SAP BOBI 4.1. Exposed to SAP CMC i.e. folder access, report access, report scheduling and group access.
• Involved in the development of executive dashboard using SAP Design Studio.

Confidential

Sr, Analyst Financial Reporting/Analysis

Responsibilities:

• Maintained and prepared premium revenue reports for different programs i.e. Medicaid Non Aliessa & Aliessa TANF (Temporary Assistance for Needy Families ) Children, TANF Adult, SSI Combined, Family Health Plus(FHP), Newborn, Maternity and Low Birth Weight based on and rate schedule provided by the state. These reports pulled data from databases & Warehouses using SQL code & Excel generated Insert statements into temp tables for joining data from different external sources. Then sliced and diced in Excel via pivots for the final result.
• Preformed Analysis on the Quality Incentive Bonus program provided by the state. Analysis was on the Impact of the chances of not satisfying all the requirements for the program i.e.to show the impact on revenue for Medicaid products provided by company (TANF Child, TANF Adult, SSI & FHP) due to the chances of a drop in quality incentive bonus from 1.5% to varying percentages. Based on rates and /enrollment.
• Analysis done on DME (Durable Medical Equipment Med Supplies) & PT/OT (Outpatient Rehabilitation Therapies: Physical Therapy, Occupational Therapy, Speech Therapy) by showing Total Claims, Utilization & Unit Cost for all programs (Medicaid, Child health Plus, Family Health Plus, Medicare and Qualified Health Plans in the New York State of Health Marketplace) by provider. Plus ranking the providers. These reports pulled data from MS SQL Server using SQL code and then were populated in Excel for further messaging before final outcome.
• Automation of revenue reports that pull data from various databases and data warehouses by using MS SQL Server, SQL Code (Temp\Global temp tables), MS Access, MS Excel and VBA.
• Out Patient - Reporting via MS Excel Power Pivot Data Model - Build sample dashboards that.i.e. drill data by year, quarter, month, date, program and category of service giving the ability to visualize data from different perspective for top executives review for implementing MS Excel Power BI as a dashboard reporting tool for company’s BI needs. Cleansed data via MS Excel Power Query. Additional functionality was added to the dashboards by using VBA. Developed the BRD & FRD via JAD Secession/Facilitator.
• Also provide support on Ad Hoc reporting request using SSRS i.e. CHP (Child Health Plus) analysis & impact of rate changes by state on premiums of different programs. Plus retro impact if changes in rates effect previous year especially if based on draft rates.
• BRS (Billing Reconciliation System) - New Born Project - Validating the data generated by BRS with existing Newborn, Maternity and Low Birth Weight revenue reports data. With help of SQL code & Excel.
• Took part in the development of state requirements of DFS QHP report. This also had encryption using SQL.

Confidential

Business Intelligence Analyst/Developer

Responsibilities:

• Build KPI’s/Measures (Healthcare regulatory metrics .i.e. ACO, MU, MU2 & PQRS) using a top down approach to database modeling.
• Developed OLTP, OLAP Data Warehouse/ Data Mart with Star Schema and Snow Flake Schema in conjunction with agile methodology.
• The Data mart then would be used by company’s propriety tool PMF to build the Multidimensional Data Warehouse/Cube. For personal testing used SSAS & SSRS to visualize data mart data as cube and view its output.
• Presented the cube data generated via company proprietary tool PMF as percentages then added targets to these actual metrics in order for a company to evaluate its performance.
• Maintained the models using Erwin.
• Worked on the necessary SQL (DDL) scripts to create the relational database, Data Warehouse/ Data Mart with Star Schema and Snow Flake Schema in MS SQL Server 2008R2. Plus the SQL (insert statements) scripts to populate the Dimensions using the help of VBA to automate the process.
• Documentation of the entire process of creating the data dictionary, models, databases and scripts using MS Excel & MS Word.
• Exposed to Web Focus Developer Studio, Report Painter, Info Assist and Focus language.
• Testing to add ADHOC reporting capability to PMF tool (application) via other Web Focus applications.

Confidential

IT Telecom Analyst

Responsibilities:

• Developed KPIs i.e. Calls & Impairments, Post Dial Delay, IVR, ALOC, Valid Calls Aborted or Completed, Percent of Valid false, Misdialed In Relation To Type 1 & Type 2 Errors and Cause Code Finger Print Completed & Aborted. The data for the KPIs was based in Vertica and massaged in Toad data Analysis tool using SQL. Plus used MS Excel Pivot Table to further slice and dice imported data in various KPIs.
• Wrote SQL code bucketed large amount of data (i.e.50 million transactions per day) from Vertica to be presented in MS Excel as histograms. Plus used logarithms to size buckets so that it showed details in areas around zero and coarser granularity at larger numbers.
• Due to the large amount of data had to write SQL that would take absolute data and normalize it. So when presented in a histogram would give a better picture of the data.
• Developed SQL Code for in-house Score Card Application i.e. Correct Calls Not Completed, Misdialed & Aborted Calls and Completed Calls.
• Built Cross Correlation charts in MS Excel via Line & Scatter charts. The Line chart depicted the norm and the Scatter chart depicted the deviant values from the norm.

Confidential

Product Control Enginee r

Responsibilities:

• Built a Database Schema on the existing Enterprise Contract Management Application System WinTrak, which then would be used to help in building a data warehouse in SQL Server 2005/2008 and then help in building a Relational Model and Package in IBM Framework manager. Finally evolving it into a DMR Model based on Star Schema. This Schema was based on my coordination and efforts between CMD, TSD and Engineering Departments. Played the role of a Facilitator (JAD Session) to develop the schema’s BRD & FRD.
• Verified existing packages via mapping of package data items to original source fields, validated data at the package level, validated cardinality at the model level and validated data at the ETL (SSIS) by checking data in Data warehouses in SQL Server 2005/2008 using structured query language, SSRS (i.e. tabular/matrix/list reports, built in expressions, sub reports, drill down\drill through reports, cascading parameters, nested groups & indicators), Report Studio, Framework Manager, MS Excel (VBA ADO Stored Procedures), Access and the original data source.
• Installed and configured IBM Cognos Framework manager. Plus validated existing models in relation to their logic i.e. star Schema or relational.
• Exposed to IBM Cognos Business Insight 10.1, IBM Cognos Advance Business Insight 10.1, IBM Cognos Report Studio 10.1 Active Reports, IBM Cognos Analysis Studio 8.4 and IBM Cognos Event Studio 8.4.
• Upgraded existing reconciliation report packages and debugged all the errors associated with that. i.e. re-mapping of data items based on data dictionary, filter logic errors due to different output and missing query subjects. Plus added functionality to them via prompts and UI’s.
• Upgraded existing Report Studio 8.4 reports to Report Studio 10.1 i.e. Multi Page Prompt Reports, Nested Cross Tab Reports, Dynamic Charts, Drill Down and Drill Through reports via XML.
• Developed prototype dashboard reports that consisted of Multi Line Graph Reports with Prompts, Dynamic Cross Tab with Chart Reports, List with Chart Reports and Drill Through reports (Cross Tab, Chart and List) using Report Studio and Cognos Connection (Pages in Connection, adding Portlets and Portal Tabs).
• Debugged reports that were developed using Query, Union, Join, Intersect and Except Objects in Report Studio. Plus added more functionality to existing reports by using SQL Object.
• Exposed to creating cubes in IBM Cognos Transformer 8.4 (Dimensions & Measures) from existing DMR models/packages from IBM Cognos Framework Manager 8.4. Then using these cubes in IBM Cognos 8.4 Analysis Studio.

Confidential

Reporting Analyst Data Analyst/BI

Responsibilities:

• Build and updated reports in PeopleSoft Query Manager 8.49. Some of these reports had Expressions, Date Prompts, Sorting, additional Criteria's, Grouped Criteria's, Sub Queries, Joins and Having Clauses.
• Maintained and build reports in SAP Crystal Reports 11. Reports that used i.e. Formula Fields, Parameter Fields, Selection Expert, Group Expert, Section Expert and Sub Queries etc. Plus build on existing reports by doing a few modifications i.e. on Fields, Selections in Formula Editor and adding and linking tables via Database Expert. Coded reports using SQL with the Add Command option after connecting to databases. Also remapped tables and fields in reports.
• Updated and developed reports in Cognos Reports Studio 8.4 that utilized features like Cascading Prompts, Drill Through, Master Detail Relationships, Singletons, Filters, and Query Calculations etc.
• Developed reports in Cognos Query Studio 8.4 and trained clients on how to use Query Studio for their ad hoc reporting needs.
• Responsible to providing over all support on Cognos reporting studios.
• Maintained code in MS Access databases i.e.New-Lawsonre.mdb, Report Builder.mdb, PTO.mdb, Payroll Recon.mdb and New Requisition.mdb. Plus, on a daily basis ran procedures developed using VBA (DAO and DoCmd Object) and SQLthat updated local tables in MS Access via table links to Oracle Streams and Sql Server databases. Then did a compact and repair on them.
• Automated reports - Wrote code in VBA andSQL that imported data from PeopleSoft, Lawson, ADP and user files. Then did the required massaging of data files. Formatted them for MS Excel, using the MS Excel Application Object in MS Access and then send final output to MS Excel. Or depending on the complexity of the report wrote VBA code in MS Excel to directly import data into MS Excel do the massage and formatting
• Maintained reports in ADP ReportSmith 3.10. Plus developed new reports based on existing reports by editing their Selections, Derived Fields and Table Fields.
• Responsible for maintaining and running schedule reports on daily, weekly, biweekly and monthly basis.
• Provided database mapping of all schedule reports fields in ADP and Lawson for the conversion of reports to PeopleSoft.
• For the preparation of PeopleSoft testing did Lawson Data dumps via Access as a point of .
• Provided support in the validation, cleanup, quality and formatting of data during the conversion of Lawson data to PeopleSoft - Using MS Excel (Vlookup, Hlookup, Choose, Match, Index, Array, Exact, Upper, Lower, Upper, Mid) and MS Access (Unmatched Query and Union Query).

Confidential

Application/SW Development/Support

Responsibilities:

• Developed, maintained and upgraded an automation application in MS Excel, VBA/Modules and Macros for the purpose of providing information on the usage of AT&T products by each customer in each segment. Also created all the necessary FTP scripts & DOS batch scripts to move data from Unix to Windows for the automation application to process and send back to Unix.
• Maintained on daily, weekly and monthly bases the back-end scripts, which populated the data on RICS (Record Information Control System - Product Forecasting) web site and its corresponding Oracle database tables. Its purpose was to forecast inbound and outbound minutes usage and check variance based on actual. Also documented and presented the whole process.
• Developed and maintained an automation application that gave visual representation of relevant data for each customer in each segment - Dashboard. The front-end was developed using MS Excel, Charts, Macros and VBA. The back-end consists of scripts written in Shell scripts and Oracle SQL statements.
• Blended and modified images in PhotoShop 7.0 for our website.
• Maintained time series reports in MS Excel based on Pivot tables such as CircuitSummary.xls, BandwidthPacketAttribution.xls and ComparisionBandwidth.xls. Also responsible for running the SAS scripts that provided data for the above Excel reports.

Confidential

System Analyst

Responsibilities:

• Troubleshoot MS Excel - VBA Reconciliation application to correct built-in business logic.
• Convert MS Excel - VBA business logic to ASP and VB Script.
• Wrote code in ASP, VB Script, CSS and HTML to transfer the content of Active Server pages to MS Excel, which users had the option to save on their machine or print.
• Worked on CSS classes to manipulate MS Excel output from Active Server Pages.
• Wrote VBA code for printing in a particular format and layout.
• Researched and prototyped various solutions required by project manager, as per clients varying requirements.

Confidential

Business Support Specialist

Responsibilities:

• Extracted data from SAP data warehouses.
• Developed reports in MS Access and MS Excel.
• Used SQL and MS Access for manipulation of data from data warehouses.
• Used MS Excel tools like MS Query (Unions and Joins) and Pivot tables to show different views of data from data warehouses.
• Developed VBA Modules that took raw data from SAP in different formats (.csv, .dat, .xls or .txt) and processed it using MS Access, SQL and MS Excel. To produce the final product - Mission Critical Logistics Reports.
• Wrote VBA code to facilitate data identification through automated processes.

Confidential

Technical Support Specialist/Help Desk Support

Responsibilities:

• My responsibilities included setting up new employees in relation to their IT needs, such as desktop/laptop, software, mainframe, printer, voice mail and phone.
• Developed and maintained an Employee Setup Application for all department managers and HR, which was accessible through a network drive. The application user interface (UI) was developed in Data Access Pages, VB Script, HTML and VBA. The back-end was an Access database.
• Upgraded and modified MS Access 97/2000 databases i.e. Machine Inventory, Lan Inventory, Paper Inventory, Toner Tracking, Picking Label and Daily Turnover to MS SQL Server 2000 via MS Access ADP (Access Queries upsized to Views or Stored Procedures and Access validation rules upsized to Triggers - Insert/Update/Delete) or to MS Access 2000/2002/2003. Plus developed their front-ends using ASP, VB Script, HTML, MS Access Forms (DAO or ADO) and VBA
• Designed and maintained an intranet site for the purpose of verifying temporary data entry employees performance. This site was developed using MS Excel, Macros (automation), MS SQL Server, VB Script, ASP and HTML.
• Developed an intranet site with Excel and FrontPage. The sole purpose of this site was to help IT department setup new employees and be able to track the progression of the new employee setup process.
• Created modules in Monarch to convert text files into MS Access tables, MS SQL Server tables or Excel worksheets. Depending on report layout using macros instead to convert text files into Excel worksheets, Access or MS SQL Server tables - automation.
• Ran & maintained DTS/SSIS - Local Packages in MS SQL Server 7.0/2000/2005 to update retail database. Plus updated TPR changes in mainframe.
• Trained technicians on HTML and basic relational database concepts with the help of MS Access.

Confidential

Programmer

Responsibilities:

• Took an existing unfriendly Visual Basic 5.0 application that executed on command line and transferred images from Novell Server to NT 4.0 Server. The user had no knowledge about the progression or completion of the process. Upgraded application to Visual Basic 6.0 and developed a user friendly interface (UI) that executed in Windows environment and informed the user about the progression and completion of the process of transferring images from one server to the other. Also informed the user of existing and new path of transferred images.
• Given the task of maintaining ROD (Registrar Of Deeds) and UCC (Uniform Commercial Code) applications in Visual C++ 5.0 (MFC) and MS SQL Server 6.5. Also to upgrade these applications to Visual C++ 6.0 and MS SQL Server 7.0.
• Extracted information for reports from an Oracle database using SQL, Toad and PowerBuilder for the accounting department.
• Responsible for transferring images form ROD (Registrar Of Deeds) which was on a Novell Server to NT 4.0 Server, which in turn every night transferred images to the ROD website. Had to verify that images existed at all three levels. Plus once images were transferred burn them to a CD and verify the copying process.