Monika Jain

Mobile: +1-973-***-****

Email: adcfii@r.postjobfree.com

PROFILE

• 11+ years of IT experience in Design, Development and Implementation of Data warehouses as an ETL Lead/Developer & Support Lead

• Experience in an onsite/offshore model including coordination and assignment of work to offshore resources

• Experience in designing and implementing ETL environments using ETL strategies as well as tools like Abinitio & Informatica

• Experience in the Analysis, Design, Development, Testing and Implementation of business application systems for banking & telecom clients like Barclays, Vodafone, Citi & JPMC

• Extensive experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files, DataBase – Oracle, Teradata

• Proficiency in using various Abinitio components like Join, Reformat, Redefine Format, Lookup, Rollup, Scan etc

• Extensive experience in error handling and problem fixing

• Extensively worked with Client’s for gathering Requirements

• Perform and participate in all aspects of the project lifecycle including requirements and worked in Design, Development, Testing, Production Deployment & Hyper Care

• Exposure in preparation of Technical Design document, Test cases and Unit test documents

• Involved in full life cycle development of Data Warehousing

• Experienced in using scheduling tools like Autosys, Maestro & Tivoli

• Experience in working with UNIX Shell scripts and necessary Test Plans to ensure the successful execution of the data loading process

• Knowledge of working with tools like Teradata SQL Assistant, Putty

• Excellent communication and interpersonal skills UEDUCATIONAL QUALIFICATION

Bachelor’s Degree in Computer Science Engineering, India UTECHNICAL SKILLS:

Data warehousing Tools Abinitio-GDE 3.0.5, Abinitio-EME, Abinitio Co-op 3.0.3, 2.14

Databases Teradata, Oracle

Languages SQL, PL/SQL

Database Utilities Teradata SQL Assistant, PL/SQL Developer Operating System UNIX, Windows NT/2000/2008.

Scripting Languages UNIX Shell Script

Other Tools Autosys, Maestro & Tivoli

UPROFESSIONAL EXPERIENCE:

Project : Wells Fargo – Corporate Finance Data Exchange Client : Wells Fargo

Company : Vultus, Inc

Position : Sr. ETL Lead

Location : USA

Duration : Sep 2018 – Till Date

Overview:

In Banking System, where the deposits and transactions are being done through different channels there is a need to consolidate the information coming from different sources and then create balance summary of all those transactions so that Fact reconciliation, adjustment and further correction entries if required can be provided so that a final summary can be generated. All these activities are being done in Wells Fargo in Corporate Finance Data Exchange System. Roles/Responsibilities:

• Participate in business requirements and functional requirements gathering, which involves a review of existing systems configurations and operating methods as well as understanding evolving business needs

• Provide technical solutions of data acquisition from different source system, apply business rules for data processing and provide automated solutions for data reporting

• Perform testing based on established best practice methods of project test strategy documents. The testing will be conducted using accelerators which streamline the testing process and optimizes testing. Create test artifacts, testing of application including extensions, procedures, and interfaces. Conduct quality review of process for data loaded onto the application and coordinating the testing activities overall with upstream and downstream applications

• End to end performance tuning of Abinitio graphs Environment: Abinitio-GDE 3.0.5, Abinitio-EME, Abinitio Co-op 3.0.3, Oracle SQL, PL/SQL, UNIX Project : Barclays – Anti-Money Laundering

Client : Barclays

Company : Capgemini

Position : Sr. ETL Lead

Location : India

Duration : Mar 2017 – Sep 2017

Overview:

Money laundering is the process of making illegally gained proceeds appear legal. First, illegal money is introduced into the legal financial systems, and then it is moved around to create confusion generally through wiring or transferring through numerous accounts. Finally, it is integrated into the financial system through additional transactions until the "dirty money" appears "clean". In an effort to detect these suspicious transactions or activities, Law enforcement agencies of many jurisdictions have set up sophisticated systems which is called as “Anti-Money Laundering”. AML (Anti-Money Laundering) System is a transaction monitoring application in which data is being received from multiple data sources in the form of flat files, processed/transformed based on the different business rules called “Anti-Money Laundering Rules” and then provisioned to Fortent Application, which ultimately provides the information to specific users & departments. Roles/Responsibilities:

• As a lead of L3 work stream of application support, work was divided into two major streams:

o Application Enhancements:

Work with business analysts and reporting lead to understand the business needs

Understand and clearly define the ETL requirements

Analyze the change & identify the impacted graphs & other application documents and prepare an Impact Assessment document

Prepare/update documents and get it reviewed / approved

Create / modify Abinitio graphs, Unix Scripts as per the defined requirements

Assist & Co-ordinate in SIT, UAT & Production deployment by working with different teams

o Providing resolutions to Production Support Teams:

With Bug Fixes & make sure that BAU Activities will continue with least possible impact of users

Analyze the Known Error Issue list and provide permanent resolutions to those issues

