SUMMARY:

●**+ Years of experience in Data Warehousing & Business Intelligence

●Good Experience in Power BI Reports and Dashboard Development

●Implemented Securities like Row Level Security (Dynamic & Static)

●Good knowledge of Data warehousing concepts

●Good Experience in Data Modeling and Data Analysis

●Good hands-on experience in the Snowflake Schema & and Start Schema model.

●Good knowledge of Power BI on-premises and Cloud & handling large volume of data

●Good experience in developing models & and implementing start schemas and snowflake schemas.

●Developed various solution-driven views and dashboards by developing different chart types including. Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI

●Good Experience in Production support (L2 & L3) and Experience in Leading the Team

●Proficient in writing DAX queries & and DAX Studio

●Worked on Azure Data Factory to orchestrate the ingestion of data from various sources like Azure

●tables, Azure SQL Database, Azure SQL DWH, Azure Storage Blobs, and on-premises databases to

●Azure Data Lake Store.

●Extensive testing ETL experience using Informatica 9.1/8.6.1/8.58.1/7.1/6.2/5.1 (Power Center/ Power

Mart) (Designer, Workflow Manager, Workflow Monitor, and Server Manager) Teradata and Business Objects. Ulti-Industry Experience: Resources (Oil & Gas, Utilities & Chemicals), Finance (Credit Card & Insurance- Auto, Life) & Logistics.

●Good working experience on object-oriented programming like Java & and Python

●Integrated Microsoft 365 services such as MS Teams with both Power Apps and Power Automate SQL.

●Published Power BI Reports visualization development in the required originations and made Power BI Dashboards available to Web clients and mobile apps.

●Suggested and Implemented Tibco best practices for Performance and Tuning.

●Strong Data Warehousing ETL experience using Informatica 9.1/8.6.1/8.5/8.1/7.1 PowerCenter.

●Client tools - Mapping Designer, Repository Manager, Workflow Manager/Monitor and Server tools Informatica Server, Repository Server manage. Wrote scripts to analyze objects and schemas of Oracle databases.

●Experience in building and retrieving data using Universes, Personal data files, and creating

●complex ad-hoc Reports using the Business Objects suite applications.

●Hands-on experience in the development and extension of RICE components using SQL and PL/SQL,

Customization of forms using Custom, reports using Report Builder 6i, XML Publisher, and exposure to WF and consultant Oracle Discoverer.

●Good Knowledge of Cloud Datawarehouse – Snowflake

●Strong experience in Extraction, Transformation, and Loading (ETL) data from various sources into

●Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer,

Workflow Manager, Workflow Monitor, Metadata manager), Power Exchange, Power Connect as ETL tool on Oracle, DB2, and SQL Server Databases

●Experienced in Automating business processes with Power Automate SQL (MS Flow)

●Good Experience in Migration projects like Legacy BI tools to Power BI

●Migration of traditional infrastructure to cloud-based automated infrastructure

●Testing, Migration, Security management, and Production support.

●Excellent skills in understanding business needs and converting them into Technical Solutions.

●Good experience in creating reports in Power BI, like drill-through Reports and drill Reports.

●Good Experience in Develop Complex Reports and Dashboards.

●Experienced in Training & Supporting end-user reporting needs using Business Objects.

●Worked on DAX expressions and created the calculated columns and measures using DAX expressions.

●Provided the Analysis, Assumption, Forecasting, and Summary created based on the Data provided.

different report visualizations development and Synopsis.

●Used Tibco utilities like domain utility, AppManage, and builder.

●Hands-on experience in designing and developing cloud solutions based on Microsoft Power Bi

●Platform using Power Apps, Power Automate, Power BI, Power Apps Portal, and Common Data

Service (CDS).

●Good experience in Unit testing and making sure that the report is working as per the requirement.

●Configured report properties like data source, target data source folder, target report folder, etc. before deploying the reports.

●Good experience in creating and reviewing KPIs and models.

●Knowledge of ETL Tools like Informatica and Data Stage.

●Good Knowledge on Agile Methodology and JIRA Ticketing tool

EDUCATION:

Bachelor’s in information technology from JNTUH, India.

TECHNICAL SKILLS:

Reporting Tools : Power BI, Power BI Services, Power Query, Cognos 8.1/8.4/10.2/11, Azure DevOps

ETL Tools: Informatica and Data Stage

Data Base : Snowflake, Azure Analysis Services, SQL, MSSQL, MySQL,

Languages : SQL, T-SQL

Other Tools : DB Visualizer 8.0, TOAD, File Zilla, Putty, MS SQL Server Management Studio

PROFESSIONAL EXPERIENCE:

BBW, OH June 2022 – Current

Senior PowerBI Developer

Responsibilities:

