Application Development Senior Analyst Resume Example

Project Name :SigFig (ETL -Developer)

Client Name:UBS

Project Description:UBS is a global firm providing financial services to private, corporate and institutional clients. This project deals with the wealth management department of Union Bank of Switzerland, USA. The main purpose of this project is to create and customize their tools and services for advisors that will complement their expertise and enhance client digital experience.

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 on a daily basis.
• Creating Autosys jobs for scheduling.
• Monitoring and managing QA defects in ALM.
• Creating SCR and deployment notes to migrate the code to higher environments.

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 in order 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 in order 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.

Project Name: Capital Stream

Client Name: PNC

Project Description: PNC Financial group is one of the largest diversified financial services organizations. PNC has wide range of services for their customers for individual, small business to corporations and government entities. 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. On the basis of the rating PNC can decide the relation with the customer for various types of loan and credit. They want to create the data ware house to analysis their business.

Responsibility:

• 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 stage and historical table.
• Used MD5 to comparing stage and historical data for maintaining the history.
• Used Harvest tool for check in the code for QA environment.
• Conducting Unit Testing.