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