SUMMARY

• A growth driven self - motivated Datastage / Mainframe Analyst with over 10.1 years of progressive experience in the Business Information Management sphere.
• Offering a rich mixture of business and technical expertise in Mainframe, ETL and reporting, lineal to the Banking / Financial and Insurancedomain.
• A track record in consulting, requirement analysis, designing, developing, testing, integrating and implementing novel end-to-end Business solutions, aligned with critical business requirements, under stringent deadlines, for ace business corporations.
• 10.1 years of working experience for Confidential Consultancy Services both at onshore and offshore in various capacities.
• 4.1 Years of ETL Data Stage Experience and 6 Years of Mainframe Experience
• Very strong experience with various migrations and acquetions projects in both Data Stage and Mainframe.
• Strong design experience to independently turn Physical Data Model into Data Stage job design.
• Strong Data Stage implémentation skill to complete implementation within tight Project Schedule.
• Expert level knowledge of relational databases (especially DB2 and Oracle) and worked on Flat files
• Experienced in Full Life Cycle Development of building a Operational Data Store for large technology projects including Analysis, Design, Development, Testing, Maintenance and Documentation.
• Good Unix shell scripting skill.
• Extensively Worked on Job Sequences to control the execution of the job flow using various activities like Job Activity, Email Notification, Sequencer, Routine activity and Exec Command Activities
• Complete team co-ordination involving task allocation among team members and holding frequent discussions to monitor progress of project work
• Extensively worked on Parallel Jobs using Various Stages like Join, Lookup. Lookup File Set, Change Capture, Filter, Funnel, Copy, Sort, File set, Sequential File, Data set, Oracle Enterprise, Merge, Aggregator, Remove Duplicate Stages, Pivot Stage, Stored Procedure stage, CFF Stage.
• Good expérience in the Conversion projects, Data migrations and Mainframe to ETL technology transformation projects.
• Good experience with Client Interaction, On shore - Offshore working model.
• Quick learner with excellent analytical and problem solving skills.
• Good interpersonal, written and verbal communication skills. Multilingual, highly organized, detail-oriented professional with strong technical skills.
• Passionate about all aspects of the software development life-cycle, from design through development, deployment, Production Support and Data Quality & Data Management.

TECHNICAL SKILLS

Operating Systems: Unix, Win95/NT/2000/XP, IBM Mainframe Z/OS

Languages/Scripting: Unix Shell Scripting,SQL,PL/SQL,COBOL,JCL,Eazytrieve

Database: IBM - DB2, Oracle 11g

