SUMMARY

• 8 years of IT experience in the Data Analysis, ETL Application Development, Data Integration, Implementation and Testing of applications
• Expertise in architecting and building an integration platform using IBM InfoSphere tools that makes data available from any source to any consumer in whatever format is needed
• Develops operational and technology strategies by creating and configuring ETL frameworks to support convergence and continuous improvement in line with central architectural standards
• Responsible for reusable enterprise identity management, data integration, and process orchestration
• Project Planning and Monitoring using Rally - Agile model
• Two years of experience on IBM Datastage Administration
• Designed and implemented the DW solution to build a golden source of data for casualty insurance preditctions
• Designed and implemented a solution for data ingestion to Hadoop environment and Netezza appliance from legacy databases and external data sources to support BigData Analytics
• Knowledge of Data Warehouse methodologies, Dimension modeling (Star Schema and snowflakes), Data modeling (logical and physical) and data profiling
• Expertise in designing solutions for converting Informatica Power Centre 6.0 ETL to IBM Datastage using IBM FastTrack
• Experience in upgrading Datastage versions 7.5.2 to 8.1, 8.1 to 8.7 and 8.7 to 9.1 versions
• Excellent analytical, problem solving skills and has good communication & interpersonal skills to work with stakeholders and the team

TECHNICAL SKILLS

ETL Tools: IBM Infosphere Information server Datastage 8.x, 9.1 & 11.3.1Ascential Datastage 7.5.2, Informatica Power Center 6.0 & Ab Initio

Databases: MongoDB or NO SQL, Oracle 10g, DB2 9.5, SQL Server 2000

Operating Systems: UNIX, Windows XP/2000/NT. (Sun Solaris, HP Unix, AIX).

Programming Languages: SQL, PL/SQL, UNIX

SQL Querying Tools: TOAD, SQL Developer.

Miscellaneous: CA7 Scheduler, Putty, MS Visio 2003

PROFESSIONAL EXPERIENCE

Confidential, Syracuse, NY

Senior ETL Developer

Responsibilities:

• Gathers and understands the business requirements from customers and business stakeholders
• Designing the system technically and writing technical specifications of project
• Involved in the design strategies and documenting the Proof Of Concepts
• Presents the strategic designs to the business stake holders and communicate the same to onsite & offshore team
• Responsible for reusable enterprise identity management, data integration, and process orchestration
• Experience in applying business rules, process and context to data as it moves through the enterprise
• Develops operational and technology strategies to support convergence and continuous improvement
• Have been using IBM Infosphere Fast Track to write the mapping specifications and to generate a non-productional DS jobs
• Have been using IBM Information Analyzer to create the rules and integrate the same in DS jobs
• Project Planning and Monitoring
• Creating High Level and Low-level ETL Flow Diagram in Visio
• Designed the reusable components to support conversion
• Presenting the strategic designs to the customers and communicate the same to the offshore team
• Project Planning and Monitoring using Rally - Agile model
• Error Logs/Audit Trails were maintained
• Implemented the best practices in terms of IBM tools and documented the lessons learnt

Environment: IBM Information Server 8.x and 9.1, Microsoft Visio, CA7, Oracle 10g, Shell Script, SQL, UNIX and Toad.

Confidential, Syracuse, NY

Senior ETL Developer

Responsibilities:

• Coordinated in gathering business requirements from client.
• Design the conversion strategy for the conversion and the upgrade concurrently
• ETL Development for Control Architecture, Common Modules, Sequence Controls and major critical interface
• Designed the reusable components to support conversion
• Documenting the Proof Of Concepts
• Presenting the strategic designs to the customers and communicate the same to the offshore team
• Coordinate with the IBM concierge team for PMRs
• Implemented the best practices in terms of IBM tools upgrade and documented the lessons learnt
• Implementing the applications to production in various timings without impacting each other
• Coordinate with conversion testing team to remediate the issues as and when arises
• Installed Data Stage clients and take cares of administration up-to some extent

Environment: IBM Infosphere Information Server Datastage 8.1 & 8.7, Oracle 10g,, SQL, UNIX, Shell scripts, TOAD, CA7 Scheduler, Linux, Putty.

Confidential, Syracuse, NY

Senior ETL Developer

Responsibilities:

• Analyze and Design the solution based on the requirements
• Coordinate with offshore in developing and reviewing the modules
• Writing of Technical Specification of the project
• Designed the Batch Control Architecture, Mapping Relationships, Keys and Indexes
• Generates PL/SQL scripts to extract the data from ODS and also data manipulation & validation
• ETL Development for Control Architecture, Common Modules, Sequence Controls and major critical interfaces
• Documenting the Proof Of Concepts
• Designed a solution to integrate the DB2 source legacy applications to middleware layer
• Using ETL best practices to develop ETL processes in support of the requirements validate that they meet business and technical specifications, ensure that any issues raised during testing are addressed prior to migration into production; and manage ongoing maintenance of the system and data
• Implementing the application into production
• Coordinate with SIT & UAT team in resolving the issues
• Installed Data Stage clients

Environment: Data stage 7.5 and IBM Infosphere Information Server Datastage 8.1, Oracle 10g, DB2 9.5, SQL, PL/SQL scripts, UNIX, Shell scripts, TOAD, CA7, Linux, Putty.

Confidential, NJ

ETL Application developer

Responsibilities:

• Build and Maintain ETL processes working closely with BI ETL Architects, data analysts, business analysts and BI developers to understand requirements.
• Worked on reusable components in DS common modules and routines
• Alongside, using IBM Datastage have built ETL jobs for data migration from legacy applications in to the system
• Researching and resolving any outbound data issues reported by UAT/SIT team.
• Implemented SCD logic to identify the daily changes in Client Data
• Fixesmutating problem in database trigger whenever arises using Pragma transactions
• Performed Unit testing
• Preparation of System test cases
• Performed System Testing

Environment: Datastage 7.5.2, Ab Initio 2.10 co>op sys and 1.10.8 GDE, Oracle 10g, SQL, Linux, Shell scripts, TOAD, Putty.

Confidential, NJ

ETL Application Developer

Responsibilities:

• Developed processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouse using DataStage Designer.
• Designed and developed of DataStage Server and Parallel Jobs.
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements
• Tuned DataStage jobs for better performance by creating common modules, RCP concepts
• Used DataStage Director for running the Jobs.
• Used the Manager to import, export jobs/routines.
• Preparation of Unit test cases
• Performed Unit testing
• Preparation of System test cases
• Performed System Testing

Environment: Datastage 7.5.2, Oracle 10g, DB2 8.2, SQL, Linux, Shell scripts, TOAD, Putty.