Oracle

PROFESSIONAL SUMMARY

Over ** years of experience in performing project/product analysis,

design, development, support and working with clients like Toyota, Union

Bank of Switzerland, Northwestern Mutual, British Petroleum, Hartford

Insurance, Visy Papers etc.

Strong skills in Oracle server side programming which includes SQL,

SQL*Plus, PL/SQL Packages, Stored Procedures, Functions, Cursors,

Triggers, Views, Materialize Views, Temporary tables, Oracle Jobs,

Partition Tables, Object Oriented PL/SQL Programming, PL/SQL

Web-services, Java Stored Procedures, and Oracle Web Toolkit.

Extensive experience in identifying performance issues, debugging and

performance tuning using SQL Trace, Explain plan, Indexing, Hints,

Partitioning, TKPROF and Profiling

Hands on experience in database designing for OLTP and DWH as per data

modeling techniques and migration of data using SQL* Loader, Migration

scripts and Informatica.

Strong experience in ETL Architecture, Analysis, design, development,

testing, implementation, maintenance and supporting of Data Warehouse

(EDW), Operational Data Store(ODS), Data Mart (DM), ETL, OLAP and Web

applications on Windows and Unix platforms.

Strong Experience in Relational Modeling and Dimensional Data Modeling

using Star & Snow Flake schema, De normalization, Normalization, and

Aggregations

Experience in using Informatica Power Center 8.1.1/8.5.1/9.5 Designer,

Workflow Manager, Workflow Monitor including performance tuning of

Informatica transformations/mappings/sessions/workflow's.

Have Good understanding of ETL/Informatica standards and best practices,Confirmed Dimensions, Slowly Changing Dimensions (SCD1,SCD2,SCD3)

Conceptual understanding of with Teradata, Netezza, Mainframe, Java,

PowerBuilder, XML, SOAP, HTML, DHTML, Web Servers, and Java scripts etc.

Solid technical understanding of n-tiered client-server architecture

with in dept understanding of the complete SDLC(using Waterfall, V and

Agile) and it's documentation like Functional and Technical design, Test

Plan Preparations, Unit Testing, System Testing

Extensive experience in onshore -offshore business model and with 24*7

support in production environment as per ITIL Service model

Demonstrated excellence in interacting with clients, managing client

challenges and providing client solutions across different geographies

locations(USA, UK, UAE, Australia and Singapore)

An energetic, self-motivated team leader with hands on experience in

training and adept in end to end development of software

products/project from requirement analysis to system study, project

planning, designing, testing, documentation and implementation with

cross-cultural teams.

Good interpersonal, communications skills and team leading capability.

Awarded and recognized with various awards from client and employee i.e.

Super Hero from Toyota, Best professional from Hartford Insurance,

Champions awards from Wipro.

SKILLS

Domain Knowledge : Auto, Insurance - P&C and BFSI

Operating Systems : Windows NT/2000/XP, UNIX, LINUX, SOLARIS

Application Servers : Oracle 9i AS, Jboss, Tomcat, Web Sphere, EA

Server

Databases : Oracle 11x/10x/9x/8x, Netezza, Db2,

Teradata, Postgres, Sybase ASE 12.5, MS

Access

Data Modeling Tools : Erwin, Power Designer

Transmission Tools : FTP, SFTP, MFT

Languages : Mod PL/SQL, Power Builder, Java (JDK), J2ee

IDE Tools : Toad, SQL Navigator

Methodologies/Tools : ER-WIN, Power Designer, SDS, Xprobe

Web Technologies : Oracle Web DB, Oracle XDB, Servlets, JSP,

Power Dynamo

Scheduling Tool : Autosys, Unix Cron jobs

Data warehouse Tool : Informatica, SAS

Version Control/Tracking : Visual Source Safe, PVCS, SVN

Management Tools : Microsoft Project Planner, E-Cube, ITG

PROFESSIONAL EXPERIENCE

Toyota Financial Services[LA CA USA] Apr 2012 - Apr 2014

Technical Lead from W3Global Inc.

Key Projects Dialer disposition download from external dialers

