SINDHU KONDA

Power BI/SQL Server Developer ad2ncc@r.postjobfree.com 202-***-****.

PROFESSIONAL SUMMARY

●8 years of professional IT experience with Data Modeling, Database Design, Programming, Development, and Implementation of Client-Server Applications and Database systems using SQL Server 2014/2016/2017/2019.

●Detailed knowledge of Microsoft BI studio products including SSIS,SSRS for the implementation of ETL methodologies in data extraction, transformation, and loading.

●Ability to design, develop and maintain Power BI reports and dashboards providing actionable insights to users.

●Experience on publishing Power BI reports of dashboards in Power BI server and Scheduling the dataset to refresh for upcoming data in power BI server.

●Experience in SAS/BASE, SAS/MACRO, and SAS/ODS, SAS/SQL, SAS/STAT,SAS/GRAPH, SAS/ACCESS, and SAS/CONNECT in UNIX and Windows environments.

●Communication experience with stakeholders, subject matter experts (SMEs), and end users in order to understand, analyze, communicate, and validate requirements.

●Having extensive experience in calculating measures and dimension members using multi-dimensional expressions (MDX), mathematical formulas, and user-defined functions.

●Expertise in Data Warehousing concepts and methodologies, including star schemas, snowflake schemas, ETL processes, and reporting tools.

●Created and extracted Oracle tables from SAS and within Oracle by using PL/SQL using SAS/ACCESS and SAS/CONNECT

●A proven track record of developing SSIS packages to import and transform data between external and internal databases.

●Expertise in using various SAS report generating procedures like PROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE and PROC PRINT.

●Extensive experience developing custom reports, including Tabular Reports, Matrix Reports, Ad-hoc Reports, Parametric Reports, Cascaded Reports, Conditional Reports, Table, Matrix, Chart, and Sub-Reports using SQL Server Reporting Services (SSRS).

●Detailed knowledge of RDBMS, including E/R Diagrams, Normalization, Constraints, Joins, Keys, and Import/Export of data.

●Written Korn-shell FTP scripts to FTP files to the specific path in the UNIX environment and to backup SAS files from mainframe.

●Created reports in SAS and exported to Excel spreadsheets, created web reports using Web Report Studio.

●A proven track record of creating underlying data for the reports and exporting cleaned data to a data warehouse from Excel Spreadsheets, flat files, and CSV files.

●Having experience configuring and maintaining Report Manager and Report Server for SSRS, and deploying and scheduling reports within Report Manager

●Ability to determine priorities, schedule work and meet critical deadlines with excellent communication skills.

TECHNICAL SKILLS

Power BI Tools

Power BI Desktop, Power BI Gateway, Power Query, DAX, Power BI App, SSIS, SSRS, SSAS

RDBMS

MS SQL Server 2008/2008R 2/ 2012/2014/2016 /2017/2019, Oracle, MS Access.

Languages

T SQL, DAX, M CODE, SQL*Plus, PL/SQL, XML

Software Packages

MS - Excel, PowerPoint, Word, TOAD

Application Administration

Oracle WebLogic Server

Methodologies

Agile, Waterfall, RAD

Operating System

Windows Linux.

PROFESSIONAL EXPERIENCE

Provident Bank Jersey City, NJ

Oct 2022 – Till Date Power BI Developer

Environment: Power BI, Power BI Gateway, Power Query, MS SQL Server 2019, SSIS, SSRS, MS Excel, Windows, Team Foundation.

●Gathering and analyzing requirements of clients, understanding and converting them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation.

●Integrated Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation’

●Developed and implemented efficient data extraction processes from various sources, including databases, APIs, and flat files.

●Integrate data from various sources, including SQL databases, Excel documents, and web services, into Power BI reports

●Visualize complex data and create charts that effectively communicate it to business users

●Resolve issues with Power BI reports and dashboards

●Extensive study, design, development and testing were carried out in the Oracle Environment

●Calculated columns and measured queries were written in PowerBI Desktop to demonstrate good data analysis techniques.

●Ensured the extraction of relevant and accurate data for business analysis and reporting in Power BI.

●Using Power BI and Power Pivot to write complex DAX functions.

●Conducted performance tuning of ETL processes to improve data loading speed and overall system efficiency.

