SUMMARY:

• To be a part of an organization where continuous learning & growth is assured and fulfilling the expectations out of my knowledge, skills and experience, aspiring to have a good career path with my interest and ability to learn and deliver the resultsProfile Overview
• A Dynamic IT professional with nearly 10+ years of work experience in Data Analysis, design and development of software application.
• Experience in Data warehouse development, ETL (DataStage), ETL testing, Data Stage implementations and support.
• Extensive hands - on using DataStage client components - DataStage Director, DataStage Manager (prior to 8x release), DataStage Designer.
• Good understanding of Data warehousing concepts, Relational Database Management Systems and Dimensional modeling (Star schema and Snowflake schema).
• Familiar with new enhancements in the IBM Web sphere DataStage - Multiple Job Compile, Surrogate key generator Stage, Job Report, Message handler options.
• Developed efficient mappings for data extraction/transformation/loading (ETL) from different sources to a target data warehouse.
• Proficient in all phases of the development lifecycle, coherent with Performance Tuning, Unit Testing, experience in design and implementation of Server and Parallel jobs including Job Sequencers.
• Effective Interpersonal skills to co-ordinate and participate in a team environment and achieve organizational goals
• Keen insights and ability to identify key problems, sound knowledge and understanding of communications tools and public relations techniques
• Statistical strong and expert in project management methodology. Team leader with excellent communication and management skills.

CORE COMPETENCIES:

• Data warehousing concepts
• Relational Database Management
• Dimensional modeling
• Operational Data Store
• Migration and Integration
• Development and Implementation multi-dimensional business analytics
• ETL Development Life cycle
• ETL design methodology
• Creative Problem Solving
• UNIX scripts
• PSR, PMR Reporting

TECHNICAL SKILLS:

Languages: C, C++, SQL, PL/SQL, Shell Scripting.

Operating Systems: Windows 98/2000/NT/XP, UNIX (AIX/HP)

Tools: Database: Autosys, ESP Cybermation, UC4, HPSD, HPSM, Remedy, Tivoli, Initiate Inspector, Aqua Data Studio, Toad, Putty Oracle 11g/10g/9i, Netezza, MS Access, SQL Server 2000/2005, DB2ParAccel 3.5, SQL*Plus

ETL Tools: IBM Information Server 11.3/9.1/8.7/8.1 , Ascential DataStage 7.5.x, QualityStage 8.x, IBM Infosphere FastTrack 9.1, IBM Infosphere Metadata Workbench 9.1, Infosphere Information Server Manager 9.1

PROFESSIONAL EXPERIENCE:

Confidential, Bloomfield, CT

Senior Datastage Developer

Environment: UNIX, Oracle 11g, DB2 z/OS, IBM InfoSphere Information Server 9.1/11.3, Infosphere Manager 9.1, Toad 10, IBM AIX 5.3, Oracle 10g, DB2 9.7, Netezza, Toad, SQL developer, Command Editor, ESP, Putty, ALM, Job Control

Responsibilities:

• Was a part of Systems Integration (SI) team and responsible for extracting claim data from upstream (Databases) and send the data (Flat files and Complex Flat files) to downstream for processing.
• Designed Parallel jobs using Sequential file, Oracle connector, Db2 connector, Netezza Connector, Aggregator, Funnel, sort, Remove Duplicate, copy, datasets, XML, MQ, Join, Remove Duplicates, FTP stage, Filter, Dataset, Lookup file set, Modify, Transformer etc.
• Designing jobs and sequences as per the defined frame work so that they can be accessed through Job Control application
• Create generic sequence jobs that handle migration of data for different modules.
• Lead off shore team, communicate the business to the off shore and help them understand the requirements. Monitor the code developed by off shore and give a sign off before moving the code to next environment.
• Involved in development of scripts that pass parameters to the job and run the job.
• Used schema files so that all the team could generic extract job for different files.
• Used and developed shared Containers to load the statistics into Confidential DataWarehouse from where testing team would have access to the statistics as well.
• Working on the Defects which were assigned through ALM
• Scheduling jobs in ESP
• Migrating few jobs from V8.1 to V9.1
• Migrating code between the environments through Infosphere Information Server Manager V9.1 and V11.3
• Production Implementations/deployments - Pre deployment reviews/walkthroughs
• Performance monitoring (OS, DataStage, job throughput)

