Pl Sql Developer
Resume:
Laura Britt
Charlotte, NC 28262
803-***-**** (C
adykta@r.postjobfree.com
LinkedIn: www.linkedin.com/in/laura-britt-4aa63b6
Professional Summary
•PL/SQL professional with over 10 years’ experience and a proven ability to implement projects and reports of various size and scope.
•Particularly successful in using Mathematics to bring insight to complex data sets.
Professional Experience
Infosys Limited July 2021 – Apr. 2023
Create Tables and views
Create complex PL/SQL packages
Write complex SQL queries
Generate PeopleSoft reports
Close tickets in ServiceNow
Monitor jobs in IBM Workload Scheduler
Took course on AWS
Wells Fargo Mar.2020 – May 2020
Web Developer 6
•Resolved payment application issues using Splunk, SQL Developer, and Unix shell scripts
•Researched application problems displayed in both Unix and Linux
•SQL Performance Tuning as needed
•Explored Issues in Autosys batch scheduler, IBM MQ messaging backbone, and MongoDB
Ally Financial Nov. 2019 – Jan. 2020
Oracle Developer
•Responsible for SQL and PL/SQL programming in Oracle Apex.
•This includes creating PL/SQL Packages, Procedures, Functions, Triggers, Views and Exception handling for retrieving, manipulating, checking, and migrating complex data sets in Oracle.
•Worked with Oracle Supplied Packages, Dynamic SQL, Records and PL/SQL tables.
•SQL Performance Tuning as needed
•Collaboration with Oracle Support to provide solutions as functional and technical bugs are encountered.
•Knowledge of all phases of software development including design, coding, testing, debugging, implementation, and support
•Experience writing and reviewing software design specifications in an object-oriented development environment
•SQL and PLSQL performance tuning for Oracle 19c on Exadata.
Konica Minolta Heathcare Americas, Garner, NC May 2016- Dec. 2017
Heathcare IT Customer Support
•Facilitate backing up medical images to cloud storage.
•Installed and troubleshot cloud-based backups for various medical devices running against MS SQL Server 2008-2016.
•Performed complex calculations to determine the best backup solutions.
Fayetteville Public Works Commission, Fayetteville, NC Feb. 2015 – July 2015
Business Analyst
•Updated WDSL and xsl file for SOAP web service server change.
•Tune 3rd party SQL reports. Created PL/SQL reports from various sources.
•Discovered 5 out of the box processes for cleaning up staging tables which allows the application to run faster.
•Added exception handling to a PL/SQL procedure which gets rid of the “all or nothing” mentality, allowing those that can be processed be processed and logging the reason why those that can’t. This reduces 20+ man hours per run trying to figure out which account won’t process and eliminates the guesswork involved in discovering why the process aborted.
•Created Perl scripts to automate meter exchanges.
•Converting Oracle CC&B, Oracle MDM, and Oracle MWM scheduled processes to the CA Scheduler.
•Analyze data and data sources for BI.
American Kennel Club, Raleigh, NC 2012 - 2015
Software Engineer
•Modify and maintain production PL/SQL code. Troubleshoot dog registration issues. Convert legacy code.
•Troubleshoot production problems with dog registrations by researching Oracle packages and Java code resulting in the creation of a new package of common prodfix procedures along with complete documentation detailing each problem, where it occurs in the source code and what should be done to fix the problem.
•Modified the customer merge process using dynamic SQL to save all the DML statements to a clob so that a complete unmerge could be accomplished. Created the procedure to run and execute the statements contained in those clobs.
•Converted COBOL programs to a combination of PL/SQL, Perl and Unix shell scripts. One of these jobs entailed creating the necessary tables and modified versions of both the PL/SQL and Perl in my own schema and working to ensure the job ran in the correct order in Autosys so it could run effectively in parallel with the production COBOL process.
•Tuned various packages for performance, taking out old rule-based hints and adding index-based hints as needed.
•Created a new printable microchip chip type using Oracle compound triggers and ensuring the trigger did not mutate.
•Discovered stuck/broken dog and litter registrations. Created a new Oracle PL/SQL process to find and fix broken or stuck registrations, resulting in 350 new registrations.
•Used Jira in an agile, Kanban, environment and SVN for source code
•Performed unit and integration testing
•SQL and PLSQL performance tuning for Oracle 12c.
•Extensive experience high-performance PL/SQL code development and SQL performance tuning.
•Strong skills in ETL development and Data Warehousing.
IBM, Research Triangle Park, NC 2011 - 2012
System Admin./PL SQL Developer
•Create and troubleshoot reports. Validate billing information. Act as system administrator.
•Create and troubleshoot reports from Oracle, Postgres, Sybase and DB2 databases. Schedule reports via crontab.
•Trouble shoot the DPA reporting tool for performance, by manipulating the underlying Sybase database using Oracle SQL Developer and maintaining the DNS files located on various Linux/Unix boxes around the globe.
•Validate billing information contained in an Oracle database
•Designed, developed, and tested various PL/SQL programs for Oracle12c.
Quintiles, Durham, NC 2011 - 2011
Pricing Systems Analyst II
•Convert legacy pricing and reporting system to Oracle Apex.
•Created a system for producing a report for client companies using Dynamic SQL in PL\SQL and Python. Created a master report of all things ApEx from log files and database objects. Created several new ApEx reports.
•Update and improve several ApEx pages using ApEx items and JavaScript on tabular forms.
•Model and create Oracle database for Phase 3 drug trials using TOAD
MAK Solutions, Irmo, SC 2007 - 2011
Senior Programmer Analyst
•Maintain and update Banner CIS systems for utility companies around the US.
•Work with clients as both a technical and functional resource to design and develop software enhancements based on business requirements, create stored procedures, triggers, complex queries.
•Created and updated several interfaces to various 3rd party vendors using PL\SQL and Dynamic SQL.
•Created and updated several PL\SQL reports and forms, while optimizing for performance.
•Automated data conversion/clean-up scripts
•Updated various database processes using Pro*C
PNM Resources – Albuquerque, NM 2000 – 2007
Sr. Programmer/Analyst
Developed new web services used in conjunction with the new E bill system.
Maintain and administer the LDAP systems
Maintain current E business application
Migrate E business application to Weblogic 10
Responsible for testing new LDAP servers
Responsible for farming data from the LDAP
Provide production support on an ongoing basis.
Developed and maintain the stored packages used in the View My Bill web application.
Developed the PL\SQL packages for Budget Billing and Meter Reading in use with the IVR and E business Systems using Dynamic SQL and Pro*C
Developed the documentation for PL\SQL packages contained in the IVR and E Business library.
Tested all IVR and E business PL\SQL packages for conversion from Oracle 8i to Oracle 9i and fixed problems when they occurred
Converted manual refund process to an automated system so that developers time is not taken running scripts in production environment.
Working with the Credit Department Head, designed and developed a process for diverting refunds to pay bad debt until either the bad debt or the refund was exhausted. This saved the company $20000 the first time it ran.
Education
Master of Science in Applied Mathematics
North Carolina State University, Raleigh, NC
Bachelor of Science in Mathematics
North Carolina State University, Raleigh
Certifications
A+, Project+, CIW Data Analyst
Contact this candidate