Power Bi Sql Server

SUMMARY

*+ years of IT Experience in Database Design, ETL (SSIS, ADF) Development and business intelligence (Power BI, SSRS, Tableau) of Microsoft SQL in Development, Test and Production Environments in various industries like Education, Banking domain, Music Data, and others like Consumer goods Manufacturing.

Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.

Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from 2008 to 2022.

Implemented Data Modelling with Power BI Semantic Models.

Strong knowledge and experience in error handling of SSIS packages using transactions, checkpoints (package restart ability features), break points and error logging procedures.

Experience in creating and developing different types of reports using SQL Server Reporting Services and migration of Data from Excel, DB2, Sybase, Flat file, Oracle to MSSQL Server by using BCP and utility.

Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX Data Mining Models, developing reports using MDX and SQL.

Experience in Developing and Extending OLAP Cubes, Dimensions and data source view. Expert in Working with a Data Warehouse build from Scratch.

Developed confidential proprietary analytical tools and reports with Microsoft Excel, and Power Pivot, and Power Point.

Extensive knowledge on Transparent Data Encryption (TDE) with Azure SQL DB.

Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Crosstab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.

Good Understanding of Azure Data Factory and created POC in moving the data from flat files and SQL Server using U-SQL jobs.

Experience in creating Indexed views, complex Stored Procedures, CTE’s, Triggers and Functions to facilitate efficient Data manipulation and consistent Data storage.

Involved in DBA activities such as backups, restores, replication etc.

Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning.

Experience in Reporting Services, Power BI (Dashboard Reports), SSRS using MS SQL server and supporting services MDX technology of the analysis Services.

Expertise in Power BI, Power BI Pro, Power BI Mobile.

Created Power Query (M-language) with complex Dax expressions for Calculated fields within Power Bi Dashboard integrated within the Power Plat form.

Designed reports with complex sub reports, Drill down, Cross Tabs, formulas, functions, parameters, schedule reports, alerts, multiple grouping, running totals, Charts, graphs, mapping, multiple sections, mailing label.

Worked on managing ETL process by pulling large volumes of data from OLTP to a staging Database Using SSIS for Data transformation.

Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture within SSRS (Table, chart and matrix report).

Design and Deploy solutions based on Azure SQL Database at Scale, Radis Cache, StorSimple

Experience in using SQL Server Tools like DTS, Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer.

Experience in implementing business logic using Triggers, Indexes, Views and Stored procedures.

Experience in database design, Performance Tuning, Optimization, Backup and recovery in MS SQL Server

Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).

Migration database from Oracle, MS Access, MySQL to SQL Server.

EXPERIENCE

Unified Strategic February 2022 – Till Date

Azure Data Engineer– Remote

My responsibility includes providing guidance and recommendations to process owners and is consulted by business areas for inputs/thoughts.

Experienced in Azure Storage, SQL Azure and in different PaaS Solutions with Web, and worker Roles and Azure Web Apps.

Created Python Scripts to Implement Linear Regression statistical analysis.

Created Python Scripts for Scrambling the PII data before ingestion into Azure Data base.

Used Lambda, NumPy functions to Develop Python Scripts to perform Logistic Regression.

Successfully implemented Cloud Datawarehouse within Snowflake that provides historical usage data for all accounts within the users Team.

Responsible to implement Read-heavy analytical queries using Snowflake.

Virtual Machine Backup and Recover from a Recovery Services Vault using Azure PowerShell and Portal.

Scheduled the Reports to run automatically using data driven subscriptions.

Created/Updated Views, Stored Procedure, Triggers, User Defined Functions (UDF) and Scripts using T-SQL and SQL Server.

Created Azure Data Factory pipelines to transfer XML file data into Azure SQL server database.

Used Azure Data Factory and extract transform loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for applications.

Improved performance of SQL server queries using a query plan, covering index, indexed views and by rebuilding and reorganizing the indexes.

Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.

