SUMMARY:

• Proven Success in Data Integration and Strategic IT Solutions
• Seasoned ETL Leader with 15 (+) years of Global IT experience and Technical proficiency in ETL Design and Implementation of Data Warehouse /Data Mart solutions teamed with Business Requirements Analysis, Development, Testing and Documentation.
• Extensive (11+) years of strong Data Warehousing experience, ETL and Data Integration experience in Designing and Developing ETL mappings and scripts using IBM InfoSphere DataStage (11.X, 8.X, 7.X), Information Analyzer, Fast Track, MetaData Server and Informatica PowerCenter 7.1/6.2/6.1/5.2/5.1 and PowerMart 7.1/6.2/6.1/5.2/ ETL tools.
• Proven ability to create and deliver end - to-end Data Integration solutions tied to business growth, Application Modernization and Process Automation. Skilled problem identifier and troubleshooter comfortable managing multiple systems, projects and teams in a dynamic IT environment.
• Solid experience in Analysis of Source Systems, building Staging area & designing Target systems. Extensively worked on the ETL mappings Design, Analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Performed Business Requirements Analysis, Prepared ETL standards, Naming conventions and wrote ETL flow Documentation in high visible, global distributed projects for Telecommunication and Banking Industries.
• Experienced in using Oracle 10.1/9i/8i/7.x, MS SQL Server 2000/7.0/6.5 , Sybase SQL Server 12.0/11.x, Teradata V2R5/V2R4, DB2, UDB, MS Access 7.0/2000, IMS Data, Erwin, SQL, PL/SQL, SQL*Plus, Sun Solaris 2.x, HP-UX, AIX, SCO-UNIX, Sun-Ultra, Sun-Sparc
• Proficient in Error Handling, Bug fixing and Performance Tuning of ETL mappings.
• Associated with Production support team in various performances related issues and worked with testing team in Unit, Integrated testing and UAT.
• Excellent analytical and logical programming skills with a good understanding Confidential the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals. Excellent written and verbal communication skills including experience in proposal and presentation creation.

TECHNICAL SKILLS:

