Abdul Hameed khan

acz1h5@r.postjobfree.com

872-***-****

PROFESSIONAL SUMMARY

Over 8+ years of professional IT experience in Requirement gathering, Data warehousing, Design, Modeling, Development, Analysis, Implementation and Testing.

Work with client in capturing requirements, document them and obtain sign off.

Expert knowledge in working with Data Warehousing tools (ETL tools) like Oracle Warehouse Builder (OWB) and Informatica Power Center 9.x.

Extensively used Informatica Warehouse Designer to create and manipulate Source and Target definitions, Mappings, Mapplets and Transformations.

Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator.

Have clear understanding of Data warehousing and Business Intelligence concepts with emphasis on ETL and life cycle development using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.

Expertise in Data warehousing concepts like OLTP/OLAP System Study, Analysis and E-R modeling, developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling.

Experienced in handling SCDs (Slowly Changing Dimensions) using Informatica.

Over Seven Years of RDBMS experience using Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000, PL/SQL (Stored Procedure, Function, Package, Trigger, Bulk Load, Autonomous Transaction, Exception Handling) and SQL Editor (SQL*Plus, TOAD).

Experience in implementing update strategies, incremental loads and Change Data Capture (CDC).

Knowledge of complete Software Development Life Cycle(SDLC) including Requirement Analysis, Requirement Gathering, Cost Estimation, Project Management, Design, Development, Implementation and Testing.

Involved in Full Life Cycle Development (Waterfall & Agile) of building a Data Warehouse on Windows and Unix Platforms for Life Sciences, Investment Banking, Financial, Retail, and Insurance Industries.

Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre & post session operations.

Performed System Analysis and QA testing and involved in Production Support.

Excellent communication and interpersonal skills. Ability to work effectively working as a team member as well as an individual.

Self-motivated individual with strong Technical & Analytical skills. Always keen and eager to face up to challenges by means of novel and innovative ideas.

TECHNICAL EXPERIENCE

ETL Tools : Oracle Warehouse Builder (OWB), Informatica PowerCenter v9.x,

Power Center Client tools -

Designer, Repository manager, workflow manager/monitor, ILM tool, Server tools – Informatica Server, Repository Server manager.

Programming & Scripting Languages : SQL, PL/SQL

Web Technologies : HTML

Database : Oracle 10g/11g, MS SQL Server and DB2.

Database Tools : SQL Plus, Toad, SQL Navigator, PLSQL Developer

Modeling Tools : Microsoft Visio. MySQL Workbench and Toad

Platforms : Windows NT/2000/XP/Vista, UNIX, Linux

Photoshop : Adobe Photoshop and Adobe Illustrator.

Other tools : Microsoft Office (FrontPage, Excel, Groove, Communicator, and OneNote, LiveMeeting) and Putty.

WV Dept. of Health and Human Services, Charleston, WV July 15 – Current

Sr. Informatica Developer

WV Department of Health and Human Services was provider of various consumer services to the resident of the state.

Responsibilities:

Created High Level and Low Level design document and ETL standards document.

Involved in Extraction, Transformation and Loading (ETL) Process.

Installed and configured Informatica 9.5.1 HF3 on Red Hat platform.

Wrote shell script to take repository backup on a weekly basis and archiving the 30 day old files on Red Hat.

Developed various T-SQL stored procedures, functions and packages.

Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager.

Perform T-SQL tuning and optimizing queries for Reports which take longer time in execution SQL Server 2008.

Solved T-SQL performance issues using Query Analyzer.

Optimized SQL queries, sub queries for SSRS reports.

Created the SSRS reports with multiple parameters.

Modified the data sets and data sources for SSRS reports.

Retrieved data from Oracle EBS and loaded into SQL Server data Warehouse.

Worked with the Oracle EBS tables like GL_CODE_COMBINATIONS, GL_LEDGER, GL_PERIODS, GL_JE_SOURCES_TL, AP_CHECKS_ALL, AP_INVOICE_ALL, PO_HEADERS_ALL, PO_LINES_ALL, RA_CUSTOMER_TRX_ALL, SO_LINES_INTERFACE_ALL etc.

Involved in unit testing, Integration testing and User acceptance testing of the mappings.

Performance tuned Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval

Developed various T-SQL stored procedures, functions and packages.

Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager

Perform T-SQL tuning and optimizing queries for Reports which take longer time in execution SQL Server 2008.

Installed/configured Teradata Power Connect for Fast Export for Informatica.

Involved heavily in creating customized Informatica data quality plans.

Worked with address and names data quality.

Used Proactive monitoring for daily/weekly Informatica jobs.

Customized the proactive monitoring dashboard with the Informatica repository tables like OPB_SESS_TASK_LOG etc.

Resolved Skewness in Teradata

Created jobs for Informatica data replication fast clone to get data from oracle and load it into Teradata.

Wrote BTEQ scripts of Teradata extensively.

Extracted data from complex XML hierarchical schemas for transformation and load into teradata and vice versa.

