Corporate Security Encryption

Project Managed and provided Tier-2 analyst support to the Corporate Security team to install commercial encryption software.

Scope included multiple Company applications spanning multiple operating environments and data models.

Each application’s design was analyzed and charted for installation and future production specifications.

User Acceptance Testing and Production Support and Regression Testing was mapped out and project managed.

Oracle Enterprise Application Upgrades

Lead analyst role for a company-wide Oracle code replacement application

End to end business and systems analysis support

Requirements refined, documented

Collaborating with all Sub Ledger & General Ledger teams for referential integrity

Coordinated systems, integration, and user acceptance testing

Regression testing scheduled with the application and DBA teams

Created an International Code Replacement Application
  • Created brand new customized Oracle-based application to code replace/sweep Oracle Code Combinations and Segments
  • Led cross team functional analysis including the General Ledger and all Sub-Ledgers:
    • Accounts Payable
    • Accounts Receivable
    • Purchasing
    • Fixed Assets
    • Project Accounting
  • Took initiative to design integrated dynamic web pages for reporting on the new application
  • To complete web pages, self-education in AJAX and Cold Fusion interfacing with Connect:Direct software
  • Added a function for secure transfer files
  • Provided customers with SQL-like interfaces to pull Oracle data, replacing legacy reports
  • Reduced waste in material and customer time while providing full flexibility

General Ledger Oracle Conversion from MVS mainframe
  • Developed system requirements
  • Managed system, integration, and user interface testing phases
  • Planned out a procedure and schedule to update incorrect financial codes on transactions and balances
  • Restated up to 10,000 records
  • Attained a complete error-free General Ledger that had never been accomplished

Support for large Company Spin-Offs
  • Sourced the balance sheet for two new Corporations spinning from Parent
  • Orchestrated the processing of several hundreds of transactions over one year to split the company financially
  • Constant collaboration with the financial team customers, managing proper approvals
  • A strict focus on proper GAAP, and regulatory policies
Financial Management Language Conversion for Benefits
  • Lead analyst
  • Convert legacy Accounting to new Enterprise structure for company-wide benefit allocation
  • Collaborated with 3 internal customer division teams
    • develop requirements
    • plan and execute testing
    • post production installation support
  • New high-level designs and low-level logical data changes for the development team
Eliminated International Tax Penalties

Learned a special tax allocation process for an external country in Oracle GL

Sketched out issues including levied tax penalties for incorrect data to determine root causes

Introduced new idea to utilize MS Excel to cut down on manual legacy efforts

Leveraged Excel functionality to introduce faster and more effective auditing for International Controller team

Tax data was entirely corrected and tax levies avoided

Work Advocacy Team Leadership
  • Volunteered time to join the Corporate Systems Division Work Advocacy team
  • Advocacy Team scope was to support entire Division to get on board with new technologies in the workplace
    • Use of reservation application for mobile employees
    • New MS Lynx and Skype applications
    • Unified Communication software and hardware
    • Internal Social Media software
  • Authored a blog on the team website to summarize and provide support for all the new technologies using personal knowledge and experience
  • Utilized an existing team’s trivia training application from outside the Division to influence the Division teams in learning all the new tech
Income Summary – Retained Earnings Year End Closes
  • Project Lead for 5 straight corporate-wide End of Year closes to Retained Earnings
    • Schedule and facilitate all customer and development meetings for 4 months (~ 12 meetings)
    • Gathered, documented, and socialized business requirements
    • Generated pseudo code, high-level design, and flows for requirements impact to developers
    • Performed system and integration testing
    • Facilitated user acceptance testing and customer endorsement of the process and results
    • Created a new website for the process and maintained it for each year’s processing
    • Provided 24×7 support for production
  • The schedule is not flexible and requires pinpoint accuracy from end to end to ensure timely results
  • Collaborated with many customer teams
    • Corporate Accounting
    • Regulatory
    • International Finance
    • Corporate Investments
    • Corporate Tables
  • The process covered both MVS and Oracle environments due to a migration from MVS

Main
Alan Yurkovic
Help