Software Engineer Oracle Database

JOECY D. FRAZIER

INFORMATION TECHNOLOGY PROFESSIONAL

Expertise: System Analysis & Design, Oracle or Database Development, Oracle versions 7-11g, 19c, Oracle Forms (6i-10g) & Reports, PL/SQL, Unix, Project Lead/Management, Splunk, AppDynamics, Grafana

Highly experienced, deeply driven, motivated system analyst/software engineer with 24+ years of track record in Oracle database (from ver. 7 to 12g to 19c Enterprise Edition) and system development. Headed Database planning and migration. Worked with various industry such as banking/finance that is responsible to deliver reports required by the federal reserve to banks with more than 50B assets. Built application used by local government agencies (created, designed and partially coded an Accounting System, that is modular and integrated). Other domain includes manufacturing, software consultancy, utilities, telecom and insurance (function focus: CLAIMS (Pension/Annuity), New Business, Policy Administration, Underwriting, Agency, partial Account for Agent commission) . Led a big team of software developers in US and in Philippines. Extensive exposure to database development, quality assurance and documentation. Extensive involvement in the different stages of software development, maintenance and support. An Oracle Certified Associate. Have experienced in doing minor DBA roles/jobs.

Technology Snapshot:

Software: Oracle PL/SQL, Oracle versions 7.0, 8.04,9i, 10g, 11g, 19c, Tortoise Git, Tortoise GitMerge, Splunk, AppDynamics, Grafana, Oracle Forms 6i and 10g versions, Oracle Reports, Digital UNIX OSF/1 4.0B/4.0D, MS-DOS 2.x–6.22, Microsoft Windows ver. 3.xx/95 xx/98, Intel/Alpha Based Microsoft Windows NT Workstation/Server Oracle SQLNet, Oracle Developer Server 1.6.1, Oracle WebServer 2.1.1, Oracle Jinitiator 1.1.7.27, Oracle Developer 2000 Forms Release 4.5, 6.0,6i, Oracle Designer 2000, Seagate Info, Crystal Reports, Microsoft Office products, Connectivity and Terminal emulation software like Xcursion, Kea!Term, Delphi4.0/5.0, PowerBuilder 8.0, Citrix, Putty, PVCS, SmartFTP, Microsoft Visual SourceSafe, Oracle Developer SQL Data Modeler, Visual Studio, Microsoft Clear Case, Oracle SQL Developer, TOAD,OBIEE, PLSQL Developer 64-Bit, Submersion Client Configuration, Tortoise SVN, Visual C++, Collabnet Subversion Client, Control M, GitHub, Confluence, Jira, Putty, NDM, iReport, WinSCP, Pac2000, Notepad++, Skype for Business

RDBMS: Oracle Enterprise Server Edition 7.x.x.x (with Distributed, OPS, EBU, and Replication implemented), ROSS, Oracle Database 8, 9i, 10g, 11g, and 19c, AS400, MongoDB

Hardware: DEC Alpha Based Machines 4100/8200 models, Intel Pentium, IBM PC and Compatibles, IBM AIX, IBM Power7

• Product/Software Development • Data and Application Architecture

• Product Support/Maintenance

• Agile Development • Structured System Development/Information Engineering

• Knowledge in Oracle EBS (thru online reading)

PROFESSIONAL EXPERIENCE

Wells Fargo Bank July 2019 - Present

Senior Software Engineer

TekSystems February 2019- July 2019

Database Developer/Apps Systems Engineer

Client : Wells Fargo

Location: Boston, MA

As a Senior Software Engineer, I was task to manage and support Wells Fargo Equipment Customer Self-service application and new functionalities for the business. Part of my duties and responsibilities includes the following:

• Lead moderately complex initiatives and deliverables with technical domain environment

• Contribute to large scale planning of strategies

• Design, code, test, debug, and document for projects and programs associated with technology domain, including upgrades and deployments

• Review complex issues and lead a team to meet existing client needs or potential new client needs while leveraging solid understanding of the functions, policies, procedures, or compliance requirements

• Collaborate and consult with peers, colleagues, and mid-level managers to resolve technical challenges and achieve goals

• Lead projects and acts as an escalation point, provide guidance and direction to less experience staffs.

