We provide IT Staff Augmentation Services!

Business Analyst Senior Resume

Irving, TexaS

SUMMARY:

  • Twenty years of executive level experience in application of finance and accounting computer systems to manufacturing, distribution, real estate/ Confidential, health services and human resources areas in both large and small companies.
  • The systems tool must fit the clients’ needs.
  • Completion of projects within the timeframe and requirements specified, with quality and integrity.
  • Able to prioritize and identify potential issues, find solutions and take preventive measures to complete the projects.
  • Able to give experienced business and systems input into project processes, yet the client’s wishes come first.

TECHNICAL SKILLS:

Operating systems (O/S)/Platforms: DOS, Microsoft Windows 3.2 and 95 through 2000, Windows XP, NT and NT Workstation, Novell Adv. Netware DOS through Zenworks for Windows 3.x & 4.x, IBM Mainframe DB2, SQL Server, Oracle.

Software Packages: SQL Server, SSRS, SSIS, Provenir, DNN, De3 Dialer, MailFlow, De3, Business Objects, Crystal Reports 11.1, TIMS, Diver, Oracle, Platinum Reporting Facility (SQL), SAS, DYL 280, AS/400 Office, Lawson Insight for Human Resources & Accounting, PeopleSoft, AS/400 based Confidential Financial Accounting and Inventory Systems, Confidential HR WorkWays, ADP, IBM Mainframe Based Accounting Systems, Cougar Mountain Accounting System, Peachtree, Quicken, Quickbooks, Btrieve, Lotus, Excel, Quattro Pro, Dbase, Rbase, Paradox, FoxPro, MS Access, Seagate Crystal Reports, MS Project, WordPerfect, MS Word, Multi - Mate Advantage, OrgPlus, Freelance, Harvard Graphics, Norton Utilities, MS PowerPoint, MS Publisher, MS Frontpage, HotDog Pro, HotMetal, Paint Shop Pro, Adobe Photoshop Deluxe, MapEdit, Visual Basic - Access, Excel, Acrobat Exchange, Fidelity. ADP Dealership, ADP Human Resources, IDX Healthcare, Dictaphone, Sentinel Vitalworks, MicroStrategy, LPS/MSP, LPS Desktop, FiServ, CoreLogic VendorScape

Computer Programming Languages: SQL, SQL Server, Visual Basic, VB Access, Access Macro Language, Crystal Report Language, HTML, Java, Javascript, CGI Script, SAS

Hardware: IBM AS/400, IBM System 34-36, IBM PCs as Mainframe terminals, Ethernet Networking Hardware, DOS and Windows based PC configurations, printers, plotters, scanners, CDROM R and RW, digital recording, installation and maintenance of PC parts, cards, chips, memory, hard drives, network components, maintenance and backup of PC server based network.

WORK EXPERIENCE:

BUSINESS ANALYST SENIOR

Confidential, Irving, Texas

Responsibilities:

  • Business Analyst Senior for Confidential Marketing Information Management.
  • Working with 3rd party vendor Acxiom for global financial institution acting as liaison and quality control for staging, uploading and merge of “Big Data” from multiple internal and external Citi sources.
  • Facilitating design, implementation and successful launch of additional data feeds into the existing system.
  • Also working with Customer Service to provide system application of privacy regulations Confidential customers’ request, answer questions and troubleshoot if necessary.
  • Providing documentation of existing department processes, including production procedures.

MIS ANALYST

Confidential, Fort Worth, Texas

Responsibilities:

  • Business Analyst for Loan Operations for this Internet based PayDay and Installment Loan lender.
  • Providing Reports and structure for Operations reporting, including interpretation of business actuals data, analysis and meaningful regular information related to Collections and Fraud departments.
  • Working extensively with SQL and SAS, MS Access, Excel and other related tools to build reporting.

MIS ANALYST

Confidential, Fort Worth, Texas

