MOHAMMED ALI

989-***-****

acg0kq@r.postjobfree.com

SUMMARY:

• Over 7+years of IT Experience with Informatica workflow, ETL, Oracle, Data Mapping,

and Transformation and loading in a complex, high-volume environment, full cycle

implementation experience as Techno-Functional Consultant.

• Expertise in Oracle, PL/SQL, UNIX Shell, QA testing and ETL tools. Extensive Application

Development using Visual Basic, VBScript, UNIX shell scripting etc.

• Experience in using Informatica Client tools: Power Center Designer, Workflow Manager,

Workflow Monitor, Repository Manager.

• Expertise in data modeling and OLAP for business analysis using Star & Snowflake schema

modelling, Fact tables and Dimensional tables.

• Expert in designing Star Schema and well versed with UNIX shell wrappers, KSH and

Oracle PL/SQL programming and stored procedures, functions, triggers and indexes.

• Involved in Performance Tuning of databases.

• Involved in High Level & Detail Design.

• Analysis on User Requirements and process flow.

• Experience in Creating Database Packages, Stored Procedures, functions, and triggers.

• Very strong in creating indexes, tuning SQL queries, and tuning indexes.

• Well versed with UNIX shell scripting with expertise in UNIX shell wrappers, KSH.

• Good programming knowledge in SQL, PL/SQL and stored procedures.

• Well versed with IMPORT/EXPORT/SQL * LOADER utilities, different kinds of joins and

partition techniques of Oracle 10g/11g

• Developed SQL scripts and tuned the queries.

• Dimensional Data Modeling experience using Data modeling, Star Join Schema/Snowflake

modeling, FACT & Dimensions tables, Physical & logical data modeling, ERWIN 3.5/3.x and

Oracle Designer.

• Involved in providing production support to various Ab Initio ETL jobs and Oracle Database

programs.

• Almost 2 years of experience in a dual role as Programming and Business Analyst.

TECHNICAL SKILLS:

• ETL: Informatica Power Center 9.1, 8.x, 7.x (Designer, Workflow Manager, Workflow

Monitor, Repository Manager, Repository Server,

• OLAP: Business Objects Supervisor/Designer/BO 5.1.4/5.1.1, Cognos

• Databases: Teradata V2R4, Oracle 11g/10g/9i/8i/8/7.3, SQL Server 7.0, UDB DB2

• Programming: SQL, PL/SQL, T-SQL, UNIX Shell Scripting, C, C++

• GUI Tools: Developer 2000 (Forms 6i/5/4.5 & Reports 6i/3/2.5), SQL*Loader

• Operating System: Windows NT 4.0, MS-DOS, Sun Solaris 8.0, HP-UX, OS/400

PROFESSIONAL EXPERIENCE:

GenRe/TCS, Stamford, CT, July 2014 – Till date

IT/ SUPPORT ANALYST- SQL/ETL DEVELOPER

Responsibilities:

• Involved in complete understanding of business requirement and involved in analyzing the

sources to load in Oracle warehouse.

• Interacting directly with client and business Users for understanding the issues and resolving

the MR (Maintains Request) and SR (Services Request)

• Provides Support for Informatica implementation

• Provides Support for Informatica Cloud implementation

• Driving big offshore team

• Communicating between Businesses, various project team and application support

team

• Responsible to manage Development, QA and Production environments and making sure that

code is sync in all the three environments.

• Monitoring the loads (workflows) whether the loads are scheduled to respective timings

• Recovery or Re-start in loads in case of any failures.

• Identifying the tardiness in loading process in case of any sessions are in hung status

• Designed Sources to Targets mappings from SQL Server, Excel/Flat files to Oracle using

Informatica Power Centre.

• Responsible for working with DBA and Data Modellers for project coordination.

• Responsible for Detail design of each interface.

• Responsible for developing complex Informatica mappings using different types of

transformations like UNION transformation, Connected and Unconnected LOOKUP

transformations, Router, Filter, Aggregator, Expression and Update strategy transformations

for Large volumes of Data.

• Implemented slowly changing dimension Type 1 and Type 2 for Change data

capture using Version control.

• Responsible for creating Workflows and sessions using Informatica workflow manager and

monitor the workflow run and statistic properties on Informatica Workflow Monitor.

• Responsible for Defining Mapping parameters and variables and Session parameters

according to the requirements and performance related issues.

• Created various tasks like Event wait, Event Raise and E-mail etc

• Created Shell scripts for Automating of Worklets, batch processes and Session schedule using

PMCMD

• Tuning the Informatica mappings to increase the performance.

• Wrote test plans and executed it at UNIT testing and also supported for system testing,

volume testing and User testing. Also provided production support by monitoring the

processes running daily

• Extracted Data from FACETS Database.

Environment: Informatica Power Center 9.1/8.6, Oracle 11g, Sybase, Mainframe, Erwin, Unix,

Rapid SQL

Fannie Mae, Herndon, VA, January 2014 – June 2014

IT/ SUPPORT ANALYST- SQL/ETL DEVELOPER

Responsibilities:

• Involved in complete understanding of business requirement and involved in analyzing the

sources to load in Oracle warehouse.

• Designed Sources to Targets mappings from SQL Server, Excel/Flat files to Oracle using

Informatica Power Centre.

• Responsible for working with DBA and Data Modellers for project coordination.

• Responsible for Detail design of each interface.

• Responsible for developing complex Informatica mappings using different types of

transformations like UNION transformation, Connected and Unconnected LOOKUP

transformations, Router, Filter, Aggregator, Expression and Update strategy transformations

for Large volumes of Data.

• Developed SDE mappings to load large amount of data from different sources to staging area,

SID mappings for load the data from staging area to target system

• Implemented slowly changing dimension Type 1 and Type 2 for Change data

capture using Version control.

• Responsible for creating Workflows and sessions using Informatica workflow manager and

monitor the workflow run and statistic properties on Informatica Workflow Monitor.

• Responsible for Defining Mapping parameters and variables and Session parameters

according to the requirements and performance related issues.

• Created various tasks like Event wait, Event Raise and E-mail etc

• Created Shell scripts for Automating of Worklets, batch processes and Session schedule using

PMCMD

• Created various Oracle database SQL, PL/SQL objects like Indexes, stored procedures,

views and functions for Data Import/Export.

• tuning the Informatica mappings to increase the performance.

• Wrote test plans and executed it at UNIT testing and also supported for system testing,

volume testing and User testing. Also provided production support by monitoring the

processes running daily

• Extracted Data from FACETS Database.

• Worked on creating HIPAA files from SQL Server database.

Environment: Informatica Power Center 9.1/8.6, MS SQL server 2005, Oracle 10g, Data quality,

Toad, PL/SQL (Stored Procedures, Triggers, Packages), Erwin, MS Visio, Windows XP

AT & T, Edison, NJ, Oct 2012 – Dec 2013

ETL Analyst/ETL Developer

Responsibilities:

• Involved in Requirement Analysis, ETL Design and Development for extracting the data

which is stored in different sources like Oracle, SQL Server, Sybase, and DB2.

• Analyzed, designed and developed an environment that would facilitate the use of Informatica

to transform data coming from Igrasp oltp into Adim datamarts.

• Developed complex Informatica Mappings with transformations like lookup, router,

aggregator, expression, update strategy, joiner and etc.

• Created Connected, Unconnected and Dynamic Lookup transformations for better

performance.

• Created sessions, worklets, workflows for the mapping to run daily, biweekly based on the

business requirements.

• Extensively used Parameter files, mapping variables in the process of development of the

mappings for all the dimension tables.

• Implemented Slowly Changing Dimension type2 methodology in Informatica.

• Worked on handling performance issues of Informatica Mappings, evaluating current logic for

tuning possibilities.

• Tuned SQL, PL/SQL Queries in Source qualifier Transformation for better performance.

• Created and executed unit test cases for various scenarios for all the mappings, workflows and

scripts.

• Involved in unit testing and fixing the bugs identified, provided data to the reporting team for

their daily, weekly and monthly reports.

• Worked on modification of UNIX shell scripts.

• Involved in team weekly and by monthly status meetings.

Environment: Informatica PowerCenter8.5, Oracle10g, Toad, SQL, PL/SQL (Stored Procedure,

Trigger, Packages), Erwin, MS Visio, Windows 2000, UNIX.

SPRINT PCS, KS, Jan 2010 – Aug 2012

Informatica Developer

Responsibilities:

•Developed Logical and physical database designs for the transaction system.

•Extract the XML file from source transform it with multiple transformation including XML

Transformation.

•Performance tuning on sources, targets, mappings and SQL queries in the transformations.

•Used PL/SQL Views, Triggers, Procedures and Functions.

•Designed and developed complex ETL mappings making use of transformations like Source

•Qualifier, Expression, Joiner, Update Strategy, Connected Lookup and unconnected Lookup,

Rank, Router, Filter, Aggregator and Sequence Generator transformations.

•Created reusable transformations and mapplets based on the business rules to ease the

development.

•Developed mappings to implement type 2 slowly changing dimensions.

•Developed and implemented the Unix shell script for the start and stop procedures of the

sessions.

•Used various Informatica Error handling technique to debug failed session.

•Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision

Used various debugging techniques to debug the mappings.

•Created Test cases for Unit Test, System Integration Test and UAT to check the data quality.

•Created Materialized view for summary data to improve the query performance.

Environment: PowerCenter8.1,Oracle9i, SQL Server 2000, SQL,PL/SQL, shell scripts, MS

Visio, ERWIN Data Modeling tool, Toad 8.0, Windows 2000,XML,UNIX

Proctor & Gamble, Cincinnati, OH, Jun 2007 – Dec 2009

Informatica Developer

Responsibilities:

• Extensively used Informatica client tools – Source Analyzer, Warehouse designer, Mapping

designer, Mapplet Designer, Transformation Developer.

• Developed complex mapping using Source qualifier, Aggregators, Connected & unconnected

lookups, Filters & Update strategy.

• Used Lookup Transformation to access data from tables, which are not the source for mapping

and also used Unconnected Lookup to improve performance

• Developed reusable Mapplets and Transformations.

• Good knowledge on fixed income Derivatives and foreign exchanges also.

• Responsible for transport the data to Target Warehouse Oracle tables on the server, Schedule,

Run Extraction and Load process and Monitor sessions by using Informatica workflow

manager and workflow monitor

• Create and Administer Repositories using Repository manager of Informatica.

• Worked on creating HIPAA files from SQL Server database.

• Also involved in moving the mappings from Test Repository to Production after duly testing

all transformations.

• Calculated the Cache requirements for Lookup, Joiner and Aggregator transformations and

increased the memory on Informatica server to avoid the paging to the disc.

Environment: Informatica Power Center 7.1, Oracle 9i, UNIX, Sybase, MS SQL Server 2004,

Windows 2000

TechMahinder Ltd, India, Oct 2005 - Apr 2007

Programmer/Analyst

Responsibilities:

• Involved in gathering Business requirements and technical aspects for development.

• Involved in deciding the architecture strategy, design of the physical and logical models of the

data warehouse as well as two dependent data marts.

• Scheduling, monitoring, coding and testing of custom PL*SQL modules to load data into the

data warehouse from the legacy systems.

• Extensively used all the features of Informatica Versions 6.x and 7.x including Designer,

Workflow manager and Repository Manager, Workflow monitor.

• Interpreted logical and physical data models for Business users to determine common data

definitions and establish referential integrity of the system.

• Worked with mappings using expressions, aggregators, filters, lookup, update strategy and

stored procedures transformations.

• Partitioned sources to improve session performance.

• Created users in Informatica, assigned them various permissions.

• Backup/Restoration of repositories.

Environment: Informatica PowerCenter6.1, Oracle7.0, SQL, PL/SQL, Oracle Designer,

Business Objects

Contact this candidate