Business Intelligence Analyst Resume Samples

Business Intelligence Analysts develop a clear picture of the company’s present status by analyzing data, compare the past and future trends, understand the chunks and revert back to the company by delivering insights. Business Intelligence Analysts make sure that the company is able to increase its profit and efficiency by using information and data to figure out the market trends. A Business Intelligence Analyst works directly or as a consultant for the company by gathering data through diverse ways, the information is gathered either by mining the company’s computer data using software or by looking at the trends of the competitors.

Business Management, Accounting, Economics, IT and Statistics Graduates are normally hired for the posts of Business Intelligence Analyst, while Business Intelligence Analyst Resume Sample clearly projects a Master’s Degree as an additional qualification for complicated jobs.

Business Intelligence Analyst III Resume

Summary : I am a Business Intelligence Analyst Level III and a BO Universe Developer with over 10+ years of experience in the analysis, design, development, and maintenance of applications using Oracle and SAP Business Objects tools , RDBMS tools and designing universes, I have expertise in creating Info Spaces for SAP Business Explorer, and developing complex reports for financial analysis using Web Intelligence, BO Desktop, MS Excel, BO Analysis Tool, Live Office, and complex Oracle SQL queries.

Skills : Oracle SQL, PL/SQL, Business Objects XI, R2/R3/R4 Development, BO Universes, IDT, BO Desktop, Web

Description :

  • To create new business objects (BO) universes on an ongoing basis and maintain about 120 existing BO universes.
  • To interact with people at all levels, gather requirements and translate their business needs into technical requirements and then create universes according to their requirements.
  • Assist the reporting group by developing complex and advanced level reports which the reporting group is not able to handle.
  • Communicate with customers and managers of other departments to define business intelligence requirements and then lead initiatives to deliver solutions accordingly.
  • To develop, document, and support the web based corporate reporting and troubleshoot existing bo reports.
  • Incorporate complex logic through free hand SQL to implement complex business rules responsible for creation and maintenance of user accounts for about 2000 users in the absence of bo administrators.
  • Successfully completed financial projects involving creation and automation of complicated financial reports to view ROI for all clients at a glance. 
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
MBA

Business Intelligence Analyst II Resume

Objective : 4 years of IT project experience as Business Analyst, IT/Systems Analyst with a proven track record in business analysis, system analysis, requirements gathering, process management, risk management, data management & modeling, and project coordination/management. Experienced in vendor management, training users/peers, building consensus, Onshore/Offshore Model.

Skills : DATABASE, DATA WAREHOUSING, DATABASE DESIGN, RELATIONAL DATABASE, FINANCIAL REPORTING, ETL, SQL, BI

Description :

  • As a member of the corporate business intelligence team, manage projects for various teams across the Globe, Primary responsibilities include the collection, analysis, planning, development, and change.
  • Projects typically consist of the generation, management, transformation, or presentation of data.
  • Designed and implemented a process that automates and streamlines ordering, quotation auditing and Relational database design, API integration, and data warehousing tools.
  • Resulted in improved pricing strategies, cost savings and scalable structure for a newly created.
  • Outsourced team and alleviated burdensome manual processing duties for 150 program managers.
  • Integrated operational and financial data from several distinct business systems and sources.
  • Created real-time dashboards and reporting capabilities of KPI metrics to senior management.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
B.S


Business Intelligence Analyst - Retail Resume

Summary : Experienced Business Intelligence Professional who has excelled in the retail field with innovative and targeted solution based approach in the fast- paced environments; with strong business acumen, technical and interpersonal skills for past 10 years.

Skills : Data Analysis and visualization Tools, BIDS (Tableau, SSRS, SSIS), SQL/ETL, OLAP, TeraData, Metadata, SSIS, SSRS, SSMS, SAS Web Report Studio (WRS), SAS Business Report Center (BRC)

Description :

  • Automated manual reports for retail clients, which led to the reduction in 30% of resource time.
  • High levels of client interaction for feedback and smooth flow of processes.
  • Designed and developed Tableau dashboards that enabled stakeholders to focus on performance.
  • Defined and documented client requirements in structured formats and created data mapping.
  • Documentation from source to destination for new and existing clients.
  • Developed reporting solutions for large data sets (Big Data) using SQL, SSRS, and SSIS, Hadoop.
  • Extensively analyzed exiting data models and provides insights for future projects.
  • Intensively worked on Data Quality Analysis, Data lineage and Data Standardization data structures, data.Base design, data warehouses, business intelligence/analytic tools, ETL, and data integration.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
MBA

Business Intelligence Analyst - Pharma Resume

Summary : A dynamic professional with over 9 years of extensive experience in Business Intelligence, areas including but not limited to, customer relationship management, testing, and business analysis. Excellent communication and interpersonal skills with strong relationship building, analytical, team building, problem-solving and organizational abilities.

Skills : BIDS, Tableau ETL Tools: SSAS, SSIS, And SSRS, DB2K, Advantage Data Architect(Arc32) Databases: MS Access, Oracle 8i, SQL Server Environments, DB2, Advantage Data Architect(Arc32)

Description :

  • Lead a group of 6 BI team members with internal and external client requests to develop reports to help our operations team and clients ensure robust data and excellent quality in reporting.
  • Work closely with operational team leaders, IT staff, program managers, and reporting solutions users to clarify and translate project requests from business needs to information solutions.
  • Lead daily engagement meetings for business mock-ups and business rules clarification between operations and analysts for 4 pharmaceutical clients.
  • Supporting back-end production systems, workflows, and solution delivery.
  • Strong knowledge of reimbursement and pap operational programs and / pharmaceutical sales and marketing business disciplines.
  • Liaison between stakeholders and management/developers/testers in implementing business rules into technical instructions.
  • As a business analyst resources also accountable for data governance to help with delivering projects from inception to completion.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Senior
Education
Education
CIS


Business Intelligence Analyst (Financial Planning & Analysis) Resume

Headline : Adaptable, Self-driven, results-oriented, and able to make decisions under high pressure. Extensive education and 6+ years of experience in people management, Business Intelligence, problem-solving, strategic planning, and communication skills.

Skills : Strong Excel, PowerPoint And Access With Focus On Financial Modeling And Report Writing Via The Use Of Pivot Tables, VLookups, Queries And Table Configuration. Trend Analysis And Data Interpretation

Description :

  • Design, create and implement IT solutions for inventory, data extraction, database management, metric reporting, and business process efficiencies for accounting and all related business units.
  • Coordinate inter-disciplinary teams in streamlining information for metric reporting, including it, marketing/sales, accounting, purchasing, and distribution.
  • Analyze and implement efficiency projects within accounting as well as other internal partners.
  • Assist data integrity, data management, and data administration solutions for integration with sap.
  • Create budgetary and financial reporting efficiencies with existing and newly designed processes.
  • Design management strategies with Microsoft access SQL for data manipulation and extraction.
  • Produce reports, dashboards, pivot tables and other metrics for accounting and budgetary information within excel.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Junior
Education
Education
MBA

BI Analyst - Government Resume

Summary : An 8 years experienced Business Intelligence Analytics Professional proficient in developing new and innovative ways to leverage data to improve processes and enable fact-based decision making.

Skills : SAP Business Objects, Business Analysis, SQL, SSIS, Tableau, Requirements Analysis, Python, SDLC, Scrum

Description :

  • Performed analysis and design by translating business requirements and developing reporting solutions that yield relevant business information in a user-friendly format by collecting, analyzing and leveraging data to solve business problems. 
  • Used Business Intelligence Reporting Tool to create KPIs and Scorecards to improve corporate profitability measures and comparative financial analysis.
  • Developed an in-depth knowledge of the Portfolio and Project Management data models (Clarity and related systems) and processes as needed to support critical issues. 
  • Assisted with investigating, reviewing and analyzing data from multiple internal and external sources in order to maintain quality and understands the source structures and business relevance of the data. 
  • Supports integration with other systems and data stores as needed to support analytics related to Portfolio and Project Management Delivery. 
  • Applied technical skills using SQL in data collection, data analysis and reporting to procure data from database structures. 
  • Assisted with training within the functional business areas on use of data as an analytical tool, displaying the information in new forms. 
Years of Experience
Experience
7-10 Years
Experience Level
Level
Senior
Education
Education
B.S

Business Intelligence Analyst - Education Resume

Summary : Professional Business Data Analyst with over ten years of ETL manipulation, statistical analysis and reporting. Hands on experience with T-SQL scripting in Oracle, SQL Server, Sybase and MySQL environments. Detailed experience in data manipulation with SSIS, Microsoft Excel, Microsoft Access, Oracle, Sybase and TOAD ETL tools. In addition, experience with reporting analytic tools SAS, Microsoft Excel Pivot tables, Crystal Reports and Tableau. Masters Degree in Applied Mathematics.

Skills : Access, Oracle 9i+, SQL Server, DB2, Teradata Development Tools: Toad, Oracle Reports Builder, Forms Builder, Crystal Reports, SQL Server Mgmt Studio Bug/Issue .

Description :

  • Worked closely with Controller group with overall strategic planning for financial business intelligence.
  • Reviewing Business requirement document for completeness, analyzes actual, and forecast budgeting and forecasting requirements.
  • Implementation and transition of reporting solution based on MS Power BI/Tableau/Cognos to all level of stakeholders. Develop strategy for implementing data cleaning, data profiling, and Data quality.
  • Worked on building Data Warehouses from scratch with expertise in all phases of data warehousing lifecycle along with implementation and testing of software applications and products.
  • Migrate existing Cognos reports to Tableau and MS Power BI embedded in applications by replacing semantic layer. Expert in evaluating data models to design Tableau solutions.
  • Designed and developed interactive Tableau dashboards and reports that portray business intelligence.
  • Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts, line charts using show me functionality. 
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
MIS

Sr. Business Intelligence Analyst Resume

Summary : Over 8+ years of professional experience in IT industry with expertise in design, development, modeling and implementation of data warehousing applications. Strong business knowledge in Finance, Accounting and Healthcare domain with Extensive knowledge in financial reporting environment and Financial, Retail & Healthcare analytics.

Skills : Reporing - Tableau desktop/Server, Microsoft Power BI, Cognos BI, ETL Tools - Informatica Power Center and Datastage

Description :

  • Worked closely with client's business intelligence group to help analyze and enhance their current reporting deliverables.
  • Worked with finance team in financial management process automation with automate statutory,management and regulatory reports. Worked closely with regional CFO to reduce business risk and improve efficiency in critical business reporting process. 
  • Involve in ETL life cycle process by getting data from xml documents, web services, flat files, DB2 databases and Oracle. 
  • Extensively worked on Datatsage sever and parallel job controls and sequencers. Designed and developed parallel jobs by using different types of stages such as transformers, Aggregator, Merge, Join, Lookup, Sort, Remove duplicate, Funnel, Filter, Pivot, Shared container for developing jobs. 
  • Used complex SQL queries for data analysis, created store procedures and Unix scripts.
  • Worked with Datastage Director in running the solution, testing, and debugging the components and monitoring the resulting executables. Task allocation to resources and ensure completeness of the tasks in timely manner.
  • Experienced in Dimensional data modelling, Star Schema and Snowflakes schema modelling, FACTS and dimension table design. Extensively worked in large scale data loading from text files. 
Years of Experience
Experience
7-10 Years
Experience Level
Level
Executive
Education
Education
MS in Data Science

Business Intelligence Analyst II Resume

Objective : With over 3 years experience in Business Analyst, Versatile, solutions oriented individual with strong analytic and quantitative background, Tech fluent, apt with unfamiliar concepts and an assiduous employee.

Skills : SQL, Tableau, Microsoft Access, Excel, Illustrator, Office Applications

Description :

  • Widely used Email notification, Terminator, Nested condition, Error handling and before and after sub routine. 
  • Worked with Finance and Accounting department to develop multidimensional budgeting and forecasting using Cognos TM1, Cognos controller.
  • Creation of import specifications, entity hierarchy, account mappings to improve efficiency and auditability by collecting and analyzing data from different sources using Cognos FSR and disclosure management for internal and external reporting. 
  • Development of reports for Group finance/FP&A and production of excel/systems modelling for the budget and forecast processes, enabling automation where applicable. 
  • Leads the monthly financial close process including, preparing and reviewing journal entries, reconciliations, and data validations using Cognos controller. Prepared consolidated financial information in a centralized, controlled, compliant environment.
  • Enabled automation and control of financial consolidation process.
  • Created design documents for extract, transform, validate and load ETL process and flow diagrams along with development of both server and parallel jobs to extract data from Peoplesoft, text files, sequential files, flat files and MS Access
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
CIS

Business Intelligence Analyst (Contractor) Resume

Summary : Experienced Business Intelligence Analyst who is committed to operational excellence, delivers results through process improvements and task automation that realize cost savings, increase efficiency and improve reporting capabilities.

Skills : SSRS, SQL, Business Objects XI, Actuate (2.0 - 11.0), Crystal Reports XI, Eclipse BIRT, Visual Basic.NET, VBA, C++, ERwin, Visio, CA Clarity

Description :

  • Worked as a Business Intelligence Analyst on the Dell Financial Services BI team; supported reporting and analysis requirements from various stakeholders within the organization. 
  • Gathered and analyzed requirements in order to determine reporting needs. 
  • Performed data collection, mining, and reporting on Oracle and Teradata databases. 
  • Performed data visualization and interpretation using Tableau, batch scripting, ad-hoc SQL analysis. 
  • Coordinated data migration projects, including resource allocation, execution, and follow-up. 
  • Completed weekly root cause analysis and reports by extracting information from data sets. 
  • Facilitated the automation of reporting and business processes.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
Computer Science

Associate Business Intelligence Analyst Resume

Summary : With over 9+ years of experience of Business Intelligence principles, attention to detail, and commitment to excellence to improve customer satisfaction and meet business objectives.

Skills : Data Analysis, Machine Learning, Statistics, Project Leadership, Natural Language Processing, Business Analysis. R, SQL, Neo4j Cypher, Python, Microsoft VBA, MatLab.

Description :

  • Develop, document, implement and maintain Tableau & Cognos BI reporting solutions for the BCA users around the Globe. 
  • Transfer business questions into fact based analysis that delivers clear insights and actionable recommendations. 
  • Develop actionable, insightful data analytics and reporting for internal BCA customers with business performance, including root cause analysis. 
  • Provide data-driven insights and recommendations to strategic business questions, including new product launch and demand Accuracy Strategy, as part of several
  • Collaborate with fellow analytics business consultant team members to support demand Accuracy Strategy and Inventory Reduction initiatives.
  • Responsible for the technical definition, support, and consulting assistance to facilitate data integration and preparation of reports and analytical trend analysis in support of client-specific deliverables.
  • Teradata focal for the team (manage outages, create outage plans, attend technical meetings and create Teradata CPU usage forecasts for the team.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Senior
Education
Education
B.S.

Business Intelligence Analyst III Resume

Summary : Detail-Oriented IT professional with 14 years experienced working as Business Intelligence Analyst different positions for a variety of organizations including Healthcare, Pharmaceutical, Telecommunications and Financial Services.

Skills : SQL SERVER REPORTING SERVICES (SSRS), BUSINESS OBJECTS 6.5, WEB INTELLIGENCE , BROADCAST AGENT ADMINISTRATION, CRYSTAL ENTERPRISE 11, SEAGATE INFO 7.5, SQL SERVER 2005, SERVER 2008, MS ACCESS, MS WORD, MS EXCEL 2007, EXCEL PIVOT TABLES, PIVOT CHARTS, MS POWERPOINT, MS VISIO, HEAT, PROJECT

Description :

  • Analyze the current business process of daily report generations cycles and optimize the process by optimizing the stored procedures and build a complete automated process by developing complex stored procedures and scheduling the jobs with better error/exception handling and reducing the cycle time and manual intervention.
  • Builds, documents, and maintains complex ETL jobs, SQL stored procedures and data-flow processes using a combination of SQL Server, Toad and other applications. 
  • Strong experience with T-SQL, PL/SQL and developing complex stored procedures and functions. 
  • Develop all ETL components including data acquisition, cleansing, standardization, validation, staging and database persistence using Microsoft SQL Server. 
  • Writing SQL queries using joins and Sub queries and functions to retrieve data from multiple schemas and tables. 
  • Designing transformation rules and process to derive the correct data from, the extracted data and transform into the required format and structure to report the business requirements. 
  • Monitoring the Quarterly production cycle and resolving the issues within service level agreement period.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Senior
Education
Education
MBA

Data Visualization / Business Intelligence Analyst Resume

Summary : Solution oriented professional with over 7+ years in Business Intelligence Analyst/Manager utilizing Excel, Power Pivot/Power View, Tableau, SSRS , SQL and other BI technologies with a company needing insights into data.

Skills : Power Pivot, SQL, Tableau, Excel

Description :

  • Develop custom SQL queries and alternative methods in order to establish effective data models leading to insightful business intelligence visualizations.
  • Work alone and in collaboration with teams to build exact bi dashboards leading to statistically significant increases in work order response and completion percentages, cost savings, budget planning, and additional business functions.
  • Effectively communicate the results and meaning of dashboards, the business process', and any other related documentation.
  • Maintain data and perform data audits in various business-facing databases and tools.
  • Create initial project proposals, project charters, and statements of work.
  • Collaborated with production support team and performed root cause analysis to fix critical issues.
  • Developed ETL mappings to integrate disparate source data into staging layer and, transform and load into the data warehouse.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Senior
Education
Education
Bachelor Of Science

Senior Business Intelligence Analyst Resume

Summary : IT Business Analyst with over ten years of experience working with financial data and systems. Skilled in analysis, problem solving, risk management and communication. . Adept at researching, evaluating, interpreting and explaining complex processes and information to others. A self driven and determined learner, who demonstrates strong leadership and initiative, excellent interpersonal skills, a high degree of integrity and the flexibility to work autonomously or with a team.

Skills : SQL, Technical Support, SQL Server, T-SQL, MS Access, MS Excel, Business Analysis, Data Analysis, SSRS, SSIS, SSAS

Description :

  • Create and modify stored procedures to facilitate automation of critical business tasks.
  • Collaborate with business contacts to identify and document requirements for new scripts, data feeds, or reports.
  • Collaborate with programmers to extract sap data and load into SQL server tables for reporting and automation solutions.
  • Facilitate project meetings and ensure tasks are documented and completed within deadlines.
  • Led the project and created data delivery architecture to automate employment verification process in collaboration with internal business contacts and a third party vendor.
  • Gather data required to conduct analysis from several sources, compile it together in the standardized format and enter the data into business intelligence software.
  • Efficiently provide technical support to existing clients for software, hardware and data issues and effectively documents and communicates cause and resolution.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Senior
Education
Education
CIS

Business Intelligence Analyst (BW/BI Developer) Resume

Summary : As a Lead in Business Intelligence and Analytics solutions by mining data, and creating dashboards for visibility, with over 12+ year of experience in Insurance, finance and manufacturing industries for international companies, both in lead roles and consultant roles. With analytics thinking, great people skills and a proven track record of using data to see market potential and business problem

Skills : BUSINESS INTELLIGENCE, SQL, COGNOS, IBM COGNOS, Data Mining, Tableau, Analytics

Description :

  • Cognos BI reporting solutions for the bca users around the globe and to Develop, document, implement and maintain tableau. 
  • Transfer business questions into fact based analysis that delivers clear insights and actionable recommendations.
  • Develop actionable, insightful data analytics and reporting for internal bca customers with business performance, including root cause analysis.
  • Provide data-driven insights and recommendations to strategic business questions, including new product lunch and demand accuracy strategy, as part of several inventory reduction initiatives stemming from the boeing wide inventory reduction projects.
  • Collaborate with fellow analytics business consultant team members to support demand accuracy strategy and inventory reduction initiatives.
  • Work with cross-functional partners to uncover and explain the drivers of business performance.
  • Teradata focal for the team (manage outages, create outage plans, attend technical meetings and create Teradata CPU usage forecasts for the team.
Years of Experience
Experience
10+ Years
Experience Level
Level
Executive
Education
Education
MS

Lead Business Intelligence Analyst Resume

Summary : Solutions-oriented Business Intelligence professional with over 15-year record of finance solutions that provide business insights and metrics for corporate decision-making.

Skills : Research, Reporting, Project Management, Tableau, Microstrategy, Customer Service, Design, Data Analysis, Communications, Quality Assurance, Analytics, Presentation, SQL

Description :

  • Partner with the developer team, executives and end users to implement Business Intelligence solutions.
  • Generating new reports & modifying existing reports (Dashboards, Drill through reports, Master detail relationship repots, Cross tabs, list, Active Reports) using Cognos Report Studio, Query Studio and Analysis Studio.
  • Replicating Crystal and business objects reports in Cognos and developing reports using SQL Server Reporting Services(SSRS) 
  • Publishing reports in Test, QA & Production Environments and making sure they are in same line of structure.
  • Testing the reports before user validation by comparing Cognos generated SQl and Native SQL.
  • Devised robust Business Intelligence reports to track and analyze SKU inconsistency across all Staples channels using Tableau Platform. 
  • Unified and transformed Stock Keeping Unit (SKU) content into a single source using Python and SQL improving data integrity by 27%. 
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
Masters Of Public Health