PROFILE:

• 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- Confidential 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

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

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- Confidential 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

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

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 Confidential 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

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

Responsibilities:

• Performance Tuning and Production Support, Support the OS/ DB2 upgrade.
• Break fixes, enhancements, Performance Tuning and Production Support.
• Break fixes, enhancements, Performance Tuning and Production Support.
• Production Support, Business Users support
• EDW Applications Monthly Metrics Reporting.
• Maestro Release Coordination.
• Coordinate with Onsite and delivering defect free Reports from Offshore to Onsite
• Develop the critical and complex reports using Hyperion Dashboard Reporting.
• Internal review of the deliverables and Quality management.
• Understand the adhoc Business request of the Client.
• Query the Database for the requests either in QMF (Mainframe) or Hyperion Report for various members of the Special Services Team.
• Support the existing MS-Access Reports.
• Develop Batch Hyperion Reports for Planogram Reporting Project.

Environment: DB2 8.0, QMF, Hyperion Interactive Reporting 9.0, MS-Access

Onsite/Offshore Mainframe developer

Confidential, Minneapolis

Responsibilities:

• Understand the Business request of the Client.
• Design & Develop the solution in MF Technologies.

Environment: O/S 390 (MVS), Cobol, Eztrieve, JCL, DB2 7.1, Platinum, Softech, File Aid, Abend Aid, JMR, Endevor, Xpeditor, CA-7 Schdeuler, Cool-Gen.