esponsibilities:
• Interact with onsite leads to understand the requirement and deliver low level design document, discuss 
the requirement with offshore team and post any questions to onsite team
• Interpret and understand functional specifications, write technical design documents adhering to 
predefined standards
• Design and develop ETL to deliver the functionality detailed in the technical specifications using 
Informatica PowerCenter 7.1, PL/SQL and shell scripts
• Develop PL/SQL code and shell scripts to load various types of data into EDW environment, invoke 
Informatica ETLs and PL/SQL codes using shell scripts
• Fine tune existing/new ETLs to ensure the code adhering to acceptable application performance
• Conduct peer review and provide constructive feedback, prepare detailed unit test cases, execute unit 
test cases and document the results
• Diagnose and resolve defects found in QA and UAT test phases and support regression testing
• Prepare migration check list and object inventory and share with onsite counterpart

Analyze project requirements from high level design document and prepare low design document, conduct low level design document review meeting with team members and 
accommodate review changes
 Prepare source to target mapping specification according to busines 
requirements; develop Extract, Transform and Load (ETL) jobs using Informatica PowerCenter 7.1 and 
load data from desperate sources into staging area followed by data warehouse with appropriate load 
order using job scheduler  Fine tune performance of informatica PowerCenter jobs in mapping, session
 and workflow level,design and develop ETL jobs based on various slowly 
 changing dimension (SCD) requirements
 Generate testing scenarios and test cases; perform data and business rule 
 validation, prepare deployment component list and share with onsite team

• Interact with application owners to understand upstream and downstream data sources and prepare a 
plan for data masking deployment
• Build customized RegEx in Delphix DMSuite to identify firm defined Personally Identifiable 
Information(PII) within databases and files, design and develop masking algorithms in a form of mapplets 
using Informatica PowerCenter tool and deploy in Delphi DMSuite software
• Setup DMSuite environment and connection, create profiler set for profiling job, generate data masking 
inventory report, accommodate application owners comments and upload back to Delphix DMSuite 
repository, create and execute masking job for ETL forward code generation
 • Configure user defined data types, administrate DMSuite software and manage entitlements for other 
developers, build metadata repository from DMSuite profiler metadata in centralized data store which 
enables high degree of automation and helps to bring single version of metadata for any sensitive data 
stores within an enterprise 
• Troubleshoot DMSuite issues at various modules and co-ordinate with vendor team for software fixes 
and patches, work with vendor team to customize the software according to client’s environment
• Drive end to end migration and upgrade activities of DMSuite software from one version to another 
version as per firm’s direction 
• Generate report from metadata repository to prioritise data masking pipelines and predict future 
workload
• Develop custom tools for automation of data masking functional workflows using shell and perl scripting 
languages, deploy data masking code into dedicated datamasking plant using metadata driven migration 
software and execute dry run against production system in order to pre validate data masking code in 
the production environment
• Transition the knowledge to support team on individual data masking applications and shadow them for 
few weeks to make them provide continues support and maintenance
• Design and develop monitoring software to track data masking execution status and collect metrics for 
analysis and quality improvements, prepare migration strategy for configuration or software 
changes,execute migration
• Prepare project plan for various business requirements, drive and track delivery status and provide 
periodic reports to management
• Work with User Interface(UI) team and align our deliverables according to their plan, conduct weekly 
meeting with offshore team to effectively communicate business requirements
• Prepare quarterly roadmap for data masking program and share with all stakeholders, drive Proof of 
Concepts(PoC), evaluate vendor tools for new data masking requirements. Act as a SWAT team member 
for any fire fighting situations, troubleshoot and resolve issues in production during onsite hours
• Arrange periodic meeting with business users, business analysts, managers at all stages of the project 
life cycle to make everyone on same page 
• Dive own and offshore team deliverables to assure on time delivery with no compromises in quality

 Collection of multiple legacy reporting platform usage data for data discovery and exploration to 
identify extensively used platforms. Used Python and Spark to clean and analyze large datasets, 
Built new forecasting models which increased customer base for one of the analytics platform
 Used decision trees to identify manual execution of reports Vs scheduled report usage to 
understand usage pattern. Conducted cluster analysis to generate segmented usage from 
various types of users.  Used random forest algorithm to help identify external users usage and predict the likelihood of 
using additional services
 Manage multiple development and support projects for Alight Solutions including Health & Wealth 
Reporting, Financial Manager(FM) Reporting, Your Spending Account(YSA) Reporting and Plan 
Sponsor Portal Shutdown
 Manage multiple development and support projects for Alight Solutions including Health & Wealth 
Reporting, Financial Manager(FM) Reporting, Your Spending Account(YSA) Reporting and Plan 
Sponsor Portal Shutdown
 Drive Project Planning, Requirement Analysis, impact analysis, Architecture, Design and 
Development, UAT and deployment strategy for each project and monitor project progress to 
meet deadlines, standards and cost targets
 Manage multi disciplinary team comprising ETL, Reporting and java development team to deliver 
seamless reporting experience for end users
 Prepare and execute monthly & quarterly project releases based on business priorities. 
Document process flows, prepare dependency charts and determine the right lineage between 
business and IT needs  Interact with business owners to understand business priorities and conduct weekly meeting with 
client team. Drive project deliveries end to end with central focus on customer’s expectation
 On Monthly basis, Identify usage of all reporting platform and decommission inactive application 
to save cost incurred on licensing and maintenance
 Audit overall BI migrations on weekly basis and prepare key metrics to support and meet GDPR 
& SOC 2 compliance requirements
 Define SMART goals for project and team members to achieve common goals inline with 
organization priorities.Dive own and team deliverables to assure on time delivery with no 
compromises in quality and provide periodic status to management