Chetan P

Product Catalog :

One of the goal of this project is to build and establish a centralized item master. In today's scenario, Plans are spread across multiple systems and there is no common topology to connect them by a unique Item ID. This project is to integrate all the systems and build a common Item and Pricing Master.

• Designing of data model in Reltio for all product plan & pricing types
• Enable users to manually create product plan and pricing in Reltio
• Created product plan and pricing in CB using automated Integration between Reltio and Chargebee
• Master Data entities identification and structure/form definition capability
• Trained data stewards, business users as per their roles & responsibilities
• Created library of industry standard algorithms and associated API stack to curate, enrich and improve Master Data Quality
• Designed Role based access control, Business Rules engine and Change Management Workflows to effectively govern Master Data
• Necessary technical capability to propagate such governed master data back to Operational systems to maximise consistent business operations and decisions
• Canonical mapping of data semantics from various systems to Companies standardized set of values
• Life Cycle management of critical organizational reference data such as Currency conversion rates lookup tables, Organizational sales hierarchy vs customer entity mapping change management, etc...
• Whats achieved – Having consistency and uniformity in set of identifiers and their extended attributes that describe the core entities of an enterprise's business transactions

LCNC (Low Code No Code) Analysis

InOrder to incorporate the projects and its prioritize to delivery, we have evaluated multiple LCNC tools with various line items to check if it adhere towards Companies Use case and Business decisions.

• Evaluated Tool evaluation based on Factors - Security, Integration, Attributes, Workflow management, Dashboard View, File Upload & Download, Role Governance, Change management, Language applicability, User Choice, Licensing Cost, Hosting Platform, Performance
• Tools validated - Workato, Quixy, Retool, Nintex, Keboola

EDW Model

Data marts are being built by each BI- Stream independently with their own models. The ultimate goal of this project is to combine the different models being used as a single enterprise data model using a generic framework which would be used by each stream to pull the data from lake house/ different sources using a consistent metadata with proper governance to maintain the EDM with both functional metrics and org metrics.

• Enabling Metrics as a service
• Understanding the existing data models of different marts to design source & dimensional
• Creation of prototype model using Model & Metrics
• Cost and performance optimization with ease of ETL
• Centralized Enterprise Metrics Governance and Federated Data Engineering
• Implementation of Anomaly detection on data to send alerts to business users
• Creation of BOT in Freshworks Inhouse application which connects to Metrics and gives the value based on filters applied making it easier for the user to get the values at a self-serve method
• Applied RLS method using custom SQL bridge which provides access to members to limit the restrictions on metric layer
  

R&D of Enrichment Systems

To Eliminate data silos across the organization and bringing all data together using enrichment system using database of hundreds of millions of records.

• Performed R&D over multiple enrichment systems - D&B, Leadspace, ZoomInfo, Wiki Database, LinkedIn
• Multiple calls with Vendors to understand data and its usage to Organization
• Analyzed enrichment systems based on packages, locality coverages, industry segments, employee size segment, Financial Trend and Fortune Information.
• Developed Pipeline to pass relevant attributes to respective systems to get effective payload outcomes with highest relevance score
• Handled Negotiations regarding API Calls, product classification which aligned with technical limitations since it includes tool execution

TAM(Total Addressable Market)

The perception that TAM data is not accurate, sales reps spend a lot of time researching and confirming vs selling. MDM platform implies the TAM accounts enrichment data as a one-stop solution and leverages MDM features for the Marketing team's day-to-day operations.

• Lead the team to convert business requirements to Technical buckets for implementation to convert all TAM accounts into the MDM platform - Reltio
• Automated the TAM enrichment process from spreadsheets into on-demand/scheduled jobs
• Designed the TAM profile to collaborate with all process owners/participants
• Provided a scalable system to handle emerging business needs
• Enforced the data stewardship for critical data element changes - Data Quality Life Cycle
• Utilization MDM elements (RDM, RIH) to achieve the data outcome in an efficient manner
• User Roles & Privileges creation based on business sub-division to view, edit / suggest data changes to maintain data governance
• Enforcing CDM (Common Data Model) which satisfies & utilizes data values from various enrichment process
• Built Pipeline in Ticketing portal to handle the business changes in data addition & updating End to End.
• Developed SFTP to send data to Leadspace team to handle enrichment values while data entry through CRM in Real time
• Communication regarding Data Quality & Data Standardization dashboards to business users to correct / alert on the data present in Systems
• Migration of Artifacts from AWS EC2 instances to Databricks migration which handles the Compute + Storage in same environment
• Improved Presentation Quality of the project by delivering the material in more enhanced way by video tutorials & presentations.