●Applied data transformation techniques using tools like Power Query to standardize and clean raw data for consistency.

●Monitored and analyzed ETL performance metrics, identifying and resolving bottlenecks for enhanced performance.

●Extensively involved in getting data from oracle database using SQL pass- through.

●Developed and maintained data transformation scripts, ensuring compatibility with Power BI data models.

●Develop data modeling and visualization best practices for Power BI reports and dashboards

●Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc.

●Implemented complex business logic into Database Design and Maintenance using SQL objects such as Stored Procedures, User Defined Functions, Views, and T-SQL Scripting.

●Maintaining SSRS using Report Manager and Report Server, deploying and scheduling reports

●Work with Office 365 admins to create Power BI workspace groups with authorized members.

●Documented ETL processes, including data extraction, transformation, and loading steps, to facilitate knowledge transfer and troubleshooting.

●Extracting and converting data from one platform to another to be used for further analysis. From Oracle and Excel to SAS by using SAS SQL procedures and create SAS data sets.

●Transformed reports into interactive dashboards in Power BI for Business Users, Program Managers, and End Users.

●Produced Drill Down Reports, Parameterized Reports, Linked Reports, Subreports, and Ad-hoc Reports using SSRS.

●Developed star schema as per business requirements as part of the modeling activities.

●Analyzed data quality issues based on the latest data prep, fuzzy matching, and data profiling features.

McCormick & Company, Cockeysville, MD

Nov 2020 – Sep 2022 SAS BI Developer

Environment: Power BI, Power Bi Desktop, Power Query, Power BI Data Modeling, DAX, SSAS, SSRS, ETL, Microsoft SQL Server 2017, SharePoint, MS Excel, MDX, Agile, Windows.

●Used ETL processes, Collected data from a variety of external sources (Oracle) and stored it in a data warehouse system (Enterprise Cube).

●Advanced querying using SAS EG, Calculating computed columns, using filter, manipulate and prepare data for reporting, graphing, and summarization, statistical analysis, finally generating the data marton weekly basis.

●Created MDX scripts for KPIs and calculated members in SSAS based on business requirements.

●Developed DAX (Data Analysis Expression) functions for Excel pivot tables and SSAS tabular models.

●Managed relationship between tables in Power BI using star schema.

●Visualized data using various visual objects (Line chart, Bar chart, Tree map, Single card, KPI, Map, Pie chart, custom visuals).

●Involved in writing code using SAS/ Base SAS/ Macros for Creation and analysis datasets

●Developed and Executed SAS SQL Queries for Merging concatenating and Updating large volumes of Data

●Assisted in the development of SSRS reports that include subreports, dynamic sorting, and define data sources and subtotals.

●Built packages with the help of T-SQL queries, stored procedures, and handled slowly changing dimensions to keep the history of the data.

●generating SAS EG stored process with static and dynamic prompts for product specific analyses

●Importing SAS datasets, OLAP Cubes in SAS information Map Studio. Using instructions on how to access and combine relational data tables, calculating new data items, Created multiple pre-defined filters.

●Developed and maintained ETL automation scripts, reducing manual intervention and ensuring timely data updates.

●Used a query editor in Power BI performed certain operations like fetching data from different file.

●Utilized SSRS, Excel services, and Power BI to create reports.

●Creating various transformation procedures by using SAS 9.1, SAS Cube Studio, SAS Data Integration Studio, and SAS Enterprise guide.

●Conducted rigorous testing of ETL processes to identify and rectify data anomalies and errors.

●For data cleansing and data massaging, used Power Query in Power BI to pivot and unpivot the data model

●Used Power BI desktop to develop reports and dashboards based on multiple data sources.

●Create reports and dashboards using Excel and other data visualization tools.

●Generated customized reports using SAS/MACRO facility, PROC REPORT, PROC TABULATE and PROC SQL

●Analyzed data from various sources, including SQL databases and Excel files, to identify trends and patterns.

●Provided support and troubleshooting for reports in Power BI workspaces.

●Ensured data accuracy and integrity by working with IT and other departments.

Hanover Insurance Worcester MA

Jan 2019 – Oct 2020 Power BI Developer

Environment: Power BI Desktop, Power BI Service, DAX, SSAS, SSRS, Power Query, OLTP, ETL, Oracle, Windows.

