Sr. Oracle PL/SQL Developer
Resume:
Atul Mehta
***** ***** ***, ******, ** ***** H: 201-***-**** ****.******@*****.***
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