Software Engineer Sql Server

RAHUL GUPTA

Sr.Software Engineer

Summary

More than 5 years of software industry experience in Designing, development and administration of databases and Manual Testing.

Expertise in Oracle, MSSQL Server and Manual Testing.

Excellent database experience using SQL, PL/SQL, TSQL, Oracle9i and MS SQL Server. Experience of UNIX Commands and in operating systems like UNIX, and Windows (2000/XP).

Ability to work in-groups as well as independently with minimal supervision.

Technical Skills

Programming Languages

SQL,PLSQL,TSQL

Data base

Oracle 9i, SQL Server 2005, SQL CE, SQL Server 2005 Express.

Operating System

Windows NT,2000, XP, Sun Solaris, Unix

Development Tools

TOAD, SQL Editor, Query Analyzer, SQL Differentiator, CEQuery Tool.

Functional Areas

Databases(Oracle, MSSQL 2005) Development,

Manual Testing And Administration

Training Programs Attended

Speak Up: It’s training on how we have to speak effectively and assertively with client. The training is provided internally.

Technical Training: It’s the training on Oracle 9i Database Administration for administering the database backups and recovery scenarios. The training was taken by self.

Oracle Applications Financial Techno Function training on GL, AP, AR, Alerts

Academic Record

B.Tech(I.T.) from JMIT, (Kurukshetra University), 2005 Batch with 68% aggregate.

Higher Secondary from Prerna Public School Sirsa with 67% aggregate score.

Summary of Work Experience

Pine Labs Pvt. Ltd., Noida – October 2005- till Date as Sr. Software Engineer.

Name of Employer : Pine Labs Pvt. Ltd., Noida, India.

Dates of Employment : October 2005 till date

Job Title : Software Engineer

Project Description

1. IRIS (Retail Automation)

The IRIS is a retail automation solution for BPCL to get all the detailed information about the product sale, product receipts with operator and dealer information. This solution is also integrated with smart card and credit card solutions. With this solution BPCL gets information about the happenings on the Retail Outlet at different granularity levels. This solution has a very strong reporting system which helps in analyzing the performance of retail outlets and also on retail outlet level one can analyze the performance of various operators. This Solution uses two types of databases one in-house database that is deployed on the Retail outlets(MSSQL Server 2005 Express) and other on the central host (Oracle 9i) This solution has Following modules

Tracking Product Sale

Card Issuance Engine

Transaction Processing

Back End Processing

Financial Reconciliation

Historical Data Reporting

Payment Acceptance Devices

Dynamic Attendant Tagging

Shift Management

Local Credit Deposits

Bank Deposit System

Alerts and Alarms

Dynamic Pricing

Happy Hour Schedules

Web GUI

Role

Sr.Software Engineer

Responsibilities

Worked as a member of Design team for designing the solution, majorly in database architecture and reporting system.

Worked as the only database developer for the entire client side software consisting of over 400 stored procedures and 300 tables.

Extensively designed various modules and developed stored procedures, functions and triggers with quality logic.

Designed and developed entire reporting system for host and client database.

Developed stored procedures, triggers, functions using PL/SQL for central host database in Oracle (later on migrated to MSSQL Server)

Documented all the database objects with relations and references using a database documentation tool.

Replication of database in MSSQL Express database which does not support replication.

Interaction with client providing them details about the whole solution and solving the problem which they encounter.

Provided Product support at various levels.

Technologies

SQL Server 2005 Express, Windows XP, Manual Testing.

Oracle 9i Database used at back end database on host server (Later on Migrated to MSSQL Server).

Team Size : 8

2. Retail Automation (Third Party Integration)

The Retail Automation Solution is for IOCL where in third party integration has been done. Our solution is the middle tier, which facilitates all the operations on the retail outlets. The communication happen using XML which are parsed using the application developed within and interacts with database to push or pull data.

Fuel Tracking

Transaction Processing

Back End Processing

Reconciliation on Request

Fuelling Point of Sale Terminal

Dynamic Attendant Tagging

Shift Profile Management

Alerts and Alarms

Dynamic Pricing

Happy Hour Schedules

Role

Sr.Software Engineer

Responsibilities

Worked as a member of Design team for designing the solution, majorly in database architecture and reporting system.

Worked as the only database developer for the entire integration consisting of over 250 stored procedures and 200 tables and also handling administration of databases.

Extensively designed various modules and developed stored procedures, functions and triggers with quality logic.

Designed and developed entire reporting system for client database.

Developed stored procedures, triggers, functions using Procedural SQL for Local database on MSSQL Server 2005 Express.

Documented all the database objects with relations and references using a database documentation tool.

Technologies

SQL Server 2005 Express, Windows XP, Manual Testing.

Team Size : 4

Project Description

3. BPCL/BPCL Petro Card

The smart card solution enables BPCL customers to promote their products by offering loyalty points and alternate means of payment through stored value card. This system is being designed and developed to allow consumers to buy gasoline using prepaid smart cards and gain loyalty points for transactions. It provides a complete solution inclusive of backend, Point of Sales (POS) application, and card application. This end-to-end solution provides accurate transactions data, successful communication with banks, and integration into the bank’s systems for periodical reconciliation of accounts. This application has following modules:

Card Issuance Engine

Transaction Processing

Backend Processing

Financial Reconciliation

Reporting and Third Party Integration

Role

Software Engineer

Responsibilities

Development of Stored Procedures, Triggers, Functions and Reporting Packages in PL/SQL. And administering various database objects.

Testing of Database in accordance with Functional document

Worked as a member in Production Database support team.

Documented Quick Reference Manuals and checklists.

Technologies

PL/SQL (Database used Oracle)

Team Size: 5

Project Description

4. BPCL/BPCL BRASS

This is a retail automation(Low End) solution for BPCL using a POS Terminal. The Terminal has the application loaded on it which interacts with the MPD’s to keep track of each and every transaction that’s happening on the retail outlet. In addition to that the POS terminal also has the BPCL Smart card and Credit Card applications installed on it which facilitates the Petro card and Credit Card transactions. In lieu with this BPCL Brass has a web based reporting system which helps in analyzing the performance of a retail outlet. This application has following modules:

Card Issuance Engine

Transaction Processing

Backend Processing

Financial Reconciliation

Reporting and Third Party Integration

Role

Software Quality Analyst

Responsibilities

Testing of the BPCL POS terminal according to the Test Plan.

Testing of BPCL Graphical User Interface according to the Test Plan.

Worked as a member in Production Support team in order to provide technical support to the application users.

Documented Quick Reference Manuals.

Technologies

Oracle 9i, Linux, Manual Testing, Windows XP, Toad

Team Size: 3

Awards and Achievements

Passed Oracle Certification exam 1Z0-007(For SQL) with 94% marks

Received an appreciation letter 3 times for performance in IRIS.

Received award for player of the tournament in cricket.

Strengths

Proven strength in problem solving, coordination and analysis.

Achievement oriented and an ability to manage change with ease.

Excellent knowledge of Retail automation solutions and Card based solutions.

Personal Details

Date of Birth: 27th November 1983.

Father’s Name: Mr. A.K. Gupta

Passport No.: F3135796

Nationality Indian

Marital Status: Single.

Languages Known: English, Hindi and Punjabi.

Permanent Address: B 15/7 Old Courts Colony Sirsa (Haryana)

Email Id: ***********@*****.***

Mobile No.: +91-989*******

Contact this candidate