Business Intelligence Analyst Resume Samples

Description :

1. To create new business objects (BO) universes on an ongoing basis and maintain about 120 existing BO universes.
2. 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.
3. Assist the reporting group by developing complex and advanced level reports which the reporting group is not able to handle.
4. Communicate with customers and managers of other departments to define business intelligence requirements and then lead initiatives to deliver solutions accordingly.
5. To develop, document, and support the web based corporate reporting and troubleshoot existing bo reports.
6. 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.
7. Successfully completed financial projects involving creation and automation of complicated financial reports to view ROI for all clients at a glance. 

Experience

10+ Years

Level

Senior

Education

MBA

Description :

1. 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.
2. Projects typically consist of the generation, management, transformation, or presentation of data.
3. Designed and implemented a process that automates and streamlines ordering, quotation auditing and Relational database design, API integration, and data warehousing tools.
4. Resulted in improved pricing strategies, cost savings and scalable structure for a newly created.
5. Outsourced team and alleviated burdensome manual processing duties for 150 program managers.
6. Integrated operational and financial data from several distinct business systems and sources.
7. Created real-time dashboards and reporting capabilities of KPI metrics to senior management.

Experience

2-5 Years

Level

Junior

Education

B.S

Description :

1. Automated manual reports for retail clients, which led to the reduction in 30% of resource time.
2. High levels of client interaction for feedback and smooth flow of processes.
3. Designed and developed Tableau dashboards that enabled stakeholders to focus on performance.
4. Defined and documented client requirements in structured formats and created data mapping.
5. Documentation from source to destination for new and existing clients.
6. Developed reporting solutions for large data sets (Big Data) using SQL, SSRS, and SSIS, Hadoop.
7. Extensively analyzed exiting data models and provides insights for future projects.
8. 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.

Experience

10+ Years

Level

Senior

Education

MBA

Description :

1. 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.
2. 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.
3. Lead daily engagement meetings for business mock-ups and business rules clarification between operations and analysts for 4 pharmaceutical clients.
4. Supporting back-end production systems, workflows, and solution delivery.
5. Strong knowledge of reimbursement and pap operational programs and / pharmaceutical sales and marketing business disciplines.
6. Liaison between stakeholders and management/developers/testers in implementing business rules into technical instructions.
7. As a business analyst resources also accountable for data governance to help with delivering projects from inception to completion.

Experience

7-10 Years

Level

Senior

Education

CIS

Description :

1. 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.
2. Coordinate inter-disciplinary teams in streamlining information for metric reporting, including it, marketing/sales, accounting, purchasing, and distribution.
3. Analyze and implement efficiency projects within accounting as well as other internal partners.
4. Assist data integrity, data management, and data administration solutions for integration with sap.
5. Create budgetary and financial reporting efficiencies with existing and newly designed processes.
6. Design management strategies with Microsoft access SQL for data manipulation and extraction.
7. Produce reports, dashboards, pivot tables and other metrics for accounting and budgetary information within excel.

Experience

5-7 Years

Level

Junior

Education

MBA

Description :

1. 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. 
2. Used Business Intelligence Reporting Tool to create KPIs and Scorecards to improve corporate profitability measures and comparative financial analysis.
3. 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. 
4. 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. 
5. Supports integration with other systems and data stores as needed to support analytics related to Portfolio and Project Management Delivery. 
6. Applied technical skills using SQL in data collection, data analysis and reporting to procure data from database structures. 
7. Assisted with training within the functional business areas on use of data as an analytical tool, displaying the information in new forms. 

Experience

7-10 Years

Level

Senior

Education

B.S

Description :

1. Worked closely with Controller group with overall strategic planning for financial business intelligence.
2. Reviewing Business requirement document for completeness, analyzes actual, and forecast budgeting and forecasting requirements.
3. 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.
4. 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.
5. 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.
6. Designed and developed interactive Tableau dashboards and reports that portray business intelligence.
7. Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts, line charts using show me functionality. 

Experience

10+ Years

Level

Senior

Education

MIS

Description :

1. Worked closely with client's business intelligence group to help analyze and enhance their current reporting deliverables.
2. 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. 
3. Involve in ETL life cycle process by getting data from xml documents, web services, flat files, DB2 databases and Oracle. 
4. 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. 
5. Used complex SQL queries for data analysis, created store procedures and Unix scripts.
6. 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.
7. 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. 

Experience

7-10 Years

Level

Executive

Education

MS in Data Science

Description :

1. Widely used Email notification, Terminator, Nested condition, Error handling and before and after sub routine. 
2. Worked with Finance and Accounting department to develop multidimensional budgeting and forecasting using Cognos TM1, Cognos controller.
3. 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. 
4. Development of reports for Group finance/FP&A and production of excel/systems modelling for the budget and forecast processes, enabling automation where applicable. 
5. 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.
6. Enabled automation and control of financial consolidation process.
7. 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

Experience

2-5 Years

Level

Junior

Education

CIS

Description :

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

Experience

10+ Years

Level

Senior

Education

Computer Science

Description :

1. Develop, document, implement and maintain Tableau & Cognos BI reporting solutions for the BCA users around the Globe. 
2. Transfer business questions into fact based analysis that delivers clear insights and actionable recommendations. 
3. Develop actionable, insightful data analytics and reporting for internal BCA customers with business performance, including root cause analysis. 
4. Provide data-driven insights and recommendations to strategic business questions, including new product launch and demand Accuracy Strategy, as part of several
5. Collaborate with fellow analytics business consultant team members to support demand Accuracy Strategy and Inventory Reduction initiatives.
6. 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.
7. Teradata focal for the team (manage outages, create outage plans, attend technical meetings and create Teradata CPU usage forecasts for the team.

Experience

7-10 Years

Level

Senior

Education

B.S.

Description :

1. 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.
2. Builds, documents, and maintains complex ETL jobs, SQL stored procedures and data-flow processes using a combination of SQL Server, Toad and other applications. 
3. Strong experience with T-SQL, PL/SQL and developing complex stored procedures and functions. 
4. Develop all ETL components including data acquisition, cleansing, standardization, validation, staging and database persistence using Microsoft SQL Server. 
5. Writing SQL queries using joins and Sub queries and functions to retrieve data from multiple schemas and tables. 
6. 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. 
7. Monitoring the Quarterly production cycle and resolving the issues within service level agreement period.

Experience

7-10 Years

Level

Senior

Education

MBA

Description :

1. Develop custom SQL queries and alternative methods in order to establish effective data models leading to insightful business intelligence visualizations.
2. 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.
3. Effectively communicate the results and meaning of dashboards, the business process', and any other related documentation.
4. Maintain data and perform data audits in various business-facing databases and tools.
5. Create initial project proposals, project charters, and statements of work.
6. Collaborated with production support team and performed root cause analysis to fix critical issues.
7. Developed ETL mappings to integrate disparate source data into staging layer and, transform and load into the data warehouse.

Experience

7-10 Years

Level

Senior

Education

Bachelor Of Science

Description :

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

Experience

7-10 Years

Level

Senior

Education

CIS

Description :

1. Cognos BI reporting solutions for the bca users around the globe and to Develop, document, implement and maintain tableau. 
2. Transfer business questions into fact based analysis that delivers clear insights and actionable recommendations.
3. Develop actionable, insightful data analytics and reporting for internal bca customers with business performance, including root cause analysis.
4. 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.
5. Collaborate with fellow analytics business consultant team members to support demand accuracy strategy and inventory reduction initiatives.
6. Work with cross-functional partners to uncover and explain the drivers of business performance.
7. Teradata focal for the team (manage outages, create outage plans, attend technical meetings and create Teradata CPU usage forecasts for the team.

Experience

10+ Years

Level

Executive

Education

MS

Description :

1. Partner with the developer team, executives and end users to implement Business Intelligence solutions.
2. 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.
3. Replicating Crystal and business objects reports in Cognos and developing reports using SQL Server Reporting Services(SSRS) 
4. Publishing reports in Test, QA & Production Environments and making sure they are in same line of structure.
5. Testing the reports before user validation by comparing Cognos generated SQl and Native SQL.
6. Devised robust Business Intelligence reports to track and analyze SKU inconsistency across all Staples channels using Tableau Platform. 
7. Unified and transformed Stock Keeping Unit (SKU) content into a single source using Python and SQL improving data integrity by 27%. 

Experience

10+ Years

Level

Senior

Education

Masters Of Public Health