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

Project Name

Confidential

Position

Senior Database Developer

Responsibilities

• Database Activities
• Analysis Design
• Analyze the complicated legacy Database code and come up with a simple and manageable version of Data warehouse dimensional model.
• Creating Oracle database objects, types and constraints in the databases.
• Develop Data warehouse queries for data reporting purposes.
• Creation and maintenance of Database Packages and Trigger for Data loading and auditing purposes in Data warehouse schema.

Development Environment Tools

Oracle 11g R2, SVN, JIRA, SQL Loader, Toad, SQL Developer

Project Name

Confidential

Position

Senior Database Developer

Responsibilities

• Interact with the users as part of requirement analysis.
• Design Data Models ERD to satisfy the business requirements.

• 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 Environment Tools

Oracle 10g and 11g R2, MySQL 5.5, Hadoop, Elastic-Search, Red Hat Linux, All Round PLSQL, Perforce, MKS Integrity, Rally As part of SCRUM for Sprint planning , GIT, JIRA, Data Pump, ER Studio, SQL Developer, MySQL Workbench.

Project Name

Confidential

Position

Senior Oracle Developer

Responsibilities

• Performed Data Modeling, developed Entity Relationship diagrams ERD for creating Sourcing Data warehouse. This Warehouse was then used for Reporting by End users.

• 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 Environment Tools

Oracle 9i/10g database, Pentaho ETL and Reporting tool , Toad, CVS, Unix

Project Name

Confidential

Position

Senior Oracle Developer/DBA

Duration

9 Months

Responsibilities

• Developed Entity Relationship diagrams ERD to satisfy business requirements Updating/Modifying Physical and Logical database design diagram

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

• Train Junior Developers for backend logic/administration.

• 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 Environment Tools

Oracle 10G database, SQL Loader, ER Studio, Rational Clear Quest, Unix

Project Name

Confidential

Position

Senior Software Engineer

Duration

Confidential

Responsibilities

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

• Design develop high availability database software using Oracle Replication.
• Design develop database interfaces between telecommunication applications and database.

• 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 all the database software modules. Single person support to all database problems DBA or Application development related to product release.

Development Environment Tools

UNIX-Sun Solaris, Oracle 9i, C, Pro C, Unix, XClearcase, Erwin 4.0, TimesTen 4.5/5.0

Projects

Confidential

Position

Programmer/Analyst

Duration

Confidential

Responsibilities

• Involved in analysis activities, which includes gathering information from users, defining and prioritizing requirements, prototyping and preparing functional specifications.

• 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 Environment Tools

Oracle 8i, Developer 2000 Forms 5.0 Report writer 2.5 , SQL Loader, MS Access, MS Visio 2000, Windows