Responsibilities:

  • Business Analyst for Loan Operations for this Internet based PayDay and Installment Loan lender.
  • Providing Reports and structure for Operations reporting, including interpretation of business actuals data, analysis and meaningful regular information related to Collections and Fraud departments.
  • Working with SQL and SAS, MS Access, Excel and other related tools to build reporting.

SR. BUSINESS ANALYST

Confidential, Coppell, TX

Responsibilities:

  • Sr. Business Analyst consulting for Confidential providing documentation and procedural expertise for conversion of Confidential servicing legal departments’ workflow system tools from LPS Desktop to CoreLogic Vendorscape.
  • Working with Agile, SDLC and Six Sigma methodologies to document technical aspects of user MS Access databases and processes in preparation for future state unification of these legal processes, utilizing centralized data sources and streamlined processes. Gathering user stories to understand and communicate correlation of existing systems and ma nual processes.
  • Documenting multiple SQL Server data sources, including tables, databases, identification and definition of data fields, notifying client of duplicated sources in an effort to streamline data access and assure data integrity throughout the reporting of workflow systems and processes.
  • With over 1,000 users, 300+ procedures and thousands of tasks to be completed by attorneys, clients and vendors, this massive project has entailed gathering of process flow information from all parties involved, understanding and defining roles and boundaries, and providing organized, informative procedures while the new system is still being developed.
  • Writing policies and procedures to accompany future state systems.

SR. BUSINESS ANALYST

Confidential, Fort Worth, TX

Responsibilities:

  • Sr. Business Reporting Analyst for Confidential Financial Transactions Management Reporting and Analytics Dept.
  • Continued production of daily, weekly and monthly established reporting using SQL Server and Reporting, MS Access, Excel, MSP/LPS, FISERV and other data systems. Design and development of other forms of reporting summaries and analytics with these tools.
  • Using knowledge of Confidential servicing and associated transactions and procedures to provide functional solutions and automation to expedite reporting in a rapidly expanding environment.
  • Working with LPS/MSP Confidential Servicing systems and converting existing reporting to MicroStrategy as the company transitions from FISERV to LPS/MSP. Assets serviced/sub - serviced for agency and private investors.
  • Guiding extraction of data from MSP reports for MicroStrategy conversion to adhere to department requirements.
  • Providing reporting development and production services for Cashiering, Loan Accounting and Investor Reporting Depts Confidential various aggregate levels.
  • Development and maintenance of multiple MS Access database tools for processing, reporting and analysis of cash transactions, 500+ investor related bank accounts, communication between multiple departments, and a large volume of investor reporting of pool activity of assets. One tool provides multiple departments with up to the minute communication of reconciliation and issues status.

BUSINESS ANALYST

Confidential, Fort Worth, TX

Responsibilities:

  • Business Reporting Analyst for Confidential Financial Transactions Management Reporting and Analytics Dept.
  • Assumed production of daily, weekly and monthly established reporting using SQL Server and Reporting, MS Access, Excel, MSP/LPS, FISERV and other data systems.
  • Design and development of other forms of reporting summaries and analytics with these tools.
  • Using knowledge of Confidential servicing and associated transactions and procedures to provide functional solutions and automation to expedite reporting in a rapidly expanding environment.

BUSINESS ANALYST

Confidential, Dallas, TX

Responsibilities:

  • Repeat engagement for this Dallas based interior design company. Developed Summary reports for the CFO; combining three separate project detail reports into one high level project summary report utilizing Crystal 11.1 report and SQL query software and Deltek software specific to the interior design industry.

BUSINESS ANALYST

Confidential, Fort Worth, TX

Responsibilities:

  • Developing integrated tools for business assessment utilizing existing system modules from different vendors including billing data from Sentinel VitalWorks, IDX Healthcare clinic scheduling data and Dictaphone timestamp data, as well as internal scheduling data for this large provider of radiological healthcare in the Dallas Fort Worth metroplex Confidential hospitals and clinics.
  • Created MS Access tools for reporting and analysis of radiology business as well as user friendly interface tools for employees using SQL and VBA for Access.
  • Provided project management and documentation of all development and systems involved, as well as ongoing status reporting to executives and other parties involved.
  • Speeding up repetitive tasks with automated solutions Confidential reduced cost to the client.

