SUMMARY

• Around 7 years of professional experience in developing and designing Business Intelligence solutions utilizing SQL Server and Power BI.
• Experience in developing, implementing, documenting, monitoring and maintain the data ETL process in various industries like Financial, Health Care, etc.
• Ability to work with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation using Waterfall and Agile methodologies.
• Ability in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Data Import and Export.
• Working with DAX formulae for creating variables like Previous Month, Previous Quarter, etc. and creating interactive visuals using geographic data.
• Expertise inPower BI Desktop, Power BI Service, Power BI Pro, Power BI Mobile.
• Experience in Power BI Desktop, Report Service, Gateway Connectors, Data Models, Relationships, Publishing / Updates to Apps Work spaces, Data On - Demand Refreshes, Scheduling, Testing and Deployment.
• Imported data using Azure Data Link (ADL) to SQL Server in Power BI to generate reports.
• Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, and Excellent knowledge in RDBMS concepts and Data Warehouse Concepts.
• Involved in publishingPowerBIDesktop reports to thePowerBIservice.
• Designed reports in SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Cubes, SQL Server Integration Services (SSIS), and Power BI
• To generate underlying data for the reports and to export cleaned data from an Excel Spreadsheet, Flat file and CSV files to the data warehouse.
• Experience in Microsoft Azure Portal, Azure Data bricks, and Azure Cosmos DB and creating data pipelines and building governance model
• Experienced on creating multiple kind of Report in Power BI and present it using Story Points.
• 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.
• Database development for both OLTP and OLAP systems using MS SQL Server.
• Proven experience developing and managing data integration solutions using Microsoft BI technologies.
• Experience in creating complex reports in Power BI (List reports, Cross-tab reports, Drill through reports, Sub reports and Cascading prompts)
• Publishing Power BI Desktop reports created in Report view to the Power BI service.
• Possessing a high level of proficiency in Data Analysis Expressions (DAX) with demonstrated capabilities in this area.
• Experience working in Agile and Waterfall model working methodologies.
• Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills.

TECHNICAL SKILLS

Reporting Package: Power BI( Desktop, Server, Pro), MS ( SSAS, SSRS), QMF

Integration Tools (ETL/ELT): Microsoft SSIS, ADF, SAP BI

Data Modelling: Star and Snowflake with Erwin, Visio, SQL Architect

Cloud reporting services: Azure

Database tools: Microsoft SQL Server Management Studio, SQL developer, Toad

MS Office: MS-Excel, MS-Access, MS- Power Point, Office 365, SharePoint

Databases: Oracle, SQL Server, DB2, Teradata, MySQL, XML, AWS-Redshift

Operating Systems: Windows, Linux

Languages: SQL, PL/SQL, T-SQL, Transact SQL, Python, R, PHP

PROFESSIONAL EXPERIENCE

Confidential, Melville, New York

Power BI Developer

Responsibilities:

• Creating Row level security with Power BI and integration with Power BI service portal.
• Created stored procedures and performed index analysis for slow performing SSRS reports to bring down the report rendering time from 15 minutes to 30 seconds.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Create and customize simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges and single-number cards.
• Connected Power BI to various databases and performed live data connections, query auto updates on data refresh.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Worked on all types of transformations that are available in Power BI query editor.
• Manage project through status meetings, weekly reports, identifying risks, and tracking issues
• Managed international stakeholders in India, United States, UK, and Switzerland by hosting weekly standups and coordinating weekly status reports.
• Used MDX to interact with the back-and OLAP Services.
• Used Data Analysis Expressions (DAX) functions to create new Calculated Columns, Calculated Fields in Tabular model projects authored in SQL Server Data Tools
• Involved in creating MDX, DAX, Cubes and Tabular models using SQL Analysis Services (SSAS). Used different types of visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer etc.) in Power BI according to the requirements.
• Worked closely on the data, by querying & transforming the data set to make it available to users in required structure and form
• Able to create complex transformation queries that can be used for process automation and incremental data load

Environment: Power BI, DAX, MDX, SQL Server 2012/2014/2016, SSAS, SSIS, SSRS, T-SQL, Power BI, Windows 7/10, MS Word, MS Excel, C#, Visio, SQL Profiler

Confidential, Parsippany-Troy Hills, New Jersey

Power BI Developer

Responsibilities:

