SUMMARY

• IT professional with over 18years’ experience in implementing varioushuge IT projects including specialization in SDLC cycle,project management, design,analysis, maintenance, with a focus on data warehousing in technology, financial, and retail industry.
• 13years of experience in a implementing various Enterprise Data warehousing projectsspecializing in DWdesign, ETL architecture model and Data Integration.
• Managed all aspects of the SDLC process - requirement analysis, time estimates, functional specification, design, development, testing, and support/maintenance.
• Worked directly for Ascential Software(taken over by IBM in 2005) as consultant in tool training, installation, mentoring for Asia Pacific clients and major IT services firms.
• Recently designed and built a retail Data Warehousing in NETEZZA from scratch as part of Oracle Retail RMS implementation.
• Highly specialized and implemented various Enterprise DW tool migration projects involving various industry leading tools like IBM DataStage, Informatica and Ab Initio.
• Designed technical processes as an Architect by using internal modeling and working with analytical teams to gather requirements and create specifications.
• Coded programs used in testing, implementing and building client databases and process flows using IBM DataStage, Informatica, Netezza, DB2, Oracle, MSSQL, Sql Server and IBM Data Integration products.
• Extensive technical background includes: hands on experience in design DW data model, developing ETL process, ETL architecture design, debugging and performance tuning of ETL jobs and process flow.
• Lead a team of 10 onshore and 30 offshore data integration team members to achieve success in design, development and deployment activities.

TECHNICAL SKILLS

Core Knowledge: Data Warehouse and Business Intelligence,DW Architecture,Data Modeling,ETL Design,Performance Tuning,Application Development,Quality Process,Configuration control, Corporate raining,DW Consulting,People Dynamics

Operating System: UNIX, Windows

Programming Languages: C, C++

Databases & Tools: Oracle, MS SQL Server, NETEZZA, DB2

Other Utilities: IBM Information Server 8.1/8.5/8.7, AscentialDataStage EE 7.x (IBM Web Sphere DataStage), COGNOS, Business Object, Informatica Power Center V 5.x, Visual Basic 5, UNIX Shell Scripts, HTML, VB Script, PHP3

Soft Skills: Program Management, Technology Evangelist, Project Management, Deployment and Implementation, Performance and Productivity Improvement, Change Management

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Lead Architect and Project Manager

Responsibilities:

• Analysis of Oracle Retail RMS design to build Retail Data Warehouse Data model in Netezza.
• DW Project planning, ETL Design architecture, project scoping, project estimation, project execution.
• Analyze the client’s current DW standard, BI Design and designed recommendations, best design practice, ETL standards and ETL Design methodologies.
• Designed ETL multi instance job template for Data pull from source system, design shared containers for CDC, Job templates for dimension and fact build and load.
• Designed and developed process flow for entire data warehouse using UC4 automation.
• Installed and configured DataStage 8.7 client components and coordinated with DBAs and AIX Admins in installing the server components of DataStage.
• Worked in performance tuning and performance enhancement of DataStage jobs.
• Designed and developed the Operational Data Store(ODS) for the entire Confidential + Outdoors organization and also developed the business intelligence data for reporting.
• Built DataStage projects for data warehouse and Data Integration teams. Also created the environment variables using Admin Stage.
• Developed UNIX shell scripts for scheduling ETL processes for executing from UC4.
• Scoping, Requirements gathering, design and development of integration from different source system and enhancements.

Environment: IBM DataStage 8.7, IBM AIX, UC4 Automic, Oracle RMS 13.2, Netezza Striper 4, SQL Server 2008 R2, DB2, Shell Scripting, SED, AWK.

Confidential, Alpharetta, GA

ETL Architect and Project Manager

Responsibilities:

• Provided a proposal as part of a bid for tool migration from Ab Initio to IBM DataStage 8.0
• Involved in data migration planning, Data migration analysis and design, implementation, and Data migration close out.
• Designed and developed QualityStage component replacing a Trillium plug-in to build a unique household and address ID.
• Used shared containers for multiple jobs, which have the same business logic.
• Designed job templates for staging, ODS Lookups, Facts, aggregate facts and Extraction process for EBCDIC, mainframe, sequential and various database sources.
• Analyzed existing Ab Initio process and developed similar design for DataStage.
• Extensively worked with Job sequences using Job Activity, Email Notification, Sequencer, Wait for File activities to control and execute the Data stage Parallel jobs.
• Extensively worked in the performance tuning of the process flow, ETL jobs and processes, tuning the SQL used in Transformations and fine-tuning the database.
• Also Worked as DataStage Administrator, defined projects, environment variables, user groups and privileges and set up different environments (Dev/QA/Prod). Created master controlling sequencer jobs using the Data Stage Job Sequencer
• Extensively used Restart ability Techniques in the job sequencers.
• Provided standard documentation, Best practices, Common ETL Project Templates
• Leveraged DB2 enterprise connection stage to take advantage of DB2 partition parallelism.

Environment: IBM Information Server DataStage/QualityStage8.0.1/8.1, UNIX Shell scripts, PERL, Ctrl-M, DB2, SYBASE, Oracle, RH Linux & Windows XP, Mainframe Files.

Confidential, Sunnyvale, CA

Team Lead, Support Admin

Responsibilities:

• Installation, configuration and administration of IBM DataStage server and client products
• Project planning, Project execution and support
• Comprehended and converted critical business requirements into technical functionalities forthe ETL and Reporting teams
• Developed UNIX scripts, to perform multifarious data processing tasks and automation function.
• Functioning as Team Lead in all aspects of new development, maintenance, and coding methodologies for the 4.0 TeraByte EDW Data Warehouse
• Established DataStage Best Practices and architecture guidelines for new developers and existing ETL team.
• Designed Enterprise Edition (PX) jobs for moving large volumes (> 70 million records daily) of data using DataStage 8.0.
• Designed Teradata BTQ scripts to move high volumes (> 100 million records daily) of data
• Performance testing and enhancing existing DataStage jobs
• DesignedEnterprise EditionParallel jobs for processing large data volumes while applying various business rules
• Redesigning ETL jobs and PLSQL code into IBM WebSphere DataStage
• Designing ETL jobs in DataStage for the EDW which provides data for Business Objects reports.
• Creating Test cases for ETL jobs based on business requirements and data cleansing rules

Environment: IBM Information Server 8.0.1, Sun OS & Windows XP, UNIX Shell scripts, Oracle Forms, Oracle PL/SQL

Confidential

Team Lead, Sr. Developer

Responsibilities:

• As a Tead lead involved in requirements gathering with Business Analyst for banking products (Derivatives and GIRO)
• Analyzing the existing rules and derivations in the Middleware for enhancement based on new product addition to the existing system.
• Develop and enhance the new banking products (Derivatives and GIRO) and enhance existing reconciliation process.
• Enhancements to existing PL/SQL procedures in OFSA to include Derivatives & GIRO
• Created a complex and dynamic master control job to run several DataStage Server jobs on a daily basis which process flat files, database extracts, and SAP extracts into the Dashboard Toolset Repository.
• Provided managers and research analysts with training on existing end-to-end ETL processes
• Designed table load jobs in Oracle 8i PLSQL with data manipulation.
• Created event driven triggers and sequences to create indexed keys which, maintained data integrity in multiple tables.
• Created indexes for referential integrity and used foreign key constraints on tables to enforce multi-column business keys.
• Ensure system performance is still within existing performance standards
• Load time of the new feeds is comparable to the feeds of similar complexity and data volume
• The load window time may extend based on new feeds that is loaded into the GDW
• AVA Cost Allocation Process
• Enhancement of existing AVA Cost Allocation process to include Derivatives & GIRO products
• OFSA Registration
• Ensure that Derivatives & GIRO products related tables are made available OFSA modules.
• Extensively worked in developing workarounds for handling of CLOB/BLOB data and processing XML data in DataStage jobs. Extensively worked in XML data processing.
• Developing and implementing data masking, encoding, decoding measures using the DataStage and UNIX scripting.
• Extensively worked on DataStage routines, custom stage and wrappers to handle complextransformations, calculations, encoding, decoding etc

Environment: DataStage 7.1 R1 and Informix 9.3,HP UX 11.11, Oracle 8i

