SUMMARY

Specialization in Technical Delivery Management in Business Intelligence, Data Warehousing, Dashboards, Information Management and Data Migration . Over 10 years of technical analysis, design of BI Architecture and leading BI projects. Experience in Requirement Analysis, Incident Management and Product Development using SDLC, Agile, ISO and CMMI methodologies. Project Management to track issue metrics, manage resource , vendor management, problem solving and risk escalation management. Experience in Systems Analysis AS-IS , Requirement Study, GAP analysis Functional Design Documentation Including Source to target mapping the technical specifications , Test Plan Preparation, Unit testing, System Integration testing, UAT. Analyzed, designed and developed software systems from requirement analysis, milestone definition through complete software life cycle to the delivery of the application to end users. SKILLS

TRAINING

Training in Project Management perquisite for PMI certification. Training in CMMI. Training and Certification in ITIL V3 Certified in March 2012 Training in Business Objects Administration and Security. Training in Master Data Management. Training in Advanced Data modeling. Training in Scope Management and Escalation

PROFESSIONAL EXPERIENCE

confidential

Maintain and manage Metadata from source systems to Analytics solution. grant funded by CMS . Gave the solution on the Data governance and proposed on BI solution design for new BI/IM solution from various source system. Proposed dashboard for data governance and audit process. Worked on normalization and matching solution from source system to analytic data store. Build physical and logical design model. Participated in key project design reviews as part of methodology process to follow the Enterprise information architecture. Created function for Patient attribution and storing Master Patient Index.

Environment : Oracle, Mysql , SQL Server 2010, Unix, Unix scripting, PL/SQL, Query tuning, Tableau, Crystal reports, and Power Pivots.

confidential

Role : BI/DW Solution Architect and Technical Delivery Management

Design and propose on BI solution design for new BI/IM solution from EMR, Practitioner , ACO, Population health and Quality Data. Mapped and designed the new work flow and Database design using Visio, and Mysql WorkBench. Build physical and logical design model. Build prototype of Information management and give proposal of various BI tools to use. POC on reporting solution using Tableau. Plan to migrate the exiting reporting solution in crystal reports to Tableau. Designed and developed incident management RT reporting solution. Planning and design of Patient attribution and Master Patient Index. Design and deployment of ACO reports to CMS.

Environment : Oracle 10g, Mysql, SQL Server 2008, GE EMR, Informatics, MySql WorkBench, RT Incident Management system, QlikView, Tableau, SSIS, Crystal reports, and Power Pivots.

confidential

Role: BI/IM Solution Delivery Consultant and BI Solution Strategy

Proposed various new BI solution design for long term self service BI solution. The proposed BI Solution was sourced from Oracle, Mysql to Sql Server and reporting solution through and Tableau. Designed data mart for Incident Management and Change Management metrics and reporting solution. Created BI reporting and designed data mart for trending and operational reporting solutions. Managed the maintenance and enhancement of the legacy reports in Crystal reports. Managing and consolidating the KPI and shared goals of the division. Created presentation and presented the KPI metrics results to top executives within Division. Created source to target mapping documents, and technical specifications of the reports.. Created metrics and KPI validation for ITIL standards for incident management and for continual service Improvement.

Environment : Oracle 11g, 10g, PLSQL, SQL Server 2005, Mysql, MySql WorkBench , Business Objects Crystal reports 2008, Tableau desktop, QlikView, SSIS, IPSOFT, ITIL V3, BSC designer, Agile BI.

confidential

Role: Technical Solution Team Lead in BI/IM Practice Area. Projects : confidential Role : DW Module/s lead

Team Lead for the financial reporting Data warehouse, enhance the existing processes, improve the reliability of the existing DW solution. Manage the process for Incident management and Change Management, and SLA's. Build and enhance the Source to Target Mapping and Metadata Management. Outline the the improvement of the processes and build efficiency in the existing ETL process. Management of resource task allocation and issue escalation.

Environment : Oracle, DB2 , QlikView, ETL Informatica, Unix scripting, Erwin

Managed 3 resources on shore and 10 resources offshore.

confidential

Role : BI and Data Integration Lead For the new Incentive Management System create a high-level design of an end to end integration solution from the source application to data mart solution. Designed and outlined the long term and short term BI solution for the immediate and long term needs. Created source to target mapping and reports query repository. Worked on building the audit and automation of the existing and future data load process. Proposed plan for change control and version control of the code and Design documents. Environment : Incentive management System, Oracle 10g Rel2, Informatica and Oracle PL/SQL and BOBJ Crystal Reports, Tableau desktop.

Managed 2 resource locally and 3 resource offshore delivery center. confidential Role: Part of BI/ IM Technical Solution team

Designed and developed the long term and short term BI solution for client. Designed and created data mart from multiple data source in SQL server 2005.Worked on proof of concept for Project Cost Allocation, Personnel Plan using Microsoft BI Reporting SSRS . Presented the Proof of concept to the senior client management. Created the design and plan for the Data Warehouse and data mart. Designed and created road map for short term and long term strategic solution for data mart from Project server and other project data sources. Created POC reports for Cost receiver allocation and forecast allocation . Proposed to deploy the reports and cube in the share point. Environment: Oracle, DB2, SQL Server 2005/ 2008, QlikView and MSBI SSRS and SSIS, DTS .

