Professional Summary:

• Have 10 years of dynamic career reflecting pioneering experience in the field of Information Technology as a DataStage/ETL Developer in Data Warehousing technologies, with strong understanding in all phases of SDLC involving Requirement gathering, Business analysis, Application Design, Data Modeling, Development, Testing and Maintenances and Documentation.
• Experience in verticals Pharmaceuticals, Oil and Energy, Telecom, Healthcare and Insurance.
• Experience in latest version of IBM InfoSphere Information Server DataStage 8.1 and QualityStage, Informatica, Microstrategy Crystal reports.
• Experience in Relational and Dimensional modeling, including the development of entitiy relationship diagrams.
• Experienced in Hadoop and BigData and Very large DataWarehouse.
• Experience in relational data models such as conceptual, logical and physical data models, dimensional data models, data dictionary, and metadata.
• Extensively contributed in the areas of Dimensional modeling Star Schema and Snowflake Schema .
• Developed logical data models for the operations business area, using ERWin.
• Experience in Technical, Business teams to create logical data models : Create logical entities and define their attributes, and define relationships between the various data objects.
• Expertise in Performing Data Migration from various legacy systems to target database
• Experience in UNIX Shell scripting as part of file manipulation, and have strong knowledge in scheduling Data Stage jobs using Crontab as well as familiarity with Control-M.
• Worked with Oracle PL/SQL Stored Procedures, Table Partitions, Triggers, SQL queries, SSIS, PL/SQL Packages, IBM SQL Procedural Language and loading data into Data Warehouse/Data Marts.
• Expertise in Database Design, Data Modeling, Analysis, Implementation, generating Reports and Documentation for various databases Teradata, Oracle, DB2, MS SQL Server, and Informix .
• Has a good exposure in creating reports using MicroStrategy, Hyperion, SAS and Webfocus.
• Has a good exposure in Development/Admin MS SQL server2000/2005.
• Prepared and involved in writing, implementing and documenting the User Acceptance Test Plan, Test Cases and Test Scripts.
• Varied Experience in Business Process Management, Gathering Requirements from Users to determine the Functional and Technical Design and creating design process and scheduling of tasks to the team.
• Extensive knowledge of all phases of the Software development life cycle SDLC and the iterative Rational Unified Process RUP .
• Self-starter, able to work independently and as part of a team, Good at comprehending problems and in coming out with innovative solutions.
• Conducted training sessions on application created for client.
• Possess strong communication interpersonal skills and a committed team player, resulting in excellent rapport with employees and team members.

TECHNICAL SKILLS:

• Operating Systems: Windows, UNIX.
• Programming languages: PL/SQL, C/C , SQL, Visual Basic
• Databases: Oracle10g/9i/8i, Teradata, SQL Server 2005/2008, Sybase, DB2, Informix
• No-SQL Databases: HADOOP,HIVE, PIG
• Web Related: HTML, ASP, JavaScript and VB Script.
• DW Bi tools: IBM Infosphere, DataStage 7.x, Microstrategy
• 8.1.2, WebFocus7.1.3, Crystal Reports, SSIS/SSRS, Hyperion
• Tools Utilities: TOAD, Compuware Debugger, Corel, Mercury Test Director
• 8.0, PVCS, ERWIN, SQL Navigator, NDM, JIRA.
• ERP: Oracle ERP R11/R12, Siebel, SalesForce

PROFESSIONAL EXPERIENCE:

Confidential

Database Developer.

Development Responsibilities:

• Schedule sessions with Business owners and Clients to understand and estimate the project scope, interfaces and timeline involved.
• Created technical Specification document for each interface i developed.
• Defined validations to be built into application in line with the functional requirements.
• Architected the Data storage in Hadoop for Fraudnet.
• Created PL/SQL procedures and packages and fine tuned existing pkgs and existing packages.
• Experience with agile development methodologies.
• Involved in Unit testing, Integration testing, UAT by creating test cases, test plans and helping Datastage administrator in deployment of code across Dev, Test and Prod Repositories.
• Coordinated tasks with offshore team members.

Environment: Oracle, UNIX, Hadoop, Pig.

Confidential

Oracle Consultant

Development Responsibilities:

• Designed functionality of a real-time data pipeline that writes data to the cluster, and extending the batch process for new applications.
• Designed and developed Hadoop/Pig Scripts for data transformation and loading into multi terabyte DB for iCloud downstream Reporting purpose.
• Helped in analyzing large amounts of data, discover and solve real world problems and build metrics and business cases to help business teams to make decisions.
• POC on using Oozie,Hive and Hbase.
• Coordinated tasks with offshore team members

