Badges
Certifications
amittewari243 has not earned any certificates yet.
Work Experience
Intern
NYC DOITT• May 2019 - April 2020
• Extracted 100 K + IT Services data from MS SQL Server, SharePoint, Excel writing SQL queries such (joins, aggregation, merge, subquery) • Performed data cleaning, data validation, data duplication using Python(Pandas), Excel(Pivot Tables, VLOOKUP) Inconsistent and missing data was rectified & integrated back in the SQL server following ETL processes through SSIS • Created & Analyzed ad-hoc reports, performance reports, dashboards, visualization in Power BI & MS Excel which reduced the data anomalies & increased the product performance by 45%. • Spearheaded the analysis of reporting data using Power BI for NYC IT services application, also tracked various KPI’s that boosted initial response time by 40% & reduced the total number of issue logging tickets by 20%. • Built ETL process to migrate data from multiple sources to destination database using SSIS packages. • Worked with various business stakeholders, Business Analyst, cross-functional teams acting as a Bridge to identify business needs & discuss solution options. • Provided database support , process logging, mapping tools using SQL and SQL Server • Extensively used Excel Pivot tables, VLOOKUP’s to identify errors and clean row level records thereby removing inconsistencies in the data & provided recommendation to senior management to optimize business data processes • Designed new interactive dashboards & reports using Power BI to visualize performance analytics for service management request for govt agency data. • Created calculated measures, data filters, slicers, drill up & drill down reports, Aggregated reports using MS Excel .For easy access reports was uploaded on AWS S3 bucket
Software Engineer
BMC Software• September 2016 - August 2018
•Designed statistical reports, charts, dashboards using MS Excel, Python (Pandas) for BMC remedy Truesight showing performance metrics & time series analysis. Assisted in management of dashboards across the business enterprise •Developed and established Key Performance Indicators(KPI’s) using Excel, Power BI to monitor analysis & provide strategic insights to drive performance within machine and sensor data analytics •Used ETL SSIS to develop jobs for extracting, cleaning, transforming & loading data from source to target tables •Increased efficiency by 70% by transferring 500 + reports from My SQL database into SQL Server Reporting Services (SSIS) •Researched, analyzed, troubleshooted issues in database applications writing adhoc , parametrized queries using SQL •Utilized the Power Query in Power BI to pivot and unpivot the data model for data cleansing & data massaging •Analyzed data extracted from different sources figuring out data logging issues using Python, Pivot Tables in Excel •Designed test cases for A/B testing thereby analyzing results & providing decisions on future business strategies •Educated business teams by preparing training plan involving product features, issue resolution thus reducing ramp up time of employees by 4 weeks ,also streamlined & improved workflow systems by implementing changes using Agile
Education
Pace University
Computer Information Systems, MS• September 2018 - May 2020
University of Pune
Computer Science, BE• September 2012 - May 2016