SUMMARY

• Power BI Developer with an experience of 5 years indesign,development,analysis of databasesandbusiness intelligence solutionsincluding SQL scripts, database objects, ETL frameworks, data conversion and reporting.
• Highly experienced in using DAX (Data Analysis Expressions) functions and creating required calculated columns/ measures/tables in creating Power BI dashboards and reports.
• Worked on all aspects of the ETL pipeline, as well as aggregated and reported on operational system metrics, using Microsoft BI stack like SQL Server, SSIS, SSRS and SSAS
• Experienced in creating Data Flows and good understanding on performance techniques like Data Folding and Query Reduction.
• Designed various Dashboards to match with the client BI needs with available and custom visuals on Power BI
• Hands - on working on dummy projects with creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, and Histograms in Power BI.
• Proficient in creating Tableau scorecards, dashboards using advance Tableau functions like Calculated fields, Sets, bins, Groups, Parameters, Actions, Level of Detail (LOD), Adhoc Calculations, etc.
• Experience in Performance Tuning and Optimization of the rendering time on the interactive visualization dashboards with In-Memory OLAP/OLTPprocessing.
• Used PowerBI inAzureand created dynamic reports that provide real-time insights of client operations.
• Created Power BI Apps using REST API and integrated with Power BI reports & dashboards
• Familiarity in Text Analytics, generating data visualizations using R, Python and creating dashboards using tools like Tableau
• DevelopPowerBIdatavisualizationutilizing comparisons, flows, and a diversity of charts based on user requirements
• Experience developingQlikViewuser interfaces: Creating charts, filter boxes, list boxes, text objects, etc
• Worked with MDX Queries, Info providers and Multi providers to create Crystal Reports as per End user requirements.
• Experienced with Deployment pipelines to maintain Datasets and Reports with various environments like Dev /QA/ Prod with Power BI Premium capacity.\
• StrongDataGovernance/Profiling experience includingDatacleansing,Dataquality,Dataarchiving andData/Code Migration experience using SQL, T-SQL and Informatica.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups.
• Worked with data conversion team to develop data migration plan for the data integration project.
• Skilled in design of logical and physical data modeling using Erwin data modeling tool.
• In depth understanding of the As-Is and To-Be (Gap Analysis) business processes and experience in converting these requirements into Technical Specifications for preparing Test Plans.
• Performed configuration of on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards .
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T- SQL
• Experienced in Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.
• Highly experienced on Data preparation on Power Query, Data modelling and various performance techniques within Power BI.
• Developed multiple dashboards, analytical reports, KPIs, and interactive reports based on business requirements using Power BI
• Sound knowledge of Data Marts, Operational Data Store (ODS), OLAP, dimensional Data Modeling with Ralph Kimball Methodology (Star Schema Modeling, Snow-Flake Modeling with FACT and Dimensions Tables) using Analysis Services (SSIS).
• Developed complex SQL queries, common table expressions (CTEs), Views to support Power BI
• Experienced in working with different get data modes like import, Direct query and live access and its limitations.
• Worked on all the Products in Power BI such asPower BI Desktop, Power BI Pro, Power BI Embedded, Power BI Report Server, Power BI Premium, Power BI Mobile
• Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.
• Worked on administration tasks such as Data loading, Batch Jobs, Data unloading, Backup & Recovery, User and Application Table Management, upgrades, creating Databases/File groups/Files/Transaction logs.
• Experience with full development cycle of a Data Warehouse, including requirements gathering, design, UAT, and Deployment

TECHNICAL SKILLS

Reporting BI Tools: Power BI Desktop, Power BI Service, Power BI Gateway, Power BI Report Server, SSRS, SSIS

Databases: MS SQL Server 2016/2018, Oracle9i/10g/11g, MySQL, MS Access

Web Technologies: HTML, Java Script

Operating Systems: Windows 2012/2016/2018 R2, UNIX.

Scripting Languages: SQL, PL/SQL, T-SQL, VB Script

Other Tools: MS Access, MS-Excel

PROFESSIONAL EXPERIENCE

Confidential, Santa Clara, California

Power BI Developer

Responsibilities:

