Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Awards
Additional Information
Timeline
Generic
Anup Pillai

Anup Pillai

Supervising Associate
Kerala

Summary

Highly motivated and communicative individual with strong interpersonal skills and the ability to adapt to working in team environments. BI Lead with over 12 years of IT experience, possessing a diverse skill set and extensive working experience in Business Intelligence, Reporting, Data Analytics, and Power Apps. Expertise lies in analyzing user requirements and translating them into comprehensive Business Requirement Specifications.

Overview

12
12
years of professional experience
4
4
years of post-secondary education
5
5
Certifications

Work History

Supervising Associate

Ernst & Young
12.2019 - Current
  • Created different Power BI reports utilizing desktop and online service and schedule refresh.
  • Understand business requirements in BI context and design data models to transform raw data into meaningful insights
  • Managed and trained a team of junior Power BI Developers
  • Analyzed SAP transactions to build logical business intelligence model for real-time reporting needs.
  • Perform DAX queries and functions in Power BI.
  • Transformed project data requirements into project data models.
  • Participated in requirements meetings and data mapping sessions to understand business needs.
  • Created different visualization in reports using custom visuals like Bar Charts, Pie Charts, Line Charts, Cards, Slicers, etc. Also, using different transformation inside edit query to clean-up the data
  • Develop and deploy dashboards, visualizations and autonomous and dynamic reporting interfaces to be distributed to stakeholders via BI reporting platform, web portal
  • Developed strong rapport with customers and created positive impression of business.
  • Enhanced team productivity by streamlining communication and implementing efficient project management tools.
  • Developed comprehensive risk management plan, significantly reducing potential disruptions.

Test Specialist

Allianz Technology
02.2019 - 12.2019
  • Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
  • Created Dax Queries to generated computed columns in Power BI.
  • Functional Testing of Reports
  • Identify bottlenecks and bugs, and devise solutions to mitigate and address these issues.
  • Creating Database objects – tables, views, functions and developing procedures for implementing application functionality at the database side for performance improvement.
  • Developing compelling and interactive analysis reports and dashboards for Insurance Marketing analytics using advanced DAX
  • Performance tuning and functional testing of reports
  • Established testing procedures to codify consistent, high-quality approach.
  • Collaborated with developers to identify root causes of defects and ensure timely resolution.
  • Maintained up-to-date documentation of all test plans, results, and defect reports for efficient tracking and reference purposes.

Test Analyst

Infosys Limied
08.2013 - 02.2019
  • Integrated custom visuals based on business requirement using power BI desktop..
  • Documentation - Test Strategy and Test Plan Creating test scripts based on identified scenarios.
  • Converting all operational excel report into Power BI Reports.
  • Experienced in developing Power BI reports and dashboards from multiple data sources using data blending.
  • Experience in database development and release management concepts, practices and procedures along with performance tuning database code in OLTP and OLAP environments
  • Excellent knowledge of all the phases of Software Development Life Cycle (SDLC)
  • Design, develop and deploy business intelligence solutions as per needs
  • Identify key performance indicators (KPIs) with clear objectives and consistently monitor those
  • Involved in coordinating meetings with the product committee, project manager and functional management to discuss project impediments, needed resources or issues/delays in completing the task
  • Reviewed all test cases and test scripts for quality and identified additional areas to review.
  • Reduced production issues by implementing rigorous regression testing before each release.

Education

B.Tech -

Biju Patnaik University of Technology
09.2008 - 09.2012

Skills

Power BI

undefined

Accomplishments

  • Collaborated with global business teams to guide requirements discussions, identify relevant data for meaningful reporting .
  • Managed projects moving monthly balanced scorecard and KPI metrics into Power BI, saving team 40 hours/month in workload
  • Performed root cause analysis on failures. Resolve performance tuning related issues and queries.
  • Developed schemas for business applications with providing full-life cycle architectural guidance and ensured quality technical deliverables.
  • Specialized in transforming data into user-friendly visualization to give business users a complete view of their business using Power BI


Certification

Microsoft Power Platform Fundamentals-PL900

Awards

Extra Miler Award- EY

Spot Award-Infosys

Additional Information

Ernst & Young

Description: Work with various service lines and external clients towards data modelling, governance, identifying and establishing key KPI's , building and managing insightful reports. Analyzing and understanding business requirements.

Responsibilities:

Collaborate with global business teams to guide requirements discussions around identifying key matrices for reporting

Developed Reports/Dashboards and deployed into Power BI.Com service

Involved in Data Modeling, Involved in Process Optimization.

Responsible for import data from Azure and build the dashboards as per the requirement

Responsible for providing the securities for reports/dashboards by assigning roles

Responsible for identifying the project’s stakeholders and figure out what they need

Installed and Configured Enterprise/On-Prem Gateway and Personal Gateway in Power Bi Services.

Worked extensively on Repots with KPIs, Cards, Trend Charts and other Visuals

Worked on creating Power Apps to cater to specific client needs


Allianz Technology

Description: Worked for various operational entities withing Allianz. The objectives were to identify meaningful data, connect to various data sources, build and maintain reports/dashboards which were used by business to make key decisions.

Responsibilities:

Analyzing and Understanding the business requirements. Creating Power BI.

Used Power BI to develop data analysis prototype and to visualize reports and creating DAX queries for Power BI Reports.

Created Drill-down and Drill-through Power Bi reports to meet the requirements

Published Power BI Reports and dashboards using power BI in the required originations and Made Power BI Dashboards available in power BI workspaces.


Infosys Limited

Description: Worked for various clients across North America and Europe. Developed and tested various data models, security and governance across data storage and accessibility. Worked with clients business team to identify reporting requirements , analyze data and develop meaningful insights in form of reports and dashboards.

Responsibilities:

Develop Power BI report

Supported in QA testing

Developed analysis reports and visualization using DAX functions like aggregation function and iteration functions.

Pulling data from various Data sources like OData, ADO(Azure Devops Boards), SQL, share point list, SharePoint folders etc. to Power BI in order to build the Report

Created Power-BI reports using custom visuals.

Worked to optimize the performance of Power BI reports

Understand and document client requirements

Worked to optimize the performance of Power BI reports

Understand and document clie

Timeline

Supervising Associate

Ernst & Young
12.2019 - Current

Test Specialist

Allianz Technology
02.2019 - 12.2019

Test Analyst

Infosys Limied
08.2013 - 02.2019

B.Tech -

Biju Patnaik University of Technology
09.2008 - 09.2012

Similar Profiles

CREATE PROFILE
Anup PillaiSupervising Associate