Business Intelligence Analyst

Business Intelligence Analyst

Professional & Skills Summary:

IT Graduate, certified Power BI, Business Objects and Oracle Data Reporting Analyst having over 4 years of experience as Data and BI Reporting Analyst.

Over 4 years of professional experience in coding, testing and establishing system improvements along with Business Intelligence, Predictive modelling, Data Visualization, Quantitative & Statistical analysis, Data Mining Tools & Techniques.

Well versed with complete Life Cycle Development process including requirement analysis, documentation, development, testing/quality assurance, implementation, and maintenance.

Comprehensive experience in entire testing process (estimation, business requirement analysis, preparation of test plan, test scenarios, test cases, traceability matrix, test case execution, defect management and creation of test closure reports).

Extensive experience in coordinating testing effort, responsible for test deliverables, status reporting to management and issue escalations.

Performed Smoke testing, Functional Testing, System Integration Testing (SIT), Performance Testing, Regression Testing and User Acceptance Testing (UAT)

Experience in testing database applications of RDBMS in Oracle, My-SQL and SQL Server by executing SQL Queries.

Proficiency in upgrading DTS packages to SQL Server Integration Services.

Strong knowledge of SQL, Oracle language and experience in databases such as Oracle 11g/10g/9i, MySQL, SQL Server 2014/2012.

Experience in providing assistance to the clients and end users for Business Objects Universe Designer.

Hands on experience in SSIS (SQL Server Integration Services) package design for data integration

from heterogenous sources (JSON, OData, MS SQL Server, MS Access, MS Excel, XML, Oracle,

Flat File, Text Format Data), SSAS (SQL Server Analysis Services) Cube design and development,

SSRS (SQL Server Reporting Services) design and development.

Proficient in creating developing and deploying Reports and Dashboards using Power BI, Business Objects Webi, SSAS, SSRS & MS Excel.

Experienced in gathering the SAP BI reports requirement with Business user, analyzing existing reports and creating new reports as per requirements.

Proficient in designing SQL tables, Schema, Stored procedures & optimizing SQL queries to speed up performance.

Ability to optimize Microsoft Power BI dashboards with a focus on usability, performance, flexibility, testability and standardization.

Expertise in working on various Power BI dashboards: reports using different data source connectors, different charts, created complex formulas, DAX measures, parameters within Power BI to meet the need of complex business logic.

Good knowledge on DAX expressions like filters Aggregate, Mathematical Functions and Created New Calculated Column and Measure using DAX Expression.

Expertise in App workspaces to control permissions and access to Power BI dashboards.

Ability to partner with DBAs to source necessary data, map source data to target structures, and define query methods.

Leverage MS BI tools to answer questions, solve problems, and create reporting solutions.

Experience in preparing/executing test cases for unit testing, created various test cases to validate the data, performance and look and feel of the reports.

Experience in Data Transformation like Derived Column, Conditional Spilt, Aggregate, and Execute SQL Task to load into Data Warehouse.

Experience in creating/analyzing/modifying in writing Oracle SQL queries, tables, views, functions, procedures, sequences.

Experience in Integration of various Data Sources like MS Excel, Flat Files, Different Database Sources and Other Sources into the Staging Area.

Excellent troubleshooting, problem solving, analytical skills and flexibility to adapt to fast-paced ecosystem.

Well-versed with ITIL principles, Agile Methodologies and Customer Relationship Management tools.

Ability to effectively communicate with various business groups to gather requirements and prepare functional and technical documents.

Strong proficiency in different SDLC methodologies including Agile and Waterfall models.

Exceptional ability to quickly master new concepts and technologies.

Proficiency in functional, technical documentation and status reporting.

Capable of working in groups as well as independently with excellent communication skills.

Ability to meet deadlines and handle multiple tasks, flexible in work schedules and possess good communication skills.

User / Security and Access - User provisioning, License management, Profile setup /

administration / maintenance

Standard and Custom Objects - Customization of standard objects, Custom object design / creation, Field level Security, Page layout design, Record type creation / maintenance, Object linking / relationships

Analytics- Creating custom reports, creating dashboards, Creating report types

