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
Database Analyst

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, Nassau Park, NJ May 2010 - April 2011
Senior DBA/Project Manager

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
Software Engineer

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.

Confidential, Lawrenceville, NJ 1989 - 2000
Principal Oracle Systems Analyst

Primary Projects:

• Database Reporting: Created database reporting infrastructure for Worldwide Regulatory Affairs Division using Report Writing tools such as Oracle Reports, InfoReports and IQ Report Writer. Managed reporting requirements for Worldwide Regulatory Information Management System with dynamic HTML reports and Web-based PDF reports using InfoServer and InfoReports.
• Imaging System Upgrade: Managed a highly visible database upgrade for a critical imaging system used throughout the world. Developed entire upgrade plan, timelines, roles and responsibilities. Ensured minimal downtime and maximum regression testing by working with staff at international sites.
• Nonclinical Studies Tracking: Designed, developed and implemented SQLForms/SQLMenu application to track non-clinical studies worldwide, using Oracle CASE tool and InfoReports report writer. Managed all aspects of the design and development process as an application DBA, by creating and implementing all Oracle objects such as Tables, View, Indexes, Constraints, Triggers and PL/SQL Procedures and Packages. Managed two consultants in final delivery. Worked closely with QA to test and document the system. Application was used at five sites within PRI which was fully validated to meet FDA audit standards.
• Other Projects: Generated system and functional requirements for an ordering application and managed two development engineers to complete project. Designed and developed an Oracle application for the library to track journals and photocopy requests. Designed and developed an application for the office of the president to track PRI research grants and investments.

Confidential,, U.K. 1983 - 1989
Systems Engineer

Primary Projects:

• Naval Mines: Drafted proposal and cost analysis for state of the art equipment for naval mine hunters from meeting with intercompany management and sales/marketing personnel from private defense firms in the U.K. Digitized 22 analog trial tapes to graphically reproduce seismic, magnetic and acoustic sensor activity after in-water homing trials.
• Spearfish Torpedo: Assessed the homing subsystem capability using real time software and trials analysis. Represented the company as a technical advisor at Royal Naval bases for in-water torpedo trials.
• Transducer Development: Mathematical modeling and testing of transducer development.
• Tigerfish Torpedo: Produced final three-volume analysis report for the British Ministry of Defense to support their decision to purchase the simulation. Managed a team of six analysts to assess software simulation modeling torpedo, fire control submarine center and surface or submerged targets. Assessed homing subsystem using real-time software and in-water trials analysis. Evaluated software and hardware development.

EDUCATION

Configuring MS Windows SharePoint (70-631) 3/29/2010-4/2/2010 Training Camp, Bushkill, PA
IST229 Intermediate C#, May 2005, Mercer County College, Hamilton, NJ
IST129 Introduction to C#, December 2004, Mercer County College, Hamilton, NJ
Introduction to SQL Server, June 2004, Internal training at Thomson Petersons, NJ.
Java Programming SL-111, January 1999, Sun Education Services, Skillman, NJ
IQ Report Writer, August 1998. Internal training at Bristol-Myers Squibb.
Oracle Designer/Developer 2000, May 1997. Internal training at Bristol-Myers Squibb.
SQLForms 4, January 1997, Internal training at Bristol-Myers Squibb.
Bachelor of Science, Physics and Astrophysics (Hons.), University of London, UK