Director Of Bi/analytics Resume
SUMMARY:
- 20 Years of IT experience - Have seen data from every possible angle.
- 10+ years in planning/execution of infrastructure and operations of SAP Business Objects products.
- Extensive knowledge and experience in the Business Intelligence/Data Warehousing field. Working knowledge of AZURE and AWS Cloud ecosystems, ETL/ERD Tools (Informatica), Cognos, SAP BW, Oracle,MYSQL, Teradata, SQL Server SSIS/SSRS, Rochade (MDM).IBM Unica. Netezza DB.
- SAP Business Objects Subject Matter Expert.
- Cognos ReportNet Certified Designer
- Working knowledge of Unix/Linux
- Extensive experience with Federal and State Government.
- Health Care and Pharmaceutical experience.
- Proven track record of training/motivating others to work within proper BI/Data standards.
- Managed/Led/Mentored on/off shore development of software and reporting.
- Managed groups of 5-25 in development/deployment of BI solutions.
- Project management using “agile-esque” methods. SCRUM and WBS sprints.
- ITIL aligned service management strategies and processes
TECHNICAL SKILLS:
Operating Systems: Unix (Solaris, AIX, HP-UX), Linux, Windows 2008/XP/7/10, AZURE and AWS Cloud ecosystems
Programming and Scripting Languages / Methods: Restful Services; Java, Javascript, C#, PHP, SQL,MDX; HTML/DHTML, XML, UML. SOA api broker and consumer wsdl generation and programming
Source Code Control: RCS, CVS, ClearCase, GIT.
Web Application: Apache/Tomcat, MSI-IIS, Websphere (WAS), BEA Weblogic Application Server, web Methods Active Works, Netegrity, CA-Site Minder Secure Portal Server.
Database: MS-SQL, Informix, Oracle/Exadata, DB2, Sybase, GreenPlum, Teredata, HANA, WebServices-WSDL.; Netezza; MySQL
Directory: AD/Kerberos. LDAP.;SAML SSO;SPENEGO
Tools: SAP Business Objects Business Intelligence Platform Products (XI.3.x/BI4) including IDT/UDT(Universe design); Dashboards(formerly Xcelcius), Webi, Crystal Reports and Info View, Business Objects SDK, Business Objects XI Integration Kit for SAP ; HANA . Cognos reportnet Enterprise (;Report Studio, Analysis Studio, Query Studio, etc); MS- SSIS/SSRS ; PowerBI; BIRST, Black Baud Rasiers Edge and Financial Edge, Tableau
WORK EXPERIENCE:
Confidential
Director of BI/Analytics
Responsibilities:
- Deliver vision for BI and Analytics
- PowerPoint ppt developed displaying vision steps
- Illustrate 3 Phases of BI maturity
- Giving Back to the Business
- Upskill of Resources to Analytic Professionals
- Roll out of Advanced Analytics
- Reveal the plan to successful deployment
- Vendor Selection and Bake Off
- Demonstrate Vendor Options
- HTML 5 Ability
- Self Service Reporting
- Present Pro vs Con
- Show gaps in functionality of existing and align to recommendation for solution.
- Highlight Skill requirements
- Provide story to solution framework for POC's
- Produce Business Case for Executive Review
- Goals
- Objectives
- Needs
- Recommendation
- Recommend and Review Existing Staffing for applicability to proposed solution
- Recommend Training
- Foster Culture Change ie. BI and Data centric Organization
Confidential
Contractor - onsite, Phoenix Arizona
Responsibilities:
- Present kickoff for BI realignment
- PowerPoint ppt developed in coordination with MMI director of technology
- Illustrate 4 Pillars of BI effort
- Backlog to Worklog
- Executive Dashboard
- SAP HANA
- Training and Culture
- Reveal the plan to success
- Develop and Execute Backlog to Worklog plan
- Make helpspot ticket repository source of record
- Decommission JIRA
- Attach helpspot HS# to every request for service.
- Provide metrics to show open/close, new/problem/change across all business areas
- Develop dashboard for executive oversight
- Foster team global team (AZ,South Africa,UK and offshore support) development into service and subject matter aligned role matrix
- Highlight pain points for risk / mitigation
- Provide story to solution framework for POC's
- Manage Data Model project
- Manage Executive Dashboard Project
- Manage Training and Culture Project
Confidential
Business Objects SME
Responsibilities:
- Design of Business Objects reports against hosted Collegue Universes integrating 5 sources into 1 single view
- Redesign/Modify existing BO reports,
- Track requests via. Service Now
- Provide mentoring and design assistance as tool SME.
- SQL Integration: oracle/mysql, ms-sql, noSQL
Confidential
Senior Engineer
Responsibilities:
- Sustain and Support Enterprise Business Objects environments. Daily interaction with end users.
- Sustain and Support Enterprise Unica Cognos environments. Daily interaction with end users.
- Proper Service Management -ie responding to RM/RF C/ Confidential assignments.
- Mentor end-users and Business Partners on proper utilization of SAP Business Objects products.
- Design of customized Cognos reports for Unica Campaign Management; BIG data integration presenting digital analytics mashed up with campaign planning data.
- Cognos Report conversion and redesign.
- Design of Business Objects Reports for Digital (ie. Dot com) business line.
- Excelcius dashboard design utilizing GIS data to mapping .
- Restful API SDK: SOA using JSON and XML for meta data analysis in BO stack.
- SQL SSRS/IS/AS data analysis and visual reporting
- Oracle RDBMS table/view remote procedure creation
Confidential
Senior Business Intelligence Developer
Responsibilities:
- Sustain and Support Enterprise Business Objects environments.
- Adhere to ITIL in responding to RM/RF C/ Confidential assignments.
- Management of contractor(s): reporting and universe development
- Mentor end-users and Business Partners on proper utilization of Business Objects products.
- Promote innovation in design and support. “Working Smarter not Harder”
- Design “smart-dates” solution to provide time dimension control to Teradata connection Universes.
- Provide Developer expertise in solving reporting inefficiency experience with SIMBA - merchandise reports/universes.
- On Call support for BO Sustainment
- MS SSRS/SSIS customized reporting for log shipping POC.
- Conversion of MS SSRS/SSIS reports to business objects webi and xcelcius dashboard.
- Partner with Configuration Management to modernize reporting and analysis via Xcelcius Dashboards and Web I reports.
- Development of Proofs of Concept (P.O.C).
- Interface with business partners to promote and discuss Business Intelligence inside of the Confidential World Organization.
- Global design support as sole Universe Developer for Shang Hai Confidential World Ticketing inception phase.
- Multi Source Universe Oracle/DB2/Teradata Unx design for Disney Vacation Club using IDT.
- SQL SSRS/IS/AS data analysis and visual reporting
- Oracle RDBMS table/view remote procedure creation
Confidential
BI Architect (BO SME)
Responsibilities:
- Authored project deployment methodology, comprised of multiple decision trees and prioritization matrices, effectively aligning BICCC schedules with project WBS.
- Designed enterprise shared server environment, comprised of development, test and production environments to provide Business Objects functionality IRS wide.
- Technical management of BICCC contributor roles. (ie. Designers/Security/ChangeManagement)
- Multi-site federation, redundancy of service requirements addressed in place and in Disaster Recovery (DR) plan.
- Interface with C level executives to promote and discuss Business Intelligence inside of the IRS.
- Design and implement secure authentication and authorization via silent single sign on (sSSO) and SSL.
- Design and Implement security broker interface for negative TIN requirements for all SBU data.
- Conduct periodic webinars and/or seminars to promote BI and BOE use in the IRS.
- Design content management procedures and role assignments.
- SQL SSRS/IS/AS data analysis and visual reporting
- Oracle RDBMS table/view remote procedure creation
- Respond to customer requests for technical support of Business Objects products and assign course of action.
- Guide client in planning/execution of infrastructure and operations of Business Objects Products.
- Monitoring IRS business unit reporting and compliance to align functional requirements with BI roadmap.
- Perform project assessment through engagement process.
- Provide customized training in Business Objects tools for projects and/or direct projects to approved training.
- Mentor internal/external teams in the design and release of all BI products.
Confidential
BI Architect
Responsibilities:
- Led reporting team tasked with producing BO financial reports for the Confidential for the Confidential .
- Led reporting team tasked with producing reports for the User Fee Collections (Prism, MDUFMA, PDUFA, ADUFA, Color Certifications).
- Produced customized reporting solutions and universes. Re-engineered and streamlined existing universes and reports.
- Managed Data Warehouse load scripts and ETL routines as Data Architect.
- SME in recommendations and integration of DI/BW COTS products.
- Performed specialized offsite training and custom design at National Toxicology Research Center, Arkansas.
- Interview all perspective DI and BO contractors, and make recommendations.
- Interface with client senior management on risk analysis scheduling and training.
