Ruchitha Rao

Email: adztvu@r.postjobfree.com

Phone: 980-***-****

PROFESSIONAL SUMMARY

Over 4+ years of experience in Data Analysis, Design, Implementation, Administration, and support of Business Intelligence using SQL Server SSIS, SSAS, and SSRS.

Expertise in Power BI, Power BI Pro, and Power BI Mobile.

Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports, and create and share dashboards based on reports in Power BI desktop.

Worked on Data Factory to load data from Data Lake to Azure SQL Data warehouse and Azure SQL.

Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database, and SQL data warehouse environment

Expert in creating and developing Power BI Dashboards in to rich look.

Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling, and reporting tools.

Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from

different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards.

Proficient in writing complex T-SQL (DDL, DML), new features like CTE, Ranking Functions, TOP(n), PIVOT, XML PATH, SQL, Physical, logical database design, and Performance tuning.

Holds good knowledge of SSAS Concepts like the creation of Cubes, Dimension/Fact Tables, Deployment process, and knowledge about the creation of Power pivot and performance considerations in T-SQL.

Proficient in developing parameterized reports, charts, graphs, linked reports, and drill-down reports using SSRS/Power BI.

Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design

Created different visualizations (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line and clustered Column Chart, Map, Slicer, Time Brush, etc.) in Power BI according to the requirements.

Hand-on experience in writing calculated columns and measures using MDX and DAX query language

Experience in Error handling Debugging coding issues and troubleshooting production problems.

Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.

Worked on creating Azure Data Factory for moving and transforming the data.

Hands-on experience in writing SSIS scripts/ Script component tasks using C#, and VB scripts for customized data manipulation of complex SSIS packages

Experience modifying views and dashboards in Tableau to reflect updates and changes to requirements.

Experience in publishing Power BI Desktop reports created in Report View to the Power BI service.

Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS), and SQL Server Integration Services (SSIS) R2).

Proficient in SSAS storage and partitions, aggregations, defining hierarchies, calculation of queries, and developing reports using MDX and T-SQL.

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

Experience in Interacting with Business users to analyze the business process and transform requirements into screens, performing ETL, documenting, and rolling out the deliverables.

Extensive experience in writing Power shell and VB scripts to automate the script task

Technical SKILLS

Databases: SQL Server, Oracle, Oracle DB2, Postgre MS Access, NoSQL Databases (Hbase).

Database Tools: MS SQL Server, MS-Access, SQL Server Integration Services (SSIS), Data Transformation Services (DTS), SQL Server Reporting Services (SSRS)

Development skills: T-SQL, PL/SQL, SSIS/SSRS, SQL PLUS, Power BI

Languages: VB.net, Linux, Unix

ETL Tools: DTS, SSIS (SQL Server Integration Services), Informatica, COMOS, Kettle, Azure Data Bricks, Azure Data Factory

Reporting Packages: SQL Server Reporting Services, MS Excel.

Tools: /Methodologies MS Project, SQL Profiler, Toad, TFS, Agile, Jira, Waterfall.

Operating Systems: Windows

EDUCATIONAL DETAILS

Master in Science from the University of New Haven

EXPERIENCE

SQL POWER BI Developer

Client- Humana Tampa, FL April-2022 to present

Responsibilities

Coordinating with business users in analysing business requirements and translating them to technical specifications.

Developed dashboards and ad-hoc reports using MS Power BI and SSRS for the senior management team for analysis.

Using the SSIS Package identify the Upstream and import the required tables into the intake database, Store Procedures are created in the staging database using the intake database tables & and views.

Created complex SQL stored procedures, Triggers, Functions, Views, and Indexes in SQL Server 2016.

Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services and reporting services.

Design data model and create the schema on Azure SQL

Worked on an Azure copy to load data from an on-premises SQL server to an Azure SQL Data warehouse.

Worked on redesigning the existing architecture and implementing it on Azure SQL

Good grasp of database concepts, structures, storage theories, practices, or principles.

Hands-on expertise in SQL reporting, development, analytics, or BI.

Relevant experience in processing flowcharts or data flow diagrams

Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure, etc.

Migrated data from On-Premises to Azure SQL Server using ADF Pipelines

Created various views in Tableau like Treemaps, Heat Maps, Scatter plots, Geographic maps, Line charts, and Pie charts.

Designed and implemented SSAS Tabular Cube as the reporting layer. And Used DAX scripting to access data from the Tabular Model

Created many complex queries and used them in Power BI Reports directly to generate reports on the fly.

Incorporated complex business logic by writing complex SQL procedures and functions.

Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large database sets.

Extracted data from Oracle, SQL Server, Flat Files, Excel, and XML using SSIS and cleansed the data.

Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.

Checking the code into TFS (Store Procedures, Views, Tables, Schema) for the deployment process for the production environment

Published Power BI Reports in the required originations and Made Power BI Dashboards available to Web clients and mobile apps.

Involved in validating data between Qlik Sense and Cognos reports

Wrote T-SQL (DDL and DML) queries and store Procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.

MSBI Developer

Client- Max Life Insurance July-2019 To Dec 2020

Responsibilities

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

Provided guidance and insight on data visualization and dashboard design best practices in Tableau.

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 &, and testing OLAP cubes with SSAS 2014 and in adding calculations using Multidimensional Expression MDX & DAX.

Able to handle multiple tasks and prioritize accordingly

Designing database tables and Structures using MS SQL server

Transforming data in Azure Data Factory with ADF Transformations

Maintaining data quality and overseeing database security

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

Plan and scheduled the report to run at a desired frequency in Cognos Scheduler and scheduled the cubes to run on ETL job completion dependency using the Auto sys tool

Used Microsoft Azure data storage and Azure Data Factory, Data Lake

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.

UI development using HTML5 and CSS

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

Data Analysis, understanding trends and patterns in data.

Involved in the scorecard and KPI Reporting.

Implemented and successfully tested Log shipping in SQL Server 2008 and SQL Server 2012.

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

Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports using SSRS.

Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.

Published dashboards on an intranet site using SharePoint Server.

SQL Developer

Client-ICICI India

Responsibilities Jan-2018 To June 2019

Designed rich dashboards with Power BI and prepared user stories to create compelling dashboards to deliver actionable insights.

Gathered data from various external sources (Oracle) into a data warehousing system (Enterprise Cube) with the help of the fETL process.

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

Responsible for ongoing maintenance and change management to existing reports and optimizing report performance (SSRS).

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

Involved in database development using stored procedures, triggers, views, and cursors

Wrote DAX Expressions, Power Query, and Functions in Power BI.

Used SSAS features to build and configure Hierarchical dimensions, define Measure groups, create Calculated Measures, and KPIs, and configure Partitions, aggregations as well and Actions.

Used various Data Visualizations with Power BI and published reports to Power BI Services

Implemented cell-level security in cubes using MDX expressions to restrict users of one region from viewing data of another region using SSAS.

Monitored performance and optimized SQL queries for maximum efficiency.

Used majority of the transformations, tasks, and containers present in SSIS which include Fuzzy grouping, Derived Column, Conditional Split, Aggregate, Lookup, Row Count, Merge Join, Union All, Multicast, Sort, Copy column, Data conversion, and other transformations during development.

Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements, and physical constraints. Designed and developed web pages using VBScript.

Created automation script to Scale up/down the Data Warehouse.

Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages and Stored Procedures.

Performed tuning of SQL queries and Stored Procedures for speedy extraction of data to resolve and troubleshoot issues in the OLTP environment.

Using a Query Editor in Power BI performed certain operations like fetching data from different files.

Merge Queries and Append Queries, remove columns and split columns, and choose required columns in the data.

Created dimensions by defining Parent-Child relationships, using different dimension types

Involved in planning, defining, and designing star/snowflake diagrams using Erwin on business requirements and provided documentation.

Contact this candidate