ETL Tools: IBM Info Sphere Data Stage 8.7((Administrator, Manager, Designer, Director), Tectia Terminal and File Transfer,XML Spy,TFS,Eclipse

Mainframe Supporting Tools: FILE-AID, FILD, DB2I, Spufi, SDSF, Change-Man, Expeditor (batch and online), Abend-Aid, SAR, CA7, QMF, NDM

Other Tools: Microsoft Visio, Ultra Edit, Clear Case IBM Data Studio 3.1,TOAD for DB2, SQL Developer for Oracle, Quality Center, Maximo,Remedy,SharePoint CHANGEMAN,CA7,NEXUS

Methods: Waterfall Model, AGILE

Domain Experience: Insurance, Banking and Finance Services, Retail

PROFESSIONAL EXPERIENCE

Confidential, Charlotte

Data Analyst

Responsibilities:

• Working with client and IT management and staffto establish and maintain consistent data element definitions across computing environments
• Working with Business Analysts, Solutions Architects, and Systems Analysts to design solutions for clients
• Create/Refine technical specifications.
• Analyzing and developing the logical data designs, data models.
• Defining the data validation rules / standards
• Understanding the data requirements, data types, possible values and understand the structure of data in Web service
• Identifying the ACORD XML tags/JSON structure for each of the new data elements
• Creating Request Data Mapping for the identified data elements with transformations for Real time interface
• Creating the Response Data Mapping for the identified data elements with transformations for Real time interface
• Creating the Data Mapping for all new data elements with transformations for batch interface
• Working with the middleware and application teams to address all the Data Quality & Data Integration issues
• Creating sample Request XML/JSON Request for Real time interface
• Creating sample Response XML/JSON Response for Real time interface
• Create sample Request XML for batch interface
• Create SID for real time interfaces
• Create BID for batch interfaces
• Review the Data Mapping and BID/SID with the middleware and application teams
• Producing the necessary documents to ensure transition to support team once development is complete

Confidential, Charlotte

Technical Lead

Responsibilities:

• Project Planning and Monitoring
• Designing system technically and Writing Technical Specifications of project
• Creating High Level and Low-level ETL Flow Diagram in Visio
• Designing concept template jobs and shared containers to help reduce the development time
• Created POCs for extracting data from complex source XML repeating tags
• Creating and handling larger EBCDIC files
• Have created routines for different functionality
• ETL Development for Control Architecture, Common Modules, Sequence Controls and major critical interfaces
• ETL Jobs and Sequences performance tuning
• Documentation of all the TCS developed modules of the project
• Educating the team with the design approaches, performance monitoring techniques, bug fixing and timely responses for issues
• Create master controlling sequence jobs using the Data Stage Job Sequence.
• Used Data Stage Manager for importing metadata from repository, new job categories and creating new data elements.
• Used Data Stage Parallel Extender parallel jobs for improving the performance of jobs.
• Dealt extensively with data from Mainframe, DB2, XML, Flat file and SQL Server sources.
• Used Data Stage Director to validate schedule run and monitor the data stage jobs
• Developed user defined Routines and Transforms by using Universe Basic.
• Used Before/After Job-Subroutines in Job Properties.
• Responsible for performance tuning
• Used Data Stage for developing, programs for scheduling data loading and transformations
• Developing shell scripts to automate file manipulation and data loading procedures
• Error Logs/Audit Trails were maintained.

Confidential, Charlotte

Technical Lead

Responsibilities:

• Responsible for reviewing functional specifications and preparing technical design framework for ETL.
• Interacted extensively with client/onsite team to resolve technical and infrastructural issues.
• Review LLD & HLD documents as per the requirements specification documents.
• Interacted with Business Partners to understand the business requirements, Analyze and design the integration Approach.
• Performed ETL coding using Datasets, Sequential file, Transformer, Sort, Merge, Aggregator stages compiled, debugged and tested.
• Extensively used stages available to redesign Data Stage jobs for performing the required integration.
• Used Data Stage Designer tools for creating Parallel jobs and importing and exporting the jobs.
• Used Data Stage Job Sequences to execute the jobs in a sequence order.
• Used Quality stages for enrich data to meet business objectives and data quality management standards.
• Created Data Stage Jobs to build business rules to load data.
• Used Data Stage Director to run and monitor status of the jobs.
• Imported table/file definitions into the Data stage repository.
• Controlled jobs execution using sequencer, used notification activity to send email alerts.
• Involved in Performance Tuning and Enhancement.
• Used Autosys job scheduler for automating the regular BAU Calendar schedule cycle in both production and UAT environments.
• Coordinating with Release Management, Data Management and Configuration Management.
• Ensure technical relationships with third party vendors.
• Support Bank’s acceptance testing needs.
• Conduct the Weekly Status meetings with onshore and offshore Teams.

Confidential, Texas

Technical Lead

Responsibilities:

• Involved in Analyzing the existing mainframe programs and creating the Requirement documents.
• Performed Mainframe coding using COBOL/DB2, JCL and Eazytrieve.
• Used CA7 Scheduler to schedule and execute the jobs based on the calendar schedule.
• Used SDSF/SAR to run and monitor status of the jobs.
• Responsible for reviewing functional specifications and preparing technical design framework for ETL.
• Interacted extensively with client/onsite team to resolve technical and infrastructural issues.
• Review LLD & HLD documents as per the requirements specification documents.
• Interacted with Business Partners to understand the business requirements, Analyze and design the integration Approach.
• Performed ETL coding using Datasets, Sequential file, Transformer, Sort, Merge, Aggregator stages compiled, debugged and tested.
• Extensively used stages available to redesign DataStage jobs for performing the required integration.
• Used DataStage Designer tools for creating Parallel jobs and importing and exporting the jobs.
• Used DataStage Job Sequences to execute the jobs in a sequence order.
• Used Quality stages for enrich data to meet business objectives and data quality management standards.
• Created DataStage Jobs to build business rules to load data.
• Used DataStage Director to run and monitor status of the jobs.
• Imported table/file definitions into the Data stage repository.
• Controlled jobs execution using sequencer, used notification activity to send email alerts.
• Involved in Performance Tuning and Enhancement.
• Used Autosys job scheduler for automating the regular BAU Calendar schedule cycle in both production and UAT environments.
• Coordinating with Release Management, Data Management and Configuration Management.
• Ensure technical relationships with third party vendors.
• Support Bank’s acceptance testing needs.
• Conduct the Weekly Status meetings with onshore and offshore Teams.

Confidential, Charlotte

Technical Lead

Responsibilities:

• Involved in Analyzing the existing mainframe programs and creating the Requirement documents.
• Performed Mainframe coding using COBOL/DB2, JCL and Eazytrieve.
• Used CA7 Scheduler to schedule and execute the jobs based on the calendar schedule.
• Used SDSF/SAR to run and monitor status of the jobs.
• Responsible for reviewing functional specifications and preparing technical design framework for ETL.
• Interacted extensively with client/onsite team to resolve technical and infrastructural issues.
• Review LLD & HLD documents as per the requirements specification documents.
• Interacted with Business Partners to understand the business requirements, Analyze and design the integration Approach.
• Coordinating with Release Management, Data Management and Configuration Management.
• Ensure technical relationships with third party vendors.
• Support Bank’s acceptance testing needs.
• Conduct the Weekly Status meetings with onshore and offshore Teams.
• Participate in Disaster recovery process.
• Lead the offshore Time deposits team

Confidential, Charlotte

Technical Lead /Team Member

Responsibilities:

• Creation / Implementation of NDM & FTP processes.
• Run Time Improvement/Automation
• CA7 Scheduling Exceptions
• Update JCL, PROC’s and Parms for abend resolution
• ABENDS - reruns and restart
• Contention Resolution
• Performance improvements
• Conducting Reviews of Software artifacts
• Conducting FI for the assigned Projects
• Creation and assignment of tasks to the team members and delegation of work for timely completion.
• Using IPMS for all project management related quality activities.
• Performing configuration management.
• Lead the off shore team

Confidential, Green bay, Wisconsin

Technical Lead /Team Member

Responsibilities:

• Discussions with RMS Confidential team based on the System Requirements
• Document to cover the functionality with reduced CPU time, operationally, technical issues and scope of work

Confidential, Green bay, Wisconsin

Programmer /Team Member

Responsibilities:

• Involved in Analyzing the existing mainframe programs and creating the Requirement documents.
• Performed Mainframe coding using COBOL/DB2, JCL and Eazytrieve.
• Used CA7 Scheduler to schedule and execute the jobs based on the callendar schedule.
• Used SDSF/SAR to run and monitor status of the jobs.
• Responsible for reviewing functional specifications and preparing technical design framework for ETL.
• Interacted extensively with client/onsite team to resolve technical and infrastructural issues.
• Review LLD & HLD documents as per the requirements specification documents.
• Interacted with Business Partners to understand the business requirements, Analyze and design the integration Approach.
• Coordinating with Release Management, Data Management and Configuration Management.
• Ensure technical relationships with third party vendors.
• Support Bank’s acceptance testing needs.
• Conduct the Weekly Status meetings with onshore and offshore Teams.
• Participate in Disaster recovery process.
• Lead the offshore Time deposits team