Environment: Hadoop, Pig, Hive, Oracle Exadata, UNIX.

Confidential

Sr Datastage Developer

Development Responsibilities:

• Provide effective communications with all levels of internal customers and staff.
• Interact closely with Business users and end users, and formulate a feasible design on which the development team could work on.
• Defined the Functional and Technical Specification document for each interface.
• Defined validations to be built into application in line with the functional requirements. Participated in meetings with Developers, Project Managers and Quality Analysts to discuss business requirements, test planning, resource utilization, and defect tracking.
• Created the Logical and Physical Data Models needed for transformations OLAP .
• Created PL/SQL procedures, actively participated in Siebel/ERP discussions/sessions to design the ETL job flow, designed and developed the ETL jobs.
• Prepared detail design documents which contain job designs and functionality of each job.
• Developed DataStage extract jobs using Oracle stages and load the data into a staging area in the form of flat files/Data Sets.
• Used Join/Merge/Lookup Stages to replicate integration logic based on the volumes of the data.
• Worked extensively with Parallel Stages like Row Generator, Column Generator, Modify, Funnel, Filter, Switch, Aggregator, Remove Duplicates and Transformer Stages etc extensively.
• Transformer, Lookup, Merge, Join, Aggregator, Sort, Filter and Remove duplicates stages were extensively used to Cleanse/Transform the data extracted into staging.
• Involved in Unit testing, Integration testing, UAT by creating test cases, test plans and helping Datastage administrator in deployment of code across Dev, Test and Prod Repositories.
• Coordinated tasks with offshore team members

Environment: Windows 2000 Server, Oracle 10g, IBM Infosphere DataStage 8.1

Confidential

Technical/Team Lead

Development Responsibilities:

• Organise sessions with Clients to understand and estimate the project scope, interfaces and timeline involved. Interact closely with Business users and end users, and formulate a feasible design on which the development team could work on.
• Defined the Functional and Technical Specification document for each interface.
• Defined validations to be built into application in line with the functional requirements. Participated in meetings with Developers, Project Managers and Quality Analysts to discuss business requirements, test planning, resource utilization, and defect tracking.
• Created the Logical and Physical Data Models needed for transformations OLAP .
• Created PL/SQL procedures using DBMS XML packages for reading, parsing and validating the XML files sent from different systems and taking the data to the desired tables.
• Actively participated in discussion sessions to design the ETL job flow.
• Compiled source to target mapping documents to design the ETL jobs.
• Prepared detail design documents which contain job designs and functionality of each job.
• Developed DataStage extract jobs using Oracle stages and load the data into a staging area in the form of flat files/Data Sets.
• Used Join/Merge/Lookup Stages to replicate integration logic based on the volumes of the data.
• Worked extensively with Parallel Stages like Row Generator, Column Generator, Modify, Funnel, Filter, Switch, Aggregator, Remove Duplicates and Transformer Stages etc extensively.
• Transformer, Lookup, Merge, Join, Aggregator, Sort, Filter and Remove duplicates stages were extensively used to Cleanse/Transform the data extracted into staging.
• Involved in Unit testing, Integration testing, UAT by creating test cases, test plans and helping Datastage administrator in deployment of code across Dev, Test and Prod Repositories.
• Involved in Production Scheduling to setup jobs in order and provided 24x7 production support.
• Coordinated tasks with onsite and offshore team members

Environment: Windows 2000 Server, Oracle 10g, IBM Infosphere DataStage 8.1, Java.

Confidential

Technical/Team Lead

Development Responsibilities:

• Lead a team of 4 members
• Schedule sessions with Business owners and Clients to understand and estimate the project scope, interfaces and timeline involved.
• Interact closely with Business users and end users, and formulate a feasible design on which the development team could work on.
• Defined the Functional and Technical Specification document for each interface.
• Defined validations to be built into application in line with the functional requirements.
• Participated in meetings with Developers, Project Managers and Quality Analysts to discuss business requirements, test planning, resource utilization, and defect tracking.
• Created the Logical and Physical Data Models needed for transformations OLAP .
• Assisted the team in mappings and ETL jobs by tuning the MS SQL server ETL code as well as SQL Procedures involved.
• Involved in the detailed design of the reports/dashboards and data model.
• Enhance performance by creating Aggregate tables, Indexes and managing Cache.
• Modified some of the existing reports and dashboards, and fixing some of the issues related to performance, data quality etc., during production support.
• Created procedures and involved in performance tuning of several SQL statements and the procedures written and fine tuning SQL scripts.
• Defined the Test plans Preparation of Test Plans and Support Documents.
• Supporting the Development Team and the User Acceptance Testing team to ensure business needs are properly implemented and documented.