Confidential, Naperville, IL

Senior Datastage Developer

Environment: UNIX, Oracle 11g, SAP ECC 6.0, ParAccel 3.5, Datastage 8.7, Toad 10, SAP R3 Plug-in, Aqua Data Studio, UC4, Putty, Remedy

Responsibilities:

• Re-design / development improvements to outdated ETL jobs
• Design, Develop performance measures for estimated volumes and - Pre deployment reviews/walkthroughs
• Provide new development procedures/documentation on process
• Capture estimated job performance Metrics via monitoring (DataStage, job throughput)
• Communications to BI Operational Synergies on new development activities scheduling in both UC4 and Datastage
• 24x7 Active monitoring of Production
• Outage/downtime planning & communications - production
• Production Implementations/deployments - Pre deployment reviews/walkthroughs
• Performance monitoring (OS, DataStage, job throughput) - production
• Additional Tasks
• Custom item file reruns
• Custom item file Development/ Modifications
• Manual Adjustments
• Yearly calendar loading
• Data Requests
• Automation of Custom item file reruns
• Error reduction/System Stabilization

Confidential, Weehawken, NJ

Onsite coordinator

Environment: IBM Infosphere Fast Track 9.1, IBM Infosphere Datastage 9.1, DB2, Oracle, UNIX, Autosys

Responsibilities:

• Working on designing Proof of Concepts for the usage of complete Infosphere suite 9.1
• Documenting the Technical specifications
• Designing Datastage jobs and making them as a part of shared repository so that they can be accessed through the other Infosphere tools such as Information Analyzer, Business Glossary
• Scheduling the offshore calls and assigning them day-to-day tasks.
• Gathering technical requirements from client and converting them into datastage jobs.
• Designed Parallel jobs using various stages like (XML, MQ, Join, Remove Duplicates, FTP stage, Filter, Dataset, Lookup file set, Modify, Transformer and Funnel stages) for one-shot (AD-HOC jobs as per the requirement)
• Supporting unit, integration, and end user testing by resolving identified defects and assisting levels 1-2 in their issue resolutions

Confidential, Hartford, CT

Tech Lead

Environment: IBM Infosphere suite 8.1, DB2, Oracle, UNIX, Tivoli, ESP Cybermation, Initiate Inspector

Responsibilities:

• Designed Parallel jobs using various stages like (XML, MQ, Join, Remove Duplicates, FTP stage, Filter, Dataset, Lookup file set, Modify, Transformer and Funnel stages) for one-shot (AD-HOC jobs as per the requirement)
• Extensively used TOAD for analyzing data, writing SQL, PL/SQL scripts performing DDL operations.
• Working on the code fixes.
• Working on the tickets raised due to the job failures in the Production
• Provided 24*7 production support on rotation basis.
• Mentoring advising and providing support to junior colleagues
• Interacting with vendors and documenting user needs
• Documenting technical support in Datastage including migration to different environments
• Supporting unit, integration, and end user testing by resolving identified defects and assisting levels 1-2 in their issue resolutions
• As requested, developing methods to efficiently use existing code components

Confidential, Omaha, NE

Senior ETL Developer

Environment: IBM Infosphere suite 8.1, DB2, SQL Server 2005, UNIX, Cybermation

Responsibilities:

• Working in Agile/Scrum methodology.
• Working along with the BA’s and Business to create mapping documents for the new source (Inspro).
• Design Datastage jobs to load Inspro data into existing EDW (Enterprise data Warehouse) and Data Mart
• Created jobs using different stages like Join, Transformer, Sort etc. and sequencers to execute the designed jobs. Used Execute Command Activity Stage, Notification Activity Stage, job activity, routine activity stages to implement these sequencers.
• Extracting data from various source systems like SQL Server, DB2 and Flat Files
• Modified existing server routines and shell scripts as per the new job requirements.
• Created Test cases for Unit Testing and System Testing.
• Providing On-Call support on rotational basis for the existing system.
• Tuning existing jobs for better performance.

Confidential, Cincinnati, OH

Senior ETL Developer

