Vivek Tiwari

• Collaborated with teams to gather requirements and design user-friendly applications.
• Implemented code reviews and testing procedures to ensure software quality and reliability.
• Normalize databases and ensure relational integrity.
• Import, export, and manipulate data from various sources (Excel, SQL Server, CSV).
• Automate processes using VBA.
• Create complex functions, error handling, and custom logic.
• Develop custom reports for business analysis and decision-making.
• Developed complex databases using MS Access and SQL Server.
• Compiled reports from various sources such as MS Access, SQL Server, Oracle Database. using Visual Basic for Applications.
• Created complex SQL queries to access data from databases like Oracle, MS Access.
• Developed stored procedures, functions and triggers in MS SQL Server 2008, 2012, 2014 database environments as per project requirement.
• Created database objects such as tables, views, stored procedures in MS SQL Server.
• Conducted code reviews to ensure quality and maintainability of VBA applications.
• Conducted unit testing of developed components in order to ensure accuracy of results produced by the application.
• Created and maintained user forms, macros, functions and queries using VBA programming language.

• Automation of various reports related to Material Movements using SQL, MS access and VBA Macros.

• Creating and managing Access database and making complex queries to get the desired data from Database.

• SAP –Scripting for fetching data from SAP on regular basis.

• Automation of different SAP related tasks.

• Inventory Management in wareshouse/ store.

Providing different material tracking reports as required from DC/NHQ.

• Co-ordination with Jio points for any query related to the SAP and fiori Processes.

• Participating in regular discussions with DC related to different processes for material movement.

• Responsible for the handling ,storage and accuracy of inventories at Store.

• Co-ordination with Pan-India SCM Team regarding proper Material Dispatches and reversal.

• Logistics management for material movements.

• SAP- Analysing Reports and Monitoring Differsent KPI’s.

• Develop database schemas, tables and Views in SQL server.

• Designing databases and ensuring their stability, reliability, and performance.e.

• Experience in writing complex SQL Queries and Procedures.

• Experience in the migration of data from Excel, Flat file and XML to MS SQL Server by using conversions and DTS utility.

• Automation for various Process in SAP based reports using VBA

• Proficient in extracting, transforming and loading of data using SQL Server SSIS.

• Monitoring Circles for deployment and Material Reconciliation.

• Reporting the Management for Growth analysis.

• Responsible for any SAP related Query.

• Conducted comprehensive site surveys for small cell deployment across Karnataka, ensuring accurate assessment for installation.
• Coordinated with multiple teams statewide, facilitating effective communication and project alignment.
• Managed all billing operations, maintaining financial accuracy and timely processing for the company.
• Analyzed SAP reports to monitor project progress and resource allocation, enhancing operational efficiency.
• Executed service entries for site activities, including dump extraction, to ensure accurate record-keeping and data integrity.

• Conducted Single Cell Functionality Tests (SCFT) to ensure Quality Assurance, validating various Key Performance Indicators (KPIs) for optimal network performance.
• Utilized Atoll Tool for RF Planning, effectively contributing to site planning initiatives across multiple cities.
• Performed Walk Tests to assess and optimize WIFI network coverage and connectivity.
• Executed Cluster Drive Tests to evaluate and enhance RF signal strength and network reliability in targeted areas.