SUMMARY

• Around 7+ years of experience in IT Application development and maintenance support with Datastage (IIS V11.3),Tivoli Workload Scheduler (TWS) and Mainframes skill set of DB2, JCL also with UNIX skill sets and experience in support projects for Confidential &T Account and Confidential Global Account.
• Well versed in components of Hadoop ecosystem - HDFS,MapReduce,HIVE,PIG,Sqoop & HBase by attending several key training in Big data & unstructured data handling.
• Lead 8 member Maintenance support team coordinating technically on ETL Datastage and Mainframe.
• Strong ability to learn new technologies in short span and implement independently.
• Proficient in leading dedicated teams for running successful projects and effective communicator with excellent relationship building & interpersonal skills.
• As a Senior System Engineer, I was responsible for interfacing with the Confidential &T technical team, application system engineers to gather requirements, conduct impact analysis, documenting the requirements and present the conclusions to the technical and business teams.
• Responsible to perform detailed study questioning the end-users for reporting data elements, analyze data flows and identify integration patterns to design a high level Solution plan.
• Responsible for building the detailed design defining: ETL migration methods, data integration and transformation rules, collaborate with data architects and to define data hierarchy and build the physical data mode.
• Responsible for communicating the business priorities and explain the design approach and provide guidance to the development teams to ensure the implementation of the requirements meet the business needs
• Responsible for helping in Building and data extraction and transformation solutions in accordance with EBDP (Enterprise Bulk Data Processing) methodology adopted by Confidential &T - Confidential .
• Performing detailed study questioning the end-users for reporting data elements, analyzing work flow and identifying integration patterns to design a high-level solution plan.
• Possessing extensive experience in Data Warehousing concepts with emphasis on ETL and life cycle development includes requirement analysis, design, development, testing and implementation.
• Responsible for Build or enhance applications/data services in support of the enterprise target architecture for Enterprise Bulk Data Processing by getting ordering, Provisioning and Billing data from various platforms to a single view.
• Responsible for Client Support: Interfacing with the customers for day to day Operational issues and resolution of the same.
• Experience in Data Modeling using Star Schema/Snowflake Schema, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and logical data modeling using ERWIN 4.x/3.x.
• Responsible for track the project progress working with technical leads; develop deliver progress reports, presentation and communicate the project status, issues and risks to the client and stake holders.
• Experience in integration of various Operational Data Sources (ODS) with multiple feed/sources like VSAM files, Flat files, RDBMS etc.
• Works with Confidential and Confidential &T senior management team to estimate the proposals, budgeting, project planning and execution.
• Responsible for mentoring, coaching the client’s support teams and provides assistance working with them to resolve user issues.
• Converted existing programs which were in DB2 to Oracle compatible procedures,routines and programs.
• Excellent technical and communication skills and ability to work effectively and efficiently in teams.
• Extensive experience in Confidential InfoSphere 11.3, Confidential InfoSphere 9.1, Confidential InfoSphere 8.1 (DataStage, QualityStage, Information Analyzer, Metadata Workbench), Confidential WebSphere 8.0 (DataStage, Information Analyzer, QualityStage).

TECHNICAL SKILLS

Tools: Ascential Datastage V 7.1.08/7.5.1.38 , Confidential Information Server(Datastage) 8.7.0/11.3.1.1 , 11.5.0, TOAD, Tivoli Workload Scheduler,SQL*Loader, SQL*Plus, PL/SQL Developer, Autosys, Confidential Websphere Business Modeler, Confidential OPAL(On Demand Process Asset Library), PRISM,SCME,ALM, SVN, Putty, Microsoft office package.

Scripting: UNIX shell

Databases: DB2, Oracle 11g/10g/9i, Oracle 11i, Mainframe

Languages Known: PL/SQL, SQL

Operating System: Unix Solaris, Linux, Windows

Framework: Hadoop V1.0 & V2.0 (Bigdata)

Project Methodology: Agile, Scrum

PROFESSIONAL EXPERIENCE

Confidential, Rochester, MN

Technical Lead - ETL

Responsibilities:

• Performed column analysis, rule analysis, primary key analysis, natural key analysis, foreign-key analysis, and cross-domain analysis.
• Performed detailed study questioning the end-users for reporting data elements, analyzing data flows and identifying integration patterns to design a high-level solution plan
• Performed data profiling on various source systems to identify and accommodate the required data from different interfacing systems into the Enterprise Data Warehouse (EDW)
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Developed data analyzing solutions, run analysis jobs, reviewed results, created and managed data quality controls using Information Analyzer.
• Performed source to target mapping straight out of modelling tool that imports model straight into the Metadata Server via a bridge with the help of Confidential Info sphere Fast track.
• Was responsible for building the detailed design defining ETL migration methods, data integration and transformation rules; collaborated with data architects and defined data hierarchy and built the physical data model.
• Executed data cleansing through standardizing customer data, verifying international addresses, identifying duplicate records, and applying data rules by integrating stages from Confidential Quality Stage.
• Involved in understanding the scope of application, present schema, data model and defining relationship within and between groups of data.
• Possessed extensive experience in Data Warehousing concepts with emphasis on ETL and life cycle development includes requirement analysis, design, development, testing and implementation.
• Was responsible in building SQL queries for Oracle to fetch the data from the Database as per the business requirement and use the SQL queries/function/packages in the Data Stage for further processing.
• Created Audit jobs and generated Reconciliation reports balancing the Source and target record (Source-to-Target mapping) counts using DSJobReport Functions by reading job logs.
• Verified the Cognos Report by extracting data from the Staging Database using PL/SQL queries.