• Led the planning and migration of 9 Database migrations (dev to production)

• Maintain and develop existing and new functionalities for the business that adheres to the full life cycle process, this includes, evaluation of business requirements, investigation, to design, documenting, coding and testing using available tools and technology

• Write new or modify existing PL/SQL objects base on the new functionalities

• Assist UI team in building, executing database objects and verifies them

• Analyze current procedures, recommended and implemented improvements as needed

• Make sure that modified or newly created PL/SQL objects adheres to the requirements and are functioning by testing the written codes thoroughly and documenting them

• Execute and monitor batch jobs as requested by users and/or other teams

• Debug or troubleshoots pre-production and production issues

• Write shell scripts

• Write DDL and DML scripts and push them to Git as well as writing backout scripts

• Create or modify existing AutoSys jobs

• Document existing batch jobs which could hasten the identification of bugs and fixes needed in solving them

• Prepare documents that list the inventory of objects that will go to SIT, UAT and PROD environment

• Analyze and document test results, investigates discrepancies and tracks issues

• Coordinates with business to make sure that requirements are delivered on time and with quality

• Migrates database objects and data from one server to another

• Provide support for product enhancements to meet the customers’ requirements.

• Design, create and execute test cases based upon business requirements and system requirements to validate system functionality

• Other ad hoc jobs such as updating existing documents e.i. on-boarding manuals, training manuals, etc.

• Create/develop dashboards in Splunk, AppDynamics and recently Grafana

Tools/Software Used: Oracle, PL/SQL,SQL Developer, UNIX Shell Scripting, Shell Programming, Autosys JIL, GitHub, Confluence, Jira, Putty, NDM, Tortoise Git, Tortoise GitMerge, iReport, WinSCP, Pac2000, Notepad++, Skype for Business, Teams, Splunk, AppDynamics, Grafana, MongoDB

TekSystems July 2017- December 2018

Sr. Oracle PL/SQL Developer

Client : State Street Bank

Location: Boston, MA

As a Sr. Oracle PL/SQL Developer, I was task to manage and support WSS applications, extracts and reports. ORD is the database that is specifically created to store the data of WSS on a readable format. My team provides data for various extracts/reports, for various teams.

• Analyzed and designed tables to be used for storing extracts for ease of generating various reports

• Created new stored procedures and functions and modified existing ones.

• Created shell scripts to execute script in SQL*Plus using Autosys jobs

• Install and manage Autosys scheduling package on Windows and multiple UNIX environments

• Monitor daily processing flows and Autosys jobs, insuring systems stability so we meet processing service level

• Responsible for deployment of changes to QA, UAT and PROD making use of Cloud DB Deployment, IBM BuildForge

• Created AUTOSYS command script to retrieved information from daily AUTOSYS EVENT logs

• Worked on data analysis and data correction and cleanup for warehouse tables

• Developing reports using complex queries as risk manager request as a part of production support

• Analyzed current procedures, recommended and implemented improvements as needed

• Developed complex SQL queries to perform the back end testing of the Oracle database using SQL and UNIX shell commands

• Prepared documents for production deployment – Day Of Production (DOP), Operations Readiness, etc.

• Prepared documents such as Inventory of all AutoSys job from all environments, this helps the team in determining which jobs should be created in case of new site/s; determining defects and fixing them.

• Exposure to ETL tools

Major Projects Handled

MiFID II – (Markets in Financial Instruments Directive)

o Analyzed and designed tables that will store information such as table name, column name, filter criteria, active indicator, etc.

o Created 3 procedures that can handle multiple table extracts without creating separate procedures for every table requested, thus eliminating redundancy and hastening the delivery of new tables requested for data extract

o Created austosys jobs that calls the shell scripts which then calls the procedures created

o Assisted QA in validating/verifying and ensuring that defects raise (if any) are addressed promptly

ASP QA3 Migration

o Migrated 1800-2000 autosys jobs from old QA4 server to QA3.

o Made sure that all components such as unix shell scripts, .profiles, directories, files, grants, etc are in place in the new server

o Tested the jobs for all sites, made sure that they are all running successfully

EMEA TOLAS migration

