PROFESSIONAL SUMMARY:

• 9 years of IT experience in Data Stage, Data Analysis, Dataware house Implementation, Data migration, Data Conversion, SQL, PL/SQL
• Extensive experience in IBM DataStage 11.3/ 9.1/8.7/8.5/8.0.1/7.5. x using Components like DataS tage Designer, DataS tage Manager, DataStage Director, DataS tage Administrator, DataS tage Console , Information server and Parallel Extender.
• Experience in data profiling using IBM Information Analyzer.
• Experience in data cleansing using Quality Stage. knowledge and experience in Data Warehouse Development life cycle.
• Executed software projects for Insurance, Retail and Healthcare industry.
• Extensive experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouse and Data Mart using DataStage 8.5x , 9.1x and 11.3.
• Involved in developing the project plan for my team applications by analyzing the effort, time and dependencies among applications.
• Worked on different kinds of DataStage Stages like Xml, Change Capture, MQ stage , Complex Flat File, Dataset, Lookup, Oracle Connector, ODBC Connector, Lookup, Join, Aggregator, Sort, Merge, Filter, Transformer and Funnel.
• Experience in integration of various data sources like Oracle, DB2 UDB, Teradata, XML and Flat files into the Staging Area.
• Experience working in onsite and offshore model.
• Good experience in designing, implementing and performance tuning SQL queries.
• Expert in Unit testing, System testing, Integration testing, UAT and implementation.
• Member of Confidential ETL Production Support team of 5 members for 1 year with outstanding client admirations and provided maintenance for around 2500 jobs(v 7.5x,8.1x,9.1x) on 24*7 shift basis.
• Familiar with Version management tool like SVN.
• Created and deployed Work orders and resolved problem request tickets on HPSM /Remedy Management tool to track the incident.
• Used ALM tool to track the Defects.
• Good knowledge in understanding Customer Business Requirements.
• Extensive experience in loading high volume data, and performance tuning.
• Hands - on with database client tools like Oracle PL/SQL developer and TOAD.
• Received appreciation at organisation level while dealing with most demanding customers.
• Expertise in utilising Secured Shell Client tool for interacting with UNIX operating system, Citrix Client and VPN for remote server connectivity.
• Exceptional verbal and written communication skills, excellent team player.
• Experience working in both Agile and Waterfall model.
• Worked on migrating all the old jobs from 7.5.2, 8.0.1 to 9.1.2 version.

SKILLS SUMMARY:

Operating Systems: UNIX , Linux, Windows XP, Windows7 , Windows 10.

Databases: Oracle 10g, MS SQL Server, DB2,Teradata .

Tools: MS Power Point, Visio, Word, OneNote, Excel, Share Point, Putty, T OAD, SQL Developer , Connect Direct, Address Standardization and validation

Master Data Management: Standard Edition, Inspector, Rally.

Scheduling: ESP, CA7 Workstation .

Programming Languages: SQL, UNIX .

ETL Tool: IBM InfoSphere DataStage and Quality Stage (version 11.3) IBM Information Analyzer (version 11.3), IBM InfoSphere DataStage and Quality Stage (version 9.1), IBM WebSphere DataStage and QualityStage(Version 8.1), Ascential Datastage(Ver7.5x)(Manager,Administrator,Designer,Director)

Version management Tools: SVN

Bundle/Package Creation & Deployment: Jenkins(Build tool)- to create and upload Packages or Bundles, UDeploy (Deployment tool) - to deploy the Packages or Bundles.

ETL Job Control: Jobs Monitoring, Verify logs, Handling job Parameters/variables, Tables, Delta dates, Records Statistics each stage level. Pull/push Files from different servers using Connect direct method. Job listing, Directory Creation, File Maintenance, File Clean-up, Reset/Restart jobs

PROFESSIONAL EXPERIENCE:

Confidential, Windsor, Connecticut

ETL/ DataStage Developement Lead

Responsibilities:

• Using ETL Job control, Jenkins, deploy.
• Involved in analysing business requirements and design documents.
• Designed and developed jobs using Datastage 9.1x for loading the data into Tables.
• Performing analytics on the ODS and Registry to determine fallout of a particular SR ticket.
• Performing data clean-up activities based on SR tickets.
• Running scheduled maintenance tasks
• Involved in development of DataStage Jobs with required Transformations like MQ Stages, XML Stages, Aggregator, Filter, Funnel, Join, Lookup, Merge, Remove Duplicates, Sort and Transformer.
• Developed processes to extract the source data from different sources, integrated and populated the extracts after cleansing, transforms and integrating.
• Created pattern and data overrides to override the data values that are not handled by the rule sets.
• Used Complex Queries for data extraction from Source and Staging.
• Responsible for preparing comprehensive test plans and thorough testing of the system keeping the business users involved in the UAT.
• Involved in Unit Testing and Integration Testing.
• Involved in Tuning and Performance Testing.
• Used Shared Containers for code reuse and implementing complex business logic which increased the productivity of work.
• Extensively worked on Job sequences to Control the Execution of the job flow using various Activities & Triggers (Conditional and Unconditional) like Job Activity, Wait for file, Email Notification, Sequencer, Exception handler activity and Execute Command.
• Involved in fixes for bugs identified during production runs within the existing functional requirements.
• Creating UNIX scripts in support of ETLs.
• Involved in preparation of ESP/CA7 scripts to schedule the jobs and ETL Job Controls.
• Attended daily Scrum meetings.

