Customer Service Sql

PROFESSIONAL DETAIL

Oracle Developer with **+ years of experience in designing and building custom applications using Oracle databases and tools in Linux, UNIX and Window environments.

Extensively wrote PL/SQL, SQL programs. Designed and developed the Views, Synonyms, Functions, Procedures, Packages, Triggers and Cursors.

Created Cursors, Collections, DataType and database Triggers for maintaining complex integrity constraints and implementing the complex business rules.

Very good knowledge of SQL, PL/SQL especially writing queries with joins, sub-queries, Set Operators.

Expertise in handling errors using Exceptions with RAISE application clause.

Experience with Oracle utilities like Export/Import and data pump utilities.

Involved in all phases of SDLC (Software Development Life Cycle), from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Good experience working with various FTP and SFTP protocols.

Experience in implementing and providing solution for Retail and Utilities Domain Applications.

Managed security module by creating and granting roles and privileges to users.

Extensively worked with third party database tools like TOAD & PL/SQL Developer.

Extensive experience in Performance Tuning of SQL queries & Views using Explain Plan, Hints, Partitioning and indexing concepts.

Experience in creation of table partitioning by range, list, hash, composite methods for managing large tables

Worked on Oracle Forms 6i/10g/11g, Reports 6.0/6i/10g/11g

Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.

Understanding of Oracle Real Application Clusters and Oracle Portal.

Experience creating Interactive reports with drill-down capabilities using global and local Filters with Oracle Discoverer (groups, access/query privileges), Metadata objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling.

Experience in managing and coordinating team. Overall strength lies in precise translation of business requirements into technical documents. Ability to quickly learn and apply new technologies with strong technical background. Excellent analytical, problem solving skills and ability to follow through with projects from inception to completion.

Areas of Expertise:

Contingency Planning

Technical Specifications Development

Team and Project Leadership

Tuning Packages and Procedures

Streaming A/V (Audio / Video)

Data Warehouse concepts

SQL Optimizer, Execution Plans and Indexes (Oracle).

Software Quality Control

Managed IT Project.

Technical Proficiencies:

Databases: Oracle 9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers),NoSQL.

Reporting Tools: Oracle Report 9.x,10.x,11.x, Oracle Discoverer and Crystal Report.

Developer Tools: Toad, Pl/Sql Developer.

Platforms: Linux, OSX, Windows, Unix, iOS, Vmware, VirtualBox

Languages: SQL, PL/SQL, Linux shell scripts, C++,Assembler, Prolog, Perl, Vim, Emacs.

Utilities: Flip Factory, Sorenson Media (Squeeze), Emicsoft and Microsoft Office Suite.

PROFESSIONAL EXPERIENCE:

Hackensack UMC - Palisades, North Bergen, NJ

Volunteer, (8/2016 – present)

LKQ Corp, Kearny, NJ

Warehouse worker (11/2016 – present)

Prepare orders by processing requests and supply orders; pulling parts off shelves (both by hand and with forklift); packing boxes, preparing pallets, and preparing shipments; placing orders into delivery area and onto delivery trucks (both by hand and with a forklift)

Maintain inventory controls by collecting stock location orders and printing requests

Maintain safe and clean work environment by keeping shelves, pallet area, and workstations neat; maintaining clean shipping supply area; complying with LKQ Policy and Procedures

Completes reports by entering required information

Forklift Trained and Certified

Contributes to team effort by accomplishing related results as needed

IT Quality Solutions, North Bergen, NJ

Desktop Support Technician (3/2016 – present)

Analyze and respond to end user problems with personal computer hardware, software, applications and peripheral devices.

Document, maintain, upgrade or replace hardware and software systems.

Assist with Track IT work requests to the IT Department regarding computer hardware, software and application issues.

Research, specifically for the order of computer hardware and software replacements.

Coordinate and perform the maintenance, repair, upgrade and relocation of all office computer hardware, and peripheral devices.

Maintain inventory of computers, software and other Information Technology equipment.

Manage user account information including rights, security and systems groups in Active Directory.

Provide new employees IT training on environment and systems as needed.

Proficient in Virus and Malware protection, monitoring and remediation.

Consistently maintain high levels of customer service, ensuring problems are worked out efficiently and in a timely and appropriate manner.

Manage projects and deployments as requested.

Ecuavisa, Guayaquil, Ecuador

Freelance, (6/2015 – 6/2016)

Reengineer processes on each business core module.

Develop technical documents for programs developed and generated.

Implement audit tables and a front-end for generate reports.

Create, conduct and facilitate various workshops for developer’s team.

Metro Web Corporation, North Bergen, NJ

Bindery Operator (3/2016)

Read and evaluated work orders, and set up equipment according to project specifications.

Communicated effectively to coordinate efforts with several staff and team members.