o Created autosys jobs that will call new stored procedures created in generating FX, MM recons and IFS Oracle GL transaction entries

o Tested, validated/verified the accuracy of data being generated by each reports – FX, MM and IFS Oracle GL

o Coordinated with other teams that consumes the data provided in reports

o Monitors the newly created autosys jobs, making sure that they ran successfully

Brexit

o Analyzed and prepared an object inventory of all Munich related objects such as PL/SQL Procedures, materialized views, triggers, metadata, Unix shell scripts, unix files, directory and file setup in every server (QA, UAT and PROD), autosys that will need to be created for the new Frankfurt site

o Modified existing procedures to handle the new Frankfurt site

o Modified existing shell scripts and unix files to handle the new Frankfurt site

o Created 90-100 autosys jobs and monitored these jobs in every environment

o Tested, validated/verified the accuracy of data being generated by each Frankfurt reports

o Assisted the QA in verifying the data generated by the FXRP team who are stationed in China

o Coordinated, assisted various groups that consumes the WSS application data.

Minor Projects Handled

SailPoint

Other stories such as formatting issues and Algo reports

Tools/Software Used: Oracle 11g/10g, PL/SQL,SQL Developer, UNIX Shell Scripting, Shell Programming, UNIX (Solaris, Linux), Autosys JIL, T-SQL, SQL Server Reporting Services, SQR-Reporting, IBM Utilities such as ClearCase, ClearQuest, BuildForge, GitHub ; Agile Development, AiKanban

Maxnet Technologies, LCC May 2014- December 2016

Oracle Developer/Technical Lead

Client : Deutsche Bank

Project Management – Senior Business Project Manager III

Location: New York City

In June 2009, the Federal Reserve conducted the Supervisory Capital Assessment Program (SCAP), a "stress test" that focused on identifying whether large, domestic BHCs had capital sufficient to weather a more-adverse-than-anticipated economic environment while maintaining their capacity to lend. In 2011, the Federal Reserve continued its supervisory evaluation of the resiliency and capital adequacy processes through the Comprehensive Capital Analysis and Review (CCAR) 2011. The CCAR 2011 involved the Federal Reserve's forward-looking evaluation of the internal capital planning processes of the BHCs and their anticipated capital actions in 2011, such as increasing dividend payments or repurchasing or redeeming stock; evaluating whether these BHCs had satisfactory processes for identifying capital needs; and evaluating whether these BHCs held adequate capital to maintain ready access to funding, continue operations, and meet their obligations to creditors and counterparties, and continue to serve as credit intermediaries, even under stressful conditions. During the fall of 2011, the Federal Reserve implemented the FR Y-14A/Q. In 2016, the Federal Reserve published a final notice in the Federal Register (81 FR 35016) requiring intermediate holding companies of foreign banking organizations to file certain regulatory reports and comply with the information collection requirements associated with regulatory capital requirements, including the FR Y-14 reports with submissions as of December 31, 2016. The respondent panel is comprised of any top-tier BHC or IHC that has $50 billion or more in total consolidated assets as determined based on: (i) the average of the firm's total consolidated assets in the four most recent quarters as reported quarterly on the Consolidated Financial Statements for Bank Holding Companies (FR Y-9C) (OMB No. 7100-0128); or (ii) the average of the firm's total consolidated assets in the most recent consecutive quarters as reported quarterly on the FR Y-9Cs, if the firm has not filed an FR Y-9C for each of the most recent four quarters. Participation is mandatory. The annual schedules are reported as of December 31 each year. Certain schedules are semi-annual and also reported as of June 30 each year, including the Summary, Scenario, and Retail Repurchase Exposures schedules. For the annual Trading and Counterparty worksheets (contained in the Summary schedule), the data will be as of a specified date in the first quarter.

• Designed and developed physical data models and schemas for projects and on-going application enhancements. Written and executed stored procedures, triggers, and complex cursors and SQLs for Oracle.

• Ensure data integrity, security and performance through review of physical data models against application processing and architectural designs.

• Led and performed database-related testing in conjunction with other application testing efforts.

• Coordinated the implementation of database objects, tables and stored procedures into production. Support development efforts, including consulting on the design and execution of all data-related tasks. This includes writing and creating tables and constraints, views, materialized views, creating synonyms and roles and granting privileges to different roles.

