SUMMARY

• IT enthusiast having around 10 years of working experience as a PL/SQL Developer, Data Modeler, Data Architect, BI Modeler/Architect, ETL/ELT Developer and Database Administrator in design, development, maintenance and production support phases in renowned IT Organizations.
• Responsible for gathering requirements, creating data mapping documents, writing functional specifications, creating Conceptual, Logical and Physical Data Models.
• Working experience on OLTP and OLAP databases. Extensively worked on snowflake, star schema designing using fact and dimension tables (Ralph Kimball method). Extensively worked on implementing normal forms in OLTP databases.
• Responsible for taking the hot/cold backup, cloning of the database, database cleanup, database performance issues and database maintenance.
• Experienced in loading huge amount of data into data warehouse using ETL tools like Informatica, DTS, SSIS and Kettle/ Pentaho
• Responsible for developing PL/SQL collections, packages, procedure, functions etc.
• Extensive working experience on manual ETL (PL/SQL Driven) and manual Data Migration (PL/SQL Driven) projects.
• Extensive working experience on SAP BO and was responsible to developing ad - hoc reports.
• Extensively worked on range of database technologies like Oracle, MySQL, SQL Server, IBM DB2 and MongoDB.
• Expertise in using SQL Developer data modeler, MySQL workbench and Visio for doing data modeling.
• Extensive experience on forward and reverse engineering processes by using CA Erwin.
• Hands on expertise on performance tuning of SQL queries, Stored Procedures and various PL/SQL intensive applications.
• Developed SQL*Loader programs to load data from flat file to temp tables. Developed PL/SQL programs to update interface tables and execute along with loader programs.
• Having exposure of UNIX and shell scripts.
• Completed real time training on ORACLE D2K (Forms 9i) from SQL*STAR INTERNATIONAL.
• Completed ORACLE CERTIFIED ASSOCIATE (OCA) in Oracle 9i.
• Completed IBM CERTIFIED DATABASE ASSOCIATE FOR DB2 FUNDAMENTALS.
• Completed document database MongoDB certification from 10gen.
• Have designed and developed data model for Jones Lang LaSalle real estate project on SQL SERVER database.
• Have designed and developed data model for Lawson motor service project on MySQL database.
• Worked on Confidential LTD largest Government oracle application implementation project and involved in data migration from Sybase to Oracle.

TECHNICAL SKILLS

RDBMS: Oracle 8/9i/10g/11gR2/12c, SQL SERVER 2008, MySQL 5, IBM DB2 9

NoSql Database: MongoDB

ETL Tools: Pentaho Data Integrator, IBM Data Stage, Informatica, Oracle Data Integrator (ODI)

Reporting Tools: SAP Business Objects

Database Tools/Utilities: SQL*PLUS, SQL-Loader, TOAD, WMEMPROF, SQL Developer.

Data Modeler Tools: SQL Developer Data Modeler, MySQL Workbench, ER Studio, Visio, Erwin Data Modeler

Operating Systems: HP-UNIX, Windows NT/XP

Languages: C, PL/SQL, UNIX (shell scripting).

Domains: Investment/Banking, HR/Payroll, Retail, Healthcare, Real Estate, Motors, Entertainment.

PROFESSIONAL EXPERIENCE

Confidential

Database Architect/Administrator

Responsibilities:

• Created conceptual, logical and physical models for OLTP and OLAP systems using CA Erwin.
• Designed and developed an ELT process to move the data from OLTP to OLAP systems by using Oracle Data Integrator (ODI).
• Responsible for moving data migration from various external systems to Oracle database.
• Implemented data discovery and data mapping strategies.
• Worked on integrating multipledatasources for BI Reports usingPentahoDataIntegrator.
• Responsible for taking the backup of the database of the database, cloning of database and maintenance.
• Extensively used RMAN, expdb/impdb functionality take the backup of the database.
• Review and provide suggestions on the performance pain points of the existing system.
• Responsible for providing solution for PL/SQL performance issues.
• Analyze and provide solution to improve response time of the real time and ad-hoc reporting.
• Modify and refine architecture based on findings.
• Responsible for estimating work effort for project.

Confidential

Database Architect/Administrator

Responsibilities:

• Designed, implemented and maintained conceptual, logical and physical models the OLTP and OLAP systems using Visio.
• Responsible for developing ETL process to move the data from OLTP to OLAP systems.
• Implemented 3rd Normal Form in OLTP and Ralph Kimball method of designing (Fact & Dimensions).
• Review and find out the performance pain points of the existing system.
• Responsible for taking the backup of the database of the database, cloning of database and maintenance.
• Extensively used RMAN, expdb/impdb functionality take the backup of the database.
• Analyze and provide solution to improve the real time and ad-hoc reporting.
• Suggested and implement partitioning to improve the performance of the system and make it scalable.
• Responsible for developing proof of concept and prototyping activities to assess whether the proposed architecture and database components meet the non-functional requirements like reliability, scalability, performance and maintainability.
• Responsible for loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD and FASTLOAD. The volume of database size was around 20 Terabytes.
• Responsible for refreshing data by using fast export and fast load utilities.
• Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system.
• Establish database security policies.
• Develop strategies for data acquisitions, backup, archive and recovery, and implementation of a database.

Confidential

Database Architect, Developer, Support Engineer, Administrator

Responsibilities:

• Designed, implemented and maintained conceptual, logical and physical models the OLTP and OLAP systems using CA Erwin.
• Designed and developed an ETL system to move the data from OLTP to OLAP systems.
• Collaborating with senior architects to discuss the requirement and to finalizing the database changes.
• Tracking the system for bad performing queries by using TKPROF and AWR reports.
• Develop and implement the complex reporting queries.
• Developing back-end program using PL/SQL i.e. by writing stored procedure, triggers, views, sequences, Packages etc.
• Built a reportingDataMart for reporting purpose. BuiltPentahoSchema for analytical reports
• Responsible for taking the backup of the database of the database, cloning of database and maintenance.
• Extensively used RMAN, expdb/impdb functionality take the backup of the database.
• Responsible for developing delta scripts to resolve the production support issues.
• Develop strategies for data acquisitions, backup, archive and recovery, and implementation of a database.
• Build and deploy the application patches for development and testing environments.
• Modify the implement the partitioning in the highly populated tables.

Confidential

Programmer Analyst, Data Modeler

Responsibilities:

• Analyze the existing report and prepare a technical plan to automate it.
• Develop the macros to automate the sequenced steps.
• Designed, implemented and maintained the OLTP and OLAP systems.
• Develop and implement the data import layer to load the data from data store to reporting database.
• Generated ETL scripts to fetch the aggregated data to our database, which we use in our reporting purpose.
• Write the reporting queries and schedule it to populate the reporting database.
• Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD and FASTLOAD.
• Refreshed the data in Teradata by using fast export and fast load utilities.
• Used Teradata administrator and Teradata Manager Tools for monitoring and control the system.
• Establish database security policies.
• Ensure Database Reliability and Performance (e.g. Teradata load balancing).
• Develop strategies for data acquisitions, backup, archive and recovery, and implementation of a database.
• Responsible for delivering final report to business analyst to every week.
• Responsible for writing the top mover queries.
• Responsible for tuning the application queries.

Confidential

Designer, Data Modeler, Developer and Unit Tester

Responsibilities:

• Developed the process to extract the data in the csv format from the existing data source.
• Developing the control file to load the data from csv file to the system.
• Responsible for developing the business logic to calculate the electricity bill for each and every employee who stays in company quarters.
• Design and develpment of specifications, writing Stored procedure.
• Involved in data migration from Sybase to Oracle.
• Involved in generating Reports using SAP Business Objects.
• Responsible for Data Discovery and Data Mapping for the migrated data involved through various sources.
• Responsible for developing reports using Oracle reports developer.
• Responsible for developing forms using Oracle forms and was extensively using Oracle D2K.
• Developed wrapper to backup the data and structure while migrating from Sybase to Oracle database.
• Involved in writing the shell scripts to automate the attendance report generation process.

Confidential

Design and Development

Responsibilities:

• Design and development of specifications, writing Stored procedure.
• Implemented and maintained the OLTP and OLAP systems.
• Involved in production support and manual testing.
• Involved in generating SQL Reports.
• Involved in gathering the requirement phase, interacting with various users to address their technical issues with the product.

Confidential

Design and Development

Responsibilities:

• Responsible for writing business logic by using PL/SQL Stored procedure, database objects and complex queries.
• Responsible for generating the SQL * Loader control files to load the raw data to staging tables.
• Extensively used cursors, collections and advanced PL/SQL in the business logic wrapper.
• Responsible for implementing the complex queries to support the various reports development.
• Involved in data discovery phase to find the source definition of each and every dimension involved in reporting domain.