Jane Farias (Rupp) Email & Phone Number

Chicago, Illinois, United States

• Upgrade from Oracle 11G to Oracle 19C for multiple databases on multiple environments• Provide Oracle application and day-to-day operational support for the Federal Reserve Financial Services – FedLine department• Automated several manual processes using Oracle Database and Control M scheduling tools• Generate and distribute data files to customers per schedule• Create ad-hoc Oracle queries based on customer request or technical support need• Interface with National IT and WPO partners for deployment and support issues• Cleanup and/or fix Oracle Technical Debt• Lift and shift FTA ETL Unix process from Solaris to AIX/Linux• Transition Oracle database deployments from National IT to FedLine• Coordinate on-prem QA and Production FedLine deployments for 5 application development teams and National IT• Transition the coordination of QA and Production deployments to the Change/Release Management team

Chicago, Illinois, United States

• Developed and tuned portions of multiple systems that provide shopper insights and analytics using Oracle 11G stored procedures and packages (PL/SQL).• Re-architected existing mission critical processes which utilize Oracle 11G databases to provide for scalable solutions as the company’s business volume continues to increase.• Reduced CPU utilization on 4 Core Linux servers running Oracle 11G databases to maintain Oracle licensing costs.• Provided light Oracle Database Administration work when situations warranted.• Re-wrote SPSS Data Modeler code using Oracle 10G stored procedures and packages to automate manual processes. This reduced execution time from 12 hours to 15 minutes.• Migrated applications and processes from Oracle 10G database on Sun/Solaris hardware to Oracle 11G database on X86/Linux servers. This immensely improved system and application performance.• Upgraded from Flux scheduler version 7 to Flux scheduler version 8 and migrated over 550 Workflows from Solaris to Linux.• Communicated and wrote database processes and transition documentation for support of mission critical applications.• Technical and business point of contact for developers, leadership, and business partners on numerous projects.• Mentored new developers by reviewing their business and technical designs to ensure efficient and consistent coding techniques. • Provide Production Support to ensure on-time delivery of data, reports and files to our customers.

Chicago, Illinois, United States

• Migrated applications and processes from Oracle 8i database to Oracle 10G database.• Experienced in performance tuning Oracle SQL within C# .NET, for OLTP and OLAP processes. This includes experience with tuning upgrades for Oracle database releases.• Developed Oracle stored procedures and packages to manage market data entitlement and billing systems utilized by financial advisors.• Initiated, defined, and implemented schema enhancements to accommodate application requirements. Maintained data models of application schema. Established test data in support of user acceptance testing to provide for accurate reflection of production environment.• Managed SDLC and change management processes to ensure regulatory compliance. This includes code review sessions to ensure accuracy and proper coding standards, and adherence to application recovery plan for corporate disaster recovery.• Directed the preparation of the corporate disaster recovery exercise for multiple mission critical applications. This ensured successful recovery was completed accurately, within required time frame, during the annual disaster recovery drills.• Provide 24 X 7 X 365 Production Support to ensure systems execute successfully.

Schaumburg, Illinois, United States

ClientsGeneral Electric Medical Systems Wachovia SecuritiesUnited Stationers • Established data conversion requirements, processes, and procedures for incorporating information from multiple companies acquired through business mergers. Analyzed data models from companies’ systems to create processes to integrate data seamlessly from acquired companies.• Worked with colleagues and customers across 4 time zones at various hours of the day to meet tight deadlines

Indianapolis, Indiana, United States

• Developed and implemented new warehouse delivery system and inventory management systems for a manufacturing firm to improve efficiency and provide accurate inventory control for eight warehouses across the country.• Implemented an interface between the warehouse delivery system and UPS Worldship software shipping package to eliminate redundant clerical work and improve workflow.

Long Grove, Illinois, United States

• Enhanced a newly deployed personal lines insurance billing system to allow input from multiple policy writing systems, thereby eliminating 11 other billing systems.

• Acted as Technical Architect for a single point application security system to meet multiple customers’ strategic needs. Through negotiation across multiple customers, determined the business and audit requirements. This single point security system was then successfully deployed to 10 other health care clients.• Provided 24 X 365 production support for multiple systems and clients to ensure availability of mission critical systems. This includes ensuring Service Level Agreement (SLA) compliance within the application organization.• Analyzed business requirements and procedures within the Systems Development Life Cycle (SDLC) framework to make recommendations for continued computer system improvements for multiple business clients in various industries including insurance, brokerage, and financial. This process included iterative prototyping to ensure accuracy for a successful production deployment.

• Acted as Technical Architect for a single point application security system to meet multiple customers’ strategic needs. Through negotiation across multiple customers, determined the business and audit requirements. This single point security system was then successfully deployed to 10 other health care clients.• Provided 24 X 365 production support for multiple systems and clients to ensure availability of mission critical systems. This includes ensuring Service Level Agreement (SLA) compliance within the application organization.• Analyzed business requirements and procedures within the Systems Development Life Cycle (SDLC) framework to make recommendations for continued computer system improvements for multiple business clients in various industries including insurance, brokerage, and financial. This process included iterative prototyping to ensure accuracy for a successful production deployment.

Boston, Ma

Bachelor Of Science Computer Information Systems

Associate Of Science Accountancy

Associate Of Science Management