AB Regulations Phase I and II

Stars Contact and Touches data

Customer No call Reason code

Collections treatment optimization

Score card and model enhancement

Employment alert data to SMG3

Payment aggregation

Booking code elimination

Behavioral scoring

Migration projects: Linux, Informatica and database

Environment Oracle 10g/11g, Netezza, Db2, Sun OS/Linux, Windows

2003/2008, Informatica Power Center, Informatica Power

Exchange, Java, Autosys, Xprobe, Tableau, FICO IVE and

Insight

Responsibilit Participate in business requirements gathering sessions

y with the business owners, external vendors and key

technical resources to ensure business needs are clearly

identified, documented and communicated.

Analyze business requirement and translate into system

requirements.

Involved in the analysis of source to target mapping

provided by data analysts and prepared function and

technical design documents.

Designed Conceptual, Logical and Physical data models for

new requirements.

Developed Database Tables, stored procedures, SQL Queries

routines, reviewing and tuning SQL and PL/SQL Code, Oracle

database packages.

Extracted data from flat files, Oracle, MS-Access, Netezza

using SQL Loader or Informatica ETL mappings.

Performed SQL and PL/SQL tuning and Application tuning

using various tools like EXPLAIN PLAN etc.

Created partitions tables, indexes on the tables for

faster retrieval of the data to enhance database

performance.

Extensively involved in using hints to direct the

optimizer to choose an optimum query execution plan.

Handled errors using Exception Handling extensively for

the ease of debugging and displaying the error messages in

the application.

Developed complex ETL transformation logic using various

transformations like Lookup, Aggregator, Expression,

Router, Filter, Update Strategy transformations, Sequence

generator and etc.

Developed UNIX programming script to monitor database

performance, file transmission, manage Informatica

workflows and perform routine task using Autosys

scheduler.

Wrote Unit Test cases and executed unit test scripts

successfully

Supported during QA/UAT/PROD deployments and bug fixes

Provided knowledge transition to L1 support team. Provide

any technical support to L1 team who is responsible for

day to day production monitoring

Supported Windows box setup with new Tools from

FICO(Xpress IVE, Insight, Jboss, Tomcat).

Review efforts estimates from various teams and recommend

most suitable approach or vendor to Project Managers.

Lead weekly status report with business users' task

prioritization and planning.

Worked closely with program management team to provide

regular status update on system health, resource

utilization and capacity forecasting

Union Bank of Switzerland [Stamford CT USA, Jan 2011 - Apr 2012

Singapore, India]

Application Coordinator from Wipro Technologies

Project Data IT - Production Support and Maintenance as client of

Wipro

Environment Oracle 9x, Informatica, Unix, Linux, Sun OS, Windows,

Broker, J2ee and Tomcat

Responsibil As a production support analyst responsible for up and

ity running of various UBS critical systems during US business

hours.

Conducting daily shift pickup call with EMEA and shift over

call with APAC for smooth transition of issues in 24 X 7

support model.

Notifying and handling business user during production

issues, and providing alternate solution based on priority.

Gathering the functional requirements from users and

converting them into Technical requirements, preparing

technical design document for enhancement and impact

analysis documents for bugs, system and integration testing

plan.

Developed Database Tables, stored procedures, SQL Queries

routines, reviewing and tuning SQL and PL/SQL Code.

Created PL/SQL stored procedures, functions and packages for

moving the data from staging area to data mart.

Developed complex ETL transformation logic using various

transformations like Lookup, Aggregator, Expression, Router,

Filter, Update Strategy transformations, Sequence generator

and etc.

Supporting ad hoc business queries and route requirement to

proper channels

Analyzing performance of database objects and suggesting DBA

for Indexes, schema gathering, partitioning, Explain Plan,

TK PROF

Participate in pre release, release and post release calls.

Responsible for taking all required sign off for production

implementation.

Support production implementation week as release

verification, post production testing and in case of issues

back out of production code.

Worked closely with program management team to provide

regular status update on system health, resource utilization

and capacity forecasting

Northwestern Mutual [Milwaukee WI USA] Dec 2009 - Nov 2010