Analyze the performance of the application and provide resolutions & suggestions for process improvements

• Provide weekly status of the work to the management Environment: Abinitio-GDE 3.0.5, Abinitio-EME, Abinitio Co-op 3.0.3, Oracle SQL, PL/SQL, UNIX Project : Barclays – Structured Data Archival (SDA) Client : Barclays

Company : Capgemini

Position : Sr. ETL Lead

Location : India

Duration : Mar 2016 – Feb 2017

Data Ingestion/Transfer Framework:

With the continuous need of data archival for the data coming from different internal & external applications, there was a need to create a generic framework for data extraction and archival so that the same framework can be utilized across different applications for data archival needs. Salient features of the framework:

• Data can be pulled from any type of database like Oracle, Teradata or any file system

• Data Archival: All the data which was pulled from any system was need to be archived, Archival time period can be configured

o DAFFY: used for file transfer

o RainStor: storage place for Archived files

• Audit Logging & Data Control Check: checks the record count of the data pull & data push This all was done by creating configurable tables in Oracle Database and creating Abinitio graphs for data pull

Roles/Responsibilities:

• Gathering & capturing requirements by having discussions with different IT Managers / Application Managers and technical architects

• Creating data flows & process flows using MS Visio and gathering feedback

• Prepare Design documents & ETL Specifications and validating the same w.r.t. different scenarios

• Getting the list of tables from business required for the process and helping data modeler with data model creation

• Creating the unit proto-type using Abinitio, Unix & Oracle, unit testing & validation of few of the samples data objects

• Assisting in Integration testing by considering different type of data objects as well as different systems into consideration

• Leading the module UAT with users and providing demo & validation for the different test scenarios

Environment: Abinitio-GDE 3.0.5, Abinitio-EME, Abinitio Co-op 3.0.3, Oracle SQL, PL/SQL, UNIX Project : Mondrian

Client : Vodafone UK

Company : IBM

Position : Sr. ETL Developer

Location : India

Duration : Mar 2015 – Feb 2016

Overview:

The Mondrian project aims to send out the event notification from Vodafone OpCo UK to the VIS application through Provision Notification API. Notification sent to VIS is being sourced from EDW, since EDW collates network events from a number of sources and loads these into its tables. Abintio process will determine the required change events. The data once gathered is submitted to TIL (Tibco Insulation Layer) to provide the latest information about the Mondrian customer through VIS (Vodafone Internet Services). Abinitio creates the delta files which is sent to TIL via JTC.

There are basically three events for which Notification will be sent.

• Change MSISDN Event

• Change IMSI Event

• Terminate Event

Roles/Responsibilities:

• Project Lead

o Project Planning and Implementation Roadmap as per Requirements/Priorities set by Program Team

o Keeping a check on various moving parts of a project and reporting status to program stakeholders during SDLC Calls

o Lead four members’ team for supporting the issues encountered during SIT/Joint SIT testing and individually managed all issues which included discussions with different stakeholders of the project

• Abinitio Developer

o Prepared HLD and LLD by analyzing the data warehouse requirements and meeting the expectations of the client

o Prepared Unit test Cases and system test cases

o Well versed with various Abinitio parallelism techniques and implemented number of Abinitio Graphs using Data parallelism

o Providing ETL solution which are feasible in the given time and developed a generic job

o Prepared well versed Abinitio graphs with conditional components o Providing ETL solution which are feasible in the given time and developed a generic job

o Monitoring jobs in UAT and Production

Environment: Abinitio, TeraData, UNIX, Maestro

Project : OTC

Client : Vodafone UK

Company : IBM

Position : Sr. ETL Developer / Onsite Co-ordinator Location : Newbury, UK

Duration : Apr 2014 – Mar 2015

Overview:

There is a design gap in the feed of One Time charges to the EDW arising from the fact that Siebel One Time charges are no longer being processed through BRM. As a result,

• One Time Charges are not being fed to the EDW from any source resulting in incomplete revenue within the EDW and impacting on Finance Reporting.

• EDW is not able to pass on One Time Charges like Early Termination/Early Upgrade fees to the Commissions system.

This change is required to enable accurate, indirect revenue share commission payments, Customer value calculations, forecasting, and detailed reporting in the consumer, enterprise segments Roles/Responsibilities:

• Onsite Coordinator

o Involved in estimation, requirement discussions and requirement base lining o Work with business analysts and reporting lead to understand the business needs o Offshore Resource Optimization and Prioritizing project activities o Worked on getting the required approvals during the deployment and coordinated the progress of deployment

o Weekly Project Status

o Maintain the Risk register and propose the mitigation plans for the expected risks to the project deliveries

• Abinitio Developer

o Understand and clearly define the ETL requirements o Prepare data flow and ETL Specifications documents o Logical and Physical design of data model

