SUMMARY:

• Over 9 years of experience in providing Strategic solutions for Business Intelligence, Analytics and Data Warehousing
• Over 5 years of experience in Healthcare Domain
• Experience working on Federal Project - Confidential (Interim Security Clearance - Public Trust)
• Significant expertise in building strong strategic client relationships, managing project expectations, resolving issues and driving value
• Hands on experience prototyping new technology integration and business solutions for Business Intelligence and Analytics
• Experience in evaluation of Data Governance, Metadata Management and Master Data Management (MDM) tools
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to generating reports to business users
• Experience with analyzing data using Toad, SQL Developer and excel along with BI Tools
• Knowledge of SAS, python and R languages
• Exposure to cloud and Big data solutions
• Experience in taking IT Product ownership for OBIEE, OBIA, Noetix integration and Golden Gate and taking lead on multiple projects at the same time
• Experienced in requirements definition, gap analysis, functional analysis and design, system configuration, process design, quality assurance testing, change management, training development & delivery, and post production support
• Expert in managing production support, working with IT teams, SMEs to resolve issues, liaison with business users
• Ability to adapt quickly to challenging and changing environments and comfortable with communications at all levels of management

SKILLS AND KNOWLEDGE:

Analytics, BI and Integration Tools: Tableau, Power BI, QlikView, OBIEE 11g, Toad, MS Visio, Essbase, Golden Gate, Informatica, ODI, Noetix, SSIS, Sql Server, MS Parallel Data Warehouse (PDW), MS Excel, R, Python, SAS, Azure Cloud

Data Skills: Data Analysis, Data Mining, Data Profiling, Dimensional Modeling, Data Warehousing, Business Intelligence Reporting, Data Governance, Meta-Data Management

Domains and Functional Areas: Healthcare Fundamentals, Claims, Providers, claim frauds, OBIA modules including Financials Analytics, Procurement and Spend Analytics, HR Analytics, Supply Chain Analytics, Projects Agile and Waterfall Methodologies, Scrum, Product Ownership, SDLC

EXPERIENCE:

Senior Consultant

Confidential

Responsibilities:

• Establish a professional, working and consultative relationship with the client, including the C-level for mid-to-large accounts by developing a core understanding of the unique business needs of the client within their industry
• Use specialty expertise to seek out new opportunities for customer value by expanding and enhancing existing opportunities to build the pipeline in and drive pursuit in specialty area
• Maintain and use overall cross-portfolio knowledge to support account leads with integration of solutions
• Coordinate the creation of RFP responses for delivery in collaboration with the sales team and the Proposal Desks as necessary

Confidential, Louisville, KY

Responsibilities:

• Developing strategic roadmaps and project plans for Long-term and Short-term solutions for the Data Warehousing, Data Governance and Analytics Projects
• Provided Data Mining solution using SQL for fraudulent claims to be used for Predictive Modelling
• Worked on Provider Data integrity and Data Quality during transition of new contract
• Evaluated technologies for self-service BI and Data Visualization. Designed POCs using various tools including Power BI, Tableau, QlikView
• Evaluated technologies for Data Governance, Data Quality and Master Data Management. Worked directly with vendors for POCs and Presentation for the top-level executives
• Designed and enhanced data integration process for Optum ETG product by 25%. Worked on innovative solution to automate the data integration process for Optum reports
• Providing analysis and solution for Quality Control Auditing metrics for senior management using QlikView
• Rolling out BI solutions to end users including QlikView and Tableau
• Implementation of Tableau for enterprise users and performing admin tasks and migration of reporting platform from QlikView to Tableau
• Implementation of Collibra in Microsoft Azure cloud environment

Business Consulting Principal Consultant

Confidential

Responsibilities:

• Assessment of current reporting system and processes of clients mostly in the financial area
• Developing strategic roadmaps and project plans and other functional activities including resource planning
• Drafting and design reporting and data warehousing solutions
• Implementation of OBIA (financial Analytics) and custom OBIEE reporting solutions
• Modelling of RPD, design complex reports and BIACM configurations
• Migration of OBIA objects including ODI, BIACM, reports
• Architected automation of data flow process to ingest and extract data saving huge manual effort
• Designed GDPR reporting data flow process for MNC client
• Leading UAT sessions with the business
• Extensive data validation, data reconciliation in coordination with SMEs for data integrity

Applications Consultant

Confidential

Responsibilities:

• IT Product ownership for OBIEE, OBIA, Noetix integration, Essbase integration and Golden Gate and taking lead on multiple projects at the same time.
• Researching new technologies and available technologies to improve business processes.
• Designing custom Data Models and implementation of Datawarehouse Solution for HR and T-Recs reporting.
• Lead Upgrade of OBIA 7.9.6.4 and implementation of OBIA 11.1.1.8.1 (Financials, Procurement and Spend, HR and Projects modules) with ODI.
• Provided reporting solution for AP internal metrics trend reports using QlikView
• End to End implementation of Near Real Time reporting custom DataMart for financial close using Golden Gate for extraction and transformation of data for populating Data Mart and using OBIEE as frontend tool for reporting.
• Scoping out the server architecture of Golden Gate and OBIEE and integration with multiple systems
• Scoping out the road map for Golden Gate and OBIEE/OBIA and providing guidance on utilization of OBIEE and Golden Gate in future.
• Provide insights on using OBIEE for replacement of Access, Excel and other places where data is extracted and stored; and leverage data mining to OBIEE for analysis and reconciliation.
• Developed strategies, designed DataMart and implementation Near Real Time reporting using Golden Gate.
• Developing Proof of Concepts (POCs) for new technology integration and business solutions for OBIEE, QlikView, Tableau, and Noetix.
• Responsible for installing, configuring, developing, support and maintenance of the OBIA, OBIEE, ODI, Informatica, DAC and Golden Gate.
• Extensive data validation, data reconciliation in coordination with SMEs for data integrity.
• Exposure to Essbase/Hyperion Planning (cube building, security setup using shared services, MDX scripting)
• End users and Admin users training

BI Developer

Confidential

Responsibilities:

• End to End design development from concept to deployment.
• Designed Data Warehouse Bus Architecture using Kimball's approach to Dimensional Modeling.
• Performed high level data analysis at Database level using complex SQL queries.
• Created Data Profiles to verify the consistency of data across all tables in Data Warehouse.
• Develop Tables, Stored Procedures, Views, Joins and Subqueries to enforce the business rules.
• Created Indexes (Clustered and Non-clustered) to reduce data retrieval time.
• Fine tuned SQL queries to improve query performance and to reduce runtime.
• Updated the Dimension and Fact tables through SSIS Packages.
• Used incremental loading, slowly changing dimensions (mainly SCD2), late arriving dimensions concepts to load the Dimensions and Fact Tables.

OBIEE Consultant

Confidential

Responsibilities:

• Involved in full SDLC and knowledge of Manufacturing Life Cycle
• Regulated offshore team coordination for timely deliverables
• Gathering and documenting Business Process Requirements from End users
• Involved in providing project timeline estimate
• Prepared high level design documents (mockup of reports in excel) and presented to end users to get approval
• Involved in Scrum Process (Agile Methodology) for quick approvals, timely deliverables
• Designed and developed the OBIEE Metadata Repository(RPD) using OBIEE Admin tool
• Identified granularity level of the data required to be available for analysis
• Worked extensively on OBIEE Answers to create the Product Quality reports and Intelligence Dashboards as per the detailed design requirements
• Extensively used page prompts and dashboard prompts for filtering data values in reports
• Utilized drill down, drill through and slice & dice methods on reports to gather more information on Product Details
• Developed high level ad-hoc reports for grain level analysis
• Used customized HTML Script for enhancement of Dashboards and Reports
• Performed Unit testing and SQA testing in all environments
• Performed high level data analysis at Database level using complex SQL queries