BUSINESS ANALYST

Confidential, Dallas, TX

Responsibilities:

  • Developed MS Access Report databases for this young dealership which provides credit services along with sales of pre-owned vehicles.
  • Used SQL and VBA tools to provide reporting on daily status of sales and referrals, movement of merchandise.
  • Worked with data downloaded from ADP Dealership system paired with ADP Human Resources data to provide daily, weekly and monthly reporting for 6 stores.
  • Deployed databases in shared drive environment; trained personnel to run reports.
  • Provided experienced input for distribution of Acrobat PDF printed reports and other system solutions.

BUSINESS ANALYST

Confidential, Dallas, TX

Responsibilities:

  • Short term assignment to identify/troubleshoot systems issues for company Controller prior to rollout of a new customized system.
  • Developed new and modified existing Crystal reporting (specifically purchase orders) in a Business Objects environment.
  • Using Crystal SQL and query tools, provided cost effective and timely solutions.

SENIOR ACCOUNTANT/ BUSINESS ANALYST

Confidential, Grand Prairie, TX

Responsibilities:

  • Short term assignment to assist VP of Finance with furniture retail corporation’s fiscal year-end analyses and preparation of reserve amount calculations for accruals for fiscal year ending 2008.
  • Working with various departments and managers to obtain information necessary for completion.
  • Using MS Access, SQL, Excel, Word and Oracle based legacy systems for project completions.

BUSINESS ANALYST

Confidential, Irving, TX

Responsibilities:

  • Contracted by this Bear Stearns-owned corporation to maintain and enhance in-house MS Access database designed to track, report status and retain detail of bank account reconciliations related to 500+ investor accounts.
  • These accounts provide funding for 500,000 loans nationwide.
  • Completed enhancements; created new reports, set up a monthly reporting schedule.
  • Created input screens and other tools for users. Provided liaison services for Bank Recon and Investor Accounting Depts with IT to facilitate storage and speed improvements to shared drive. Developed automation for reconciliation of +/-1,000 bank accounts previously reconciled in Excel.
  • Developed automated download of Fidelity data and “FORT” data - a SYBASE in-house system - to provide automation of primary reconciliation steps. Extensive use of SQL and VBA.

SENIOR ACCOUNTANT/BUSINESS ANALYST

Confidential, Plano, TX

Responsibilities:

  • Contracted to develop and implement corporate financial reporting for this year-old Plano based distributor of orthopedic devices and equipment.
  • Working with a UNIX based mid-sized financial information system called TIMS, and its companion SQL query/reporting software Diver to build corporate monthly, quarterly and annual reporting for analysis and information, as well as daily snapshot/ scoreboard statistics.
  • Additionally building reports and analyses in MS Access and Excel for 22 branches, 6 regions, etc.
  • Recommendations on best tools to use for different types of reporting for accounts receivable, collections, claims tracking, etc.

FINANCIAL REPORTING/BUSINESS ANALYST

Confidential, Denton, TX

Responsibilities:

  • Contracted to develop and implement corporate financial reporting for Confidential ., holding company for several makers and distributors of welding and gas equipment.
  • In the newly formed corporate office Confidential the Victor location in Denton, Texas, used MS Access, SQL and downloads from Confidential Accounting and Inventory systems to produce monthly and quarterly financial and inventory analysis, stored and calculated in Access and exported to Excel for reporting and further analysis.
  • Produced reporting to assist with year-end decision-making processes; applications contain continued trend analyses to be used going forward.

BUSINESS ANALYST, SYSTEM AUDITOR

Confidential, Irving, Texas

Responsibilities:

  • Contracted to audit Lawson GL, Inventory and Sales systems security for SOX Audit Compliance for this distributor of aviation parts to government, defense and commercial airline companies. Auditing global security network in Lawson version 7 in preparation for upgrade to Lawson 8.1.

