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
• 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.