Confidential

DataStage Consultant

Responsibilities:

• DataStage Parallel Extender training for various client across Confidential region including India, Singapore, Australia, Thailand, Malaysia, Japan.
• Installation of DS EE in various clients including DHL Kuala Lumpur, Ascential Software-Singapore Melbourne, Tata Consultancy Service-India, Cognizant Technology Solutions India, InfoSys India
• Mentoring exercise for various client on system requirements, installation and training in best practices.
• Working as a support engineer in Ascential Sydney in support desk for DataStage product
• Integration of DataStage engine for PeopleSoft products as part of Peoplesoft-OEM
• Migration project for data center migration for RaboBank, Sydney for change in Database for EDW.
• Migration project replacing all SQL script and Java programs to DataStage ETL process flow and jobs for DHL - Malaysia
• Various performance tuning activities for various Ascential clients.

Environment: DataStage Server 6.x/7.x, Peoplesoft, XML, DB2, SQL Server, Oracle,UNIX Shell Scripts

Confidential

Sr. ETL Developer

Responsibilities:

• Installation of INFORMATICA PowerCenter product components, design, development of Informatica mapping and testing to populate the data from AS400 system to Datamart and from Datamart to SIEBEL for CRM activities and for VALEX for campaign generation.
• Built custom transformation functions for data conversion, creation of batch schedules for ETL process execution.
• Developed PRO*C programs to populate into SIEBEL IF interface tables.
• Designed and developedpackages for design and deploying a batch processing self-installation tool using LEX, YACC, CORBA and JAVA technologies.
• The responsibility involved scoping, requirement gathering, design, development and testing.
• Identified and designed LEX/YACC and C++ object oriented technologies that would be used for the project, and best practice and recommendation on methodologies and framework for the project.
• The roles involved programing and coding in LEX, YACC and C++ programing language along with PERL and shell scripting to develop deployment package for self-installation.

Environment: InformaticaPowerCenter 5.x, UNIX Shell Scripts,C++, Lex, Yacc, Siebel.

Confidential

Module Lead

Responsibilities:

• As a role of a module lead for LOAN module, responsibility involvedleading the team, activity planning, scoping and team management.
• The responsibility included extensive study of the design of the banking system and coordinating directly with the On-site San Jose team to resolve various critical issues.
• As a functional team leader the responsibility included; training new batches of recruits about the system, coding and review of the core banking business rules of the "Loan" Logical Server in C++ environment, compilation, Stub Testing in UNIX.
• Involved in automation the code deployment package for auto-deployment from development to testing through a streamlined automation process using PERL and UNIX scripting.
• The responsibilities included configuring and maintaining the server operations.
• System integration testing responsibilities includes; integration of the entire project at client site, real-time testing with live transactional data

Environment: C++, UNIX, Oracle 8.01.

Confidential

Web Developer

Responsibilities:

• Developed scripts in PHP with mySQL as the database on the Linux box.
• Involved in web page designing (with Dreamweaver) of the site with creating links and integrating the PHP scripts with HTML.
• Involved in maintaining and designing/developing of enhanced request.
• Played significant role in various phases of project life cycle, such as requirements definition, functional & technical design, testing, Production Support and implementation.
• Excellent team member with problem-solving and trouble-shooting capabilities, Quick Learner, highly motivated, result oriented and an enthusiastic team player.
• Involved in writing Test Plans, Test Scenarios, Test Cases and Test Scripts and performed the Unit, Integration, system testing and User Acceptance Testing.

Environment: PHP, HTML, UNIX, mySQL.

Confidential

Application Developer

Responsibilities:

• Analyzing the current clinical system and internal working of the system.
• Suggesting various solutions with respect to implementation approach and maintenance of clinical activities and model for maintenance of in-patient histories.
• Designing of logical model for the database tables and development of Visual Basic program for implementing of clinical activities. Involved with deployment and maintenance of the entire system and for enhancement requests.
• For reporting purpose we used Crystal Reports which was well supported with Visual basic application.
• Interacted with various levels of management/staff to understand the requests and validate the report requirements and output.

Environment: Visual Basic, Crystal Reports