amrendra verma

Data Analyst

Wipro Technologies•  July 2018 - Present

 Provided reporting, analysis, and insights about KPI’s of crowdsourcing data to support corporate analytics using Python, Power BI, SQL.  Collaborated with clients and company officials to identify data analysis needs, develop and implement data collection procedures and create meaningful data visualizations illuminating key performance indicators.  Developing & enhancing existing Power BI dashboards.  Maintained existing SQL code base and develop new code including complex SQL queries, stored procedures, etc.  Extensively used advanced chart visualizations in Power BI like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, funnel charts, etc., to assist business users in solving complex problems.  Handling multiple reports, working with formulae, pivot table & pivot charts, and various other excel sheet components for crisp and accurate data.  Excellent in MS Excel (Hlookup, Vlookup, lookup, Index, Offset Pivot Table & PivotTable Chart, etc).  Coordination with teams and solving their problems  Generating reports from Database in MS Excel and presenting them in required format.  Imported, exported and manipulated large data sets in multi-million-row databases using SQL queries.  Designed databases, stored procedures, reports, and data input interfaces using MY SQL.  Involved in various data transformation and cleaning techniques like cast, convert, trim etc in SQL.  Utilized data visualization tools effectively to communicate business insights.