Power Bi Sql Server
Resume:
Dinesh Muppa
***********@*****.***
SUMMARY OF QUALIFICATIONS:
•I have 10 years of Hands-on IT experience in Database development, Data Analysis, system analysis design, development, and support of MS SQL servers of 2008/ 2012/ 2016/ 2019.
•Extensive experience in designing, developing and delivering business intelligence solutions using Power BI, DAX, Analysis services (SSAS).
•Experience in developing self-service BI platform (Power BI) for financial analysts to Analyze and interpret monthly variances and trends between budgets, actual and prior results in developing projections and forecast.
•Experience in RDBMS: MS SQL Server 2008/ 2010/ 2017/ 2019 developed stored procedures, functions, triggers, indexes, cursor in T-SQL.
•Excellent experience in onsite-offshore model interacting with clients and Onsite managers.
•Hands-on experience in Azure Cloud Services Like Azure Data Factory (ADF) and Azure Synapse Analytics (ASA), Key Vault and Azure Data Lake
•Experience in MS OLAP technologies in SSAS both Multi-dimensional and Tabular.
•Experience in SQL Server Integration Services (SSIS) and SQL Server reporting services (SSRS)
•Perform various operations using DAX calculations, Row-level security (RLS), Data Modelling and M query in Power BI Desktop.
•Created 55+ Power BI reports Using DAX, RLS and Data Modelling.
•Designed and developed the reports/dashboards according to the requirements using Tableau and Power Map using Power BI.
•To analyze performance, we used: Calculation, KPI, Derived column and hierarchy. Also created MDX scripts and built reports on top of cubes.
•Skilled in data warehousing tools, data mapping, unit testing, migration, conversions, and process documentation.
•Extensive experience in Extracting, Transforming and Loading (ETL tools) using SSIS, DTS Import/ Export Data, Bulk Insert, DTS Packages and SSIS packages.
•Hands on Experience working with Various Source Control software like Visual Source Safe (VSS), Visual Studio Team Foundation Server (TFS).
•Experience in software development life cycle (SDLC), Agile/Scrum and project management methodologies.
•Excellent Planning and problem-solving skills, able to independently as well as in team with minimal guidance.
Education:
•Master's in computer science and information technology from Sacred Heart University, Bridgeport, Connecticut.
•Bachelor’s in electrical and Electronics Engineering from JNTUH, Hyderabad, Telangana, India.
TECHNICAL SKILLS
Microsoft Tools and Software’s
Power BI, SSMS, MS SQL, SSIS, SSRS, SSIS, Power automate Power Apps and Visual studio,
Languages
SQL, DAX, and Python Programming (Initial).
Database
SQL Server 2008/2005/2000, MS Access, PL/SQL, T-SQL, MDX Query’s, DAX Query’s Query Optimization, Stored Procedures, Triggers, Database normalization, Functions.
Cloud Technologies
Azure Data Factory, Azure Synapse Analytics and Azure Data Lake.
Tools
VSS (2005), TFS (2010/2008), Power BI (Power Pivot, Power View), SharePoint.
Reporting Tools
Crystal Reports (10/8.5/8), SSRS 2008/2005, Power BI Reports and
Dashboards.
Certifications: Completed Power BI Data Analyst Associate (PL - 300).
Professional Experience:
Client: Thermo Fisher Scientific, Pittsburgh, PA Nov 2016 – Current
Role: Sr. BI Developer
Project: Business Insights & Analytics (BIA)
Responsibilities:
Developed the BI Analytics platform for the Global Corporate hierarchy.
Develop and integrate role-based data visualizations using Power BI desktop.
Developed many reports and Dashboards using Power BI, DAX and row level security (RLS).
Experience with Integrate Dashboards/Reports into internal applications using Power BI Embedded.
Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
Hands-on experience in Azure Cloud Services Like Azure Data Factory (ADF) and Azure Data Lake.
Development of SSRS Reports for specific applications based on business needs.
Creating automated Excel reports using Power Pivots and Power View and publishing to finance users.
Created many Power Flows for automated daily operations and Power Apps for reps and customers for updating the requesting.
Utilized SharePoint, Excel, and SQL Database as data sources for Power BI Reports and Dashboards.
Proficient in working with Direct Query and adept at developing tabular models from these sources.
Design advanced web sites and pages using SharePoint web parts combined with HTML and CSS.
Leverage Microsoft Azure cloud and on-premises resources in a hybrid environment to build a Data Semantic Layer (DSL)
Developed many tabular models using and implementing DAX Calculation and Row level security (RLS).
Involved in designing, developing, and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
Having Experience in creating Pipelines Jobs, Scheduling triggers using Azure Data Factory (ADF)
Experience in Building the SSAS tabular in memory model on SQL 2016
Created Different Visualization in the report using custom Visuals like Bar charts, Pie charts, line charts, cards grids tables and slicers so on.
Implemented different transformations inside edit query into clean up the data.
Experience in developing REST/HTTP APIs for exposing financial data.
Utilizing Microsoft SQL maintained a data feed to SSRS, Excel, and other reporting tools to build custom reports that will drive core business decisions.
Developed Performance tuning by checking the loads on Indexes by using SQL Profiler and tuning advisor.
Experience in configuring Excel service and user Profile Management in SharePoint.
Developed 15+ tabular and multidimensional models and instructed a team of 12 in application methods.
Engaged in comprehensive Agile/Scrum project management methodologies throughout the project.
Started python programming language and implemented FTP operations.
Used SQL compared to sync up the DEV, staging and Production databases.
Performed SQL performance analysis / tuning using the latest tools and techniques.
Perform User Acceptance Testing of the Functional Requirements of the system and business processes.
Provide support for production environment deployments.
Environment: Visual Studio 2019, SSRS Reports, SSIS Packages, SSAS, Power BI, SQL SERVER 2019, TFS, Test Driven Development, Power Automate, PowerApps, MS SharePoint, CSS, HTML, Power Pivot, Power View, MDX, DAX.
Client: Hyper Drive Interactive, Cincinnati, OH July 2016 – Oct 2016
Role: SQL Developer
Project: Larose’s, Dream Field, and Barber Foods.
Responsibilities:
Participated in various Client meetings with the team and the Project manager to discuss improvements/amendments in the development of the section.
Possess very good expertise in developing programs using SQL and PL/SQL procedures to transfer data from legacy systems.
Worked on various backend Stored Procedures, Views, Triggers, Indexes and Functions using PL/SQL.
Creating new Azure service accounts, subscriptions for all web services and websites based on the datacenter’s location of the application.
Prepared high level design documents, tasks, and user stories for application development.
Implemented Unit Testing, Integration testing on the applications that are being migrated.
Monitoring the Scheduler Jobs in SSIS job monitor on daily basis and fix in case of any failure.
Migrated data using ETL Tool in SSIS.
Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS.
Defined relationship between dimensions and measures groups, calculated slowly changing dimensions, KPI for different OLAP cubes.
Developed SSIS packages using different types of tasks and with Error Handling.
Taking weekly database backup and schedules job using SQL Agent.
Identify bottlenecks and bugs, and resolutions to the problems.
Collaborate with co-located and remote team members to solve technical issues.
Involved in Application Review process to capture the technical details of the application.
Worked on Autosys Jobs, Scheduling SSIS Packages.
Environment: SQL Server 2012/2014, ADO. Net, WCF, WPF, SSRS, SSIS, SSAS, MS Azure, MS Silverlight, MS SharePoint, Team Foundation Server, SSDT.
Client: Cardinal Health, Dublin, OH Nov 2015 – June 2016
Role: SQL Developer
Project: Cardinal-Opti Freight
Responsibilities:
Involved in writing views, stored procedures, and triggers.
Created stored procedures, views, tables, triggers, table-valued, scalar functions etc. on various databases for critical data involving profit and loss, net revenue, forecasting.
Created and integrated user defined functions and stored procedures for reporting purposes.
Designed and developed various complex reports in SSRS.
Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time.
Planning, Configuration and Monitoring of Log shipping. Performed Role Reversal of Primary and Secondary servers of the log shipped database.
Created Transactional Replication, Pull Subscription, and defined editions to transfer data from branch to head office and vice versa.
Created Indexes and involved in Performance tuning.
Using DTS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
Created DTS Package to transfer data from the Oracle source database.
Scheduled the ETL Process using Jobs and Created Alerts to notify the status of the process.
As a Production support person, monitored every day’s ETL Process, and fixed the data issues.
Modified DTS to SSIS packages to accomplish critical business logic.
Reduced the overall ETL Time by SQL Query Performance Tuning. Discussed with User Interface and External Interface teams over the performance issues and provided solutions.
Environment: Visual studio, MS SQL Server 2005/2012, T-SQL, DTS, SSIS, SSRS.
Client: Hermes Networks Inc., Plainsboro, NJ Jan 2014 – Aug 2015
Role: SQL Developer
Project: Banking Portal Connector
Responsibilities:
Involved in Data Migration from DTS packages to SSIS Packages.
Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
Involved and Created Datawarehouse Cubes in SQL Server Analysis Service (SSAS).
Deployed SSIS packages and Reports to Production Servers.
Involved Database Design. Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
In charge of converting data using SQL Server 2005 using SSIS.
Create joins and sub-queries for complex queries involving multiple tables.
Created SQL reports, data extraction and data loading scripts for different databases and schemas.
Designed a report on the monitoring of Server Performance using Task Manager. This report gives a detailed report to the management on the Performance of the server.
Maintained SQL Scripts for creation of Database Objects.
Managed Login and User: adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.
Environment: SQL Server 2005/2008, T-SQL, Management studio, SSIS, DTS, Enterprise manager, Query Analyzer, SQL profiler, Performance Monitor, Windows 2003/2000 platform.
Contact this candidate