Oracle database developer
Resume:
Name: Aijaz Ahmad Hajam Email: ********@*****.***
Mobile: +91-897******* / 700-***-****
Summary:
Over 3+ years of practical experience on major facets of IT consulting
It includes Business Development, Business Analysis, Project Management, on-site coordination, client management and Software Delivery.
Experience of handling Development and support projects in Oracle PL/SQL projects.
Worked in SQL navigator and PLSQL developer tools to write PLSQL code.
Writing procedures, functions, cursors, triggers, sequences, SQL queries.
Worked on development and enhancement projects.
Hands on ticketing tools like Service Now.
Worked on Excel VB automation tools. Many tools are in production now.
Experience in generating the reports using SQL, MS Excel, Excel VBA and Power Point.
Responsible for Preparing Documentation to the client, preparing case studies, preparing Data Analytics & Reporting material.
Key Competency:
Oracle PLSQL Development, Data understanding, Management, Manipulation, Insight, Automation, Process Re- Engineering, Development and UAT testing.
Working as a PA and involved in support of PL/SQL Procedures, Packages, Triggers and provide the code fix as per the requirement.
Handy in creating stored procedures, functions, packages, triggers, sequences, SQL queries, cursors.
Skill Set (Technical):
Operating System
Windows
Primary Programming Languages
SQL, PL/SQL.
Procedures, Functions, Cursors, Triggers, Sequences, SQL Queries
Secondary Programming Languages
Excel VB, C, Java.
Excel macros.
Databases & Tools
Oracle 10g, SQL Navigator, PLSQL Developer, Service Now ticketing, BMC remedy, Workload Control Center, FileZilla file extraction.
Employment History:
Name of the Company
Designation
From
To
Cognizant Technology Solutions
Programmer Analyst
May-2014
Till date
Project Description:
1.The Hartford Financial Services:
The Hartford Financial Services Group, Inc., usually known as The Hartford, is a United States-based investment and insurance company that is part of the Fortune 500 list. Headquartered in Hartford, Connecticut. The company’s earnings are divided between property-and-casualty operations, group benefits and mutual funds.
Project Profile:
Project Title
Hartford HIG-Talcott-Centralization
Duration
Sep 2014 – Sept 2016
Location
Cognizant Chennai, India
Environment
Oracle 10g on Windows, Service Now, SQL Navigator, Excel 2010
Overview: Integrated Information Repository is an application that provides an integrated, consistent and efficient repository to perform reporting and data analytics. It holds the historic data from numerous source systems (VISTA, VIPSTAR, RPS, PARS) .
Environment: Oracle SQL/PLSQL, Excel VB, MS- EXCEL & PPT.
Roles & Responsibilities:
Involved in development of PL/SQL Procedures, Packages, Triggers and provided the code fix as per the requirement.
Coding (involves policy rule coding, sequence flow, status flow, and dictionary entries)
Created Test Plan and Performed Unit Testing for the developed reports
Tested the scenarios for the developed reports in Assembly Testing
Ensured customer issue is resolved before deadline or SLA miss.
Created quality deliverables and shared with clients as per business needs.
Responsible for Delivery management, Code review, Quality assurance, User acceptance testing, Production deployments and Root cause analysis of source data issues
Managed End to End Project deliverables - Understanding of project objectives, data requirements,
Ownership in extracting data from various data sources and working with multiple sources to meet the business objectives of the project
Prioritized and scheduled work, managed workflow to achieve operational targets and meet customer needs
Coordinated discussions between various business groups and arrived at efficient solutions for the critical problems
2.GlaxoSmithKline plc (GSK):
Project Profile:
Project Title
GlaxoSmithKline plc (GSK)
Duration
Sept 2016 till date
Location
Cognizant Gurgaon, India
Environment
Oracle 10g on Windows, PLSQL Developer, SQL Navigator
GlaxoSmithKline plc (GSK) is a British pharmaceutical company headquartered in Brentford, London. Established in 2000 by a merger of Glaxo Wellcome and SmithKline Beecham, GSK was the world's sixth largest pharmaceutical company as of 2015, after Pfizer, Novartis, Merck, Hoffmann-La Roche and Sanofi.
Overview – The scope of project is to design, develop, test and deploy an analytical platform to support day to day reporting requirements of various Business Units/Applications.
Environment: Oracle SQL/PLSQL, Excel VB, MS- EXCEL & PPT, File Zilla.
Roles & Responsibilities:
Oracle PLSQL Development, Data understanding, Management, Manipulation, Insight, Automation, Process Re- Engineering, Development and UAT testing.
Working as a PA and involved in support of PL/SQL Procedures, Packages, Triggers and provide the code fix as per the requirement.
Handy in creating stored procedures, functions, packages, triggers, sequences, SQL queries, cursors.
Frequent Client interaction to understand the business and deliver the output effectively
Managed Data extraction and Monthly and Weekly data downloads Production
Ensured zero operational loss due to processing error
Designed the Technical Specification document
Coding (involves policy rule coding, sequence flow, status flow, and dictionary entries)
Created Test Plan and Performed Unit Testing for the developed reports
Worked and involved in development of PL/SQL Procedures, Packages, Triggers and provide the code fix as per the requirement.
Ensured customer issue is resolved before deadline or SLA miss.
Academic Qualification
Academic Qualification
Institute/ University
Year of Passing
CGPA
Graduation ( B.Tech )
AUCET Hyderabad
2013
76.70
12th
JKBOSE Dangiwacha
2009
66.66
10th
JKBOSE Behrampora
2007
64.50
Achievements:
Awarded Associate of the Quarter from Cognizant.
Awarded Best BCP coordinator of the Project.
Work independently as well as in team with coordination.
Received Client appreciations for automation.
Automated Excel reports to save the time taken to create the report and also ensured the quality of the reports.
Simplified PLSQL code to save the time and also helped the team to understand the Scenario.
Conducted Excel training to the internal team.
Identified opportunities to drive data analytics solutions.
Notice Period:
60 days from day of selection.
I hereby declare that the above written particulars are true and correct to the best of my knowledge and belief.
Date: 01-Apr-17 Place: Gurgoan
(Aijaz Ahmad Hajam)
Contact this candidate