Senior Consultant Resume
SUMMARY:
- Analytical Applications Architect Business Intelligence Applications - Experienced in successful management and team building with diverse groups of people with in-depth understanding of emerging technologies and their practical applications. Architect business intelligence in interaction with multiple systems and software applications.
- Implementing business intelligence and informatics solutions
- Bridging the gap between development, design and management teams
- Managing programs and projects including selecting systems and software
- Initiating and sustaining process improvement
TECHNICAL SKILLS:
Languages: Assembler (mainframe), AS/400 CL, Basic, C/C++/C#, COBOL, FORTRAN, HTML, IBM 370 JCL, Java, MDX, Pascal, Perl, PL/I, R, RPG400, RPG-ILE, SAS, SQL, Visual Basic.
Software: Analysis Services (Microsoft OLAP); Access (95-2007); Application Studio; ASP; BPA 10; BPC; DBU; DTS; Excel;FDC (GEAC; Comshare); GEAC Infor MPC (CPM) V4.5 through 10.4 (BPA); Hyperion Financial Management; J.D. Edwards; KBSQL; LMS IV & V; Microsoft Dynamics/Financials (Great Plains); MPC (Infor GEAC Comshare) V4.5; through 10.4; MS Office; Microsoft BI Suite; MS Project; Oracle PL/SQL;Oracle BI Desktop; Oracle BI Cloud; OutlookSoft; Pagemaker; PerformancePoint; Photoshop; PM10; QlikView; QlikSense; Quick Books; Quicken; Rippe & Kingston LMS IV & V; SQL Reporting Services(SSRS); SAP BPC; SAS; SAS FM (4.2; 4.3); SAS HCM; SharePoint; SPSS; SQL Anywhere; SSIS; SSMS; SSRS; Tableau; Talend; Visio; VBS; Visual Studio; VSAM; Websphere. ETL programming in MS-BIDS, Talend, SAS.
Databases: MS SQL Server ; AS/400 DB2 (iSeries); HBOC on UNIX; Hive; Linux (Red Hat); MySQL; Oracle (9-12); PostgreSQL; Raintree; Sybase IQ; Unix;
PROFESSIONAL EXPERIENCE:
Senior Consultant
Confidential
Responsibilities:
- Delivered ten successful new full cycle Business Intelligence software implementations and seven upgrades including customizations and additions of functionality.
- Achieved three successful data warehouse designs and implementations including one with a unique calendar-weeks-in-month reporting calendar.
- Guided four fiscal year conversions; and implemented complicated automated load and consolidation processes including designing formulas with custom drivers for five companies.
- For one subsidiary of Confidential & Confidential, developed custom sales reporting with automated distribution resulting in sales figures emailed out to international sales staff one hour after final daily figures reported.
- Increased visibility into Confidential t care, prescribing patterns and profitability for two hospitals and a clinic using QlikView as the front end delivery for custom data warehouses combining data from multiple source systems.
Manager
Confidential
Responsibilities:
- Helping a client resolve a significant reconciliation issue between their transaction system and General Ledger by identifying and quantifying the issues, fixing the problem, and putting the controls in place to ensure the errors would not happen again.
- Rescued a client implement of a CPM package after the client had tried and failed twice previously without assistance. Instrumental in understanding why the previous implementations had failed, developed a more reasonable approach, and utilization of the software for the client implementation to be successful.
Programmer/Analyst
Confidential
Responsibilities:
- Realized the Chief Financial Officer’s vision of a Management Dashboard opening with four quadrants leading to detailed information - first person to integrate Comshare and SharePoint websites to realize this vision.
- Created and maintained accounting and financial analysis programs including identifying and correcting Y2K potential issues before they became problems.
- Implemented a programmatic data consolidation and extraction for the annual partnership contribution reporting reducing the report preparation time from three weeks to three hours.
- Recognized gaps in processes and designed solutions then persuaded stakeholders to adopt those solutions becoming the ad-hoc systems integration specialist. Integrated Microsoft applications, Lotus Notes/Domino, intranet applications, SQL Server and iSeries (AS/400).