Resolve syntax differences from Teradata to Oracle and documented it.

Scheduled the workflows to pull data from the source databases at weekly intervals.

Loaded HIPAA compliant X12 file to Oracle Database.

Used various performance enhancement techniques to enhance the performance of the sessions and workflows.

Created the FTP connection from Tidal to the source file server.

Retrieved data from XML, Excel, CSV files.

Archived the source files with timestamp using Tidal Scheduler.

Performance tuning on sources, targets, mappings and database.

Worked with the other team such reporting to investigate and fix the data issues coming out of the warehouse environment.

Worked as production support SME to investigate and troubleshoot data issues coming out of Weekly and Monthly Processes.

Worked with business to provide them daily production status report in the form of issues, their priority and business impact along with recommended short term and long term solution.

Environment:

Informatica Power Center 9.6, Informatica IDQ, Oracle 11g, Oracle EBS R12, Teradata 13, BTEQ, Fast load, multi load, TPump, SQL Assistant, Fast Export, Toad 10, Unix, HP-UX 11i, Toad Data modeler, Red Hat, SQL, Tidal.

Otsuka Pharmaceuticals, Princeton, NJ Jan 14– Jun 15

Sr. Informatica Developer

Otsuka is a leading pharmaceutical company. Purpose of this project was to develop a corporate data warehouse to enable the management to take corporate decisions. The project deals with building a real time view of enterprise wide data. A decision support system is built to compare and analyze services and their prices and patient profiles.

Responsibilities:

Involved in creating Logical and Physical design of databases using Erwin.

Participated in build of the Data Warehouse, which includes the Design of Data mart using Star Schema.

Created High Level and Low Level design document and ETL standards document.

Created Dimension Tables and Fact Tables based on the warehouse design.

Extracted data form flat files, DB2 and oracle database, applied business logic to load them in the central oracle database.

Involved in Extraction, Transformation and Loading (ETL) Process.

Scheduled the workflows to pull data from the source databases at weekly intervals.

Used various performance enhancement techniques to enhance the performance of the sessions and workflows.

Performance tuning on sources, targets, mappings and database.

Created reusable transformations and Mapplets and used them in mappings.

Worked on SQL queries and tuned them to improve performance.

Extensively used Shell scripts to automate the Pre-Session and Post-Sessions processes.

Performed data manipulation using basic functions and Informatica Transformations.

Environment:

Informatica Power Center 9.1.0 HF1/ 9.6.1, Informatica Data Quality 8.6.2, Informatica B2B, PL/SQL, Oracle 10g/9i, DB2, Teradata 13, SQL Server 2008 R2, Red Hat Linux,Peoplesoft ERP, SQL Developer, Sales Force dot com (SFDC), Force.com, putty, Autosys, Erwin 4.2, Perl Scripting, Power exchange, Linux Susse, Windows 2003, OBIEE.

Citi Bank, Freeport, NY Dec 12 – Jan 14

Sr. Informatica Developer

The Cargo On-Hand System (COS) Warehouse Management and Distribution System offer Operations a flexible, robust application which responds to the day to day challenges encountered in warehouse management. The application provides package level tracking, management of multiple warehouses from a central location, tight integration with the Freight Forwarding systems which provide global visibility of shipment data

Responsibilities:

Analyzed and understood business and customer requirements by interacting with Business Analysts, Data Modelers and Subject Matter Experts.

Wrote and reviewed documents like Functional Specifications, Data Mapping Sheets and Technical Specification Documents.

Prepared documents like Deployment Doc, Estimation Reports, Development tracking report and weekly status Reports .

Established standard code migration process.

Extracted data from a wide variety of sources like flat files, XML files, Relational Databases (Oracle, SQL Server) and from the legacy mainframe systems by using Informatica Power Exchange.

Involved in creation of Informatica mappings to build business rules to load data using transformations like Source Qualifier, Expression, Aggregator, Lookup, Filter, Router, Update Strategy, Normalizer, Stored procedure, XML and Sequence generator transformations.

Created User defined functions to reuse the logic in different mappings.

Extensively used mapping parameters, mapping variables to provide the flexibility and parameterized the workflows for different system loads.

Creation of sessions and workflows according to the data load in to different systems.

Data investigation in the analysis of incoming data from the various source systems, documenting the data anomalies and generating Data Quality reports.

Involved in different phases of testing like Unit, Functional, Integration and System testing.

Creation of Review documents for specification document and test cases.

Performance tuning of targets, sources, mappings and sessions.

Involved in database testing, writing complex SQL queries to verify the transactions and business logic like identifying the duplicate rows by using SQL Developer.

Environment: Informatica PowerCenter v9.5.1, Informatica DataExplorer (IDE) v8.6.1, SSIS, SQL Server, Oracle 11i,Autosys, Business Objects XI R3, Windows-XP (Client), Informatica servers on AIX Unix, SQL Developer, PL/SQL Developer. Job Agent, DB2.