Data Management - Data Loader etc. like loading large data sets of contacts and accounts.

Approval process & workflow Creation.

Customized standard objects and created custom objects and relationships, fields, reports and dashboards.

Responsible for understanding Salesforce use cases of the design and solution build.

Interacted with Business Analysts and Product team to document the design and requirements.

Education and Certifications

Oracle SQL Certified Associate with 95% Score: Client ID: OC1794610

Oracle PL/SQL Certified Associate with 77% Score: Client ID: OC1794610

AMCAT Certified Data Processing Specialist: License 807305-211

AMCAT Certified Channel Sales Professional: License 807305-195

AMCAT Certified Customer Service Specialist: License 807305-210

AMCAT Certified Collections Specialist: License 807305-197

AMCAT Certified Telesales Professional: License 807305-282

Master of Computer Applications(IT):Graphic Era Hill University, India May 2013- June 2015

Bachelor of Science(IT):Graphic Era Hill University, India May 2010- June 2013

Technical Skills

Technologies used

: Power BI/SSIS/SSAS/SSRS/MS Office

Web Development

: HTML, HTML5, CSS, JavaScript, JQuery, PHP

Programming Language

: C, C++, JAVA, VBA, SQL,T-SQL

Operating Systems

: Windows 7/8/10

Databases

: MySQL, MS SQL Server, Oracle

ETL Tools

: SQL Server 2012 Integration Services, SSIS 2014, Informatica

Business Intelligence, Analytical Tools

: SSRS, MS Excel, Power BI Desktop, Power BI Service, Tableau, SAP Business Objects – Webi, Crystal Reports, Universe Design Tool (UDT).

Good Knowledge of ITSM Tools

: Service Now, Salesforce and MS Office

Development IDEs

: SQL Server Management Studio, Notepad, Oracle SQL Developer, Visual Studio, NetBeans, SQL Server Data Tools

CRM

: Salesforce CRM

Professional Experience

ADP, Mississauga ON January 2019 – Present

Role

: Business Intelligence Analyst (Contract)

Team Size

: 10+

Environment

: Business Objects, SAP BI Business Objects 4.2 Web Intelligence, SSIS, MS SQL Server Management Studio, MS Access, MS Excel, MS Office.

Project 1: The project involved upgrading SQL Server from 2000 to 2014, automating jobs, verification of the supporting data and tables. Changes in DTS packages to SSIS packages.

Project 2: Client reports development. Code changes to support existing BI/BO reports on the new server. Creation of BI/BO reports using different universes having different parameters.

Roles and Responsibilities:

Involved in end to end – development lifecycle stages – design, development, testing, implementation/production and maintenance.

Gathered business requirements and ensured data design followed prescribed reference architecture and framework.

Worked with the clients/SME’s to proficiently document reporting requirements using MS Office 2013 and received sign-off.

Worked with the data modelers and BI developers to establish protocols to extract data in a standardized process from variety of data sources.

Analyzed large amount of data from different data cubes using SQL 2014 to provide concise, targeted reports for clients. Further, created various reports in a number of formats including MS Excel, Crystal reports, etc.

Responsible to gather and analyze the SAP BI reports requirement with Business user.

Analyzed existing Web Intelligence & Dashboard reports and their related universe.

Create new and enhanced existing Webi reports and their related universe as per requirements.

Maintained strong relationships through proactive communication and worked closely with stakeholders to ensure business needs are addressed.

Identified business objectives and process workflows, gathered requirements from stakeholder, and translated requirements into technical specifications.

Responsible for being familiar with source code, version management, and code deployment standards.

Ensured that QA processes and procedures are followed in test environment and the integrity of the various environments is not compromised.

Created project artifacts such as planning documents/test plan, applicable standards, requirements, test

cases and procedures.

Create data models and packages based on feature requirements and business logic.

Tested Framework Manager against relational and multi-dimensional data sources and ensured each of the layers (Data, Logical, Presentation) resulting in predictable queries, filters, calculations, SQL.

Verified data modeling package and troubleshoot any issues in all Business Objects reporting application- Web Intelligence.

