Summary
Overview
Work History
Education
Skills
Work Preference
Timeline
Generic

ANIKET NAGDEO

Summary

Responsible for delivering world - class analytics solutions, with a comprehensive technical and functional understanding of the end-to-end process of sourcing data to delivering visualizations and analytics that add value by providing strategic insight and broad user adoption. As a recognized expert Architect, ensuring that applications exceed the needs of users while reducing risk by blending the disciplines of functional business requirements, technical development, organizational behavior, aesthetic design principles, and analytical psychology. PROFESSIOANLSUMMARY Over 14 years in BI, I've mastered SAP suite and Microsoft reporting tools. As a Lead Power BI Developer, I excel in report development and have a proven track record of engaging effectively with high-level stakeholders. Crafted extensive data models and rich BI reports using advanced Excel functions, macros, and the full Microsoft Power BI stack, alongside Tableau visualization tools Created and deployed Power BI Desktop reports to both Report Server and Power BI Service. Experienced in crafting cloud solutions with Microsoft Power Platform, leveraging Power Apps, Power Automate, Power BI, Power Apps Portal, and Common Data Service. Very strong Dashboard UI/UX design experience and passionate in building TEMPeffective data visualizations for the best user experience. Expert in crafting visually compelling Power BI dashboards and thoroughly testing reports for accuracy against source data strong development skills in Azure Data Lake, Azur Data Factory, Azure Data Factory, AWS Cloud, SQL Data Warehouse, and Azure Blob storage, ensuring smooth data processing and management. Experienced with all Power BI products, including Desktop, Pro, Embedded, Report Server, Premium, and Mobile, ensuring versatility in report creation and deployment. Developed various report types, including tabular, matrix, parameterized, sub-reports, and global map reports in both Power BI and Power BI Cloud Service, catering to diverse business requirements Exceptional experience in dealing with various databases like Teradata, Oracle, DB2, SQL Server, SAP Hana, AWS Redshift, MS Access and Flat files. Experience in building interactive reports, dashboards, and/or integrating modeling results and have strong Data Visualization design skills and analytic background by using POWER BI and Tableau desktop Extensive expertise in Snowflake Database, including schema and table structures. Implemented complex business rules in Informatica Power Center by creating re-usable transformations, and robust Mapplets Hands on in Designing, maintaining and building Cubes, Dimensions, and Data source views, data mining Models, Deployment and Processing Expertise in design and configured ISTM and customizing the application using Java Scripts, AJAX and HTML and Service Now Extensive expertise in MS Dynamics AX, MicroStrategy, and implementing reporting with Crystal Reports, SSRS, and SSAS. Expertise in managing PBI Premium capacity, Pro License, data flows, user access, RLS, and schedules. Worked on DAX scripting to access data from Tabular Model and MDX for Multidimensional Cubes. Extensive database experience (MySQL, DB2, SQL Server, Oracle) with adeptness in key DAX functions like SUMX and CALCULATE. Highly skilled in ETL migrations and database synchronization. Proficient in database development, release management, and performance tuning in both OLTP and OLAP environments. Hands on experience on HP ALM , Quality Center, Rally, JIRA Clear Quest..

Overview

15
15
years of professional experience

Work History

Lead Power Bi Developer

Wavicle
03.2021 - Current
  • Project Specific Activities:
  • Utilized Power BI Desktop for direct database table connections (Direct Query Mode) or file imports (Import Mode)
  • Utilized Power BI to extract, clean, and visualize data from diverse sources like SQL Server, Excel, and CSV files
  • Created insightful reports from datasets using Power BI Cloud, with a focus on interactive analysis
  • Analyzed BRD to design a conceptual model and actively contributed across SDLC phases, implementing T-SQL, SSIS, SSAS, and SSRS to deliver the solution
  • Extracting data from different sources connecting them and used the same to create dashboard using AWS and Redshift
  • Wrote Azure trigger functions to schedule data loading into the Visual Studio-created data model deployed on Azure Analysis Services for Power BI reporting
  • Graphic design UI/UX to ensure the usability of the site and change management to assist in the analysis and outreach in the adoption of the data
  • Implemented Power BI Gateway for diverse data sources, enabling tailored analysis and modeling for Power Pivot and Power View
  • Implemented Microsoft Flow (Power Automate) for automatic approval and status updates based on predefined criteria
  • Employed Power Apps and Power Automate templates from the admin center to swiftly create low or no-code business solutions
  • Calculate measures and columns as per the requirement using DAX functions and M Query
  • Designed and deployed interactive reports with Drill Down, Drill Through, and Parameterized options in Tableau, offering enhanced data exploration and analysis
  • To prepare test data, review, and test developed UIs for adherence to specified UI/UX designs
  • Developed Python script to for processing large data sets and also to extract data from different files
  • Migration of Qlikview apps to Qlik Sense including the scripts, objects, include files and visualizations
  • Set up Microsoft Flow (Power Automate) to provide auto approval and status update feature based on predefined criteria
  • Built Power BI reports from scratch and implemented row-level security integrated with Power BI Service portal."
  • Created acceptance criteria for functional and technical user stories in JIRA
  • Worked on building reports for tracking Incidents & Change management on top of Service Now Data
  • Utilized Query Editor to clean, format, and merge data from various sources, eliminating redundancy for streamlined analysis.

Lead Power Bi Developer

Providence
06.2021 - 10.2021
  • Project Specific Activities:
  • Created customized Power BI visualizations and dashboards to meet specifications
  • Produced dynamic dashboards in Power BI Desktop and Service, leveraging advanced data visualization capabilities for rapid analysis
  • Uploaded Power BI paginated reports to Report Server, redesigned dashboards, and managed SSRS configuration
  • Published the reports and dashboards to Power BI Cloud Service and report server for end-user access
  • Developed numerous calculated columns and measures using DAX in Power BI to meet report requirements
  • Engaged in daily Agile/Scrum stand-up meetings to discuss enhancements for existing requirements
  • Implemented dynamic row-level security and updated data visualizations based on client requests
  • Migrated Teradata and DB2 to Snowflake database on AWS, leveraging Matillion and AWS Redshift for Epic Data Warehousing in Snowflake
  • Built SSIS packages to transfer data from Oracle to SQL Server, incorporating complex SQL Views, CTEs, and Temporary Tables
  • Performed programming in M Query while using power query ETL process
  • Managing reports and solving the UI/UX defects on the reports
  • Conducted data extraction and validation using TOAD for Oracle dB and AQT for DB2
  • Contributed to development and debugging of intricate T-SQL procedures and functions
  • Engaged in seamless environment migration in ServiceNow using service update sets and import sets
  • Gathering requirements and designing charts in Qlikview and Qlik sense
  • Created Roles and implemented Row level security for user Authentication in POWER BI
  • Created and Managed OLAP Cubes using SSAS and created different KPIs to perform analysis based on business requirements.

Lead Power BI Developer

Microsoft
01.2020 - 06.2021
  • Project Specific Activities:
  • Created Compete Report for Microsoft where we are checking how competitors doing in market compare to MS
  • Created FY21 Edge reports
  • Created dynamic reports using Power Apps reporting interface and SSRS, deployed on CRM for various roles, and integrated with Power BI and web services
  • Leveraged Power Apps and Power Automate templates for low or no code business solutions
  • Created reports that have been defined by business architect and generated canned reports in a Crystal format of Crystal Reports
  • Created and implemented Azure Data Factory and Data Flow ETL and Pipelines
  • Deploying the Qlik Sense apps to streams, and maintaining user security and data security using section access
  • Used Scripting tools and Service Now functionality to create script to automate rote task being done in Service Now
  • Created Power BI dashboard and generated reports using the Snowflake server tables as Data source using SQL & M Query Language
  • Designed reports utilizing custom filters and DAX expressions with Power BI, and written DAX Expressions, Power Query and Functions in Power BI
  • Adapted data visualizations in Power BI reports and dashboards based on client needs
  • Implemented Power BI Gateway for diverse data sources, ensuring alignment with analysis criteria
  • Leveraged Query Editor to clean, format, and merge tables from various sources, eliminating redundancy

Lead Power BI Developer

USAP
Dallas, TX
10.2018 - 12.2019
  • Project Specific Activities:
  • Working closely with the business users like regional presidents or managers to understand and gather requirements for dashboards
  • Creating and Publishing Power Bi Paginated Reports in Power BI Service and Power BI report Server
  • Created database schema and number of database objects like tables, views, stored procedures, user defined functions using SQL Server management studio
  • Used Power BI desktop to directly connect to database tables ( Direct Query Mode) or import the files into Power BI ( Import Mode)
  • Configuring Gateways and setup refresh schedules for business users
  • Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports
  • Responsible for Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.

Sr. Power BI Developer

Toyota, Allan
, TX
05.2018 - 10.2018
  • Project Specific Activities:
  • Implemented Role based access security using Microsoft Power BI
  • Analyzed the functionality and formulas of the data and created metric (KPI's) dashboard reports using the visualization tool
  • Created the data model by pulling the data from multiple sources and transform the raw data into business information by applying the transform rules
  • Installed and configured Enterprise gateway and Personal gateway tableau in Power bi service
  • Integrated custom visuals based on business requirements using Power BI desktop
  • Developed professional reports as per the business requirements using Power BI.

Sr. Power BI Developer

Rexel
Addison, TX
01.2018 - 05.2018
  • Project Specific Activities:
  • Designed and developed new ETL/SSIS package that load data from OLTP into our existing Data Warehouse based on technical specifications and business requirements
  • Configuring Gateways and setup refresh schedules for business users
  • Migrated existing Qlikview reports to POWER BI reports
  • Querying and manipulating multidimensional cube data through MDX Scripting in SSAS
  • Designed the POC for migrating the On-premises OLAP database to Cloud for reporting
  • Utilized TFS (team foundation server) for coded check-in/check-out and the management of differing code versions
  • Involved in troubleshooting, resolving and validating data related issue to improve data quality

Sr. Power BI/ SAP BO Developer

ASSA ABLOY
06.2017 - 12.2017
  • Project Specific Activities:
  • Developed Dashboards and Reports with Excel, SQL Server, SharePoint List and Report Server data sources using Power BI Service Desktop tool
  • Involved in creating MDX, DAX, Cubes and Tabular models using SQL Analysis Services (SSAS)
  • Embedded Power BI reports on SharePoint portal page and managed access of reports and data for individual users using Roles
  • Performed data refresh on Tableau Server on weekly, monthly and quarterly basis and ensured that the views and dashboards were accurately displaying the changes in data
  • Worked closing with the UI/UX team to integrate the Power BI visuals to an internal dashboard
  • Designed dimensional data model of the OLAP database using Erwin
  • Automated Power Query refresh using power shell script and windows task scheduler
  • Deployed Dashboards, Reports and Data sources in the Power BI Service.

BI Developer

First National Bank
, Pennsylvania
11.2016 - 05.2017
  • Project Specific Activities:
  • Coordinated JAD session with the development team to understand functional requirements
  • Used Power BI Custom visuals like Power KPI, Chiclet Slicer, Info Graphic Designer, Spline Chart to make the visuals look and understand better
  • Designed Data Model in Power BI Designer according to the Structure and Hierarchy of Data
  • Created indexed views, and appropriate indexes to reduce the running time for complex queries
  • Created reports using multiple data providers such as Universes and personal data files in generating reports
  • Configured Power BI enterprise data gateway for scheduled data refresh of Power BI datasets.

Lead SAP BO Developer

Norwegein Cruseline
Miami, Florida
02.2016 - 10.2016
  • Project Specific Activities:
  • Installation, configuration, maintenance, technical support and troubleshooting of Business Objects
  • Established the SAP Business Objects connectivity with SAP BW system and Relational databases t
  • Involved in designing Universe and migrating existing Desktop intelligence (DESKI) reports to Web intelligence (WEBI) reports
  • Actively involved in migration of Business Object resources from BOXI 3.1 to BOXI 4.0 environment
  • Performed regression testing after migration to BOXI 4.0 platform
  • Created dashboards for Operations and Sales, Actual Sales and Projected Sales, National and International territories Sales using Xcelsius , Web services, QaaWS and Excel data
  • Ensured the quality and timely delivery of all the important complex canned reports, and Involved in migration and testing of Objects to PROD environment from DEV through QA environment using Import Wizard.

Lead SAP BO Developer

Black Line
Los Angeles, California
03.2015 - 01.2016
  • Created multifarious sales reports in SAP Business Objects including complex cross tab, summary reports
  • Responsible for ETL operations using SQL Server Integration Services (SSIS) and Worked with users in training and support and also has experience in incremental data loading
  • Created Standard reports, Ad-hoc reports, Complex charts and Drill-Down Reports using BusinessObjects 4.0
  • Created Ad-hoc reports using SAP Business Objects functionalities like Cross Tab, Master Detail and Formulas, Alerts, Slice and Dice, Drill Down @Functions
  • Created interactive Dashboards and Business Presentations by importing data from Excel sheets using Crystal Xcelsius
  • Test/Debug Business Objects Universe enhancements/modifications in Designer to include new objects, updated tables and joins.

SAP BO Developer

Tri-Health Hospital
Mason, OH
11.2014 - 01.2015
  • Implemented security features of Business Objects like row level, object level and report level to make the data secure
  • Involved in performance tuning and Data Quality, Business Objects Full Client and WEBI reports
  • Create standard and ad-hoc reports using Business Objects functionalities like Slice and Dice, Templates, Drill Down, Functions, Cross Tab, Master Detail and Formulae, Breaks and Custom Sorts in reporting
  • Responsible for developing thick/thin client canned reports using Business Objects and Web Intelligence
  • Performed Admin tasks like monitoring DB Services, monitoring BO server running with optimal performance, monitored licenses, monitoring of user activities/ sessions etc
  • Designed and developed Test Scenarios, Test procedures, Test Cases, and Test Data according to requirements.

SAP BO Developer

Capital One Bank
Richmond, VA
01.2014 - 11.2014
  • Customizing the AdhocWebi reports as per the user requirements by using the Formulas, Drill Downs, Master/Detail and Cross Tabs
  • Developed dashboards, KPI and scorecards for detailed analysis
  • Also, creating Dashboard (xcelsius) Manager using Application Foundation and Web Intelligence
  • Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure
  • Created dashboards using SAP Business Objects Dashboards 4.0 (Xcelsius)
  • Assisted in training the powerful features of Business Objects to Moderate BO users.

Team Lead

Inautix, BNY Mellon
10.2013 - 01.2014
  • Created universes with Classes and Objects for investment management system
  • Used Index awareness, @aggregate aware and Aggregate tables for optimized query performance
  • Created universe on top of views build in composite coming from multiple data sources
  • Worked extensively with @functions (@select, @prompt, @where) in designer, created optional prompts, also created objects using complex case functions
  • Exported Xcelcius to repository to make it available for users through info view, Created and modified the Crystal Reports for various financial groups using the Universe as a main data provider
  • Created Multiple Custom Hierarchies for several groups to provide drill across functionality
  • Testing performance of CR, WEBI, DESKI and accordingly configuring the server parameters.

Sr. BOBJ Developer

Cognizant, JP Morgan Chase
08.2012 - 09.2013
  • Created prototypes of the dashboards, involved in interacting with the end users and finalizing the conceptual design, Created Xcelcius visualization for Wealth management business unit to provide Financial Analysis by product, region, state, portfolios and Advisors
  • Created personalized dashboards to reflect user-specific alerts and metrics to track critical Key Performance Indicators (KPI)
  • Used XML, QAAWS data sources to import data into the dashboard
  • Used dynamic visibility to give users multiple views with in one single screen for detailed insight and interactive analysis, Used multiple components (Gauges, dials, sliders, list boxes radio buttons, Pie charts, combination charts, accordion menus, combo boxes etc) to build state of art dashboards
  • Created universes with Classes and Objects for investment management system
  • Used @aggregate aware function and Aggregate tables for optimized query performance
  • Used @prompts to create predefined conditions and prompts to filter the data and dynamic user selection
  • Tested the Web Intelligence reports in System Integration and Testing (SIT) environment and Performance Testing (Staging) environment to validate performance of all the reports, which helped in analyzing its performance before moving into production environment.

Business Objects Technical Support Specialist

SAP Americans
08.2009 - 07.2012
  • Involved in Administration activities, worked with Import Wizard to promote Reports/Universe to Production
  • Installed, Maintained the Business Objects Enterprise
  • Responsible to talk to business users and finalize on any enhancements/new requirements needed by reporting department
  • Created dashboard for IT department and published them to the Enterprise, which showed daily activity being performed by the system users such as user’s login time, number of reports being used by each user, number of sessions running etc
  • Defined contexts, aliases and used multi parse SQL in the universes to address loops, chasm traps and fan traps, which support Ad-hoc and canned reports
  • Extensively involved in developing Web Intelligence reports' publications, scheduling and monitor publications.
  • Worked with Crystal Report XIR2 for creating complex reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports and analysis reports.

Education

Bachelor of Engineering - Computer Technology

KITS Ramtek College, Nagpur University
2009

Skills

  • TECHNICAL SKILLS
  • Power BI Tools: Power BI Desktop, Power BI Gateway, Power Query, DAX, Power BI App, SSIS, SSRS, SSAS
  • Programming Languages: C, C
  • Database Technologies: Microsoft Access, My SQL, SQL Server 2012/2014/2018
  • Operating Systems: Win XP/7/8/10, UNIX, MAC OS X
  • Methodologies: Agile, Waterfall, RAD
  • Testing / Defect Tracking Tools: JIRA, Redmine, Team Forge, Service Now, Team Foundation
  • Web Technologies:
  • HTML 5/HTML, CSS3, CSS2, Bootstrap 3, JSON, XML
  • Others: Toad, SQL Developer, Git, Sublime Text, Notepad, Eclipse, HP Quality Centre 11, Green Hat Tester, Soap UI
  • Auxiliary Skills: MS Office Suite, Microsoft Visio, IBM Rationale Rose, ER Modelling, Erwin

Work Preference

Work Type

Full TimePart Time

Work Location

On-SiteRemoteHybrid

Important To Me

Career advancementWork-life balanceHealthcare benefitsPaid sick leave401k matchPaid time offStock Options / Equity / Profit SharingFlexible work hoursCompany CultureWork from home optionPersonal development programsTeam Building / Company Retreats

Timeline

Lead Power Bi Developer

Providence
06.2021 - 10.2021

Lead Power Bi Developer

Wavicle
03.2021 - Current

Lead Power BI Developer

Microsoft
01.2020 - 06.2021

Lead Power BI Developer

USAP
10.2018 - 12.2019

Sr. Power BI Developer

Toyota, Allan
05.2018 - 10.2018

Sr. Power BI Developer

Rexel
01.2018 - 05.2018

Sr. Power BI/ SAP BO Developer

ASSA ABLOY
06.2017 - 12.2017

BI Developer

First National Bank
11.2016 - 05.2017

Lead SAP BO Developer

Norwegein Cruseline
02.2016 - 10.2016

Lead SAP BO Developer

Black Line
03.2015 - 01.2016

SAP BO Developer

Tri-Health Hospital
11.2014 - 01.2015

SAP BO Developer

Capital One Bank
01.2014 - 11.2014

Team Lead

Inautix, BNY Mellon
10.2013 - 01.2014

Sr. BOBJ Developer

Cognizant, JP Morgan Chase
08.2012 - 09.2013

Business Objects Technical Support Specialist

SAP Americans
08.2009 - 07.2012

Bachelor of Engineering - Computer Technology

KITS Ramtek College, Nagpur University

Similar Profiles

CREATE PROFILE
ANIKET NAGDEO