Jyoti Bhala

1-469-***-**** E: adi684@r.postjobfree.com

Redmond, WA 98052

PROFESSIONAL SUMMARY

* ***** ** *****-** experience in ETL-Informatica power center across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing

Worked as a team lead while helping project Management with time estimation for project completion.

Participated in regular Technical Reviews, Defect review and walkthrough meetings with important project & business stakeholders throughout the project life cycle.

Strong Data Warehousing ETL experience of using Informatica 9.x PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools.

Created Informatica mapping using various transformation (like router, Filter, Aggregator, union, lookup etc) Implemented SCD Type -I, II.

Expertise in working with relational databases such as Oracle 11g, SQL Server MS Access and Teradata.

Extensive experience in developing Tables, Views and Complex SQL queries using SQL Server and Oracle.

Experience in designing and developing dashboard using Tableau Desktop for various organizational metrics and indicators using best practices and industry standards.

Maintaining and Supporting during various phases of testing including Production environment.

SKILLS

Operating Systems: Unix, Windows

Database: SQL Server, Teradata, Oracle 11g

ETL: Informatica PowerCenter 9.6, Informatica Power Exchange 9.6

Language: SQL, Shell Script

Tools: Oracle SQL developer, Toad, Tableau, VMware.

WORK HISTORY

APPLICATION DEVELOPMENT SENIOR ANALYST 01/2019 to Till Date

Accenture

Project Name: Portfolio Management (ETL Informatica Developer).

Responsibility:

Creating mappings using different transformations and loading the target tables.

Created Informatica mappings to load the data warehouse. Implemented SCD- type 2. The mappings involved extensive use of transformations like Filter, Router, Expression, Sequence generator, lookup and joiner.

Use lookup transformation to get the date from flat file.

Used joiner transformation to join the staging and hist table

Create the sql queries and map view.

Coordinating with the onshore team to manage application and to address issues changes on daily basis.

Creating control m jobs for scheduling.

Keep track of user stories and responsible for code delivery and timelines.

SENIOR ASSOCIATE (INFORMATICA DEVELOPER) 12/2015 to 01/2019

Cognizant Technology Solutions

Project Name : SigFig (ETL -Informatica Developer)

Client Name: UBS

Responsibility:

Creating mappings using different transformations and loading the stage tables.

Generate the files and Sftp to Sigfig drop box. Perform health check on the files and send reports to end users. Perform reconciliation for position and balances files generated within UBS and files send by Sigfig.

Coordinating with the onshore team to manage application and to address issues changes daily.

Creating Autosys jobs for scheduling.

Worked in AGILE development environment using JIRA and Confluence.

Monitoring and managing QA defects in ALM.

Schedule extract refresh for weekly and monthly reports.

Creating SCR and deployment notes to migrate the code to higher environments.

Involved in cleansing of data and designing the data modeling part.

Project Name: Global Securities Infrastructure (Data Provisioning)

Client Name: Credit -Suisse

Project Description: Data Provisioning is a project which manages the flow of data internal and external to GSI. There are various consumers for which we prepare extract to fulfill their requirements. Reconciliations are carried out between the Front office and Back office trades. Due to day-to-day business transactional process and to maintain consistency extracts are generated with help of ETL tool. Huge Data stores along with its huge set of connections in different environment are involved to generate feed for different business consumers.

Responsibility:

Understanding the business model and customer requirement.

Involved in developing ETL strategy to populate the Data Warehouse from various source systems (Flat Files, Oracle) feeds using Informatica Power center.

Creating reusable transformations and used transformations like Source qualifier, Aggregators, lookups, Filters, Router, SQL, and Joiner.

Also created Concurrent workflows.

Code review and Unit testing.

Involved in trouble shooting and performance tuning.

Performed unit testing and bug fixing. Preparing Technical Specification, Unit Test Case Documents.

SYSTEM ENGINEER (BI Engineer) 2012 to 11/2015

Tata Consultancy Services

Project Name: Capital Stream

Client Name: PNC

Project Description: PNC Financial group is one of the largest diversified financial services organizations. PNC project involves building a Data Warehouse application using the tool Informatica and Oracle. The aim of this project is to calculate the rating of the customers. Based on the rating PNC can decide the relation with the customer for various types of loan and credit. They want to create the data warehouse to analysis their business.

Responsibility:

Developed mappings that performed Extraction, Transformation and load of source data into Derived Masters schema using various power center transformations.

Wrote SQL queries to test the data in database using TOAD and validated the data.

Experienced in debugging mappings; Identified bugs in existing mappings by analyzing the data flow and evaluating transformations

Developed and assisted users in creating and modifying worksheets and data visualization dashboards.

Created drill down and navigation reports using the Tableau Desktop.

Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.

EDUCATION

Bachelor of Engineering Technology Information Technology 04/2012

Sant Gadge Baba Amravati University

Contact this candidate