Highly skilled and well experienced in Oracle **g/12C Features and PL/sql with On-Hands Coding. Also experience in Relational and Dimensional Modeling and Oracle BI Publisher Reports. Have 16 years of development experience in Oracle Pl/sql, Unix Shell Scripts, Datastage 9.1, Pentaho 4.5, Erwin, Sql Developer Data Modeler and Toad. I take a real pride in my job and currently looking for a challenging opportunities.

PROFESSIONAL EXPERIENCE

Cognizant Technology Solution • 10/2009 to Present

Oracle12C PL/Sql Developer (Currently working at client location E*Trade Financial Corporation)

Hands on experience on PL/sql,Toad, Sql Developer Tool.

Extensively worked with Version Control Systems SVN (Subversion), GIT Bitbucket, Confluence.

Experience in Agile Methodology, JIRA Tool etc.

Extensively worked on PL/sql Stored Procedures, Triggers, Cursors, RefCursors, Pragma Autonomous Transactions, Collections.

Knowledge in Oracle 12C Features Auditing using FDA, In-Memory column, DB Cache, JSON Object.

Expertise on building Relational / Dimensional Modeling using Erwin and Sql Developer Data Modeler Tool.

Experience in creating and managing database Objects like Tablespaces, Schemas, Tables, Constraints, Sequences, Directories, Indexes, Views.

Experience in Performance Tuning – Explain Plan, Partitions, Indexes, Sql hints, In-Memory.

Extensive experience in Oracle BI Publisher reports with templates builder for Words, Excel.

On-Hands experience in Data Migration Activity using Oracle Export / import Data pumps and Sql loader / .ctl file and External Tables.

Experience in Writing Complex / Analytics queries using SQL.

Expertise on Physical database design, Logical database design, Data Exports & Imports, Application Support and Performance Tuning.

Created Indexes, Records, Tables, and Objects. Proficient in PL/SQL exception handling, query writing, dynamic SQL, Bulk Collect and materialized views.

Experience in file utilities such as SQL*loader, UTL_FILE, External Tables,Import and Export utilities

Experience in building Data Warehouse and Data Marts with Start Schema and Snow-flake Schema.

Knowledge and experience in Domain areas like Healthcare, Manufacturing, Finance, Communication, Automobile and Energy.

Good knowledge in ETL Tools like Informatica, Datastage 9.6, Pentaho 4.5 Tools.

On-Hand experience in reverse / forward engineering and solution for Data Model issues.

Setting up the builds for SIT, UAT and PROD rolls. Monitor the builds and fix the issues

Collaborate with developer and UI Application team to fix the issues during the roll and patch or rebuild the DB objects with the fix.

TECHNICAL SKILLS

Programming Language

Oracle SQL, PL/SQL, Unix Shell scripting.

Database Technologies

ORACLE 11g/12C,DB2,Sql server 2012

Tool

Erwin 9.2,Visio 2013,SQL Plus, Toad, Oracle Sql Developer,JIRA, Sql Developer Data modeler Tool 12.2

ETL/BI Tools

Informatica 9.6, Datastage 9.1,Pentaho 5.4.0.1,DMExpress, Oracle BI Publisher, Actuate,Cognos Reports

Platforms

Windows, Unix, Linux

Version Control

SVN,PVCS, Tortoise GIT

Job Monitoring Tool

Autosys,UC4

PROJECT EXPERIENCE SUMMARY

Project 1

Project Title

EEO 2.0

Client

E-Trade Financial Services

Duration

July 208 – Till Date

Project Description

Migrate the data from StockPlan to EEO – Agile Methodology.

Tools

Sql Developer, Sql Developer Data Modeler Tool, Unix, Oracle 12C, Oracle Pl/sql, JIRA, Confluence, GIT, Bitbucket

Roles and Responsibilities

Analyze and Identify the Data Patterns on the list of StockPlan Tables.

Walk-thru the Data Patterns and get approval and Design the Unified Data Model.

Break the Database Data Model into Smaller Units and design the solution for Unified Data Model.

Develop the Pl/Sql Programs for Data Migration and Auditing.

Create Mapping sheet from Source DB to Target DB.

Create DB Stories in JIRA Board and walk-thru the groomed stories for Agile Sprints.

Daily status to Scrum Master on the assigned Sprint Stories.

PROJECT - 2

Project Title

Transformation from Qcare to FACETS

Client

Emblem Healthcare

Duration

Jan 2017 – June 2018

Project Description

Migrated the data from Qcare system to FACETS

Tools

Datastage, Autosys, Unix,Oracle Pl/sql

Roles and Responsibilities

Involved in understanding the copybooks to load the data from FACETS to DW.

Worked on DW database design, development, test and deploy to process FACETS data to DW DB.

Worked on ETL/SQL loader mapping to DW DB.

Manage the team at onshore/offshore for deliverables and issues.

Client/offshore coordination and Shared the weekly Status report updates to client.

PROJECT -3

Project Title

BCS-HCS-Data Modeling

Client

Blueshield California

Duration

Aug 2016 – Dec 2016

Project Description

Creation of subject-wise Data Model (E/R) on BSC-HCS Mainframe system.

Tools

Erwin 9.2, Mainframe Tools

Roles and Responsibilities

Review the Entities/Attributes Xl sheet created by Mainframe team with relations between attributes set in the Mainframe HCS system.

Creation of subject-wise Data Model using the xl sheet and publish those Data models in pdf format.

Review those Created E/R Data Model with SME and get sign-off.

Client/offshore coordination and Shared the weekly Status report updates to client.

PROJECT -4

Project Title

Z-Series Archival Migration

Client

HealthNet

Duration

Jan 2016 – Aug 2016

Project Description

Z-Series Archival is the Migration project, which archive the Application data from Mainframe DB2 to Oracle Database.

Tools

DMExpress,Oracle11g,SybasePowerDesignerstool,Mainframe,DB2,PL/sqlDeveloper,Unix,Shellscripts,BlueZoneSession Manager.

Roles and Responsibilities

Identify the business pain areas, Key Data Quality Issues, understand the current process of Data governance, list of Source Systems and define the high level requirements / scope for Z-series implementation.

Review the detailed design documents prepared by other team members.

Reverse engineering on the Mainframe DB2 source Database using Sybase Power Designers and publish the Data Model of the Z-series Application.

Review the ETL Design stages, which extracts the data from Mainframe DB2 and VSAM Files and load the data into Oracle Database.

Automate the Z-series Applications archival process and review the data quality on the target.

Client/offshore coordination and Shared the weekly Status report updates to client.

PROJECT -5

Project Title

HRMS-Storefront

Client

Comcast

Duration

Sep 2014 – Dec 2015

Project Description

Storefront is the downstream HRMS Application database supports the other downstream Applications like AD/IDM/CIFA. Also the other downstream databases used to extract the HR data from storefront thru the interfaces.

Tools

Pentaho5.1,Oracle11g,PL/sqlDeveloper,Unix,Shellscripts,UC4 scheduler.

Roles and Responsibilities

Led teams of technical analysts in the collection and documentation of business and technical requirements gathering for the development of Storefront HRMS Database rollout.

Led requirements gathering for Storefront DB and SAP workflow processes.

Work with business stakeholders and gather specific requirements and Design the storefront Logical and Physical data model and maintain the Data Dictionary.

Capacity planning for the proposed storefront Database.

Work with the Business to document & communicate the Process changes and Conduct training and presentations to UAT users and downstream application vendors.

Managed customer expectations relating to consulting deliverables, project scope and timeline, and risk/mitigations.

Ensure balance between business needs and Technically-feasible solutions.

Setup the VM-ware Environment and Leverage the Open source Pentaho to extract and load the data from various sources with different formats.

Automation of the process workflow in UC4 tools.

PROJECT-6

Project Title

BJ’s Order Management

Client

BJ’s Wholesale Club

Duration

Mar 2014 – Aug 2014

Project Description

BJ’s wholesale club would like to enhance their existing enterprise DW model and their datamart for their Analytics. This enhancement delivers deep customer insight that empowers organizations to make better decisions in each of the stages across the entire order Lifecycle. By leveraging actionable and fact-based Insights, this project can enhance their current order management process to improve financial performance and their member’s loyalty. The insights gained from this analysis deliver actionable steps to address short-term issues and provide strategic input and transform the order management & fulfilment process

Tools

Erwin 8.6, Teradata.

Roles and Responsibilities

Work with business managers and end Customers and gather the business requirements.

Analyze the existing DWH and data mart and Identify the various subjects and grain of the data.

Reverse engineering the existing DWH/data mart model and enhance the data mart for analytics.

Maintain the meta data repository and data dictionary.

Develop best practices and naming standards in the Proposed Data model.

Guide the ETL/Application/Report Developers on mapping the data .

Generate daily and weekly status reporting on key progress indicators and progress metrics

Review the detailed design documents prepared by other team members.

Guiding and mentoring the team in executing and meeting the deliverables on time with quality to the customers

PROJECT -7

Project Title

Trane –DM Reports.

Client

Trane

Duration

June 2012 – Mar 2014

Project Description

Trane Inc. (subsidiary of Ingersoll Rand) is a manufacturer of Climate controls. Trane has a Centralized Data warehouse which has the provide analytical information like for a period of time, who/what services provided to which facility and how to optimize the services to client and generate periodical data reports and dashboard reports to middle/higher management.

Tools

Erwin 8.6, Oracle 10g,Oracle BI Publisher, Actuate Reports

Roles and Responsibilities

Work with business managers and end Customers and gather the business requirements.

Analyze the existing DWH and data mart and Identify the various subjects and grain of the data.

Reverse engineering the existing DWH/data mart model and enhance the data mart for analytics.

Guiding and mentoring the team in executing and meeting the deliverables on time with quality to the customers

Coordinate and Manage workshop sessions with Business SMES for requirement gathering.

Coordinate with ETL Teams for technical data Integration issues.

Hands-on and publish the Daily service reports/Dashboard/Scordcard/Cubes reports.

Establish Processes to conduct reviews and manage the overall quality and deliverables.

PROJECT-8

Project Title

PIN Application

Company

Mahindra Satyam,Cognizant

Client

J.D Power Associates

Duration

Jan 2009 – Jun 2012

Project Description

J.D Power Associates developed a Data Model to create syndicate services to client and generate periodical data reports and dashboard reports.

Tools

Erwin 8.6, Oracle 10g

Roles and Responsibilities

Data Modeling on the Service Data Model.

PROJECT-9

Project Title

Chevron Businesspoint Application

Company

Mahindra Satyam

Client

Chevron

Duration

Jan 2007 – Dec 2008

Project Description

Chevron Businesspoint application generates invoices/rebates to customer.

Tools

Oracle 10g, Pl/sql

Roles and Responsibilities

Application Database PL/SQL Developer.

PROJECT-10

Project Title

TRW – VMS Tool

Company

Mahindra Satyam

Client

TRW

Duration

Jan 2006 – Dec 2007

Project Description

TRW – Vendor Management system Tools

Tools

Oracle 9i, Pl/sql, .NET

Roles and Responsibilities

Application Database PL/SQL Developer.

PROJECT -11

Project Title

Parts and Accessories (PANDA)

Company

Mahindra Satyam

Client

Ford

Duration

May 2004 – Dec 2005

Project Description

Maintains the inventory of Parts and generates invoices.

Tools

Oracle 9i, Pl/sql, Forms 6i/Reports6i and Forms 9i/ Reports 9i

Roles and Responsibilities

Production support Developer.

PROJECT -12

Project Title

IMEX and RSR - Production Support

Company

Siyara Technologies (P) Ltd

Duration

June 2000 – Mar 2004

Project Description

Imex & RSR Production Support

Tools

Oracle 8, Pl/sql

Roles and Responsibilities

Production support Developer.

Contact this candidate