SUMMARY

• Ability to lead and innovate wif strong interpersonal skills
• Worked in many cross - functional teams
• Interacted wif all levels of management, business stake holders, architects, and developers
• Finance and Healthcare experience in Kaiser Permanente, World Bank Group and Confidential

TECHNICAL SKILLS

• Data modeling tools ERWIN
• VISIO
• Toad Data Modeler
• Databases Oracle / SQL Server
• ERP tools SAP NetWeaver 7.4 (Business Warehouse)
• Cube Design
• ABAP / ABAP Objects
• ETL tools Informatica 9.x/8.x
• SSIS (Integration Services/ BIDS)
• Backup Recovery Model query & reporting tools PL/SQL
• Business objects
• Universe Designer and WEB Intelligence Reporting Services (SSRS)
• BEX Analyzer (BW Cube)
• SQL Server Analysis Service (SSAS) olap tools MS SQL Server Analysis Services (SSAS)
• Business Intelligence Development Studio
• Applix/TM1/ OLAP Server
• BW on HANA

PROFESSIONAL EXPERIENCE

Confidential

Data Architect/IT Business Analyst

Responsibilities:

• Architecture, Business Data Mapping, building solutions Interacting teh Business Clients at various levels, Data Analysis, Data Integration, Data Conversion Conceptual, Logical and Physical Data models using Involved in integration between Medicaid, Claims Data Warehouse, Patient Encounter Data, Pharmacy, Ambulatory and Dental, New born Kick payment, Claims Monitoring and Health Financial Monitoring reports for Regulatory bodies like Medicaid Office, Department of Health and Mental Hygiene, MD and VA Guiding and tracking teh efforts of teh development team, Testing and validating of teh finished product wifin teh Project guidelines and timeline.
• Detail oriented wif a strong grasp on teh big picture for teh Management Team On-going support for Reporting wif Business Objects, Universe Designer and Web Intelligence Reporting.
• Using latest technology for automating Industry standard like 835/837 into teh data warehouse and building optimum Business Object Universe Design Model and Webi reports Strong grasp of Informatica Data Quality and Meta data manager, Power Center tools. Oracle 11g/12c Performance Tuning, Shell scripting in Unix / Windows environment

Confidential, DC

Consultant

Responsibilities:

• Involved in Architecture and design of Enterprise Planning system based on SAP/BW/BPC on HANA, EPM Worked on Data Analysis for BPC on various Planning modules, Data Integration, Data Conversion, CDM, Conceptual, Logical and Physical Data models using ERWIN.
• Integration problems between costing in SAP and benefits calculation in HR, expense and revenue planning area. Staff Affordability, Capital Expenditure, Expense and Revenue Planning, Work Program and Task Planning, Budget Construction, Project Initiative) Lead Data Architecture and ETL Architecture (Informatica) Integrated Planning System/PSAP and QBR (Quarterly Business Review) for Fixed/Variable Cost planning, Expenditure, was built on JAVA / Flex and Oracle 11g / SQL Server, Used agile methodology, JIRA for Change management. On-going support for Reporting wif Business Objects, Universe Designer and Web Intelligence Reporting.
• Lead teh team meetings wif third party Vendor development team to align their development efforts wif Business and Enterprise Architecture Teams’ Direction.
• Provided a comprehensive dashboard for planning tool for teh Unit Manager and GP Practice Managers Part of teh team responsible for implementing QBRR (Quarterly business Review Reports) for senior managers and VPs. Provided expertise in Project Management / Estimating teh level of effort for various modules, worked wif contractors and provided wif insight into bank processes, assisted in enforcing design standards and product development was according to teh specification

Confidential, DC

Data Architect & Lead ETL

Responsibilities:

• Integrating data from SAP/R3/Net weaver 7 and BW for Planning and Expense Monitoring Design of Master Data Hub for creating Golden copy of master data of commonly used entities using Informatica Developed highly efficient way to load high volume data (~120 Million rows, around ~20 M rows daily) using partitioning.
• Designed data model for SOA Architecture, Web Service, Self Service Reporting model Developed WEBI reports, Designed and optimized SAP Business Objects Universe.
• Assisted teh team lead in many weekly meeting sessions wif teh clients.
• Database Installation, User Access Control, Installation, Performance Tuning, Disaster Recovery and Backup monitoring of SQL server Databases and Sybase databases. Assisted Oracle DBA as standby or backup DBA
• Lead many meetings wif business community that often-included Senior Managers, CAO’s, and Business Analysts and Development team.
• Designed teh Architecture layout for Application Data Model / Reporting Model and System (used by over 200+ users) worldwide.
• Designed and assisted teh BO Developers wif implementing teh design. Designed highly efficient high performance Database Structures, wif full-fledged referential integrity.
• Lead all teh data modeling / data Architecture, related issues, bringing teh business and Technical teams together.

Confidential

Development Database Administrator

Responsibilities:

• Designing and maintaining SQL server Database, writing Stored Procedures/ Triggers for teh business Logic for teh Educata Portal and teh objects and data residing in teh SQL Server Database Developed Routines to ping teh SQL Server and do a http ping to teh Website and process teh output to monitor teh site every 5 minutes

Confidential

Database Administrator & Systems Programmer

Responsibilities:

• Performed Database Administration on ISM SQL Server, Installation and Maintenance of SQL Server, Backup and Recovery, Data Modeling using Systems Engineer, Developing / Debugging of PowerBuilder Programs
• Developed standardized naming convention for Databases / Triggers / Stored procedure etc. and developed PowerBuilder Applications for Regional Office accounting System and Porting of Data between ROAFI application and Activity Management System.