●Developed databases and schema objects including tables, indexes, and constraints, connected various applications to the database, and wrote functions, stored procedures, and triggers.

●Implemented a Power BI dashboard for tracking sales data for an e-commerce company, improving the company's ability to analyze data.

●Tracked inventory and sales data in real-time with a Power BI dashboard for a retail store

●Shared ad-hoc reports with decision makers using Power BI using Excel Power Pivot.

●Used DAX functions extensively in the reports and tabular models.

●Developed robust error handling mechanisms to identify and address issues during the ETL process, preventing data inconsistencies.

●Created a Power BI dashboard to track the performance of a B2B sales team and identify areas for improvement

●Developed key performance indicators (KPIs), star schemas, and snowflake schemas in Analysis Services (SSAS).

●Involved in the creation of reports and updated the knowledge of all features of Power BI Desktop

●In order to assist other BI Reports, Data Flows were created with self-service data preparation.

●Data Folding and Query reduction techniques and Data Silos have been taken care while implementing Steps with transformations on power Query.

●Generated Drill down, drill through, Matrix Reports, and Parameterized reports using expressions to calculate, group, filter, and parameterize report using SSRS.

●Utilized version control systems (Git) to manage and track changes in ETL scripts and configurations.

●Developed transformations in SSIS such as checksums where all rows needed to be compared to update a table.

●Developed enterprise reports and stored procedures in response to requests. Implemented report models to meet business needs.

First Choice Health, Seattle, WA

Jul 2017 – Dec 2018 SQL Server BI Developer

Environment: Agile, SQL Server 2016, SSIS, SSAS, SSRS, MDX, Power BI, MS Office, T-SQL, Windows.

●Involved in Planning, Defining and Designing database using Erwin on business requirement and provided documentation.

●Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to load the shipping and customer data.

●Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.

●Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL Server, Teradata, Excel and Oracle to SQL Server using Business Intelligence Development Studio (BIDS).

●Created custom logging and package configurations to change connection strings and variables dynamically. Used all types of containers in SSIS.

●Created package deployment utility and deployed packages into various environments. Involved in unit testing, SIT, UAT and data validations.

●Designed, processed and partitioned cubes using SSAS. Good experience in designing aggregations and Calculations. Experience in deploying SSAS objects using deployment wizard.

●Created calculated measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.

●Writing various T-SQL queries, Stored Procedures and used them to build packages.

●Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using Microsoft SQL Server reporting services.

●Implemented security measures to protect sensitive data during the ETL process, adhering to organizational data privacy policies.

●Monitored ETL job performance using tools like SQL Server Profiler or similar monitoring tools.

●Created and maintained SSRS reports for External Reporting and Internal Activity Based Costing (ABC) for shipments tracking. Outstanding knowledge in creating drill down reports, Graphical reports, ad-hoc reports and drill through reports using the ROLAP/MOLAP as sources.

●Worked in agile methodology, participated in daily scrum meetings.

North Cascades Bank, Chelan, WA

Sep 2015 – Jun 2017 SQL Server BI Developer

Environment: SQL Server 2012, SQL Server Integration Services (SSIS), Reporting Services (SSRS), TFS, Pivot Tables, MS Visual Studio.Net, C#, SQL Profiler, Windows.

●Gathered requirements, designed the database, and created the workflow for the reports in collaboration with Business analysts.

●Integrated data flow and control flow controls into one central SSIS Master Package. Dynamically passed variables on runtime using Parent Packages and XML Configurations.

●Contributed to identifying and resolving data migration issues.

●Utilized a variety of variables, break points, check points, logging, package configurations and event handlers in SSIS packages to meet the needs of the business.

●Optimized queries and enhanced the performance of databases, SQL queries, and stored procedures by using SQL Profiler, Execution Plan, and Index Tuning Wizard.

●Developed complex SSAS Cubes based on OLAP reporting needs, with multiple fact measure groups and hierarchies.

●Created MDX queries for Analysis Services & Reporting Services.

●Implemented OLAP and offline reporting solutions using PivotTables and PivotCharts.

●For the different measure groups, multiple partitions and aggregations were created to improve cube performance.

●Fixed any data and connectivity issues with SSAS cubes.

●Helped Business Users understand how to generate reports with Excel and drill down into the data with SQL Server Analysis Services (SSAS).

Contact this candidate