| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateChagrin Falls, OH 44023
PHONE NUMBER AVAILABLE (HOME) EMAIL AVAILABLE
________________________________________
SUMMARY OF QUALIFICATIONS
Sr. Software Engineer with 20+ years of Fortune 500 Company professional experience in full life cycle application/system development including architectural design, project leadership, agile methodology, requirement creation/analysis, technical approach, proof of concept, prototype, coding, testing, troubleshooting, documentation, CI/CD, and product support.
Deep Expertise in Oracle and SQL Server database design, programming, performance tuning, reporting and administration. Oracle Database 19c Administrator Certified Professional, Oracle Database 12c/11g Administrator Certified Professional, Oracle Database 11g Performance Tuning Certified Expert, Microsoft Certified Professional (MCP) in SQL Server administration.
Extensive experience in object-oriented programming in Java including Spring Boot REST web service, microservices, Java API. Oracle Certified Professional - Java SE 8 Programmer, Sun Certified Java Programmer, Siebel 7.7 Certified Consultant.
A vital role in designing and implementing complex data-intensive enterprise application, enterprise billing system conversion, systems consolidation, migration and integration, data encryption, revenue share/invoice/payment creation, reporting, and automatic streamline process.
Hands-on experience in project planning, estimation, sizing, and prioritizing in Agile scrum, Azure DevOps, Jira and Confluence. Actively mentored software engineers.
TECHNICAL EXPERTISE
Oracle database architectural design, data integration, Oracle 19c/12c/11G DBA, AQ, Golden Gate replication, and Data Modeling (MagicDraw, SQL developer Modeling, ER with Visio), RAC, RMAN, ASM, OEM, Oracle Reports, MongoDB, IBM MQ
Oracle SQL, PL/SQL, SQL*Loader, SQL*Plus, Toad for Oracle, SQL Developer, DB Visualizer, WebLogic admin, MySQL, PostgreSQL, Crystal Reports, NoSQL
SQL Server, SSIS, SSRS, T-SQL, .NET Framework, Visual Studio, C#, Visual Basic, ETL tools, Python, Star Schema, Snowflake schema, SSMS, Azure Data Studio, Rest Web Service, Terraform, Power BI, Tableau
Java/JEE/J2EE, Java Spring Boot, Microservices, API, JSP, WebSphere, MVC, Eclipse, Kafka, Maven, JDeveloper, BPM, JSON, XML, JavaScript, C/C++, BMC Remedy ITSM
Windows Server, Azure DevOps, Linux, UNIX, Oracle VM Virtual Box, VMWare, Unix/Linux Shell Scripts, JIRA, Confluence, GitHub, Bitbucket, ClearCase, Google Cloud, AWS, Docker, Kubernetes, Google Kubernetes Engine, Jenkins, Kibana-Elastic, CheckMarx
PROFESSIONAL EXPERIENCE
KeyBank, Cleveland, OH 11/2020 03/2023
Senior Software Engineer
Led creating a critical long-term solution to automate, streamline, integrate and transform legacy system bank customer info into a new enterprise digital portal. Coordinated resources and dependencies of the project across multiple teams in multiple bank systems development life cycle. Scheduled design meetings, gained security accesses, created change requests and set up work environments. Analyzed functionalities and feasibilities, prioritized tasks, and phased out project.
Took a key role in defining requirements, high-level approach, prototyping, modeling, QA testing, CI/CD delivery, and production support. Created DB objects, coded packages, stored procs and microservices using PL/SQL, SQL, T-SQL, Java spring boot, JSON, MQ, Docker, GKE, XL Release OpenShift, and Jenkins.
As a cross functional squad lead, designed and developed nightly sync process that extracts, transforms, and loads bank customer data from multiple sources (MDM, Oracle, SQL Server, DB2) into Oracle DB for decommission, business analysis, and reporting using Java spring boot, Microservices, PL/SQL, T-SQL, C#, .NET, SSIS, Google cloud, Jira and Confluence. Completed hands-on training on Python, Tableau, Power BI, and Cyber Security.
Windstream, Twinsburg, OH 11/2014 09/2020
Software Engineer III
Innovatively improved enterprise applications performance and created great customer satisfaction by recommending and implementing a new architecture approach with high availability, scalability, performance, and reliability, that is using Oracle Advanced Queue (AQ) to decommission Golden Gate in six legacy systems. Evaluated options, leading Proof of Concept, prototyping AQs, Schema, API, registration, propagation, and demonstration. Wrote architecture design with modeling diagrams, created project team board, and stories in wiki and agile sys. Performed team code review. Saved high license fee and cut long system processing time down to half sec.
Significantly contributed to Windstream legacy systems consolidation, migration, and integration into a next generation of inventory order system. Leading and owning customer account, subject areas of orders, system replication, and delegation. Played a critical key role in in-depth analysis, approaching, functional/technical design, coding, data modeling, database object creation, replication, domain delegation, testing, performance tuning, and production delivery using SQL, PL/SQL, shell scripts, MagicDraw. With analysis and design addressing data integrity issues, named as a stakeholder.
Designed and coded Java REST web services to retrieve and process customer orders using Spring Boot Microservices, JSON, Maven, PL/SQL, SQL, and Oracle XML. Evaluated the technical tools and languages, prototyped complex products hierarchy search functionality UI using jqxWidgets, jQuery, JSON, Ajax, JSP, HTML5, CSS, and Java.
Developed a crossing multiple systems customer info sync tool using MVC architecture, J2EE, Java, JSP, Java Scripts, HTML5, SQL, SQL Server and Oracle. Hands on experience with ADF frameworks with Java/JavaScript, Python, HTML5, and APIs for web orders.
Advocated and practiced agile methodology and best practices to adopt frequent changes, improve quality, speed up release processes and better meet customer needs. Worked closely with business team in collaborating, and strategy planning for various system migrations and integration.
Created new oracle and PostgreSQL DB databases, SQLs and PL/SQL stored procedures and packages for web application. Worked on Oracle 12c/11g databases, Linux Server, and WebLogic server installation and admin in oracle VM environment.
Designed/developed a BPM Portal audit tool "Queue users and roles reviewing process" using Java, JavaScript, Java Server Pages, IBatis, Oracle, SQL, PL/SQL, Business Process Manager models, workflow process, API calls/Web Service, and email in middleware. Collected and identified requirements analysis and design reviews as a consultant.
Verizon Wireless, Twinsburg, OH 02/1999 - 04/2014
MTS III Consultant-System Engineering
Worked as lead developer contributing significantly to a new VIG financial invoice system development, saving Verizon wireless business $2 million a year. Proved excellent analysis and problem-solving capabilities in designing and implementing various data-driven applications like file processing, invoice creation, OFAC reporting and Tax APIs. Receiver of Verizons Performance Excellence, Quality and Innovation reward.
Played a key role in designing/implementing data processes, and job scheduler for billing integration, revenue share and customer profile reporting, payment and SOA tax consolidation in VZW Data Mart and Data Warehouse systems.
Improved dynamic rule engine to revenue share modules. Enhanced Java Message Queue (MQ), EJB, JPA and Hibernate, creatively integrated service framework into recurring manager models, created various java APIs and emails for Cellcrypt voice security solutions, mHealth, mobile payment and customer care apps.
Successfully converted 11 million customer lines from ALLTEL to Verizon billing system by designing/implementing conversion batch jobs using PL/SQL and SQL. Significantly improved performance using SQL Tuning Advisor, Execution Plans, and Query Optimizer.
Created various reports for audit/reconciliation of orders. Owned Mediator modules/ controller, CTI Tax APIs/Web Services, Network APIs, Revenue Share rules, invoice & payment creation batch processes, and OFAC reporting. Planned/estimated and scheduled project management activities using JIRA project management software.
Sr. Client Server Developer/Analyst Alltel (merged with Verizon Wireless in Jan 2009)
Exceptional results in developing and delivering of ALLTEL major CRM applications included B2B/B2C eCommerce, Customer Care, Call Center, and Point of Sale solutions.
Took critical responsibilities in designing/coding complex database packages and data load batch jobs in converting data across enterprise billing systems. Streamlined data processing/messages across major Applications. Conducted performance tuning in B2C eCommerce registration. Upgraded Oracle database from 9i to 10g for Siebel Apps.
Led analysis, design and implementation of B2C Call Center Back Office, B2B Customer Care Failed Order Management, eCommerce Offerings and Order history. Identified requirements, estimated project tasks, designed/coded workflows, creatively diagnosed and resolved unusual/undefined problems/gaps, provided innovative and efficient solutions to internal/external groups, wrote test plans, did code promotion/building.
Conducted comprehensive Proof of Concept for B2B eCommerce multi-Line change feature orders, altered the original market-based approaches to optimize solutions, avoid high failure Order rate. Developed an optimized order history search engine to resolve complex business hierarchy performance issue. Created Product Model for POS system.
Served as the leader in developing Siebel Strong Encryption Solutions, and data encryption jobs to encrypt data in ALLTEL Oracle databases and major apps for protecting CPI Info. Developed HR Management System. Created a Trouble Management system tool to automate Trouble Tickets creation, assignments, and email notification.
Mentored newly hired client server consultants. Actively organized and facilitated mentoring group meetings and wrote training cases studies. Completed Microsoft Visual Studio and .NET training.
EDUCATION
Cleveland State University, Cleveland, OH
Masters degree in Computer and Information Science 1998 |
