We provide IT Staff Augmentation Services!

Business Systems Analyst Resume

Columbus, OH

SUMMARY
Accomplished Business Systems Analyst with over 9 years of experience, and demonstrated skills in project analysis, data mining, web ecommerce/retail, database design and Q/A. Reduced the cost of data processing by 30% and prevented loss of data and duplication.
Strong technical and analytical skills in finance, project management, defect tracking, executing and conducted end-user system testing.
Core Competencies
Retail Management & Data Warehouse Data Mining & Risk Management Quality Assurance
Strategic & Project Planning Financial & Systems Analysis Pricing & Production Control
Technology & Operations Forecasting & Budgeting eCommerce / Web Retail


Technical Skills
Windows 2000 Vista Premium MS Project 2003 Project Server MS Office 2003/2007 MS Access 2003 Visio Flowcharting
VB 6.0 Lotus Notes Outlook 2007 Quality Center /Mercury Database Acrobat Reader SDIS SQL Server 2005 SQL Query Analyzer IDM /Internal Deal Model PKS/Pricing Data Model SQL Analysis / TOAD 9.6 SharePoint Star Schema
Oracle ERP Financial Power Point 2007 PeopleSoft 8.3 - 8.9 IVAULT Mortgage System Business Objects Solomon

Professional Experience
Confidential,Columbus, OH (March 2009 – October 2009)
Business Systems Analyst at Confidential,
Analyze Use Cases & Validation Rules for new Pricing Data Model Application. Participate in all phases of PRPC implementation, analysis, design, training, regression testing and support. Identify new QA and technology solutions based on business strategy needs.

  • Created a functional design for Pricing Model Application. Assisted with the recommendations for systems solution and development of an implementation plan. Translate business requirements into technology specifications (IDM 4.5; PRPC; WebSphere; TOAD).
  • Responsible for debugging and fixing applications, program analysis, design and specification for WebSphere & IDM Applications.
  • Improved IDM 4.5 testing procedures by introducing new technology resources. Modified existing use cases, scripts, scenarios, analyzed system changes, verified software functionality and defect tracking issues (HP Quality Center / Mercury Database; Access).
  • Confidential,Columbus, OH (January 2008 – January 2009)
    Business Systems Analyst, Confidential,
    Analyzed new business processes, established system testing with business and functional specifications liaise with global technology leaders, business analysts and developers (Storefront, IBM Web Store). Resolved ecommerce shopping cart cross-functional issues related to software testing. Reviewed, executed, controlled, and communicated final results of existing test scenarios. (Test Director, SDLC)

  • Monitored web site implementation activities, analyzed system changes and identified functional and user acceptance testing. (SQL Query Analyzer, SQL Server 2005, ERP Pricing) Led B2B / B2C E-Commerce Storefront Shopping Cart design walkthroughs.
  • Implemented Web Store use cases, scripts, scenarios and improved integration and regression testing process (Excel VBA, SQL Query Analyzer, and PowerPoint Presentations). Assigned project schedule and managed Microsoft Project Server 2007 activities.
  • Designed and lead matrix system analysis process to identify software functionality and defect tracking issues in ERP and eCommerce IBM Web Store Applications. Verified software functionality and defect tracking issues by adding connection link between existing applications. (SQL Server 2000, Excel 2007; Power Point; Visio). Recognized by management for successful and efficient project completion.
  • Improved IBM Web Store testing procedures by introducing new IBM Server. Installed IBM WebSphere Server and verified software functionality and defect tracking issues. Managed QA deliverables for each new build release (Visio 2003, SDLC, JIRA) .
  • Confidential,Dublin, OH (October 2005 – July 2007)
    Business Analyst at Confidential,
    Analyzed B2B / B2C vendor relations data warehouse projects and coordinate project requirements to project management group. Responsible for life cycle testing on the large integration project, reviewed existing testing with project and quality assurance teams.

  • Increased system integration functionality by 25% and improved data quality by conducting external customer satisfaction reports and analysis. Designed Financial Progress Reports for Project Management and Finance Group.
  • Launched new process of identifying ‘flag’ data inconsistencies and dramatically improved data warehouse. Designed metrics scorecard analysis and improved workflow project completion by 40% (Excel 2000, Access). Implement new business process to ensure the existing system aligned end-user expectations (SQL 2000, Mercury Test Director).
  • Provided financial data analysis used by project management and analyzed system integration functionality. Designed and implemented the balance score card analysis. (SQL Server 2005; Mercury Test Director) Provide system-generated quarterly and monthly financial reports
  • Initiated PeopleSoft v8.80 cross-training with department of finance. Improved streamline project completion by automating data entry and financial reporting. Informed employees of PeopleSoft v9.0 Training Sessions.
  • Confidential,Columbus, OH (January 2002 – October 2005)
    Business Analyst at Confidential,
    Analyze new functionality for wireless paging system. Presented wireless system workflow analysis to a GTI group. Introduced new wireless paging system process to secure wireless technologies. Skills Used: (Excel VBA, Visio, PL/SQL). Reduced the cost of data processing time by 30%. Prevented loss of data and duplication during migration of JPMC & Bank One.

  • Increased wireless paging system functionality by 70%. Project was completed successfully in 3 month vs. 6 month and recognized by management. Managed monthly financial reporting including: financial statements, cost analysis, reconciliation and scheduling
  • Skills Used: (Mercury Query Analyzer, PeopleSoft 8.8 - 8.9, SAP FI/FO, Business Objects 6.0, Access 2003).

  • Designed Access Database for Bank One/JPMC Merger Companies. Created Access queries, forms, reports and macros and improved monthly financial reporting process. Automated data entry and introduced process improvements for AP / AR functions. Reduced monthly processing time by 40%.
  • Created and implemented new requirements gathering to provide project cost benefits analysis. (Excel 2003; Visio; Power Point)
  • Integrated worldwide wireless paging systems functionality. Analyzed system functionality and explained new client specifications to internal users. Provide training in areas of wireless technology paging system process. Executed system-testing procedures and facilitated the implementation of new functionality for wireless connections between US / UK & Germany (Excel 2003, Access 2000).
  • Financial Analyst at Confidential,
    Analyzed and review client requirements for G/L conversion to PeopleSoft 8.4. Participate in the full financial software migration life-cycle (CICS, PeopleSoft 8.3). Liaison with other financial analysts related to financial analysis & management reporting.

  • Participated in the migration of CICS JCL and COBOL to a People Soft 8.4 (G/L, A/ R, AP, P/M, P/O). Analyzed and reconciled PeopleSoft G/L; AR; AP including fixed assets, depreciations, journal entries, and generated monthly balance sheets (Excel 2000; Access 2000 / SQL Query Analyzer).
  • Improved the existing reconciliation process by defining new requirements gathering for AP / AR functions. Improved system functionality by migrating financial data between CICS Mainframe & PeopleSoft v8.4 G/L.
  • Financial Analyst at Confidential,

  • Optimized financial reporting operations including; accounts reconciliation; month-end closing; cost; financial analysis and systems. Created new system process analysis using SQL Query Analyzer and identified gaps between multiple projects.
  • Increased financial reporting productivity level by 70%. Created money-pool reconciliation and identified financial data inconsistencies and errors. Analyzed and interpreted new feature project criteria’s. Supported functional and project side of the business. Skills Used: (SAP FI / FO; Access 2000/ Excel /ODBC)
  • Upgraded the existing MS Access Database and improved monthly financial reporting analysis process by developing new SQL Queries, Forms, Reports and Macros. Skills Used: (SQL Server 2000; MS Access 2000; MS Project 2003)
  • Established operating metrics and dashboard reports to identify monthly variances and trends between budgets. Analyzed detailed assets; liabilities and created quarterly forecast analysis (Access 2000/SQL Server 2000). Compiled quarterly financial budget analysis using integrated links to PeopleSoft 8.3 - 8.4 A/R; A/P.
  • Created analysis and ad-hoc reports used for annual budgets and YTD expenses. Produced and enhanced stored procedures and ad hoc queries in SQL. Compiled consolidated financial statements and generated ad-hoc reporting. Prepared financial and income statements at the month-end closing. (SAP R/3; SAP Business Objects; DB2)
  • Reduced the risks associated with project future cost. Developed change management plan to identify cost savings initiatives. Developed and maintained daily operations projects, prepared monthly expenditures and created quarterly financial reports. Skills Used: (PeopleSoft 8.4; Business Objects 6.0; FICO).
  • EDUCATION

    • B.S. in Business Administration / Information Systems
    • B. S. in Accounting/Finance

    Hire Now