Sharavana SS Dommaraju

Email-Id: ady648@r.postjobfree.com

Phone: +1-469-***-****

Objective:

To obtain an innovative, Challenging, and flexible position in a reputed organization where I will have opportunities to utilize my exposure and experience.

Professional Summary:

Having 7 years of IT Experience in providing Business Intelligence Solutions in Data warehousing using MSBI Tools like SQL Server, SSIS, SSAS, and SSRS/POWER BI

Professional Skills:

Worked on performing the ETL Activities using Power Query and used required transformations like Merge Queries, Append Queries, and Pivoting the data.

Having Visualization skills, developing interactive reports and dashboards Publishing the reports into Power BI Service, visual insights Geographic Map, Pie Charts and Bar Charts, and Donut Charts.

Designed different Types of reports like drill-down reports, Drill through reports, Sub reports Parameterized reports, List reports, and Gauge reports.

Deploying and scheduling Reports using PBI to generate all daily, weekly, monthly, and quarterly Reports including status.

Experience in doing Data Modelling in Power Pivot Model. worked on Enhancing the Data Model by Creating New Columns, New Measure, and New Tables using DAX Expressions.

Skilled in Power BI Desktop for data visualization, Reporting, creating effective Dashboards, and Publishing to Users.

Experience in the design and development of SSIS packages.

Good in Extraction, Transformation, and Loading data from SQL Server, Excel, and Flat Files SSIS(ETL).

Working on Tasks such as Dataflow tasks, Executing SQL Tasks, Executing Package, Bulk insert, File system, and Containers like for loop, for each loop in Integration services development.

Used Transformations like Derived Column, Conditional Split, Aggregate, Sort, Data Conversion, Merge join, And Union all.

Performing ETL activities using different types of sources Flat File, OLEDB, Raw File, and Excel files

Create DWH and Stage Tables using SQL Script, Load Data to DWH using SSIS using Dimension Modelling, Star and Snowflake Schemas with DWH Design Best Practice

Good understanding of Dimensions and Fact Tables and their relationships.

Good understanding of Full and Incremental Data Loading, and SSIS Logging.

Experience in Creating jobs and Scheduling SSIS Packages.

Experience in creating SQL Server Reports using SSRS/PBI.

Good experience in joins, subquery, built-in functions, Stored functions, stored procedures, Indexes, set operators, and CTEs.

Having knowledge in creating Databases, Tables, Stored Procedures, Functions, Triggers, and Views using various DDL and DML commands.

Having knowledge of Data warehouse Concepts.

Worked on generating reports and publishing reports using PBI.

Good experience in creating tables and complex views.

Having experience with temp tables, table variables, identity property, and Merge Command.

Work Experience:

Worked as a Software Engineer for Ubus Technologies Pvt Ltd, Bangalore from Apr 2018 to Jan 2023.

Worked as Jr GIS Engineer in Infotech Enterprises Ltd, Hyderabad from Aug 2006 to Dec 2008

Education Details:

●Bachelor of Technology in Mechanical Engineering from JNTU INDIA

Technical Skills:

Operating system : Windows

RDBMS TOOL : Microsoft SQL Server 2017/2019

Integration & Analysis Tools : SSIS, SSAS

Reporting Tools : Power BI

Project Details:

PROJECT#1:

Project Title : HealthCare Insurance

Client : Tardis, UK

Role : Power BI DEVELOPER

Environment : SSIS, SSRS, PBI, SQL Server 2017.

Description:

Tardis Healthcare is a global health service company with roots in the UK, serving more than 180 million customers and patients throughout the world. Tardis Healthcare operates in many lines of businesses like Casualty, Liability, and Specialty. Data Warehouse would refresh every day and almost all the latest data would be available for end users. A centralized Data warehouse system is built using SSIS with SQL Server.

Roles and Responsibilities:

•Involved in creating packages in SSIS 2017 using various Control Flow Tasks and Data Flow Transformations to implement Business Rules.

•Used Control Flow Tasks like Execute SQL Task, Execute Package Task, Execute Process Task, Send Email Task, and Data Flow Task.

• Working with Dataflow Tasks, Execute SQL Task Frequently.

•Creating SSIS Packages by using different Data Transformations like Derived Column, Lookup, Conditional Split, Merge Join, and Multicast while loading data into DWH.

• Involved in gathering user requirements.

•Involved in designing, coding, and testing the SSIS Packages.

•Involved in deploying and scheduling SSIS packages.

• Creating packages at SQL Server Integration Service platform.

• Writing SQL queries to retrieve the data from the database.

• Creation of Configurations and deploying packages to the target server.

• Analyze business requirements and provide business solutions.

•Good in writing T-SQL Queries, Dynamic-queries, sub-queries, and complex joins for generating Complex Stored Procedures, User-defined Functions, and Views.

• Experience in doing Data Modelling in Power Pivot Model. worked on Enhancing the Data Model by Creating New Columns, New Measure, and New Tables using DAX Expressions.

• Skilled in Power BI Desktop for data visualization, Reporting, creating effective Dashboards, and Publishing to Users.

• Designed and Developed Daily and Weekly Reports using PBI as per the client’s requirement.

PROJECT #2:

Project Title : HDA Project

Client : PRICE WATER HOUSE COOPERS, New York

Environment : SSIS, SSRS, PBI, SQL Server 2017.

Role : POWER BI DEVELOPER

Description:

HDA is a Clinical care management program for patients in the US. To provide the best treatment, we maintain the patient’s health history. By knowing the patient’s health history, health organizations can provide effective treatment to patients at a low cost. For this, we are creating a data warehouse with the patient’s health history in the US.

Roles and Responsibilities:

Understanding the Business Specifications and workflow of the existing system and analyzing the system.

Involved in creating various SSIS packages to implement the business workflow.

Populating the Data from different source systems into DWH using SSIS.

creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, and union all.

Deploying the packages to Integration, Acceptance, and production environments.

Used transformations like Derive Column, Lookup, SCD, Merge join, Conditional Split, Aggregate, Row Count, and Sort and execute SQL Task to load data into Data Warehouse.

Container Tasks like For Each Loop, For Loop, and Sequence Container.

Designed and developed matrix and tabular reports with drill-down, drill- through and drop-down menu options using SSRS.

Skilled in Power BI Desktop for data visualization, Reporting, creating effective Dashboards, and publishing .

Contact this candidate