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

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.

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.
• 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.
• 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.

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.
• 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..
• 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.
• 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.

• 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..
• 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.
• 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.

Boston, MA

Bachelor Of Science Computer Information Systems

Associate Of Science Accountancy

Associate Of Science Management