Pavani K Email & Phone Number

Bengaluru, Karnataka, India

Project Description:American Insurance Group, Inc. - also known as AIG - is an American multinational insurance corporation with more than 88 million customers in 130 countries. AIG companies employ over 64, 000 people in 90 countries. The company operates through three businesses: AIG Property Casualty, AIG Life and Retirement and United Guaranty Corporation (UGC).Roles and Responsibilities:● Creating and implementing the source code of new applications ● Gather requirements from client and guide the team on development standards● Develop technical documents and deployment guides to accurately represent application design and code● Create the Row Level Security in Power BI. ● Interacting with Client to get requirements.● Create the Calculated columns and measures with the use of DAX Expressions. ● Involved in creating data visualizations like Clustered Column Chart, Donut Chart, Line Chart, Slicer, Gauge Visualization etc. with Power BI. ● Involved in developing reports and dashboards in Power BI. ● Designing the modeling in Power BI.● Designed and developing SSIS packages using different transformations like Conditional Split, Multicast, Union-All, Merge, Merge Join and Derived Column● Created systems for capturing error data in flat file using flat file destination, sending the error data in flat file attached to the corresponding mail ids using Sent Mail Task, and correcting error data● Responsible for creating appropriate loaders and relational writes to load the Data from SSIS. ● Involved in effectively used data blending, filters, actions feature in Power BI. ● Embedding Power BI reports to web pages. ● Experience in creating dashboards using Power BI visualizations.● Worked on Custom Visualizations like Sunburst charts, scroller etc● Having good experience in Power query, Power pivot and Power view f or creating theeffective reports and dashboards in Power BI.

Bengaluru, Karnataka, India

Project Description:Xylem is a leading water technology company committed to "solving water" by creating innovative and smart technology solutions to meet the world's water, wastewater and energy needs. In a world of ever-growing challenges, Xylem delivers innovative water technology solutions throughout the cycle of water.We have developed a system fully automate the data warehouse building process. Data is extracted from various sources from all branches. This transformed data is loaded into a single database, which is maintained as a Data warehouse for the whole company. The main objective of this project is to help the senior and middle level management of the organization to improve the sales through data Analysis and steps to be taken improve their business. Roles and Responsibilities:● Accessed and used various Custom Visuals available in Power BI● Involved in creating data visualizations like Bar charts, Tree Maps, Line charts, Scatter plot, Mapping Visualization etc. with Power BI ● Involved in preparing and cleansing of the data.● Create the Calculated columns and measures with the use of DAX Expressions. ● Interacting with Client to get requirements.● Build and automated the Power BI reports for the client through which business were able to reduce 20-man hours of data cleansing and creating report in excel every month.● Accessed various data sources to pull data for reporting and analysis● Involved in creating power BI reports in Direct Query Mode.● Sharing of Power BI reports and managing workspaces in Power BI service.● Involved in accessing different sources like DB2, Oracle and SQL.● Creating of packages in SSIS to load data from OLTP to Staging, DWH Tables.● Used Control flow tasks like For Loop Container, For Each Loop container, Sequential container, Execute SQL task, FTP Task and dataflow Tasks in Designing packages.

Bengaluru, Karnataka, India

Project Desc:● Nespresso sell coffee: capsule, machine and Accessories in 54 countries.● The objective of this project is to develop and maintain website for Nespresso B2C and B2B Customers.Roles and responsibilities:● Monitor the sales and infrastructure performance● Content management using Magento● Configure grafana and newrelic dashboards● Write php scripts and sql queries to fetch reports● MySQL database is used in this project● Schedule cronjobs