SUMMARY

• Highly Accomplished IT Leader who expertly drives high - level systems, projects, and programs through to successful completion, and who makes sound decisions to align with a company’s mission.
• Hands-On Self-Starter who offers 9+ years of development experience within an Oracle environment with 8+ years of PL / SQL experience, and who exhibits talent in strategic planning, business modal analysis, and process design, as well as project lifecycle management in highly structured change management scenarios using proprietary methodologies and Agile techniques .
• Out-of-the-Box Thinker who continually leverages new technology and 18+ years of know-how to manage diverse projects, and who maintains cutting-edge technological skills while gaining buy-in among teams to attain incredible results.
• Influential Strategist who unfailingly sees the “big picture” at times while thriving in rapidly evolving workplaces to exceed core project expectations - always willing to “go the extra mile” to surpass the status quo.

TECHNICAL SKILLS

• Software: GIT SoapUI Tableau 9.0 SharePoint Informatica Powercenter HP ALM Confluence JDA RedPrairie WMS | JIRA | GIT |Oracle ERP | Oracle Forms/Reports 11g Microsoft Power BI | Crystal Reports | Microsoft Dynamics 365 | Experlogic | REST API
• Relational Database Management System (RDBMS): Oracle 9i / 10g / 11g / 12c | Microsoft Access 2000 / 2002 / 2007 / 2010 MySQL SQL Server |SSIS | SSRS |T - SQL|
• Operating Systems: Windows 98 / 2000 / XP / NT UNIX (SunOS 5.7 / Solaris 8 / HP-UX) Red Hat Linux | UNIX
• Languages: Perl Oracle PL / SQL 12c/ 11g / 10g / 9i UNIX K-Bash Shell Scripting XML Visual Basic SAS SQL (ANSI / Oracle) HTML5 CSS Java Script | JavaScript frameworks
• Networks: TCP / IP
• Tools: SQL Developer Toad Rapidus Business Objects Microsoft Publisher | Quest SQL Navigator Microsoft Office (Word, Excel, PowerPoint, Access, Outlook) Microsoft Project

PROFESSIONAL EXPERIENCE

Confidential, Austell, GA

Sr. Data Analyst

Responsibilities:

• Created and maintain rich interactive visualizations through data interpretation and analysis integrating various reporting components from multiple data sources.
• Assisted internal users with processes, data corrections and troubleshooting.
• Assist internal users with processes, data corrections and troubleshooting.
• Tuned reports by tuning complex SQL views/joins and TSQL .
• Created BI reports using several reporting tools (Power BI, Crystal Reports, SSRS) to analyze data to answer key questions from stakeholders while investigating and communicating areas for improvement in efficiency and productivity.

Confidential, St. Louis, MO

Oracle Data Architect - Dev / Ops

Responsibilities:

• Capitalize on the opportunity to lead the forward-thinking decommissioning of reporting database and applications, including assisting in the development of team-centric work plans, as well as monitoring and updating team work plans.
• Create test plans and scripts and support users in conducting tests for new development. Accurately maintain design documents, technical documents, user guides, and training manuals.
• Design, code, and implement software applications using PL / SQL procedures, functions, and packages on Linux and UNIX platforms.
• Designed, developed, automated, and support complex applications to extract, transform, and load data into Data Warehouses and Datamarts.
• Successfully led project to convert batch processing jobs to Attunity.
• Develops logical and physical data flow models for ETL applications.
• Served as designated lead to implement new department-wide database applications.
• Showed excellent debugging skills by working with Dev/ops teams to monitor systems during and after work hours.
• Implemented solution design by providing direction and feedback during technical design and development.
• Worked with reporting teams to tune complex Oracle sql views/joins Toad, SQL Developer, SSMS and SQL Navigator.
• Assumed ownership of the integrity and quality of data across the team’s multiple databases.

Confidential

Senior Database Developer (PL/SQL) - Dev / Ops

Responsibilities:

• Trained, coached, and mentored team members to boost productivity.
• Supported SOA web service testing / troubleshooting using SoapUI application.
• Tuned high-level SQL queries for improved Database and application performance.
• Streamlined front-end Javascript application’s delivery to rapidly disseminate data to end-users.
• Performed root cause analysis on master data for production related projects.
• Design, Develop and Test ETL Mappings, Mapplets, Workflows, Worklets using Informatica Powercenter 9.x.
• Continually participated in responsive, 24-hour on-call support on a monthly rotational basis.
• Assisted with user acceptance testing and defect tracking for several new software releases.
• Designed and built new archive systems to manage and maintain a large database table space.
• Used table partitioning when dropping table LOBs, so that extent can be reused by the database.

Confidential, Little Rock, AR

Database Developer - Oracle PL / SQL / Oracle Forms

Responsibilities:

• Leveraged broad scope of industry knowledge toward expertly developing SQL queries, PL / SQL programs, Oracle Reports, and UNIX shell scripts per client requirements.
• Coordinated review meetings with stakeholders and consultants to create business requirement documents.
• Reviewed and modified / corrected functional requirement documents and detail design documents.
• U pdated front-end and back-end code changes to an interface between custom applications and TrakrEA accounting application.
• Delivered real-time support, administration, and maintenance for systems using Oracle Forms, Oracle Reports, SQL*Plus, ASP.NET, and PL / SQL.
• Generated SQL and PL / SQL scripts to install, create, alter, and drop multiple database objectives, including tables, views, primary keys, indexes, constraints, packages, sequences, grants, and synonyms for a unit-wide server migration.

Confidential

Database Developer - Oracle PL / SQL / Oracle Forms and Reports

Responsibilities:

• Created test plans and test case templates for testing an entire application.
• Designed Oracle Reports 10g/9i/6i for complex projects.
• Assisted in designing and implementation of extension to ERP systems on basis of outline specifications.
• Develops logical and physical data flow models for ETL applications.
• Modified Packages, Procedures, Functions and Triggers for designing user interface.
• Troubleshot performance issues and bugs within packages, Oracle forms, and reports.
• Developed diverse use cases, workflow, screen mock-ups, and conversion requirements.
• Coded and implemented PL / SQL procedures, functions, and packages for custom applications.

Confidential, North Little Rock, AR

Programmer System Analyst

Responsibilities:

• Spearheaded gathering, interpretation, and documentation of user requirements for accurate translation into business language.
• Maximized the use of resources to achieve goals by planning and prioritizing workflow.
• Developed plans, project documentation, and test cases.
• Demonstrated experience with 20+ Red Prairie Modules and provided frontline support of all Red Prairie WMS and third-party applications.
• Coordinated and managed application development of Oracle forms and reports.
• Gathered requirements, created design documentation, wrote programming code, and designed solutions-focused test cases for new software implementations.
• Designed, developed, and managed warehouse performance and metrics.
• Displayed Expert skill modifying and creating complex (non base table) forms and complex Oracle Forms/Reports.
• Assisted in development and maintenance of Oracle applications, HRMS and Oracle Procurement.
• Modified existing Oracle PL/SQL database packages, adhering to business requirements.
• Consistently optimized operational efficiencies and customer compliance initiatives.
• Hand-selected to lead systems analysis, design, and implementation of new eCommerce customers.
• Created training materials, sessions, discussions, and planning efforts for Timex Repair & Service Center.
• Coded and implemented PL / SQL procedures, functions, and packages for custom applications.

Confidential, Little Rock, AR

Business (Client) Delivery Analyst

Responsibilities:

• Proactively advised client of potential process improvements and optimal data use.
• Exhibited skill in the use of SAS, SQL, and Auditor to validate data based on requirements.
• Seamlessly managed encryption processes for incoming and outgoing files with sensitive data.
• Documented and / or made appropriate code changes in Focal, Quickjob, and DataStage, among others.

Confidential

Data Analyst

Responsibilities:

• Played a vital role in support and consultation of complex data, analysis, and interpretation for team and clients.
• Performed comprehensive audits to ensure conformance with procedures, project requirements, and detailed SLAs.
• Successfully performed testing of data files before files reached production.