Jaspreet Singh

Jaspreet Singh E-mail:- Phone: -, - Civil Line, Sector -15 Part 1, Gurgaon CAREER SUMMARY Data Analyst/ PL/SQL Oracle Developer with 3.6 years of experience. Expertise in Advance SQL, Advance Excel, HTML, MS-Word and PL-SQL. PROFESSIONAL EXPERIENCE January 2017 — Present Nits Solutions Pvt Ltd Oracle Developer Projects: WPP (Wholesales Parts Purchase) Role: Oracle Developer Description: Wholesale parts purchase portal for dealership. Roles & responsibilities:Development of software using PL/SQL Writing the code by maintaining Coding Standards to get effective quality of code Displaying the Report at Front End using Java Script, CSS, HTML and using environment Oracle Apex 5.0 Unit Testing, Prepare Test cases to verify that code is fulfilling the requirements without any failure Creating views and package as per the technical specification provided. PPB VW (Part Performance Bonus) Role: Oracle Developer Description: PPB is most profitable project of the company. Roles & responsibilities:Development of software using PL/SQL Writing the code by maintaining Coding Standards to get effective quality of code Displaying the Report at Front End using Java Script, CSS, HTML and using environment Oracle Apex 5.0 Unit Testing, Prepare Test cases to verify that code is fulfilling the requirements without any failure Creating functions, triggers, procedures, cursors as per the requirements Nits Solutions Pvt Ltd March 2016 — December 2016 Data Analyst Extract the raw data from Oracle SQL Server by running DML quires, compiled and tracked data, and analyzed data to generate reports in excel spreadsheet. Worked with other team members to complete special projects and achieve project deadlines. Used advanced Excel functions to generate spreadsheets and pivot tables. Handle queries for Audi, Volkswagen and Volvo. Prepare monthly presentation for Volkswagen. Monitor data on daily basis. Aon India Services Pvt. LTD April 2015 — February 2016 Process Analyst Handling almost 10 Critical Clients and preparing Premium Reports for them. Extract raw data from Mainframe and Oracle Sql DML Queries Download the Reports and do Automatic and Manual formatting by running several Macros or by adding Manual formulas for Checks. Doing Reason-ability checks on Reports with last month for any critical variance. Providing Health and Welfare reports to Clients and Vendors. Convergys Pvt Ltd April 2014 — March 2015 Technical Support Officer Provide assistance over the customer’s queries related to the process. Educating customer about the billing and helping them in up gradation. Helping customer with the basic troubleshooting steps with internet, cable and phone services. SKILLS Technical Operating System: Windows Database: Oracle 12c Design Tool: Apex 5.0 People & Personal Team management, Proactive, Adaptive, Communication EDUCATION Master Of Computer Applications Jan 2011 — Dec 2012 Sikkim Manipal University Marks Secured : 76% B.SC( IT) DAV College (G.N.D.U University) Marks Secured : 60% CERTIFICATION Oracle Database SQL Certified Expert August 2007 — June 2010 Oracle Database 10g Administrator Certified Associate AWARDS & EXTRACURRICULAR ACTIVITIES Successfully completed multiple projects. Participated in Group Dance competition. Lead and organized different Fun activities in office. Winner of office Badminton Tournament. 3