●Collaborate with stakeholders to gather requirements – Business Analyst functions.

●Work closely with business users and analysts to understand their reporting needs.

●Understand business requirements to set functional specifications for reporting applications.

●Design, develop, and optimize data models, ETL processes, and data visualization components.

●Implemented Machine Learning algorithms with Python NLTK classifiers, NumPy, SciPy, Pandas,

Django

●Implement data integration and transformation strategies to ensure data accuracy and consistency.

●Translate business requirements into technical specifications for BI solutions.

●Identify and resolve data-related issues, performance bottlenecks, and system errors.

●To identify KPIs with clear objectives and monitor them consistently.

●Developed Universe using Designer module in Business Objects.

●Involved in gathering, analyzing, and documenting business requirements, functional requirements Analyzing data and presenting it through reports can help in decision-making. and data specifications for Business Objects Universes and Reports.

●To be able to convert business requirements into technical specifications and decide the timeline to tasks.

●Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and

Workflow Monitor.

●Developed Auto retrieval and insertion of NOSQL data using PyMongo and MongoDB with Python

programming.

●Experience in Using Oracle standard API, Forms personalization, and Extensions.

● Extensive experience in utilizing Oracle Utility tools like Toad, SQL*Loader, Import and Export.

●To design, develop, and deploy Power BI scripts and perform efficient detailed analysis.

●To perform DAX queries and functions in Power BI

●Developed various dashboards to know the school climate, school safety, risk factors, and risk behaviors.

●Created a dashboard for school system financial information which includes revenue and expenditure by district.

●To create charts and document data with algorithms, parameters, models, and relations explanations

●To conduct data warehouse development

●Tuned the Informatica mappings for optimal load performance.

●To perform SQL querying for best results

●Developed Employee Nomination System using PowerApps and Microsoft Flow.

●Experienced in rebuilding SharePoint Designer / Nintex workflows to Microsoft Power Bi Automate SQL

●Extensively used the @functions and Aggregate Aware feature. Worked on back end views, tables

●required by the business objects universes..

●Overall project manager for new LOB called “Technical Controls”, which is an umbrella category for

monitoring and control/automation of rental equipment (tanks, pumps, filtration) for liquid management

solutions using IoT devices, GPS Tracking of equipment, and reporting. Initial business areas included

Oil & Gas (Frac), Refinery & Construction sites.

●Developed data capture and navigation desktop and mobile apps in Microsoft Power apps that connect

to distribution center solutions design analytics in Power BI.

●Use filters and graphs to better understand data.

●Design data models to convert raw data to meaningful insights

Environment: Power BI, SharePoint, SQL

Safelite AutoGlass, OH March 2021 – June 2022

Senior PowerBI Report Developer

Responsibilities:

●Understand the Business logic and implement same in Power BI

●Understand business requirements to set functional specifications for reporting applications.

●Be able to quickly shape data into reporting and analytics solutions.

●To create dashboards and visual interactive reports using Power BI

●To identify KPIs with clear objectives and monitor them consistently.

●Analyzing data and presenting it through reports can help in decision-making.

●To be able to convert business requirements into technical specifications and decide the timeline to accomplish tasks.

●Ability to install TIBCO.

● products and setup multiple Tibco Domains for an organization

●Created and Configured Workflows and Sessions to transport the data to the target warehouse Oracle.

tables using Informatica Workflow Manager

●Developed Python script for processing large data sets and extracting data from different files.

●Built Python Modules to deliver specific formats of data.

●Performed development, testing, and integration of Oracle application objects (Oracle forms and

reports) and Oracle database objects (tables and views)

●To design, develop, and deploy Power BI scripts and perform efficient detailed analysis.

●To perform DAX queries and functions in Power BI

●Set up groups and users for Business Objects deployment.

●To create charts and document data with algorithms, parameters, models, and relations explanations

●To conduct data warehouse development

●Administrative experience in TIBCO EMS/JMS installing the EMS, creating Queues, Topics, Users, and Roles configuring various EMS options.

●Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions, and packages to migrate.

data from SQL server database to Oracle database

●To perform SQL querying for best results

●To use filters and graphs for a better understanding of the data

Environment: Power BI Desktop, Power BI Services, SharePoint, SQL

Microfocus, OH Jan 2019 – Feb 2021

PowerBI Developer

Responsibilities:

●Collect the Business Requirements and understand business requirements in the BI context.

●Design data models to convert raw data to meaningful insights.

●Connecting different data sources in Power BI reporting by creating relationships between them

●Create calculated columns and tables by combining two or more elements of existing data.

●Using the Performance Analyzer to measure and improve the performance of your data model.

●To create dashboards and visual interactive reports using Power BI

●Manage the deployment activities with IT and business units.

