Project Data

Summary

. Over ** years of experience in Analysis, Design, Development,

Integration, Deployment and Maintenance of IT Systems in various domain

and platforms.

. Highly experienced in Database Analysis, Design, Implementation including

Data Migration and Performance tuning for large-scale projects using

Oracle.

. Experience in Data Modeling using tools like ER Studio, SQL Developer and

Toad.

. Extensive coding experience in SQL and PL/SQL to develop stored

procedures/functions, triggers and packages for satisfying client or ad-

hoc reporting requirements.

. Experience in Data Warehouse Projects using ETL Tools like Data Pump,

SQL*Loader and Pentaho.

. Experience in Database Administration for performance bottlenecks,

explain plan, blocking session, user or instance management, etc.

. Designed and developed Client Applications using Oracle Forms, C, Visual

Basic, Java and Oracle Reports.

. Experience in Scripting language like Unix Shell for creation,

modification and execution of database objects.

. Experienced in Software Methodologies (SSADM, RAD and SCRUM).

. Experienced in Leading and Management a team of junior database

developers (delegation of tasks, resolving technical problems, task

estimates, etc.).

. Experienced in taking Lead/Ownership of the database tasks from feature

requirements to completion. Ability to work collaboratively with team

members to achieve business goals. Excellent presentation and

communication skills. Good planning, organizing and interpersonal

skills.

. Experienced in Other databases like MySQL and NoSQL like Hadoop,

ElasticSearch.

. Self-starter, quick learner, ability to handle multiple, concurrent

assignments with tight deadlines. Can adjust myself according to the

requirements.

Education

Degree University Country Year Marks

MSc in Computing Staffordshire UK 2004 Distinction (throughout)

University

Bachelor's in Gujarat India 1998 Distinction

Electronics and University

Communication

Professional Certificate

OCP 9i Certified (SQL, PL/SQL, Forms)

OCP 11g SQL Certified Expert

Training

. Oracle 11g Performance Tuning, Oracle (ODTUG) Conference 2011

. Datawarehouse lifecycle, Informatica 6.0, Business Objects 6.2.

. Java 2, HTML, XML, C++.

. Scrum Methodolgy

. Leadership courses (Learning to Lead, Managing People).

Technical Skills

Modeling Tools ER Studio 9.0, SQL Data Modeler

Operating Systems Windows NT 4.0, UNIX - Sun Solaris, Red hat Linux

Databases Oracle 7.3 - 11g, TimesTen (In Memory database) 4.5 -

5.0, MySQL 3.23, 4.0, 5.5, MS Access.

Programming Languages SQL, PL/SQL, C, Oracle Forms 4.5 - 9i, Oracle Reports

2.5 - 9i, Visual Basic 6.0, Java

Version Control Tools XClearcase, CVS, Visual Source Safe, Perforce

Shell Scripting Unix K

Data Warehouse Tools SQL Loader, Pentaho (Kettle and Reporting suite), Data

Pump, Hive

NoSQL Databases Hadoop, ElasticSearch

Work Experience

December 2008 to Till Date- BlackBerry (Waterloo, Ontario, Canada)

Project Name Software Loading

Position Senior Database Developer

Description Project used for upgrading the device configuration/software

for the mobiles in the field. It also sends notification to

the mobile device in case a new software/configuration is

available. Additionally, all the Stats collected needs to be

copied over to a data-warehouse for analytic/reporting. The

Database size is around 1 Terabyte.

Responsibilities Analysis & Design

Interact with the users as part of requirement analysis.

Design Data Models (ERD) to satisfy the business

requirements.

Database Activities

Creating Oracle and MySQL database objects, types and

constraints in the databases (came up with Coding standards

and Database directory structures for build purposes).

Creation and maintenance of Database Packages and Triggers

(extensive coding of Packages).

Develop Unix Shell Scripts for Release migration that

included maintenance of database objects and code deployment

(migration is a key part in release deployment).

Database Job Scheduling of Copy Scripts (fetching data from

regional data centers to a central location for data

warehouse).

Implemented Oracle Partitioning for Data warehousing of

Statistical information (Tables have millions of rows and

were being used for reporting hence partitioning was used).

Perform Code review and Identify performance bottlenecks

followed by fixing the problematic SQL queries.

Created a PLSQL Unit test framework that can be automated and

used for Code coverage purposes.

Prototype/Investigate different Oracle and PLSQL products for

staying current in Oracle and using the knowledge for Project

benefits.

Drive Oracle Database Upgrades within the department (through

collaboration) in case of expiry of Oracle support or

resolution of critical bugs.

Prototype and Used Different NoSQL Databases like MongoDB,

ElasticSearch, and Hadoop for Big Data scenarios.

Leadership Responsibilities

To lead the database team for assigning tasks, coming up with

sprint estimates, resolving database problems and providing

necessary consulting in regards to project tasks.

To provide guidance/direction for technical and professional

development of junior developers.

Support

To support different teams (like Development, QA, Staging and

Production) with Database solutions, configuration or release

deployment.

To support ad-hoc reporting including data analysis request

from Business Executives/Director. This assisted the

Management with the progress on software release.

Overall Performance

Based on my Technical skills and experience I have been

assigned the Lead authority for all database activities of

the project.

Based on my leadership skills I am now leading a team of five

junior developers.

Development Oracle 10g and 11g R2, MySQL 5.5, Hadoop, Elastic-Search, Red

