Sql Server Powerbi Developer
Resume:
Nandini Raparthi
Herndon, VA *****
***********@*****.***
SUMMARY
6+ years of experience as a PowerBI Developer adept at executing database projects and employing dialogue mapping to gather requirements. Proficient in deploying Oracle data modeling & collaborating with global teams. Skilled at creating a schema and implementing SSIS packages to deliver user-centric solutions and maximize customer satisfaction.
Building and publishing PowerBI reports utilizing complex calculated fields, table calculations, filters, parameters
Experience in using Tableau and PowerBI to generate various reports
Experienced in creating interactive dashboards and scorecards utilizing PowerBI
Hands-on experience in MS PowerBI Desktop and PowerBI service
Expert in ETL(SSIS) and DTS packages to perform data transfer from different server locations and heterogeneous sources like Oracle, Excel, CSV, XML, MS Word, and Text Format Data
Experience in using SSIS Import and Export Wizard, SSIS Designer, and other package execution utilities for performing the ETL operations
Hands on Experience in SSIS Configuration, Logging, Procedural Error Handling, and Data Error Handling
Experience in using multiple transformations provided by SSIS such as script component, Lookup, Data Conversion, Conditional Split, Bulk Insert, Merge, Merge Join, Union All and Slowly Changing Dimension
Experience in creating various SSIS packages, troubleshooting errors, and creating alerts using Send Mail tasks
Created stored procedure for generating reports using SQL Server Reporting Services SSRS.
Experience in designing reports using SQL Server Reporting Services, generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamic, filters, and charts in SSRS
Implemented parameterized, cascading parameterized, drill-down, drill-through and sub-reports using SSRS.
Involved in complex data mapping, modeling data, and understanding business data relationships
Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, MS Excel spreadsheets, and Power pivot
Expert in presenting multi-platform data visualization like pie/bar/graph charts and Dundas charts
Experience in implementing the Indexes such as clustered index, non-clustered index, covering index appropriately on data structure to achieve faster data retrieval
Experience in writing Sub-queries, Joins, T-SQL queries to create database objects and simplify complex queries involving different tables, and create relationships between tables using the foreign key and primary key
Experience in Database/Data Mart Design, stored procedures, Triggers, Indexes, Data Cleansing/Data Mining
Experience working with Agile and Waterfall methodologies in SDLC
Able to work collaboratively, quickly understanding the system architect and business needs towards achieving goals
Excellent communication and management skills. Quick learner and excellent team player, ability to complete the task on time
PROFESSIONAL SKILLS:
• Query Review • Code Optimization • Query Development • Database Table Designing • Database Table Coding • Data Modelling • Database Triggers Development • Table Index Development • Project Management • Requirement Gathering
• SQL Programming & Scripting Languages: C, C++, Java, JavaScript, MS SQL Server2016,2014,2012,2008, MS-Access, Oracle, MySQL, DB2
• Operating Systems: Mac-OS, LINUX, UNIX, Windows 10/8.1/8/7/XP, Windows Server 10/8.1/8/7/XP, Windows 2003/NT BI
• Programming language: T-SQL, PL/SQL, C, C++, .NET, VB.NET, HTML
• BI Tools: MSBI Stack (SSIS, SSRS), Microsoft Visio, SQL Server Management Studio
• GUI: DTS Import/Export, SQL Server Integration Services
• Reporting Tool: SQL Server Reporting Services (SSRS), MS Excel, PowerBI, Tableau Reporting Tool
• ETL Tool: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Informatica
• Version control tools: Visual Source Safe (VSS), Subversion (SVN), Team Foundation Server (TFS)
WORK EXPERIENCE:
Envista, Carmel, IN May 2022 to Current
PowerBI Developer
Responsibilities:
Developed calculated columns and measures using DAX in PowerBI
Expertise in data migration in Microsoft Dynamics 365, including data mapping, data extraction, data transformation, and data loading
Experience in working with different data sources, including databases, spreadsheets, and flat files, and migrating data into Dynamics 365
Created SSIS packages to perform filtering operations and to import the data daily from the legacy data sources to SQL Server 2016
Creating complex SQL scripts to transform legacy data in the staging area using SSIS packages
Configuring SSIS packages for runtime parameters and configuring files
Used SSIS for Extracting and Merging data from a different source to a single source
Scheduling Jobs to run SSIS Packages in the night feed to DSS for fresh day data
Scripting using SSIS packages for data cleansing, encrypting, and decrypting sensitive information
Created SSIS packages to automate different FTP files and emailing to different clients
Designed, Developed and Deployed custom reports in MS SQL Server environment using SQL Server Reporting Services-2008.
Created SSIS packages using various Transformation to generate underlying data for the report and to export the cleaned data from Excel, CSV, Flat file, and MS Access to the data warehouse
Created notifications and alerts, subscriptions to reports in the PowerBI service
Deployed Reports to Report Manager and Troubleshooting for any errors during in execution
Developed transact-SQL commands including complex queries, views, functions, stored procedures, cursors and triggers on SQL server 2008 R2/2008/2005/2000.
Migrated DTS objects to SQL Server Integrated Services SSIS environment.
Scheduled the Reports to run on a daily and weekly basis in Report Manager and email them to the directors and analyst to review in an Excel sheet
Responsible for extracting, transforming and loading data from Multiple Sources to Data Warehouse using SSIS.
Implementing various SSIS packages having different tasks and transformations and scheduled SSIS packages.
Created Sub-Report, Matrix Report Tablix Report Drill Down Report and Charts using SSRS
Deployed and subscribe Reports using SSRS to generate all daily, weekly and monthly reports
Developed SSIS packages that can extract data from various sources and merge them into one only source for Power BI reports
Designed a PowerBI Data model with multiple Facts and Dimension Tables based on the requirement
Designed and Implemented analytics solutions using PowerBI Dashboard and Reports
Participated in testing during the UAT (QA Testing). Mentored and monitored team development and status
Drop and recreate Index on the DSS System while migrating data
Based on the business requirement written complex T-SQL queries to perform data and graph validation to make sure that the test results are matched
Created trace in SQL Profiler and used Database engine tuning advisor for performance tuning on scripts and stores procedures
Environment: SQL Server 2014/2016, SQL Server Integration Services, PowerBI MS Excel 2016, MS Access 2016, Management Studio, SQL Profiler and SSRS.
Verizon, Herndon, VA Mar 2021 to April 2022
MSBI Developer
Responsibilities:
Wrote from simple to complex T-SQL queries in SQL Server Management Studio, for extraction of data from the staging environment based on the requirement and pushed the required data to the UAT environment
Created simple to complex Store Procedures to re-use all the complex queries that I wrote for the Enterprise Data Warehouse (EDW) in a specific format with the help of the given template
Responsible to create various Tables, Views and Functions based on the requirement specified by the EDW team and wrote complex Join statements for combining data from various Databases and tables in different relational model database servers such as Oracle and DB2
Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report or PowerBI
Involved in migration and conversion of Reports from Crystal Reports to SSRS 2008R2.
Designed and implemented Stored Procedures and Triggers for automating tasks.
Fine-tuned SQL queries for maximum efficiency and performance using MS SQL Profiler, Database Engine Tuning Advisor, and Execution Plan and Index Tuning wizard
Involved in improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards
Created effective reports using visualizations such as Bar charts, Clustered Column Chart, Waterfall Chart, Gauges, Pie Charts, TreeMap, etc. in PowerBI
Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through and Drill down Reports.
Fine-tuned SQL queries for maximum efficiency and performance using MS SQL Profiler, Database Engine Tuning Advisor, and Execution Plan and Index Tuning wizard
Helped in Rebuilding the Indexes at regular intervals for better performance
Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
Worked with a Congo’s team and helped to create complex weekly, quarterly and annual reports by writing code based on the requirement.
Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
Produced operational reports in SSRS 2012/2008R2 i.e., Drill-Down, Drill-through, Dashboard, Sub-Report, and Matrix reports.
Attained legacy data to use as a source to develop new reports previously compiled and maintained manually.
Created SSRS Data Model projects using Microsoft Visual Studio 2010/2008 and using Report Builder for report server to create reports
Converted manual reports pasted together into parameter driven stored procedures to be used with Microsoft Reporting Services 2012/2008R2
Involved in configuring the report viewing security for various users at various levels using Report Manager
Maintained Backup of the data, created Job failure alerts using SQL Server Agent and restore data from the backup on request
Developed dashboards with PowerBI which display key KPIs for business analysis and decision making
Improved performance of SQL Queries using SQL Execution Plan and SQL Profiler
Published reports on PowerBI services, shared dashboards utilizing within office 365
Extracted data using SSIS packages (ETL) from different server locations and data sources like Excel, CSV, flat file, and Text Format Data, and load data using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension
Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse databases
Helped in planning out the coding and offered different solutions in the initial planning of the project
Environment: -MS SQL Server 2012, 2008r2, SSIS, SSRS, T-SQL, SSMS Execution Plan, SQL Profiler, Log Shipping, Windows 2008 Server, and Erwin 8.0, MS-Office, MS Outlook Express, Linux, Windows
BOEING, Seattle, WA Feb 2018 to Mar 2021
SQL Developer
Responsibilities:
Migrated SQL Server 2008 databases to SQL Server 2012 and upgraded SSIS Packages
Used Performance Monitor and SQL Profiler for Monitoring memory, processor and SQL Queries
Deployed the created SSIS packages in Development and Testing environments
Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases
Implemented various sets of loggings (Text log, SQL Server Log) for SSIS Packages
Used various SSIS tasks such as Conditional Split, Derived column, data validation checks etc. during staging, before loading the data into various sources
Successfully migrated SSIS packages from development to test and production environment using SSIS Configuration files and development wizard
Installed and configured and maintained PowerBI Report Server
Created the PowerBI dashboard and generated reports using the SQL server tables as a source. Lock objects on the reports
Created reports on PowerBI Desktop and published them on the PowerBI Report Server
Involved in migration and conversion of Reports from SSRS 2008 to 2012
Involved in developing Bar graphs, Pie charts and Report templates based on financial data.
Developed Multi-dimensional objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
Building OLAP Cubes for analyzing claims data and business process
Creating and Modifying T-SQL Stored Procedures/ Triggers for Validating Integrity.
Rebuilding Indexes and Tables as part of the performance tuning exercise
Created Database Objects-Tables, Views and functions and developed procedures for implementing application functionality at the database side for performance improvement
Environment: MS SQL Server Management Studio 2012/2014, SQL Profiler, Index Tuning Wizard, MS SQL Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Microsoft Visual Studio.
EDUCATION:
Bachelor’s from Kakatiya University
Contact this candidate