Business Intelligence Manager

Location:

Voorhees, NJ

Posted:

August 26, 2024

Contact this candidate

Resume:

FNU PAVITRAVAS

BI Developer & Analyst

Contact:

Phone: 480-***-****

Email: **********@*****.***

Education:

MSE Arizona State University, Tempe, Arizona, USA, Aug, 2010 – Aug, 2012

B.Tech Indian Institute of Technology-Delhi (IIT-Delhi), Delhi, India. Jul, 1995 – Jun, 1999

Summary:

10+ years of Business Intelligence and reporting experience in working with Oracle and Microsoft Reporting tools.

8+ years of experience in reporting using Microsoft SSRS and Power BI.

3+ years of experience in reporting using OBIEE /11g/10g/10.1.3.x and BI Publisher.

Expertise in writing complex queries for retrieving data from Oracle databases using PL/SQL.

Expertise in writing complex queries for retrieving data from MS SQL Server databases using T-SQL.

Expertise in creating datasets, reports in Power BI desktop. Expertise in creating datasets, reports and dashboards in Power BI Service.

Expertise in transforming data in Power Query Editor by, removing and adding custom columns, and merging tables and appending multiple tables.

Expertise in creating gateways to refresh data sets across various environments like DEV, UAT and Production.

Expertise in migrating reports to various environments like DEV, UAT and Production in Power BI Service.

Expertise in Power BI administration duties.

Expertise in creating reports with complex layouts in SSRS.

Expertise in creating tables in SSRS reports using row groups, column groups.

Expertise in creating reports with high cosmetic standards so that reports look pretty to end users.

Expertise in creating shared data sources, datasets, parameters in SSRS.

Expertise in editing and updating configuration properties of project details in SSRS solutions.

Expertise in deploying reports from SSRS to various environments of report manager.

Expertise in migrating report RDL files across environments like DEV/UAT and production.

Expertise in creating Data Sources in Report Manager of SSRS.

Expertise in creating and scheduling reports in Report Manager by creating Subscriptions from scratch so that reports can be emailed to end users according to desired requirements.

Database experience in Oracle 12c/11g/10g/9i/8i, and oracle DBMS Packages, oracle supplied utilities, TOAD.

Strong Knowledge of Data Warehousing concepts and Dimensional modeling using Star schema and Snowflake schema. Extensive experience in defining the overall data warehouse architecture.

Experience in database design and knowledge in Data Modeling.

Exposure to ETL process by looking at high level ETL process from OLTP to OLAP database.

Create data models and reports based on default layouts and RTF templates in BI Publisher.

Create report jobs in BI Publisher to schedule and deliver reports to end users through email.

Build complex SQL queries based on end user requirements and deliver data extracts to end users in the form of MS Excel spreadsheets.

Provide production support to OBIEE and BI Publisher reports by trouble shooting production issues.

Perform migration of BI Publisher and OBIEE reports from DEV to UAT/Production environments.

Excellent Team Management Skills with good business acumen, effective communicator, experience in working with Business Users and Senior Managers and Executives.

A Team Player with excellent communication, analytical, verbal and writing skills.

Technical Skills:

OLAP/DSS Reporting Tools: Power BI, SSRS, Microsoft SSDT for Visual Studio 2017, OBIEE 12c/11g, BI publisher.

Cloud Services : Microsoft Azure.

Database Tools : TOAD for Oracle, SQL Developer, MS SQL Server Management Studio

Databases : Oracle11g/10g/9i/ 8i/8, MS SQL Server Databases

Data Modeling Tools : ERStudio

Programming Languages : C, SQL, PL-SQL

Operating Systems : Windows 10/ Windows 7/XP/2000/NT/9x, MS-DOS

Markup Languages : XML

Employment History:

Schindler Elevator Corporation, BI Developer & Analyst May ’22 – Present

Morristown, NJ

Schindler Elevator Corporation a multinational company which manufactures elevators, escalators and moving walks, with its USA headquarters in Morristown, NJ. I worked on projects involving reports development on existing installations for this company. The work involved on creating reports and dashboards in Power BI.

Roles and Responsibilities:

Coordinate with BAs and gather business requirements for creating Power BI reports.

Analyze various manual reports in MS Excel and understand the logic behind report fields by coordinating with BAs to finally provide automated reports in Power BI.

Create connections to various sources like MS Excel and SQL server databases in Power BI using Direct and Import Query modes.

Transform data in Power Query Editor by merging tables using various joins like inner, left outer and right outer; and append tables.

Use Power Query Editor to choose columns, remove columns, keep rows, remove rows, split columns, sort columns based on other columns, etc.

Create data models in Power BI desktop based on database views, excel spreadsheets and star schema tables.

Create measure/fact tables in Power BI Desktop to gather all the required measures in groups.