• Imported and exported large amount of data from and into Oracle database from different source (datafiles coming from different sources)

• Support and perform the resolution of production application data issues, Oracle upgrades and maintenance. Contribute to projects, enhancements and conversions by writing and maintaining Oracle procedures, functions, and packages.

Recommend improvements to or replacement of application databases, data processes and data modeling tools.

• Produced technical designs and specifications from the functional requirements, development of functional and technical specifications into working application modules in addition to completing documentation and testing. Ultimately working with other developers to incorporate code into a larger application

• Provided support for product enhancements to meet the customers’ requirements.

• Designed, created and executed test cases based upon business requirements and system requirements to validate system functionality.

• Analyzed and documented test results, investigated discrepancies and tracked issues.

• Review existing process documentation.

• Coordinates and gather s Business Requirements with lines of business.

• Designs systems architecture based on product development requirements.

• Designs and develops Oracle based relational database architecture.

• Builds secure web application, user authentication, role-based access control, n-tier architecture.

• DB/file encryption, input validation techniques.

• Provides documentation to describe program development, logic, coding and corrections

• Migrates database objects and data from one server to another

• Tests developed or written packages/procedures and make sure they are of good quality

• Prepares/Writes GAD (General Application Design)

• Exposure to data warehousing (FDW Finance DataWarehouse), SAP

PROJECTS in Deutsche Bank :

IHC Reports Automation

• Works on development / automation of various (39 to 41) IHC reports required by Fed to financial companies. Example of reports automated are: FC1, FC2, FC3, TICBC, TICBL1, TICSLT, TICBQ3, FRY12, FRY9LP and other IHC reports.

• Works with various data analysts and business analysts

• Investigates and creates an innovative design that prepared business users of the scenarios to be used.

• Leads the database design and processes that will be both use by backend and gui platform

• Develops backend processes (packages, procedures, functions, triggers) in automating the data received from different business users to feed the AXIOM platform

• Fine tunes PL/SQL procedures and SQL queries

• Prepares migration scripts and executes them

Technical Lead – Sept 2014 LOB Report

• Led the development of various processes that generated feeds to LOB platform that can be invoked using Plan B or C scenario in a very aggressive and constrained timeline

• Investigated and created an innovative design that prepared business users of the scenarios to be used.

• Partnered with consultants from Ernst & Young (LOB platform team) to ensure that the delivery of the project is successful and of high quality

• Developed backend processes (packages, procedures, functions, triggers) in automating the data received from different business users to feed the LOB platform

• Fine tunes PL/SQL procedures and SQL queries

• Prepared migration scripts and executed them

SWAT Adjustment

• Worked on database side of Daily Balance Position adjustment

• Designed database objects and processes to be used for DBP SWAT adjustment

Technical Lead – Automation of FRY9C/031/FRY14A Reconciliation (Current project)

• Produce technical designs and specifications from the functional requirements, development of functional and technical specifications into working application modules in addition to completing documentation and testing. Ultimately working with other developers to incorporate code into a larger application

• Solves issues raise by our business users, doing so would include investigation on how and why the bug had occurred (root cause analysis), rectifying the problem, testing and documenting

• Analyzes changes, foresee impact to the totality of the system and business in order to minimize possible risks

• Assists any member of the team in solving an issue

• Designs, creates and executes test cases based upon business requirements and system requirements to validate system functionality

• Develop backend processes in automating data reconciliation of bank’s SAP, RCS and FDW Classic data

• Fine tunes PL/SQL procedures and SQL queries

• Prepared migration scripts and executed them

Tools/Software Used: SQL Developer, TOAD, Control M, Putty, Oracle Database, .Net, Visual Studio, Visio. AXIOM, LOB application

Genpact, LCC May 2013 – April 2014

Technical Lead/Lead Consultant

Client : NBC Universal

Location: New York City

Part of a 12 member team that is tasked to convert NBC Universal networks (Bravo, E!, Style and Esquire) from their legacy system (Deal Maker) to OnAir

• Leads development team (mostly PL/SQL programmers) with conversion initiatives

• Performs independent and complex technical and functional analysis for multiple projects supporting several data conversion

