Technical Skills:

• RDBMS: Oracle 8/9i/10g/11gR2/12c, SQL SERVER, MySQL, IBM DB2
• 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

Professional Experience:

Role: Database Architect

Responsibilities -

• Review high level architecture and design database components.
• Designed, implemented and maintained the OLTP and OLAP systems.
• 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.
• 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.
• Closely worked with business analysts to pin down the requirements.
• Have used CA Erwin for designing the data model for transactional and reporting databases.

Role: Database Architect

Database: IBM DB2 9, SQL Server, Teradata 14

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.
• Designed and developed an ETL system to move the data from OLTP to OLAP systems.
• 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.
• 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.
• Refreshed the data by using fastexport and fastload 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 load balancing .
• Develop strategies for data acquisitions, backup, archive and recovery, and implementation of a database.
• Closely worked with application developers to drill down the requirement for implementation.
• Closely worked with business analysts to pin down the requirements.
• Have used Visio for designing the data model for transactional and reporting databases.

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.
• Designed, implemented and maintained the OLTP and OLAP systems.
• Created conceptual, logical and physical models for the system.
• 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.
• 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.
• Develop delta scripts to resolve the production support issues.
• 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 5 Terabytes.
• Refreshed the data in Teradata by using fastexport and fastload 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.
• 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.
• Have used CA Erwin for designing the data model for transactional and reporting databases.
• Closely worked with application developers to drill down the requirement for implementation.

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.
• 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 fastexport and fastload 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.

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 data migration from Sybase to Oracle.
• 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.
• 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 data migration from Sybase to Oracle.
• 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 data migration from Sybase to Oracle.
• Involved in production support and manual testing.
• Involved in generating SQL Reports.

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.