Reported and tracked bugs, replicated reported customer bugs, verified bug fixes and new

functionalities, regression tested new releases, supported developers by examining logs and debug

files.

Performed Black box and White box testing, which includes both debugging SQL scripts and investigating data integrity issues.

Actively involved clients for their feedback in various stages of development and successfully demonstrated final product to receive sign-off.

AWC Software Pvt. Ltd, India July 2015 – October 2018

BI Data/Reporting Analyst

Project:

Client

: Genpact

Role

: Data/Reporting Analyst

Team Size

: 10+

Environment

: Power BI, SSIS SQL Server Data Tools, MS SQL Server Management Studio 2012, MS Access, MS Excel, MS Office, Salesforce CRM

Roles and Responsibilities:

Participated in business requirements gathering with business users and ensured the requirements are fully understood and captured.

Communicated with business users to develop and translate business requirements into an effective and insightful interactive analytical dashboard using data visualization and reporting tools (using MS Excel, Power BI and SSRS).

Liaised with business users and stakeholders to identify valuable KPIs and various data sources (SQL Server, Oracle, Informix, Excel, PostgreSQL, Google sheet, OData, and CSV).

Extracted data using SSIS packages (ETL) and optimized T-SQL scripts from various sources

(Oracle, MS SQL Server, MS Access & MS Excel, OData, and CSV and Flat Files).

Prepared test cases for unit testing, created various test cases to validate the data, performance and look and feel of the reports.

Created test cases to ensure data conversion procedures deliver the correct data.

Planned all concerned data processing steps to be used in data conversion.

Performed end-to-end testing for client server applications.

Designed test matrices, test plans, test scenarios, test scripts and test data for web and Client-Server applications.

Verified database changes through the front-end GUI and back end by using SQL queries.

Validated that the application meets stated business requirements. Analyzed functional and technical specifications and submitted feedback to business and technology teams.

Plan, estimate & release product using Agile methodology with Developers and QA.

Troubleshoot performance issues associated with SSIS packages, T-SQL Queries, Power BI

workbooks, dashboards and slow running reports in SSRS.

Developed and deployed Reports and Dashboards using Power BI, SSAS, SSRS, Tableau & MS Excel.

Created interactive reports for the dataset on the Power BI Desktop by importing data from different sources, using different DAX Functions, Power Query, Visualizations.

Created Power BI Dashboards with interactive views, trends and drill downs using user level security

and user filters so that only appropriate teams can view it.

Built Management Analytic Dashboards with set of predefined Key Performance Indicators (KPIs) and appropriate group security and access permissions.

Troubleshoot and tuned performance issues associated with SQL Queries, Power BI workbooks and dashboards.

Scheduled full and incremental extract refresh for weekly and monthly reports.

Involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to specific groups in Power BI Server.

Conducted training and support to Business users on the use of dashboards.

Develop SQL and PL/SQL Code as per the documented design and coding guidelines.

Customized standard objects and created custom objects and relationships, fields, reports and dashboards.

Load large data sets of contacts and accounts using data loader.

Responsible for understanding Salesforce use cases of the design and solution build.

Interacted with Business Analysts and Product team to document the design and requirements.

Produce Analysis and Design documents or review documents created by others.

Developed Database Objects using SQL including Tables, Keys, Constraints, Schemas, Stored Procedure.

Developed T-SQL and Stored Procedures to manipulate data (Join, Cast, Case When, Datediff, Group by).

Create, optimize, and maintain SQL queries that support application functionality and operational activities.

Developed a data visualization solution in Tableau, Power BI for the business partner to help them determine the machine buying cycles of the customers, & understand market trends at the enterprise level.

Trained employee’s on Power BI application during Lunch & Learn meeting to enable them to leverage the tool to share their research insights.

Created presentation charts with data driven sources from different database sources.

Created Simple Chart Showing Sales over Countries and Product Lines.

Projected and delivered Multiple Measures on Charts and Other Refinements

Responsible for properly updating documentation throughout application lifestyle

Collaborated with project stakeholders to identify and translate the E- Commerce business requirements of Sales and CRM into specific technical requirements.

Contact this candidate