We provide IT Staff Augmentation Services!

Business Analyst Resume

Atlanta, GA

OBJECTIVE:

Permanent Application Analyst/Data Analyst/Developer position solving large - scale implementation or data analytics & reporting challenges

SUMMARY:

  • 20 year history of cost savings and efficiency improvement leading to improved company performance
  • More than 10 training and/or compliance programs developed, documented and implemented
  • Technical Lead and Project Management roles in selection and implementation of 10 large impact software integrations including:
  • EDI creation, implementation and support for a warehouse and distribution division,
  • PeopleSoft GL, Payroll, HR and Budgetary package,
  • Oracle Financials PTM module implementation/integration

TECHNICAL SKILLS:

Networking: Windows based LAN, Citrix LAN support, Active Directory, DNS, Exchange, Server 2K and 2003 and limited Novell network

Programming: COBOL, RPG4 ILE, VBA, SQL and PL/SQL

Database (development & admin): Access, SQL 2K & 2005, 2008(ETL&SSIS), Oracle 10g, HP3000, MySQL

Reporting: Business Objects Reports, Oracle Reports (10), Oracle Discoverer, MS SQL, Access, ExcelDeveloper in all MS Office (Excel, Access, Word, Powerpoint, Outlook) apps including interoperability

Specific Software Experience: PeopleSoft implementation; Financial/Payroll/Accounting, MAS 90/200/500, American HealthTech LTC, McKesson Horizon Homecare, MestamedEDI Implementation (multiple) ANSI X12 format Oracle 12 (Inventory, Material Management, Planning) Supply Chain; Quest TOAD; SQL Navigator Accounting, Healthcare/Insurance Operations, Healthcare AR claims and Financial Reporting, Payroll/HR/Benefits reporting and data acquisition, SQL Database Administration on MS 2K & 2005 Visio, MS Project, Veritas Backup Exec, Friendly EDI, FrontPage, Photoshop, QuickBooks Pro, Adobe Distiller & Acrobat

SDLC, Waterfall development methodologies: Demonstrated user and management interaction skills in specifications interview, presentations, training sessions and demonstrations

PROFESSIONAL EXPERIENCE:

Business Analyst

Confidential, Atlanta, GA

Responsibilities:

  • Grew data throughput to proprietary SQL Server analytic model 300% via creation of or improvement of SSIS ETL packages processing 15 insurance clients casework data
  • Handled doubling of client load while providing improvement of lead quality to a call center that double in size and tripled in volume
  • Technical lead in client integration team updating all specification documentation
  • Created documentation for client data file processing and created a backup plan should initial SSIS package processing fail
  • Inspected and cleaned several gigabytes of client input data
  • Created automated business reporting for all clients which did not exist previously

Contract Data Analyst

Confidential, Atlanta, GA

Responsibilities:

  • Maintained and improved query logic across multiple DB formats and ERP using MircoStrategy for Legal Dept project relating to CMA
  • Decoded proprietary software package used to oversee all Medical Research spanning Confidential and Emory Medical System to create a reporting repository which would allow easier reporting on all medical research

Sr. Business Analyst

Confidential, Norcross, GA

Responsibilities:

  • Develop, edit and automate large weekly prospect data loads from diverse external systems to MS SQL2005 via SSIS
  • Provide all routine and ad hoc reporting of operations, accounting&finance, regulatory, SOX, HR and compensation, external contracted data reporting and multiple state PSC submissions via Excel, MS SQL formatted reports and limited SSRS
  • Provide primary and secondary application troubleshooting and user assistance for the proprietary web-based application on top of several MS SQL2005 databases

Sr. Data Analyst

Confidential

Responsibilities:

  • Developed JAVA served parameter driven web-based reports to provide department and senior level management real-time metrics and statistics to allow them to more effectively manage
  • Conducted user interviews and specification gathering
  • Developed highly customized graphically presented information in Oracle Reports that was user parameter driven
  • Used SQL Navigator, TOAD, ReportBuilder to develop and deliver rapid-turn-around ad hoc statistical trend based reports
  • Served as defacto department technical representative at several state-wide report development initiatives

Software Developer

Confidential, Duluth, GA

Responsibilities:

  • Use MS Project for project tracking and reporting
  • Utilize TOAD and Oracle Discoverer for data pull development and automation
  • Part of Oracle Financials 12 implementation group devoted to Supply Chain and division-wide planning
  • Acted as both Business Analyst and Developer interviewing users and stakeholders. Determined full business process, redesigned program to solve existing implementation issues as well as created technology and a path to a unified enterprise constrained planning solution
  • Wrote Functional Spec, re - designed user interface to cut 50% time from planning session
  • Brought together technology and people from within IT infrastructure, data systems and on-site consultants to create platform for new enterprise level constrained planning system
  • Documented, assisted in designing QA testing and trained users on the new system