Working on visualizations like tables, matrices, KPI Score cards, line charts, pie charts, bar charts, etc. to build Power BI reports.

Working on conditional formatting on various fields in tables and matrices.

Creating hierarchies in Power BI desktop and use them in drilldown in various visualizations such as matrices, line charts, pie charts and bar charts.

Working on reports in Power BI Desktop with drill through features.

Create new columns and measures in Power BI desktop using complex DAX calculations.

Provide data specific access to end users by performing row level security in Power BI Desktop and Power BI Service.

Create paginated reports in Power BI Report Builder.

Working on publishing reports to various environment specific workspaces in Power BI Service.

Create and maintain Gateways in Power BI service.

Providing access to various reports to end users by performing Power BI administration duties in Power BI Service.

Gather data refresh requirements from business and set up refresh intervals for reports in Power BI Service by using data sources and gateways.

Enable delivery of reports to end users through email by creating and configuring Subscriptions in Power BI Service.

Pinning of visualizations and reports to dashboards in Power BI Service.

Enable sharing of various reports to multiple users using their email ids in Power BI Service.

Perform unit testing of reports by verifying data in Power BI reports against the SQL query outputs using SSMS.

Environment: Power BI Desktop, Power BI Service, Power BI ReportSQL Server Management Studio v 18, MS Office 365, MS Word, MS Excel, MS Power Point, MS Outlook, Sharepoint, MS Teams, Microsoft Azure.

Unifeye Vision Partners, BI Developer & Analyst Mar ’21 – Apr ‘22

Dallas, TX

Unifeye Vision Partners is an integrated eye care community providing quality eye care services in the healthcare sector. I worked on projects involving reports development in SSRS for this company. I also worked on creating reports and dashboards in Power BI.

Roles and Responsibilities:

Gather business requirements for creating Power BI reports.

Create connections to various SQL server databases in Power BI using Direct and ImportQuery modes.

Create data model in Power BI desktop based on star schema data model.

Use Power Query Editor to choose columns, remove columns, keep rows, remove rows, split columns, sort columns based on other columns, etc.

Append and merge tables in Power Query Editor.

Create reports with various visualizations like tables, matrices, KPI Score cards, line charts, pie charts, bar charts, etc.

Create tables and matrices with conditional formatting on various fields.

Create hierarchies in Power BI desktop and use them in drilldown in various visualizations such as matrices, line charts, pie charts and bar charts.

Create reports in Power BI Desktop with drill through features.

Create new columns and measures in Power BI desktop using complex DAX calculations.

Perform row level security in Power BI.

Publish reports to various environment specific workspaces in Power BI Service.

Create and maintain Gateways in Power BI service.

Performing Power BI administration duties.

Set up refresh intervals for reports in Power BI Service by using data sources and gateways.

Create subscriptions in Power BI Service to deliver reports to end users through email.

Pin visualizations and reports to dashboards in Power BI Service.

Enable sharing of various reports to multiple users using their email ids in Power BI Service.

Perform unit testing of reports by verifying data in Power BI reports against the SQL query outputs using SSMS.

Gather business requirements for creating SSRS reports.

Maintain and create projects, solutions in Visual Studio for various reporting environments.

Work on creating shared data sources in SSRS on SQL server databases based on windows authentication and database credentials.

Create datasets in SSRS based on SQL queries after writing them in SSMS and testing the queries.

Create complex queries for SQL server databases using SSMS.

Create and maintain SSRS reports having tables, matrices and charts.

Migrate SSRS reports to DEV/PROD by deploying them to report manager.

Create and maintain shared data sources in SSRS Report Manager.

Migrate SSRS RDL files to DEV/PROD.

Create and maintain subscriptions on SSRS reports so that the reports can be delivered to end users daily, weekly or monthly based on the requirements.

Environment: Microsoft SSDT for Visual Studio 2019, Power BI Desktop, Power BI Service, SQL Server Management Studio v 18, MS Office 365, MS Word, MS Excel, MS Power Point, MS Outlook, Egnyte, MS Teams.

South Jersey Industries, Power BI/SSRS Developer & Analyst Jul ‘17 – Feb ‘21

Hammonton, NJ

South Jersey Industries is an energy services holding company based in New Jersey and delivers energy solutions to its customers. I am working with the EWAMS team as a BI Developer. My duty in this project is to develop reports from the Maximo database. The Maximo application is an asset management system which helps South Jersey Industries manage its assets and field activities in a timely and efficient manner. I worked on projects involving report development in SSRS for South Jersey Gas and Elizabeth Town Gas (which was acquired in this project by South Jersey Industries). Also, I worked on conversion of BI Publisher reports to SSRS platform. I also worked on creating reports and dashboards in Power BI.

Roles and Responsibilities:

Gather business requirements from various teams like operations and construction.

Connect to various data sources from Power BI desktop using Import and DirectQuery modes.