• Developed Rich looking Analytical Dashboards and Reports in Power BI for Business Executives to take better decision.
• Developed Power BI Custom Visual custom table bars with D3 Java Script and Type Script.
• Familiar with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER, RANK.
• Created Drilldowns, Drilssl through and Bookmarks in Power BI Reports for easy navigation and storytelling.
• Enhance and modifyPowerBIdashboardto make it understandable for different audience
• Created Dynamic Dropdown measures in slicer with the help of DAX in Power BI Desktop.
• Developed Measures, Calculated Columns, Conditional Columns, Custom Columns in Power BI.
• Transformed complex business logic to extract data across multiple sources using well writtenSQLQueries and PL/SQLstored procedures.
• Created calculated fields and parameters along with the appropriate filters and plotted the measures on the respective graphs using MicrosoftPowerBIdatavisualizationtools.
• Involved in the data analysis and database modeling of bothOLTPand OLAP environment.
• Developed different types of reports such as Descriptive, Predictive, and Prescriptive for end-users.
• Involved in validating data betweenQlikSense and Cognos reports
• Created various visualizations such as Scatter Charts, Bubble chart, Slicers, Stacked Charts, Pie Charts, Donut Chart. Cards according to business requirements.
• Involved in ETL processes and develop source-to-target data mappings, integration workflows, and load processes
• Designed and created data extracts, supporting SSRS,PowerBI,Tableauor other visualization tools reporting applications.
• Installed and Configured Power BI gateway (Personal/Enterprise) to schedule daily jobs to refresh reports/dashboards in Power BI Service.
• UsedPower BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Designed Data Models in Power Bi Designer by using schemas such as STAR, SNOWFLAKE and GALAXY.
• Developed and deployed reports for the internal users in Power BI Report Server.
• Embedded Power BI Reports in to our own .Net Application via REST API’s for giving better access and flexibility to the end-users
• Worked with both the modes of connection in power bi such as Direct/Import Query Modes.
• Created, Managed, Scheduled Pipelines in Azure Data Factory.
• Created Copy activities and linked service for both source and destination Databases.

Confidential, South Windsor, Connecticut

Power Bi Developer

Responsibilities:

• Import data from different data sources to create Power BI reports and Dashboards.
• Worked closely with various teams across the company to identify and solve business challenges.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients.
• Transform, define, navigate the data from data source and performed merge and append queries using Power Query.
• Involved in design, enhancement, and development of applications for OLTP, OLAP, and DSS using Dimension modelling with Teradata.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Involved in defining report layout in SSRS.
• Generated reports inPowerBIDesktop andPowerBIService using super-fast slice and dice and moderndatavisualizationfeatures and usedPowerBIDesktop to developdataanalysis for multipledatasources to visualize the reports chartImported data from SQL Server DB, Azure SQL DB to Power BI to generate reports
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Written complex DAX functions inPower BIand Power Pivot like COUNT(), SUM(), RELATED(), LOOKUPVALUE(), RANX(),CALCULATE(),etc
• Participating in Daily stand upAgile/Scrum meetings to discuss regarding the enhancements to be made for the existing requirements.
• Used different type of slicers available in Power BI for creating reports.
• Experienced in creating many dashboards by pinning many visualizations in the workspace as per the insights provided.
• Experienced in Data Modelling used to define and analyse data requirements needed to support the business processes within the scope of corresponding information systems in organizations.
• Used recently introduced Power BI to create self-service BI capabilities and use tabular models.
• Shared the created workspace across the organization using Power BI Apps.

Confidential

Power BI Developer

Responsibilities:

• Responsible for building reports inPower BIfrom the Scratch.
• Responsible for creating and changing thevisualizationsinPower BIreports and Dashboards on client requests.
• Developed and deployed reports for the internal users in Power BI Report Server.
• Implemented automated backup anddatabasemaintenance / cleanup jobs.
• Managed huge volume of data by creating weekly partitions in SSAS models.
• Implemented DAX Time-intelligence functions SAME PERIOD LAST YEAR, PREVIOUS YEAR, PREVIOUS QUARTERto manipulate data using time periods, including days, months, quarters, and years, and then build and compare calculations over those periods.
• Generating reports by queryingdatain Teradata database forbusinessusers.
• Created the InfoPath forms and published into SharePoint Document Libraries for gathering and sharing information.
• Worked on both live and import data to Power BI for creating reports.
• Involved in all phases ofSDLCincluding Requirements Analysis, Design, Development and Customization of the reports.
• Migrated from Tableau and Cognos reporting to Power BI reporting
• Createddatabaselinks and accessed the data through SQL statements.
• Participated in all phases of the design and development life cycle of analytic applications (SDLC)
• Involved in validating data betweenQlikSense and Cognos reports
• Published Power BI reports from Power BI desktop to Power BI service.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Involved in ETL processes and develop source-to-target data mappings, integration workflows, and load processes
• Implement functionality of existing systems Ability to work in-groups as well as independently with minimal supervision.
• Wrote standard & complex T-SQL Queriesto perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.