SUMMARY

• 15+ years of experience in Information Technology in System analysis, design, development, Implementation, and maintenance of Data Warehouse project, providing Business Intelligence through Power BI Dashboards and Reports in SDLC and Agile environment.
• Extensive experience in Power BI development skillset including visualization development, use of parameters, and report optimization.
• Experience in working with ETL team on Data Migration using SQL, SQL Azure, Azure storage, Azure Data Factory, SSIS and PowerShell
• Worked with ETL team in Defining the transformation logic in the ELT (Azure Data factory) and SSIS
• Extensive exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support.
• Strong knowledge of data warehousing methodologies and Agile methodology.
• Involved in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc. using Power BI and Tableau.
• Generated context filters and data source filters while handling large volume of data.
• Involved in creating Filters, quick filters, table calculations, calculated measures and parameters in Power BI.
• Have good experience in creating advanced chart types, visualizations and complex calculations to manipulate the data as per business need through Power BI.
• Experienced in Supporting end - user reporting using Power BI.
• Experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export using ETL tools such as SSIS and Informatica. Experience in testing and writing SQL statements.
• Hands on experience with MSBI (SSIS) to extract, transform and load data into database.
• Part of the end user team where in gathered requirements and daily scrum meetings.
• Prepared projects, dashboards, reports and questions for all JIRA related services.
• Good experience in Migration of Reports & Packages in different environment.
• Mastered the ability to design and deploy rich Graphic visualizations using Power BI and Tableau.

TECHNICAL SKILLS

ETL Tools: SQL Server Integration Services, Informatica

Reporting Tools: Power BI Desktop 2.6, Power BI Service, Power BI Gateway, Power BI Report Server, Tableau Desktop 8.x/9.3 Tableau Server, Cognos,Qlikview,SQL server reporting services (SSRS), SQL Server Analysis Services (SSAS).

Databases: Oracle 10g/11g, MS SQL server 2014/16, Teradata 15, Azure SQL DB Hadoop Ecosystem HDFS, Hive

PROFESSIONAL EXPERIENCE

Confidential

Sr. Power BI Developer / MSBI Developer

Responsibilities:

• Worked closely with Business Analyst, Data Modeler and all team within the organization to understand business processes.
• Read source data from Azure SQL DB, CSV, ORACLE, and SQL Server through Power BI.
• Read different formats of Source data from hive like JSON, ORC, and TXT.
• Generated context filters and data source filters while handling large volume of data.
• Hands on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions in source data.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Create and customize simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges and single - number cards.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients.
• In Power BI developed reports by different time intelligence like year to data (YTD), Month to date (MTD), same period last year.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.

Environment: Microsoft Power BI 2.6x, SSIS, SQL Server 2016, ORACLE 11g, SQL Developer, SQL Azure, Azure storage, and Azure Data Factory, PowerShell

Confidential

Sr. Power BI Developer / MSBI Developer

Responsibilities:

• Requirement s analysis and detailed functional design for the various blocks identified within the Perform data modelingusing Star Schema to meet customer business and technical requirements.
• Designed, developed reports and Dashboard Reports in Power BI Desktop and published to Power BI Web and working Power BI Pro.
• Solid 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
• Worked on various types of DAX functions like Date and time functions, Time - intelligence functions, Filter functions, Information functions, Logical functions Math and Trig functions, Parent and Child functions, Statistical functions and text functions.
• Experience in configuring security, Organizational Content Packs, data Gateways, refresh schedules for Power BI service.
• Performed Power BI administration tasks like configuration of governance policies, usage monitoring, provisions of licenses, capacities and organizational resources
• As a Power BI and Cognos SME responsible for the design, development and production support of interactive data visualizations used across the company.
• Conducted meetings with business stakeholders, clients and director level members for requirement gatherings and presented various solutions using best practices.
• Expertise in data preparation with experience in blending multiple data connections and creating multiple joins across same and various data sources.
• Used and created various visualizations in reports like scatter plot, box plot, Sankey chart, bar graphs, Gantt chars, trend lines, waterfall charts, statistical models, heat maps, geo-maps allowing end users to utilize full functionality of the dashboard.

Environment: Microsoft Power BI 2.6x, SSIS, SQL Server 2016, ORACLE 11g, SQL Developer, SQL Azure, Azure storage, and Azure Data Factory, PowerShell

Confidential

Power BI Developer / Data Analyst

Responsibilities:

• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them via Power BI.
• Used to connect different data sources like SQL DB (SQL Query), Tabular Model (MDX Query), Web Trends to Power BI and generate reports with different visualizations.
• Worked with the business users to understand the architecture, data Model, business logic and rules to be applied to meet the business needs.
• Discussed with team to capture high level transformation rules, produce features, define metrics and User Interface Design Document acceptance.
• Create PowerPivot models and PowerPivot reports, publish reports onto SharePoint, and deploy models into SQL Server SSAS instance.
• Create Parameterized SSRS Reports and PowerPivot Workbooks using data of Tabular model and Cube data model to prove the functionality of database
• Used Tableau to generate Tableau combination dashboards and wrote SQL Queries for testing the tableau report/dashboard.
• Implemented Extract filters, Calculation Filters, Context filters, Data source filters to exclude certain values or a range of values as well as batter performance.
• Blended data from multiple sources like SQL Server 2014, PostgreSQL, oracle 10g, Teradata into one report by selecting primary keys from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.

Environment: Tableau 9.1 (Tableau Desktop, Tableau Server, Tableau online), MS Office Suite, Oracle 10g, MySQL, UNIX, SQL Server 2014

Confidential

BI Developer / Informatica Developer

Responsibilities:

• Responsible for gathering/refining requirements from the customer for developing reports in Cognos and Power BI and Tableau.
• Built Data Analytics or visualization using Power BI and Tableau (Power View integrated with Share Point).
• Worked with DAX/MDX queries in building expressions for various business calculations.
• Building, publishing customized interactive reports and dashboards, report scheduling using Power BI service.
• Created Grouping, sorting columns and writing expressions according to the business requirements.
• Extensively worked with Informatica tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Used SSRS to create reports, customized Reports, on - demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

Environment: MS SQL Server 2008/2012 Enterprise Edition, MS SQL Server Reporting Services 2012, Informatica,Cognos, Power BI,Tableau.