PROFESSIONAL SUMMARY:

• IT professional with 10 years of rich experience in IT service and consulting industry, currently working as a Senior ETL Consultant at Confidential .
• Expertise on data integration, data quality, data cleansing and data processing using SAP BO Data Services (BODS) , business reporting using WEBI, Dashboard and Crystal Reports.
• Extensively worked in the field of data warehousing with ETL tools such as SAP BO DATA Services(BODS),Informatica 9x,, integrating with Oracle11g, MS SQL server 2008 & 2012, DB2, VSAM, XML, Mainframe - flat files to design and develop high-quality product and solution for the business need.
• Well versed in various programming languages such as Windows- Power shell scripting, Mainframe - COBOL, JCL.
• Used different service management tools and change management tools for entire SDLC process of project as well as providing support and maintenance for product after go-live: Service Now, IBM Lotus PTM, HP Service Centre and BMC Service desk, JIRA.
• Sound domain knowledge on Banking, Finance, HealthCare, Government Labor Department.
• Created and maintained project document like, detailed design document, Test Plan and implementation document, code review, migration document and so on.
• Involved in various phases of projects including Requirement analyzing, Designing, prototyping, development, documentation, review and testing.
• Experience in working with multiple vendors, Offshore and cross functional team in various project management methodologies including Agile and Waterfall models.

SKILL:

ETL Tools: SAP BO Data Services (BODS), WEBI, Dashboard and Crystal Reports, Informatica Power center, Informatica Power Exchange, B2B Data Transformation, Pentaho, Data Flux.

Databases: Ms SQL Server 2008 and 2012, Oracle 11g, IBM DB2

Scheduler: Autosys, Control-M,CA 7

Service Management tools: Service Now,JIRA,INFOMAN

Mainframe Skills: COBOL, JCL,VSAM, DB2, SDF, Z/OS

Languages: Window Scripting, VS-COBOL - II, JCL

Operating systems: MVS/390,Z/OS, WINDOWS

Domain Experience: Banking, Finance & Healthcare, Government Department of Labor

Project Methodologies: Agile, Waterfall

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Understanding business requirements and converting them into technical requirements and creating the requirement documents.
• Designed the solution, creating/modifying the Data Models, defining the Data Dictionary and data mapping specs
• Worked hands-on on the complex mapping and scripting for the quality and timely delivery of the product using the SAP BODS.
• Effectively communicated with the stakeholders to understand the changing requirements, plan the release, building the solution and testing the quality of the solution with the third-party vendors, implementation plan through meetings as in required.
• Plan the SIT and UAT and facilitate the same throughout life cycle before release of the product.
• Provide the after go-live support and resolve the production issues.
• Preparing the project artifacts such as Test plan, Implementation plan & Schedule and Recovery manual.

Environment: SAP BO Data Services (BODS), WEBI, Dashboard and Crystal Reports

Confidential

Responsibilities:

• Understanding Client business requirements and converting them into technical requirements and creating the requirement document for the team members
• Prioritize the user stories and backlogs to initiate the design and execution phase of the project in each sprint/release
• Designed the solution around the ETL Informatica Tool integrating with the client provided resources
• Provided the direction and solution to the offshore team by regular day to day communication
• Worked hands-on on the complex mapping and scripting for the quality and timely delivery of the product.
• Effectively communicated with the stakeholders to understand the changing requirements, plan the sprint, retrospective of sprint and sprint release, implementation plan through daily standup and meetings as in required.
• Plan the SIT and UAT and facilitate the same throughout the sprints before release of the product.
• Interact with the change control board to implement the product smoothly into the Production environment.
• Maintained the defect life cycle to improvise the product quality.
• Provide the after go-live support and resolve the production issues as per the SLA.
• Facilitate any customer level escalation through proper channel by interacting with the onsite management and offshore team as in required.
• Provide the project progress and forecast the risk to the upper management.

Environment: Informatica power center, B2b data /transformation. UNIX, Oracle

Confidential

Senior Business Analyst

Responsibilities:

• Identified and assessed areas of functionality by leveraging existing tools, applications and services.
• Participated in Requirement Gathering, Understanding Customer Requirements & documenting the complexity of the ETL system integration with application.
• Mapped these Requirements to the Product Functionality
• Participates in all phases of the development lifecycle including analysis, design, development, testing, code reviews and documentation throughout all the iteration and releases.
• Integrated the developed component to the existing environment.
• Participated in Test case building and execution for validating the ETL system.
• Provided implementation plan for smooth transition into the Production environment
• Represented the changes in the Change control Board
• Closed the defects following the defect lifecycle
• Provided the support for the further optimization of the ETL products

Environment: Informatica power center, B2B Data Transformation, UNIX, Oracle

Confidential

Responsibilities:

• Interacted with the onshore coordinator on daily basis to understand the business requirements.
• Worked with project teams to refine business requirements to technical specification that produce well-designed and developed solutions.
• Worked on different sources like Mainframe files, DB Tables, flat files and FTP sources.
• Analyze the data flow requirements and develops a scalable architecture for staging and loading data.
• Prepare/implement data verification and testing methods.
• Worked with multiple pipeline mappings.
• Created complex workflows with more than 50 sessions including decision and event tasks.
• Created Mapping documents, Production Implementation Documents.
• Providing KT sessions to new joiners on the system overview and useful process being followed.
• Co-ordinate the release activates before and on the day of release.

Environment: Informatica, SQL Server, PL SQL, IBM Initiate Inspector, UNIX

Confidential

Responsibilities:

• Gathered requirements for the new applications on mainframes and mid-range systems from Functional & nonfunctional document received from onsite counterpart.
• Developed code in COBOL as well as Informatica ETL mappings as per requirement.
• Providing extract for UAT, jobs scheduling and implementing the jobs in production using version control tool ENDEVOR.
• Using tool PTM (Production Turnover Management) to put the jobs in production along with
• Assessed the Impact of change on component level.
• Test the NDM scripts with third party vendors to assure successful transmission of datasets.
• Production Support for Confidential application maintaining the defined SLA.
• Resolve user tickets and productions issues.
• Continuous Improvement for the Application, Project releases and support.

Environment: Mainframe, COBOL/DB2, JCL, VSAM, CA7, FILAID, CHANGEMAN, Informatica 9.5.1 Power Center, UNIX shell Scripting.

Confidential

Responsibilities:

• Interacted with business users and onshore team for requirements gathering of new enhancements.
• Provide status to the upper management on the progress of tasks.
• Maintenance and Enhancement of ETL Interfaces for data extraction into SDR.
• Extensively used Informatica for loading the data from sources involving flat files to target as relational table.
• Designing various mappings as per the business requirement.
• Unit testing workflows at in DEV & QA.
• Peer reviewing the mappings.
• Batch Jobs Monitoring & Reporting for ETL workflows.
• Escalation process in the event of Job failures according to severity and SLA.
• Monitoring of Service Centre Tickets .

Environment: Informatica, SQL Server, PL SQL, IBM Initiate Inspector, UNIX

Confidential

Responsibilities:

• Involved in understanding the existing system and providing a suggestion for redesigning the existing process and finding an opportunity for Performance tuning in jobs.
• Performed Mainframe coding using COBOL/DB2, JCL and EASYTRIEVE.
• 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.
• Unit testing workflows at in DEV & QA.
• Batch Jobs Monitoring, Minor Enhancements.
• Monitoring of Service Centre Tickets.

Environment: COBOL, JCL, VSAM, DB2, SPUFI, File-Aid, CA-7, CHANGEMAN, EXPEDITER, EASYTRIEVE

Confidential, Caterpillar

Responsibilities:

• Involved in understanding the existing system process and providing a suggestion for redesigning the existing process and finding an opportunity for Performance tuning in jobs.
• Requirements gathering from business analyst and creating technical specifications.
• Prepared detailed design for new interfaces, programs, jobs, DB2 tables.
• Created Common module and routines to get better performance and reusability.
• Used SPUFI to write SQL queries for extensive backend testing and to ensure proper backup and restoring of data.
• Production Support to maintaining the defined SLA.
• Resolving user tickets and productions issue.
• Continuous Improvement for the Application, Project releases and support.
• To develop and code all the elements JCL, COBOL, CONTROL CARDS, DOCs as per standard.
• Testing after the development of code and to upload the test results in Mercury for Audit purpose and to send the code for UAT using version control tool ENDEVOR.
• Monitoring of Service Centre Tickets.

Environment: COBOL, DB2, SDF, JCL, FILE-AID and ENDEVOR

Confidential

Responsibilities:

• Analyze the ASSEMBLER codes and rewrite them in COBOL.
• Migration of Easytrieve components to COBOL-Reporting Programs.
• Prepare the migration standard Document which followed in project development process.
• Good experience with relational databases DB2.
• Experience in analyzing the entire system and the impact with the other backend and front-end systems.
• Contributed in Project Requirement Analysis meetings with the onshore team.
• Coordinated with the Onsite counterpart during production moves and support.
• Participated in weekly status meetings and contributed views in project proceedings with Onsite counterpart.
• Coordinated with the testing team for QA testing.
• Experience in adhering to coding standards and finishing on time.
• Capable team player who works well with people at all levels.
• Scheduling/allocating/monitoring work among the team and being responsible for the successful delivery of the entire project/sub-project(s).

Environment: COBOL, ASSEMBLER, EASYTRIEVE, JCL, NET EXPRESS.MAINFRAME EXPRESS