EXPERIENCE SUMMARY

• Skilled professional with extensive 33 years experience in Information Technology Systems Development Life Cycle . Over 20 years of experience in client-server applications using RDBMS ORACLE 9i/10g/11g. Proven ability in computer-based business Client/Server applications development, Data warehouse, Web design and customer support using various operation systems, tools and hardware platforms. Responsible for design, implementation and testing the database schema, and all related tools and procedures using Oracle. Valuable experience in designing a database within the parameters established for the project. Strong SQL Skills and tuning abilities. Worked closely with other staff members to coordinate assignments and communicate progress and/or difficulties. Participated in department and project meetings. Provided input, solutions and recommendations. Assisted with other duties as assigned. A supporting team player.

SOFTWARE TOOLS:

Oracle 8i/9i/10g/11g, Oracle Data Warehouse, Oracle Developer 2000 Forms 2-6i, Reports 2-6i , Designer 2000, Discoverer 2000 2/3/4, PL/SQL, SQL Plus, TOAD, SQL Loader, PVCS, ASP, Javascript, Coldfusion, Macromedia Dreamweaver, Oracle Web Server Web application server , HTML, ASP, ERWIN, Visio 2000 Pro, UNIX, UNIX /shell scripting, Windows 3.x 2003, Windows, DOS.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Database Administrator

Database Support:

• Analyzed and developed new schema for Confidential Receive and Process Frequency Proposal Workflow - Document processing Event Action / Task module.
• Developed scripts for new schema and developed packages, functions, and procedures to support backend processing.
• Designing and Developing Interface application modules. Coding Import and Export load and batch processing scripts.
• Developed packages, procedures and functions for various process modules.
• Developing adhoc views, reports and queries.
• Develop and deploy Extract-Transform-Load ETL processes.
• Developed schema for appropriate data access permission.
• Resolving database issues.
• Provide guidance and assistance to team members.

Confidential

Database Consultant

Product Support:

• Designing and Developing Interface application modules. Coding load scripts.
• Coding schema scripts, Packages, procedure and triggers.
• Developing adhoc reports and queries.
• Resolving database issues.
• Monitoring Production tasks and resolve any issues related to those tasks.
• Provide guidance to team members.

Confidential

Sr. Database Architect

Data warehouse :

• Designed and developed a Data Warehouse DW for Confidential. The Confidential is being used for internet reports. access via the internet and intranet. With this DW in place, the response time has tremendously improved.
• Designed and developed various web reports in ASP code.
• Creation of dimension and fact tables for data warehouse STAR SCHEMA .
• Performed ETL Extraction, Transformation, and Loading on Operational system data prior to loading into DW.
• Coded ETL routine for daily updates and staging area. Load scripts.
• Maintain optimal performance of DW.
• Perform relationship and dependency test.
• Designing and developing query reports from static to dynamic reports Operational Tuning of SQL scripts and databases.
• Redesigned various web reports to improve response time and removed hard coding of period or any other parameters if any.
• Added and modified this process to evaluate multiple answer sheets for a specific course at different time periods.
• Added provision for reading data from the web along with normal usage via the postal system.
• Changed the course answer section to a more generic course exception table where an exception can be defined avoiding any hard coding in the code / procedure.
• Added provision to achieve data to a back up table.
• Also, added provision to read and match all available course versions. The application has proven to be tremendously successful and has earned the Marine Corps Institute MCI praise from the Marines in Iraq and Afghanistan because of its immediacy and reliability. Adoption rates have exceeded expectations.
• Work involved creating both the database back-end for storing answers, the web application for capturing entered data and submitting it to the back-end, and procedures for transferring the data to the legacy Confidential servers. Almost 20,000 grades have been processed in its first 5 months of operation, including over 5,000 grades processed in Confidential.
• Designed and developed database for next-generation training management application for the Confidential. This system enables training Confidential and Officers to review the training status of Marines in their unit. Almost 1,000 unit accounts have been created, and over 2,000 users have been authorized into the system.
• Modified and added new grading business roles in this module. A Confidential database table was added for defining any exception to a course to avoid any hard coding of a business role to the system. Procedure was modified accordingly.
• Fixed numerous bugs and incorporated new business roles in the main Confidential applications Oracle forms and reports .
• Involved with clients to plan, define and document user requirements.
• Assisted in Oracle installation server and client .
• Designing / Modifying logical schema diagram Star schema diagram .
• Designing / Modifying ER Entity Relation / Dimensional module Diagram.
• Designing and developing logical and physical data models.
• Creating physical database, adjusting table space and data files as required.
• Reviewing naming conventions used for all database objects.
• Performing data analysis and process modeling.
• Defining user roles and privileges data access components .
• Assisted in troubleshooting Oracle error codes
• Coding procedures / functions / triggers for various applications in PL/SQL.
• Testing of operational reports.
• Assisted in the design and creation of user interface.
• Assisted in designing databases and coding of web reports ASP .

Confidential

Lead Software Engineer

• Defined development plans and deliverables Proposed implementation dates Pre/Post .
• Worked closely with technical lead to create a development and deployment strategy.
• Assisted in writing proposals and defining the scope of new projects.
• Coordinated with project management and information architects to ensure that the project remains in line with the project/client objectives, schedule and budget.
• Participated in the full life cycle development: Requirements gathering, database structure design Logical and physical with Designer 2000 and technical specifications definition.
• Created and made enhancements to forms, menus, forms triggers, record groups, reports, report triggers and used debug facility to trace trigger operation in forms, defined chart items and graphical display.
• Produced the documentation used as application development design specifications and functional requirements including application flow and logic diagrams.
• Developed PL/SQL packages Procedures, Functions for data transport and manipulation. Loading and extracting data files into/from Oracle using SQL Loader. Developed and maintained Entity Relationship Diagrams ERD .
• Performed Unit testing, system validation and provided technical support based on deep knowledge of the existing relationships between core enterprises systems.

Projects:

Confidential:

• Defined and prepared requirements documentation.
• Incorporated all necessary changes for Confidential project in geo demographical research schema Oracle Forms, Reports, Pro C and PL/SQL, C .
• Confidential:
• Created logical and physical database and application using Developer 2000 for extracting / loading data using bulk collect and creating Confidential flat data and report files on the UNIX system.
• Using remote shell, data files were copied to the specified directory and reports file was copied via FTP from UNIX to the user's workstation for further viewing in Microsoft Word or other text editor.
• Designed and developed a front end interface Oracle forms and developed multiple Oracle reports using Developer 2000 Database and SQL Tuning.
• Technical / Production Support:
• Successfully resolved 70 Team share support issues, out of which 40 were 911 calls. Provided all necessary assistance to fellow team members.
• Supported Enterprise Systems:
• RSI Radio Station Information , QDP Qualitative Diary Processing .
• GDR Geo-Demographical Research , EDD External Data Delivery Support.
• DSTC Data Service Tier Construction , ARM Arbitron Reporting Management .

Environment: Oracle 8i/9i, Oracle 8i/9iAS, ACCESS, Designer 2000, Developer 2000 Forms 4/5/6 and Reports 2/6 , Discoverer 2000/Browser 2/3/4, SQL, PL/SQL, SQL Plus, SQL Loader, TOAD, UNIX shell scripting, Pro C, C, VB, JAVA, ASP, Javascript, ColdFusion, HTML, UNIX, Win-NT