Power Bi Information Technology

Suchetha Tipparthi

337-***-**** **********@*****.*** suchetha-tipparthi

SUMMARY

With nearly 7 years of experience in Information Technology specializing in Data warehousing projects, I excel in Requirement Analysis, Design, Development, Quality Reviews, and Implementation support. I possess strong communication and interpersonal skills, alongside technical proficiency, a results-driven mindset, and exceptional problem-solving capabilities. Recognized for my innovation and efficiency, I thrive as a collaborative team member or autonomously with minimal supervision. SKILLS

● Proficient in SQL, T-SQL, SQL Server, Python and Oracle PL/SQL

● Experienced in SAP HANA modeling, creating Attribute and Calculation Views and script-based views

● Skilled in Tableau Desktop, Tableau Server, Qlik Sense, Power BI Desktop, Power BI Service, Excel and PowerPoint for

data visualization

● Experienced in ETL/ELT process using Informatica, Python to source data from CSV or database, transform them and load them into Database.

● Knowledgeable in Data Blending, Parameterization, Sets, Drill Down reports, and various chart types

● Experience working in Data Management, Data Integration, Data Modeling, Data Wrangling, Data Migration

● Performed Data cleansing activities to remove duplicates and formatting data.

● Involved in creating functional and technical specifications, as well as providing user demos during Go Live

● Good understanding of GitHub, Jira and Confluence pages.

● Developed Crystal Reports and worked with Analysis for Office

● Familiar with Excel, Word, BODS, Data Modelling, and Data Warehouse concepts. PROFESSIONAL EXPERIENCE

Deloitte – Jan 2017 till Dec 2020

Role: Senior Data Analyst

Responsibilities

● Led BW Replacement, iRPM, Consulting Ops, and Talent Model projects, overseeing sprint projects

● Developed calculation views (Graphical & Script) based on Functional Documents provided by Users

● Designed procedures for data loading from views into tables as per project requirements

● Created Informatica and BODS jobs for data loading from Procedures and Flat files into Hana Tables

● Conducted unit testing for all developed objects and prepared Technical Specification documents

● Managed migration of developed objects across landscapes

● Resolved UAT bugs promptly to ensure timely completion of sprint deliverables

● Conducted Hardware Upgrade Testing on Hana Environments and PE Testing for Views

● Tested AO and Crystal Reports, creating customized reports based on user requirements

● Built and published interactive reports and dashboards, scheduling reports using Tableau, Power BI server

● Implemented action filters, parameters, and calculated sets for dashboards and worksheets in Tableau.

● Developed visualizations and dashboards using Tableau Desktop, Power BI Desktop and Power BI Service, blending data from multiple sources.

● Created Drill-down reports, scatter, doughnut, line, column and etc. charts using Tableau Desktop, Power BI Desktop.

● Create ETL flows in Python as well to consume the files in excel format for document warehouse projects and load them into tables using multi-threading in python by creating classes, getters and setters to encapsulate the data and store them in MySQL.

● Consumed flat files, SQL tables in python using batching process and used pandas and loaded them into SQL server tables.

Cognizant Technology Solutions – Mar 2014 till Nov 2016 Role: Programmer Analyst

Responsibilities:

● Designed, developed, debugged, and delivered high-quality work to clients

● Designed data models and created tables

● Loaded extracts into facts and dimension tables

● Created scripts, functions, and procedures for reporting purposes

● Utilized SQL Loader and SSIS to load data from flat files obtained from Share path

● Optimized queries and tuned performance at the query level

● Utilized ETL Informatica to extract data from various sources and perform complex transformations

● Utilized Analytical Functions for reporting in Pie and Bar charts

● Created scripts for new tables, views, and queries for application enhancements

● Created indexes on tables to enhance database performance

● Implemented Exception Handling for error management and debugging purposes. Project Description

American International Group, Inc. (AIG) is a leading international insurance organization serving customers in more than 100 countries and jurisdictions. AIG companies serve commercial, institutional, and individual customers through one of the most extensive worldwide property-casualty networks of any insurer. In addition, AIG companies are leading providers of life insurance and retirement services in the United States. GRID is a Dashboard Reporting system which will represent the data in the form of dynamic charts. Charts are used to show the Risk Reporting, Vulnerabilities and types of expressions in the representational format. EDUCATION

Bachelors in computer science from JNTU (HYDERABAD).

Contact this candidate