Project Data
Resume:
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