Business Intelligence Analyst Resume

OBJECTIVE

To secure a challenging position in your company where my technical knowledge and experience, extensive experience in dealing with business customers, and communication abilities will be useful in the further progression of the company and me
Over 10 years of experience in identifying customer requirements and providing the required assistance to corporate customers
Over 7 years of experience in the Data Warehouse and Business Intelligence Industry.
Expertise in Dashboard and Report development.
Expertise in gathering requirements for BI implementation.
Experience in implementing end - to-end data warehousing solution.
Expertise in designing and optimizing queries for use in reports and dashboards.
Experienced in ETL using SSIS.
Experience with several reporting tools like (SSRS, MicroStrategy, Crystal Reports, Tableau, Power BI).
Expert in Microsoft Transact-SQL programming with the ability to optimize, analyze and improve database SQL performance.
Extensive hands-on experience developing business intelligence solutions; data cubes, dashboards and reports using MicroStrategy
Strong understanding of data modelling techniques as relates to data warehouse design.
Experience with data quality, data cleansing and data stewardship processes and techniques
Ability to solve complex data problems by analysis, develop appropriate solutions and clearly communicate those solutions to the team.
Ability to work efficiently and provide accurate time estimates for work to be undertaken.
Strong Analytical thinker with expert problem-solving skills.
Worked in several roles where I had to build and maintain good customer relations.
Strong written and verbal communication abilities.
High energy, flexible, quick learner and achievement-oriented individual.

TECHNICAL SKILLS

SAP BI: Web Intelligence, IDT, UDT, HANA, Dashboard, Crystal Reports 2011, Dashboard, XCelsius, BI Web Services, BW, BEx Query, BODS, Universe Migration, CMC Administration

Microsoft BI: SSIS, SSAS, SSRS, Excel, Power Pivot, Power BI, MicroStrategy

Programming: SQL, C++, C, Visual Studio.NET, Java, LabVIEW, HTML

Operating Systems: Windows (2000, 2000 Server, 2003 Server, 2008 Server, XP, Vista, 7), Linux, Mac, SQL Server, File Server, Exchange Server, FTP Server, Web Server

Database: Access, SQL Server 2000/ 2008/2012/2014/2016 , Oracle

PROFESSIONAL EXPERIENCE

Business Intelligence Analyst

Confidential

Responsibilities:

Developed the entire BI infrastructure for the Control Centre which manages the operations of all the DriveTest Centre’s in Ontario
Played a key role in the implementation of our Data Warehouse (DW) and Business Intelligence (BI) Implementations
Developed and managed databases in Microsoft SQL Server 2008/2012/2014/2016
Developed ETL solution for all data loads using SSIS
Developed and managed cubes in SSAS which were used in our dashboarding solution
Developed and optimized queries in Transact-SQL
Developed interactive Dashboards and reports in Microstrategy which were used by Senior Management to view the performance of operations
Configured and maintained the backend of our custom Dashboarding solution
Worked with finance to provide financial reporting for upper management
Worked with vendors to develop the requirements for the infrastructure upgrades
Provided the technical requirements for our new systems which will manage the online booking and automated scheduling of staff for all offices

Business Intelligence Specialist

Confidential

Responsibilities:

Was involved in the migration of the entire data warehouse/reporting infrastructure from the IBM data center to a cloud computing environment.
Aided in the design of data warehousing solution
Was responsible for all the Administrative tasks required to ensure the BO servers were functioning.
Was responsible for building/maintaining universes in BO 3.1 x and 4.0. Designed reporting infrastructure in WebI
Designed Dashboards in XCelsius and Dashboard developer.
Supported the reporting infrastructure to make sure critical reports were available to the business in a timely fashion.

SAP BI/BO Consultant

Confidential

Responsibilities:

Designed Universes for SAP BI/BO 4.0 Platform
Developed data warehouse solution in SQL Server.
Designed reporting infrastructure in WebI
Designed client facing reporting infrastructure in Crystal Reports 2011
Enhanced the usability of extracted data by designing Dashboards

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship