SUMMARY

• Database Architect having around 10 years of working experience as a Data Modeler, BI Architect, ETL/ELT Developer and PL/SQL developer in design, development, maintenance and production support phases in renowned IT Organizations.
• Extensively worked on range of database technologies like Oracle, MySQL, SQL Server, IBM DB2 and MongoDB.
• Gathered requirements, creating data mapping documents, writing functional specifications, creating Conceptual, Logical and Physical Data Models.
• Experience on OLTP(transactional) and OLAP(data warehouse) databases. Extensively worked on snowflake, star schema designing (dimensional modeling) using fact and dimension tables (Ralph Kimball method). Extensively worked on implementing normal forms in OLTP databases.
• Expertise in using SQL Developer data modeler, MySQL workbench and Visio for doing dimensional and transactional data modeling.
• Extensive experience on forward and reverse engineering processes by using CA Erwin.
• Experience in usingSAStoread,write,importandexportto another data file formats, includingdelimited files,Microsoft Excel, PDFandMSAccess tables.
• 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.
• Created ETL jobs to load JSON data and server data into MongoDB and transported MongoDB into the Data Warehouse.
• Responsible for migration relational data from Oracle database to MongoDB.
• Responsible for taking the hot/cold backup, cloning of the database, database clean - up, database performance issues and database maintenance.
• 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.
• Hands on expertise on performance tuning of SQL queries, Stored Procedures and various PL/SQL intensive applications.
• Extensive working experience on SAP BO and was responsible to developing ad-hoc reports.
• StrongSASProgramming experience inHealth care,RetailandPharmaceuticalindustries.
• StrongSASprogramming background forcreating,maintaining existing code,ad hoc reportingand supporting the reporting functions.
• Worked with the marketing department to develop marketing campaigns for customer acquisitions that involved liaising with third party Data Providers, setting up internal IT systems and Campaign data analytics.
• Expertise in using various SAS report generating procedures such as:PROC REPORT, PROC FORMAT, PROC GPLOT, PROC GCHART, PROC COMPARE, PROC EXPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABLATE, PROC TRANSPOSE, PROC COPY, PROC SUMMARY, PROC IMPORT.
• 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.

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, HiveQL, Pig.

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

Responsibilities:

• Created conceptual, logical and physical models for OLTP and OLAP (dimensional modeling) systems using CA Erwin. Designed star flake and snow flake schema.
• Designed and developed an ELT process to move the data from OLTP to OLAP systems by using Oracle Data Integrator (ODI).
• Interact with stakeholders in various Big Data initiatives, understand the Data needs and define Data Services product requirements.
• Provide consulting to customers in identifying Big Data use cases and then guiding them towards implementation of use cases.
• Move structured data from Oracle to Mongodb in JSON format and used pentaho data integrator for this.
• Responsible for moving data migration from various external systems to Oracle database.
• Implemented data discovery and data mapping strategies.
• 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.
• Immensely used various active transformations like Filter Transformation, Router Transformation, Lookup Transformation, Update Strategy Transformation, Joiner Transformation and Aggregator Transformation.
• Review and provide suggestions on the performance pain points of the existing system.
• Responsible for providing solution for PL/SQL performance issues.
• Analyse and provide solution to improve response time of the real time and ad-hoc reporting.
• Responsible forSASprogramming background forcreating,maintaining existing code,ad hoc reportingand supporting the reporting functions.
• Worked with the marketing department to develop marketing campaigns for customer acquisitions that involved liaising with third party Data Providers, setting up internal IT systems and Campaign data analytics.
• Modify and refine architecture based on findings.
• Responsible for estimating work effort for project.

Confidential

Database Architect

Responsibilities:

• Designed, implemented and maintained conceptual, logical and physical models the OLTP and OLAP (dimensional modeling) systems using Visio. Designed star flake and snow flake schema.
• 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.
• Analyse 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 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

Responsibilities:

• Designed, implemented and maintained conceptual, logical and physical models the OLTP and OLAP (dimensional modeling) systems using CA Erwin. Designed star flake and snow flake schema.
• 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.
• Provide consulting to customers in identifying Big Data use cases and then guiding them towards implementation of use cases.
• Lead a team Big Data CoE team on different Big Data Solutions/PoCs for multiple customers and verticals.
• 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:

• Analyse 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 development 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.