SUMMMARY
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 , Oracle Enterprise Manager, 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 9i Application server, Oracle WebLogic Server 11g, FTP, Data Warehouse, Visual Source Safe, WEBQL,Businessobject6.5,Cognos 8.3, Apache, Exceed, Secured client Shell, IBM Info Sphere Data Architect, Oracle Apex 4.1, Informatica 9.1
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,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