SAURABH VERMA

Developed SQL queries and stored procedures to generate data reports. Dug into database details to ensure appropriate data filters , extraction and methods are applied based on business requirements. Performed SQL query performance tuning by creating/modifying indexes, setting transaction isolation levels, and changing query structures(used CASE to reduce table scans/seeks). Mostly involved in gathering business requirement and online system specification and building up a solution. Prepared and updated documentations ( Data Analysis, Data Mapping, Data Validation etc.) to ensure all procedures and knowledge are traceable in future cycles.

Strong skills in SQL development. An in-depth grasp of SQL reporting, analytics and business intelligence. Excellent understanding of database structures, principles, theories and practices. Great problem solving and analytical skills. Conversant with T-SQL coding. Diagnosing and resolving database access and checking on performance issues. Working on SQL queries using SQL Server. Responsible for creating calculated fields, combine field, bins, sets,geo codingand hierarchies using Tableau desktop. Designed, developed, tested, and maintained tableau functional reports based on user requirements. Created Tableau scorecards, dashboards, using stack bars, bar graphs, scatteredplots, geographical maps, Gantt charts, using show me functionality. Strong hands on experience implementing dash boarding, data visualizations, andanalytics using Tableau desktop and server.

Points of Sales- Collect and analyze data on customers' demographic, preferences, needs, buying habits to identify potential markets and factors affecting product demand. Point of Tracking- Setting clear strategies for commercial growth and increase return on investment as per the knowledge of having the most up-to-date retail sales data combined with an understanding of which products and services are performing well in the market and which are not. Identify, develop or evaluate marketing strategy, based on knowledge of establishment objectives, market characterstics, cost and markup factors. Use sales forecasting or strategic planning to ensure the sale and profitablity of products, product lines or services by analyzing business developments and monitoring market trends.

Forecast and track marketing and sales trends, analyzing collected data. Gather data on competitors analyze their prices, sales and method of marketing and distribution. Evaluate construction options to determine best cost-effective plan. Develop and implement quality control procedures. Identify all project risks and make a plan to handle each one.