Designed Azure Data Factory pipelines dealing with different data sources (SQL Server and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations.

Involved in creation of new database, planning the location of data, index, and transaction log files on the disks.

Improved Query performance using Data modelling with Power BI by altering the relationship between Dimension to Fact tables

Worked in creating a Data Warehouse with combination of Various facts(measurements) and dimensions (Categories) supporting BI.

Created complex Stored Procedures, Triggers, Tables, Views and SQL Joins and other statements to maintain referential integrity and implement complex business logic.

Involve in creating table-valued functions.

Used joins and sub queries to simplify complex queries involving multiple tables.

Built and nitrated Architecture End to end from files to Power BI Dashboards including Power Apps and Power Automate Workflows.

Worked under a unified Analytics Microsoft Fabric platform to create Azure Data factory Pipelines for ETL and Power BI for the users to interact with.

Built workflows that automate time-consuming Business tasks and process across applications using Power Automate and Power Apps Combination.

Microsoft Flow within Power plat form helped to Update and Create Business Process Flows resulting in Data Visualization Reports for Power BI.

Expertise in writing complex DAX functions in Power BI and Power Pivot.

Participated in discussions with Business Analysts (BAs) and end users to create several test scenarios for running the reports.

Created views and Stored Procedures for generating Tableau report.

Produced Metrics for reporting to Senior Management. Used Extract, Transform, Load, (ETL) Concepts to Transform Data into MS Access database to produce reports in MS Excel.

Created Power Apps, Power BI reports, Power Automate workflows and Azure Data Factory pipelines with one unified Azure Fabric Framework for various used cases.

Environment: Azure Data Factory, Azure SQL Server, Azure Fabric, Power BI, Power App, Power Automate Microsoft SQL Server, MS Visual Studio, Azure DevOps, Tableau, Snowflake, SSAS

Wells Fargo Bank February 2020 – February 2022

Lead Data Engineer– Charlotte, NC

My responsibility includes Writing the stored procedures, checking the code for efficiency, Routine backups, and restoration.

Designed Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.

Develop, deploy, and monitor SSIS Packages, including upgrading DTS to SSIS.

Provided the ultimate banking experience for successful entrepreneurs and professionals through an uncommon dedication to extraordinary service, proactive advice and total financial solutions.

Created reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.

Developed the system that will generate a fair lending extract file which will monitor loans in compliance.

Improved operating efficiency and reduced risk through a wide range of asset management and securities services solutions.

Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Column, Conditional Split, Term, Slowly Changing Dimension and more.

Performed ETL mappings using MS SQL Server Integration Services.

Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.

Designed and developed MOLAP and ROLAP cubes with SSAS.

Created a report model on SSAS cubes.

Experienced Connecting SSAS with either SSRS or Excel tables.

Involved in SDLC of the project from requirements gathering from Business users to perform technical design, development, and testing.

Deployed SSIS packages into various Environments (Development, Test and PROD) using Deployment Utility.

Built workflows that automate time-consuming Business tasks and process across applications using Power Automate and Power Apps Combination.

Created Power Apps to update the records that are pointed to Power BI Dashboards.

Created Architecture that Users can use the interactive Power BI Architecture integrated by Power Plat form (Power Apps, Power Automate) Power query(M-Language) with Complex Dax functions and generate Power BI reports.

Investigate and propose leading edge methodologies and or technology solutions, interact with solution vendors to determine the best fit and develop solution plan.

Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.

Expertise in Configuring SVN distributed platform for multiple applications and automating builds using Jenkins or other tools and process for regulated SVN code control and builds.

Converted the old Data flow logic written in .NET C# to SSIS packages.

Designed functional and technical documents, report templates and reporting standards for the developers to work on report development.

Performed maintenance of Stored Procedures to improve Performance of different front-end applications.

Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.

Developed numerous reports of OLTP Servers using Reporting Services by writing T-SQL queries, stored Procedures with parameters, charts, and multiple datasets.

Wrote database triggers in T-SQL to check the referential integrity of the database.

Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation, and implementation.

Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.

Environment: MS SQL Server 2012/2008/R2, DTS, SQL Server Management Studio, Tableau, MS-Access, SSAS, SSIS, SSRS, OLAP, OLTP, MDX, ETL, Erwin, MS Visual Source Safe. -Access, SQL Server Query Analyzer, ETL, C#, ADO.NET, MS Azure, Power Platform, power BI

Broadcast Music, Inc.(BMI) May 2018 – February 2020

DATA ANALYST – Nashville, TN

Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc., to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access, and CSV files to data warehouse.

Scheduled the Reports to run on daily and weekly basis in Report Manager and emailed them to director and analysts to review in Excel Sheet.

Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.

Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.

Modified SSIS ETL package for changing business requirements to load data from different source files to SQL Server tables in data warehouse.

Generated Sub-Reports, Crosstab, Conditional, drill down reports, Drill through reports and parameterized reports using SSRS.

Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.

Cloning of the database with the help of EXPORT/IMPORT.

Experience in moving data from heterogeneous data sources like oracle and flat files to SQL Server using SSIS.

Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification.

Involved in the development of custom stored procedures, functions, triggers, SQL, T-SQL.

Involved in migration of data between different heterogeneous sources such as flat file, Excel and SQL Server 2005 using SSIS, BCP and Bulk Insert.

Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.

Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and perform action in XML.

Involved in deployment of SSRS reports on the SharePoint Portal.

Wrote stored procedures to get the fields required for the reports.

Created datasets using stored procedures and reports using multi value parameters.

Improved the performance of the cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy options in SSAS.

Environment: MS SQL Server, Power Platform, power BI SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), MS Azure, SQL Server Query Analyzer, T-SQL, MS-Access, SSRS, OLAP, OLTP, MDX, ETL, Erwin, MS Visual Source Safe, Snowflake, Azure Fabric

