PROFESSIONAL SUMMARY:

• Around 13+ years of rich experience in IT, with emphasis in Business Intelligence, Data warehouse applications. Involved in the implementation of Interface design, Client Issues Resolution, System Change Requests (SCRs) - Enhancements, Application tuning using Ascential DataStage 7.5.1 and Abinitio 3.01.
• 13+ years experience in Data warehousing and Business Intelligence tools based applications Techno-Functional Development/Support.
• Worked across different modules of Business Intelligence applications .
• Very strong in Business intelligence tools like Ascential DataStage 7.5.1, Informatica and Abinitio 3.01.

SKILLS SUMMARY:

• Thirteen (13) + years in Technical Designs, Coding, Unit Testing, Integration Testing activities. Extensive experience in Performance Tuning, Enhancing and stabilizing many business critical Data warehouse applications.
• Expertise in Technical Design & Development, Test Plan preparation, Unit Testing, System Integration testing and documentation.
• Prepared the technical specifications according to Organizational wide standards.
• Involved in all aspects of Software Development Life Cycle and Production troubleshooting, Software testing, Requirement Analysis, Design Documents, SDLC including Client Support.
• Involved in client interaction in onshore for around 18 Months as an ETL designer to capture the business requirements.
• Good Knowledge on Big-data HADOOP, HDFS, Hive technologies.

TECHNICAL COMPETENCIES:

Programming Languages: PL/SQL

Databases: Oracle 8i/9i

Operating Systems: Windows NT/2000/XP/CE, UNIX

BI Tools: IBM DataStage Enterprise Edition v7.5.1,Abinitio 2.15 & 3.01, Informatica6.x, 7.x, Sagent 5.0,Business Objects 5.1.8

Big-data: Hadoop,Hive,Pig,Zookeeper

NoSQL: Hbase

Other Tools: TOAD, SQL Analyzer, QC

Project Management Tools: MS-OFFICE Tools

Scheduler Tools: Autosys, Crontab, TWS

Web Interface: CITRIX, VDI.

PROFESSIONAL EXPERIENCE:

Confidential

Project Lead /Designer

TECHNOLOGY: Ab-Initio 3.01, UNIX, Oracle

Responsibilities:

• Involved in collecting the Business Requirements for ETL module design.
• Creating Technical Design Documents for the respective subject area.
• Involved in design and development of Abinitio graphs/plans.
• Involved in creating Aggregate tables.
• Involved in estimations.
• Involved in Project planning, task assignments, monitoring and tracking.
• Involved in document reviews and code reviews.
• Conducting knowledge sharing sessions.
• Maintain project communications, including project status with the Target Business Analysts, conduct regularly scheduled project status meetings, prepare and submit a weekly Status Report generated in Clarity on weekly basis.
• The Project Plan and weekly Status Reports were created and maintained throughout the project.

Confidential

Senior Software Engineer

TECHNOLOGY: Ab-Initio 2.14, UNIX, Netezza

Responsibilities:

• Involved in collecting the Business Requirements for ETL module design.
• Creating Technical Design Documents for the respective subject area.
• Involved in design and development of Abinitio graphs/plans to record customer history, transaction history and product history etc.
• Involved in design and development of Abinitio graphs/plans to record Call details for over 2 years
• Involved in creating Aggregate tables.
• Involved in estimations.
• Involved in Project planning, task assignments, monitoring and tracking.
• Involved in document reviews and code reviews.
• Conducting knowledge sharing sessions.
• Maintain project communications, including project status with the Target Business Analysts, conduct regularly scheduled project status meetings, prepare and submit a weekly Status Report generated in Clarity on weekly basis.
• The Project Plan and weekly Status Reports were created and maintained throughout the project.

Confidential

L3 Support

TECHNOLOGY: Ab-Initio 2.14, UNIX

Responsibilities:

• Collecting the Business Requirements for ETL module design.
• Preparing/reviewing HLDs, LLDs, and other design documents.
• Creating Technical Design Documents for the respective subject area.
• Coding and testing the functionality as per the Business requirements.
• Preparation of the Unit Test Plan and Unit Test Report.
• Creating graphs, Plans and wrapper scripts.
• Coordinate and manage the technical activities of offshore project team members.

Confidential

Design, Development, Testing and Team Lead

TECHNOLOGY: Abinitio 2.15

Responsibilities:

• Collecting the Business Requirements for ETL module design.
• Creating Technical Design Documents for the respective subject area.
• Coding and testing the functionality as per the Business requirements.
• Preparation of the Unit Test Plan and Unit Test Report.
• Unit Testing.
• Coordinate and manage the technical activities of offshore project team members.
• The Project Plan and weekly Status Reports were created and maintained throughout the project.

Confidential

Senior Software Engineer

TECHNOLOGY: Ascential DataStage 7.5.1

Responsibilities:

• Collecting the Business Requirements for ETL module design.
• Creating Technical Design Documents for the respective subject area.
• Coding and testing the functionality as per the Business requirements.
• Preparation of the Unit Test Plan and Unit Test Report.
• Unit Testing.
• Integration Testing.
• Development support.
• Coordinate and manage the technical activities of offshore project team members.
• Maintain project communications, including project status with the Target Business Analysts, conduct regularly scheduled project status meetings, prepare and submit a weekly Status Report generated in Clarity on weekly basis.
• Workload assignment/transition to offshore and tracking until delivery.
• Used the DataStage Designer to develop processes for extracting, clean, transforming, integration and loading data into warehouse database.
• Used the Data Stage Director and its run-time engine for running the solution, testing and debugging its components.
• Working with DataStage Manager for importing table definitions.
• Used Oracle Enterprise, Teradata stages to extract and load the data simultaneously.
• Used Transformers like Lookup, Aggregator, Change capture, Copy, Filter, Funnel, Join, Merge, Sort, Column Generator, Row generator stages.
• Monitoring the DataStage jobs using Autosys scheduler.

Confidential

Development, Testing and Offshore Coordination

TECHNOLOGY: Sagent 5.0

Responsibilities:

• Used the Sagent Designer to develop plans for extracting, clean, transforming, integration and loading data into warehouse database.
• Involved in Creating SUB - PLANS.
• Used Flat File Source, SQL Query, ORACLE BATCH Loader, Key Lookup, Key Generation, Splitter, SUB PLAN, Filter, Expression Calculator, Rank, Disk sort, Record number, Add Columns, Column Select Transformations to create plans.
• Extracted and transferred source data from Flat File data, DB2 Database to Oracle database.
• Designing and developing PL/SQL Procedures, functions, and packages.
• Involved in creating the Unit Test plans and Unit Test Plan Results.
• Involved in Performance Tuning.
• Gap analysis for existing Warehouse applications for future requirements.
• System Change Request to cater future integrations of all target companies
• Problem analysis and fixes for client identified problems with existing systems

Confidential

Development and Testing

TECHNOLOGY: DataStage 7.5

Responsibilities:

• Involved in Converting SQL server stored procedures into DataStage Jobs.
• Used the DataStage Designer to develop processes for extracting, clean, transforming, integration and loading data into warehouse database.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
• Working with DataStage Manager for importing table definitions and creating the Routines based on the business rules.
• Designed and developed validation routines to validate the data in warehouse and Data Marts after loading process balancing with source data.