Power Bi Sql Server
Resume:
Harsha Vardhan
Sr. MSBI / Power BI Developer
Phone: 201-***-****
Email:****************@*****.***
Professional Summary:
8+ years of experience as MSBI / Power BI developer, database developer, and data analyst with Microsoft SQL Server 2016/2014/2012/2008 R2/2008/2005, SSIS/SSRS/SSAS, OLTP, OLAP (Different environments such as Production, UAT, and development) and MSBI/Power BI in various domains.
Strong background in a disciplined Software Development Life Cycle (SDLC) process involving Systems Analysis, Design, Development, and Implementation and working knowledge in an Agile/Scrum Environment.
Extensive experience in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports, and create and share dashboards based on reports in Power BI desktop.
Experience in Power BI to design Interactive Reports using Power Query, Power Pivot, and Power View.
Experience in implementing physical data models (Databases, Schema Tables, Views & Virtual Data Warehouse)
Experience in relational database design, and SQL queries like joins, stored procedures, and views.
Experience in Creating, Maintaining & scheduling various reports in Power BI like Tabular Reports.
Extract and analyze data using Power Query, PivotTables, MS Excel, Power BI, and SSRS
Experienced in client requirement Analysis, Logical and Physical design & development of a database (using MS Visio, Erwin, normalization, and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support, and Maintenance of business applications using SQL Server 2012/2008R2/2005, DTS, SSIS, SSAS, and SSRS.
Experience in dimensional modeling with Star and Snowflake schemas.
Good hands-on working experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique)
Experience in Analysing Execution Plans, managing indexes, and troubleshooting deadlocks.
Experience publishing Power BI Desktop reports created in Report View to the Power BI service.
Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
Experience in Optimizing long-running ETL packages by using different mechanisms.
Experience in creating visualizations and dashboards in Power BI and publishing them.
Worked on creating different types of reports and data models in Power BI.
Experience publishing Power BI Desktop reports created in Report View to the Power BI service.
Extensive knowledge of Power BI Desktop & report performance optimization.
Experience in working with the ETL team on Data Migration using SQL, SQL Azure, Azure storage, Azure Data Factory, SSIS, and PowerShell
Worked with the ETL team in Defining the transformation logic in the ELT (Azure Data factory) and SSIS.
Strong knowledge of data warehousing methodologies and Agile methodologies.
Power BI experience in designing Interactive Reports using Power Query, Power Pivot, and Power View.
Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
Experience working with the BIDS and SSDT which includes SSIS, SSAS, and SSRS.
Experience in using ETL methodology for performing Data Migration, Extraction, Transformation, and Loading using SSIS and designed data conversions from various source systems.
Experience in designing SSIS Packages to extract data from various heterogeneous data sources such as Access database, Excel spreadsheet, and flat files into SQL Server for further Data Analysis and Reporting by using multiple transformations provided by SSIS.
Migrated data in various formats like text files, Excel spreadsheets, etc. to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
Experience loading 1TB of data from multiple sources converted from text fields to database data types, transferred over the network and inserted into a single destination server involving multiple partitions.
Experience working on huge data, millions of records in a table.
Sound knowledge of Data Marts, Operational Data Store (ODS), OLAP, and dimensional Data Modeling with Ralph Kimball Methodology (Star Schema Modelling, Snowflake modeling for FACT, and Dimensions Tables) using Analysis Services.
Experience in Providing the cube level security (Data level, Column level)
Efficient in creating Sub-Queries and Joins for complex queries linking multiple tables and Exception Handlers.
Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, and horizontal and vertical partitioning.
Proficiency in Performance Tuning, Query Optimization, Client/Server connectivity, and Database Consistency Checks using DBCC Utilities.
Experience in technical oversight and leadership necessary to accomplish the work which includes the development and implementation of the full suite of Data Warehouse solutions: Data Warehouses and Data Marts, Cubes, and ETL processes.
Performs data flow diagramming and/or process modeling (code architecture)
Extensive knowledge and experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, and cursors using SQL and PL SQL.
Knowledge in programming such as C, C#, VB.Net, and Visual Basic.
Knowledge of IBM Middleware MQ, MB, Web technologies such as HTML, DHTML, JavaScript, and XML
Technical Skills:
SQL Server Tools
SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Data Tools
Reporting BI Tools
Power BI Desktop 2.6, Power BI Service, Power BI Gateway, Power BI Report Server, Tableau Desktop 8.x/9.3 Tableau Server, SQL server reporting services (SSRS), SQL Server Analysis Services (SSAS).
Databases
MS SQL Server 2012/2008/20x05/2000, Oracle 10g/9i/8i, DB2, Teradata, MS Access
Business Intelligence
MSBI, Power BI, Tableau,
Cloud
Azure, Google Cloud
Programming Languages
C, C#, VB.Net, SQL, T-SQL, Power Shell, Visual Basic
Web Technologies
ASP.NET, ADO.NET
ETL Tools
Data Transformation Services, SQL Server Integration Services (SSIS), Informatica.
OLAP Tools
SQL Server Analysis Services (SSAS)
Scripting
HTML, DHTML, XML, JavaScript
Reporting Tools
SQL Server Reporting Services (SSRS)2012/2008, QlikView, Tableau, Power BI, Crystal Reports XI/X/9/8.
Application Packages
MS Outlook, MS Office
Operating Systems
Windows 2003/2008, Windows 7, Windows NT, Windows 2000, XP
Version Control
Team Foundation Server, VSS, SVN
Professional Experience:
Wells Fargo, MN Oct 2022 – Present
Role: Sr. Power BI Developer / MSBI Developer
Responsibilities:
Translate business logic into dashboards, charts, reports, and presentations supporting the Sales & Marketing department.
Imported data from SQL Server DB, and Azure SQL DB to Power BI to generate reports.
Designing Microsoft Power BI dashboards and managing the Power BI gateways with a focus on usability, performance, flexibility, testability, and standardization.
Designing OTLP, and OLAP databases and creating ETL packages, tabular models, and dashboards.
Installed and Configured Enterprise Gateway and Personal Gateway in Power BI Services.
Using Power BI, and Power Pivot to develop data analysis prototypes, and used Power View a Power Map to visualize reports available in Web clients and mobile apps.
Utilizing Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper-level management.
Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
Designed SSAS Cube and developed MDX queries for Analysis.
Document steps needed to migrate database objects between environments including Development, UAT, Staging, and production.
Meet with the business for defined requirements of the project.
Provide production support for existing ETL process and develop cross-validation rules to ensure mapping accuracy for newly added business rules.
Develop SQL queries or use available data profiling applications to perform data analysis based on the business requirement and create data profiling reports for data discovery.
Developing new data integration and supporting existing datasets for BI teams.
Creating SSIS jobs and scheduled packages using SQL Server management studio
Supporting Maintenance of the ETL process
Used Z-order to overlap the reports on each other using Power BI.
Used Power BI, and 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 to Web clients.
Created multiple data models and used them as a common data source for reporting purposes.
Used Power BI Gateways to keep the dashboards and reports up to date.
In Power BI developed reports by different time intelligence like a year to date (YTD), Month to date (MTD), and the same period as last year.
Applying common transformations such as aggregate, data conversion, conditional split, lookup, merge, and sorter transformations
Responsible for migrating folders or mappings and sessions from the development server to the test environment.
Working with Data Architects, DBAs, and Business Intelligence teams in designing and supporting end-to-end data solutions across multiple platforms.
Improving ETL performance by applying best practices.
Environment: MS SQL Server 2016/2014/2012, SSIS, Microsoft Power BI 2.6x, Shell Scripting, SQL, T-SQL, PL/SQL, Oracle, MS Word, MS, Excel, UNIX, Windows OS, Azure, Azure Storage, Azure Data Factory, PowerShell.
Carnival Cruise- VA Jan 2020 – Sep 2022
Role: BI Developer
Responsibilities:
Developed high-level test matrix based on business requirements, Functional and technical specifications, and development standards for assigned projects/applications.
Developed Power BI reports and dashboards from SAP Hana using data blending.
Response reports in building reports in Power BI from Scratch.
Delivered on-demand reports in multiple rendering formats with standard and data-driven subscriptions.
Published Power BI Reports in the required originations and Made Power BI Dashboards available to Web clients and mobile apps.
Developed Dynamic Row level security with Power BI and integrated document Power BI service portal.
Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
Power BI (Power View) to create analytical dashboards that depict critical KPIs such as legal case matters, billing hours, and case proceedings along with slicers and dicers enabling end-users to make filters.
Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI with the decision-makers for strategic planning.
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.
Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS for Different Regional Sales Head by Monthly and Quarterly Reports.
Perform thorough unit testing on all relevant platforms to ensure proper implementation.
Used bookmarks feature which enables the easy to jump to respective report tabs with one click.
Imported custom themes and page backgrounds for rich visual effects.
Performed end-to-end testing on the reports and packages developed to ensure data quality was met.
Utilized Power BI gateway to keep dashboards and reports up to date with on-premises data sources.
Created drill down and drill through the report to go to details and child report within Power BI based on hierarchy.
Utilized Power Query in Power BI to Pivot & Un-pivot the data model for data cleansing and data massaging.
Creating and managing schema objects such as Tables, Views, Indexes, and referential integrity depending on user requirements.
Develop and deploy SSIS packages, configuration files, and scheduled jobs to run the packages to generate data in CSV files.
Troubleshooting reports issues, ETL job failures, and optimizing query performances.
Design and implement the ETL processes using SSIS which involves collection of data from sources like SQL Server 2008 R2, Salesforce, and Intacct.
Created many calculated columns and measures using DAX in Power BI based on report requirements.
Develop SSIS, SSRS / T-SQL Code, and schedule jobs for Jobs Monitoring Automation.
Developing and maintaining/modifying complex T-SQL queries, stored procedures, and SSIS packages to load the data into the warehouse.
Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
Created, Maintained & scheduled various reports in Power BI like Tabular Reports.
Explore data in a variety of ways and across multiple visualizations using Power BI.
Involved in the complete SSIS life cycle in creating SSIS packages, building, deploying, and executing the packages in both environments (Development and Production).
Designed and built up high-performance ETL packages to migrate and manipulate data from MS Excel and SQL Server by using SSIS.
Extensively worked on Dimensional modeling, Data cleansing, and Data Staging of operational sources using ETL processes.
Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
Responsible for debugging, performance checks, and performed index tuning and query optimization.
Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long-running queries.
Designed and created OLAP cubes in the data warehouse.
Designed a partitioning strategy to refresh cubes effectively.
Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
Environment: Power BI, Power BI Pro, Power BI Desktop, Power BI Service, Power BI Gateway, SAP HANA BW, SAP S4, SharePoint, Microsoft Office, Visio, Outlook, Microsoft Teams, Skype for Business, MS SQL Server 2016/2012, MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), Salesforce, Intacct, Data Gateway, DAX, T SQL, SQL Profiler, XMLA, MS Excel, Excess, Windows 10.
Link Global Technologies INDIA May 2016 – Dec 2019
Role: SQL Server BI Developer (SSIS/SSAS/SSRS/Power BI Developer)
Responsibilities:
Involved in the complete Software Development Life Cycle (SDLC).
Identified and prioritized requirements from stakeholders through brainstorming, documented and developed an ongoing process of gaining consensus into the requirements process.
Defined and documented problem definition, scope, and project objectives by collaborating with stakeholders.
Involved in Planning, Defining, and Designing a database using Erwin on business requirements and provided documentation.
Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008, and Flat files.
Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting processes, issues, and errors using SQL Server Integration Services (SSIS) 2008.
Designed and developed ETL packages using SQL Server Integration Services (SSIS) to load the data from the SQL server, and XML files to the SQL Server database through custom C# script tasks.
Involved in the complete SSIS life cycle in creating SSIS packages, building, deploying, and executing the packages in both environments (Development and Production).
Used various Transformations in SSIS Dataflow, Control Flow for loop Containers, Fuzzy Lookups, etc.
Implemented Event Handlers and Error Handling in SSIS packages.
Created SSIS packages for Data Conversion using data conversion transformation.
Configured data loading into slowly changing dimensions using the Slowly Changing Dimension Wizard. Also implemented the checksum SCD method to load the data into the data warehouse.
Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake Schema. Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
Enhancing and deploying the SSIS packages from the development server to the production server.
Designed and built OLAP cubes to meet reporting needs.
Performed Documentation for all kinds of reports and DTS and SSIS packages.
Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS), created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2005 Analysis Services (SSAS).
Understanding the OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
Created Packages in SSIS with error handling.
Provide input in implementing and maintaining change control and testing processes for modifications to databases.
Used ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables, and views to other databases or files with proper mapping.
Data reporting experience with Crystal Reports, SSRS.
Create, or support the creation of required reports in response to business user needs.
Created reports in SSRS with different types of properties like chart controls, filters, Interactive Sorting, SQL parameters, etc.
Environment: MS SQL Server 2008R2/2008/2005, SSIS 2008R2, SSRS 2008R2, SSAS 2008R2, Microsoft Access, TFS, Windows 2003 Standard Edition, Windows 2000 Advanced Server, VSS, SQL Diagnostic Manager.
Education:
Bachelors in commerce.
Contact this candidate