• Assists BA in requirement gathering for them to be able to properly write the Conversion Requirement Document (CRD)

• Leads data conversion design and review of documents prepared by BA

• Writes technical mapping documentation based on the documents prepared by BA’s

• Develops data conversion routines for multiple projects supporting several divisional initiatives

• Writes PL/SQL procedures that will handle the conversion task from legacy system to target system

• Fine tunes PL/SQL procedures and SQL queries.

• Directs in writing and maintaining data conversion code from documented logic and instructions of limited to moderate complexity

• Study and performs data analysis and executes data conversions

• Performs code and unit testing for moderate to complex scope data conversion routines

• Assist QA team in building their SQL in validating data staged. Helps in fine tuning their scripts.

INFOSYS July 2012 – May 2013

Technology Analyst/Oracle Developer

Client : Fidelity Investments Sept. 2012 – May 2013

Location: Boston, MA and Smithfiled, RI

Part of GEM (Global Employee Management) team that monitors the activities of Fidelity Investments’ access employees with regards to trading.

• Provides effort needed in the changes or enhancement (back end only) to the GEM system required by the business users.

• Analyzes changes, foresees impact to the totality of the system and business in order to minimize possible risks

• Designs and develops physical data models and schemas for projects and on-going application enhancements.

• Writes and executes stored procedures, triggers, and complex cursors.

• Ensures data integrity, security and performance through review of physical data models against application processing and architectural designs.

• Performs database-related testing in conjunction with other application testing efforts.

• Coordinates the implementation of database objects, tables and stored procedures into DIT and SIT environments.

• Supports development efforts, including consulting on the design and execution of all data-related tasks.

• Designs, creates and executes test cases based upon business requirements and system requirements to validate system functionality

BAKER & TAYLOR (YBP Library Services), USA Oct. 2011 – June 2012

Oracle Developer

Location: New Hampshire

Baker is Taylor is the world’s largest distributor of physical and digital content and value-added services.

• Lead and perform data analysis for projects and on-going application enhancements. Develop lasting conceptual and logical data models and designs that support current and future business requirements. Identify and document the interactions between data and business/application processes. Participate in and lead logical data model discussions.

• Design and develop physical data models and schemas for projects and on-going application enhancements. Write and executes stored procedures, triggers, and complex cursors. Ensure data integrity, security and performance through review of physical data models against application processing and architectural designs.

• Lead and perform database-related testing in conjunction with other application testing efforts. Coordinate the implementation of database objects, tables and stored procedures into production. Support development efforts, including consulting on the design and execution of all data-related tasks.

• Support and perform the resolution of production application data issues, Oracle upgrades and maintenance. Contribute to projects, enhancements and conversions by writing and maintaining Oracle procedures, functions, and packages.

Recommend improvements to or replacement of application databases, data processes and data modeling tools.

ITAC RESOURCES, Malaysia June 2010 – June 2011

MATADOR SINGAPORE June 2009 – June 2010

Client: Hong Leong Assurance Malaysia

Senior System Analyst/Oracle Developer

Hong Leong Assurance Berhad (HLA) is one of the largest insurance companies in Malaysia. It is a well-established and respected Malaysian brand offering financial planning and protection solutions to meet the various needs of Malaysians at different cycles of their lives.

Extensive exposure in New Business, Underwriting, Claims(Pension, Annuity, GMAT, Death, TPD, PPD and other claims) and Policy Servicing, Unit Link module, Group Life System. Traditional and Takaful Insurance. Minor knowledge in Finance/Accounting. Minor knowledge in General Insurance

• Provided effort needed in the changes or enhancement required by the user particularly on Claim Modules (Pension or Annuity, Maturity), New Business, Agency, Policy Administration, Agent’s Commission accounting entries, Underwriting and others

• Produced technical designs and specifications from the functional requirements, development of functional and technical specifications into working application modules in addition to completing documentation and testing. Ultimately working with other developers to incorporate code into a larger application

• Solved issues raise by our end-users, doing so would include investigation on how and why the bug had occurred (root cause analysis), rectifying the problem, testing and documenting particularly on Claim Modules (Pension or Annuity, Maturity), New Business, Agency, Policy Administration, Agent’s Commission accounting entries, Underwriting and others.

