PROFESSIONAL SUMMARY:

• A seasoned Business Intelligence Analyst with seven years of experience driving businesses to make the right decisions from the initial idea around capturing data, through data preparation, analysis, management, all the way to building powerful & insightful reports and solutions.
• A skilled IT professional, solving business challenges by aligning needs with enterprise innovations.
• Qualified IT professional with seven years of experience working on projects with Business Intelligence tools like Power BI, SSRS, Tableau in diverse roles across the organizational hierarchy.
• Have good experience in Developing Power BI dashboards including creating Data Model, Custom visuals, Filters, different kind of Charts, format the data and publishing multiple reports as per user views/ Client requirements using Power BI.
• Advance data modeling using DAX, power query/edit query in Power BI desktop, and working with custom visuals.
• Experience with Power BI Tools - power bi desktop, power pivot, power query, power view, power map, power bi dashboard, calculated columns and calculated measures using DAX, data modeling
• Expertise in creating Workflows based on Functional Specification Document.
• Proficient in optimizing SQL queries, performance tuning.
• Created various types of charts like Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, TreeMaps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop, Power BI, and Excel to provide better data visualization.
• Expert in generating on-demand and scheduled reports for business analysis or management decisions using POWER BI.
• Created Excel reports, Dashboards & Performing Data validation activity VLOOKUP, HLOOKUP, Macros, formulas, index match, Slicer with (Pivot table, Get Pivot Data, Dashboards), Power View, Power Map, and Heat Map.
• Expert on Microsoft Power BI reports dashboards and publishing to the end-users for executive-level Business Decision.
• Expertise in creating and maintain Workspace and Gateways.
• Expert on maintaining and managing POWER BI driven reports and dashboards.
• Experience in configuration and maintain report manager and report server for SSRS deployed and scheduled the reports in report manager.
• Good Experience in Cloud environment Azure, AWS and GCP.
• Strong experience in fixing bugs in existing system and creating ad-hoc reports based on user requirements.
• Conceptually strong with an innovative and analytical approach to the work with an eye for detail. Enriched with the ability to learn new concepts & technology within a short span of time
• Experienced in all facets of software development life cycle (analysis, design, development, testing, and maintenance) using a waterfall and agile methodologies.

SKILL:

Database: MSSQL 2008, 2012, 2014, 2016, 2018

Operating Systems: RHEL 5x, 6x,7x, 8x, OEL, Windows

Programming Languages: SQL, Python

BI Tools: Power BI, Tableau

ETL & Data Modelling Tools: SSIS, Azure Data Factory, ERWIN

SDLC Experience: Agile and Scrum Methodology

PROFESSIONAL EXPERIENCE:

Confidential

Power BI Consultant

Responsibilities:

• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Created DAX Queries to generate computed columns in Power BI.
• Generated computed tables in Power BI by using DAX.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Creating and managing Power Bi Gateway and workspaces, Migrating dashboards from one environment to another.
• Created power bi reports and deployment them in shared workspaces, along with automating them using both gateway and share point (cloud services).
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI. Utilized Power BI gateway to keep dashboards and reports up to date with on-premises data sources.
• Experience in working with Power BI Admin Portal, and azure active directory in Azure portal.
• Good Knowledge with DAX to create measures, calculated columns, transform various data sets into enterprise data models and application specific solutions.
• Designed expressions to calculate, group, filter, parameterize, and format report contents.
• Designed for Power - BI report designs including backgrounds, buttons and logos etc.
• Utilized multi-dimensional and tabular model in analysis services to pull and generate reports directly from in-memory from backend relational data sources.
• Creating functions in Power BI report by creating toggles, Navigation panes, drill through filters, dill down reports, data hierarchies and conditional formatting visuals.
• Delivered on-demand reports in multiple rendering formats with standard and data-driven subscriptions.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Led all sprint planning, sprint reviews, sprint retrospectives and daily scrums with the development team resulting in DEV, QA and Prod.
• Developed Data Mapping, Performance Tuning, and Identifying Bottlenecks of sources, mappings, targets, and sessions.

Confidential

B.I Developer

Responsibilities:

• Partner with business stakeholders to design reports, visualizations, and dashboards to support strategic decision making.
• Gathered and documented business requirement for analytical reports. Participated in requirement meetings and data mapping sessions to understand business needs.
• Worked on both live and import mode to bring data to Power BI for creating reports. Used Power BI gateway to schedule daily job to refresh data and establish RLS (Row Level Security).
• Created complex SQL scripts to extract data from Oracle, SQL Server, Data Lake, Hive to make data available for enterprise reporting.
• Design and write elastic queries to access data across database and Migrate an existing Oracle Database to Azure Database using Azure Data Factory.
• Created user-friendly and dynamic dashboards and reports with KPIs, heat maps, scatterplots, bar charts, slicers, Drilldown and drill through features.
• Created DAX Queries to generate calculated columns and measures in Power BI.
• Expertise in data preparation with experience in blending multiple data connections and creating multiple joins across the same and various data sources.
• Used and created various visualizations in reports like scatter plot, box plot, Sankey chart, bar graphs, Gantt charts, trend lines, waterfall charts, statistical models, heat maps, and geo-maps end-users to utilize the full functionality of the dashboard.
• Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh.
• Used Parameters and Quick filters, Dynamic X and Y axes using Parameters, Table Calculations.
• Solid experience in building interactive reports, dashboards, and integrating modeling results and have strong Data Visualization design skills and analytic background by using POWER BI and Tableau desktop.
• Created complex dashboard using parameters, sets, groups, and calculations and drill down and drill up in worksheets and customization using filters and actions.
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.

Confidential

Business Intelligence Analyst

Responsibilities:

• Support the design, build, and maintenance of automated reporting, dashboards, and analysis to enable our team to self-service most of their regular BI data needs, allowing you to focus on answering hard, strategic, and ambiguous problems that will move the needle in terms of customer adoption.
• Deliver timely, accurate and professional technical assistance to internal colleagues. Have the ability to dive deep into how their needs can be met with existing (and new) metrics and insights to grow adoption
• Design and drive experiments to form actionable recommendations to grow adoption. Present to business teams in both ad-hoc forums and routine monthly and weekly business reviews to drive decisions
• Support the operationalization and maintenance of a customer ‘subscription funnel’ to help grow adoption by analyzing customer activity across things like views and engagement time, to frequency of data exports and % of products exported vs subscribed to.
• Develop queries and visualizations for ad-hoc requests and projects, as well as ongoing reporting
• Develop a deep understanding of AWS’s vast data sources and know exactly how, when, and which data to use to solve business problems
• Define analytical approaches and metrics strategy to uncover new customer insights
• Have familiarity with Salesforce reporting, dashboards, goal setting and opportunity management
• Establish ways to measure and track metrics related to adoption of AWS Data Exchange products, and make improvements to the approach based on those measurements

Confidential

BI Analyst

Responsibilities:

• Build and provide reports initiated from business reporting requests.
• Responsible for the whole project life cycle of Maintenance and Support Group, which includes gathering the tickets generated by the business users and resolves the tickets raised by delivering on-time solutions.
• Migrated Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, and Density Chart to Power BI reports dashboards.
• Developed donut charts and implemented complex features in charts like creating bar charts in the tooltip.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and table calculations.
• Created DAX Queries to generated computed columns in Power BI.
• Generated computed tables in Power BI by using DAX.
• Involved in creating and optimizing stored procedures and queries.
• I am experienced in designing and developing large amounts of enterprise reports (Power BI) using the data from ETL Loads, SSAS Cubes, and various heterogeneous data sources.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Published Power BI Reports in the required originations and Made Power BI Dashboards in Web clients and mobile apps.
• Experience in developing dashboard reports, parameterized reports, linked reports, sub-reports by region, year, quarter, month, and week.
• Explore data in a variety of ways and across multiple visualizations using Power BI
• I have used Power BI Gateways to keep the dashboards and reports up to date.

Confidential

Business Intelligence Developer

Responsibilities:

• Build and provide reports initiated from business reporting requests.
• Designed and developed various SSIS packages (ETL) to extract and transform data and Scheduling SSIS Packages.
• Developed and maintained ETL (Extract, Transform and Load) mappings to extract the data from source Netezza database and loaded it into Oracle tables.
• I am involved in Database migrations from legacy systems, SQL Server to Oracle.
• Validated and modified the data using various Data Flow Transformations like Send Mail, Web Services, File System Task, Conditional Split, Lookup, Term Extraction, Pivot, Multi-Cast, Derived Column, Audit, and Data Conversion, etc.
• Scheduled the SSIS packages to run at various intervals to load the data into SQL Server. Involved in Maintenance and Deployment of SSIS Packages.
• Developed Custom Reports by Ad-hoc Reports using SQL Server Reporting Services (SSRS).
• Developed Tabular, drill down, parameterized, cascaded, and sub-reports using SSRS.
• Generated Reports using Global Variables, Expressions, and Functions based on the requirements in SSRS.
• Created Parameterized Reports and Linked Reports and thorough knowledge of report server architecture using SSRS.
• Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures, and User- Defined Functions.
• Ability to perform duties in a speedy pace environment and ability to learn new technology.