University of Illinois Urbana-Champaign

Product Owner at Heidrick & Struggles

Chicago, Illinois, United States

Heidrick & Struggles

Product Owner

- Engaged with multiple FICOH Business and Technical SMES to gather Functional and Technical requirements; as well as elaborate and finalize user stories for Release 1 and 2 initiatives

- Lead cross functional team composed of Capgemini QA members, Offshore Developers, and FICOH Business Analysts, including Operational Managers and Power Users, to enable multiple State Governed Data Extracts for FICOH TMNAS

- Managed integration of legacy data into the new GuideWire Suit based system; Datahub and Infocenter, and created new data partner feeds State Governed Statistical Reporting

- Solutioned operational and technical processes for reviewing business and the development of Test Cases using documented testing approaches approved by the Business Teams and ensuring FICOH Expectations are met to deliver excellence into Production for their new Integrations

- Performed high level Business and Code Reviews on a consistent basis for R1 and R2 State Mandated Efforts and User Based Reporting

- Provided technical guidance to the Capgemini Functional BA Team to help their data capturing requirement skill sets; as well as providing similar guidance to the Capgemini Development and Testing Teams to understand Business Pressure Points and how to Deliver those documented Client Expectations

- Accomplished in dept analysis on a daily basis using Data Lineage tools, such as the Client Data Modeling Tool - Collibra, as well as SQL Server, Erwin, Informatica and Cognos

First Insurance Company of Hawaii

Business Systems Analyst and Jr. Data Modeler - TOP3 Guidewire Implementation

- Data mine claims entered through the Guidewire portal

- Gather business functional requirements to layout a business model

- Engaged Solutions Architect directly to build physical and logical models from the attributes provided by Guidewire

- Maintained metadata to reflect up-to-date business functionality and proposed technical design

Farmers Insurance

Functional Business Analyst - Claims Business Intelligence

Capgemini

Senior Consultant

- Data profiled policies entered via Duck Creek Insurance Software by Accenture

- Analyzed source data updates to gather business requirements

- Reviewed detailed design documents to ensure business requirements were met and delivered

- Partnered with offshore resources to solution ETL products through initial build and update phase

West Bend Mutual Insurance

Business Specialist and ETL Developer – Delivery Services

- Engaged power users directly to determine use cases to build the Center of Excellence component of the business

- Analyzed Claims, Provider, Customer data sources to gather business requirements

- Solutioned Source to Target mappings based on requirements to initiate and build the respective data marts

- Built Slowly Changing dimensions for the Claims and Provider data marts

- Designed detailed regression testing suite to validate the built data marts

Blue Cross and Blue Shield of Kansas

Lead ETL Developer and Business Analyst Advanced Analytics – Data Governance

- Solutioned production defects for Employer to Employee Reporting

- Redesigned production validations procedures to accurately report on source data quality issues for Employer Group Reporting

- Successfully analyzed working COBOL manipulation scripts to create Source to Target mappings to support Employer Training for EPIC go live in 2017

- Built and delivered working data model for the Actuarial Team to confirm different revenue streamlines

- Redesigned and implemented HCG Grouper Processes with accurate logic which accounted for $21 million of unused dollar amounts

- Directed the effort to automate HCG Grouper Processes to be incorporated into GDW

- Designed and implemented Slowly Changing Dimensions with zero production defects

- Lead the enhancement project to indicate and identify Preferred Pharmacies for the delivery component of Spectrum Health

Spectrum Health

Lead ETL Designer and Jr. ERwin Data Modeler

- Joined project mid-development and performed data analysis to become familiar with subject area in a short amount of time

- Create Informatica mappings to load dimensions and facts for completely new data mart for the campaign team

- Design and develop Informatica mappings to extract data from source database, load it to staging and push data into the IDL of the EDW to meet business reporting needs

- Ensure all code was successfully implemented into production region while having zero defects in user acceptance testing

- Build detailed design documents for Informatica mappings and developed necessary code for release

- Tuned SQL queries to optimize performance

- Triaged defects with development to identify defects

U.S. Cellular

Production Support ETL Developer

- Support Enterprise Data Warehouse (EDW) Business users regarding issues dealing with multiple teams within U.S. Cellular® and their BI Reporting needs

- Estimate the level of effort analysis on defects and enhancements opened by the business users against the EDW

- Develop, validate and execute test cases for all ETL changes implemented in Production and Testing, including SIT, UAT and DIT, environments

- Analyze source data updates and the resulting impact to the EDW to make proactive Production updates

- Manage the production log to track weekly reports for executive statuses

- Manage daily standup meetings with a large production support team  to provide bi-weekly updates to business users on progress

- Lead requirements gathering meetings to ensure client needs are met

- Create test cases to ensure the functionality of the EDW and source (ODS)

- Creation of the Regression Test Suite to execute 300 plus test cases automatically on a daily basis

- Refine source to target transformation rules using source data analysis and engaging in meetings with business users and client-side subject matter expertise

- Collaborated with clients on problem solving and business rules clarification

Production Support Business and Data Analyst

- Performed System Integration Testing and User Acceptance Testing using IBM Tivoli Workload   Scheduler via two build processes.

- Oversaw the triage of defects and code failure troubleshooting.

- Maintained and updated metadata regularly to confirm the data was loaded properly.

ETL Execution Team

- Compared data between two databases to ensure the quality of the data was maintained.

- Participated in meetings to review and uphold business requirements.

- Triaged defects with source data.

Data Quality Analyst

Clarity Insights is a data and analytics consulting firm delivering enterprise-class, full life-cycle solutions including strategy and project management, BI/DW, MDM, data science, advanced analytics and information delivery. We specialize in big data, closed-loop analytics and customer intelligence, providing deeper insight and measurable results. Industry specialties include Healthcare, Communications, Media and Entertainment, Financial Services and Insurance.

With locations in Chicago, IL, Austin, TX, San Francisco, CA and Charlotte, NC, we are a fast-growing company attracting many of the top subject matter experts in the industry. Clarity’s team is comprised of alumni from industry and consulting leaders, including Big Four consulting firms and niche data boutiques, spanning two decades of data and analytics experience. As a group of truly passionate professionals, Clarity is transforming the way companies think about, organize and use their data.

Ujjawal Patel