●Review, analyze, and create detailed documentation of use cases.

●Implemented Power BI security model (RLS, Object level, etc.)

●Strong analytical and problem-solving skills

●Used Machine learning using “Python-Programming Language” for converting different language text to English for analysis.

●Developed testing scripts and test cases. Extensively tested Business Objects reports, dashboards.

and other Business Objects Applications in a new environment.

●Performance tuning of Oracle Databases and User applications

●Created Power Automate SQL flows to automate business processes for a variety of use cases.

●Developed solutions for SharePoint Online, Power Apps, and Power Automate SQL

●Provided operational support for SharePoint Online, OneDrive for Business, Power Apps, and Power Automate services SQL.

●Coordinated with DBA and Business objects designer group in solving various technical issues.

●Created various SSIS packages for data movements and transformations. Worked on Python code to

●load data from Google buckets to big query tables, used data flow for ELT (Extract Load Transform) in Big Query

●Installed, configured, and maintained Oracle databases on Linux and Solaris environments.

●Good experience in implementation and customization of Oracle Application modules for Order

Management, Shipping, Inventory, and Advance pricing modules.

●Translate business requirements into output mock-ups as required for a visual representation of business expectations.

●To identify KPIs with clear objectives and monitor them consistently.

●Analyzing data and presenting it through reports can help in decision-making.

●To be able to convert business requirements into technical specifications and decide the timeline to accomplish tasks.

●Used Aggregate awareness function of Business Objects to route the query objects through the

●appropriate path while selecting from multiple contexts.

●Migrated and upgraded Oracle database from 9i to 10g on the Veritas Cluster environment.

●To design, develop, and deploy Power BI scripts and perform efficient detailed analysis.

●To perform DAX queries and functions in Power BI.

●To create charts and document data with algorithms, parameters, models, and relations explanations.

●To conduct data warehouse development.

●To perform SQL querying for best results.

●To use filters and graphs for a better understanding of the data.

●To define and design new systems by analyzing current ETL processes.

●To make technical changes to existing BI systems to enhance their working.

Environment: Power BI, SharePoint, SQL, MySQL

Capgemini, TX Jan 2016 – Dec 2018

PowerBI Reports Developer

Project Name : Reyes Beer Division

Client : Reyes Holdings

Role : Power BI Report Developer

Environment : Power BI, Snowflake

Duration : Nov 2016 to Dec 2018

Responsibilities:

●Migrating the Reports from Cognos to Power BI

●Perform installation, configuration, and Oracle databases on Solaris, Linux, HP-UX, and VMware.

●Understand the Business logic in Cognos and Implement the same in Power BI

●Prepare Logical Model and Physical Model If needed.

●Experience in creating datasets and data flows.

●Used Table, Matrix, Bar, Card and multi cards, Gauge, multi and hierarchy slicers, graphs, and custom visualizations.

●Configured and Tested Backups for Oracle Databases by restoration and recovery

●Attended the daily Scrum Calls.

●Involved in gathering, analyzing, and documenting business requirements, functional requirements

and data specifications for Business Objects Universes and Reports

●Worked on DAX expressions like filters, Aggregate, and Mathematical Functions

●Created a New Calculated Column and Measured using DAX Expression.

●Comfortable in working with filters/calculated columns/measures/relationships and transformations of the Edit Query section.

●Implemented Row Level Security

●Interacted with the client-side team to gather the requirements.

●Attended daily and weekly status meetings with clients.

●Follow the Agile Mythology and attend daily scrum meetings.

Project Name : Alterra Daily Management Reporting

Client : Alterra Mountain, USA

Role : Power BI Report Developer

Environment : Power BI, SQL Server

Duration : Jan 2016 to Oct 2016

Responsibilities:

Prepare Power BI Design Notes Documents

Prepare Logical Model and Physical Model

Used Table, Matrix, Bar, Card and multi cards, Gauge, multi and hierarchy slicers, graphs, and custom visualizations.

Created the reports using Business Objects functionality’s like Queries, Cross Tab, Master Detail and

Formulae’s etc.

Upgraded Oracle Database from 9i to 10g and 11g.

Worked on DAX expressions like filters, Aggregate, Mathematical Functions

Created New Calculated Column and Measure using DAX Expression.

Comfortable in working with filters/calculated columns/measures/relationships and transformations of the Edit Query section.

Developed complex queries and PL/SQL procedures in a Data Warehousing environment to facilitate.

strategic plans for higher levels of management. Created Oracle database redo log members and groups.

Created Business Objects Repository while building Business Objects solution

managed online redo log files. Responsible for Oracle database performance tuning

Design PoC Reports as per Customer request.

Implemented Row Level Security

Coded PL/SQL Procedures, table Packages, and UNIX shell scripts for selecting data from Oracle database.