Client & Industry : Independence Blue Cross - USA Philadelphia Health and public service

Experience summary : ETL

• Module handling
• Extracts and Sourcing – Handled and delivered various projects using various tool as per the requirement
• Worked calculating various budgets allocated by Insurance company based on Vendors and visualize the data for Year-End report and Analyzing effectiveness of broker
• Have experience in providing data for the below list of campaigns : SMS campaign, Email campaign, Direct Mail campaign
• Experienced in each stage of software development life cycle – Designing, Development, Testing and Documentation.
• Worked in waterfall as well as agile methodologies
• The nature of work includes the extensive use of the research methodologies of the Teradata utilities like Fast load, Multi load, BTEQ to solve the business challenges by applying business rules.
• Worked on process improvements in the team. Groomed new resources to work independently.
• Have taken multiple knowledge sharing sessions.
• Efficient in Scripting and scheduling the dependency in job execution process techniques.
• Leading a module - managing a 4 members team for delivering strategic projects and share point requests
• Preparing release plans and managing code deployment strategies for every release.
• Project Monitoring - User Acceptance Testing (UAT) of Financial Services Application of DOP.

Experience summary : MDM

• Built multiple jobs using DataStage job and ELT framework to feed the data into SQL server (mounted on MDM initiate server)
• Identified appropriate fuzzy, most and least matches which were used to make pairs better.
• Managed End - to - End BSA part, Design process, Loading, Production deployment by creating the .imm files & inspector properties and reporting the same to client.
• Had Multiple scenarios to handle queue counts by detaching the SQL server and adding data into Database using Snapshot to bring back the Server up without impacting Data loss
• Source addition for Member, prospects which were used for various campaigning process( including campaigning for Corona cases )
• Handled multiple instance in various projects for generation of EID's & Person Enterprise ID's
• Adding various sources into Inspector ( front end application ) to visualize the entire record set having in the MDM INIT server.

Project : IBC – Marketing Analytics

IBC is the market leader of Health insurance in the state of Pennsylvania. Accenture supports the data warehouse of IBC. We at marketing analytics, work to acquire new members and retain existing members using business data and perform analysis for campaigning accordingly.

• Extracting data from various flat files and loading it into staging tables using Data Stage, FASTLOAD / MLOAD and BTEQ scripts
• Developed Bteq script to pull data from database and generate files to send for different vendors using wrapper script
• Develop UNIX scripts to download the files from remote server, FTP/SFTP extract files to vendor server, call DataStage jobs in wrapper script and creating parameter file
• Monitor all business requirements and validate designs and schedule ETL processes and prepare documents for data flow diagrams
• Preparing release documents and run books for testing and production support team
• Fixing defects in the developed ETL / report by unit testing and worked closely with QA team during the testing phase and fixed bugs that were reported
• Various data analytics operations like Aggregation calculations, SCD implementation etc. are carried out through the implementation of business rules for the reporting purposes.
• The optimization/Performance tuning of the existing queries are performed through the proper implementation of the best practices of the Teradata.

Project : HASF Analytical pool

Create and represent the data given by the client in Tableau format

• Have attended training in Tableau, Talent, Business objects and Informatica.
• Analyze multiple documents of various for accounts based on vendor selection including sensitive data information
• Gathering Health related information like regulatory and licensing authorities and Budget information of various countries
  

Project : HEDIS

HEDIS (Healthcare Effectiveness Data and Information Set) - Employers and individuals use HEDIS to measure the quality of health plans. HEDIS measures how well health plans give service and care to their members.

• Analyze various system codes generated data and calculate the counts for a member to send a notification to the restive client.
• Build a common platform for the client as well as BSA to have a check on the requirement with different methods

Project : IStrat

Istrat sends campaign's the Nurses, members, hospitals data associated with them within the locality based upon the medical usages, rule assigned to them.