PROFESSIONAL EXPERIENCE

Oracle PL/SQL and Microsoft SQL Server Database Designer/Application DBA/Developer who created Peterson’s TestPrep database system which led to a 32% sales growth in it\'s first year for the company. This database currently supports 5 million worldwide web users accessing up to 300 tests. I have delivered validated applications on time, by successfully managing teams of developers through SDLC process. Polite and effective communicator with a good command of English, Hindi and Gujarati.

SOFTWARE

Oracle 11g, 10g RDBMS, Oracle CASE Dictionary. Oracle Partitioning, PL/SQL Packages, Procedures, Functions, Triggers, Materialized Views, Oracle Reports 6i, SQL*Loader, SQL*Forms, SQL*Menu, SQL Navigator, TOAD, ERWin, Autosys, HP Quality Center, CVS, SVN, Benthic Golden. SQL Server 2005 & 2000, SQL Query Analyzer, SQL Server Express, T-SQL, Microsoft Visual Studio, TFS, WSS SharePoint 3.0, IBM Optim. InfoReports & InfoServer Report Writers, IQ and IQ SmartServer Report Writers, BRIO Query, C, Pro*C, Fortran, MS Office.

PROFESSIONAL EXPERIENCE

Confidential,Parsippany, NJ May 2011 - Present

Primary Projects:

• Oracle 11g Upgrade: Compared 10g schemas with migrated 11g schemas to ensure all schema objects were migrated successfully and were valid.
• Development: Supporting various SOA teams with Database design and development of objects ranging from tables to PL/SQL packages. Supporting the ETL team ensuring structures are in place to support CDC processes. Using CVS to track and promote DB scripts to QA and Production databases. Worked with off shore DBA teams to implement production database changes.
• Partitioning: Upgraded 10g Range Partitioned tables to 11g Interval Partitioned tables. Also upgraded 10g parent-child Partitioned tables to 11g REF Partitioned tables.
• Create/Modify Autosys processes in support project needs.

Confidential,Park, NJ May 2010 - April 2011

Primary Projects:

• Database: Archiving application databases using IBM Optim. Analyze RDBMS databases to determine schema relationships. Interface with database owners to determine an appropriate solution.
• Project Management: Primary contact within the team responsible for end user consulting for new projects. Chairing weekly team meetings including team members from Europe. Maintaining group SharePoint site and ensuring all projects follow the SOP.
• PACS D/B Archive: Consulted with IM database owner and end users to gain an understanding of the application and database. Analyzed and documented the schema using Oracle data dictionary to determine relationships. Generated Visio E-R diagrams and created a PL/SQL routine to extract data from several unrelated un-indexed tables.

Confidential,Lawrenceville, NJ 2000 – 2009

Primary Projects:

• SQL Server 2000 Upgrade: Lead developer migrating SQL Server 2000 database to SQL Server
• 2005. Created T-SQL code to compare databases to validate database structures. Modified T- SQL stored procedures and functions using SQL Server Express. Set direction for regression testing with QA and production planning with IT team.
• Military: Developed a PL/SQL package to allow DANTES users to access Peterson’s OASC course. This represents a significant revenue stream for the company of $80K over five years.
• ROTC: Developed a PL/SQL package to allow ROTC users to access Peterson\'s SAT and ACT courses. Worked with Business Unit leader to identify the requirements and collaborated with internal and external teams to design, develop, test and deliver the desired system.
• Data Warehouse: Designed and Developed an Oracle 10g PL/SQL Partitioned Data Warehouse to capture and report on student Practice Test data. Designed and implemented a daily process for uploading, extracting and transforming data using custom PL/SQL packages. This process was optimized to reduce execution time from ten hours to less than five minutes. Expanded the warehouse in 2009 to include student test scores data.
• Reporting Upgrade: Upgraded a SQL Server 2000 database reporting system to allow better management of student reporting for the SAT, ACT and PSAT online courses. Created and modified T-SQL database procedures and functions.
• State Access: Designed and developed an access model for TestPrep users across the country to access Peterson’s practice tests. Multi faceted roles ranging from internal and external business requirements gathering, SQL and PL/SQL database design, development and testing. This process has been operational for two years and represents a continuing revenue stream for the company.
• StudentEdge: Designed and developed a PL/SQL authentication process for the company’s flagship SQL-based product which is used by many schools across the country for the SAT, ACT and PSAT online courses.
• Online Courses Upgrade: Managed and coordinated a highly visible multi departmental upgrades throughout 2004. Developed project plans, worked with internal business leaders, external developers and QA to ensure a perfect launch.
• TestPrep Sales Model: Delivered an application and managed implementation of a new web sales model for TestPrep, enabling existing products to be bundled together. Designed and developed extensions to the TestPrep database and UI flow and managed a web developer to deliver the final system.
• TestPrep Database Extension: Extended the database to give access to large number of military users. Improved customer support by designing and developing a database e-mail alert reporting system to track client usage. The alert system significantly reduced the number of issues reported by clients leading to a reduction in the number calls for the customer support team.
• TestPrep Database: Designed, developed and implemented the database which is the foundation for flagship products for the company. It has grown from supporting one test to over 300 tests and has expanded to over ninety tables. Responsible for the creation of the Logical and Physical data models and all objects (Tables, Primary Keys, Foreign Keys, Indexes, Triggers, Sequences etc.), combined with supporting PL/SQL code.