Power Bi Sql Server
Resume:
Radhika Ramineni
************@*****.***
Executive Summary
Over all 13+ years of experience on designing, developing, and maintaining databases/BI applications with SQL Server (T-SQL), Snowflake and BI Stack (Power BI, Azure data factory (ADF)/SSIS, SSAS, and SSRS). Experience within multiple industries to include healthcare, Manufacturing, and logistics.
Hand on experience in Azure cloud services like data lake (Adls2), Data factory (ADF), Azure SQL Database and Powe BI
Built interactive dashboards for high level strategy.
Gather and utilize data from multiple data sources, define metrics, prepare tabular semantic data models and leverage to Power BI data model.
Collaborated on ELT (Extract, Load, Transform) tasks marinating data integrity and verifying pipeline sustainability.
Good Knowledge on Python and R
Analyze data and create visualization using Power BI
Generated systematic calculations using data analysis expression (DAX).
Good Knowledge on Azure Databricks and unity catalog.
Experience in using Azure Devops and snowflake Data warehousing.
Experience in providing the integration solutions built on top of Microsoft Technologies Azure (IaaS PaaS & Hybrid).
Extract and manage large amounts of data in multiple formats, conduct analysis and concisely and effectively communicate the findings and support decision making process at all levels within the organization.
Translate stakeholders’ requirements into report deliverables, coordinate with multiple stakeholders to drive the requirement gathering, design, automation, testing and deployment of key reports for all parts of the division.
Create and define best practices for documentation of all key reporting, including identification of control processes and following appropriate change control processes.
Experience in database related work primarily creating complex Stored procedure, ADF pipelines, Views, (UDF)Functions, using PL/SQL, T-SQL and Performance Tuning in SQL Server and Oracle.
Technical Skills
Database: Azure SQL, SQL Server, Oracle, T-SQL, PL/SQL, My SQL
Cloud Datawarehouse: Snowflake
Data Visualization: Power BI
Data Engineering: Azure data factory, SSIS
Reporting: Crystal Reports, SSRS, SSAS
Web Technologies: ASP.NET, C#, VB, JavaScript, XML, AngularJS, React JS, REST APIs
IDE Tools: Visual Studio .NET 2015, SQL Server Management studio, TOAD ORACLE
.Net Frameworks: .Net Framework 4.5
Modeling Tools: UML, MS Visio
Version Control Tools: Azure Devops, GITHUB
Experience
Fidelity Investments
Principal Software Engineer May2023 – Dec 2024
Gathered requirements and coordinated with different End Users to assure satisfactory data content, quality, data integrity and receipt of desired information.
Creating select queries from different sources and use them to create Table visualization
Developing Reports using direct query mode and import mode based on the business needs.
Design (model) and implement data sets in support for reporting solutions.
Performed Data Analysis between multiple databases and the Data Warehouse.
Design data visualization with Power BI
Expertise in writing complex DAX functions in Power BI.
Used various sources to pull data into Power BI
Scheduling Automatic refresh and scheduling refresh in power bi service.
Wrote calculated columns, Measures queries in power bi desktop to show good data analysis techniques.
Weekly presentation to the business users about the reports and their changes as required.
Migrating Reports from Jasper to Power BI and validated
Implemented row level security for the reports to limit access to specific users
Working on paginated Reports using Power BI Report builder
Following Agile and used Jira for tracking work on stories and using GITHUB for version control
Creating datasets from different sources which can be used in Angular UI to display data
Creating Power BI reports which can be embedded in Angular UI
Working on all types of transformations that are available in Power bi query editor.
Extensively using Joins and Sub-Queries to simplify complex queries involving multiple tables.
Fidelity Investments
BI Developer Nov 2022 – April 2023
Gathered requirements and coordinated with different End Users to assure satisfactory data content, quality, data integrity and receipt of desired information.
Created dimensional modeling (Star schema) of the views.
Developing Reports using direct query mode.
Design (model) and implement data sets in support for reporting solutions.
Performed Data Analysis between multiple databases and the Data Warehouse to create mapping documents.
Design data visualization with Power BI
Expertise in writing complex DAX functions in Power BI.
Used various sources to pull data into Snowflake such as SQL and Oracle.
Used snowflake as main source for Power BI Reports.
Scheduled Automatic refresh and scheduling refresh in power bi service.
Creating alerts on Dashboards using power automate.
Followed Agile and used Jira for tracking work on stories and using GITHUB for version control
Implemented row level security for the reports to limit access to specific users
Wrote calculated columns, Measures queries in power bi desktop to show good data analysis techniques.
Weekly presentation to the business users about the reports and their changes as required.
Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
Worked on all types of transformations that are available in Power bi query editor.
Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
Designed and created data extracts, supporting POWER BI or other visualization tools reporting applications.
Johnson Controls
BI Developer June 2021 – Oct 2022
Analyzing existing data across multiple different source systems.
Designing data model for the new Data Mart.
Designing transformation logic to standardize data in Data Mart.
Data Mapping between source and target system
Created dimensional modeling (Star schema) of the data mart.
Migrate Oracle EBS and Legacy SSRS to Power BI Report and enterprise dashboard.
Developed Power BI model used for financial reporting of P & L and Headcount.
Experience with manipulating, processing and extracting value from large, disconnected datasets.
Design data visualization with Power BI
Implemented row level security for the reports to limit access to specific users
Designed and documented the entire Architecture of Power BI reporting workflows.
Expertise in writing complex DAX functions in Power BI and Power Pivot.
Automated Power Query refresh using power shell script and windows task scheduler.
Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure
Installed and configured Enterprise gateway and Personal gateway in Power bi service.
Created Workspace and content packs for business users to view the developed reports.
Scheduled Automatic refresh and scheduling refresh in power bi service.
Wrote calculated columns, Measures queries in power bi desktop to show good data analysis techniques.
Weekly presentation to the business users about the reports and their changes as required.
Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
Worked on all types of transformations that are available in Power bi query editor.
Created stored procedures and SQL queries to pull data into power pivot model.
Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.
Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
Designed and created data extracts, supporting SSRS, POWER BI or other visualization tools reporting applications.
Creating data blending in case of merging two different datasets using
Created Datasets in T-SQL, stored procedures for SSRS.
Developed Excel Power View, Power Query and PowerPivot dashboards for data analysis.
John Deere
BI Developer
Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases. Oct 2020 – May 2021
Developed Power BI model used for reporting.
Expertise in writing complex DAX functions in Power BI and Power Pivot.
Automated Power Query refresh using power shell script and windows task scheduler.
Used various sources to pull data into Power BI such as SQL Server, Oracle, SQL Azure
Installed and configured Enterprise gateway and Personal gateway in Power bi service.
Created Workspace and content packs for business users to view the developed reports.
Scheduled Automatic refresh and scheduling refresh in power bi service.
Wrote calculated columns, Measures queries in power bi desktop to show good data analysis techniques.
Weekly presentation to the business users about the reports and their changes as required.
Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
Implemented row level security for the reports to limit access to specific users
Worked on all types of transformations that are available in Power bi query editor.
Created stored procedures and SQL queries to pull data into power pivot model.
Performed SQL Query Tuning by creating/modifying indexes and Query Optimization.
Updated statistics/Creating databases/ Index Maintenance.
Worked on Stored procedures, Functions.
Created Databases (DDL, DML, DCL), database tuning, SQL tuning, performance planning.
Wheels
BI Developer Aug 2019 – Oct 2020
Implemented Visual Level, Page level, report level filters and pinning in dashboards.
Written simple DAX calculation as per the requirement to maintain business measures.
Worked on report permissions and dashboard permissions to provide access to different users.
Used Quick insights to get various types of visuals to match the requirements.
Experience on relationship tab to provide cardinality between fact and dimension tables.
Involved creating effective reports, dashboards and publishing into Power bi service.
Creating the roles for the dashboards, sharing the developed dashboards to the client in power BI.
Experience in creating content pack library for sharing the dashboards and reports to the colleagues.
Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
Implemented row level security for the reports to limit access to specific users
Develop best practices for database design and development activities.
Connect, import, shape, and transform data for business intelligence (BI).
Experience in developing Visualization reports and dashboards using Power BI
Visualize data, author reports, and schedule automated refresh of reports.
Created Stored Procedures, SSIS packages, Triggers, Functions, Tables, Views and joins for applications.
Worked as a Onsite Delivery Coordinator.
XPO Logistics
Software Engineer Sep 2017 – July 2019
Designed and documented the entire Architecture of Power BI reporting workflows.
Expertise in writing complex DAX functions in Power BI and Power Pivot.
Automated Power Query refresh using power shell script and windows task scheduler.
Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure
Installed and configured Enterprise gateway and Personal gateway in Power bi service.
Created Workspace and content packs for business users to view the developed reports.
Scheduled Automatic refresh and scheduling refresh in power bi service.
Wrote calculated columns, Measures queries in power bi desktop to show good data analysis techniques.
Weekly presentation to the business users about the reports and their changes as required.
Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
Worked on all types of transformations that are available in Power bi query editor.
Created stored procedures and SQL queries to pull data into power pivot model.
Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.
Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
Designed and created data extracts, supporting SSRS, POWER BI or other visualization tools reporting applications.
Creating data blending in case of merging two different datasets
Created Datasets in T-SQL, stored procedures for SSRS.
Developed Excel Power View, Power Query and PowerPivot dashboards for data analysis.
Developed confidential proprietary analytical tools and reports with Confidential Excel, and Power Pivot and Power Point.
Created SSIS packages to import data from Access, Excel, XML, OLE DB Source and Flat Files.
Filtered bad data using Derived column, Lookups, Fuzzy Lookups, Conditional split.
Designed SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task.
Designed and created data extracts, supporting SSRS, Power BI other visualization tools reporting applications.
Debugging SSIS packages, Performance tuning on Slowly running SSIS Packages.
Created Reports using Charts, Gauges, Tables, matrix.
Created Parameterized Report, Dashboard Report, linked report and Sub Report by Year, Quarter, Month, and Week.
Created Drill Down Reports, Drill Through Report by Region.
GIC, Singapore Jun 2014 - May2015
Senior Consultant
Creating UI using jQuery, JavaScript, AngularJS, HTML, and CSS.
Created Model classes.
Participated in requirement gathering.
Implemented business logic using JavaScript, AngularJS, and jQuery for debugging on client side.
Responsible for bug fixing.
Worked on Angular UI
Implemented LINQ for Data Accessing
Used Agile Methodology (ex: scrum) to develop the application.
Collaborate with business users and technical staff to design system providing scalability, reliability, and performance for application.
Participated in requirement gathering and UI Prototype design.
Ensure timely resolution of issues (technical, functional or team related).
Involved in testing, debugging and documentation.
Written stored procedures, Triggers and created tables.
Created and scheduled SQL Jobs to retrieve data from different databases.
Provided supports to different clients in SLA driven environment.
Environment: VS2012, ASP.NET, C#, ORACLE11g, SQLSERVER2012, jQuery, MVC, Entity Framework, JavaScript, Angular, HTML, XML, SVN
Infosys/Cisco, India April 2012 - Aug 2013
Technology Analyst
Gathered Requirements
Functional analysis
Prepared technical analysis Document
Bug fixes
Enhancements
Unit testing
Worked on Stored Procedures and User defined functions
Created and scheduled the Jobs.
Published the code on stage.
Worked on the Project independently
Environment: C#.NET, ASP.NET, JavaScript, SQL SERVER2008, VS2010, VSTF, XML, HTML
Infosys/Kodak, India Sep 2011 – Mar 2012
Technology Analyst
SRS: The SRS (Smart Review system) Video Module has made a significant expansion to the existing SRS Admin Module necessary to store settings that control the operation of the module. The expanded module will consist of web page(s) which allow administrative users of SRS to manage the Registry settings, Profile Bitrates effectively.
Responsibilities:
Participated in Client Meetings and Gathered Requirements
Understanding and analyzing the requirements
Designed Admin web Pages for Video Module
Designed Asp.net Admin web Pages for Video Module.
Developed application databases and data access layer using the SQL and creating the stored Procedures to access the data with ADO.NET objects.
Worked on ADO.Net components SQL Connection Object, SQL Command Object, Data Reader, Data Adapter, Dataset and Data View to provide communication to the database
Bug Fixes
Deployment on Test Server
Worked on Perforce to manage versions
Environment: C#.NET, ADO.NET, ASP.NET, VS2005, SQL Developer, Oracle 10g.
Client: Infosys/Microsoft, India Mar2011 - Sep2011
Technology Analyst
Understanding and analyzing the Requirements.
Worked on Bug fixes.
Worked on Enhancements
Programming using C#, SQL
Prepared Test data for unit testing
Environment: C#.net, windows services, SQLserver2005, WCF
Client: Infosys/Microsoft, India Mar 2010 – Oct 2010
Technology Analyst
Understanding and analyzing the requirements
Support to onboarding consumers for PVP web services
Trouble shooting errors
Preparing Metadata scripts
Worked on web services using C#
Technical Analysis on web services
Updating Consumer guidelines, Troubleshooting Documents on PVP webservices
Preparing flow diagrams and documents for PVP onboarding process
Environment: C#, WCF, Windows Server2008, Visual Studio .Net 2010, SQL Server 2008.
Education
Master of Computer Applications: MCA
Certifications: Infosys Global Agile Developer
Contact this candidate