Kotturi Kalyani

Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.

It brings benefits like expanding your mind and boosting creativity. Books provide an escape from stress, promoting relaxation and mental well - being. Participating in book clubs can make reading an exciting social activity.

Pursuing a hobby like painting is more about overcoming inhibitions than creating a picture – It takes practice, experience and observation. Painting can stimulate your imagination, inspiring you to explore how you interpret the world.

Creative crafts like knitting, crocheting, and painting are actually good for you. They boost your mood, relieve stress, and improve cognitive.

Aside from health benefits, cooking is also a great way to explore other cultures. Trying new foods from different cultures can lead you to find new favorite dishes, but it can also lead you to a deeper appreciation of the culture and the people.

SKILL SET: Good at Excel VBA[MACROS], Advanced Excel, SQL SERVER

Advanced Excel:

§ Presenting the data by using:

§ Advance formatting features, Dynamic Charts, Slicers [filters], and Form Controls.

§ Summarizing the data by using Pivot, Slicers. Customizing the formula by using functions to create

Dynamic Ranges, Arithmetical Calculations, Lookup & Reference, Date & Time-Based Templates.

§ Proficient in Formulas and Features like Count If, Sum If, Sum Product, IF, Nested If, V-Lookup, H-Lookup, Match, Index-Match, Find, Search, Substitute, Replace, Choose, Rand between, Offset, Advanced Filtering and Sorting, Date and Time Functions, Pivot Tables, Power Pivot, Charts.

§ Developing dynamic pivot table and charts by using excel functions [Offset].

Macros - VBA Excel:

§ Developing Macros in VBA to automate the excel application with Excel VBA Techniques.

§ Developing Sub Procedures: Public & Private [Event Based: Excel Workbook, Work sheet].

§ Developing UDF: User Define Function [Custom Functions] and Excel Add ins to automate tasks.

§ Developing User Forms using Excel VBA. Debugging VBA code in VBE.

§ Segregation of stores sales into different sheets by customer wise and naming the sheets with customer name.

§ Consolidation of Work Sheets and Workbooks in a folder by using Excel-VBA [Macros].

§ Created Hyperlinks for sheets for different stores through VBA coding.

§ Automated Time Stamp Tracker with VBA coding for tracking the time for discrepancies.

§ Created User Form to update employee training course details.

§ VBA Code Developed for Pivot Tables and Charts.

SQL SERVER

§ Creating a Table and Drop Table, Use Case, Where Clause, Having & Group by clause, Order by.

§ DDL, DML, DRL Queries, Sub Queries, JOINS: Inner Join, Outer Join, Cross Joins, Self-Join, Constraints.

§ Writing Queries using Sub-queries, Joins, DDL, DML, and DRL.

§ Stored Procedures, Indexes, Views.

Power Bi Skill Set:

Technical Skills:

1.Good at preparing Reports / Hands on experience in working on Reporting.

2.Good at Power Bi Desktop:

excellent knowledge on connecting Power Bi Desktop to various data sources

like excel, Text/csv, web, Access, SQL- server.

3.Good at Power Query:

Get data + Cleaning Data

ETL: Extraction, Transformation and Load

4.Good at Power Pivot:

Data Modeling: Get Data + Creating Relationships between Tables

5.Good at Analytical Language:

DAX: Data Analysis Expressions

M-Functions: Mashup Functions

Wring Analytical Calculations

6.Good at Power View:

Representing data into visualizations,

Making different charts like Column, Bar, Pie, Donut, Line, Maps.

Proficient at Data Visualizations using Power Bi

7.Good at Power Bi Services:

Publishing reports to Power bi Services,

comment, sharing, subscription, Refresh, Schedule Refreshing the Reports.

Soft Skills:

8.Good at Communication:

Speaking, listening, Reading & Writing.

9.Can do Attitude.

10. Good at Presentation.