SUMMARY:

• Have 8 years of IT experience and with ample knowledge in Banking/Insurance, Retail and HealthCare domain.
• 8 years of experience in Data modelling, Datawarehouse Design, Development and Testing using ETL and Data Migration life cycle using IBM WebSphere DataStage 11.5/11.3/8.7/7. x,Quality Stage, Shell Scripts.
• Experience in analyzing the data generated by the business process, defining the granularity, source to Confidential mapping of the data elements, creating Indexes and Aggregate tables for the data warehouse design and development.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool DataStage (Ver. 11.5/ 11.3/8.5/8.1/7.5 ), designing and developing jobs using DataStage Designer, Data Stage Manager, DataStage Director and DataStage Administrator.
• Expertise in Datastage server, MPP clustered platform and parallel jobs.
• Expert in server jobs development, handling hash files and inter process stages.
• Created a Control - M setup dedicatedly for many server jobs applications in current project as part of development.
• Handled main frame source system files (VSAM, QSAM and SAM- using complex flat file stage) in banking project and performed ETL process after extraction.
• Expert in using stages, Standardization, Scrubbing, Matching and Survivorship rules using IBMQualityStage.
• Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning and System Testing.
• Efficient in in corporation of various data sources such as Oracle11g/10g/9i/8i, PL/SQL, MS SQL Server 2000/2005/2008/2008 R2, DB2 9.5 & 10.1, XML (parsers) and Flat files into the staging area.
• Experience in Mapping Server/parallel Jobs in DataStage to populate tables in Data warehouse and Data marts and addressing performance issues and enhancements.
• Exposure to design and support of mainframe applications using JCL, DB2 and IBM Mainframe tools and utilities.
• Expertise and worked in Service Oriented Architecture- SOA as part Confidential Corporation.
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies and relational database design.
• Expert in unit testing, system integration testing, implementation, maintenance and performance tuning.
• Experience in Scheduling tools like Control-M, Autosys for automating and scheduling jobs run.
• Worked on MDM in Confidential to merge the critical supplier information details with respect to geography and created one master data file for ease of access
• Expertise in Master data management - MDM tool can be used to support master data management by removing duplicates, standardizing data (mass maintaining), and incorporating rules to eliminate incorrect data from entering the system. The merged supplier master data would be efficient for business enhancement.
• Experience in UNIX Shell scripting, complex SQL queries, PL/SQL, Stored Procedures and Database Triggers.
• Excellent knowledge of operating systems Windows, UNIX and databases including Teradata, Oracle, Netezza, Greenplum, SQL Server and DB2.
• Have undergone Informatica ETL tool training.
• Experience in implementing Quality Processes like ISO 9001:2000/Audits.
• Provided 24X7support to users and having good experience in resolving high priority production issues within the time.
• Good Interpersonal skills, leadership skills, team player, commitment, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks.
• Designed the Control-M Visio based on the business needs for scheduling the DataStage jobs in control-M scheduler.

TECHNICAL SKILLS:

Technologies/Languages: Data warehousing (ETL), Shell Scripts and Message Queue

Databases: Teradata, Bteq scripts, SQL, MQ, Oracle, DB2, Netezza, Microsoft Access, SAP

Operating Systems: Windows& DOS, UNIX/LINUX/AIX and Solaris, MDM tool

BI Tool: Cognos

Data Modeling: Erwin and Microsoft Visio

Configuration Management: Microsoft Team Foundation Server (MSTFS)

Programming Languages: SQL, PL/SQL, UNIX commands and Shell Scripting

Domains worked: Banking, Retail, Insurance and Healthcare

Scheduling Tools: Control-M, & Autosys.

Tools: used DataStage 7.5,8.1,8.5,9.1,11, 3( Server and Parallel jobs), Quality StageCDC, Talend, Teradata SQL Assistant, Oracle SQL Developer, IBM DB2 Clients, PL/SQL, Hadoop file system, Microsoft SQL Server, Cognos, MSTFS, Putty, Toad and MS Visio

PROFESSIONAL EXPERIENCE:

Confidential

Technical Lead, Irving, Texas

Tools worked on: Datastage 11.5 - (Parallel jobs), Oracle 11g, Control-M, MS Visio, UNIX (IBM-AIX), Toad, Netezza, Win SCP and Putty

Responsibilities:

• Support the implementation of the Datastage by performing all roles associated with architecture, design and development of the solution.
• Create program specifications and Project plan.
• Build the new datastage parallel jobs based on the business requirement as part of various project release
• Develop Control-M and Unix scripts setup for the applications that we develop
• Implement testing, transition and support activities.
• Support unit, automated regression, and UAT testing for all new enhancements
• Support the production Datastage jobs by monitoring and resolving any issues
• Contribute to the project planning process by estimating Data Architecture, Modelling, Reporting tasks and Deliverables
• Perform qualitative and quantitative analysis on data from various sources including database for log files to identify new business metrics patterns that will enhance the Customer's data quality and value
• Performance tunes the Datstage jobs as part of the continual process enhancement.
• Analyze test results and track the progress of the deliverables

Confidential

Technical Lead, Ann Arbor, Michigan

Tools worked on: Datastage 8.5 & 11.1 - (Server and Parallel jobs), Oracle 11g, Control-M, MS Visio, and UNIX (IBM-AIX), Toad, Oracle, DB2, Win SCP, Putty and Quality centre

Responsibilities:

• Support the implementation of the Datastage by performing all roles associated with Architecture, design and development of the solution
• Perform weekly, monthly release data refresh activities in UAT environment
• Develop new datastage server and parallel jobs based on the business requirement as part of monthly release
• Troubleshoot and handle issues pertaining to datastage server jobs application which are running in legacy systems
• Handle mainframe source system files( QSAM, VSAM) from MDSS server and extract them for ETL process
• Develop Control-M setup for the application that we develop
• Work closely with internal and external clients to determine reporting requirements, data architecture and design solutions
• Contribute to the project planning process by estimating Data Architecture, Modeling, Reporting tasks and Deliverables
• Performance tune the Datastage jobs to extract information from the data warehouse
• Support the production Datastage jobs by monitoring and resolving any issues
• Support unit, automated regression, and UAT testing for all new enhancements
• Perform qualitative and quantitative analysis on data from various sources including database for log files to identify new business metrics patterns that will enhance the Customer's data quality and value

Confidential

Technical Lead

Tools worked on: Datastage 9.1& 11.1 Oracle 11g, Teradata, Autosys, Quality centre and UNIX, Toad

Responsibilities:

• Designing the Functional specification documents
• Designing the functional test cases to identify the bugs in the code
• Development of control table for file management and data processing
• Developing project development process flows for standardization across Lines of business
• Adding suggestions to business needs to enhance the efficiency of the existing system
• Performing high level data validation and provide remediation of source system data

Confidential

Technical Lead, Minneapolis

Tools worked on: Datastage 8.5, Oracle 11g, Teradata, SQL, Control-M, PL/SQL, UNIX, Shell Scripting, Microsoft SQL Server, Cognos and MFTS

Responsibilities:

• Prepare the HLD document by coordinating with business team and technical architect.
• Gathering current requirements from core business team through scrum meetings to make/add the changes in HLD.
• Adding suggestions to business needs to enhance the efficiency of the existing system
• Making key code changes in Datastage and Teradata codes during the development phase.
• Presenting daily status report to the clients.

Confidential

Technical Lead

Responsibilities:

• Leading Confidential .com & Marketing portfolios in NPE.
• Managing project related activities and handling client escalations.
• Preparing the project monthly metrics for client presentation.
• Guiding the team with the process improvements and automations.
• Help the project teams with the value ads and performance tunings.
• Presenting the weekly status report to the clients.
• Logging the lessons learnt and best practices in TCS portal.

Confidential

L2 support engineer

Responsibilities:

• Resolving Datastage issues pertaining to Non Prod Environments with appropriate solutions.
• Coordinating with other environment support teams in resolving the issues in related to Database unavailability and job scheduling tools etc...
• Working on work requests and defects raised by business users, adhering to the predefined SLA’s and updating the work logs with the solution accordingly.
• Performing Data refresh to sync up the Non Prod Environments with production environment data and writing data refresh scripts to perform the same in Datastage.
• Prepared the Gap Analysis Document for all the T.COM and Marketing applications that compares the environment details of the Non Production Environments.

Confidential

Senior ETL developer

Tools worked on: Datastage 8.1, Oracle 10g, Autosys, Quality centre and UNIX

Responsibilities:

• Assigning the test requirements to releases based on the specifications in the Functional Specification document
• Determining the number of fixed and open defects at a release or a cycle level
• Enhancing the reporting granularity for the test set folders
• Identifying the bugs and report the same through incidents to the corresponding development teams on priority
• Modified the Datastage jobs that have got logic issues and changing the code based on the client requirements.

Confidential

Module Lead

Tools worked on: Datastage 8.1, Teradata, Autosys, Oracle PL/SQL HP Service Manager Tool and UNIX

Responsibilities:

• As part of the production support team, we provide round the clock support in monitoring and maintaining the functioning Datastage applications
• To send emails in case of any failures or any Adhoc requests from the clients regarding issues that are pending and if the client needs an update regarding the same
• As and when issues rise, incidents are raised based on the priority and closed with appropriate solution which includes data fix and data correction through DBA instructions
• Problem tickets are raised for reoccurring issues and a permanent fix is given by making the appropriate changes at the job level and testing those jobs in the PRT environment to ensure that the data load is correctly implemented through the changes made
• Modify the Datastage jobs that has got logic issue

Confidential

ETL Developer

Tools worked on: Datastage 8.1, Teradata, Autosys, Oracle PL/SQL HP Service Manager Tool and UNIX

Responsibilities:

• Development of ETL mappings as per requirement
• Reviewing the ETL mappings and testing them
• Implementation of the transformations
• Scheduling the session through Autosys
• Developing the Autosys environments for running the jobs in Datastage and editing the scripts in UNIX
• Testing the jobs in SIT and PRT environment
• Prepare the corresponding documents and test cases

Confidential

ETL Developer

Tools worked on: Datastage 8.1, Teradata, Autosys, Oracle PL/SQL HP Service Manager Tool and UNIX

Responsibilities:

• Collecting the project details from the existing production system
• Exporting the project from the DataStage 8.0 version and importing it in the new Datastage 8.1 environment and compiling the jobs
• Setup the UNIX environment for the projects and giving permissions to the users
• Developing the Autosys environment for running the jobs and editing the scripts in UNIX
• Scheduling the job through Autosys
• Involved in various phases of testing like environment testing, SIT and PRT
• Test all the components in the development environment, fix new errors / warnings and make necessary changes in order to make all the components function as in the existing environment
• Preparing the documents for the environment setup request in the new production system
• Preparing the production package with all the required documents like test case and migration documents, .dsx files and Unix scripts