kshama

Around 14 Years of experience in development and Production support of (Reporting Services,Web development Asp.net 2.0,3.5 & SQL server 2005,2008) , (Microsoft BI Tools SSIS, SSRS, SQL Server -6 Yrs.) and (Tableau /Power BI - 5 Yrs. Exp.)

client interaction for requirement gathering & Change Request execution.  Team Management: Tickets handling, resource management, VSS handling  Requirement Gathering and estimation/Handling Service Now portal for Ticketing tool  Documentation: Creating MOM, UAT, FAT, functional documents, Technical documents designing  Server Activity support: Database backup /restore activity.  SQL /Widow job Creation /Monitoring/ Deployment of Websites  Asp.net 2.0 & asp.net 3.5/4.0 (Supporting 2 Portal sites of (ACC Cement & Ambuja Cement)  Excellent skills in High Level Design and implementing ETL packages using SSIS 2008/2012 for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text file) by using multiple transformations available in SSIS toolbox.  Hands on Expertise in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous Systems using SQL Server tools like SSIS, Bulk Insert.  Experience in providing Logging, Error handling by using Event Handler, Custom Logging for SSIS Packages and configurations for SSIS Packages.  Worked on various data models like Star schema and Snowflake schema.  Experience working on creation of various Reports using SQL Server Reporting Services (SSRS).  Created Tabular, Matrix reports with and without parameters using SSRS.  Experience on Power BI reports & dashboard using various sources  Used Table , Matrix , Bar, Card , Gauge , Slicers visualizations and also Custom Visualizations like multi slicer and Hierarchy slicer in Power BI.  Experience in Tableau reports and dashboard creation using various sources  Good knowledge and understanding of DAX Functions in Power BI like filters, Aggregate, and Mathematical Functions.Created New Calculated Column and Measure using DAX Expression.  Experience in creating SQL Server Queries, Joins, Sub queries, Stored Procedures and Jobs in SQL Server also having experience in Query Optimization & Performance Tuning.  Experience in Data Schema Design, and Table Design.  Designed technical documents from business requirements to develop the Source Code.  Self-motivated and possess ability for critical thinking, ready to accept new challenges and adapt quickly to new technologies and good communication skills

EDUCATION:  B.Tech in Information Technology from DBATU ,Lonere,Maharashtra 2005.  Diploma in Computer Engineering from Institute of Petrochemical Engineering,Lonere 2002 EXPERIENCE: Kshama Khopatkar_TeamLead_PowerBI_Tableau MSBI_SQL_Server_.net  Working as a Technical Analysts with Coforege Technology Ltd.( Formerly known as NIIT Technologies Ltd), Mumbai From Jan 2017 to Till Date.  Worked as a Senior Software Developer with NIIT Technologies Pvt. Ltd, Mumbai From Jun 2015 to Jan 2017.  Worked as a Software Developer with NIIT Technologies Pvt. Ltd, Mumbai From Dec 2013 to Jun 2015.  Worked as a Lecturer in DBATU ,Lonere from 2006 to 2007

Thank you....

Tableau Activities:  HR –Activity dashboard for Feedback analysis  Using Tableau, developed visualization dashboard and reports  Developed KPI's for dashboards and monitoring reports  For reports, developed Data Visualization Presentation Projects of Tableau  IPL Analysis  Covid analysis  Product Analysis  Agriculture Data Analysis

Power BI Activities:  HR –Activity dashboard for Feedback analysis  Using PowerBI, developed visualization dashboard and reports  Developed KPI's for dashboards and monitoring reports  For reports, developed Data Visualization Presentatio

Roles & Responsibilities: Overall supp&