Alpine Mutual Funds, Boston, MA June 11 – Dec 12

Data warehouse Analyst

Project description: This project is aimed at the implementation of Top - down data warehouse Architecture. Data of various OLTP’s was extracted from mainframe using Eztrieves and converted to flat files and finally loaded the data into the oracle database using ETL process as per the business requirements.

Responsibilities:

Implementation of Top down data warehouse architecture.

Used Eztrieves, to extract data from Mainframes and load to flat files.

Developed mappings and workflows using Informatica power center 8.1.

Involved in design, development, testing phases of ETL

Autosys on HP UNIX was used to schedule Informatica jobs.

Implemented Slowly Changing Dimensions Type II for the Change Data Capture Process

Conducted Performance Testing of the Mappings and Performance tuning with Informatica tool

Used TOAD for development of Oracle scripts and procedures

Analyzed Session Log files in case the session fails in order to resolve errors in mapping or session configurations.

Environment: Informatica 9.x, UNIX, Cognos, TOAD, Oracle 10g, Teradata

Unum, Portland, ME Aug 10 to June 11

Informatica Developer

Project Description: Worked with DaIS team in creating LTC data mart. LTC data mart helps Unum in effective in-house reporting in LTC division

Responsibilities:

Performed requirements analysis, process design, data design, development, testing and implementation of Data warehouse load processes and Data transformation processes.

Extensively worked on Informatica Power Center - Designer, Workflow Manager and Workflow Monitor.

Created Technical Specification documents using MS Visio and maintained technical specification documents throughout development lifecycle.

Created and maintained Data Models working with Data Architect.

Extensively used ETL processes to load data from various source systems such as Oracle, Sybase, Flat Files and XML into the target Oracle database by applying business logic on transformation mapping for inserting and updating records when loaded.

Extensively used Informatica Workflow Manager and Workflow Monitor to develop, manage and monitor workflows and sessions.

Extensively worked in the performance tuning of the programs, ETL Procedures and processes.

Environment:Informatica Power Center 9.x, MS Visio, Oracle 9i, MS SQL Server, Sybase, SQL, PL/SQL, TSQL, Flat Files, XML, UNIX and Erwin

Life Insurance Corporation of India, Hyderabad, India Jan 08 to July 09

Informatica Developer

The Life Insurance Corporation of India (LIC) is the largest life insurance company in India. The purpose of the project is to create a customized data mart AIP (Agency Information program) which consisted of Agency details, Policy details, and Claims/Loss details. The data mart is in star schema with Agency Fact table and several dimension tables, Policy and Claims details were laid out in flat files. The information was then transformed according to the business logic and loaded into the data mart.

Responsibilities:

Understood existing business and customer requirements.

Involved in designing the mappings between sources and targets and also tuned them for better performance.

Created Informatica Mappings to build business rules to load data using transformations like Source Qualifier, Expression, Lookup, Filter, Router and Update Strategy.

Involved in code migration from development to QA and production environments.

Extracted data from of different types of Flat files, Relational Databases Oracle.

Implemented reusable transformations, mappings, User Defined Functions, Sessions.

Implemented SCD Type 1 and SCD Type 2 methodologies to keep historical data in data warehouse.

Creation of Unit, Functional, Integration and System test cases based on Requirement Specification Documents, Use Case Docs, PDM, and User Interface Specifications.

Involved in Unit testing and System testing and prepared test plan documents

Extensively used mapping parameters, mapping variables to provide the flexibility and parameterized the workflows for different system loads.

Creation of sessions and workflows according to the data load in to different systems.

Maintained Coding standards and participated in Code Review.

Involved in Performance tuning of mapping level and session level.

Environment: Informatica Power Center v8.x, Oracle 9i, Toad 7.6, Windows XP, UNIX

Reliance Communications, Hyderabad, India Jan 07- Dec 08

Software Developer

Project Description: Migration of Data from Sql server to Oracle database and develop new informatica packages to meet new business requirements.

Responsibilities:

Involved in understanding requirements, analyze new and current systems to quickly identify required sources and targets

Involved in preparation of technical documentation, design transformations that are consistent with the goals of the existing data warehouse, and worked with the development team to implement the solution

Worked on legacy code to analyze problems, confirm requirements, and create designs, code and testing.

Experience in designing, developing, and testing Informatica extract/transform/load processes in a Data Warehouse.

Extensively worked on Mapping Parameters, Workflow Variables, Mapping Variables, and Session Parameters.

Used the Workflow Manager to create Workflows, Worklets and Tasks.

Wrote SQL over ride queries in the required transformations.

Used design and development techniques that resulted in efficient, maintainable, and high quality ETL processes.

Used problem solving skills and quickly understood relationships between data with little documentation.

Environment: Informatica Power Center 8.x, Oracle 9i, SQL, PL/SQL, Quest TOAD.

Educational Qualifications:

Bachelors in Computer, Osmania University, India.

Contact this candidate