Resume

Sign in

Sr. Oracle PL/SQL Developer

Location:
Savage, Minnesota, United States
Posted:
June 12, 2018

Contact this candidate

Atul Mehta

***** ***** ***, ******, ** ***** H: 201-***-**** ac5uti@r.postjobfree.com

Professional Summary

Data Warehousing Oracle PL/SQL Developer Full Lifecycle Project Lead Unix Programmer

Experienced IT professional with proven record of designing and implementing data warehousing and application solutions.

Strong focus on clean, scalable and future proof designs. Ambitious, technology driven self-starter with ability to grasp business requirements quickly and seamlessly integrate technology initiatives.

Expert project lead with demonstrated ability to manage multiple tasks simultaneously.

Approachable team player brings direct interpersonal skills that build relationships and establish credibility quickly with members of cross-functional teams at all levels of the organization.

Ability to cultivate ongoing relationships and effectively communicate with third parties, vendors, and end users.

Forward-thinking and resourceful professional with a diligent mindset and disciplined approach.

Ready to bring 12 years of experience with Oracle to a challenging new role.

Skills

12 years of Oracle Expertise

Project Lead

Data Warehousing

Agile

PL/SQL Developer

Unix Shell Programming

Help Desk/Troubleshooting

Business Intelligence

Migration/Upgrades/Installation

Business Liaison

Solution Architect

Enterprise Warehouse Maintenance

Business Development

Technical Analysis

Python

Project Estimation and Costing

Functional Expertise in different domains

Manage Remote teams

Work History

Cognizant Technology Solutions – New Jersey, Minnesota, and Illinois

Senior Associate, 2010 to 2017

PROJECTS

Senior Oracle Developer, Cognizant Contractor Dec 2016 Jan 2017

AbbVie – North Chicago, IL

Technical Environment: Oracle PL/SQL, Unix, JDA, Windows 10

Responsibilities: The project entailed a smooth transition of the supply chain system to incorporate changes for the next year while facilitating a separate JDA component deployment.

Loaded Data into Oracle Tables using SQL Loader.

Trusted as the sole business liaison.

Mobilized the offshore delivery team and ensure the quality of all deliverables

Ensured zero disruption in the business during critical year end transition

Translated business requirements into working database solutions

Monitored and resolved SQL performance issues for multiple applications, reporting systems and dashboards

Senior Oracle Developer, Cognizant Contractor Nov 2013 Sep 2016

Optum, Medicare Secondary Payer (MSP) – Eden Prairie, MN

Technical Environment: Oracle 11g, PL/SQL, Toad, Unix shell scripting, Tivoli, Java, Windows 7, Agile

Responsibilities: A critical revenue generation project had to developed and deployed while meeting aggressive deadlines and tight SLA's.

Involved in all phases of the project right from analysis, design, development, testing, implementation and maintenance.

Collaborated closely with other teams and coordinate delivery in a timely fashion

Designed and developed a state of the art workflow-based solution.

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

Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Leveraged prior experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.

Loaded Data into Oracle Tables using SQL Loader.

Partitioned large Tables using range partition technique.

Experience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB and UTL_FILE.

Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.

Worked extensively on Ref Cursor, External Tables and Collections.

Expertise in Dynamic SQL, Collections and Exception handling.

Succeeded in SQL performance tuning using Cost-Based Optimization (CBO).

Increased knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.

Re-factored existing code using Explain Plan and HINTS.

Conducted user training and also in-house training sessions for other developers in the team.

Performed feature/cost analysis of competing technologies.

Senior Oracle Developer, Cognizant Contractor May 2010 May 2013

Avis Budget Group (ABG) – New Jersey

Technical Environment: Oracle PL/SQL, Unix shell scripting, C++

Responsibilities: Involved in end to end management of the client change requests which involves, requirement analysis, design, coding, testing and delivery of the change for the requested enhancement. Supervised a cross-skilled mid-size team to manage the enterprise data warehouse and meet all the daily SLA's. Mobilized resources for timely delivery and issue fixing in the production environment.

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

Performed additional tasks of business development.

Operated the resourcing, costing and budgeting functions for the entire team.

Spearheaded the marketing campaign for the client on the data warehouse side. Coordinated with existing vendors and third parties.

Overhauled existing processes and increased the processing capacity. Quantified the time and money savings with this remodeling.

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

Strong experience in Data warehouse concepts, ETL was acquired.

Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Excellent technical and analytical skills was demonstrated along with a clear understanding of design goals of dimension modeling for OLAP.

Experienced with working with Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.

Loaded Data into Oracle Tables using SQL Loader.

Worked extensively with Oracle Supplied Packages such as DBMS_SQL,DBMS_JOB and UTL_FILE.

Worked extensively on Ref Cursor, External Tables and Collections.

Succeeded in SQL performance tuning using Cost-Based Optimization (CBO).

Experienced in Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.

Created Shell Scripts for invoking SQL scripts and scheduled them using crontab and Tivoli.

Senior Consultant, Oct 2000 Jun 2005

Sonata Software – Chicago/New Delhi/Bangalore

Technical Environment: Oracle Financial Analyzer, Unix shell scripting, Oracle 8i

Responsibilities: Involved in end to end management of datamart projects which involves, requirement analysis, design, coding, testing and delivery of the final solution. Supervised a small team to manage the enterprise data warehouse and meet all the daily SLA's. Proposed and delivered creative solutions to challenging problems in Management Information Systems (MIS) for Fortune-100 clients.

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

Performed additional tasks of business development.

Operated the appraisal and recruiting functions for the entire team.

Successfully implemented Oracle Financial Analyzer based MIS solutions for a variety of Fortune-100 clients worldwide.

Implemented solutions for web based intra-departmental budget consolidation for a variety of clients.

Gained functional expertise on domains like Consumer-Packaged Goods, Business Process Outsourcing, and Financial services.

Automated processes for loading data from Oracle ERP solutions into MIS.

Won kudos for delivering several challenging projects.

Conducted training sessions for large user groups.

Technical Expertise

Operating Systems: Windows 9X through Windows 10, Linux Red Hat, Unix, Mac OS X.

Functional Expertise: Healthcare, Life Sciences, Retail/Travel/Hospitality (RTH), Business Process Outsourcing (BPO), Consumer Packaged Goods (CPG)

Programming: SQL, PL/SQL, Shell Scripting, Python, C, Java, LaTeX 2e, PeerSim

Microsoft Products: Office 365, SharePoint, Visio

Database: Oracle 10g/11g/12c, Oracle Express Server

Version Control: SVN, GIT

Tools: Toad, PL/SQL Developer, Rally, SQL *Plus, SQLLDR

Education

Master of Science: Computer Science, Parallel and Distributed Computer Systems, 2010

Vrije Universiteit Amsterdam - Netherlands

Bachelor of Technology (B.Tech): Computer Science, 2000

Kerala University - India



Contact this candidate