September **th, ****

Dear Sir/ Madam,

Subject: Application for the position of a Database Developer.

Please accept the attached resume for the position of a Database Developer within your esteem organization. I am very interested in this position and believe that the combination of my Analytical, Requirement Gathering, Gap Analysis, and Documentation, Oracle ERP [Forms/Reports/Database] Development skill, Linux /UNIX Shell Scripting, UAT and Strong IT education would serve your team well in this position.

Along with my Bachelor’s degree in Computer Science and Engineering I have Postgrad in IT Solutions Database Development (Oracle, SQL Server 2012). The key strengths that I possess for success in this position include:

Strong process modelling using UML (Use Cases, Sequence Diagrams, Activity Diagrams etc.)

Expertise in requirements gathering, Gap analysis and documentation during all phases of software development Life cycle SDLC.

Strong Expertise of Oracle ERP Development using Oracle 10g Forms, Reports, PL/SQL, and Database Development, OBIEE and 2+ years of Strong SQL, PL/SQL Experience and functions of OOPS methodology.

Excellent Hands on experience and knowledge of SQL, PL/SQL, ETL, SQL*Loader, Oracle Discoverer, Oracle Forms Oracle Reports /BI Publisher and large volume data processing in a time critical window.

Good Functional and technical experience of Various ERP Modules e.g.: Inventory, AR, Order Management.

Fluent in a broad range of technologies including business process tools such as MS Project, Excel, PowerPoint, Access and Visio.

Strong interpersonal and communication skills along with Excellent Analytical, Problem Solving, Time and Team Management Skills, Strong leadership qualities and ability to Work on Multiple Tasks and fast paced Environment with proven experience in utilizing people and process knowledge to assist making critical enterprise level decision.

I trust you would find me to be well spoken, energetic, confident, and personable, the type of person on whom your team can rely. As detailed in my resume, I have a wide breadth of experience of the type that gives you the versatility to place me in a number of contexts with confidence that the level of excellence you expect will be met.

I hope that you will find my experience, skills, and education intriguing enough to warrant a face-to-face meeting, as I am confident that I could provide value to you and your organization as a member of this team.

I greatly appreciate you taking the time to review my credentials and experience and look forward to meeting with you to further discuss my suitability for the position. I can be contacted at 416-***-**** or acwrua@r.postjobfree.com

Sincerely,

Aman Aulakh

Oracle Database Professional

Aman Aulakh

67 Turnvale Road, Toronto, M9V 1L9, ON

416-***-**** acwrua@r.postjobfree.com

PROFESSIONAL SUMMARY

3+ years of Expertise in Oracle ERP Development using Oracle 10g Web Forms & Reports, PL/SQL and Database Development, OBIEE, Data Warehouse, SQL *PLUS, SQL*LOADER and functions of OOPS methodology

Bachelor’s degree in Computer Science and Engineering and Postgrad in IT Solutions Database Development (Oracle 11g & SQL Server 2012) from Humber College

Good Functional and technical experience of ERP systems i.e. PO, INV, OM, AR in Manufacturing Organizations

Extensively worked on Oracle database to process (import / export data) flat files i.e. .txt, .csv, .xml files using various inbuilt Oracle tools

Extensive experience in Requirements Gathering, Gap Analysis, Documentation and Presentation during all phases of software development cycle, SDLC as an Agile Practitioner

Experience in Database auditing, Restore and Recovery, Managing Performance by SQL Tuning, Data Migration, Granting/Revoking sysdba privileges

Strong interpersonal and communication skills, Excellent Problem Solving, Time and Team Management Skills, Strong Leadership Qualities and Ability to Work on Multiple Tasks and Fast Paced Environment

Seeking a role of a Database Developer

TECHNICAL SKILLS

Databases

& Database Tools

ORACLE11g/10g, SQL, PL/SQL (Stored Procedures, Functions, Views, Cursors, Triggers), SQL Developer, Oracle Forms, Fusion Middleware / Web Logic 10.3.3, OBIEE, RMAN, OEM 11g, SQL *Plus

MySQL, PostgreSQL

SQL Server 2012(T-SQL)

Data Warehousing OWB, AWM (ETL, STAR/SNOWFLAKE SCHEMA, Dimensions, partitioning, SQL Loader/ SQL*LDR, Materialized Views)

Operating System

Oracle Linux, Red Hat Linux RHEL 5.4, UNIX, Windows 98/ XP/ Vista/7

VMWare Workstation 9.0.2, Oracle VM Virtual Box

Report Tools

Oracle AWR, Oracle Business Intelligence(OBIEE)

SQL Plus Reports

Scripting & Programming Languages

Shell Scripting (LINUX/UNIX/DBMS Scheduler), JavaScript, JQuery

HTML, CSS, CSS3, HTML5, XML, DHTML, Apache Server

C/C++, Java

Data Processing Tools

MS Office Tools (Word, Excel, Outlook, PowerPoint)

Project Management Tools

Microsoft Project 2012, MS Visio 2013

EMPLOYMENT EXPERIENCE

Database Developer June 2015 – July 2016

KC Group London Free Lance

One of the most conspicuous organizations in the field of door sets solutions in Europe

Project: ERP Development for AR Invoices