Used Power Query Editor for choosing columns, removing columns, keeping rows, removing rows, splitting columns, etc.

Create new columns, new measures in data in Power BI Desktop.

Create models in Power BI Desktop for star schemas and snowflake schemas and other data models.

Create reports with various visualizations like tables, matrix, KPIs, line chart, pie chart, bar charts, etc.

Create filters on visuals and report pages to view specific desired data in reports.

Create hierarchies on fields to enable drill downs in reports.

Create new columns using DAX functions.

Publish reports to specific workspaces in Power BI Service.

Create various gateways for pointing data sets to various environments like DEV, UAT and Production and refresh data in the data sets in Power BI Service.

Migrate reports across environments like DEV, UAT and Production by uploading .pbix files to environment specific workspaces.

Create dashboards by pinning visualizations and reports in Power BI Service.

Share reports and dashboards to other users by using share feature and entering email ids of users in Power BI Service.

Perform Power BI Admin duties and maintain workspaces, apps, dashboards, etc.

Migrate old SQL code from BI Publisher reports to SSRS Reports and archive the old SQL code.

Create solutions in Visual Studio for various reporting environments.

Create projects in solutions in Visual Studio for corresponding modules in Maximo application.

Create Shared Data sources on oracle databases in projects by getting the database connection details form DBAs.

Write complex SQL queries in TOAD and SQL Developer based on the requirements for individual reports.

Write complex queries in SSMS for pulling data from MS SQL Server Databases.

Create complex layouts for SSRS Reports by inserting objects like tables, matrix, text boxes, charts, images, etc.

Create tables with column groups, row groups in SSRS reports.

Create parameters in SQL queries and use them to filter data in SSRS reports.

Use functions such as text functions, Date & Time, Program Flow, Aggregate functions etc. in SSRS reports.

Obtain details about Configuration properties like TargetDataSourceFolder, TargetReportFolder, TargetServerURL to various environments from administrators and update the details in Project properties.

Migrate RDL files of reports to various environments like DEV/UAT and Production.

Deploy Reports to various environments like DEV/UAT and Production.

Deploy new projects to various environments like DEV/UAT and Production.

Create data sources in SSRS report manager.

Create subscriptions on various SSRS reports in report manager for delivering reports through email to end users.

Environment: Microsoft SSDT for Visual Studio 2017, Power BI Desktop, Power BI Service, Toad for Oracle, SQL Developer, SQL Server Management Studio v 17.9.1, MS Office 365, MS Word, MS Excel, MS Power Point, MS Outlook, HP-ALM, Solve It Now, Sharepoint, MS Teams.

South Jersey Industries, OBIEE/BI Publisher Developer & Analyst Jul ‘17 – Jul ‘18

Hammonton, NJ

South Jersey Industries is an energy services holding company based in New Jersey and delivers energy solutions to its customers. I worked with the EWAMS team as a BI Developer. My duty in this project is to develop reports from the Maximo database. The Maximo system is an asset management system which helps South Jersey Industries manage its assets and field activities in a timely and efficient manner.

Roles and Responsibilities:

Coordinate with Business Analysts, ETL Team, BI Team, QA Team to understand and gather business requirements.

Organize information on business requirements based on the documents provided by Business Analysts and online tickets.

Analyze and understand ETL processes by coordinating with ETL Team and data warehousing team.

Develop all three layers namely Physical, BMM and Presentation layers in RPD according to data modeling and requirements.

Develop complex and interactive reports and dashboards in OBIEE Analytics based on requirements.

Write complex SQL queries for reports to develop Data Models in BI Publisher according to end user requirements.

Develop complex report layouts and RTF templates for BI Publisher reports.

Coordinate with DBAs to improve performance of reports by providing DBAs with backend SQL queries of reports for indexing.

Develop report jobs to schedule reports and deliver reports in desired formats to end users in a timely manner through email.

Develop bursting queries in data models of reports to burst out reports to end users based on the requirements.

Build and run SQL queries based on end user requirements to deliver data extracts in the form of Excel files to end users.

Assist administrators in migrating reports and data models across environments from DEV to UAT/Production.

Provide production support by maintaining reports and report jobs in production environment and troubleshoot issues in production.

Perform training sessions for end users to train them on accessing and navigating reports and dashboards.

Prepare documentation on navigating reports and dashboards to provide the same to end users.

Environment: OBIEE 12c, OBIEE 11.1.1.6.0, BI Publisher, Toad for Oracle, SQL Developer, MS Office 365, MS Word, MS Excel, MS Power Point, MS Outlook, HP-ALM.

Vensai Technologies, Inc. Power BI /SSRS/OBIEE Developer & Analyst Jan ‘16 – Jun ‘17

Cumming, GA

Vensai Technologies, Inc is a software service provider and staff consulting company based in Cumming, GA. I worked with the HR department as a BI Developer. My duty in this project was to develop reports for the HR department.

Roles and Responsibilities:

Gather business requirements by coordinating with Business Analysts, Project Managers and end users.

Create reports using Power BI Desktop.

Use Power BI desktop to create new columns, new measures in data and use Power Query Editor for choosing columns, removing columns, keeping rows, removing rows, splitting columns, etc.

Perform data modeling in Power BI Desktop by creating star and snowflake schemas.

Create reports with filters on visuals and report pages and visualizations such as tables, matrix, line chart, pie chart, bar charts, etc. in Power BI Desktop.

Create hierarchies for drill downs in Power BI reports and new columns with DAX functions in Power BI reports.

Create gateways to point and refresh data in datasets to various environments such as DEV/UAT and Production.

Create environment specific workspaces and migrate reports across environments by publishing .pbix files to environment specific workspaces.

Create dashboards in Power BI Service and share reports and dashboards with users using their email ids.

Writing complex SQL queries using TOAD to retrieve data from Oracle databases and use the queries in SSRS and Power BI reports.

Create reports in SSRS using various objects like tables, matrix, text boxes, charts, images, etc.

Schedule SSRS reports by creating subscriptions in SSRS to deliver reports to end users as per the desired schedules.

Migrate SSRS reports across various environments such as DEV/UAT and Production by using RDL files and also implement security for reports so that specific AD groups or users can access reports.

Gather business requirements and create time/deadline schedules for the Amnesty project by coordinating with Business Analysts and data warehousing team members.

Attended meetings with enterprise architects, DBAs and data warehouse team to understand, design, configure and implement overall solutions for OLAP and OLTP databases, etc.

Coordinated with various teams and 3rd party vendors for implementing the dashboards by attending brain storming sessions.

Understood ETL process by coordinating with data warehouse team members.

Created new connection pools in physical layer for new schemas.

Worked with star and snowflake schemas at physical and logical level based on the data models created by data modeling team.

Identified facts and dimensions while performing dimensional modeling along with data warehousing team.

Imported new tables in physical layer in RPD and created alias tables for the new tables.

Built start schema model in RPD at the Physical level by joining fact table with various dimension tables.

Created a new business model by joining fact table to dimension tables by performing inner and right outer joins.

Created new logical tables, LTSs and logical columns in BMM layer by using complex case statements.

Created calculation measures from other existing logical columns using functions in expression builder.

Created complex hierarchies, level-based measures in BMM layer for use in drilling down in end reports.

Created initialization blocks and variables using variable manager.

Assisted in developing test cases for new reports.

Created new subject areas, presentation tables and presentation columns in presentation layer.

Renamed and ordered presentation columns in presentation tables.

Built SQL queries of reports developed in OBIEE so that QA can test and verify reports.

Created pie charts in Analytics for displaying statistics of payments received from taxpayers.

Created table views and pivot table views in Analytics for displaying number of taxpayers and payments made by taxpayers through payment plans and one-time payments.

Created table views using case statements for displaying counts of liabilities and tax amount received by county and state.

Created analyses having complex filters with complex case statements.

Created dashboard prompts for filtering data at the report and dashboard levels.

Formatted reports by understanding requirements of end users such color, font size, conditional formatting, etc.

Created complex reports and dashboards having drill down capabilities to other reports, web pages, etc.

Created dashboards and placed all developed reports on various dashboard pages.

Created KPIs, KPI watch lists, score cards according to end user demands for complex reports in dashboards.

Implemented object level security for various objects such as KPI watch lists and score cards.

Created agents to schedule content delivery (such as reports) to end users at specified time intervals.

Created ad-hoc environments and trained end users on how to create ad-hoc reports.

Environment: Microsoft SSDT for Visual Studio 2014, Power BI Desktop, Power BI Service, OBIEE 12c, OBIEE 11.1.1.6.0/11.1.1.9.0, OBIEE 10g, BI Publisher, Toad for Oracle, SQL Developer, MS Word, MS Excel, MS Power Point, MS Outlook.

Department of Revenue, OBIEE Developer & Analyst Jun ‘15 – Dec ‘15

State of Indiana, Indianapolis, IN

Department of Revenue of State of Indiana deals with all the revenue processes and procedures for the State of Indiana. I worked on the Amnesty project with this organization. The Amnesty project is being implemented so that taxpayers can get the privileges of clearing all their past tax liabilities with State of Indiana without paying penalties. The taxpayers need to pay only the base tax. I am working as an OBIEE developer for developing dashboards for this project. I also worked on the Fraud Protection project for this client with tools such as SSRS and Power BI.

Roles and Responsibilities:

Gather business requirements for the Fraud Protection project by coordinating with Business Analysts, Project Managers and end users.

Use Power BI to connect to various Oracle databases in Import and DirectQuery modes.