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

• 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

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