Job Description:

Created database for order management and custom invoice Application using Oracle 11g.

Monitored, optimized and allocated physical data storage for database systems

Experience in tuning and troubleshooting Triggers, Views, Functions, SQL queries, Cursors and Stored Procedures Designed & Developed ERP application using Oracle 10g Forms

Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions in Oracle 11g

Developed Master Detail, Detail reports using tabular and Group above reports

Developed PL/SQL triggers and master tables for automatic creation of primary keys

Transformed complex business rules to Oracle PL/SQL

Extensively Used Bulk Collections in Database Cursors for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines

Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables

Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error and warning messages in the application and Stored Procedures

Coordinated and assisted with the Front-End Developers in detecting the bugs and solving the same

Experience of installation, configuration and Implementation of Oracle Business Intelligence Suite

Oracle BI dashboard`s and reports for various functional groups within the organization

Worked on Business Intelligence platforms for transition back and forth from E/R modeling to a fact-dimension model with ease

Business Intelligence: Building Analytical Workspace, Oracle OLAP, Building Analytical Reports, Dimensional design, Business Intelligence Presentation Services

Dynamic settings for parallelism, load balancing, Extraction, subject areas, execution plans, Full & Incremental Load and query performance using Data Warehouse Administration Console (DAC)

Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure

Data Warehouse: Designing, Dimensional Model creation, Partitioning, Tuning, ETL tasks, creating Materialized view, Cubes

Database Developer / Web Developer September 2015 – June 2016

Space Ventures Free Lance

Space ventures is a young dynamic company with dedicated focus on international education outreach programs

Project: Redesigned the existing website

Job Description:

Developed and modified schema objects, triggers, packages, complex functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs

Developed stored procedures, triggers for lowering traffic between servers & clients

Created database objects like tables, views, materialized views, procedures and packages

Strong Experience in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors

Proactively analyzed and improved other software coded using HTML, CSS and JavaScript

Used MS Project to Track Project status and Visio for UML and Class diagrams FTO document Business Requirements

Managed database and website content using MySQL, HTML, CSS and JavaScript

Conducted unit testing and helped resolve issues and enabled bug fixes by development team

Effectively communicated with client to ensure all technical request and requirements were handled

Oracle BI dashboards and reports for various functional groups within the organization

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table space

In-depth knowledge and experience of RPD (Oracle BI Server and BI repository)

Strong Hands-on Experience on DW, ETL, OLAP, Presentation Layer Design and Implementation

Database Developer August 2013 – August 2014

Codezyn – Database Developer Full Time

Web agency that helps companies to build online presence by providing fit to custom solutions

Project: Developed database solutions tailored to meet clients need

Job Description:

Created database design and objects i.e. Tables, Indexes, View, Procedures, Triggers, Functions, Cursors, Sequences and Dynamic SQL

Wrote Oracle Technical Documentation and Drafts for user assistance

Worked on PL/SQL cartridge for an application logic stored in databases as stored procedures

Created Shell Scripts and Unix Cron jobs/DBMS Scheduler for scheduling file pre-processing as per requirement, maintained the existing scripts and administrated the Cron entries

Checked DB server and instances health on a weekly basis

Used Bulk Collections in Database Cursors for better performance and easy retrieval of data

Tuning of SQL Queries, Procedures, Functions and Packages to improve database performance

Performed unit testing to find out bugs and helped development team to resolve bugs

Implemented, documented and enforced QA checklists and test scripts

Test case/data preparation, execution and verification of the test results

Wrote Oracle Technical Documentation and Drafts for user assistance

Worked on Business Intelligence platforms for transition back and forth from E/R modeling to a fact-dimension model with ease

Oracle BI dashboards and reports for various functional groups within the organization.

Strong Experience of OLAP design principles and dimensional modeling.

Business Intelligence: Building Analytical Workspace, Oracle OLAP, Building Analytical Reports, Dimensional design, Business Intelligence Presentation Services

Developed Oracle database platforms and Data warehouse design

Application Developer / Trainee January 2013 – June 2013

Viable Technical Solutions, Chandigarh, India Full Time

Project: E-Cops

Job Description:

Tools: Dreamweaver, Microsoft SQL Server 2008 Management Studio Express

The project involved Online Application for state level police records where they can register, search and track status

Developed a client interface web application using HTML, CSS, JSP, J2EE and SQL Server 2008 as backend

Intern /Trainee June 2011 – July 2011

Hi TecPoint Technologies Pvt. Ltd. Full Time

Job Description:

Tools: VM Ware to run multiple Linux systems on a single machine (partial virtualization)

Configuration and testing of DNS, DHCP, Apache HTTP server in Linux OS

EDUCATION

Post-Graduation in IT Solutions – Database Development September 2014 – May 2016

Humber Institute of Technology and Advanced Learning, Canada Full Time

Successfully completed Capstone Project on ERP system using Oracle 10g forms, Oracle 10g Reports, Oracle 11g database and PL/SQL for Merry Tunes Inc.

Bachelors of Technology - Computer Science & Engineering August 2009 – June 2013

Punjab Technical University, India Full Time

REFERENCES AVAILABLE ON REQUEST

Contact this candidate