Environment: IBM InfoSphere DataStage and QualityStage (version 9.1x),MQ Series 7.0.1, Oracle 12c, Teradata, UNIX/Linux.

Confidential, Providence, Rhode Island

Sr. ETL/DataStage Supervisor

Responsibilities:

• Involved in analysing business requirements and design documents.
• Attend SCRUM meetings to discuss what was done since the previous meeting, what will be done today and until the next meeting and if there are any blockers.
• Performed Column Analysis, Primary Key Analysis, Foreign Key Analysis and Cross Domain Analysis using IBM Information Analyzer.
• Designed and developed jobs using DataStage/Quality Stage 11.3 for loading the data into Dimension and Fact Tables.
• Provide solution for the Customer Service Requests and ad-hoc cases, requiring application related attention.
• Developed DataStage jobs using Change Capture Stage to compare the data changes between source tables and DataMart tables.
• Involved in development of DataStage Jobs with required Transformations like Aggregator, Filter, Funnel, Join, Lookup, Remove Duplicates, Surrogate Key Generator, Sort and Transformer etc.
• Extensively involved in developing data cleansing procedures using Quality Stage to standardize names, addresses and area.
• Created pattern and data overrides to override the data values that are not handled by the rule sets.
• Created PL/SQL procedures/Packages to implement complex business logic and calculations for loading the Fact Tables.
• Used Complex Queries for data extraction from Source and Staging.
• Responsible for preparing comprehensive test plans and thorough testing of the system keeping the business users involved in the UAT.
• Involved in Unit Testing and Integration Testing.
• Involved in fixes for bugs identified during production runs within the existing functional requirements.
• Worked on conversion of all old jobs from SAS to 11.3 version DataStage.

Environment: IBM InfoSphere DataStage and Quality Stage (version 11.3), IBM Information Analyzer (v 11.3), Sql server, Teradata, UNIX/Linux, Flat Files and MSN Reports.

Confidential, Bloomfield, Connecticut

ETL/DataStage

Responsibilities:

• Using ETL Job control, Jenkins, deploy.
• Involved in analysing business requirements and design documents.
• Designed and developed jobs using Datastage 9.1x for loading the data into Dimension and Fact Tables.
• Worked in an onsite-offshore model and explained the ETL developers on the mapping and business rules.
• Involved in development of DataStage Jobs with required Transformations like Aggregator, Filter, Funnel, Join, Lookup, Merge, Remove Duplicates, Sort and Transformer etc.
• Developed processes to extract the source data from different sources, integrated and populated the extracts after cleansing, transforms and integrating.
• Used Complex Queries for data extraction from Source and Staging.
• Involved in Unit Testing and Integration Testing.
• Involved in Tuning and Performance Testing.
• Involved in fixes for bugs identified during production runs within the existing functional requirements.
• Worked on migrating all the old jobs from 7.5.2 to 9.1.2 version plus new development on v9.
• Involved in preparation of ESP/CA7 scripts to schedule the jobs and ETL Job Controls.
• Using and giving KT on Jenkins and Udeploy for code migration.

Environment: IBM InfoSphere DataStage and QualityStage (version 9.1x), IBM, Ascential DataStage (Ver7.5x), Oracle 10G, Sql server, IBMDB2, Teradata, UNIX/Linux.

Confidential, Irving, Texas

Software Engineer

Responsibilities:

• Understanding the existing business model and Translating Business Requirements into ETL jobs.
• Implemented Extract, Transformation, and Load functionality for Enterprise Data Warehouse and Data Marts using DataStage designer.
• Performed Complex Transformations of large volumes of Data from multiple Data sources using DataStage Designer.
• Extensively used the Sequential File stage, Dataset, Filter, Funnel, JOIN, Lookup, Copy, Aggregator, during ETL development.
• Worked with DataStage Director to Run jobs, Monitor and check log files.
• Implemented type II slowly changing dimension techniques on changing attributes in different data marts.
• Worked on different Partitions in DataStage to Optimize DataStage jobs.

Environment: DataStage 7.0, Oracle, UNIX/Linux and MS Windows.

Confidential

Jr Programmer

Responsibilities:

• Understanding and analyzing project requirement and translating it into specifications and programming deliverables.
• Testing and debugging the product in controlled, real situations.
• Maintaining the systems and updating as per requirements.
• Data Extraction, Transformation and Loading from different Source system.