• Analyzed changes, foresee impact to the totality of the system and business in order to minimize possible risks

• Assisted any member of the team in solving an issue

• Monitored user requirements and sees to it that the RFA’s assigned are delivered on time

• Monitored the performance of the injected programs, provided solution if in case the injected program caused system slowdown

AETINS, Malaysia – (PENTASOFT)

System Analyst/Oracle Developer June 2007 – May 2009

A company that offers a single end-to-end Insurance Solution that covers all lines of business: Individual Life, Group Life, Investment Linked and General. It spans across functions like illustration, quotation, new business, policy servicing, claims, agency management, commission and benefits, accounting and services. The main business is to help Insurance Companies to strategize and operate by leveraging on Information Technology, a key enabler to achieve transformational growth through Operational Excellence and Innovation.

• Produced technical designs and specifications from the functional requirements, development of functional and technical specifications into working application modules in addition to completing documentation and testing. Ultimately working with other developers to incorporate code into a larger application.

• Provided effort needed in the changes or enhancement required by the user particularly on Claim Modules (Pension or Annuity, Maturity), New Business, Agency, Policy Administration, Agent’s Commission accounting entries, Underwriting and others.

• Solved issues raise by our end-users, doing so would include investigation on how and why the bug had occurred (root cause analysis), rectifying the problem, testing and documenting particularly on Claim Modules (Pension or Annuity, Maturity), New Business, Agency, Policy Administration, Agent’s Commission accounting entries, Underwriting and others.

• Analyzed changes, foresee impact to the totality of the system and business in order to minimize possible risks

• Converted some Oracle Forms 10g version to 6i version (Security Forms).

• Assisted any member of the team in solving an issue

• Provided support for product enhancements to meet the customers’ requirements.

• Designed, created and executed test cases based upon business requirements and system requirements to validate system functionality.

• Analyzed and documented test results, investigated discrepancies and tracked issues.

• Helped in takafulization (Conversion of some conventional insurance terms to Islam-accepted insurance word/s) forms for Islamic Insurances.

• Monitored the performance of the injected programs. (Minimal fine tuning experience)

ACCENTURE PHILIPPINES

Senior Software Engineer July 2005 – Jan 2006

Accenture is a global management consulting, technology services and outsourcing company. Combining unparalleled experience, comprehensive capabilities across all industries and business functions, and extensive research on the world's most successful companies, Accenture collaborates with clients to help them become high-performance businesses and governments

Client : SC Gas

SC GAS is a subsidiary of Southern Company, the premier super-regional energy company in the Southeast United States. The century-old company is known for its excellent customer services, high reliability and competitive prices and was rated No. 1 among electric and gas utilities on Fortune Magazine’s Most Admired Companies. Southern Company GAS is one of Georgia’s largest natural gas providers, serving approximately 200,000 customers with a commitment to providing competitive prices and the highest level of service.

• Gave aid to Accenture Business Services for Utilities client in Canada

• Handled RMT’s (Request Management Tool) for Unix and Oracle PL/SQL

• Prepared Detail Design, Test Plans and Test Scripts for every RMT assigned

• Created, modified, tested and fixed bugs and errors in Unix and PL/SQL

• Monitored user requirements and made sure that the RMT assigned is delivered on time

• Provided support for product enhancements that meet the customers’ requirements

• Designed, created and executed test cases based upon business requirements and system requirements to validate system functionality

• Analyzed and documented test results, investigated discrepancies and tracked issues

• Performed application fine tuning

CYTRONICS INTERNATIONAL INC., Philippines Feb. 2000 – July 2005

Project Manager/System Analyst

Cytronics International Inc. (CII) is an information technology (IT) services Company established back in 1988. It was founded by professionals having a combined total of over 300 man-years of comprehensive IT experience. It was established primarily as an organization that specializes in providing IT manpower resources to various organizations.

Client : Makati City Hall

Local Government Information System (LGIS) is composed of 30 applications, categorized as follows: Revenue Generation, Financial Management, Administrative Support Planning and Development Building Permit, Barangay Operations, Legislative Management, Point of Payment System and

Contact this candidate