o Tuning of the ETL code to achieve the optimum performance and meet the SLA's o Provide ideas, suggestion to the team on various project issues Environment: Abinitio, TeraData, UNIX, Maestro

Project : EU Roaming

Client : Vodafone UK

Company : IBM

Position : Sr. ETL Developer

Location : India

Duration : Sep 2013 – Mar 2014

Overview:

The aim of the project is to support minimum, mandatory requirements for EU roaming separation only. This will enable customers to select "Alternate Roaming Provider services and use Local Break out offerings" when roaming in the European Economic Area Roles/Responsibilities:

• Understanding the existing business model, analyzing the data warehouse requirements and meeting the expectations of the client

• Prepared LLD for the project after analyzing the business requirement and translating the business specifications to technical specifications

• Created Abinitio graphs to read files with dynamic runtime filenames using Read Multiple Files component

• Developed Abinitio graphs that perform SCD type2

• Created UNIX shell scripts to perform file level validation, wrapper scripts for the Abinitio

.ksh files

• Prepared Maestro schedules/jobs for scheduling the sequence of jobs in batches

• Extensively worked on Migration of Code from DEV to SIT, SIT to UAT, UAT to PROD

• Worked with testing team to setup the Test and UAT environment by running jobs end to end and resolving the environmental errors

• Extensively used sandbox version control EME commands such as checkin, checkout, creating tags, lock and unlock for personal developer sandbox Environment: Abinitio, TeraData, UNIX, Maestro

Project : Medusage

Client : Vodafone UK

Company : IBM

Position : Sr. ETL Developer

Location : India

Duration : Nov 2012 – Aug 2013

Overview:

To allow an early introduction of LTE, 4G project aims to register 4G Data CDRs onto 4G infrastructure whilst Voice calls and SMS for 4G subscriber will continue to leverage the existing 2/3G infrastructure. The objective of the corresponding EDW project is to

• Integrate the new unrated Data CDRs for 4G with EDW

• Ensure that the existing functionality of EDW for Voice and SMS calls is un-impacted

• Meet existing and 4G specific (new) downstream and reporting requirements where the concept and data are available in EDW

Roles/Responsibilities:

• Prepared well versed batch continuous graphs using Abinitio Queues

• Used Highly Skilled Transform Components such as Reformat, Normalise, read multiple files

,Filter by Expression, Rollup, Join and their parameters, transform functions and aggregate functions.

• Created conditional DML record format for processing files with Header/Detail/Footer records, used Reformat with multiple transformations using output_indexes parameter

• Extensively used sandbox version control EME commands such as checkin, checkout, lock and unlock for personal developer sandbox

• Actively Participated in Unit Testing as well as Regression Testing of the Graphs

• Lead the team & handled pre/ post go lives issues effectively & facilitate for successful go live

• Co-coordinated with onsite team member to get better understanding of project requirement and to deliver the key results in time

• Allocating work properly to team during development and to review their work periodically

• Worked closely with the testing team during testing phase and helped them in understanding the requirement of testing

• Preparing daily status report for the onsite and offshore project managers Environment: Abinitio, TeraData, UNIX, Maestro

Project : UKRR

Client : JP Morgan Chase

Company : IBM

Position : ETL Developer

Location : India

Duration : Oct 2010 – Oct 2011

Overview:

The UK Regulatory Replacement program is concerned with replacing the existing UK regulatory reporting architecture. Abinitio has been selected as the chosen product to replace the existing architecture of FRD.

UK Regulatory Program uses reference data from FRD system. It gets loan and deposit feeds from different legal entities of banks and they are loaded to common staging area and sends to UK regulatory.

Roles/Responsibilities:

• Understanding the existing JPMC architecture

• Created the conditional DML record format for processing the files with Header/Detail/Footer records

• Written shell scripts to unload the data into a file

• Written xfr based on the business requirement

• Prepared well versed Abinitio graphs with conditional components and conditional dml

• Implemented end to end testing of the project, prepared test cases and helped testing team to execute testing

Environment: Abinitio, Oracle, UNIX

Project : CDS 2.0 mart

Client : CITI Bank

Company : L & T Infotech

Position : ETL Developer

Location : India

Duration : Mar 2008 - Sep 2010

Overview:

Citidirect for Securities is a Citi custodian. It includes systems like corporate action, Transaction Manager, Fund Services Reporting.

The system allows user to trade shares, bonds, equities. To respond to new corporate event declarations, such as new dividend announcements, choose between growth or payout option, new IPO release. The system prepares reports and serves to client. There were mainly two kind of data End of day Cash and end of the day safekeeping data, and Intraday Cash and intraday safekeeping data

Roles/Responsibilities:

• Taking the requirements from Client in conference calls

• Modifying the existing and developing new Abinitio batch Graphs

• Testing the Abinitio graphs

• Unit and System Testing and fixing the defects

• Monitoring the graphs in UAT and Production

Environment: Abinitio, Oracle, UNIX

Contact this candidate