Informatica, SQL, Unix Shell Scripting
Resume:
Ankush J Varma
Visa Status: L* (with EAD)
**********@*****.***
Summary:
Extensive experience (7 years) in analysis, design, development, testing and implementation of data integration between business application systems using Informatica Powercenter 9.5, 9.1 & 8.6.
Experience in querying and analyzing data sources to understand the data and determine logic for data transformations.
Created Informatica sessions, worklets and workflows for the mappings designed based on the Architecture. Created various Reusable and Non-Reusable tasks like Session and also used different tasks like Decision tasks.
Handled Performance Tuning for various Informatica components to reduce the component run time and redesigned existing mappings to create re-usable components.
Experience of working in Pentaho Data Integration 5.2 to perform data transformation activities.
Extensive experience in Smartstream reconciliation TLM tools.
Extensive experience working in Unix environment and writing shell scripts.
Proficient in complex SQL on Oracle database.
Designed multiple ETL solutions for various data formats for reconciliations.
Developed multiple reconciliations on Transaction Lifecycle Management (TLM) platform
Designed generic schema on SmartSchema 4.1.
Configured rules on TLM in Recon Admin 2.5 and 2.7 and design of dashboards in Design Studio 2.5 and SmartStudio 2.8.
Executed Tech Lead responsibilities including verification of code promotion plans, conducting code dress rehearsal and liaising with Production Support teams for code promotions.
Extensive coding knowledge in Python 2.7
Followed Agile development methodology for all our deliverables, with 2 week sprints.
Experience:
Senior Associate
J P Morgan Chase
Bangalore, India
Jun 2014 – May 2016
Team Leader
Accenture
Bangalore, India
Sep 2010 – Jun 2014
Senior Software Engineer
Accenture
Bangalore, India
Nov 2008 – Aug 2010
Senior Analyst
Lehman Brothers
Mumbai, India
May 2007 – Nov 2008
Analyst
Lehman Brothers
Mumbai, India
May 2006 – Apr 2007
Senior Process Executive
Progeon Ltd.
Bangalore, India
Dec 2005 – Apr 2006
Process Executive
Progeon Ltd.
Bangalore, India
Jan 2004 – Nov 2005
Technical Skills:
ETL Tools : Informatica PowerCenter 8.6, 9.1 and 9.5; Pentaho 5.2
SmartStream Tools : SmartStream TLM 2.7 Recon Admin; SmartStream TLM 2.7 Design Studio; SmartSchema 4.0; SmartStudio 2.8
Languages : SQL; Shell Scripting
Other Tools : Scheduling tool Autosys; task lifecycle tracking tool JIRA
Academic Qualification:
B.E. in Electronics from North Maharashtra University Jun 2001
Experience in Detail
Company: J P Morgan Chase (Jun 2014 – May 2016)
Domain: Investment Banking
Role: Senior Associate
Roles and Responsibilities:
Belong to the controls framework team wherein responsible for building and maintaining the reconciliation processes, providing control and ensuring data integrity across various platforms.
Worked on Pentaho 5.2 for performing ETL related activites by creating ktr and kjb.
Understanding client requirements and develop end to end reconciliation
Work in agile methodology with sprint of 2 weeks and provide updates on tasks in scrum calls
Work on enhancements and improvements of the existing code and provide L3 Support
Execute Tech Lead responsibilities including verification of code promotion plans, conducting code dress rehearsal and liaising with Production Support teams for code promotions.
Company: Accenture (Mar 2013 – Jun 2014)
Domain: Investment Banking
Client: Bank of America
Role: Team Lead
Roles and Responsibilities:
Worked on project involving data quality using Informatica Developer tool (IDQ) to reconcile data and provide match score report.
Handling a team of 4 members which is responsible for delivering interfaces to transform data from source to target in desired format using Informatica and Unix Scripts.
Gather requirements from client and create high and low level design documents.
Conduct UAT and KT for users and support teams for the developed interfaces.
Provide Production Support for initial few months after GO LIVE.
Manage project and team related activities for internal organization purpose.
Company: Accenture (Nov 2008 – Feb 2013)
Project Name: SmartStream TLM (Transaction Lifecycle Management)
Domain: Investment Banking
Client: J P Morgan Chase
Role: Team Lead cum Designer
Roles and Responsibilities:
Informatica
Requirements Collection from ETL perspective and parsing high-level design specification to simple ETL coding and mapping standards.
Worked on Informatica PowerCenter transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Sorter and Sequence Generator.
Developed SQL overrides in Source Qualifier according to business requirements.
Created sessions, worklets and workflows for the mappings designed based on the Architecture. Created various Reusable and Non-Reusable tasks like Session and also used different tasks like Decision tasks.
Performance Tuning handled for various Informatica components to reduce the component run time and redesigned existing mappings to create re-usable components.
Interviewed candidates on technical skills in Informatica
SmartStream TLM
Design of generic schema on SmartSchema 4.1
Generation of kb files and modification of the same
Loading of files for processing on database through Unix
Configuration of rules on Recon Admin 2.5 and 2.7 and design of dashboards on Design Studio 2.5 and SmartStudio 2.8
Used various TLM features like Masking, Aliasing, Chart dashboards
Import of SmartStream TLM packages to different environments using Configuration Import 3.4.
Development of Unix shell scripts to modify the format of input files in line with the SmartStream TLM standards.
Interviewed candidates on TLM.
Highlights
As part of the project, worked in Bournemouth, UK for 8 months (March 2011 – Oct 2011) at client site and carried out below responsibilities:
oWorked on migration of entire configuration (including testing; directory structure setup; implementation, validation and backup plans creation) of SmartStream TLM project from Unix to Linux
oWorked on various resiliency projects:
Formatting of SmartStream TLM logs through Informatica for better monitoring
Extracting Key Performance Indexes through Unix scripts
Scripts to establish connectivity with external servers to download data files
Worked in Singapore for a year (Oct 2009 – Sep 2010) on an end-to-end assignment to include all the CVC (Client Value Revenue) reconciliations for Sales and Marketing team on Informatica and SmartStream TLM. Most of these are 3-way reconciliations and need status reports and aging on SmartStream TLM along with additional reconciliation and formatting logic.
Received Accenture Excellence award in June 2011.
Company: Lehman Brothers (May 2007 – Oct 2008)
Project Name: SmartStream TLM (Transaction Lifecycle Management)
Domain: Investment Banking
Role: Designer
Roles and Responsibilities:
SmartStream TLM
Acting Point of Contact for a team of 4 people working on Design and Migration of SmartStream TLM reconciliations.
Involved in Design Meeting as role of Subject Matter Expert.
Involved in Testing of reconciliations for functionality and adherence to design standards and coordinated User Training for developed reconciliations to establish a comfort level after migration.
Tracking, Follow-up and Closure of Issues and concerns that rise during UAT.
Hand-over documents prepared for the components that were migrated to Production after User Acceptance Testing.
Responsible for SmartStream TLM Account Creation, workflow and dashboard configuration.
Creation of Business Objects reports accessing SmartStream TLM database using various universes for MIS purpose.
Trained team members on various concepts of SmartStream TLM like Reference Masking, Passes, Workflow Tools, etc.
Highlights
Traveled to Tokyo for duration of 4 months (Aug 2007 – Nov 2007) for designing of Asian reconciliations on SmartStream TLM. This was the first instance of secondment in Lehman Brothers India Operations.
Company: Nomura Services (Erstwhile Lehman Brothers) (May 2006 – April 2007)
Project Name: GSSR (Global Smart Stream Reconciliation)
Domain: Investment Banking
Role: Administration
Roles and Responsibilities:
GSSR
Handled GSSR Admin Functionality tasks like Maintenance Queues, Account Set-Up, Account Owner Investigation, etc.
Creation of GSSR auto matching rules to reduce manual intervention.
Analysis of GSSR Message Maintenance Queue and Investigation of various Operator Intervention errors.
Creation and Submission of Integrity Report on a daily basis to Senior Management.
Highlights
Received Lehman Monthly Achievers’ Award in Oct 2006.
Contact this candidate