Bipin Kumar Singh Email and Phone Number

• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.• Involved in the continuous enhancements and fixing of production problems.• Extensively used bulk collection in PL/SQL objects for improving the performing.• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.• Understanding the existing systems and handling Business Exceptions.• Developed scripts for validating the UAT deployment for the schema objects.• Used Cursors and Ref Cursors as a part of the procedure to retrieve data in procedures.• Wrote complex SQL queries using Joins, Sub queries and Group function.• Wrote Unix Shell Script d schedule various jobs using crontab.• Extensively used Advanced PL/SQL features like Bulk Collects, FORALL in the procedures for the performance issues.• Extensively involved in the performance tuning by using EXPLAIN PLAN.

• Interacted with Business Analyst to gather and analyze the Business requirements.• Worked closely with business user to provide day to day Support for business needs.• Involved in full development life cycle of the project from the requirements to production implementation. • Coordinating with the business users for System Test and User Acceptance Test.• Generated SQL and PL SQL Script to Crate and Drop database object including: Tables, Views, Primary key, Index, Constraints, Package, Sequence, Grants and Synonyms.• Used Performance tuning Utilities like Explain Plan and SQL Trace and DBMS_PROFILER to improve the performance by reducing he run time of queries n the database.• Based on the data loaded n the target database (Oracle) various business reports e developed.• Wrote Unix Shell Script d schedule various jobs using crontab.• Handling UAT and analyzing he issues raised by the user.• Used Dynamic SQL to create table, drop table and insert data during run time environment. • Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.• Provide Support or the project during the Deployment of the code change change in production.• Used Materialized views in order to improve the performance. • Extensively used bulk collection in PL/SQL objects for improving the performing.• To Make sure all Upstream and Downstream Interfaces are connected and act in case of any feed failures or other Ad Hoc Requests. Sharing Public keys and adding other interface's Public keys to Application's Authorized keys

• Handling the old report, handling enhancement, break fixes.• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.• Involved in modifying various existing packages, procedures, function and triggers according to the new business measures.• Finding the root cause and providing the permanent fixes.• Wrote complex SQL queries using Joins, Sub queries and Group function.• Handling escalations and following up the reporting issues on periodic basis by coordinating with Operations team and various other teams.• As part of supporting production team creating new PR (problem record), managing CR (Change record) and maintaining IR (incident records)• Documenting the end user guide and released various versions of the documents.• Acting as a liaison between various teams like Support ,Maintenance , Development

Part of Development & Implementation team and MIS reporting MIS Reporting with SQL• Responsible of maintaining store inventory and sales report across India• Responsible for Developing macro as per reporting requirement• Responsible for preparing reports like Purchase analysis, Sell through, OTB analysis, Forecasting, Brand Analysis, Purchase Order analysis.• Responsible for sales planning reporting like Projected sales, Stock in hand, New arrivals coordination with buyers & monitoring the movement of the same. • Responsible for allocating sales targets (Target to be fixed Vs Achieved) and analysing targets on daily/weekly basis, analysing achievements/shortfalls and coming up with an action plan for the same • Responsible for sending report to third party vendor on weekly/monthly basis.Application Development and Support• Responsible for maintenance of store software if any bug reported from across India on Oracle platform• Only point of contact for compony across India for providing Application bug resolution for database• Responsible for updating Application coding and database table structure as per the company requirement• Responsible for handling company database. In addition to ongoing work activities, I am part of Application and Macro development team which is involved in creating store application and Macro for automating reporting across India.• Strong knowledge of Macro and VB coding• Single handily Developed CRM (Customer relations management) application which is used across India by the company.• Single handily Developed Alteration application for company which is used across India by the company.