BUSINESS ANALYST, SYSTEM AUDITOR

Confidential, Dallas, Texas

Responsibilities:

  • Contracted to audit Confidential System’s new Internet based Human Resources system, comprised of Confidential HRWorkWays individually delivered software on a PeopleSoft platform.
  • Reviewing all aspects of the system, including processes used by employees, managers and Human Resource representatives.
  • Reviewing and testing Hewitt’s implementation of client-specific process requirements within the standard software, as well as the functionality of the software itself.
  • Reporting to the HRWorkWays Coordinator on the results of numerous tests. Additionally testing calculations and output.

BUSINESS ANALYST/ACCESS/EXCEL DEVELOPER/CONSULTANT

Confidential, Dallas, Texas

Responsibilities:

  • As a consultant to the Reporting & Scheduling Team for the rollout of a new technology in the wireless industry, assumed responsibility for updating and maintaining an Access database built to coordinate installation.
  • Used Visual Basic for Access and VB for Excel, as well as SQL for Access, to maintain this system of Access databases and Excel spreadsheets used to update this system. Using Citrix, FTP, TelNet, SCP and SSH to download data from NMS servers containing live status data from six regions used to guide the installation process.
  • Developed Trouble-shooting applications for both the Confidential &T Wireless and the Cingular Wireless rollout processes that automatically update the Master Schedule with relevant data as soon as the trouble-shooting team inputs the resolutions.
  • Developed separate Access database for Confidential customer Cingular Wireless to monitor newly installed site activity to identify potential issues and troubleshoot them effectively and timely.
  • Developed similar separate Access database for Confidential customer Confidential &T Wireless to monitor newly installed site activity to identify potential issues and troubleshoot them effectively and timely. Combines data from five different sources and provides a real time on-line updating facility.

BUSINESS ANALYST/ACCESS DEVELOPER/CONSULTANT

Confidential, Dallas, Texas

Responsibilities:

  • Working for the Studio Revenue Sharing Dept. of Blockbuster Inc. ’s Accounting and Finance Dept., assumed responsibility for updating and editing Access database method of downloading and calculating Revenue Share Due studios for test of new Blockbuster Inc. monthly Pass products. Transaction activity is stored in Oracle tables; in excess of ½ million records per accounting period must be downloaded and manipulated. Responsible also for the monthly production of the report.
  • Created Pass Program Summary Report, using MS Access and Excel to produce a multi-year trend report for analysis of the tested Pass Program activity and resulting Revenue Share Due.
  • Used SQL and VBA to create reports and analyses.
  • Created Access database application to facilitate the monthly accounting period reconciliation of the main Revenue Sharing General Ledger account. Downloaded data from AS/400 based Confidential Financial Accounting System for reconciliation and analysis. Account cash flow exceeds $100 million/yr., with detailed multi-line journal entries to reconcile.
  • Completed detailed analysis of Columbia title activity over a 3 year period of time, combining data from multiple sources to create a database analyzing accrual vs. actual payment activity. Completing analyses for the remaining studio clients.

FINANCIAL REPORTING/BUSINESS ANALYST

Confidential, Denton, TX

Responsibilities:

  • Contracted to develop and implement corporate financial reporting for Confidential ., holding company for several makers and distributors of welding and gas equipment.
  • In the newly formed corporate office Confidential the Victor location in Denton, Texas, used MS Access, SQL and downloads from Confidential Accounting and Inventory systems to produce monthly and quarterly financial and inventory analysis, stored and calculated in Access and exported to Excel for reporting and further analysis.
  • Produced reporting to assist with year-end decision-making processes; applications contain continued trend analyses to be used going forward.

BUSINESS ANALYST, SYSTEM AUDITOR

Confidential, Irving, Texas

Responsibilities:

  • Contracted to audit Lawson GL, Inventory and Sales systems security for SOX Audit Compliance for this distributor of aviation parts to government, defense and commercial airline companies. Auditing global security network in Lawson version 7 in preparation for upgrade to Lawson 8.1.