Technical Lead from Wipro Technologies

Key Workforce data Analysis

Projects FLL - Enhancement to data warehouse

Environment Oracle, Sybase, Unix, Java Script, PVCS, J2ee, Informatica,

Mainframe

Role Infrastructure Manager / Technical consultant

Responsibil As a Tech-Lead(aka Infrastructure Manager) was single point

ity of contact for Infrastructure setup, support and service for

various project in FFBA area of Northwestern mutual across

geographic locations

Worked closely with the project teams(DEV, ITS, PTS,

Deployment and support team) to determine the services that

will be required for Autosys, MQ Series, Informatica, UDB &

Sybase Database, QAS, Web sphere, Actuate, Winsign, Business

Objects, Siebel, as well as general infrastructure support.

Worked closely with the Delivery/Test Lead in providing 1)

feedback and input in established workflow and processes 2)

detail information on project projection 3) feedback and

input in infrastructure optimization

Providing comprehensive estimates, tracking budget and

communicating any unforeseen changes to program management

team.

AI and SCM planning and coordination as it relates

development and testing environmental setup, code

drops/reconciliations, testing strategy, project timelines,

troubleshooting, and deployment planning.

Coordinates closely with the projects C&I representative on

Tech Services scope and involvement

Worked closely with program management team to provide

regular status update on infrastructure setup, budget

utilization, infrastructure defects and remediation plan

Monitoring SLA setup for various teams and taking

proactive/reactive actions as per ITIL framework

British Petroleum [Houston TX USA] Aug 2009 - Nov 2009

Data Migration Lead from Wipro Technologies

Project Impact Data migration

Environment Oracle, Impact, Unix, Informatica

Role Project Manager

Responsibil Client interaction for preparing migration strategy and

ity planning, participated in initial level of fit-gap analysis

between Impact and BP's in house project.

Accountable for typical migration activities like

requirement gathering, planning, data cleansing approach,

migration script design and development, testing and

production rollout etc.

Providing comprehensive estimates, tracking budget, Project

planning, resource estimation and allocation.

Involved in technical POC to perform various ETL

transactions such as extraction, transformation, cleansing

and loading of data from source to target data structures

The Hartford Insurance [Hartford CT USA, India] Apr 2005 - Aug 2009

Project Lead / Onsite Coordinator from Wipro Technologies

Key BBJ History data conversion

Projects @venture - Risk Management tool

Environment Oracle 9x/10g, PVCS, Unix, Mod PL/SQL, Oracle XDB/webDB,

UNIX, Oracle9iAS, Java Script, PVCS

Responsibil Participated in KAP phase for @venture starting from system

ity study, SMTD documentation and team setup and taking

application into stead state mode.

As a App Lead was responsible of 24 X 7 production support,

business user management during production crisis

Participate in business requirements gathering sessions with

the business owners, external vendors and key technical

resources to ensure business needs are clearly identified,

documented and communicated.

Client interaction for Migration requirements gathering and

analysis, system design & Development, UAT support and

Implementation.

Implemented migration business logic using PL/SQL

procedures, Informatica mappings, and Oracle Scheduler and

UNIX scripts.

Creation of database objects like tables, views,

materialized views, procedures and packages using oracle

tools like Toad, PL/SQL Developer and SQL* plus.

Implemented Oracle partition and sub partition mechanism for

better data managements

Partitioned the fact tables and materialized views to

enhance the performance.

Extensively used bulk collection in PL/SQL objects for

improving the performing.

Created records, tables, collections (nested tables and

arrays) for improving Query performance by reducing context

switching.

Handle team management activities like team formation,

mentoring induction. Transition for new joiners, task /

resource allocation, administration and providing technical

/ mentoring support to the team members on technical as well

as project-related issues.

MphasiS BFL[UAE, Australia and India] Apr 2004 - Mar2005

Senior System Engineer

Key MES System for Visy papers Australia

Projects On Line Order Management & Tracking System for GAC Marine -

UAE

Technologie Windows 2000, UNIX, Oracle, Power Builder 8x, EA Server

s 3.5

