LiveCareer-Resume

Senior Technical Business Analyst resume example with 20+ years of experience

JC
Jessica Claire
Montgomery Street, San Francisco, CA 94105 (555) 432-1000, resumesample@example.com
Summary
Highly motivated Sales Associate with extensive customer service and sales experience. Outgoing sales professional with track record of driving increased sales, improving buying experience and elevating company profile with target market.
Skills
  • Software Engineering & Development
  • Software Optimization
  • Business Intelligence Tools
  • ETL / Data Transformation
  • SQL / T-SQL / SQL Server
  • Microsoft Visual Basic / VBA
  • Visual Studios / VB / C#
  • Business Process Reengineering
  • Database Administration
  • Data Modeling & Design
  • Client Needs Fulfillment
  • Performance & Stress Testing
  • Management Information Systems
  • Team Leadership
  • Project Lifecycle Management
  • Waterfall / SDLC / Agile-Scrum/RICE Methodologies Programming Application Engine, C#, Cobol, Crystal Reporting, HTML, iMacro, iScript, Java, JavaScript, JCL, PeopleCode, PeopleTools, PL/1, SQL, SQR, SSIS, SSRS, T-SQL, Unix, VB.net, VBA, Visual Basic
  • Utility Software Application Designer, Data Transformation Services, Enterprise Manager, Help Star, HP Service Manager, MS Office Suite (Access, Excel, OneNote, Outlook, Word, PowerPoint, Project, Publisher, Visio), MS Windows, Query Analyzer, Quest Stat, Rapid SQL, SharePoint, SQL Analyzer/Navigator, SQL Developer, SQL Plus, SQL Server, Visual Studios
  • Application Software PeopleSoft Financials, PeopleSoft HCM/HRMS, Informatica, ImageNow/WebNow, Microsoft Access, Mainframe, SPF
  • Databases DB2, Oracle, SQL Server, Microsoft Access, Data Warehouse/Data Mart
Accomplishments
Experience
01/2014 to Present Senior Technical Business Analyst Exact Sciences | Springfield, MA,
  • Lead analyst to optimize the SQL, Informatica ETL, data warehouse, data mart, and business intelligence processes and interfacing applications.
  • Identified and reengineered long running SQL processes to minimize the risk of jeopardizing established Service Level Agreements.
  • Project Manager and Lead Application Architect for a 10-month project to develop a core ETL data warehouse, data mart, business intelligence system to consolidate and summarize an average of 2 million daily financial transactions that support the financial activity decisions of the Controllers division.
  • Developed an Excel / Visual Basic / VBA macro workbook to support the annual Tax Reconciliation activities, allowing the Controllers to manage, reconcile, and generate reports and distributable workbooks.
  • Automated the monthly and quarterly PeopleSoft security audits resulting in increased data reliability and decreased the audit durations by 80%.
  • Identified and implemented business and process improvements to the PeopleSoft Financials ERP suite supporting General Ledger, Accounts Payable, Procurement, Travel and Expense, Tax, and Audit.
01/2007 to 01/2014 Senior Business Systems Analyst Highmark Inc. | Stoneboro, PA,
  • Team Lead, mentor, and subject matter expert managing ImageNow, an Electronic Content Management application digitizes and routes documents for approval, processing, retention, and information accessibility.
  • Lead application architect for the redesign of vendor-delivered Accounts Payable workflow.
  • Efforts resulted in an increase of available discounts taken from $300K to $2.2M by systematically prioritizing voucher activities to maximize cash flow, leveraging the PeopleSoft Financials escalation and approval data.
  • Enterprise Architect for the design and functional support of PeopleSoft HCM and Financial applications; Human Resources, Payroll, Benefits, Accounts Payable, General Ledger, Inventory, Travel and Expense, and Procurement.
  • Project Manager for PeopleTools upgrade from 8.52 to 8.53 for both the PeopleSoft HCM and Financial product suites.
