Develop complex Informatica mappings to load the data from various sources using different transformationslike source qualifier, connected and unconnected lookup, update Strategy, expression, aggregator, joiner,filter, normalizer, rank and router. Develop OLAP applications using Cognos 8Bi and extracted data form theenterprise data warehouse to support the analytical and reporting for Corporate Business Units.
An excellentteam player with business users, program managers, and team leads, architects and other team membersmaintaining healthy work environment, able to grasp things quickly with analytical and problem solving
Access, Word, Excel, PowerPoint, Project, Outlook
SQL Script Generation and SQL Querying
EDI Formats, Teradata, Datastage
Structured Query Language (SQL)
Oracle, TOAD, MYSQL, Microsoft SQL, T - SQL
Windows 7, Windows 8, Windows XP
Involved in all stages of the SDLC process including requirement gathering, design, development,testing, production, user and support for production environment. SSIS experience
Generated new mapping designs using assorted tools in Informatica Designer, such as Source,analyzer, Mapping Designer, Warehouse Designer, and Mapplet Designer.
Developed the mappings using needed Transformations in Informatica tool according to technicalSpecifications in Informatica PowerCenter.
Created composite mappings that involved execution of Business Logic to pack data in to staging area.
Generated Worklets, Workflow and Tasks to schedule the loads at demanded frequency usingWorkflow Manager.
Developed utile email correspondence in Workflow manager for process exception handling.
Participated in user meetings, gathered Business requirements & specifications for the data warehousedesign. Translate the user inputs into ETL design docs.
Optimized performance tuning at source, target, mapping and session level.
Strong knowledge of logistics organization, stock control system, storage management, andmanagement improvement.
Skilled at learning new concepts efficiently, works well under pressure and always ensure all deadlines are met.
Extracted data from Oracle and SQL Server then used Teradata from data warehousing.
Communicates ideas clearly and effectively.
Ability to follow directions and established procedures.
Responsible for designing ETL data enterprises to automate loads base on client requirements.
Use of the Common DataStage v8.0 ETL Framework for all ETL projects.
Implemented slowly changing dimension methodology for accessing the full history of accounts.
Engaged in-weekly status meetings, and coordinated internal and external reviews, as well as formawalk through among various teams.
Write Shell script running workflows in Unix environment.
Recorded all proceedings and data, Informatica Cloud and PowerCenter
Date integration with scalability, automation and reuse on the AWS Cloud configuration dataintegration solution that can process billions of records, Informatica PowerCenter logics.
Work with American Electric Power AEP as ETL integration team as technologies and frameworks experience, tools such as informatica, DataStage, Data flow automation and scripting.
IT Inventory Control Manager
Established procedures and controls to assure the accuracy of over ten million dollars of inventory daily.
Prepared and monitored the operational budgets.
Supervised a staff of more than 200 people of diverse backgrounds
Formulated and executed pioneering order supply and tracking inventory control procedure.
Provide necessary actions for recruitment,, and evaluation of newly appointed personnel.
Ensured essential inventory, accounting, and purchasing rules/regulations were followed and provided