Data Project

NEWAZ KHAN

SR. INFORMATICA DEVELOPER

Email id- ***********@*****.***

Contact # - 424-***-****

EXECUTIVE SUMMARY

8+ Years of IT experience with hands on experience in ETL Development and Mainframe using Informatica PowerCenter 9.5.1/8.6.1/7.1,Power,Exchange 9.5.1/8.6, Data Warehousing, PL/SQL,Oracle, Teradata.

Proficient in Optimizing Database querying, data manipulation and population using SQL PL/SQL and Utilities in Oracle 11g/10g/9i, Teradata 13/12/V2R6, DB2 UDB and SQL Server 2008/2000 databases.

Hands on experience with Informatica administration and various upgrades.

Experience of leading and managing mid-size team and coordination of Onsite-Offshore team.

Experienced in Installation, Configuration, and Administration of Informatica Power Center Client.

Experience in Data Warehouse/Data Mart Development Life Cycle and worked on Dimensional modeling of STAR, SNOWFLAKE schema, OLAP, Fact and Dimension tables.

Experience writing and modifying ETL design documentation, test results documentation and standard operating procedures (SOP) documentation.

Proven experience with writing and technical requirements analysis.

Worked with Teradata loading utilities like Multi Load, Fast Load, TPump and BTEQ.

Experience in developing Shell scripts on UNIX and experience with UNIX command line.

Knowledge of Software Testing and Quality Assurance.

Designed Real-time Datawarehouse using CDC tool Informatica PowerExchange 9.5.1/8.6.1.

Excellent communication and writing skills and capable of working successfully both in teams and independently.

Ability to self-manage time and task priorities to meet project timelines, and identify potential project risks.

Expertise in handling error, exception and performance issue in Informatica.

Experience in Unix Shell Scripting for data manipulation and scheduling tasks.

Hands on experience with third party scheduling tools like Autosys.

Expertise in production support and handling production issues.

Good experience in first logic, normalization for database designs purpose.

Provide support for problem resolution and service restoration.

Coordinating the daily work between Onsite and Offshore.

Coordinating the work and Mentoring the team for a timely/quality delivery of the deliverables.

Communication with Business and other stakeholders on ongoing basis.

Successful overseeing the entire system / application development life cycle to deliver complex, large-scale applications and systems per client requirements.

Highly effective leveraging team relationships and programming languages to maximize performance across systems and applications.

Excellent Analytical, Logical and Programming Skills.

Capable to add values to the application with innovative ideas and creating tools to reduce the redundant manual efforts.

Successful overseeing the entire system / application development life cycle to deliver complex, large-scale applications and systems per client requirements.

Excellent team player with the strong interpersonal communication, analytical skills, ability to work on multiple tasks, Quick learner, meets the strict deadlines as well as fast-paced and demanding environment.

TECHNICAL SKILLSSKILLS /

Key Skills :

Informatica Power Center 9.5.1/8.6/8.1/7.1, Informatica PowerExchange 9.5.1/8.6

Data Warehouse :

Multidimensional Model Design, Star Schema Development

Data Modeling:

Star-Schema Modeling, Snowflake Modeling, MS Visio

Database:

DB2, IMS DB, Oracle 11g/10g/9i, MS SQL Server7.0/2000, MS Access, Sybase, MySQL, Teradata 13/12/V2R6

Programming:

C, C++, SQL, PL/SQL, HTML, UNIX Scripting

Applications:

MS Office, MS Project, FrontPage, Toad 9.2/8.6

CAREER CONTOUR

Duration-Since Oct 2013 Till Present

Client- KBR, Houston, TX

Role:

Senior ETL/Informatica Developer

Environment

Informatica Power Center 9.5, Informatica Power Exchange 9.5, DB2, Data Modeling, TOAD 9.2, Oracle,11g Unix, Mainframe, IMS DB, Oracle 11g,BTEQ, MS SQL Server7.0/2000,CDC.

Responsibilities

Interacted with business analysts to gather the business requirements by attending regular meetings with the business community.

Used Informatica user defined functions to reduce the code dependency.

Handled versioning and dependencies in Informatica.

Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.

Performing ETL & database code migrations across environments.

Prepared ETL detail design and unit testing document to outline the flow of data, for testing source/targets counts and field-to-field mappings.

Provided production support by running the jobs and fixing the bugs.

Taking the backup of the repository at regular interval depending on the amount of work done.

Aided in migrating the code across various environments.

Worked on test cases and test plans.

Documented the process for further maintenance and production support.

Coordinated the Change Management process which involved driving the QA and production deployments.

Involved in Information administration including creating new users and groups, backing up the repository and domain as well as handling various upgrades.

Working on new projects to fulfill the business needs.

Documented the scope of new development projects.

Involved in writing and modifying UNIX shell scripts.

Worked with data quality team to fix the production data issues and also provide solutions to the business users.

Involved in providing the solutions for production support job failures at Tier-2 level.

Coordinated with offshore team to support the existing ODS system jobs.

Coordinated with business users and across the development teams in implementing new business requests.

Used Toad for data quality verification and unit testing the data.

Provided 24X7 on call support which included monitoring morning and nightly jobs and emergency production fixes.

Duration-May 2012 to Sep 2013

Client-TMNA, Bala Cynwyd, PA

Role:

Senior ETL/Informatica Developer

Environment

Informatica Power Center 9.1, Informatica Power Exchange 9.1, DB2, Oracle 11g Exadata, MySQL, TOAD 8.6, PL/SQL,MS Office,Unix,Linux,DB2,Crystal Reports, C, C++, Mainframe.

Responsibilities

A project of 5 months duration named NAV Dissemination Analysis implemented successfully. From the design to construction, Unit Testing, System Testing, UAT support, implementation and post implementation verification were performed by Arnab.

Handled versioning and dependencies in Informatica.

Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.

Performing ETL & database code migrations across environments.

Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.

Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.

Created and maintained the Shell Scripts and Parameter files in UNIX for the proper execution of Informatica workflows in different environments.

Provided effective guidance to offshore for performing Unit/ System Testing and UAT support.

This was a short term assignment. Two offshore members were working with me as I was responsible for all of the deliverables.

As UAT and business team are located at a different locations, UK / Ireland, there was efficient coordination with UK / Ireland team as well as the technical team based in Pittsburgh, US to execute the project flawlessly.

Production Support – Fixing and Resolving Production abends. After hours on call support.

Root Cause analysis and preparing technical specifications for the required code changes.

Technical/Functional Documentation

Per-forming Peer Reviews

Review of different SDLC phases of team members, tracking and monitoring of Project schedules

Risk identification and planning

Monitoring and reporting project and support metrics and service level agreements.

Duration- May 2011-April 2012

Client-Pacific Life, Newport, CA

Role:

ETL/Informatica Developer

Environment

Informatica Power Center 8.6, Informatica PowerExchange 8.6, DB2, Oracle 11g, Unix, Linux,Mainframe, Teradata 12, SYBASE, OBIEE 11g

Responsibilities

Created business requirement and functional specification document.

Requirement analysis, preparation of design documents, coding and Unit testing, and guiding team members during construction/delivery phase for FLEX and GIS application.

Participating in requirement gathering and gap analysis.

Estimation of different phases of the project.

Involved in data mapping and table and schema analysis.

Risk identification and planning

Stage load process with extracting the data from the different sources.

Smoothly handing the challenges for the formatting issues.

Managed requirements and design phase towards identifying mutually agreed solutions with technical teams and business partners.

Delivery management with offshore coordination was a key role as an onsite team lead.

Participating actively for the deployment and QA processes.

Implementing projects, end to end testing, System testing and user acceptance testing.

Review of different SDLC phases of team members, tracking and monitoring of Project schedules

Involved in co-ordination and communication between the Offshore and Onsite team

Participating as a key team member in planning and coordinating the testing of the products developed.

Responsible for testing and sign off from various groups like Operations and Products.

Implemented the plan for the rollover of this project to production.

Managing the delivery

Participate in Knowledge Management activities

Duration-July 2007-April 2011

Client: Sun Trust Bank, Atlanta, GA

Role:

ETL Developer

Environment

Informatica Power Center 8.6/8.1/7.x/ DB2, Oracle 10g/9i/8i, Unix, Mainframe, MS Access, SQL/PL/SQL,UNIX, MySQL, Teradata V2R6

Responsibilities

Extract the data from the application to staging area thru flat files and Tables.

Upload the data from staging area into Destiny database

Implemented Dashboards Analytics using Business objects Performance manager.

Extract the data from the application to staging area thru flat files and Tables.

Developed stored procedures for generic values instead of using the sequence generator transformations.

Extensively used ETL to transfer data from different source system and load the data into the target database.

Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data Warehouse.

Developed number of complex Informatica mappings, mapplets, reusable transformations to implement the business logic and load the data incrementally.

Extracted data from Oracle and SQL Server and load the data into target database.

Handled slowly changing dimensions of Type1/ Type 2 to populate current and historical data to dimensions and fact tables in the Data Warehouse.

Developed Informatica mappings by usage of aggregator, SQL overrides in lookups, source filter in source qualifier and data flow management into multiple targets using router transformations.

Extensively involved in performance tuning of the ETL process by determining the bottlenecks at various points like targets, sources, mappings, sessions or systems. This led to a better session performance.

Involved in creating the runbook and migration document (from Development to Production).

Document the process for further maintenance and support.

Worked on test cases and use cases creating Unit Test Plans & Unit Testing of Programs.

Involved in the Software Development Life Cycle.

Development & Modification/Bug Fixing of Programs

Performing Peer Reviews

Participate in Knowledge Management activities

Worked on production support, Prioritization of Prod issues, Modification of code, proactively fixing issue and job monitoring

Monitoring and reporting project and support metrics and service level agreements.

Contact this candidate