Responsibil Requirement gathering and analyze, system design,

ity development, unit testing, user acceptance testing,

implementation and post production support.

Developed new ETL interfaces and enhanced the existing

interfaces using OOAD methodology

Providing 24X7 production support, impact analysis and quick

fix for critical production issues, requirement gathering

for enchantments, design and development of system

enhancements, peer review and documentation as per SDLC

concepts.

Provided input to management team for effort estimation,

resource planning and allocation for enhancements.

Envision Financial Pvt. Ltd[India] Mar 2003 - Mar

2004

Senior Software Engineer

Key Project Power Broker for Brown Brothers Harriman - USA

Technologie Windows 98/NT, SQL Server 7.0, Sybase ASE 12.5, Power

s Builder 8x, Java1.2, JSP, EA Server 3.5, Web Logic 6.0,

Tomcat, MQ Series

Responsibil Participation in requirement gathering, solution design

ity meeting and documented low level design for Power Broker 4.0

Developed core business logic of SWIFT and clearing house

module of Power Broker using database programming consisting

of Complex SQL Queries, Joins, Stored Procedures derived

from multitude tables as per OOAD methodology in Sybase ASE.

Developed and documented unit test plan and test cases

Design/develop web services interface between Power Broker

and US Clearing house using J2ee architecture

Performed unit testing, supported user acceptance and

performance testing.

Performed POC(proof of concept) of running Power broker on

SQL Server 7.0

Provided offshore support for implementation of powerbroker

4.0

Ideal System Pvt. Ltd.[ India] Feb 2000 - Feb

2003

Senior Software Engineer

Key Customized ERP Application for GSFC - Baroda India

Projects HRIS for Gujarat Gas(Subsidiary of British Gas India)

Annual Maintenance Contract for Cherros India

Online Test for Jain Infonet, India

Technologie Windows 95/NT, UNIX, Oracle 8i, DB2, Main-frame, MS-Access,

s Power Builder 7/8, Visual Basic 6.0, Java1.2, Servlet 2.0,

JSP, EA Server 3.5, Tomcat, Fox Pro, Cobol

Responsibil Migrated business logic from FoxPro/Cobol to Oracle/Power

ity builder based system.

Requirement gathering, system analysis, design,

documentation, development, unit testing, User acceptance

testing, implementation and post production support.

Developed complex business rules as per OOAD methodology

using oracle(stored procedure, functions, packages,

triggers) and PowerBuilder(Windows, Data windows, Menu, PFC)

Conducted end user training sessions, prepared "How to

guide" and "Production support manuals"

Migrated data from legacy system to Oracle based system

using PowerBuilder pipe functionality

Designed web base application using JSP/Servlet and

deployed to tomcat server

Design conceptual/logical database design using top down

database model technique

Source code review and work allocation to junior member of

team, Mentoring / technical guidance to junior team member.

Raw Jute Trading & Industries Pvt. Limited.[ India] May 1998 - Aug

1999

Software Engineer

Key Office Administration (HRIS, Payroll, Inventory) for Raw

Projects jute

Technologie C, C++, Flat Files, DBASE, Windows 95

s

Responsibil Was Responsible for production support and maintenance of

ity in-house software application.

Execute/validate month/year end financial closure process

Responsible for taking backup

Install new version of software to local branch as guided by

development team

EDUCATION AND CERTIFICATION

Post Graduation Diploma In Advance Computing CDAC Feb 2000

Bachelor of Engineering in Electronics & Communication Gujarat May 1998

University

Oracle 8i Certificated DBA Mar 2002

Various Brain-bench certification i.e. DB Concepts, Oracle,

PL/SQL etc

Wipro internal certification in ITIL, Lean, Software Quality,

DWH etc

PERSONAL DETAILS

Date of Birth : 15th August 1976

Marital Status : Married

Passport No : H5882372

Date of Expiry : 02-Feb-2020

Visa Status : H1b Valid till May 2017

Address : 20809 Anza Ave Apt 104 Torrance CA 90503

Contact : +1-860-***-****

Email : ************@*****.***

Contact this candidate