Network Administrator/DBA

Confidential, Atlanta

Responsibilities:

  • Used SQL and PL/SQL to update and maintain live date in SQL 2005 and Oracle 8i environments
  • Provided financial and operations reporting using Crystal, Excel and transact SQL
  • Provided 24/7 end user and server room support to remote and local users as well as a mobile sales force
  • Installed, maintained or upgraded workstations and servers in a Windows 2K/2003/Exchange environment
  • Upgraded and limited development in ASP/XHTML/JavaScript for web-based line of business
  • Used Frontpage for other web projects as required
  • Administered Citrix 1.8 terminal services environment
  • Administered Active Directory, DNS and Exchange for local and remote office LAN’s
  • Limited administration of Novell network
  • Administered of Fujitsu 9600 PBX
  • Administer Veritas Backup Exec
  • Rapidly learned (4 weeks) operational needs and financial reporting needs through informal user interviews
  • Re - developed reports to increase automation and cut monthly reporting cycle by 40%
  • Based on interviews with financial personal, determined previously unknown data requirements which allowed me to correct data issues which had prevented and accurate month end closed for 9 months
  • Laid off due to severe business financial problems

Reports Administrator

Confidential, Atlanta

Responsibilities:

  • Responsible for developing, upgrading and overhauling poorly designed reports that were key to Sales Team Performance, Executive Management and Operations for this $300 M internet mortgage broker. Additionally I was responsible for creating and maintaining views and tables which were extracts of the production system and solely used for reporting.
  • Used transact SQL to update and maintain live data on an SQL 2005 database
  • Used Crystal Reports 11 to do operations and financial reporting
  • Used and administered Data Viewer to deliver reports real-time and via batch jobs I created to viewing folders

Crystal Reports Writer/Data Analyst/Developer

Confidential, Norcross, GA

Responsibilities:

  • Sole Developer, creating and distributed all non-financial ad hoc reporting to all 9 divisions of the Enterprise.
  • I used Crystal Reports and Excel to create regular automated data extracts which were critical feeds for our old MAS90/200 accounting/payroll/benefits system and the replacement PeopleSoft ERP system.
  • Developed reports and data extract programs which save the company $168K in labor cost over my final 14 months.
  • Used Excel and Access with embedded VBA pulling data from various ODBC compliant databases
  • Crystal Reports 8.5 and 9 and to a limited extent Enterprise server
  • Cleaned and maintain data integrity with SQL jobs I developed
  • Modified SQL procedures to develop new data extraction or reporting products
  • Used VBA and T-SQL to develop all legacy system dataloads to the PeoplSoft modules
  • Used BizTalk for app-to-app data transfers
  • Acted as Business Analyst and developer, interviewing and developing process automation solutions for 6 of the nine divisions and all but one of the corporate office departments including Finance, Accounting, AR, Payroll, HR and AP.

Applications Administrator and DBA

Confidential

Responsibilities:

  • Lead Administrator overseeing user access, program setup and performance, software implementation and upgrades for 375 apps including 14 mission critical financial and clinical systems for a 4 state multi-divisional healthcare system.
  • I was responsible for the installation and testing or coordination of testing of upgrades and 2nd or 3rd level application support and troubleshooting.
  • Also I coordinated all vendor access. Key technical member of all software evaluation, selection and implementation.
  • Served as Backup DBA and setup all original backup and restore protocols for 3 application databases on a SQL 2000 server
  • Setup, administered, upgraded and troubleshot LTC (AR/Clinical system) on SQL 2K platform for Southeastern US Nursing Home Division
  • Setup, administered, upgraded and troubleshot Horizon Homecare (AR/Clinical system) on SQL 2K for Southeast US Homecare and Hospice Division
  • Administered, upgraded and troubleshot MAS90/200 Accounting (ProvidEx) system in a MS Sever 2003 platform
  • Implemented, administered, upgraded and troubleshot MAS90/200 Warehouse and Distribution system
  • Implemented, administered, upgraded and troubleshot Mestamed (AR/Clinical system) for state-wide Patient Care Management system
  • Support DBA for SQL 2000 and to an limited extent Oracle 8i databases
  • Process Automation and reporting for Accounting, Finance & Operations utilizing Excel and VBA
  • Used Friendly EDI to created, implemented, train users and supported EDI interface to warehouse & distribution division per supply chain requirements

Hire Now