Creative and results-driven senior oracle technology consultant with 19+years of experience in successfully building state-of-the-art solutions to meet challenging business needs of Banking, Investment, Construction, Environment, Energy and Health industry. Accompanied at integrating technical know-how, IT business process design, and staff capabilities to accomplish goals, Strong analytical and problem solving skills with ability to build winning teams and address client needs, excellent ability to work with corporate and unit executives to align business objectives with IT service capabilities.

• Oracle PL/SQL and 4GL Development
• Full Life cycle Development
• Oracle Database Administration(Ver 7-11g)
• Data Modeling
• Database Development
• Project Management
• IT Management Process Design
• Web Development

TECHNICAL SKILLS
Languages: PL/SQL , SQL,SQL*PLUS, JAVA, JAVASCRIPT, COBOL, HLI, ASSEMBLER, FORTRAN
Software: Oracle Designer 6i, Oracle Forms 4.5/5.0/6i/9i, Oracle Report 2.5/3.0/6i/9i, Oracle Jdeveloper 3.2 , MS Visio, MS Xwindows, Dream Viewer 4.0, Oracle Discoverer 3.1, Actuate report 6.0, MS Project 2000, Unix, ODBC, JDBC, Erwin 4.1, Crystal Report 9, Citrix Server, Toad, Dynamic SQL, Pro *C, PVCS 6.0, Visual Basic 6.0, MS Access, Ms Excel, MS PowerPoint, Oracle 9iAs, FTP, Data Warehouse, Visual Source Safe, WEBQL,Businessobject6.5,Cognos 8.3, Apache, Exceed, Secured client Shell, IBM Info Sphere Data Architect, Oracle Apex, Informatica

Professional experience

Confidential 07/2010 – Todate
Data Architect/Senior Database Management Specialist

• OLAP design and constructions, persistence and business logic layer development extraction/transformation/Loading (ETL) Design and implementation, report development, database system trouble shooting and performance tuning
• Published Data Dictionaries ,Encoded Reference System, artifacts and Mapping System
• Member of architect team and involved in development of Application Data model, logical data model and artifacts. Prepared Apex application for mapping of data model and different interfaces.
• Created the dimensional logical model with approximately 28 facts, 100 dimensions using IBM Info-sphere IDA
• Worked with DBA to create the physical model and tables. Scheduled multiple brain storming sessions with DBAs and production support team to discuss about views, partitioning and indexing schemes case by case for the facts and dimensions
• Developed and implemented the coding of Informatica Mapping for the different stages of ETL.

Confidential 03/2009 – 07/2010
Senior Database Developer

• Completed Database Tuning & Backup/Restore Training from Learning Tree
• Involved in designing , validation of different forms for clinical Studies
• Wrote Functions and packages to be used in JAVA application
• Interacted with the client throughout all phases of Business Objects development
• Developed and tested multiple Business Objects reports.
• Designed the Information Model (OLTP) for NFGS Studies.
• used Rapid Development Methodology for application development
• Reversed engineered the oracle databases by using VISIO

Confidential 06/2006 – 03/2009
Lead Database Developer/DBA

• Participated as leading role to enhance, design and implement a medical research Data Warehouse and business intelligence system utilizing Oracle 10g architecture and Business Objects and COGNOS Suite reporting tools
• Responsible To create Universe and publishing of Frame work Manager
• Did Reverse engineering for Oracle database to understand the logical and physical data model (ERWIN, VISIO)
• Translated business requirements into dimensional data model using ERWIN
• Involved in DBA functions as Creation of Database, RMAN script for Backup,Import/Export . Tuning and security.
• Helped to identify issues and opportunities, define outcomes, explore possibilities, find out what works well , create solutions and action plan, workout strategies, create result and learn from differences.
• Implemented Functions, procedure and packages IN PL/SQL Environment
• Wrote Complex SQL to extract data from ORACLE 10g and SYBASE database and. Performed SQL Tuning using explain plan, SQL trace and Optimizer hints.
• Installed COGNOS reporting software on SOLARIS10 OS by using oracle application server and LDAP for security. Used VI editor for UNIX scripts. Diagnosed and resolved performance issues with COGNOS
• Involved in requirements Gathering and Technical design engagement with medical research team
• Modified Grant applications forms (HHS) by using Oracle forms 9i
• Wrote SQL*LOADER control files for uploading legacy data to interface table
• Coordinated day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance.
• Got training of capability Maturity Model Integration(CMMI)
• Team comprised of six members

Confidential– MD 05/2005 – 06/2006
Senior Consultant

• Participated in project and planning, budgeting, and requirement analysis. Documented functional and technical specifications. Worked with database team to understand database data modeling.
• Produced Project Status report, led the team and resolved day to day issues with emphasis on SLDC
• Implemented the system using stored procedures, Functions, packages and UNIX shell scripts. Extensively used REF Cursors , Dynamic SQL ,DBMS Packages and oracle application context.
• Worked closely with team members to perform SQL Tuning and recommended tools to improve performance Used ERWIN and TOAD to review Physical data model of PICA database (OLTP), Constraints, Foreign keys and indexing of tables.
• Extract information from database by using packages and pass it to Epiphany application through TIBCO
• Wrote PL/SQL standards for packages and reviewed every package before to submit.
• Created Materialized View and simple views and embedded them in SQL Got training of Kean project management and SLDC and applied the same for project.
• Used Rapid Development Methodology (RAD) for this project Team Consist of Five members

