Resume

Summary:

Over *+ years of experience in Development, Client Analysis, Database Design, Reporting and Presentation using SQL Server, SSMS and Power BI.

Over 20 years of IT and Non-IT experience.

Experience in developing Dashboard, Ad-hoc and Parameterized Reports, create complex reports (ex: drill down reports using different objects).

Experience in the Data Analysis, Data Cleansing, and Data preparation for developing Power BI Dashboards

Experience with Data Loading from various data sources like SQL Server DB, SSMS, Excel sheets, Text/CSV, Web Pages, Azure Data warehouse, Folder.

Experience with various Data Transformation techniques for formatting and filtering the data, Merge Queries, Append Queries.

Excellent experience with creating new columns based on Column by Examples, Conditional Columns, Custom Columns based on the Business requirements.

Excellent experience in Data Modeling techniques to build/manage relationships between various data tables.

Excellent experience with Create new custom tables, new measures, Quick measures, new columns, Hierarches, Groups, DAX formulae and syntax.

Excellent experience with Data Visualization techniques to display the dashboard reports using various visualization charts, graphs, tables like Stacked/Clustered Bar charts, Maps, Matrix Tables, Pie charts, Slices etc.

Excellent experience in designing and developing Navigation and Bookmarks, with visualization formatting, Paint roller, and mobile views

Excellent experience creating various Workspaces and Publishing reports. Scheduling reports and data refreshes

Experience in using ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source system.

Experience working in Agile and Waterfall model working methodologies.

Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills.

Technical skills:

Databases : MS SQL Server, Oracle, PL/SQL, SQL Server Management Studio(SSMS), Query Analyzer,

Programming Languages : T-SQL, XML, ABAP, Python

Tools/Utilities : Power BI, SQL Server Integration Services (SSIS)

Educational Qualifications:

Masters in Education from Osmania University, India

Bachelor of Science from Sri Sathya Sai Institute of Higher Learning, India.

Professional Experience:

QUADRANT RESOURCES LLC

Nov 2019 – Dec 2022.

Role: Power BI Data Analyst

Quadrant Covid Dashboard

As a part of community service, Quadrant Resource built a covid report to give complete information about covid facts and information.

Responsibilities:

Collection of data from different sources such as GitHub, Web, and Excel or CSV files.

Transform data using column profiling, changing data types, column renaming, and many other transformations according to the requirements.

Created calculated columns and measures using DAX queries

Created data visualizations using various visual objects (Line chart, Bar chart, Single card, KPI, Map, Pie chart, custom visuals).

Created Bookmarks and custom tooltips

Employee Admin Report

This Report helps to provide the employee information within the organizations to discover useful insights for strategic decision making. It help to provide the information It will also help to make data-driven decisions to maximize the efficiency and profit of an organization.

Responsibilities:

Performed ETL processes to data ready for creating business analysis visuals which help the leadership team to make the right business decisions.

Worked on visuals as Employee Info, project details, skills, leaves, calendar, time sheet

Created measures.

Created and shared the dashboards within the organization for updating and editing the report as per the business requirement.

Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data mode

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI

Implemented role-based security and row level security on data in Power BI.

Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

Created Power BI dashboard and generated reports using the SQL server tables as source. Lock objects on the reports.

Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.

Deployed, Tested and Scheduled SSIS packages.

Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.

Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS.

Extensively used transformations like merge Queries, Append Queries, Pivoting the Column, UN Pivoting Columns, Adding Custom Columns, Spitting the Columns, Merging the Columns etc.

Extensive Experience in doing Data Modeling in Power Pivot Model.

Generated multi parameterized reports in Report Builder allowing users the ability to make selections before executing reports; thus, making them user friendly.

Developed dashboards to show survey, design, construction and information to field contractors.

Developed various packages to extract the data from different source like relational tables and flat files.

Analyzing and understanding the Excel Data and Creating SSIS Packages accordingly to dump the data in to SQL Database.

Designed and developed a full-scale reporting solution for a multi-client environment using MS SQL Server R2 and Report Builder.

Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services.

Involved in understanding their requirements and translating functional requirements to technical specifications.

ICONSOFT LLC

Aug 2015 to Sep 2019

Role – Sr Programmer

Involved in development Client Analysis, Database Design, Reporting and Presentation using SQL Server, SSMS and Power BI.

Leveraged multiple programming languages to develop applications for various platforms.

Met with stakeholders, product teams, and customers throughout system development lifecycle.

Resolved customer issues by establishing workarounds and solutions to debug and create defect fixes.

Performed regression and performance tests for updated systems.

AP State(India) ZPHS

Jan 1997 to May 2006

High School Mathematics Teacher (Non-IT)

Adapted teaching methods and instructional strategies to promote learning in students of differing skill levels.

Taught various kinds of math at standard, remedial and advanced levels.

Met with parents and guardians to discuss student progress and areas for improvement.

Prepared, administered and graded assignments and examinations.

Managed consistent, learning-focused classroom environments by establishing and communicating clear objectives for students.

Instructed students and supported understanding of math concepts.

Documented student assignments, attendance and test scores in online reporting systems.

Assessed student progress with course material through routine quizzes, final examinations and standardized assessments.

Evaluated submitted assignments for clarity and skills, assigned grades and discussed results with struggling students to enhance understanding of course objectives.

GEETHA BORRA

425-***-****

advihc@r.postjobfree.com

linkdin: https://www.linkedin.com/in/geetha-borra-930987236

Contact this candidate