Manager Project
Resume:
Jhansi Mandla
Address: ****,******* ****** *-**** Address: ******.****@*****.***
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