Environment & Hat Linux, All Round PLSQL, Perforce, MKS Integrity, Rally

Tools (As part of SCRUM for Sprint planning), GIT, JIRA, Data Pump,

ER Studio, SQL Developer, MySQL Workbench.

Nov 2006 to Nov 2008-Agentrics (Alexandria, Virginia, USA)

Project Name Sourcing Reporting

Position Senior Oracle Developer

Description To provide Sourcing data to the Customer through the Data

mart. This Data mart consists of consolidated data from

various Sourcing Tools of Retailers and includes various

transformations like currency conversion, category mapping,

etc.

Responsibilities Analysis & Design

Performed Data Modeling, developed Entity Relationship

diagrams (ERD) for creating Sourcing Data warehouse. This

Warehouse was then used for Reporting by End users.

Database Activities

Creating Staging Database Objects for Storing Processed

information and then mapping them to the Reporting data

structures.

Creation and maintenance of Database Triggers, Procedures,

Packages/functions for generating/consuming processed

information.

Develop Unix Shell Scripts to execute the Stored Procedure in

order to create customized file extract as an alternative

reporting option.

Fine-tune the database applications for higher performance of

Reporting Queries.

Developing Cube Queries so as to quickly display processed

information to the User.

ETL Tool (Kettle) and Reporting Suite of Pentaho Product was

used for this project.

Additional Responsibilities

To Mentor Junior colleagues about the project.

Overall Performance

I quickly grasped the new ETL tool and completed the project

tasks within a very short time frame.

Based on my skills and experience I was given the authority

to make Decision on several tasks of the project.

Development Oracle 9i/10g database, Pentaho (ETL and Reporting tool),

Environment & Toad, CVS, Unix

Tools

Feb 2006 to Oct 2006-Fannie Mae (Washington, DC, USA)

Project Name Restatement

Position Senior Oracle Developer/DBA

Duration 9 Months

Description Adjustment of Financial Data to make it compliant to GAAP

policies.

Responsibilities Design

Developed Entity Relationship diagrams (ERD) to satisfy

business requirements (Updating/Modifying Physical and

Logical database design diagram)

Database Activities

Designed, Developed and Deployed complex Stored Procedures.

This Stored Procedures populates the restatement tables that

are useful for Data Reporting and General Ledger Entry

verification by the Users.

Develop Unix Shell Scripts to execute the Stored Procedure in

a particular run order.

Fine-tune the database applications for Higher Performance of

Online Transaction Processing (OLTP) applications and

business reports.

Creating master/detail relationships, objects and constraints

in the databases.

Creation and maintenance of Database Triggers, Procedures,

Packages/functions.

Import data from various sources into Oracle including

creation and modification of scripts using SQL Loader.

Extract restatement data for Auditing purposes.

Support Activities

Train Junior Developers for backend logic/administration.

Client Side Activities

Based on my performance, I was required to work at the Client

Head office (Dallas) to complete/support critical business

tasks.

Overall Performance

I completed most of the tasks within very short time frame

resulting in an early start of the Production in July rather

than the August month (scheduled time). My performance was

well appreciated within the team as well as by the user group

also.

Development Oracle 10G database, SQL Loader, ER Studio, Rational Clear

Environment & Quest, Unix

Tools

Feb 2001 to Aug 2003 - Hughes Software Systems, India

Project Name Home Subscriber Services - Internet Multimedia System, Home

Location Register

Position Senior Software Engineer

Duration 2 year and 8 months

Description This project was used for developing home location register

database that can store mobile subscriber data via software

application.

Responsibilities Analysis & Design

Analyzes user's requirement and prepared functional

specifications (interface control document).

Performed Data Modeling, developed Entity Relationship

diagrams (ERD).

Prepared Functional, and Technical documentation for each of

the database applications.

Application Development

Design; develop high availability database software using

Oracle Replication.

Design; develop database interfaces between telecommunication

applications and database.

Database Activities

Installed and Configured Oracle Database 9i and TimesTen

4.5/5.0.

Creating master/detail relationships, objects and constraints

in the databases.

Creation and maintenance of Database Triggers, Procedures,

Packages / functions.

Performance tuning of SQL queries for faster access to mobile

data.

Solved critical database problems to facilitate smooth

product release.

Provided database consulting to different clients.

Provided database benchmarking through prototyping approach.

Support Activities

Support all the database software modules. Single person

support to all database problems (DBA or Application

development) related to product release.

Development UNIX-Sun Solaris, Oracle 9i, C, Pro*C, Unix, XClearcase,

Environment & Erwin 4.0, TimesTen 4.5/5.0

Tools

Dec 1998 to Feb 2001 - CMC Limited, India

Projects Kandla Dock Labour Board, Gujarat Enterprise Management

System

Position Programmer/Analyst

Duration 2 year and 6 months

Description Project for maintaining key company aspects like payroll,

billing, sales, marketing and products.

Responsibilities Analysis & Design

Involved in analysis activities, which includes gathering

information from users, defining and prioritizing

requirements, prototyping and preparing functional

specifications.

Application Development

Designed, Developed and Deployed screens using Oracle

Developer 2000 (customer order, sales, stock, credit/debit,

goods shipping, etc.) and Oracle Reports (formats: matrix,

form, letter, cross product).

Development Oracle 8i, Developer 2000 (Forms 5.0 & Report writer 2.5),

Environment & SQL Loader, MS Access, MS Visio 2000, Windows

Tools

Contact this candidate