Alight is a leading provider of human capital solutions, who helps their clients and their people navigate the complexity of health, wealth and HR. They combine data-driven, consumer-centered technology with personalized care and service to deliver a superior customer experience. The firm wanted to build an on-demand reporting solution to get upto date view of defined benefits, defined contribution and health data for every single participants belongs to a given employer.We have built self service ad hoc reporting solution to allow client to view their current and historical savings, pension and health data. Built new reporting platform called Health & Wealth Reporting for all PSP clients and achieved 85% client adaption within 9 months of the rollout. This led to $6.5M cost savings in first year of rollout and additional 350K YoY on the licensing cost and 400K YoY on resourcing cost. Responsibilities: 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 customers 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

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

Volkswagen Financial Services (VWFS) provides finance and insurance services to customers across the entire Volkswagen Group in the United Kingdom. The Group includes some of the most popular automotive brands including Audi, SEAT, ŠKODA, Porsche, Bentley, Lamborghini, Volkswagen Commercial Vehicles, and of course, Volkswagen. The firm required to migrate existing BASEL III data extract process and plausibility reports to new infrastucture from legacy system to improve the system performance and consolidate diseperate system into centralized data warehouse for reporting purpose. Responsibilities: Migrate reports from legacy system into new Business Warehouse (BW) to take competitive advantage of data warehousing methodology and eventually decommission legacy databases Optimize PL/SQL program to provide maximum throughput, adjust configurable session properties for optimal performance, identify performance bottleneck on database and ETL level and make appropriate correction Define high-level architectural blueprints for data integration and data migration, prepare roadmap for solution implementation including architecture, technology, methodology, processes and governance components Interact with business owners to understand functional requirements, prepare functional specification and high level design documents Define execution model, runtime support, and change request workflow for overall solution implementation Drive solution design, development, deployment and maintenance of various software and database components Develop software in oracle PL/SQL, SAP Data Services to extract report for EU regulatory requirements Develop custom tools for automation of regulatory data extract, fine tune database and tool performance to facilitate faster data extraction Consolidate data from disparate systems with the help of SAP Data Services ETL, Oracle PL/SQL packages, and functions Troubleshoot data integration issues at various modules and co-ordinate with other team members for software fixes and patches, drive end to end migration and upgrade activities Document process flows, prepare dependency charts and determine the right lineage between business and IT needs Dive own and team deliverables to assure on time delivery with no compromises in quality and provide periodic status to management

Moragnstanleys(MS) Welth Management Business Unit wanted to migrate their legacy sales application to Salesforce platform to get a competetive advantage over other Retail financial firms,this required them to integrate all legacy data into Salesforce platform,in addition to bring the salesforce generated data into firm downstream applications using Informatica PowerCenter ETL tool. Responsibilities: Actively involved in research and development of attachment downloads and uploads between salesforce and RDBMS systems and responsible for migration and synchronizion of account, contact, customer, opportunity and sales data to Salesforce.com Develop ETL code in order to migrate legacy applications data into salesforce and build a strategy to manage security aspects of Informatica tool in compliance with firms security model Interact with client to understand the requirement, prepare project plan and data migration strategy, design and develop reusable ETL module to download/upload salesforce attachments including PDF, Microsoft Word documents, etc., Create Extract Transform Load (ETL) and batch jobs to import legacy sales application data from MSSQL Server database into salesforce platform and develop custom scripts to invoke Informatica PowerCenter jobs from Autosys scheduler Configure an application connection for Salesforce sources and targets in the Workflow Manager to allow application connections to read from or write to Salesforce Troubleshoot runtime issues and coordinate with Internal Informatica support team to provide any HotFixes from Informatica vendor team, Work with onsite/offshore team to understand project milestones and day to day deliverables Prepare project plan and execution strategy for Informatica PowerCenter software migration from Version 8.6.x to 9.x and work with various team including DBA support, UNIX support, IT Security team to setup environment for the migration Assist Salesforce developer in design and development of Informatica mappings, sessions, workflows and configuring Informatica PowerCenter runtime properties Fine tune existing/new ETLs to acceptable application performance, conduct peer review and provide constructive feedback, prepare detailed unit test cases, execute unit test cases and document the results

• 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

CVS Caremark is a major drug producer in United States which also Offers healthcare services to their customer. They assist their Customer to get Best drug at lowest cost by giving waiver to varies type Of drugs, also they process varies type of claims for the customer expensesOf drugs, also they process varies type of claims for the customer expenses. Responsibilities: 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

Excellus BlueCross BlueShield, headquartered in Rochester, NY, is part of a $5 billion family of companies that finances and delivers health care services across upstate New York and long-term care insurance nationwide. Collectively, the enterprise provides health insurance to nearly 2 million people and employs more than 7, 000 New Yorkers. Responsibilities: Understood the business process thoroughly Got Knowledge transfer about the project from onsite

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

Affin Holdings Sdn Bhd is one of the leading finance supporting agencies which primary activities focus on the provision of commercial, islamic and investment banking services, money broking, fund management, underwriting of general and life insurance business Responsibilities: Analyze project requirements from high level design document and prepare low level 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