Senior Business Intelligence Analyst Resume
2.00/5 (Submit Your Rating)
Houston, TX
SUMMARY:
- Drives Project Effectiveness / Builds Effective Teams and Partnerships
- A leader in all aspects of a project’s lifecycle, adept at bridging the gap between business and IT to deliver business intelligence solutions to support business analytics that drive efficiencies.
- Highly skilled in requirements discovery and tracking, logical and technical design, and solution testing strategies.
- Streamlines internal processes and documentation to positively affect customer and team engagement and satisfaction throughout the project.
EXPERTISE INCLUDES:
- Business Intelligence
- Business and Systems Analysis
- Logical and Technical Design
- Data Warehousing
- Data Integration
- Solution Testing Strategies
TECHNICAL SKILLS:
Methodologies: Waterfall, Agile, SDLC, Quality Assurance, User Acceptance, Prototyping, Advanced SQL, Business Requirements Management, Business Process Analysis
Tools: MicroStrategy, Business Objects XI, Oracle, TOAD, Netezza, SharePoint, SQL Server 2008, BMC Remedy, Visio, MS Project, Office, Aginity
PROFESSIONAL EXPERIENCE:
Confidential, Houston, TX
Senior Business Intelligence Analyst
Responsibilities:
- Led projects to design and build enterprise wide analytical views of verified trusted enterprise master data from an enterprise data warehouse.
- Served as IT point of contact with business; defined requirements, created mockups, led design sessions, created test cases and led QA and user acceptance testing.
- Led activities of core project team members leading projects to successful implementation.
- Analyzed data sources and documented source definitions, attributes, facts and dimensions, while leading a team of five business analysts through source data analysis and testing to normalize and integrate enterprise data from 15+ source systems creating the enterprise data warehouse.
- Led effort to design and implement customer and salesperson revenue reporting.
- This effort enabled sales and marketing senior leadership to focus efforts on segments that would maximize profit. Led client meetings and design sessions, gathered and documented requirements, created business process maps, and worked with business partners to ensure business success criteria were met.
- Served as functional lead to design and build BI dashboards that enable pricing, marketing and sales management the ability to identify areas with customer fee compliance issues and track area performance to set revenue goals. Streamlined monthly reporting process and increased pricing department efficiency by significantly reducing the steps required to obtain compliance data.
Senior Business Analyst
Confidential
Responsibilities:
- Led IT team members through new reporting requests, enhancements, and maintenance and support initiatives.
- Key deliverables included release requirements, user guides and quick reference documentation.
- Coordinated development, led and conducted quality assurance and user acceptance testing.
- Performed client support and managed level of effort with realistic expectations.
- Served as lead business analyst on SharePoint 3.0 to SharePoint 2007 upgrade project, enabling employee collaboration and knowledge sharing across the organization for 18K users.
- Trained corporate site owners on managing user access and creating and managing site content.
- Coordinated development efforts among cross - functional IT team members to convert legacy operational and regulatory reporting and provide self-service reporting through Business Objects XI. Created and worked with business partners to publish reporting user guides and report catalog.
- Provided functional and ad hoc super-user training for Business Objects.
- Documented Informatica ETL Data Value mappings, which included source to target mappings and business rules used for ETL development.
- Worked with ETL team to analyze data anomalies and/or testing of integration code.
- Provided ongoing functional and technical second level user production support for legacy reporting systems created in PowerAnalyzer, Business Objects, ASP, ArcPlan, and ASP/Essbase Solutions.
- Utilized Microsoft office, Visio, and TOAD to support and accomplish specific business analyst/data analyst tasks on daily basis.
- Participated in project initiation, gap analysis, design, development, and review meetings during PeopleSoft 7.5 to 8.0 upgrade.
- Tracked risks, assumptions, dependencies and provided weekly project status to senior leadership. Managed resource allocations and capacity planning, forecasting future project resource demands.
Confidential
Project Assistant
Responsibilities:
- Provided project support to multiple IT departments to track project tasks against timeline and identified milestones in MS Project.
- Served as administrator for project tracking software; responsible for managing resource allocations across multiple projects and capacity planning along with managing project and resource costs and budgets.