Data Migration/Integration/Informatica,Data Warehousing, ETL, Database
Resume:
Md Rajaul K Khan(Raja)
**********@*****.***
PROFESSIONAL SUMMARY:
Over 11+ years of total IT experiences and 10+ years of progressive experience in full life cycle development in of Data warehouses (Analysis, Design, Modeling, Development, Implementation and Testing) as an ETL developer, Informatica Team Lead and Data Integration/Migration Lead.
Proven experience and Solid understanding of Data Warehousing, Decision Support Systems (DSS), and OLAP and Business Intelligence skills and data migration, Data Integration.
Extensively worked in ETL process consisting of Data Analysis, Data Modeling, Data Cleansing, Data Transformations, Integration, Migration, Data import/Export, Mapping, Conversion.
Strong ETL experience in using Informatica Power Center 9.6.1/9.5.1/8.6.1/ 8.6.0/8.5.1/8.1, Power Mart. Power Exchange and Power connect for SAP/R3 or BCI. (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Informatica cloud to Develop, Test, Debug and Tuning mappings, Sessions and Workflows for ETL Process.
Strong experienced in handling XML files through Informatica and Java/Web Service with Informatica.
10+ years of experience in Conceptual, Logical & Physical Data modeling using tools like Toad, Erwin and SQL Developer.
Experience in Dimensional Data Modeling, Star Schema, Snow Flake, Fact & Dimension tables.
Strong experience in handling various databases like DB2, Oracle 11g/10g/9i/8i/8.0, SQL Server 2004/2008, MySQL and MS Access.
Extensive experienced in PL/SQL Cursors, Procedures/Functions, Triggers and Packages.
Experience in writing UNIX shell scripts for file transfers, file manipulation, automation of ETL jobs and Pre-Session and Post-Session Command.
Experience in performance optimization of Database and ETL process.
Experience in scheduling toll like Auto-Sys, Tidal.
Extensively worked in SAP Integration/Migration Project using ETL (Informatica); Built Interfaces (Inbound/Outbound) or Data migration using BCI, LSMW, RFC, BAPI, WinShuttle and IDOC through Informatica to load data into SAP-CRM, SAP ECC(MM. PS, SD, AP), SAP BW from Source System (Oracle, DB2, SQL Server, MySQL), Mainframe and.
Excellent ability to lead a group or work in groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.
Hands on experience on loading data in SAP through LSMW, Custom Program, BODS, processing IDoc and testing data in SAP (MM. PS, SD, AP, CRM) other SAP Object using different transaction code.
EDUCATION: MS in Computer Science (University of Texas at Dallas)
TECHNICAL SKILLS:
ETL Tools: Informatica Power Center 9.x/ 8.x/7.x, Power Exchange 9.x/8.x, (Designer, workflow manager, Monitor and Repository manager, SSIS, SSAS,SSRS.
Other Tools: TOAD, SQL Developer, Erwin, Eclipse, Rational Rose, MS Visio 2007., MS Project 2003,Tidal, Auto-Sys.
Database: Oracle 12c/11g/10g/9i/8i/8.0, MS SQL Server, DB2, MS Access 2000/7.0/6.5. MySQL
Programming Languages: J2SE, C, C++, Python, SQL, PL/SQL.
Scripting Language: UNIX Shell Scripting (Bash and Korn Shell), Python, Perl.
Software Modeling/Designing: UML (Use Case, Domain Model, Use Case Realizations, Class and Sequence Diagrams, Activity Diagram) RUP (Rational Unified Process), Design Patterns, MVC.
Testing: Test Scripts, Test Cases, Unit Testing, Functional Testing, Integration Testing, Black-box & White-box, Smoke Testing.
Operating Systems: Microsoft Windows (x), Windows Server, UNIX, Sun Solaris 5.8. Linux.
PROFESSIONAL EXPERIENCE:
Costco Wholesale, Issaquah, WA Jul 14 to CURRENT
Data Integration/Migration/ETL Lead
Costco Wholesale is one of largest retail club in USA and its' Business is rapidly expanding to worldwide. The COSMOS project is to replace the existing legacy (AS400) system with SAP for CRM, HR and FINANCE by modernize the business to make better Strategic Decision, Customer Relationship and Financial Management which will allow a cost-effective, efficient solution for the company. It also use the finance data from SAP to enhanced the existing Data warehouse. Data were extracted from AS-400, DB2, SQL server, Mainframe, Third party feed (XML format) and Java based application and loaded to SAP using IDoc/ BAPI/RFC/LSMW by applying Business logic. The project required Inbound/Outbound interfaces and Data conversion.
Responsibilities:
Leading Conversion/Interface team (Onsite/Offshore) of various fields like Mainframe, ETL (Informatica, BODS) and SAP.
Supervising the whole conversion process for all rehearsals/cycles as Data Migration/Integration lead.
Overseeing the inbound and outbound interfaces development process by closely working with functional, developer and tester.
Conducting/Attending Regular/Adhoc meeting with project teams to update daily status, or escalate issues and concerns.
Conducted team meeting/Conference call (with Offshore) with team member to assign the work and get the update of assigned task.
Helping PMO with the creation of Project time and resources Management.
Involved with the Business analysts in requirements gathering, analysis, testing, and project coordination.
Prepared standard design documents, Technical Specification, ETL Specifications and Migration documents.
Designedand reviewed the Interface/Conversion code before move to QA to ensure design standard is met.
Maintained daily Tech Tracker/Issue logs for the updates and issues related to objects and progress.
Designed and implement a scheduler to run the interfaces at different time using Shell Scripting in UNIX.
Solved various performance and complex logic related issues with effective and efficient solutionin the ETL process (performance tuning) and identified various bottlenecks and critical paths of data transformation in sessions for different Interface.
Developed Workflow, Session and mapping to load heterogeneous data into SAP using BAPI'S, RFC’s and IDOC'S with Power Connect & also used Power exchange for DB2/SQL serverVise Versa.
Created Mapping to extract data from SAP (CRM, ECC)tables directly using SAP/R3 for outbound interfaces.
Load data into SAP using Win-Shuttle, by Processing IDoc, LSMW and Custom Programs.
Design Star and SnowFlake schema and write ETL code to load data to Dimension and fact tables.
Design the validation process for conversion//migration using BODS for data accuracy and consistency.
Designed naming and design standards document for future enhancement for interfaces.
Used different transformations like Connected & Unconnected Lookup, Connected & Unconnected Stored Procedure, Router, Aggregator, Normalizer, Source Qualifier, Joiner, Expression, Update Strategy, Aggregator and Sequence generator, Transaction ControlTransformations to data conversion before loading to Target.
Created Reusable Mapplet for time saving development for interfaces.
Performed different type testing proactively to identify data anomalies and inaccuracies by using Unit, Integration and Smoke testing.
Performed various Performances Tuning activities at Database level (source, target, Look Up), Informatica level (workflows, mapping and session) as well as database level in Oracle, SQL Server, My-SQL using Sql developer and T-SQL.
Environment: Informatica Power Center 9.6.1/9.5.1, Informatica Power Exchange 9.6.1/9.5.1,Oracle 11g/12c, SAP R/3 7.1,SQL Server, T-SQL, My-SQL DB2, PL/SQL,AS400, SQL developer, AIX/UNIX.
Warner Bros., Burbank Feb12 to June 14
Sr. Informatica Consultant (Team Lead)
The project COSMOS (ITD) in Warner Bros. is to replace the aging legacy system with SAP for Strategic Decision Making, Customer Relation and Financial Management which will allow a cost-effective, efficient solution for the company. SAP’s new solution IPM (Intellectual Property Management) was implemented with CRM, ECC. Data were extracted from Oracle, DB2, SQL Server, Mainframe and Java based application and loaded to SAP using IDocs/ BAPI/RFC. The project required Inbound/Outbound Interfaces and Data Migration.
Responsibilities:
Designed the Whole EAI (Middleware) Architecture for the Project COSMOS based on given requirement in compliance with IMCC (Information management Competency Center) standard.
Managed a team of 4-6 resources (Onsite/Offshore). Attended Regular/Adhoc meeting with project team to update daily status, or escalate issues and concerns.
Conducted team meeting/Conference call (with Offshore) with team member to assign the work and get the update of assigned task.
Involved with the Business analysts in requirements gathering, analysis, testing, and project coordination.
Prepared standard design documents, Technical Specification, ETL Specifications and Migration documents.
Leading the ETL (Informatica) team to convert Legacy data to SAP applying given business logic.
Designed and developed the Interfaces by implementing given business logic within the given time frame.
Maintained daily Tech Tracker/Issue logs for the updates and issues related to objects and progress.
Designed and implement a scheduler to run the interfaces at different time using Shell Scripting in UNIX.
Solved various performance and complex logic related issues with effective and efficient solution in the ETL and Database process and identified various bottlenecks and critical paths of data transformation in sessions for different Interface.
Responsible for Data Cleansing and Data Quality checks using Informatica Data Quality (IDQ).
Developed mapping to load heterogeneous data into SAP using BAPI'S, RFC’s and IDOC'S with Power Connect & also used Power exchange for DB2/SQL serverVise Versa.
Use Web service to for data transmission.
Responsible for create mapping for Hand shaking within the Legacy-Middleware EAI-SAP.
Created Mapping to extract data from SAP (CRM, ECC) tables directly using SAP/R3.
Designed and maintained naming and design standards document for future enhancement.
Extracted data from various sources such as SQL server, DB2UBD, Flat Files, Mainframe, Oracle and SAP
Used Java Transformation by written java code in Informatica to implement Complex Business Logic.
Used different transformations like Connected & Unconnected Lookup, Connected & Unconnected Stored Procedure, Router, Aggregator, Normalizer, Source Qualifier, Joiner, Expression, Update Strategy, Aggregator and Sequence generator, Transaction Control Transformations to data conversion before loading to Target.
Created Reusable Mapplet for time saving development.
Created and Monitored workflows/sessions using Informatica Server Manager/Workflow Monitor to load data into target Oracle database.
Performed different type testing proactively to identify data anomalies and inaccuracies by using Unit, Integration and Smoke testing.
Performed various Performances Tuning activities at Database level (source, target, Look Up) and Informatica level (mapping and session) and database level with T-SQL and Sql developer and Toad.
Perform production support for the stabilizing period. Resolving production issue (ITSM) retest and deploy
Environment: Informatica Power Center 9.6.1/9.5.1/8.6.1 Informatica IDE/IDQ 8.6, Informatica Power Exchange 9.5.1/8.5.1/8.6.1,Oracle 10g/11g, SAP R/3 7.1, SQL Server, DB2, PL/SQL, AIX/UNIX, WindowsNT4.0.
Takeda PHARMACEUTICAL, Chicago NOV 11 to FEB 12
Sr. Informatica Consultant (Team Lead)
Takeda is one of the leading multinational pharmaceutical companies producing life saving drug. The project was creating data warehouse for its production, marketing and staff controlling data which enable them to easily analyze forecast and report for strategic decision. All user form all branches around the world enter the day to day data to the system which in turn analyze and use for reporting purposes. That enabled leadership of Takeda has better understanding of performance of the company's all departments. This project was to enhance the existing data ware house for financial analysis.
Responsibilities:
Interacted with the Business client to analyze the business requirements.
Collected Business requirement are transformed into the technical requirements.
Lead a team of 4 (onsite/Offshore) for the enhancement project.
Attended Regular/Adhoc meeting with project team to update daily status, or escalate issues and concerns.
Conducted team meeting/Conference call (with Offshore) with team member to assign the work and get the update of assigned task.
Designed different Cube, Fact and Dimension tables according to the business requirement for enhancement.
Designed and built Simple to complex mappings to populate all those Fact and dimension tables using various transformations like Source Qualifier, Filter, Expression, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator, Joiner Transformations and Router Transformation, SQL Transformation, Transaction control Transformation and etc.
Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
Used Informatica Workflow Manager to Create and Run Sessions, Tasks, Worklets and Workflows and scheduling them to run at specified time.
Wrote pre-session and post-session Stored Procedures/SQL to drop the indexes, to re-create the indexes, and to joins in the database.
Extracted data from multiple sources like Oracle, SQL Server and Flat files.
Used DB tools like TOAD to run SQL queries and verify and validate the loaded data in target tables.
Involved in identifying Performance issues, bug and fixing them in existing mappings by analyzing the data flow, evaluating transformations to eliminate inconsistency and inaccuracy and latency.
Involved in Debugging, Troubleshooting, Testing, and Documenting of the built application.
Fine tuned the existing Informatica mappings to improve the performance.
Translate lots of Store Procedures and Functions to Informatica Code.
Wrote Shell scripts to scheduled workflowin Scheduler.
Supported the current Production System in resolving the ITSM Tickets.
Environment: Informatica Power Center 8.6.1, DB2 UDB, Oracle 8i/9i, SQL/PLSQL, UNIX Shell Programming, UNIX and Windows 2000 Server.
Warner Bros., Burbank NOV 09 to NOV 11
Sr. Informatica CONSULTANT (TEAM Lead)
The project COSMOS (DTD) in Warner Bros. was to integrate few of existing system (STARS, UpDocs, ITS) with SAP for strategic decision making, Customer Relation and Financial Management for Domestic Television Distribution (DTD). This will allow a cost-effective, efficient solution for the company. Data were extracted from DB2, Oracle, SQL server and mainframe based application and converted in IDoc to load into SAP. In the project, EAI was the middle ware where all the statistical data were populated and maintained using STAR Schema.
Responsibilities:
Designed the Whole EAI (Middleware) Architecture for the Project COSMOS based on given requirement.
Involved with the Business analysts in requirements gathering, analysis, testing, and Project coordination.
Prepared standard design documents, Technical Specification, ETL Specifications and Migration documents.
Designed and implement a scheduler to run the interfaces at different time using Shell Scripting in Unix
Designed all the Interface/Conversionwith implementing given business logic within the given time frame.
Maintained daily Tech Tracker/Issue logs for the updates and issues related to objects and progress.
As team lead attended Regular/Adhoc meeting with project team to update daily status, or escalate issues and concerns.
Conducted team meeting/Conference call (with Offshore) with team member to assign the work and get the update of assigned task.
Solved various performance and complex logic related issue with effective and efficient solutionin the ETL process (performance tuning) and identified various bottlenecks and critical paths of data transformation in sessions for different Interface.
Conducted and attended regular meeting conference call with managers and resources (onshore and offshore) on update as well as issues.
Developed mapping to load heterogeneous data into SAP using BAPI'S, RFC’s and IDOC'S with Power Connect & also used Power exchange for DB2/SQL serverVise Versa.
Responsible for create mapping Hand shaking within the Legacy Middleware EAI and SAP using SAP/R3
Responsible for data cleansing and data quality checks using Informatica Data Explorer and Informatica Data Quality 8.6.
Designed and maintained naming and design standards document for future enhancement.
Extracted data from various sources such as SQL server, DB2UBD, Flat Files, Mainframe, Oracle and SAP using Informatica Power Exchange.
Used Java Transformation by written java code in Informatica to implement Complex Business Logic.
Used different transformations like Connected & Unconnected Lookup, Connected & Unconnected Stored Procedure, Router, Aggregator, Normalizer, Source Qualifier, Joiner, Expression, Update Strategy, Aggregator and Sequence generator, Transaction ControlTransformations to data conversion before loading to Target.
Created and Monitored workflows/sessions using Informatica Server Manager/Workflow Monitor to load data into target Oracle database.
Performed different type testing proactively to identify data anomalies and inaccuracies by using Unit, Integration and FAT testing.
Performed various performances tuningactivity at source, target, mapping and session level.
Environment: Informatica Power Center 8.6.1/8.6.0 Informatica IDE/IDQ 8.6, Informatica Power Exchange, 8.5.1/8.6.1,Oracle 10g/11g, SAP R/37.1,SQL Server, DB2, PL/SQL, AIX/UNIX, WindowsNT4.0.
BNSF RAILWAYS, Fort Worth, TX May 08 to Oct 09
Sr. Informatica Developer
BNSF Railway is one of the largest transportation (Rail) businesses in the United States with more than $15 billion in annual revenues operating through 28 most western states. Its existing Financial and HR payroll systems (Millennium and Tesseract respectively) are ageing, becoming more complex and costly to maintain and are subject to a degree of operational risk. The purpose of this project is the enhancement of the Envision (migration from Millennium to SAP financial package) for applicable business processes to provide external and internal users with reliable, timely and accurate data that can be easily analyzed. Hence it selects SAP as its future strategic ERP platform. Finance and HR/Payroll will be the first BNSF functions to be implemented on the SAP platform and Informatica is used for all automated conversion load routines required for this system.
Responsibilities:
Involved with the Business analysts in requirements gathering, business analysis, testing, and project coordination.
Extensively involved in translating Business requirement to Technical requirements.
Prepared standard design documents, ETL Specifications and Migration documents.
Responsible for DesigningInterface/ConversionAs SME in Informatica..
At one point of the project Worked as Team lead of 5/6 (Onsite/Offshore)Informatica developer.
Attending regular meeting with manager and resources on update as well as issues for onshore and offshore resources.
Maintained daily Tech Tracker for the updates from the team regarding their objects, issues and progress.
Provided various insights into how to manage performance in the ETL process (performance tuning) and identified various bottlenecks and critical paths of data transformation in sessions for different Interface.
Responsible for create mapping to loading the data into SAP using BAPI'S, RFC’s and IDOC'S with Power Connect & also used Power exchange for DB2 Vise Versa.
Responsible for create mapping (Out bound) to extract data from SAP to legacy system using SAP/R3 or BCI.
Responsible for data quality checks using Informatica Data Explorer and Informatica Data Quality 8.6.
Informatica B2B Data Transformation for comprehensive transformation of unstructured data.
Used Informatica power exchange to extract the data from Mainframe.
Responsible in strictly maintaining naming,design standards and warehouse standards for future enhancement.
Extracted data from various sources such as Flat Files, Mainframe, DB2UBD, SAP and Oracle using Informatica Power Exchange.
Implemented Complex Business Logic using java Transformation by writing java Code in Informatica.
Used different transformations like Connected & Unconnected Lookup, Connected & Unconnected Stored Procedure, Router, Aggregator, Normalizer, Source Qualifier, Joiner, Expression, Update Strategy, Aggregator and Sequence generator Transformations to data conversion before Loading to Target.
Created Reusable Mapplet for time saving development.
Created and Monitored workflows/sessions using Informatica Server Manager/Workflow Monitor to load data into target Oracle database.
Performed Acid Tests on Functional Specifications and Technical Specifications
Performed Unit testing, Integration Testing, and User Acceptance testing to pro-actively identify data discrepancies and inaccuracies.
Involved in performance tuning at source, target, mapping and session level.
Delivered and sign-off of deliverables pertaining to the Transactional Data warehouse.
Introduced the concept of Data Dashboard to track the technical details sighting the continuous requirement changes and rework needed.
Design and implement Error handling system (EEMS) and Auto recovery system.
Involved in providing Informatica Technical support to the team members, as well as, the business.
Coordination and Leading the offshore in development activities.
Environment: Informatica Power Center 8.5.1/8.6.1,Informatica IDE/IDQ 8.6, Informatica Power Exchange, 8.5.1/8.6.1,Oracle 10g/11g, SAP R/37.1, SAP, DB2UBD 4.0, PL/SQL,UNIX, WindowsNT4.0.
Sprint PCS, Dallas, TX SEPT 07 to APR 08
Sr. Informatica Developer
Sprint is one of the largest wireless companies in the United States, with more than 30 million subscribers uses the nation's largest digital voice and data network. This project deals with the Data Migration of legacy to oracle database. Data from Flat Files are loaded to Oracle Inbound staging and outbound areas using Informatica.
Responsibilities:
Participated in all phases including Analysis, Design, Coding, Testing, Production Support and Documentation.
Involved in the meetings with the business analysts & SIEBEL Developers in gathering & analyzing the requirements.
Extraction, Transformation and Load was performed using Informatica Power Center to build the Data Warehouse
Involved in preparing detailed ETL design documents, Unit Test plans for the mappings.
Worked on Informatica PowerCenter 7.1.1. Designer to develop mappings for different stages like Flat Files to Inbound, Inbound to Outbound, and Outbound to EIM tables in Oracle.
Developed complex mappings in Informatica PowerCenter to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter and Router
Exclusively worked on different transformations for populating data from Oracle Inbound tables to Oracle Outbound tables.
Extensively involved in performance tuning at source, target, mapping, and session and system levels.
Developed several reusable transformations and mapplets that were used in other mappings.
Performed Unit level testing of Mappings developed.
Worked on UNIX environment and validated the data in the flat files, counting the records in the flat files residing on UNIX box, etc.
Environment: Informatica Power Center 7.1.1, UNIX, Oracle 8i/9i, SQL Server, SUN Solaris, TOAD 8.0, Windows NT.
CNA Insurance, parsipanny, NJ jan 07 to AUG 07
ETL Analyst
CNA Insurance, a major insurance company offersvarious kinds of services in insurance field like Life & Annuities, Property & Casualty. The purpose of the project was to build EDW LIFE warehouse for capturing data from different source systems and loading them into staging area ODS & Dmart those are used for analysis & reporting purposes.
Responsibilities:
Maintained warehouse metadata, naming standards and warehouse standards for future application development.
Involved in Data Quality Analysis to determine cleansing requirements.
Designed and developed Informatica mappings for data loads.
Used various active and passive transformations for data control and cleansing, reusable transformations and Mapplets.
Wrote PL/SQL code using the technical and functional specifications.
Designed and developed UNIX scripts for scheduling the jobs using PMCMD.
Responsible for the Dimensional Modeling and populated the business rules using mappings.
Used Erwin to view the existing data model.
Tuning Informatica Mappings and Sessions for optimum performance.
Responsible for Unit testing of the mappings developed.
Prepared design documents, ETL Specifications and migration documents.
Interacted with production/DBA team while migrating from QA to production.
Environment:Informatica Power Center 7.1, Oracle 9i/8i, SQL SERVER 2000, DB2 UDB V8.0, PL/SQL, SQL*Plus, BO 6.0, ERwin, Windows 2000, UNIX.
data soft System, Dhaka, Bangladesh Jan 03to May06
Software developer
Data soft System is one leading and pioneer Software solution provider in Bangladesh. The project scope is to develop a Data Mart and Reporting System to analyze the sales of company products & services in different regions. The source data for the data mart is mapped to legacy applications, The data is extracted from the source databases and loaded into Oracle Data Warehouse using Informatica as ETL tool.
Responsibilities
Involved in building Enterprise wide Logical and Physical models using ERwin.
Understanding of business information requirements for data models.
Discussed business requirements and mapped business needs.
Designed and constructed the pre-staging tables to populate from different source system.
Created and managed the local & global repositories and permissions and assigned privileges to users and groups using Repository Manager.
Written PL/SQL packages, procedures and functions and developed Informatica Mappings to perform test loads.
Involved in Preparing Source-Target Mappings documents to provide the logic for Informatica mappings development.
Used Transformations like Source Qualifier, Joiner, Aggregator, Expression, Router, Lookup, Update Strategy, and Sequence Generator etc.
Created tasks, workflows and worklets using workflow manager. Monitored workflows and worklets using workflow monitor. Tuned Mappings and Sessions by identifying the bottlenecks for optimal performance.
Environment: Informatica PowerCenter 5.0 ERwin 3.5.2, MS SQL Server 7.0/2000, Oracle 8i, Shell Scripting, SQL, PL/SQL, Autosys, Toad, Sun Solaris 2.6, Windows 2000 Server
Contact this candidate