Environment: Windows 2000 Server, MS SQL server 2008, Hyperion IR 7, MS Access, Java.

Confidential

Technical Lead

Responsibilities:

• Schedule sessions with Business owners and Clients to understand and estimate the project scope, interfaces and timeline involved.
• Interact closely with Business users and end users, and formulate a feasible design on which the development team could work on.
• Defined the Functional and Technical Specification document for each interface.
• Defined validations to be built into application in line with the functional requirements. Participated in meetings with Developers, Project Managers and Quality Analysts to discuss business requirements, test planning, resource utilization, and defect tracking.
• Created the Logical and Physical Data Models needed for transformations OLAP .
• Developed ETL jobs in DataStage used to transfer data from various legacy systems
• Used DataStage Designer to develop multiple processing jobs to read XML files and sequential files and load into Sql Server and Oracle. Used DataStage Manager for import/export jobs, metadata from one project to another project.
• Extensively worked with Parallel Extender/Enterprise Edition EE using Parallel Processing Pipeline and partition parallelism techniques to improve job performance while working with bulk data sources.
• Used different types of Stages like Sequential File, Lookup stage, Transformer, Change capture, Remove Duplicates, External source, XML input/output, Funnel, Sort, Aggregator, and ODBC for developing different Jobs.
• Used DataStage Director to Run and Monitor the Jobs performed, automation of Job Control using Batch logic to execute and schedule various DataStage jobs.
• Production support for Weekend DataStage ETL Job Runs.
• Used PL/SQL languages for writing stored procedures and functions and were called in DataStage Jobs.
• Configured File for Parallel extender as per number of processors available to process the data by using DataStage Manager.
• Extensively worked on Unix Shell scripts to extract/load data from/to SFTP server.
• Created Unix Shell scripts used in as routines and for scheduling the jobs in crontab.
• Created procedures and involved in performance tuning of several SQL statements and the procedures written and fine tuning SQL scripts.
• Develop complicated Reports in MicroStrategy for the team.
• Defined the Test plans Preparation of Test Plans and Support Documents.
• Supporting the Development Team and the User Acceptance Testing team to ensure business needs are properly implemented and documented.

Environment: Windows 2000 Server, IBM AIX, DataStage 7.5 PX Oracle10g/9i, MicroStrategy 8, Erwin. Toad, SQL Navigator.

Confidential

Technical Lead

Responsibilities:

• Extract functional requirements from the finalized Business requirements and design use cases to aid the development process.
• Defined the Functional and Technical Specification document for each interface.
• Defined validations to be built into application in line with the functional requirements. Participated in meetings with Developers, Project Managers and Quality Analysts to discuss business requirements, test planning, resource utilization, and defect tracking.
• Created Data base design in creating a scheduler for the DataStage jobs.
• Created Data Models needed for transformations of Data from one system to another.
• Created procedures and involved in performance tuning of several SQL statements and the procedures written,
• Developed ETL jobs in DataStage used to transfer data from various legacy systems.
• Developed Reports using WebFocus reporting tool.
• Production support for Weekend ETL Job Runs.
• Simultaneously work with several applications and work groups.
• Conducted training sessions on application created for client.

Environment: WebFocus 7.1.3, Sco Unix, Datastage 7.0, PL/SQL, SQL, Oracle /Informix/DB2, WebFocus, Erwin

Confidential

Technical Lead

Description:

• Lead a team of 7 members
• Responsible for giving quality deliverables in time.
• Conduct team meetings and Coordinated with the onsite team.
• Conducted conference calls with developers following up with changes in requirements and their impact on the development process.
• Create and analyze the data process flow diagrams of various procedures created.
• Defined the Functional and Technical Specification document for each procedure.
• Defined validations to be built into application in line with the functional requirements.
• Participated in meetings with Developers, Project Managers and Quality Analysts to discuss functionality of the procedures to be created, test planning, resource utilization, and defect tracking.
• Created procedures and involved in performance tuning of several SQL statements and the procedures written.
• Member of the sign off team which reviews the procedures written by other team.
• Created and tested and reviewed test plans for several procedures.

Environment: PL/SQL, Teradata, Oracle 9i,SQL Plus, Informatica, Compuware DevPartner Debugger, Mercury Test Director 8.0