01/2005 to 01/2007 Senior Systems Analyst Apollo Global Management | New York, NY,
  • Senior Technical Analyst supporting PeopleSoft HR, Payroll, Benefits, Time and Labor, Training Administration, and Company Property modules for a national supplier of ferrous metal, iron, stainless steel, and specialty iron castings.
  • Designed and developed a customized PeopleSoft based Company Property module to manage assigned assets to achieve reduced property loss, and increase assessment reliability.
  • Reviewed, coordinated, documented, implemented, and tested PeopleSoft tax updates, patches and fixes.
  • Evaluated and reengineered customized PeopleSoft objects and internally developed processes for improved performance, increased efficiency and reduced processing time.
  • Liaison between internal clients and external vendors, interpreting systems requirements, designing solution proposals, estimating cost allocations, executing test plans, and troubleshooting technical and functional issues.
01/1995 to Present Vice-Chair of Technology/Enterprise Application Architect / Advisor MILWAUKEE PUBLIC TELEVISION/GREAT TV AUCTION | City, STATE,
  • Designed and developed Visual Basic/SQL Server Windows application that supports the year-round operations, full-time staff members, and more than 4,000 annual volunteers associated with the Milwaukee Public Television Great TV Auction.
  • During the televised Auction, the application supports nearly 200 simultaneous users.
  • The supporting SQL database was originally hosted on SQL Server 2000 and currently, SQL Server 2008.
  • The database incorporates nearly 400 stored procedures, and API interfaces to the broadcasting character generators.
  • The application incorporates Crystal Reports and interfaces with POS receipt printers.
  • Since the introduction of the enterprise application, Auction revenue has increased 20% ($200K) annually, and the standardized paperless business operation has increased transaction fulfillment to 99%.
  • Lead an 8-member team of IT volunteers to accomplish the visionary goals to automate, network, and standardize the infrastructure.
  • The application is currently being converted to a C#.net application with Visual Studios 2016 to align with current Windows operating systems and the database hosted on SQL Server 2016.
Education and Training
Expected in Master of Business Administration | Information Technology CONCORDIA UNIVERSITY, , GPA:
Information Technology
Expected in Bachelor of Science | Business Administration CARDINAL STRITCH UNIVERSITY, , GPA:
Business Administration
Expected in Associate Degree | Business Data Processing MILWAUKEE AREA TECHNICAL COLLEGE, , GPA:
Business Data Processing
Skills
VB.net, C#.net, Accounts Payable, Agile, Analyst, API, Architect, automate, Benefits, broadcasting, Business Intelligence, Business Process Reengineering, cash flow, Cobol, Content Management, Crystal, Crystal Reports, Client, clients, Data Modeling, data warehouse, Database Administration, Databases, database, designing, ERP, estimating, ETL, Financials, Financial, functional, General Ledger, HP, HTML, Human Resources, HR, DB2, Informatica, Inventory, Java, JavaScript, JCL, Team Leadership, Team Lead, Mainframe, managing, mentor, Access, Microsoft Access, C#, Excel, MS Office Suite, Windows operating systems, Outlook, PowerPoint, Publisher, SharePoint, SQL Server 2000, Windows, MS Windows, Word, Management Information Systems, Enterprise, Navigator, network, Optimization, Oracle, Developer, Payroll, PeopleCode, PeopleSoft, PeopleTools, PL/1, POS, printers, processes, Procurement, Programming, proposals, Quest, Reporting, Scrum, SDLC, Service Level Agreements, Software Engineering, SPF, SQL Plus, SQL, SQL Server, SQR, Tax, TV, Television, T-SQL, troubleshooting, Unix, upgrade, Visio, Visual Basic, Microsoft Visual Basic, VBA, VB, workflow

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • CONCORDIA UNIVERSITY
  • CARDINAL STRITCH UNIVERSITY
  • MILWAUKEE AREA TECHNICAL COLLEGE

Job Titles Held:

  • Senior Technical Business Analyst
  • Senior Business Systems Analyst
  • Senior Systems Analyst
  • Vice-Chair of Technology/Enterprise Application Architect / Advisor

Degrees

  • Master of Business Administration
  • Bachelor of Science
  • Associate Degree

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: