SUMMARY:

• Having around 14 yrs of total IT experience in IBM Infosphere DataStage v11.x, Netezza 7.2, Unix, Autosys R4.5 and R11, Hyperion IR9.X, and Mainframe Technologies.
• Major strength and experience has been predominantly in the ETL spaces 9+ yrs of ETL experience (with the exposure to 7yrs to Datastage and 2+yrs to Hyperion IR Reporting) and rest on Mainframe Technologies.
• Involved in identifying the business requirements and analyzing them in support of Data Warehousing (ETL) efforts.
• Consulted with end - users to determine their data needs and constructed flexible data models to satisfy the business requirements.
• Reviewed System Design Documents for the Data Acquisition Requirements for moving data from external systems to Staging Area, Source-to-Target Mapping and Transformation strategy Documents.
• Very Strong Database skills that include build/maintain SQL scripts.
• Excellent knowledge in complete software development life cycle involving analysis, design, development, deployment, testing, documentation, implementation & maintenance of application.
• Executed projects with teams at Onsite/Offshore that are diverse and geographically distributed across USA and multiple cities in India.
• Strong Understanding existing business model and customer requirements.
• Good Domain capability in
• Insurance with focus on Agency and IIA concepts
• Customer information distributed following MDM Architecture
• Insurance Claim processing using Guidewire Claims Center
• Designed Mapping Specifications on the basis of Functional Requirements to create the ETL Mappings.
• Extensively used rule based Data cleansing, data conversion & process implementation.
• Successfully automated several mundane manual and tedious activities.
• Successfully delivered Client value additions and process improvements.
• Strong analytical, design skills and problem solving abilities.

Skill Summary

Operating System: UNIX, MVS/OS390

Languages: Unix shell scripting, COBOL, REXX and JCL

Database: Netezza, DB2, Teradata

ETL Tools: IBM Webshpere Datastage 8.1/8.5

ETL Reporting Tools: Hyperion IR 9.X

Scheduling Tools: Control-M, Autosys R 4.5, R11, Maestro, CA7

Version Control : IIS ClearCase, Changeman, Endevor

Tools: FILE-AID, XPEDITOR, Changeman, QMF, PlatinumSPUFI, Endevor, CA-7, Test Director, HP Quality Center, Intertest, Softech

PROFESSIONAL EXPERIENCE:

Confidential

ETL Datastage Lead/Architect, NiSource, Ohio

NiSource is a holding company with headquarters in Merrillville, Ind., whose operating companies engage in virtually all phases of the natural gas business from exploration and production to transmission, storage and distribution, as well as electric generation, transmission and distribution.

Responsibilities:

• Followed the agile methodology to provide and develop ETL architecture to implement data elements from Core Systems (CIS, DIS, WMS, and Maximo) to a staging layer. Land the data elements in staging layer pertaining to the Customer, Work, and Asset domains, from the CIS, DIS, Maximo, and WMS transactional systems to the Data Lake (CDH Core Data hub). The CDH will leverage the IBM Data Model for Energy and Utilities (DMEU) for the structured data set up.
• Design the ETL solution along with audit requirements to build the stage layer for Core Systems (CIS, DIS, WMS, and Maximo).
• Develop and integrate the ETL Architecture, Audit and load components
• Design and develop the ETL solution to land the data elements from Stage layer to Core Data Hub (CDH)
• Lead the team to implement the ETL solution.
• Coordinate with Data analysts, Business teams, Data Modelers, Infrastructure Team

Environment: IBM Infosphere Datastage 11.3, UNIX, DB2 10.0, Squirrel

Confidential

ETL DI Lead, Westfield Insurance, Westfield Center, Ohio

Providing architectural solution for DI ETL-OLS & Non-BI Applications.Data Integration Team provides the Development, Application support and maintenance to BI Datawarehouse, OLS (Online Stage), Non-BI, Month end reporting to cover the analytics, reporting, research on the base data available through Policy Management System. The information available in OLS and other base data is used to build the Enterprise Warehouse and there by Datamarts.

Responsibilities:

• Onsite Lead to support, develop and deliver ETL Applications.
• Led the team in design and delivery of IIS upgrade 11.5.
• Provide application support and maintenance for ETL Applications.
• Designed and developed ETL Applications and control M scheduling mechanism to support daily batch loads.
• Reviewed System Design Documents for the Data Acquisition Requirements for moving data from external systems to Staging Area, Source-to-Target Mapping and Transformation strategy Documents.
• Design and deliver of data validation rules (Load balance, Structural balance, balance on measures) with IIS Datastage for generating the Alerts and updating data into the ETL Applicaions.
• Maintain Guidewire Claim center ODS to DI ETL Application Database using Datastage / Netezza. Support and develop complex Claims reports out of Netezza Claims ODS.
• Support the Mainframe part of the DI ETL Applications
• Identify the areas of improvement in process and implement the improved methods.
• Automate complex manual repetitive activity as part of the Project.
• Management Reporting.

Environment: IBM Infosphere Datastage 11.5, 8.5, UNIX, Netezza 7.2, DB2 10.0, Control-M

ETL Offshore Lead, Confidential

Led the CCR (Current Currency Refresh) Autosys Migration R11 Project. CIBC’s DSE Applications (are developed in Datastage, Unix, Autosys and Oracle 10G Database) running on ETL Server and uses Databases on DM1 (Daily) and DM2 (Weekly and Monthly) Servers. The aim of the project is to migrate from Autosys R4.5 to Enterprise Autosys R11 and connect to only one DB Server (DM1 and DM2 databases will be on one server after the implementation of this project). There are 6500 Autosys Jobs (R 4.5) and 400+ Unix Scripts which had to be analyzed and changed for Autosys migration and to maintain DB on one Server.

Responsibilities:

• Preparation of Technical specification document based on the Initial design document.
• Develop the Autosys jobs as per R11 standards and Unix scripts to have DB in one server.
• Automate any manual repetitive activity as part of the Project.
• Migrate Autosys JIL’s to ClearCase.

Environment: IBM Infosphere Datastage 8.5, Oracle 10G, UNIX, Autosys (R 4.5, R11), IIS ClearCase.

ETL Developer, Confidential (BOA Data Systems):

WCC Inbound: Convert WCC Inbound processes from Mainframe to Data Integration Platform. All the requirements, Data validations remain same as in Mainframe Jobs. There are around 50 Inbound processes that run in Mainframe Environment that feed data into WCC Tables. Processes are classified into 2 groups. 1. Direct Database 2. OAG Update.

Processesses under Direct Database update will Add/Update/Delete the data directly from WCC tables after performing the required validations. OAG processes / data will be published to Message queue and Message queue will take care of updating the data in WCC Tables.

WCC Outbound: Convert WCC Outbound processes from Mainframe to Data Integration Platform. All the requirements, Data validations remain same as in Mainframe Jobs. There are around 80 Outbound processes running in Mainframe Environment that generate the CFF/Flat files for the use of down stream Applications.

Responsibilities:

• Understand the business requirement provided in the high level requirement documents, development of application.
• Design jobs to replicate the existing system using Data stage.
• Create and Review application mapping document to do a source system analysis and hence prepare a source to target mapping document applying the business rules and logics.
• Develop the Application following the ETL mapping and design document.
• Identify Issues and Risks and work proactively to eliminate them.
• Review system test cases, Codes prepared by development team to ensure a quality delivery.
• Schedule week status meeting with client and onsite team; provide updates on each task/ projects being handled.

Environment: WCC data following MDM Architecture, IBM Infosphere Datastage 8.5, UNIX, Autosys, IIS ClearCase and DB2, MF Techs.

Mainframe Team Lead, Confidential:

Deliver the enhancements to the Applications VISION, Brokerage Services, Passport and PPR.

Responsibilities:

• Lead the Team to deliver the enhancements successfully in the given timelines.
• Develop the application knowledge within and among other teams.
• Create the value additions apart from the regular Client deliverables.
• Coordinate the communication with Onsite Team.
• Resolve the technical and functional issues of the Team
• Take care of the critical enhancements.
• Manage the teaming activities within and with other teams.
• Status reporting of the team.

Environment: Cobol, db2, jcl, File-aid,Xpeditor.

Confidential:: Software Developer

Onsite Hyperion / Mainframe Developer: USA

Development and maintenance in the below areas and applications

Responsibilities:

• EDW Mainframe Applications - Break fixes, enhancements, Performance Tuning and Production Support, Support the OS/ DB2 upgrade.
• EDW Brio Reporting - Break fixes, enhancements, Performance Tuning and Production Support.
• Unix Batch Reports - Break fixes, enhancements, Performance Tuning and Production Support.
• VDO Appln (THD internal Application) - Production Support, Business Users support
• EDW Applications Monthly Metrics Reporting.
• Maestro Release Coordination.

Environment: O/S 390 (MVS), Cobol, JCL, DB2 8.0, Endevor, QMF, SPUFI, Debug Tools, Platinum, File Aid, Bundle, CA-7 Schdeuler, Brio 6.6 Designer, Brio One Administrator, Brio Quick View, Unix shell script, Maestro Scheduler.