Developer Oracle
Resume:
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 *************@*****.***
Sincerely,
Aman Aulakh
Oracle Database Professional
Aman Aulakh
67 Turnvale Road, Toronto, M9V 1L9, ON
416-***-**** *************@*****.***
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