Data Warehousing: IBM Infosphere DataStage 11.3.x(Parallel Edition),/ 8.7.1/6.1/6.0/5.2 (IBM InfoSphere Designer Client, Director Client, Administrator Client, IBM InfoSphere Server, FastTrack, Profile Stage & MetaData Server

Informatica: PowerCenter 7.1/6.2/6.1/5.2/5.1/4.7 (Source Analyzer, Data Warehouse designer, Mapping Designer, Mapplet, Transformations, Workflow Manager, Workflow Monitor, Worklets), Informatica PowerExchange, Test Director8.0, Data cleansing, Data Profiling, OLAP, ROLAP, MOLAP, SQL*Plus, SQL*Loader

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FSLDML, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERwin 4.0/3.5.2/3. x, Oracle Designer, PL/SQL, Developer 5.1.4

Databases: Oracle 11g/10g/9i/8i/8.0/7.0, DB2, IMS Rx Data, MS SQL 7.0, SQL Server 2000, MS Access 7.0/97/2000, Teradata V2R5/V2R4, Sybase

BI & Reporting Tools: Business Objects XI/ 6.5/6.0/5.1/5.0 (Web-Intelligence 2.5, Designer 5.0, and Developer Suite & Set Analyzer 2.0) Data Reports, SAS, Developer 2000, MS Access Reports

Programming: SQL, PL/SQL, ANSI SQL, Transact SQL, SQL*Plus 3.3/8.0, UNIX Shell Scripting

OPERATING SYSTEMS: HP-UX11/10/9, IBM-AIX4.3/4.0/3.1, SunSolaris9/8/7/2.6/2.5, AS/400, SCO-UNIX, LINUX, Windows95/98/2000/XP, WinNT4.0, MSDOS6.22, LPAR (1D & 9S)

PROFESSIONAL EXPERIENCE:

Confidential, Middletown, New Jersey

Senior ETL Datastage Developer / Solution Architect

Responsibilities:

• Responsible for Designing and Developing ETL jobs using IBM Infosphere DataStage Parallel tool (version 11.3, 8.6) to extract, transform and load sales data from various source systems in to SXP data marts.
• Implemented best practices as per the Industry standards, designed technical specifications and developed optimized solutions for DataStage ETL jobs.
• Involve in analyzing the sources, transforming data, mapping the data and loading the data in to multiple targets using DataStage Designer.
• Lead team of 12 ETL offshore developers, manage and delegate tasks within the team, trouble shoot the issues faced in day-to-day activities and function as a single point of contact for both Confidential & Confidential and IBM technical teams and the senior management.
• Establish project directory structure setup for new projects, creating new folders, environment variables and parameter sets, routines, optimizing system performance, establishing log monitoring and maintaining security protocols.
• Develop incremental and full load data jobs using CDC (Change Capture Stage), which are scheduled to run on daily, weekly and monthly using IBM Tivoli scheduler. Use variables and parameters in the mappings to pass values between mapping, session and dynamic password setup to handle the secure logging of the applications.
• Implement restart strategy and error handling techniques to recover failed sessions and capture the rejected data for error validations.
• Involve in capacity planning and storage of data with Technical Architects, DBAs and Infrastructure teams to evaluate the data needs for effectively maintaining the existing jobs to stabilize the data flow.
• Responsible for interfacing with the Confidential & Confidential Technical Architects, Application System Engineers to review requirements, provide ETL impact analysis, present the conclusions to the technical and business teams.
• Increase team productivity and automate repetitive tasks in developing jobs by using reusable transformations, Custom functions, shared containers, run scripts to load data from operational data sources to data warehouse.
• Act as Point of Contact - POC for escalations and troubleshooting System Test, User Accepting Testing - UAT, Production ETL issues. Earn consistently 100% issue-resolution scores by providing excellent service to internal and external customers.
• Work with Release Manager for creating deployment plans, schedules and perform development verification and User certification testing for the weekly, monthly production releases.

Confidential, Middletown, New Jersey

Senior ETL DataStage Developer / Technology Team Lead

Responsibilities:

• Designed and created a data mart for Confidential & Confidential mobility site and sector data using IBM InfoSphere data stage suite 8.7 (Metadata Asset Manager, Fast Track, DataStage Designer, Director, Administrator) to support of Confidential & Confidential commercial location services (LBS) and wireless E911.
• Architected a metadata repository (project, operational, design) for all IBM InfoSphere Information Server suite components using Metadata Asset Manager and Fast track.
• Responsible for writing High Level Requirements, Reviewing with client and interface applications, ETL migration methods, data integration and transformation rules. Collaborated with data architects and to define data hierarchy and build the physical data mode.
• Trained and mentored new developers on ETL methodologies, source code guidelines including maintain version control, detail design, Test cases and results, security, effective use of Infosphere tools.
• Implemented restart strategy and error handling techniques to recover failed sessions and capture the reject data for error validations. Created Audit routines to collect the job statistics and notify the Production support team and business teams for recovery.
• Setup development, System Test and UAT environments and migrated jobs from development to System Test to UAT environments.
• Developed UNIX Shell scripts to read parameters from files for invoking DataStage jobs and setup crontab.
• Prepared the Deployment Plans and conduct reviews with Release management to ensure the code deployment to production.
• Coordinated with the System Test, UAT groups to verify the Data stage code and debugged any issues encountered during the testing.
• Supported the user groups during the UCT during the deployment and coordinated with production Support groups to solve the production tickets

Senior ETL Datastage Developer / Technology Team Lead

Responsibilities:

• Extensively followed the Express One documentation process (Software requirement document SRD, System Interface Agreement, Detail SIA ) to develop DataStage jobs.
• Prepared Detail Design as per the business rules given in SRD and created the Unit Test Plans to ensure the business rules were captured in the DS jobs.
• Participated in the reviews of SRD/IAD Documents and log the comments on Peer Review Documents
• Used DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouse databases.
• Created jobs in DataStage to extract from heterogeneous data sources like SQL Server 2000, Teradata, Sybase and Text files to Oracle 9i.
• Developed complex jobs using various stages like Transformer, Dataset, Row Generator, Column Generator, Datasets, Sequential File, Aggregator and Modify Stages.
• Extensively worked on Performance tuning of the existing DataStage Jobs by creating indexes on oracle lookup tables and converting Database look up into hash files to reduce the data extraction time.
• Used plug-in stages such as Stored Procedure, Merge and Pivot and also various stages like Sequential, Hashed, ODBC, OraOci9i, Aggregator and Inter-Process.
• Defined K-shell scripts for file watcher and file archiving process.
• Executed Unit Test cases using SQL queries, document the test results and maintain the peer review log documents in IFP.

Confidential, Charlotte, North Carolina

Lead ETL Informatica Developer / Technology Team Lead

Responsibilities:

• Requirements Gathering and Analysis. Designed and developed end-to-end ETL process for 3CP Oracle Platform.
• Extensively worked on documentation of BRDs-HLDs-LLDs for BASEL II project and 3CP Replatforming initiative .Performed extensive analysis of metadata to test the integrity, consistency and appropriateness of the data brought into the 3CP system from various sources.
• Created data maps for mainframe files (Cobol Copy books) and import data using Power Exchange Imported various heterogeneous and homogenous sources from ‘The W’’ and other SOR’s using Informatica PowerCenter7.1 Source Analyzer and PowerExchange.
• Imported various heterogeneous and homogenous targets using Informatica PowerCenter7.1 Warehouse Designer and PowerExchange. Extracted loan servicing, application, loss recovery data from sources like Corporate Treasury Data Mart (Oracle), PIMS (Sybase), BACARDI (Flat files) and upload to Teradata tables using Teradata utilities FASTLOAD /MLOAD/ TPUMP. Developed various transformations to apply BASEL II compliances to the mappings using the Transformation Developer in the Informatica PowerCenter Designer Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Design and Development of ETL routines, using Informatica Power Center within the Informatica Mappings, usage of Aggregator, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers Provide technical feedback during code reviews from offshore development and preparation of Unit and SIT test plans.
• Created and configured workflows, worklets & Sessions to transport the data to target warehouse Teradata tables using Informatica Workflow Manager. Used Queryman to analyze/insert/update data in Teradata tables and coded Teradata macros for standard update/ create views/ drop tables. Extensively used Informatica FLOAD, MLOAD External Load Utility to load data into TERADATA ‘W’ (BOFA Data Warehouse).
• Tuned the Session Parameters to increase the efficiency of the sessions in Workflow Manager Troubleshoot problems by checking sessions and error logs. Also used debugger for complex problem troubleshooting. Worked on the Unix AIX4.3 to connect to the Oracle database and run Plsql scripts.
• Used Maestro for scheduling of UNIX shell script jobs for monthly Production run.
• Extensively worked on SQL tools like Teradata SQL Assistant, TOAD and Win SQL to run SQL queries to validate the data .Interacted with various business User/Source contacts, DBA’s and system administrators to resolve performance and tuning issues.
• Responsible for Error Handling, Bug Fixing and assisted in Production Support.
• Bench Mark testing of Informatica PowerCenter mappings to calculate the lead times for batch processing and tuning the mappings. Assisted the reporting team in generating reports using Business Objects.
• Associated with Production support team in various performances related issues and worked with testing team in Unit, Integrated testing and UAT.