Interacted with the client-side team to gather the requirements.

Design various kinds of reports in Power BI and present them to Clients for Approvals

Attended daily and weekly status meetings with clients.

Follow the Agile Mythology and attend daily scrum meetings.

Infosys, India Feb 2012 – Aug 2015

Cognos/PowerBI Developer

Project Name : Apollo Munich Health Insurance

Client : AMHI

Role : Production Support Lead (24X7) & Support

Environment : SSRS, Power BI, SQL & Production Support

Duration : Oct 2013 to Aug 2015

Responsibilities:

●Developed multiple Dashboards using Power BI like Performance, summary, and Trend Dashboards.

●Deployed Power BI reports and dashboards into the Power BI cloud using o365 authentication.

●Designed and developed matrix and tabular reports with drill-down, and drill-through options.

●Deploy the Reports in Power BI

●Created linked reports, sub-reports, and Drilldown Reports using Power BI

●Created cascading parameters and multi-value parameterized reports.

●Used expressions to Calculate, Group, Filter, Parameterize, and format the content of the report.

●Involved in Report Deployment & Performance tuning.

●Worked with Report Data, Design, and Preview tabs to create data sets, to define the report.

●Layout and view the data respectively.

●Configured report properties like data sources, target data source folder, target report folder, etc. before deploying the reports.

●Handled the L2 and L3 level issues raised by customers.

●Led the Production support team and set daily status meetings with the team.

●Dashboard and report development expertise

●Power BI Admin Skills

●Developed Business Objects Universes with classes, objects and condition objects and developed

hierarchies to support drill down reports.

●Expertise in Business Objects enterprise Products (Universe Designer, Desktop Intelligence, Web

Intelligence, Info View, CMS, CMC & CCM) and its deployment

●Experience supporting large user communities.

●Experience working with Client Support to close out tickets.

Project Name : UNUM, UK

Client : UNUM

Role : Cognos Report Developer & Production Support Lead

Environment : Cognos 10.2, Framework Manager and DB2

Duration : Feb 2012 to Sep 2013

Responsibilities:

Handling Support team and good experience in Production support (L2 & L3)

Migrating the reports from Cognos 8.4 to Cognos 10.2

Creating List, Crosstab reports & Active Reports

Creating Master Detail Report & Drill Through & Drill up and Drill Down Reports

Working with filters, Dynamic Filters, and Prompts

Worked on Administration and Security settings.

Performance tuning on the Cognos level

Creating a Model by using Framework Manager and Updating the model according to customer request.

Created reports using Business Objects functionality like slice and dice drill down, cross tab,

master detail tables and formulas, etc.

Schedule the reports by using Cognos Connections.

Creating different kinds of Charts like lists, Bars, Pie charts, and Cross Tab reports.

Prepare project-related Business Requirement Documents & End User Documents

Working on Administration & Security Settings

Resolving Ticket Issues and CRs (Change Requests) and Leading the Production Support team.

Database support to Onsite and offshore teams.

Scheduling the reports & and Worked on Report enhancements.

Wipro, India Oct 2010 – Jan 2012

Cognos Developer

Project Name : SBI Enterprise Data Warehousing Project (SBI-EDWP)

Client : State Bank of India (SBI)

Role : Cognos Report Developer

Environment : Cognos 10.2, Framework Manager and DB2

Duration : March 2011 to January 2012

Responsibilities:

●Business Requirement gathering - Meeting with Business Users and setting up Workshops and Document creations.

●Develop the Business Requirement Validation Document (BRVD) Source System Mapping.

●Involved in Unit Tests and writing Test Cases.

●Gathering the Requirements from the Client.

●Creating List and Cross Tab Reports, Creating Drill through Reports and Master Detail Relationship.

●Working in different types of Prompts and Filters.

●Creating New Jobs using Cognos Connection.

●Using Framework Manager, Creating Projects and publishing.

●Renaming the Query Item name and Query Subject Names and Publish the Packages.

Project Name : WABCO Consultancy Project

Client : WABCO Germany and France

Role : Cognos Report Developer

Environment : Cognos 8.4, Framework Manager

Duration : October 2010 to March 2011

Responsibilities:

Designing the Dashboard Layouts.

Developing Dashboards according to customer request.

Testing the Reports and Dashboard.

Creating Line and Bar Charts.

Ad-hoc reports were used for Business Objects user modules for various portfolios using the

Universes as the main Data providers.

Preparing Report Specifications and Creating List and Cross Tab Reports.

Creating Drill Through reports and Master Details Relationships.

Develop the reports with conditional formatting.

Apply Filters in FM level, creating Projects and Publish the Package.

Creating New Jobs using Cognos Connection.

Contact this candidate