Tracked progress of work using company specific forms and documents.

Checked machines before and after each project for possible defects.

Performed regularly scheduled maintenance checks on all equipment.

Ecuavisa, Guayaquil, Ecuador

History of Positions:

Chief, Online Technology (2012 - 2015)

Senior Software Engineer (2005 - 2012)

IT Computer Repair (2002 - 2005)

Chief, Online Technology (7/2012 – 5/2015)

Supervised implementation of methods for transcoding and video performance.

Controlled video codec’s improvements without increasing the file size for Web.

Oversaw multiple technology department budgets.

Managed staff of 6 employees daily; trained and evaluated performance level of employees to ensure optimal execution of operations.

Reviewed global proposal of providers of advertisements, streaming, OTT (Over The Top) and other web services.

Analyzed and investigated of others platforms as new options to be used on the Web.

Generated workflow to improve encoding process.

Evaluated performance of Datacenter resource to help grow the company.

Supervised activities of operation inside development and security team.

Managed best practices for departments and collaborated with the decision support system.

Supervised recovery time and integrity data over backups.

Ecuavisa, Guayaquil, Ecuador

Senior Software Engineer, (11/2005 – 6/2012)

Worked closely with users in understanding the requirements and coordinated between the users and the development team.

Analysis of customer specifications and custom design of applications successfully implementing designs in new/existing application using PL/SQL.

Developed PL/SQL-Packages, Procedures, Functions, SQL Scripts and Database Triggers to populate the historic data in the tables applying business logic, performed application SQL Tuning using SQL Trace Explain plan for optimum performance.

Involved in coding and designing of the Transaction Module using PL/SQL Procedure.

Involved in coding and designing of the PL/SQL Blocks and increased performance by passing appropriate hints.

Implemented Export/Import Oracle utilities to move data to different testing environments.

Created Records, Tables, Objects, Collections (Nested Tables and V-arrays), and Error Handling.

Wrote complex SQL scripts and was responsible for Performance tuning of SQL Queries.

Compiled, tested and debugged to implement business logic and enhance modularity, reusability and serviceability for maintenance of the application.

Responsible for performing code reviews and written Test Plans and Involved in unit testing.

Performed Back-End code migration to different environments.

Involved as a key team member for Requirement Analysis during the design phase and interaction with the client.

Involved in writing backend Packages extensively in PL/SQL.

Involved in Code Reviews and preparing Unit test cases.

Used Quest code tester for Oracle, a component of Toad used to identify and eliminate the costly bugs and functional errors and used right data model for the data mart based on the requirements.

Maintained the data integrity and security using Integrity Constraints and Triggers.

Optimized and enhanced the existing procedures and SQL statements for the better performance.

Defining and reviewing the coding standards besides reviewing the code.

Used Key files to hide certain parameters from users and added key mapping entries to a key map file.

Preparation of Checklists, identification of Test Cases and preparing Test Plans.

Actively involved in Integration and Deployment in Production Environment.

Designed and extensively worked on Project Documentation.

Co-ordination between Development, Testing and Production teams and attending bridge calls and technical discussions regarding future developments and releases.

Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.

Analyze, design, develop and execute applications based from companies requirements

Maintenance planning about core system applications and create or update documents about changes or new options.

Coordinate with external provider the information that needs to be prepared RFP (Request for proposal).

Schedule work meetings with the key users to know improvements suggested

Review and quality control of all changes made by developers.

Develop new techniques for improve speed in the database and obtain an excellent response time on the systems.

Teach the best developer techniques to coworkers.

Tuning data warehouse packages and procedures for best performance

Supervise that new programs offers high standards of quality.

Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database.

Wrote custom support modules for implementation using PL/SQL, Unix Shell Scripts.

Involved in developing and scheduling using cron jobs to load the data into the database and export/import mechanism for data migration for bulk upload

Involved in writing the database triggers to furnish the audit details

Used various LOVS (List of Values) and record groups at various points in runtime.

Created Various Form Level, Block Level and Field Level Triggers.

Developed Master Detail reports using tabular and Group above reports.

Troubleshooted performance issues and bugs within packages, forms, and reports using dbms_output, Forms debugger, Explain plan.

Analyzed, designed and developed Oracle forms 10.X,11.x queries, layout, report triggers, parameter form, data models etc.

Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.

Created indexes on the tables for faster retrieval of the data to enhance database performance.

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

Developed Unix Shell Scripts to automate backend jobs, load data into the database.

Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.

Partitioned the fact tables and materialized views to enhance the performance.

Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.

Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.

Provided Tier3 Application support with 24/7 production support

Education:

Catholic University of Santiago of Guayaquil Guayaquil, Ecuador

Bachelor of Computer Systems Engineering 6/2008

Contact this candidate