SQL Developer & Support Analyst Resume

SUMMARY:

9+ years of experience in Oracle PL/SQL, UNIX shell script, Siebel CRM, JavaScript, Control M, Confidential Service Manager and Siebel CRM.
Prime focus on Client requirements, Analysis, Design, Development, Customization, Implementation, Upgrade and Maintenance of various Business Applications in an effective manner to deliver client satisfactory software solutions.
Currently working as Techno - functional Consultant in Trade Fund Management domain for world-leading consumer goods company.
Worked in projects which were using agile methodology for software development.
ITIL certified expert in incident / change / problem management processes.

STRENGTHS:

Quick learner

Innovator

Client - facing experience

Strong Technical & Analytical Skills

Hard Working & a Good Team player

TECHNICAL SKILLS:

Oracle SQL, PL/SQL

Unix

JavaScript

Control M

Service Manager

Siebel CRM

PROFESSIONAL WORK EXPERIENCE:

Confidential

Technology: Siebel CRM, UNIX, SAP, Oracle 11g, Ctrl-M Scheduler

SQL Developer & Support Analyst

Responsibilities:

Worked on SQL*Loader to load data from flat files to holding tables obtained from various facilities every day.
Created many packages for data validation and Unix Shell Scripts for moving the customer data from staging area to data mart.
Involved in creation and updates of severalSQLpackagesand Procedures.
Created many complicated Reports to suit client requirements and updated in Reporter Genie tool.
Worked on many proactive checks and fixed the issues before market came up.
Wrote Unix Shell Scripts to validate the SODE files which are processed during weekend like, renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
Daily, Weekly and Monthly Batch jobs scheduled via Ctrl M job scheduler.
Worked on many Special projects like DMAT, RDC Intervention, FFM Data Switch, Harmonia@CE 1 box consolidation project, Coty/Galleria Divested intervention project.
Automated many of the recursive activities by writing PL/SQL Packages and UNIX scripts to reduce the manual intervention that happens during every FYE/B.
Involved in the continuous enhancements and fixing of production problems.
Also Involved in Incident / change / problem management Process. Analyzing the tickets and furnishing the solution within SLA.

Confidential

Technology: Oracle 10g

Team Member

Responsibilities:

Working on Incident Management
Analyzing on ticket and furnishing a solution

Confidential

Technology: Oracle 9i, Open VMS, UNIX, Forms & Reports 6i

Team Member (SME)

Responsibilities:

Involved in identification of data issues in Application databases.
Involved in finding out the root cause and solving issues in case of any Batch job failure.
Writing scripts in Open VMS.
Working on regular basis tickets and CRs.
Involved in migration of batch job and database server.
Involved in documenting the issues faced and solution provided in Application Documents.
Involved in new Batch job creation, testing and uploading in production.
Created reports like Report Failure and did validation.

Confidential

Technology: Oracle 11g, JavaScript, ECP 5.5

Developer

Responsibilities:

Developed forms by using ECP Platform, JavaScript and HTML.
Developed back-end Packages, Procedures, Functions and Triggers.
Developed SQL loader scripts to load the inbound files to temp tables.
Developed procedures to validate the data in the temp tables and sync the master tables.
Tuning the SQL Queries to get the better performance for the application.
Developed drilldown dashboards and complex reports.
Developed PDF reports using Open Office.
Generated Emails and involved in Unit Testing
Involved in developing Technical Documents and Release Notes.
Applied Patches in client server and created Certification.

Confidential

Technology: Oracle 10g, JavaScript, ECP 5.5

Developer

Responsibilities:

Developed forms by using ECP Platform, JavaScript and HTML.
Developed back-end Packages, Procedures, Functions and Triggers.

Confidential

Technology: Oracle 10g, JavaScript, ECP 5.55

Developer

Responsibilities:

Developed forms by using ECP Platform, JavaScript and HTML.
Developed back-end Packages, Procedures, Functions and Triggers.
Developed drilldown dashboards and complex reports.
Developed PDF reports using Open Office.
Generated Emails.
Involved in Unit Testing.
Involved in developing Technical Documents and Release Notes.

Confidential

Technology: Oracle 10g, JavaScript, ECP 5.55

Developer

Responsibilities:

Developed forms by using ECP Platform, JavaScript and HTML.
Developed drilldown dashboards and complex reports.
Generated Emails.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship