Praveen Gopathi

Power BI/SQL Developer / adwre8@r.postjobfree.com / +1-703-***-****

- linkedin.com/in/praveen-gopathi-11311b199

Professional Summary:

•Around 7 years of professional IT experience in design, development, implementation and support of mission-critical Business Intelligence (BI) applications.

•Experience in BI Development, Designing and Deployment of Reports for the End-User requests from database.

•Experience in creating reports and dashboards in Power BI, creating content packs and training business users and service delivery users on how to use the content pack to extract their daily reports.

•Experience in Creating Data Visualizations like Line chart, Bar Charts, Pie Chart, Table, Matrix table, Area Charts, tree map, Line and Stacked column chart and Creating Visuals like Donut chart, Waterfall chart, Gauge chart, Funnel etc. in Power BI Desktop.

•Experience in Publishing, sharing by creating groups, Permissions and limiting Interactions of users and scheduling customized interactive reports and Dashboards using Microsoft Power BI Service.

•Used Power Query to acquire data and Power BI desktop for designing rich visuals.

•Knowledge in creating stories and dashboards in Tableau.

•Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.

•Creating Excel reports, Dashboards & Performing Data validation activity VLOOKUP, HLOOKUP, Macros, formulas, index match, Slicer with (Pivot table, Get Pivot Data, Dashboards), Power View, Power Map and Heat Map.

•Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.

•Expert in creating and using Stored Procedures, Views, User Defined Functions.

•Good in creating Sub-Queries and complex Joints for queries involving multiple tables and Exception Handlers.

•Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.

•Experience in migrating data from on premises database to azure SQL database using azure data factory, azure functions, and azure blob storage.

•Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database.

•Experience in using Vertipaq Analyser Metrics in DAX Studio for optimization and performance of reports.

•Experience in working with Cloud based Snowflake database.

•Creative thinking, positive attitude, decision making in critical situations, pre-planning, customer satisfaction are the key aspects which lead me to my success.

•Worked closely with management, applications development Team, and users on database solutions to resolve business problems.

Education:

Bachelors: BA, JNU Delhi - 2009

Masters: PG Diploma, HNB Garhwal University - 2010

Technical Skills:

Database:

MS SQL Server 2012/2014/2016/2017, MS Access, Snowflake, Oracle9i/ 10g/11g/12c/18c, DB2, PostgreSQL

Programming Languages:

T-SQL, PL/SQL, C, HTML, DHTML, XML

Reporting Tools:

Power BI, SQL Server Reporting Services (SSRS).

Tools:

SQL Server Business Intelligence Development studio, Enterprise Manager, SQL Profiler, Query Analyzer, Import & Export (DTS),JIRA

MSBI Tools:

SSIS, SSRS, SSAS, Power BI

Other Tools:

MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP &OLTP, Adobe Photoshop, Abode Flash, Hyper-V Manager, Figmi. DAX Studio

Operating Systems:

Windows 10/2008/2007/2003R2, Windows XP, Windows Vista

Methodology:

Agile (Scrum) and Waterfall

Career Overview

Client: AMN Healthcare Apr 2022 to Present

Power BI Developer

Description: AMN Healthcare is nation’s largest staffing company to hire physicians and clinicians for healthcare industry. Main role in this project is to create, enhance and maintain the Mobile App and Web page-based reports for business analysis using snowflake database. Implementing the browser and app usage tracking, using various reports and layouts for tracing the usage statistics and patterns of the users.

Responsibilities:

Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data feed and Reporting systems.

Created look up tables in Power BI and imported fact table from snowflake and designed the data model.

Created Sample report and collaborated with .net team to embed it, in order to help Business Team to understand more about the tool and its potential to meet the requirements.

For designed and optimized UI requirement, pull necessary columns and improved and optimised data form Snowflake view/table.

Created Cross- filters relationships and maintained Row- Level Security for Embedding Power BI reports for Customers.

Worked with Azure team to get necessary Permissions for Application to Access Reports.

Utilized RLS and maintained Security for End- Users while Embedding Reports to Customers.

Scheduled Automatic refresh and monitored refreshes in Power BI Service.

Created Navigation reports using Buttons, Bookmarks in Power BI Desktop.

Created Index Keys in look up tables and maintained relationships in order to improve the performance of repots.

Created complex DAX Queries to meet the business requirement of conditional hiding of data and created conditional columns and measures.

Embedded Individual Tiles into Application and worked on Embedding complete Report using Report ID. Enabled Query Caching in Power BI Service to meet SLA’s for Performance of the report.

Monitored and Supported 24/7 Production Environments.

Environment: SQL Server 2014/2012/2008R2/2005, SSIS, Snowflake, MS Excel, MS Visio, Linux and VMware Power BI and DAX.

Client: Macys - Atlanta, GA Sept 2021 to Apr 2022

Power BI Developer

Description: Big Ticket Merchandising Reporting. The automatic re-calculation tool will process the ROF adjustments based on the filters selected and ROF adjustments entered by the Inventory Planners. The main benefit of the automatic re-calculation tool is a reduction in manual processing, an immediate output/view of the adjustment impact and timelier and more accurate ROF projections. The scope of the project is key ROF components of the C1 Report which the Inventory Planners analyze closely each week in order to provide timely and accurate dollar and unit projects to MLO in total as well as by DC Location.

Responsibilities:

•Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data feed and Reporting systems.

•Responsible for building reports in Power BI from the Scratch.

•Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.

•Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.

•Experience on publishing Power BI reports on dashboards in Power BI server.

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

•Worked with both live and import data into Power BI for creating reports.

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

•Used different type of slicers available in Power BI for creating reports.

•Extensively involved in design of Dashboard to display all the customer related information.

•Developing all the visualizations which are requested by the business users using Power BI.

•Design and developed the Power BI solution to create reports, visualizations and dashboards as per the business requirements and published enterprise.

•While design the Power Bi reports and dashboards, the measures are created using DAX programming language. Writing all the calculations using DAX formulas.

•Scheduled the data refresh for dashboards and reports to show the live data.

Environment: SQL Server 2014, TFS, Microsoft Visual Studio 2012, T-SQL, SSIS, SSRS, Power BI and DAX.

Client: Charles Schwab - San Francisco, CA July 2020 to Aug 2021

Power BI Developer

Description: Charles Schwab is a financial services firm, providing innovative advice to public and private sector clients worldwide, with a strategic focus on the renewable energy sector. The main goal of the project was to maintain and upgrade the ETL process which transfers the data from clients and internal departments into a data warehouse of renewable energy transactions.

Responsibilities:

•Implementation advance SQL queries using DML and DDL statements to extract large quantities of data from multiple data points on MS SQL and Teradata SQL Assistant.

•Designed and developed a new ETL/SSIS package that loads data from OLTP into our existing Data Warehouse based on technical specifications and business requirements.

•Responsible for creating critical compliance test analysis documents and Business Requirement Documents (BRD).

•Provided maintenance and development of bug fixes for the existing and new Power BI Reports.

•Involved in designing and publishing visually rich and intuitive Power BI dashboards.

•Published Power BI Desktop reports created in Report view to the Power BI service.

•Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS.

•calculations using Multidimensional Expression MDX & DAX.

•Extracted data from SQL Server, Flat Files, Excel and XML using SSIS and cleanse the data.

•Migrated existing QlikView reports to POWER BI reports.

•Used Joins, correlated and non-correlated subqueries for complex business queries involving multiple tables & calculations from different databases.

•Experience in Data Analysis, understanding trends and patterns in data.

•Involved in scorecard and KPI Reporting.

•Transformed and combined the data using Query Editor in the Power BI.

•Created Sub-Reports, Drilldown-Reports, Summary Reports.

•Published dashboards on an intranet site using SharePoint Server

•Followed the AGILE methodology for the entire "SDLC".

•Worked on writing the T-SQL code for the historical data to pull according to the specification requirement.

•Used Microsoft Azure Data Storage, Azure Data Lake and Azure Data Factory.

Environment: Power BI, Oracle, SQL Server, Power Designer, MS Vision, JIRA Microsoft Office Suite (Word, Excel, Power Point)

Client: Charter Communications - St. Louis, MO June 2019 to June 2020

Power BI Developer

Description: Worked on a project called Spectrum-mobile for the client Charter communications. With the purchase of the code from Comcast Mobile, Spectrum Mobile will require modifications to performing diagnostic tests on Orders from the existing Charter backend systems.

Responsibilities:

•Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.

•Designed, Managed and published various reports using SQL Server Reporting Services 2012 and Power BI.

•Designed Dimensional Modeling using SSAS cubes for End-User.

•Project involved maintenance of existing OLTP databases as well as designing SSIS packages for custom warehousing needs.

•Created Crystal Reports Repository objects (Reports template, commands)

