Oracle Pl/sql Developer Resume
4.00/5 (Submit Your Rating)
Nashville, TN
SUMMARY
- Oracle PL/SQL Developer with 7+ years of experience woking in Manufacturing, Banking as well as Health Care Industry.
- Had successfully completed 1 - year Executive MBA from University of Virginia ( batch).
- Proven ability to identify problem, analyze possible solutions and determine best course of action to meet objectives. Strong technical background with solid project experience in PL/SQL, ORACLE 10g/11g/12c and Unix shell scripting.
- Experience includes development and production support of large and critical database tools along with End-to-End solution providing to end customers.
- An effective communicator with excellent relationship building & interpersonal skills. Strong analytical, problem solving & organizational abilities. Possess a flexible & solution-oriented attitude.
- Received many project specific rewards for timely delivery of development/support and contribution to project specific activities with 98% customer satisfaction for active resolution.
- Experience working on BI reporting tools like SAP BOBJ and MicroStrategy for analytical reporting.
- Currently working with country’s largest healthcare provider and development team uses agile framework following Scrum.
- Hands on experience in developing advanced oracle functionalities Oracle Java stored procedures, user defined Aggregate functions and Analytical functions, Oracle XML Processing, Ad-hoc Queries, EXPLAIN PLAN, DBMS PROFILE, TKROF functionalities.
TECHNICAL SKILLS
Databases: Oracle 9i,10g and 11g, 12c
Programming Scripting Languages: SQL, PL/SQL, Unix, Java Script
Query Tools: SQL-Developer, TOAD, SQL* PLUS
Operating Systems: Windows XP,7, Server 2008,2010 UNIX
Reporting Tool: Microstrategy, SAP BOBJ(Crystal, WebI)
ETL Tools: Informatica, SQL Loader
Job Scheduling Tool: Control-M
PROFESSIONAL EXPERIENCE
Confidential, Nashville, TN
Oracle PL/SQL DeveloperResponsibilities:
- Currently working on providing solution of Contract Modeling between providers and payers by automation on contracts data flow which includes creating Modelling schemes/Rate Schedule, milestone, workflow and calc engine tasks.
- Worked on Enterprise key projects to expand their Unique key ID’s to 25 digits while upgrading to Oracle 12c so that we can maintain uniqueness of records between all data centers in future.
- Created packages for implementing solution to calculate Mon Contractual Adjustments for patient’s services in the facilities.
- Worked on Group stack project to simplify the data loading in RPOP project and get performance improvements.
- Fine Tuned the SQLs using Oracle Hints, explain plan and Trace sessions for Cost based optimization.
- Experienced in working with SQL*Loader, External Tables, Import, Export to extract and load large volumes of data.
- Extensively involved in Performance tuning in Oracle using Explain plan, SQL Trace.
- Played good role in Oracle Database Tuning by building indexes (Binary/Bit Map) on the tables for faster retrieval of the data to enhance database performance.
- Used Microsoft TFS environment and team city for code check-in different environments and maintain the versatility of the code among global team.
- Worked closely with data modelers for Partitioning high-volume table when data volume goes high for any table and thereby making performance.
- Used DBMS DataPumps API for data extraction for the entire Data center and helping in data migration when acquisitions took place.
- Utilized advanced features of Oracle 12c like Deterministic function, Identity, Session Sequences, Pipelined Table functions, Ref Cursors, Collections for performance improvement.
- Use of Invisible columns for high data sensitive columns pertaining to Patient’s personal data and their accounting information.
- Gained experience working on Explain Plan, DBMS Profiler while working on tuning the PL/ SQL blocks.
- Implemented solution for proper logging of messages there by ensuring data loads are flowing smoothly for inbound/outbound jobs.
- Modified SQL’s to use Bulk Collections and FORALL for better performance during data loads.
Confidential, Jersey City, NJ
Oracle PL/SQL DeveloperResponsibilities:
- Worked in Treasury team and SWIFT messaging team for handling/maintaining database solutions.
- Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
- Created Materialized Views, tables, complex SQL queries, and Correlated sub queries, Nested Queries, Views and Function Based Indexes for effective Business Application Development.
- Maintained KEDB for known issue so that users can themselves look and resolve the issue for known errors and thereby resulting in lowering the ticket count.
- Used Explain Plan, DBMS Profiler for tuning the PL/ SQL blocks.
- Created alerts by using trigger to implement Data Threshold load alerts.
- Coordinated with DBA’s in improvement of Performance of Database.
- Fine Tuned the SQLs using Oracle Hints, Explain plan and Trace sessions for Cost based optimization.
- Customized and optimized reports for various users using Microstrategy features like VLDB properties at Project level and report level.
- Worked with end users along with Business Analysts to build reports and dynamic dashboards.
- Initiate system analysis, lead the definition of user requirements and assesses impacts. Determine alternate solutions with risk analysis and identify opportunities to use technology to improve availability and advance business initiatives.
- Provide technical analysis and solutions to issues Checking Master and referential data feeds from different inbound systems.
Confidential, SanJose, CA
Oracle PL/SQL DeveloperResponsibilities:
- Data mining for extracting historical revenue, master as well as transactional data for loading into Oracle ERP from BDR.
- Created data extracts and report from oracle to compare data loads and comparing results between SAP and Oracle reports.
- Developed PL/SQL package for business to highlight the delay in deliveries and help in optimizing the shipment based on pull in and pull out dates for CMAD and RDD.
- Testing of data flow from CRM/ECC (front end) to downstream systems till report level.
- Created Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph Reports by using chart expert of Crystal Reports.
- Developed and streamlined new interfaces to cater Scheduling agreements (Forecast) by embedding business rules in PL/SQL packages.
- Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
- Worked on complex hierarchal queries in Oracle and using Oracle Parsers for downloading BOM of products from Oracle agile into Oracle Database through AXML files.
- Automated Daily manual tasks by UNIX scripting with no manual intervention for triggering crystal reports using events feature of BOBJ.
- Working on Complex SQL, Hierarchal Queries, XML Parsers and creating cursors, materialized views.
- Streamlined Forecast process so that scheduling agreements can be maintained and tracked.
- Performing ETL Process as part of Month end and Quarterly Activities and generating revenue pivots giving slice and dice flexibility to view data by pivoting data on required parameters.
- Extending the existing process for cost association based on unique IDV, Package and leads to Part Numbers to calculate correct Margins by embedding logic in Procedures.
- Developed PL/SQL package for business to highlight the Delay in deliveries and help in optimizing the shipment based on pull in and pull out dates for CMAD and RDD.
- Testing of data flow from CRM/ECC (front end) to downstream systems till report level.
- Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
- Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
- Used XML file part of Source AXML files for loading AXML files from Oracle Agile system released as part of ECO or ATO’s in to Datamart Oracle Database.
- Created PL/SQL stored procedures, functions and packages for moving the data from stage table to data mart.
Confidential
Responsibilities:
- Exported reports per End Users request to Excel/PDF and formatted as specified with crystal accuracy.
- Handled complete administration of Microstrategy User Creation, Security Privileges, Reports scheduling and creating triggers and Events for refreshing Intelligent Cubes.
- Performing ETL Process as part of Month end and Quarterly Activities by loading the Adjustments shared by finance team after close and generating revenue pivots.
- Implemented Star schema in Business Data Repository for developing reports in Microstrategy.
- Developing complex Unix Scripts to automate daily process like downloading files, ETL data loading. Scheduling of jobs using Cron/Windows scheduler.
- Working on Complex SQL queries and creating cursor, materialized views.
- Created parameterized MicroStrategy document, dashboards and dynamic crystal reports.
- Automated Daily manual tasks by UNIX scripting with no manual intervention.
- Automated several reporting audits to route audit of Oracle data loads to mail thereby minimizing manual monitoring of production support data loads.
- Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
- Supported Travelling Expense system DB and World-Wide HR Database for Confidential Inc.
- Experience on Complex SQL, Hierarchal Queries, XML Parsers and creating cursors, materialized views.
