SUMMARY:

• Over 12+ years of experience in software consulting.
• Worked in Oracle Development for over 10+ years in developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems.
• Worked in various Industries such as Power, Manufacturing, E - Business, Retail and Tourism.
• Expertise in PL/SQL Procedures, Functions, Packages, Triggers, Materialized views, Collections, SQL* Loader, Data Loader, UTL FILE, External Tables, Tuning database queries, Forms6i, Reports6i, Interfaces, Conversions, DB Link, UNIX Shell Scripting.
• Extensive Experience with Data Extraction and Data loading through multiple applications/ Databases.
• Dimensional data modeling using star and snowflake schema in data warehouse/ data mart environment.
• Well versed in Normalization/De-normalization techniques for optimum performance in relational and dimensional database environments.
• Involved in all phases of the software development life cycle (SDLC), from user interviews, requirements collection and definition through to implementation and final testing.
• Experience in creating and documenting Metadata for OLTP and OLAP when designing a systems.
• Proficient in identifying Facts and Dimensions, Star Schema and Snow Flake Schema and ODS architecture for modeling a Data warehouse in Relational, Dimensional and multidimensional modeling.
• Experience in development of T-SQL, DTS, OLAP, Stored Procedures, Triggers, Functions, Packages, Performance Tuning and Optimization for business logic implementation.
• Good knowledge and working experience with data modeling tools like Erwin and Oracle Designer.
• Experience in data transformation, data mapping from source to target database schemas and data cleansing procedures.
• Facilitated and participated in Joint Application Development (JAD) sessions, and white board sessions to keep executive staff and the team members apprised of goals, project status, and resolving issues.
• Expert knowledge of SQL and PL/SQL.
• Proficient in System Analysis, ER/Dimensional Data Modeling, Database design and implementing RDBMS specific features.
• Well versed with Data profiling, Data Migration and Data Conversions.

SKILLS INVENTORY:

Database systems: SQL Server (2008/2005/2000/7.0 ), Oracle Databases (10g/9i/8i/7.3/6.0), MS access

Data modeling tools: Erwin, Oracle Designer

Programming Languages: UNIX shell script, Pascal, COBOL.

Operating Systems: Windows (NT/XP/2003), UNIX.

Other tools: MSOffice (Word, Excel, Power Point), MS Project.

PROFESSIONAL EXPERIENCE:

Confidential

Data Modeler / Data warehouse Analyst / System Manager

Responsibilities:

• Gathered requirements for algorithms to be used for investment “Customer recommendations” after meeting with senior account managers.
• Created low level design procedures to be created for generating “Customer recommendations” and communicated it to team members.
• Supervised and mentored development of PL/SQL Packages.
• Created Unit test plan and acceptance test plan and ensured testing.
• Created Data acquisition and Interface System Design Document.
• Develop and modify data models when required.
• Real time data upload systems were automated and provided by the regulatory authority vendor.
• Customer transactions were stored along with timestamp information in a data warehouse to maintain an archive of transactions for business, customer and regulatory requirements.

Environment: Oracle 10g/9i, PL/SQL, ETL, SQL*Loader

Confidential, Miami, Florida

System Manager/DBA/System Designer and Developer

Responsibilities:

• Responsible for managing the Oracle 9i database, fixing grave data inconsistency and application errors because of faulty system implementation and inadequate user training.
• Implemented changes in business rules and practices on the application system and database.
• Performed regular data backups, did performance tuning, fixed problems with software and data to ensure smooth operation.
• Had a constant dialog with system users to identify problems and acted as the one man help desk at Confidential and Confidential .
• Created new Forms and Reports in 6i for the management in order to facilitate inventory and cash flow management.
• Wrote a number of PL-SQL triggers and subroutines to accomplish data consistency and referential integrity.

Environment: Oracle Designer, Oracle 9i, PL/SQL, ERwin, MS-Office, Win 98/NT

Confidential, Miami, Florida

Oracle Consultant

Responsibilities:

• Wrote scripts to transfer data from the companies Microsoft SQL database to its new Oracle database. The scripts had to be efficient and comply with run time restrictions.
• Wrote scripts to cross-check and verify data integrity after transfer.
• Converted existing procedures in T-SQL to run on the Oracle server. After conversion, wrote test procedures to test the new procedures.

Environment: Microsoft SQL, T-SQL, Oracle 9i (UNIX), PL/SQLMobile

Confidential, Miami, Florida

Oracle Consultant

Responsibilities:

• Designed and developed an enterprise wide Data Mart in Oracle 8i. Analyzed user requirements, designed and created a four dimensional star schema for a Web Content Management System.
• Wrote scripts (SQL*Loader, PL/SQL) to Extract, Transform, Load (ETL) legacy data from a Navision database to Oracle using flat files.
• Also loaded image files into Oracle tables (JPEG files to BLOB datatypes).
• Developed forms in Oracle Forms 6i to implement “Image Management System “and “Content Management System” for web deployment.

Environment: Oracle 8i, PL/SQL, Oracle Forms 6i & Reports 6i, SQL*Loader

Confidential, North Miami, Florida

Oracle Consultant

Responsibilities:

• Met users to identify requirements and created a Normalized data model.
• Wrote PL/SQL stored Packages and SQL*Loader scripts to Extract, Transform, Load (ETL) legacy data.
• Developed the Purchase Order System using Oracle Forms 5.0 and Reports 3.0.
• The Forms and Reports were designed, coded and generated in Designer 2000 v2.1 and BrioQuery.
• The Purchase Ordering and Traffic Control Systems involved creating 45 Forms and 33 Reports.

Environment: Oracle 8i (NT), PL/SQL, Oracle Forms 5 & Reports 3, SQL*Loader

Confidential, Bay City, Texas

Oracle Consultant

Responsibilities:

• Designed and developed an Equipment Clearance system to create work orders for executing maintenance operations at a nuclear power plant.
• Project pre-requisites were that the system be operator error resistant.
• We had to implement all safeguards and business rules required by a nuclear plant and handle a high volume of transactions without user conflict.
• Identified and analyzed user requirements.
• Drew up a Normalized database design and an Application design, which satisfied business needs and ensured system safety.
• The database and forms were generated from Designer 2000 v1.3.
• Delivered to the customer’s satisfaction after testing.

Environment: Oracle 7.3 (UNIX), PL/SQL, Oracle Forms 4.5 & Reports 2.5, Designer 2000 v1.3