•Participated in the data analysis and database modeling of both OLTP and OLAP environment.

•Extracted data using SSIS from OLTP to OLAP.

•Integrate various legacy data Sources like legacy unidata into SQL normalized Form for clean instances of Data elements, Oracle database, third party data through web services into one centralized Data warehouse in Azure SQL Data ware house using ETL Techniques and designed SSIS Frame works along with data architect for continuous flow of data.

•Developed custom reports using SSRS/Power BI.

•Collaborated in dramatically increasing OLTP transactions on systems handling several billion transactions weekly through the implementation of advanced database techniques such as join optimization, table structure and fragmentation analysis, bulk inserts, analysis of indexes and locks, creation of custom timers to detect bottlenecks.

•Thorough analysis and testing of database objects &T-SQL statements before deployment to the production server.

•Migrated and translate legacy reports into Power BI from SSRS environment.

•Developed and implemented SSIS and SSRS application solutions for various business units across the organization.

•Used DAX query in writing queries and defining measures and calculated columns in PowerPivot and in tabular models in SSAS.

•Administered and maintained the BI Portal, Data warehouse and existing BI solutions.

•Responsible for creating the Complex Crystal Reports (on demand, AdHoc reports, Frequency reports, Summary reports, Sub reports, Drill-Down, Crosstab, Dynamic Grouping, Csross-Tab, Graphical, Aging reports) and modifying the existing reports.

•Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.

•Worked on forward and reverse engineering data architecture using data modelling tools like ER/Studio.

•Extract dataset from different data source including SQL Server, excel and flat file prepare datasets for Power BI.

•Strong Knowledge of Software Development lifecycle and methodologies like Waterfall, agile methodology and Scrum approach.

•Used TFS for proper documenting and implementing of codes on all environments.

•Created highly complex SSIS packages using various Data transformations like Conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.

•Generated Custom ETL scripts using SSIS 2014 and unit test SSIS load processes for performance check.

•Created various complex reports and manage those using SQL Server Reporting Services (SSRS) according to ERLC.

•Created multiple data visualization solution for initial Power BI environment business preview.

•Migrated and Converted Reports from SSRS 2012 to 2014.

•Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.

•Highly involved in creating, structuring, formatting using Report Designer and Report Builder.

•Written & integrated stored procedures to generate the special reports according to client's need.

Environment: SQL Server2016/2014/2012, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, PPS, XML, MS power point, MS Project, MS Access & Windows Server 2008R2, Oracle, OLTP, OLAP, Crystal Reports, Business Objects, SharePoint, ER/Studio.

Client: Ford - Chennai, India June 2016 to Mar 2019

SQL Server/MS BI Developer

Description: The major requirement of the project is to migrate from legacy systems to SQL server due to the growth of the company and increased requirements. The project also required monitoring the billing services by creating reports and report models using SQL server reporting services.

Responsibilities:

•Experience in Creating, Configuring, and Fine-tuning ETL workflows designed in MS SQL Server Integration Services (SSIS).

•Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, Dimensional modeling.

•Knowledge in developing and modifying multi-dimensional cubes using SQL Server Analysis Services (SSAS).

•Created Tabular, Matrix, Chart, Drilldown Reports, Parameterized, Cascading reports according to business requirement and deployed the generated reports directly on the client's workstation.

• Experienced in writing Parameterized Queries for generating Tabular reports, formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS.

•Excellent T-SQL skills including Stored Procedures, Indexed Views, User Defined Functions, Common Table Expressions, and Triggers.

•Involved in Huge data migrations, transfers using utilities like SQL Server Integration Services (SSIS).

Environment: MS SQL Server 2008/2008 R2/2012, SSIS, SSRS, T-SQL, Windows Server 2008, MS Excel, and MS Office, SQL Server Management Studio 2012, DOT NET Framework 4.5, XML.

Military Experience: 2005-2016

A Highly driven soldier who maintains a positive attitude under pressure and welcomes the challenge and responsibility of producing results quickly for organization and held various appointments.

Having years of experience in the army with competencies in Security Operations, Logistics, Surveillance, Policing, Training, Coordination, Administration and Personnel/logistics management.

Set short-term and long-term objectives for strategic maneuvers to achieve cross-departmental goals. Conducted meetings to communicate operational expectations and goals.

Evaluated information and advised teams based on careful analysis of operational information.

Performed security checks and routine maintenance on computer systems.

Trained new personnel on all operations and distributions systems.

Contact this candidate