Confidential

Senior ETL developer

Responsibilities:

• Responsible for interfacing with the Confidential &T technical team, application system engineers to gather requirements, conduct impact analysis, documenting the requirements and present the conclusions to the technical and business teams.
• Functioning as a single point of contact for both Confidential &T and Confidential technical teams and the senior management.
• Worked on agile development model, test case writing, Root cause analysis, triage, bug filing for automated suites.
• To perform detailed study questioning the end-users for reporting data elements, analyze data flows and identify integration patterns to design a high level solution plan.
• Responsible for building the detailed design defining: ETL migration methods, data integration and transformation rules, collaborate with data architects and to define data hierarchy and build the physical data mode.
• Experience in using various transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter, Joiner, Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalizer, sequence generator, etc to implement complex business logic.
• Responsible for communicating the business priorities and explain the design approach and provide guidance to the development teams to ensure the implementation of the requirements meet the business needs.
• Responsible for helping in Building and data extraction and Transformation solutions in accordance with EBDP (Enterprise Bulk Data Processing) methodology adopted by Confidential &T - Confidential .
• Responsible for Build or enhance applications/data services in support of the enterprise target architecture for Enterprise Bulk Data Processing by getting ordering, provisioning and Billing data from various platforms to a single view.
• Responsible for Client Support: Interfacing with the customers for day to day operational issues and resolution of the same.
• Responsible for track the project progress working with technical leads & develop deliver progress reports, presentation and communicate the project status, issues and risks to the client and stake holders.
• Worked with Confidential and Confidential &T senior management team to estimate the Proposals,budgeting, project planning and execution.
• Responsible for mentoring, coaching the client’s support teams and Provides assistance working with them to resolve user issues.
• Responsible for tracking the project with the processes and quality standards for both Confidential (QMS- Quality Management System) and client Confidential &T(PRISM).
• Very actively tracking the defects and change requests working with the system engineers and architects and uses tracking tools like RMA (Risk Management Application), TPM(Test Process Model), Requisite-Pro to ensure the process if followed.

Environment: Data stage: V7.1x,V7.5x,V8.7 & V11.3x

Confidential

ETL Datastage Developer

Responsibilities:

• Expertise in application maintenance and support for this incentive and commission payable application.
• Interacted well with the global clients and importantly handled all the critical production issue during installation & monthly production cycle and the impact of it earning their trust to a greater extent.
• Responsible for leading the Off-shore Production team to trouble shoot the issues faced in day-to-day activities.
• Worked with Quality stage to improve quality of incoming data as data is coming from different sources there will be duplicates.
• Spanned across my versatility by working on various technologies like Mainframe, UNIX and very efficient working on Datastage.
• Developed many innovative tools in Mainframes to reduce the manual efforts and repetitive works.
• End to end release planning for firm wide regulatory releases for fiscal year 2015 to reengineer all product reference data re design.
• Exceptional analytical and problem solving skills. Team player with the ability to communicate effectively Confidential all levels of the development process.
• Extensive experience in Confidential InfoSphere 11.3, Confidential InfoSphere 9.1, Confidential InfoSphere 8.1 (DataStage, QualityStage, Information Analyzer, Metadata Workbench), Confidential WebSphere 8.0 (DataStage, Information Analyzer, QualityStage).
• Served a vital role as an offshore lead and my versatility on Datastage & Mainframe giving flexibility for the project to go beyond the expectations of the customers, providing quality deliverables before the deadlines.
• Worked with File Transfer Protocol (FTP) and Secure File Transfer Protocol (SFTP) to pull or send the files from one server to another server.
• Designed adhoc job in datastage which helps to reconcile the achievement data of the eligible employees in a proper reporting format which runs each and every week to update the client team.

Data stage: V7.1x,V7.5x, Information Analyzer, Quality Stage

Confidential

ETL Datastage Developer

Responsibilities:

• Responsible to lead the team of 11 members from offshore to deliver solutions across four geographies America, Europe, Asia Pacific South and Japan .
• Actively involved for team resource planning and support for monthly production activities .
• Responsible to prepare monthly runbooks as per the client requirements and presenting them during client meetings.
• Responsible to assess the risks involved in running monthly production cycles and take necessary actions to mitigate them.
• Responsible to interlock with other distributed teams during his daily support tasks and ensure the efficient execution of production cycle.
• Responsible to provide costing information to customer for the expenses incurred in case of critical data recovery .
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
• Involves creation and implementation of all the changes required in production code, storage subsystem and database subsystem.
• Responsible for assessing the risks involved in these change implementations. He is responsible to create Project Change Requests (PCR) for incorporating the new requirements form customer. During this process, I was responsible to assess the feasibility of the customer demands and accordingly provide improvement comments to allied teams.
• Took care of quality procedures for analysis, program specifications, exhaustive test plans, defect tracking, change procedures etc.
• Responsible for Scheduling & attending daily meeting with end client for status reporting .Establish Quality Procedure for the team and continuously monitors to ensure team meets quality goals.

Data stage: V7.1x,V7.5x