Professional Summary:

• Database Architect has around 9 years of technical experience in design, development, maintenance and production support in renowned IT Organizations.
• Worked as a PL/SQL Developer, Database Modeler, Database Architect and BI Architect, was involved in requirements gathering, creating data mapping documents, writing functional specifications, creating Conceptual, Logical and Physical Data Models.
• Experienced in managing large centralized EDWs as well as subject oriented data marts.
• Working experience in OLTP and OLAP databases. Extensively worked on snowflake and star schema designing using fact and dimension tables.
• Extensive working experience on ETL and Data Migration projects by using Informatica and Pentaho.
• Worked on SAP BO to develop the Universe and Ad-hoc reports.
• Have working experience in Oracle Business Intelligence Enterprise Edition to develop the business reports.
• Worked extensively on Hadoop platform using Pig, Hive, and Java to build highly scalable data processing pipelines.
• Define BI standards, guidelines and best practices for business groups and technical teams.
• Expertise in PLSQL support, maintenance and enhancements of Oracle PLSQL based projects, performance tuning of PLSQL code.
• Experience in Relational Conceptual, Logical and Physical model and Dimensional Data modeling by creating Logical, Physical and ER Diagrams using multiple data modeling tools like CA Erwin, SQL Developer data modeler, MySQL workbench and Visio.
• Extensive experience in writing functional specifications, translating business requirements to technical specifications, created/maintained/modified database design document with detailed description of logical entities and physical tables.
• Generated and implemented Data Modeling changes by creating various DDL scripts.
• Worked extensively on forward and reverse engineering processes by using CA Erwin.
• Recommend strategies to improve performance and capacity of BI tools.
• Created and implemented triggers, packages, stored procedures, collections and various database objects in various projects.
• Re-wrote SQL avoiding usage of IN, LIKE and UNION operator.
• Observed AWR/Stats Pack Report including Waits events, CPU timed SQL, Buffer wise SQL, Hard and soft parsing, Hit Ratio.
• 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.
• Responsible for briefing and giving full database backup support to WIPRO developers in shifting the platform from LEGACY to SAP HR, MM, PAYROLL and ATTENDANCE MODULE .
• Having exposure of UNIX and shell scripts.
• Expertise in RMAN Backup Configuration and disk using scripts.
• Cold backup implemented using RMAN USER-MANAGED.
• Performing Backup and Recovery Using RMAN.
• 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 database model for Jones Lang LaSalle real estate project on SQL SERVER database.
• Have designed and developed database model for Lawson motor service project on MySQL database.
• Tuned 'HR/Payroll Detail Extract' process to achieve performance improvements from 9hrs to 15 minutes.
• Worked on BHARAT ELECTRONICS LTD largest Government oracle application implementation project.
• Meeting with users to gather business requirements

Technical Skills:

• RDBMS: Oracle 8/9i/10g/11gR2/12c, SQL SERVER, MySQL, IBM DB2, Teradata
• Operating Systems: HP-UNIX, Windows 2K/NT/XP
• Languages: C, PL/SQL, UNIX shell scripting .
• 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
• NoSql Database: MongoDB
• Modules: HR/Payroll, Retail, Healthcare, Real Estate, Motors, Entertainment.
• ETL Tools: Pentaho Data Integrator, IBM Data Stage, Informatica.

Professional Experience:

Role: Database Architect/BI Developer

Description: Confidential is the Enterprise Data Warehouse EDW for the Home Entertainment. Operational Data source In Networks ODIN application is built to migrate all the Sony products and publishing information to a single system from different territories. It allows controlling the product publishing from a common channel for a widespread of territory programs and seasons. The content being used in ODIN will come from a wide range of different media sectors text publishing, musical works, sound recordings, news, still images and audiovisual . Some of the information being exchanged will come from the original creators of a work, some from managers of the rights to that work, and some from organizations providing services to rights holders.

Responsibilities -

• Review high level architecture and design database components.
• Created a data mart for the reporting system of publishing functionality and data warehouse solution for the ODIN product.
• Implementing batch jobs by using shell scripting on UNIX platform.
• Designed, implemented and maintained the OLTP and OLAP systems.
• Implemented the business logic by using PL/SQL objects such as procedures, function, collections, triggers etc.
• Created conceptual, logical and physical models for the system.
• Designed and developed an ETL system to move the data from OLTP to OLAP systems.
• Provide database related technical insight on the project to tune it for scalability.
• Designed the process for data migration from external system to Oracle databases.
• Collaborate with senior system architects to pin down detailed solutions for specified requirements.
• Create logical and physical model for the new requirement.
• Review and find out the performance pain points of the existing system.
• Provide suggestions to tune the bad performance queries.
• Analyze and provide the solutions to improve the image handling.
• Responsible for providing solution for PL/SQL performance issues.
• Provide engineering and design support for Hadoop build, configuration, monitoring and supportability.
• Responsible for data accuracy, scalability and integrity on Hadoop platform.
• 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.
• Modify and refine architecture based on findings.
• Responsible for estimating work effort for project.
• Analyze difference between old and new system change requirement.
• Closely worked with application developers to drill down the requirement for implementation.

