Designed SSIS Packages to extract data from various data sources such as Excel spreadsheet, and flat files into SQL Server for further Data Analysis and Reporting by using multiple transformations provided by SSIS, Scheduled, and maintained daily and weekly loads of data by creating the corresponding job tasks.Successfully, developed packages that have dynamic package configuration and Error eventhandling using On Error, SSIS Logging and has Failure email notification as well as storing SSIS error log into tables.Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.Use DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.In Power BI desktop create reports publish in Power BI Service and prepare the meaningful dashboards.

Prepared the Polling Booth Lists from Voter lists of Constituencies. Preparing Templets, Enter the data in those templates which came from fields.Cross check the details taken by the team members from field work.Enter the data of surveys in English & Telugu.Preparing Charts and Graphs for review, Creating dynamic reports with PivotTables.Advance knowledge of Excel using PivotTables, Power Pivot, and Power View.Created Excel reports, Dashboards & Performing Data validation activity VLOOKUP, HLOOKUP, Macros, formulas If, Sum, index match, Slicer with (Pivot table, Get Pivot Data, Dashboards), Power View, Power Map and Heat Map, KPI

Worked on complex calculus problems with simple formulas in Excel.Prepared the PPT Presentations for MRO to Present in CollectorateMonthly meeting Notes/ Minutes of meetings Computerized.Collecting Natural Calamities data from the Fields & crops damages etc.. and update in database and prepare Graphs and Presentations Prepare the Monthly Allotments Data and Graphs regarding to FP shop Dealers & Hawkers.Generating reports and certificates from citizen charts database.Data entry and maintain the citizen database.Computerized the Land Records and Adangal/ Pahani village wise and Mandal wise