Environment: IBM Infosphere suite 8.1, DB2, Oracle 10g, UNIX, Autosys

Responsibilities:

• Supported ETL processes for large-scale data warehousing.
• Performed Unit Testing, Integration Testing, map tunings and identified obstruction in sources, targets, and sessions.
• Contribute at a senior-level to the DataStage designer by implementing a solid, extracting, cleansing, transforming, integrating, and loading data design that supports key business flows.
• Design, build and maintain different types of jobs which were created using stages like -- Sequential File, Transformer, Aggregator, Join etc.
• Created sequencers to sequentially execute the designed jobs, used Execute Command Activity Stage, Notification Activity Stage, job activity, routine activity stages to implement these sequencers.
• Extracting data from various source systems like Oracle, DB2 and Flat Files

Confidential

Analyst Programmer

Environment: IBM Infosphere suite 8.1, Oracle 9i, UNIX, Autosys, CVS Tortoise, HPSD, ITG

Responsibilities:

• Responsible for all the phases of building the data marts like analyzing the business requirements, Technical specifications, ETL process design, performance enhancement and maintenance.
• Demonstrated knowledge of DataStage Designer, ETL jobs developer,
• Actively involved in transforming and loading the data into different data marts.
• Act on various stages like Aggregator, Sort, Transformer and Sequential file.
• Performed on Import and Export of DataStage components and table definitions using DataStage Manager.
• Extracted data from various source systems like Oracle, Mainframes and Flat Files.
• Created sequencers to sequentially execute the designed jobs, used Execute Command Activity Stage, Notification Activity Stage, job activity, routine activity and sequencer stages to implement these sequencers.
• Worked on Slowly Changing Dimensions techniques to maintain the historical details of the data. SCD Type 1 and SCD Type 2 were used as a response to the change in the source data.
• Extensive experience in Usage of After/ Before job routines, Modification of existing Unix Scripts, Unit Testing, Integration Testing and User Acceptance Testing (UAT).
• Implemented enhancements to the current ETL programs based on the new requirements.
• Responsible for starting and stopping DataStage server during maintenances window.
• Worked on improving the performance of the designed jobs by using various performance tuning strategies.
• Followed the IBM naming conventions and Best Practices document for development of ETL jobs. Used the DataStage Designer for loading data into ODS.
• Used ODS for extracting the data for analysis purpose.
• Provided the Knowledge Transfer about the project to the new joiners and also trained them on IBM Infosphere suite 8.1.

Confidential

Senior Software Engineer

Environment: DataStage 7.5/ PX - (Designer, Manager, Director), Oracle 9i, SQL, PL/SQL, UNIX, Autosys, CVS Tortoise, HPSD, ITG

Responsibilities:

• Requirements Gathering, design, development, Unit testing, UAT, Production roll-out, enhancements and Production support.
• Involved in all the phases of the SDLC requirement as to understand the requirements and determine the best approach for timely delivery of in turn.
• Ensuring timely deliveries of work items to the Client.
• Involved in Implementing ETL standards and Best practices with in our portfolio.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Reusing the logic from DataStage jobs in real time.
• Developed jobs using different types of stages -- Sequential File, Transformer, Aggregator, Merge, Link Partitioner and Link Collector and Hashed File.
• Extensively worked on Error handling, cleansing of data, Creating Hash files and performing lookups for faster access of data.
• Created several Autosys jobs in dev and tested in sys and then deployed into production through SAIL ticket.
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
• Extensively used DataStage Director for Job Scheduling, emailing production support for troubleshooting from LOG files.
• Migrated jobs from development to QA to Production environments.
• Redefined production support methodologies and strategies.
• Logging in the different issues related to the development phase.
• Assisted operation support team and worked in support team for initial data loads
• Developed user defined Routines and Transformations using Ascential DataStage Manager
• POC of offshore team for Alerts and resolving them within the SLA and also raising alerts against the source Team for source related issues.
• Used import/export utilities to transfer data from production instance to the development environment.
• Created Data stage jobs for Ad-Hoc requirements to analyze the perplexing data issues.
• Extensively used DataStage Director for Job Scheduling, emailing production support for Troubleshooting from LOG files.
• Responsible for the design of jobs and delivering the Business data for the target from existing data sources.