Role: Database Architect, BI Designer

Description This project belongs to Honda reporting. Honda works in shift and the production goes for 24/7. Every department requires pre-defined report to deliver their work. This application is simultaneously used in more than 12 plants and in more than 1200 departments. This application is commonly used for online transaction processing and for reporting purpose. This number was drastically increasing and causing the system performance issues. These underline project is an assessment project where we require to find the pain points of the systems and fix it.

Responsibilities -

• Review high level architecture and design database components.
• Designed, implemented and maintained the OLTP and OLAP systems.
• Supporting and building business intelligence environment, using reporting services, analysis services, and other analytical tools used in the environment.
• Designed and developed an ETL system to move the data from OLTP to OLAP systems.
• Implemented the business logic by using PL/SQL objects such as procedures, function, collections, triggers etc.
• Created conceptual, logical and physical models for the system.
• Provide database related technical insight on the project to tune it for scalability.
• Collaborate with senior system architects to pin down detailed solutions for specified requirements.
• Create logical and physical model for the new requirement.
• Review and find out the performance pain points of the existing system.
• Provide suggestions to tune the bad performance queries.
• Analyze and provide the solutions to improve the image handling.
• Responsible for providing solution for SQL PL performance issues.
• 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.
• Work on 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.
• Modify and refine architecture based on findings.
• Responsible for estimating work effort for project.
• Analyze difference between old and new system change requirement.
• Implemented the business logic in PL/SQL.
• Closely worked with application developers to drill down the requirement for implementation.
• Used incremental agile methodology to implement the business logic and to go the release at the smoother pace.
• Used SQL Server to store the images as it handles the binary files very well.

Role: Database Architect, BI Solution Architect, Developer, Support Engineer

ETL Tools: Informatica

Operating Systems: Linux

Programming Languages: PL/SQL

Duration: February 2010 June 2013

Client Location: Livonia, MI

Description EnterpriseRx is a complete pharmacy management system that facilitates control over the entire prescription filling process while simultaneously providing a solution for many common administration and management responsibilities. The Web-based system's innovative features differentiate it from any other pharmacy system on the market today, and empower pharmacies to seamlessly adjust to industry shifts, confidently deliver excellent patient care, and consistently measure business results. This product was available for individual and big clients who can afford the hardware and software but there was a market segment which cannot afford hardware. This underline project provides the ability to share the hardware and the system, while giving access to same kind of affordable features.

Responsibilities -

• Responsible for preparing the requirement document to accommodate the new functional changes.
• Responsible for the development and maintenance of all Core data models.
• Coordinate with application team and develop all ETL processes.
• Expertise in RMAN Backup Configuration and disk using scripts.
• Cold backup implemented using RMAN USER-MANAGED.
• Performing Backup and Recovery Using RMAN.
• The EDW is used for Enterprise Reporting including mission critical Business and Compliance reports and gets data from the Impact Harmony IH OLTP Database.
• Supporting and building business intelligence environment, using reporting services, analysis services, and other analytical tools used in the environment.
• Assist development teams to maintain all data sources and data storage options.
• Designed, implemented and maintained the OLTP and OLAP systems.
• Created a data mart for the reporting system of pricing module and data warehouse solution for the EnterpriseRx product.
• Implemented the business logic by using PL/SQL objects such as procedures, function, collections, triggers etc.
• Created conceptual, logical and physical models for the system.
• Designed and developed an ETL system to move the data from OLTP to OLAP systems.
• Designed an data migration strategy using Pentaho R D .
• 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.
• Analyzing and creating the logical and physical model for the new functional changes.
• Develop and implement the complex reporting queries.
• Provide guidance to ETL team to fix the migration issues.
• Developing backend program using PL/SQL i.e. by writing stored procedure, triggers, views, sequences, Packages etc.
• oversaw delivery of data from the DW to the user community using SSRS, SSIS and SSAS.
• Develop delta scripts to resolve the production support issues.
• Tuning the application's bad performance queries, procedures and functions.
• Build and deploy the application patches for development and testing environments.
• Modify the implement the partitioning in the highly populated tables.
• Closely worked with application developers to drill down the requirement for implementation.
• Used iterative agile methodology to implement the business logic and to go the release at the smoother pace.
• Used MySQL workbench to design the data model for the EnterpriseRx.

Role: Programmer Analyst, Data Modeler, BI Designer

Description This project mainly deals with examining the business holistically. Every organization's size, focus, customers, preferred methods of operation, and adaptability differs yet each consists of processes driven by people, using structured and unstructured data in multiple applications and formats. Discovering, analyzing, and understanding the flow of work and the interrelationship of data and processes is the most challenging and most critical component of AMS success.

Responsibilities -

• Analyze the existing report and prepare a technical plan to automate it.
• Develop the macros to automate the sequenced steps.
• Ensuring that the data warehouse operational environment is able to meets its SLA's, which entails ensuring that all the critical data files have been received from the vendors, all the ETL's have completed without errors, all the daily reporting is done and the data is available to users for analytical and other ad-hoc reporting needs.
• 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.
• Responsible for delivering final report to business analyst to every week.
• Responsible for writing the top mover queries.
• Responsible for tuning the application queries.
• Used OBIEE to automate the report generation process and to extract the aggregated data.