BUSINESS ANALYST, SYSTEM AUDITOR

Confidential, Dallas, Texas

Responsibilities:

  • Contracted to audit Confidential System’s new Internet based Human Resources system, comprised of Confidential HRWorkWays individually delivered software on a PeopleSoft platform.
  • Reviewing all aspects of the system, including processes used by employees, managers and Human Resource representatives.
  • Reviewing and testing Hewitt’s implementation of client-specific process requirements within the standard software, as well as the functionality of the software itself.
  • Reporting to the HRWorkWays Coordinator on the results of numerous tests. Additionally testing calculations and output.

BUSINESS ANALYST/ACCESS/EXCEL DEVELOPER/CONSULTANT

Confidential, Dallas, Texas

Responsibilities:

  • As a consultant to the Reporting & Scheduling Team for the rollout of a new technology in the wireless industry, assumed responsibility for updating and maintaining an Access database built to coordinate installation Confidential 15,000+ sites across North America for their customer, Confidential &T Wireless.
  • Used Visual Basic for Access and VB for Excel, as well as SQL for Access, to maintain this system of Access databases and Excel spreadsheets used to update this system. Using Citrix, FTP, TelNet, SCP and SSH to download data from NMS servers containing live status data from six regions used to guide the installation process.
  • Developed Trouble-shooting applications for both the Confidential &T Wireless and the Cingular Wireless rollout processes that automatically update the Master Schedule with relevant data as soon as the trouble-shooting team inputs the resolutions.
  • Developed separate Access database for Confidential customer Cingular Wireless to monitor newly installed site activity to identify potential issues and troubleshoot them effectively and timely.
  • Developed similar separate Access database for Confidential customer Confidential &T Wireless to monitor newly installed site activity to identify potential issues and troubleshoot them effectively and timely. Combines data from five different sources and provides a real time on-line updating facility.

BUSINESS ANALYST/ACCESS DEVELOPER/CONSULTANT

Confidential, Dallas, Texas

Responsibilities:

  • Transaction activity is stored in Oracle tables; in excess of ½ million records per accounting period must be downloaded and manipulated. Responsible also for the monthly production of the report.
  • Created Pass Program Summary Report, using MS Access and Excel to produce a multi-year trend report for analysis of the tested Pass Program activity and resulting Revenue Share Due.
  • Used SQL and VBA to create reports and analyses.
  • Created Access database application to facilitate the monthly accounting period reconciliation of the main Revenue Sharing General Ledger account. Downloaded data from AS/400 based Confidential Financial Accounting System for reconciliation and analysis. Account cash flow exceeds $100 million/yr., with detailed multi-line journal entries to reconcile.
  • Completed detailed analysis of Columbia title activity over a 3 year period of time, combining data from multiple sources to create a database analyzing accrual vs. actual payment activity. Completing analyses for the remaining studio clients.

BUSINESS ANALYST/ACCESS DEVELOPER/CONSULTANT

Confidential, Dallas, Texas

Responsibilities:

  • Developed standardized reporting for the Payroll Dept. in MS Access and Crystal Reports for dept. managers using SQL and query tools; automated the monthly submission of general ledger journal entries to the Accounting Dept.
  • Developed automated reconciliation to verify data integrity between the major monthly reports.
  • Completed documentation and procedures for each of the reports and databases developed.
  • Developed archival of monthly data retrieved, and automated reproduction of previous months’ reports, as well as facilities to produce report department detail upon ad hoc request to the Payroll Dept.
  • Developed monthly employee turnover reporting for the Human Resources Dept., including analyses calculations, charts, trend reporting and automated production and archival.
  • Developed Paid Time Off Buy Back report database and employee statement producing system for use by benefits to collect information and pay employees “Buy Back” eligible hours of unused leave each 6 months.
  • Produced report database for state required Workman’s Comp annual accounting.
  • Produced documentation and user level procedures for all database venues developed.

Hire Now