Vikas Vishwakarma Email and Phone Number

1. Developed a user friendly web application that streamline the process of inputting data and generating the necessary SQL script. The application was designed with a simple and intuitive user interface, making it easy-to-use. Once all the required fields are submitted, the web application redirects user to a confirmation page where they can review al the data they have entered before sql scripts being generated. The SQL file includes all of the necessary select, insert, delete command to complete the process, making it easy for user to process the data and execute the sql scripts.2. Developed Web Application using Flask to prepare query and execute it based on Excel file input. Once Task is completed generate an log file and sent to business user.3. Developed an python script to generate the SQL Query based on the user input.4. Provided dedicated support for the application, ensuring its smooth operation and addressing any issues promptly.5. Supported the implementation of new components developed by Application Development teams, from proposing solutions during design and development to performing code reviews, ensuring quality, and troubleshooting issues post-production deployment.6. Assisted business users, functional teams, and technical data consumer users by providing database information, training, and troubleshooting database-related issues for consumer applications.7. Creating and maintaining knowledge base for the team, including general system architecture, application production supporting document and good practice conventions.8. Managed general database support activities, including daily system health checks, batch process monitoring, and software maintenance in collaboration with IT Infrastructure resources.Technologies: Python, JSON, Html, CSS, JavaScript, .NET Core, C#, SQL Database, AWS, Selenium

1. Successfully delivered the solution of Lambda function which reduced the total database calls from 2.5 million to 50K+ for average 50K donations per day. 2. Successfully integrated MuleSoft API for Gift Card payment in existing .NET console application which helped the client to onboard alternate payment method for their donors (average 50K donors per day).3. Created a Dashboard to visualize all the dataflow and jobs for a leading athletic apparel brand. Also, automated the validation of data using python scripts and API calls and sending email containing consolidated report using selenium.4. Worked on integration of incoming webhook integration with teams, which acts as tool to track and notify the dataflow run. This script synchronously fetches record values using API call. These values are fetched and formatted as JSON payloads with a message in adaptive card format using an incoming webhook. This adaptive card format is automatically forwarded to specified team’s channel.5. Worked on python script which dynamically fetches historical records using API call. Once the data is available, the script exports it into an excel file and it is shared with business team.6. Developed UI dashboard to send the daily update over email which notifies status(processing, failed, success) with different color coding.Technologies: Python, Selenium, Airflow, Adobe Experience Platform, JSON, Html, CSS, JavaScript, .Net Core, C#, SQL, AWS