Jhansi Mandla

Address: ****,******* ****** *-**** Address: acozti@r.postjobfree.com

Quincy, Massachusetts - 02169 Phone Number: 617-***-****

SUMMARY

• Over 7 years of professional experience in IT Industry with expertise in Analysis, Design, Development,

Implementation, Modeling, Testing, and support for Data warehousing applications.

• Proficient knowledge in Data warehousing and Business Intelligence concepts with emphasis on ETL and life

cycle development using Informatica PowerCenter (Repository Manager, Designer, Workflow Manager and

Workflow Monitor).

• Extensive experience in developing complex mappings from varied transformations like Router, Filter, Sorter,

Connected and Unconnected lookups, Normalizer, Expression, Aggregator, Joiner, Union,Update Strategy,

Stored Procedure and Sequence Generator etc.

• Experienced in loading data, troubleshooting, Debugging mappings, performance tuning of Informatica

(Sources, Targets, Mappings and Sessions) and fine-tuned transformations to make them more efficient in

terms of session performance.

• Worked on Slowly Changing Dimensions (SCD's) and its implementation to keep track of historical data.

• Expertise in Data Extraction from Flat Files (fixed width, delimited), XML files using Power Center.

• Experienced in automating the Informatica jobs, also experienced in Informatica scheduler (Tidal, Control-M)

Autosys.

• Experience in UNIX working environment, writing UNIX shell scripts to automate ETL Process and also for

Informatica pre & post session operations.

• Good understanding of PL/SQL procedures, functions, triggers and other database components. Experience in

converting PL/SQL procedures to ETL Interfaces.

• Excellent soft skills, team building skills. Have played Technical Lead / Sr Software Developer roles for

various projects and handled team as big as 5-7 team members.

• Experience in implementing Update-Strategies, incremental loads, Informatica B2B data transformation and

change Data capture.

• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope,

Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System

testing, Implementation and production support.

• Sound knowledge on all testing processes;have worked on unit testing,system testing,integration

testing,regression testing and UAT.

• Experience as an SME assisting the development teams with requirement gathering, system analysis,

finalizing technical and functional specifications.

• Have fair knowledge on Health Insurance, Finance and Investment banking domain.

• Excellent communication skills, problem solving skills, Leadership qualities and an attitude to learn the new

cutting edge technologies.

• Handled training sessions on Informatica to the team. Participated in Recruitment drives for Informatica

positions.

EDUCATION

Bachelors in Information Technology

JNTUniversity, India

TECHNICAL SKILLS

Informatica Power Center 8.6 and 9.0.1,9.5 Toad, PL/SQL

Tools Developer, WinSCP,Putty,Subversion (version

control),Tidal, Control-M(Scheduler Tools)

Databases SQL, PL/SQL and Oracle 9i,10g

Scripting UNIX shell Scripting.

Reporting Cognos Report Studio

Testing Unit testing, System Integration tests and User

Acceptance Tests.

Operating Systems Windows XP, Windows 7/8 and UNIX

WORK EXPERIENCE

Client : Tufts Health Plan

Feb 2014 – Till Date

Position:Consultant

Company Profile: Tufts Health Plan is not-for-a profit health maintenance organization, it is one of the nation’s

most highly –rated health plans. The company is distinguished for providing an outstanding member experience

and access to quality care. Tufts Health Plan offers a broad array of health care coverage options to individuals

and employer groups. Through diverse product offerings, the plan covers members regionally and across the

country

Environment: Informatica 9.5, Oracle 11g, Toad, PL/SQL, Windows NT, UNIX Shell Scripting.

Responsibilities:

• Responsible for understanding the business requirements and Functional Specifications document and

prepared the Source to Target Mapping document.

• Worked closely with Business Analyst and involved in Data Analysis to identify the business rules.

• Involved in Design review, code review, Performance analysis.

• Created Techical design documents,Unit test cases.

• Developed mappings/reusable objects/ transformations by using mapping designer and transformation

developer in Informatica Power Center.

• Created deployment groups to deploy objects

• Created Tidal jobs to schedule the Informatica workflows.

• Involved in optimization to identify the bottlenecks for the existing jobs.

• Developed Reusable Transformations and Reusable Mapplets.

• Migrated objects from the development environment to the QA/testing environment to facilitate the

testing of all objects developed and check their consistency end to end on the new environment.

• Optimizing the mappings by changing the logic to reduce run time.

• Provided production support for Business Users and documented problems and solutions for running the

workflows

Project: DBClear – Deutsche Bank Mar 2012 – Jan 2014

Position:Sr.Informatica Developer

Company Profile: DBClear is Deutsche Bank’s leading single and multi-asset clearing platform.

DBClear offers clients a world class clearing service ensuring our clients operating model is both present and

future proofed. It includes cost and impact modelling, expedient legal and client on-boarding processes, detailed

certification processes, sophisticated collateral substitution, collateral efficient strategies, market leading pre-trade

and post-clear portfolio analytic tools, margin financing and tailored reporting suites across all asset classes.

Environment: Informatica 9.5, Oracle 11g, Toad, PL/SQL, Windows NT, UNIX Shell Scripting.

Responsibilities:

• Actively involved in creating design specifications and ETL design documents

• Involved in requirement analysis, ETL design and development for extracting data from the source

systems like Oracle, flat files.

• Created scripts for better handling of incoming source files such as moving files from one directory to

another directory and extracting information from file names, such as date, for continuously incoming

sources.

• Wrote scripts to ensure e-mails sent to respective people on Failure/Success, error handling, control

auditing of different processes.

• Developed workflows with Worklet, Event waits, Assignments, Conditional flows, Email and Command

Tasks using Workflow Manager.

• Involved extensively in Unit testing, integration testing and UAT.

• Developed Reusable Transformations and Reusable Mapplets.

• Responsible for entire team deliverables - Prioritizing, Assigning work and Tracking.

Project: Employee Monitoring – UBS Nov 2010 – Jan 2012

Position: Sr.Informatica Developer

Company Profile: Union Bank of Switzerland is a Swiss global financial services company with its headquarters

in Basel and Zürich, Switzerland. The company provides investment banking, asset management, and wealth

management services for private, corporate, and institutional clients worldwide, and for retail clients in

Switzerland as well.

UBS Investment Bank provides securities, other financial products and research in equities, rates, credit and

derivatives.

Environment: Informatica 9.1, Oracle 11g, Toad, PL/SQL, Windows NT, UNIX Shell Scripting.

Responsibilities:

• Actively involved in creating design specifications and ETL design documents

• Involved in requirement analysis, ETL design and development for extracting data from the source

systems like Oracle, flat files.

• Assisted the team in the development of design standards and codes for effective ETL procedure

development and implementation.

• Created scripts for better handling of incoming source files such as moving files from one directory to

another directory and extracting information from file names, such as date, for continuously incoming

sources.

• Wrote scripts to ensure e-mails sent to respective people on Failure/Success, error handling, control

auditing of different processes.

• Developed workflows with Worklet, Event waits, Assignments, Conditional flows, Email and Command

Tasks using Workflow Manager.

• Involved extensively in Unit testing, integration testing and UAT.

• Developed Reusable Transformations and Reusable Mapplets.

• Knowledge Transition and resolving day-to-day production issues.

Project: T&D Somersworth Reporting – GE Energy Jun 2010 – Oct 2010

Position: Sr.Informatica Developer

Company Profile: GE Energy was a division of General Electric. As of 2013, it is no longer an active division of

GE.

This project involves in generating Cognos reports in various modules of Somersworth site data.It has divided

into many modules like Finance,Material &Shipping,IDS Orders etc.

Environment: Informatica 8.6, Cognos Report Studio,Oracle 11g, Toad, PL/SQL, Windows NT, UNIX Shell

Scripting.

Responsibilities:

• Documented the user requirements, translated requirements into technical specification for the

development of end user reports (Cognos reports) and developed implementation plan and schedule.

• Developed Slowly Changing Dimension Mappings using Type 1 SCD and Type 2 SCD.

• Created scripts for better handling of incoming source files such as moving files from one directory to

another directory and extracting information from file names, such as date, for continuously incoming

sources.

• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter

Files.

• Developed workflows with Worklet, Event waits, Assignments, Conditional flows, Email and Command

Tasks using Workflow Manager.

• Developed Cognos reports using Report Studio and cosmetic changes required to the existing reports.

• Involved extensively in Unit testing, integration testing and UAT.

• Developed Reusable Transformations and Reusable Mapplets.

Project: GE Wind Field Optimization - GE Wind Feb 2009– May 2010

Position: Informatica Developer

Company Profile: GE Wind Energy is a branch of GE Energy, a subsidiary of General Electric. The company

manufactures and sells wind turbines to the international market. In 2009, GE was the second largest wind turbine

manufacturer in the world.

The Project involved in analysis of existing reports, design, development and testing of reports, creation and

publishing of packages, migration of reports across three disparate environments and performs testing for GE

WIND Field Optimization.All these reports were available to different poles (North America / North Europe /

South Europe/ Asia) as applicable.

Environment: Informatica 8.6, Cognos Report Studio,Oracle 11g, Toad, PL/SQL, Windows NT, UNIX Shell

Scripting.

Responsibilities:

• Developed various mappings for extracting the data from different source systems using Informatica,

PL/SQL stored procedures.

• Developed mappings for extracting data from legacy and Oracle Applications into our data warehouse.

• Created Mapplets for implementing the incremental logic, in identifying the fiscal quarter of the

transaction and in calculating various requirements of business processes.

• Created scripts for better handling of incoming source files such as moving files from one directory to

another directory and extracting information from file names, such as date, for continuously incoming

sources.

• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter

Files.

• Developed workflows with Worklets, Event waits, Assignments, Conditional flows, Email and Command

Tasks using Workflow Manager.

• Developed Cognos reports using Report Studio.

• Involved extensively in Unit testing, integration testing and UAT.

• Developed Reusable Transformations and Reusable Mapplets.

Project: GE FS US Order Config – GE Fleet Dec 2007– Jan 2009

Position: Informatica Developer

Company Profile: GE Fleet Provide commercial car and truck financing and fleet management services to help

Customer save time and money and reduce environmental impact.

The project is a Development project of Agile Nature. This project is executed in iterations driven by the client

itself. It includes ETL, JAVA and Mainframe module development. This project involves developing applications

for GE Fleet Capital Services so that the customer can maintain the Orders received for Leasing and buying new

vehicles.

Environment: Informatica 8.6,Oracle 11g, Toad, PL/SQL, Windows NT, UNIX Shell Scripting.

Responsibilities:

• Involved in Analysis of BRD’s provided by Client.

• Developed mappings between multiple sources such as flat files, oracle and multiple targets.

• Created Informatica mappings with PL/SQL stored procedures/functions to incorporate critical business

functionality to load data.

• Extensively used almost all the transformations, which includes (Sequence Generator, Expression, Filter,

Router, Sorter, Rank, Aggregator, LOOK UP (Static and Dynamic), Update Strategy, Source Qualifier,

Stored Procedure, Joiner, Normalizer, XML Source Qualifier).

• Used Mapplets, Reusable transformations, Parameters and Variables to implement OO (object orientation)

techniques and to facilitate the reusability of Code.

• Developed Cognos reports using Report Studio.

• Involved extensively in Unit testing, integration testing and UAT.

• Developed Reusable Transformations and Reusable Mapplets.

Project: GEFANUC Sourcing DWH and DEFLATION TRACKER –

Sep 2007– Nov 2007

GEFANUC

Position: Informatica Developer

Company Profile: The GEFanuc is mainly involved in analysis of AS-IS process of Gefanuc sourcing and

Deflation Tracker and Creating the Physical Schema Design and Calculating the Business functionalities like

INVOICE-Cleared or Uncleared and PURCHASE-Paid or Unpaid etc .

The Main Process that performed is -Extraction, Transformation and Loading. The process on the warehouse

system executes and loads the data from flat files with pipe as delimiter, First phase of the project, data is moved

from flat files to staging area (STG) of the Warehouse system and then data is moved from staging area to EDW

of the Warehouse system and then loaded into DWH. The different subject areas covered in this phase are Invoice,

Purchase Order, Product and Vendor.

Environment:Business Objects Data Integrator 11.5,Oracle 9i,PL/SQL

Responsibilities:

• Developed mappings between multiple sources such as flat files, oracle and multiple targets.

• Extensively used all the transformations, which includes (Sequence Generator, Expression, Filter, Router,

Sorter, Rank, Aggregator, LOOK UP (Static and Dynamic), Update Strategy, Source Qualifier, Stored

Procedure, Joiner, Normalizer, XML Source Qualifier).

• Involved extensively in Unit testing, integration testing and UAT.

Contact this candidate