SUMMARY

• Dedicated and highly accomplished Business Intelligence professional with 7+ years of experience in data warehousing and business intelligence tools, Power BI, MSBI (SSRS, SSAS, and SSIS)
• Ability to work with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation.
• Skillful in ETL - Extraction Transformation Loading, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
• Experienced in Creating DAX Expressions, create Date to yearly columns and implement partitions in Tabular Models for Power BI.
• Experienced in Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Extensive experience in M-Scripting to manipulate the data coming from the data sources like Relational SQL databases by using several functions like split column and assigning variables to the M-scripts wherever necessary.
• Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modelling and reporting tools.
• Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts, and numerous stored procedures consumed at various stages of migration/cleansing process, reports or data validation.
• Experience in configuring security, Organizational Content Packs, data Gateways, refresh schedules for PowerBI service.
• Worked with Confidential Power BI, DAX expressions, Power View and Power Query integrated with share point.
• Expertized designing BI database structures, streamlined process-flows, and work-flows for data integrity accuracy and interpreted the consolidated information to deliver innovative solutions to business issues.
• Used PowerQuery to acquire data in PowerBI for designing rich visuals
• Expert in creating and developing Power BI Dashboards in to rich look.
• Knowledge in all types of Database migrations with all the versions of SQL Server.
• Experience as Azure Data Engineer inAzure Cloud, Azure Data Factory, Azure Data Lake Storage,Azure Synapse Analytics, Azure Analytical services.
• Worked on archiving of data from On-prem SQL server to Cloud databases(Azure Synapse Analytics (DW) & Azure SQL DB).
• Extensively used Azure Data Lake and worked with different file formats csv, parquet.
• Designing and maintaining reports in Power BI, built on top of Azure Synapse/Azure Data Warehouse, Azure Data lake, Azure SQL. As a Power BI developer creating workspaces, designing security including row level security for various reports. Working with users to gather requirements and training users.
• Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing, and maintenance) usingWaterfallandAgile methodologies.

TECHNICAL SKILLS

Databases: Microsoft SQL Server (2008 R 2/2012/2014//2016/2017 ), Oracle 9i/11g/12c, MS Access.

Development skills: T-SQL, PL/SQL, SSIS/SSRS, SSMS, Power BI

Languages: Python, SQL, DAX.

ETL Tools: Azure Synapse, Azure Data Factory, SSIS (SQL Server Integration Services)

Reporting Packages: SQL Server Reporting Services, MS Excel, Power BI developer.

Tools: /Methodologies MS Project, Agile, Jira, Waterfall.

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Power BI Developer

Responsibilities:

• Responsible for building reports in Power BI from the Scratch.
• Worked with complex DAX functions inPower BI
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.
• Created and maintained SQL database object such as tables, views, indexes, and store procedures with SQL Server Management Studio (SSMS) 2017.
• Installed and configured Enterprise gateway and Personal gateway in Power BI service.
• Scheduled refresh in Power BI service for every one hour, once a day and weekly.
• Used M-scripting language in Power BI to prepare the data and to transform the data as per the business requirements.
• Wrote calculated columns, Measures in Power BI desktop to show good data analysis techniques.
• Created a currency converter toggle to switch between different currencies.
• Weekly presentation to the business users about the reports and their changes as required.
• Implemented region, country and Industry level security in the same report to have to restrict access as specified.
• Used sharepoint to give access to users to update details and connected to PowerBI
• Worked on all types of transformations that are available in Power BI query editor
• Expert in creating and developing Power BI Dashboards and configuring data gateways to have automatic refresh of the data.
• Created various Drill-through and Drill-down reports to show the filtered data.
• Have good knowledge of working with Azure BLOB andData lakestorage and loading data intoAzure SQL Synapse analytics (DW).
• Created data ingestion pipeline using Azure Data Factory on various sources like SQL Server, Excel, JSON and target as Azure SQL DB, Synapse, ADLS.
• Created data driven pipeline using meta data tables.
• Extensively used copy activity in Azure data factory and synapse workspace. Worked with both selfhosted integration run time and Auto resolve integration runtime.
• Created linked services, data sets, dataflows in Azure synapse workspace and Azure Data Factory.
• Archived data from SQL server and oracle database to Azure data lake storage and created external tables using the parquet file.
• Designed and build reports on top of serverless azure external tables, ADLS (CSV files), SQL server.
• Worked on JIRA for creating User Stories and worked in daily agile Scrum meeting, Scrum review and retrospective

Confidential

Power BI Developer,Atlanta, GA

Responsibilities:

• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Manipulated the M-Script using the Advanced Editor option in Power BI and made sure to optimize the performance of the visualization using the result data set.
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Expertise in DAX Queries to build Power BI calculated measures and Calculated columns.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Built a Tabular Model from scratch data by DAX queries fetched data to Power BI reports.
• Used to connect different data sources like SQL DB (SQL Query), Tabular Model (DAX Query), Web Trends to Power BI and generate reports with different visualizations.
• Developed Power BI reports and dashboards from multiple data sources using data blending.
• Managed access to end users on PowerBI premium dashboards.
• Monitored report on usage and performance on regular basis.
• Created Power BI Visualizations and Dashboards as per the requirements.
• Transformed and combined the data using Query Editor in the Power BI and published Power BI Desktop reports to the Power BI service and installed on premise data gateway and scheduled daily data refresh in Power BI.
• Managed workspaces, published custom visuals and verified codes used to embed PowerBI in other applications
• Published Power BI reports from Power BI desktop to Power BI service.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to by calculated columns as required in Excel
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Streamlined data flows automated processes to improve data integrity accuracy and reporting accuracy.
• Restricted access to users by creating security roles to access reports in Power BI using row level security.
• Created, Maintained & scheduled various reports in Power BI.
• Worked on Azure copy to load data from On-Premises SQL server to Azure SQL Data warehouse.
• Worked with Azure Data Factory for migrating data from Oracle to Azure SQL manged Instince.
• Done a POC on Azure Synapse to migrating and archiving the data.

Confidential

SQL BI Developer

Responsibilities:

• Created various Drill-through and Drill-down reports using SSRS.
• Performed data cleaning, data validation, and data analysis using data analysis expressions (DAX), power query and power Pivot.
• Created different visualization in Power BI according to the requirements.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Installed On-Premise data gateway and scheduled daily data refresh in Power BI.
• Implemented report integration among Power BI, SSRS and Python reports.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Created SSIS package to load data from Flat File to Data warehouse and Report-Data mart usingLookup, Derived
• Columns, Sort, Aggregate, Power Pivot Transformation, and Slowly Changing Dimension.
• Developed entity-relationship diagram and data dictionary for project coordination; created SQL create, alter, and insert scripts.

Confidential

SQL BI Developer

Responsibilities:

• Designed, deployed, and maintained various SSRS Reports in SQL Server 2012
• Created Sub-Reports, ad-hoc reports, Drilldown-Reports, Summary reports, and Cross Tab reports
• Actively participated in gathering Business Requirements that are focused on providing a user friendly System usage or ambience
• Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description
• Performed data analytics in Python Language
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance
• Used various sources to pull data intoPower BI such as SQL Server, Oracle etc.
• Created SSIS packages to import data from MS Access, Excel to SQL 2008R2
• Optimized the query performance with modification in T-SQLqueries, removing unnecessary columns, eliminating redundant and inconsistent data.
• Deployed PowerBI Desktop using system center configuration manager
• Effectively created and used views in SQL Server to prevent unauthorized access
• Performed tuning of databases by normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Worked oncomplex data loading(implemented the batch data cleansing and data loading