Role: Designer, , Data Modeler, Developer and Unit Tester

Description This project involves the automation of monthly electrical bill processing. This process loads monthly electrical bill of company employees who are residing in company quarters into the database. The activity involves fetching the data from the excel system and store them into the csv format. Loading it into the oracle database in fast and efficient manner by using SQL-Loader utility, apply the business logic and then generate the reports for payroll use.

Responsibilities -

• Implementing the process to generate the csv files from the existing data source.
• Developing the control file to load the data from csv file to the system.
• Designed, implemented and maintained the OLTP and OLAP systems.
• 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.
• Responsible in planning and designing of QCC module.
• Involved in production support and manual testing.
• Involved in generating Reports.

Role: Designer, Data Modeler and Developer

Description: Excellence Award project deals with the system to provide cash award to facilitate the Employees who work efficiently for the organization. The Excellence Award will be given to Employees who are punctual, availed minimal number of leaves and other criteria for the whole financial year.

The Activity involves the collection of Cluster Data for Each Month, for each employee for the whole Financial Year. Then calculating his late arrivals to the office beyond factory hours, the number of leaves applied in a month and loading his information in database. If the employee exceeds the given constraints, then he/she will be given negative marks. So the employees with least negative marks will be adjudged as a Winner.

Responsibilities -

• Develop data layer to extract data from different data sources.
• Implement logic layer by using PL/SQL to grain the data.
• Ensuring that the data warehouse operational environment is able to meets its SLA's, which entails ensuring that all the critical data files have been received from the vendors, all the ETL's have completed without errors, all the daily reporting is done and the data is available to users for analytical and other ad-hoc reporting needs.
• Designed, implemented and maintained the OLTP and OLAP systems.
• Design and development of specifications, writing Stored procedure.
• Responsible in planning and designing of QCC module.
• Involved in production support and manual testing.
• Involved in generating SQL Reports.

Role: Design, Data Modeler, Development and Maintenance

DESCRIPTION: This project mainly deals with designed in order to reduce any discrepancy that may arise during payroll processing of the organization. This monthly activity consists of several PL/SQL and SQL Scripts which performs specific audit checks on different activities of payroll such as attendance processing, Release transactions, OT processing and reports the user if any discrepancy found that will be spooled to a file, which will be given to Quality assurance team for further analysis.

Responsibilities -

• Design and development of specifications, writing Stored procedure.
• Responsible in planning and designing of QCC module.
• Involved in production support and manual testing.
• Involved in generating SQL Reports.
• Modeling and developing reports using SSIS and SSRS.

Role: Design, Development and Maintenance

DESCRIPTION: The data gathered by Smart card based attendance system is monitored. The data is re-formatted and presented for displaying daily attendance for the month, Analysis of the late comers department wise according to Time slots. It is also used for computing incentive bonus for the employees and direct labor performance, a necessary data to increase the production of the organization.

Responsibilities -

• Design and development of specifications, writing Stored procedure.
• Designed, implemented and maintained the OLTP and OLAP systems.
• Responsible in planning and designing of QCC module.
• Involved in production support and manual testing.
• Involved in generating SQL Reports.

Role: Design, Development and Maintenance

DESCRIPTION: Movement Order System mainly deals with the travel management of the employee. When an employee goes out of station for Official work, the system has to maintain the work details, traveling allowance paid, leave details, mode of transport and much valid information. This project comprises of around 15 modules with each module interrelated. All the users are given separate logins for creation of Movement order, travel details etc, and only specific like Managers or DGM logins are given access to approve the movement order.

Responsibilities -

• Design and development of specifications, writing Stored procedure.
• Responsible in planning and designing of QCC module.
• Designed, implemented and maintained the OLTP and OLAP systems.
• Involved in production support and manual testing.
• Involved in generating SQL Reports.

Role: Design and Development

DESCRIPTION: - E-Banking project system will check the user's existence in the database and provide the set of services with respect to the role of the user. The application is based on three-tier architecture. The cipher key obtained will help to find the fraud application. The business logic helps in authenticating the application, authorizing the users and providing services. The technologies are chosen by keeping the compatibility and performance as the constraints for the application.

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.

Role: Design and Development

DESCRIPTION: - E-channel, the powerful e-Commerce platform empowers the bank to harness the tremendous potential of the Internet and the Internet technologies. It provides the perfect platform to offer integrated remote financial services like saving account, trade finance, bill payment, online shopping. E-corporate mi module enables the user to handle inquiry and funds transfer. The service home page displays the related alerts to Dcs, Bank Guarantees, Bills, Limits and instruments under clearing. The number of unread mails and number of days for password expiry are also displayed as alert.

Responsibilities -

• Design of specifications, development and unit testing.
• Writing business logic by using PL/SQL Stored procedure and database objects.
• Involved in writing queries to generate reports and to address the transactional requirement.
• Involved in production support.