Confidential- Gaithersburg, MD 04/2004 – 05/2005
Systems Analyst

• Data Warehouse design for the medical tools information such as description, size and availability in market.. Developed searching strategies and extracted data from different websites using WEBQL tool
• Designed template builder tool to assist product analyst to create templates By using Oracle Forms 9i.
• Developed different Forms Using forms 9i and deployed to Oracle application server (Web).
• Worked on oracle Financials 11i forms and placed back on oracle application server
• Wrote packages, functions ,procedure and triggers
• Performed DBA functions such as import, export, database tuning , enrolling users and maintaining system security
• Developed Search engine to fix and match dirty description of items against database by using PL/SQL and regular expression
• Migrated data and code from cache web based system to oracle
• Team contains 3 members

Confidential, Linthicum, MD 11/2002-04/2004
Consultant

• Supported RAG staff in efforts to improve business technology and processes
• Conducted activities related to database and systems planning, development, and deployment.
• Responsible for the establishment of policies and procedure pertaining to their management ,security , maintenance and utilization , including database and system configuration, setup, maintenance, performance tuning , user access, backup, and recovery procedure.
• Gathered business requirements, designed data structures and loading strategy, developed oracle data warehouse to analyze production data for decision support services and reporting. Used Star schema concept to design data model.
• Developed Forms and reports by using oracle forms & report 6i. Used oracle 9i UNIX based as back-end tool.. Familiar with JINITIATOR on Netscape.
• Created ER diagram & forms through Designer 2000. Used reverse engineering concept to create ER diagram from database.
• Created project plans for development work and documentation, which allowed other programmers to understand related process and tools.
• Used Change Control processes to make any changes to production environments.

Confidential, Richmond, VA 08/2002-11/2002
Senior Consultant

• Designed & developed thirty complex reports using Reports 6i. The project was completed in the time frame requested.
• Prepared detailed analysis report based on user’s requirement
• Involved in development of different type of Tabular and statistical and cross tab reports

IConfidential, Palatka, FL 12/2000-05/2002
Technical Project Manager

• Determined activities of project and priorities and performed proper resource utilization. Prioritized work in favor of initiatives that were most aligned with business direction. Directed plan execution and completed project ahead of schedule and within assigned budget. Used Microsoft Project to prepare project schedule. Responsible for analysis, design, data modeling of system and used Oracle Designer 2000 for data modeling and change management.
• Used Rapid Development Methodology for application development and submitted deliverables needed for project.
• Managed meetings with different group of users to understand process and prepare business rules, prototypes and detailed analysis report.
• Involved in creating , defining, developing of Data warehouse based on FLORIDA state meteorological data. 40 million transactions are inserted through SQL*LOADER process
• Trained, mentored and introduced data warehousing concept to achieve better result of query time
• Created ER diagram (OLTP) using Designer 2000 by using surrogate key Concept. Transformed logical to physical model using designer 2000. Led the initiative of a Data Warehouse Project that sources information from five operating transactional systems.
• Performed system monitoring. Trouble shooting and PL/SQL code writing SQL Loader Scripts and database load task.. Introduced Data warehouse concept to get better performance ..
• Performed DBA functions such as indexing, bitmap indexing, creation of views and materialized views, import and export utility, and creation of table space on tables
• Created database triggers and stored procedures
• Performed Software development life cycle steps like requirements gathering, analysis, designing, and development using case tools , data flow diagram , system and program specification for business application need.
• Designed and developed intranet application using HTML, Java Script, Dreamweaver, Java, Java beans and Oracle9i AS. Prepared reports through Actuate (5.0) software
• Created Business Areas using Oracle Discoverer Admin for changed & new reports
• Wrote Unix Shell scripts & pearl scripts to handle functions on Unix box
• Designed test methodology and wrote scripts of unit, regression and system test
• Prepared documentation, including user and system manual for application.
• Team Consist of 10 members

Confidential, Richmond, VA 10/1999-12/2000
Consultant
Team lead and hands-on application support for Vision System

• Created packages that interface with Oracle forms and reports
• Worked on vision application designed to keep patients and their claim information.
• Trouble shot performance issues and bugs within packages, forms, and reports using DBMS-Output, forms debugger, explain plan and TKPROF
• Designed and developed forms and reports. Used Designer 2000 to generate forms
• Used PVCS tool as configuration management.
• Involved in process to create data warehouse, Conducted data cleaning by removing orphan and duplicate records.

Confidential, Richmond, VA 10/1998-10/1999
Consultant

• Managed and performed independent verification and validation of the applications which are based on ORACLE and WANG for year 2000 readiness.
• Worked on Oracle financials, Modified Oracle forms according to user’s requirement
• Conducted communication test to ensure compliance of server, switches, routers, and other communication equipment. Designed telecommunication configuration for the enterprise and prepared test scripts and matrices
• Prepared inventory of software & hardware with their versions and support information
• Prepared test plans for unit, system, stress and regression test by using CACI methodology
• Developed , designed and implemented a relational database system using MS ACCESS for software version.

EDUCATION
Bachelor of Science (Mathematics).

TRAINING
Public trust (DHS) Point Of trust (FDA) 
Oracle database 10g:Backup, Recovery and Server Tuning
Project Management
Oracle Developer 2000, Oracle DBA, Erwin (Case Tools), Data Modeling
MS Access I/II/III
Java
VS Graphics, DOS/VSE/PACE
COBOL ASSEMBLER, FORTRAN/VSAM