• Created DAX Queries to generated computed columns in Power BI.
• Generated computed tables in Power BI by using DAX.
• Worked on DAX expressions like filter, aggregate, mathematical functions etc.
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.
• 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 available in Web clients and mobile.
• Implemented Power BI as enterprise reporting tool and responsible for managing user licenses, creating and assigning work spaces to Power BI premium capacity.
• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting, and scorecard/dashboards on SQL Server 2008 using SSAS, SSIS/DTS, SSRS.
• Created Power BI usage metrics report to help Power BI Service administrators to analyze the utilization of premium capacity resources.
• Created SSIS packages to Extract-Transform-Load (ETL) from transactional system (OLTP) to analytical system (OLAP).
• Expertise in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Treemaps, etc.
• Implementing Azure Logic Apps, Azure Functions, Azure Storage, and Service Bus Queues for large enterprise-level ERP Integration systems.
• Familiar on Azure service bus and service bus triggers.
• Deployment of Power BI using deployment Pipelines.
• Worked with both technology and business concepts in an ever-changing environment. Developed quick Power BI prototype visualizations using local datasets while working in parallel with data integration team for data automation.
• Converted functional requirements into technical specifications and performed required data analysis, data mapping, functional testing, unit testing, and test case preparation using required tools based on project needs.
• Explore data in a Variety of ways and across multiple visualizations using Power BI
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Published reports and dashboards using Power BI.
• Deploy and Configure Power BI dataset for Sales and Finance team, implement incremental refresh on Power BI dataset
• Written calculated columns, DAX, MDX, Measures query’s in power bi desktop to show good data analysis techniques.

Environment: Power BI,SQL Server 2012, Snowflake SSMS, SSIS, SSRS, T-SQL, Power BI, Windows 7, MS Word, MS Excel, C#, Visio, Share Point Jira, SQL Profiler

Confidential, Washington, D.C.

Power BI Developer

Responsibilities:

• Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data model.
• Worked as a database developer on databases like MS SQL Server using T- SQL, stored procedures and views to get data from Data warehouse.
• Built data visualizations in Power BI Desktop and Power BI Service.
• Configured report Subscription and report sharing rules in Power BI workspace.
• Utilized Custom Visuals from Power BI market place.
• Migrated SSRS reports to Power BI.
• Developed Self-Service Analytical Data model using Power BI.
• Created dashboards and reports using Power BI Desktop.
• Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel, Text file, and XML file to different data Marts.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Deployed, Tested and Scheduled SSIS packages.
• Developed complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Converted MS SSRS and Excel based reports to MS SSRS based reports.
• Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS.
• Generated multi parameterized reports in Report Builder allowing users the ability to make selections before executing reports; thus, making them user friendly.
• Extensive experience delivering OLAP cubes solutions by developing Corporate Dashboard Reports using MS SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Developed dashboards to show survey, design, construction and information to field contractors.
• Developed various packages to extract the data from different source like relational tables and flat files.
• Analyzing and understanding the Excel Data and Creating SSIS Packages accordingly to dump the data in to SQL Database.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Migrated Parameterized reports from Business Objects to Reporting services (SSRS).
• Involved in integration of SSRS reports to embedded Power BI reports and deploy them on to Power BI service.
• Created Power BI dashboard and generated reports using the SQL server tables as source. Lock objects on the reports.
• Designed and developed a full-scale reporting solution for a multi-client environment using MS SQL Server R2 and Report Builder.
• Involved inunderstanding their requirements and translating functional requirements to technical specifications.

Environment: SQL Server, SSIS, SSRS, Power BI, Visual Studio 2017/2015, TFS

Confidential

Power BI Developer

Responsibilities:

• Worked with business users to gather in-depth business requirements and keep track of changes in their requirements.
• Extensively involved in design of Dashboard to display all the customer related information.
• Developing the all the visualizations which are requested by the business users using Power BI.
• Design and developed the Power BI solution to create reports, visualizations and dashboards as per the business requirements and published enterprise.
• While design the Power Bi reports and dashboards, the measures are created using DAX programming language. Writing all the calculations using DAX formulas.
• Managed relationship between tables in Power BI using star schema.
• Used different type of slicers available in Power BI for creating reports.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Designed and deployed reports with Drill Down, Drill Through and drop-down menu option and parameterized and Linked reports.
• Worked on all types of transformations that are available in Power BI query editor.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Scheduled the data refresh for dashboards and reports to show the updated data.

Environment: SQL Server, TFS, Microsoft Visual Studio, T-SQL, SSIS, SSRS, Power BI, Azure, Spark and DAX.

Confidentia

MS SQL/Power BI Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes & Views using T-SQL in Development and Production environment for SQL Server 2008R2.
• Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data model.
• Worked as a database developer on databases like MS SQL Server using T- SQL, stored procedures and views to get data from Data warehouse.
• Built data visualizations in Power BI Desktop and Power BI Service.
• Configured report Subscription and report sharing rules in Power BI workspace.
• Utilized Custom Visuals from Power BI market place.
• Migrated SSRS reports to Power BI.
• Developed Self-Service Analytical Data model using Power BI.
• Created dashboards and reports using Power BI Desktop.
• Developed Database Triggers to enforce Data integrity and Referential Integrity.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Defined relationship between tables and enforced referential integrity.
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.
• Established connectivity to database and monitored systems performances.
• Performance tuning and monitored both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created Stored Procedures to transform the Data & worked extensively in T-SQL for various needs of the transformations while loading the data.
• Participated in performance tuning using indexing (Cluster Index, Non-Cluster index) tables.

Environment: SQL Server 2008R2, SSIS, Windows server, SQL Profiler, SQL Query Analyzer, T-SQL.