confidential

Role: BI Technical Delivery Lead For the MedImmune Merger and Integration project with Astra Zeneca Interacted with the client SME to get the scope of changes required in the contract management reporting solution IMANY CARS . Outlined the scope of changes required in the technical documentation for existing report and add new reports in the IMANY application. Unit tested and worked through the UAT environment setup and UAT testing process. Created deployment scripts for production deployment. Transitioned and completed the knowledge transfer to the support team. Modified and created additional attributes for the contract management. for the interface and the process management. Created steps to extract and cleanse the quantity per package items and reloaded the effected records. Created the documentation source to target mapping and Technical specifications. Environment : CARS IMANY GP, Oracle, PL/SQL, XML, Unix scripting and batch jobs.

confidential

Role: BI Technical Lead For the leading Pharmaceutical Company part of the team worked for the validation of interface and setup audit process to improve the data consistency of Clinical Trial Management System . Design and setup process to improve to improve the ETL audit process to CTMS and the Adverse Event Management System. Collaborated with Clinical management team to get the best check points to design and setup validation reports to enhance the trial process and requirement of the CTMS. Environment : Oracle 10g R2, PL/SQL embedded in Unix scripting, Oracle Discoverer , SAP LMS, Cognos Metrics, MS Visio..

confidential

Role: Part of the Reporting, migration and Interface team.

• For 500 bed Cardiac Surgery hospital in Cincinnati OH, was part of team successfully completed the transition from the Health Alliance network to standalone hospital. Moved from existing clinical management system implemented new clinical management system from EPIC Systems. Worked on data migration for the retired application to a archive location and designed and build reports to retrieve the historical data. Managed the building of the third party billing systems from the Clinical management systems. Gave the proposal for master data management for the Provider data maintenance.
• And worked on analysis of data migration from existing system to the new data source in Epic. Created and deployed critical go live reports in the new system. Tested validated and implemented the end solution for sending the electronic billing messages to external five Physician practice. Build and established relationship with key system team leads and understand the in depth knowledge of the existing systems. Establish and develop relationship with key counterparts of the Vendors - existing systems, EPIC, Data Center hoisting company.

Managed one resource locally and two resources off shore for this project

Environment : Epic Clinical Management System, HL7, Oracle, Oracle Discoverer, SQL server , Business Objects Crystal reports XI, Epic Clarity reporting, Toad for Oracle, and SQL server, Citrix hoisted environment, Bugzilla.

confidential

Role: Part of a Data Architect team For this project to participated in Application Assessment of a Loan Servicing Package under development by Shaw Systems for Toyota Financial Services. Concluded with design and road map and recommendations and a plan to incorporate the suggested improvements. Focus was on assisting in Data Architecture and Database design to improve response time of the application and reporting systems Assist in providing recommendations and plan to improve the Enterprise readiness of the new application under development. Preparation of deliverable for the Logical Database Review.- Compile and analyze cardinality statistics for data volume, data distribution and data growth tendency. And proposed new architecture to handle future growth and scalability. - Worked on proposal of Master Data Management , Oracle 10G R2 and Siperian MDM solution.

confidential

Role: Part of a BI/IM Team Worked and planned the road map for the on design and architecture to implement the reporting solution for Medical Cost and Claim process. Also worked on the strategy to implement of short term tactical reports in Medical Cost Essentials for Frequently Asked Questions as reporting solution from Data warehouse . Trained and managed two resources locally and four resources offshore in the delivery center. Managed the status reports and risk management.

Environment : Hyperion Version 9.0, Production reporting SQR , DB2, MS SQL Server,

confidential

Role : Senior Consultant to a division for Data warehouse solution : Team Lead to analyze and propose the architecture to implement new data mart solution in Oracle 10g using its new features. Proposed strategy to build audit reports for the ETL process for portfolio analysis in fund accounting. Designed and proposed strategy to develop report and optimized data extract for fund performance analytic.

Environment: DB2, Oracle 9i and 10g R1 , PL/SQL and Hyperion Brio SQR , Unix scripting

confidential

Role: Senior Consultant to a division for Data warehouse solution Database Marketing

A part of a team to analyze the building of the data mart for new credit card launching. To extract and load data to analyze the market lead for brand launch. Analyzed the process to and created the specifications for loading the data for conversion of credit card transactions for the merged credit card services from external banks . Maintain and enhanced the existing application for prospect solicitation for USA and Canada credit holders. Planning of UAT and File-aid and release management. Management and publishing of data dictionary as metadata for projects and documentation of Source to target mapping. Environment : VLDB in Oracle 9i and 10g , PL/SQL embedded in Unix Scripting, SQL Loader, , SAS data sets Unix Shell scripting KSH , 10g R1 , SQL Navigator Quest , MS Visio, Software Development Methodology

confidential

Role: Senior Consultant

Received two award in client site for best customer experience .

Environment : Oracle CRM 11.5.6 Service Contracts, PL/SQL 2.3 Oracle Financials , Oracle application 11i migration . SQL Loader, Brio SQR., SQL Navigator Quest , Oracle Discoverer, Golden Benthic Software , Mercury test director. confidential