Rapid Wristbands June 2017 – April 2018

Data Analyst– Houston, TX

Actively participated and interacted with users, team leaders, DBAs and technical managers to fully understand the requirements of the system.

Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).

Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle 8i.

Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the multi-dimensional data warehouse.

Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS

Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.

Midasis Technologies June 2015 – May 2017

SQL DEVELOPER-Farmers branch, TX

Involved in SDLC of the project from requirements gathering from Business users to perform technical design, development and testing.

Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2012

Write all DDL scripts to create Tables, Views, Transaction Tables, Triggers, and Store Procedures for base tables and CDC processes in all layers. Designed Jobs by Unix Shell Scripts for Tivoli to schedule workflows.

Created and maintained various databases in MS Access to track activities and progress.

Involved in Dimensional Data Modeling and Cube partitioning in SSAS.

EDUCATION

University of Houston-Clearlake - Houston, TX 2016

Master of Science (MS) in Engineering/Industrial Management

Jawaharlal Nehru Technological University – Hyderabad, India 2014

Bachelor of Technology (B. Tech) in Electrical &Electronics Engineering

CERTIFICATIONS AND AWARDS

University Of Houston Clearlake – Houston, TX 2016

Acquired Project Management and Lean Six Sigma Green Belt Joint Certificate from Dept. Science and Computer Engineering

SKILLS

RDBMS & DB tools: SQL Enterprise Manager, SQL Server Management Studio, Business Intelligence Development Studio, SQL Server Analysis Service (SSAS), Snowflake, Azure Fabric,

ETL Tools Data Transformation Services (DTS): Export/Import, SQL Server Integration Service (SSIS), Azure Data Factory,

Reporting Tools: SQL Server Reporting Services (SSRS), Tableau, Power BI,

Programming: T-SQL, PL-SQL, .Net, C#, ASP.NET, VB Scripting, JSON, DAX, M

SDLC Methodologies: Scrum or Kanban, Agile, RUP, Waterfall

Business Analysis: Eliciting & Soliciting/ Documenting Requirements, MOSCOW Analysis, GAP Analysis, SWOT Analysis, Root Cause Analysis (Fish bone diagram), UML Diagrams – Use Case, Activity Diagrams, Business Process Mapping, Meeting Facilitation, Conducting JAD sessions, User Acceptance Testing

Operating Systems: Windows Server, Windows XP

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), MS AZURE, OLAP & OLTP, ERWIN

Contact this candidate