VBA Developer
Resume:
Swadeep Vendoti Email : *****.*******@*****.***
Phone : +1-312-***-****
PROFILE SUMMARY:
• Total experience of 7 years and 10 months in Microsoft Technologies.
• 3 years of experience in VBA, Excel Stability, MS Access, SQL, Acrobat adobe. Experience Includes Automation Web Scraping, PDF to Excel Conversion, Chart generation, Mail generation, Scraping historical Data from ill formatted PDFs and Excel etc. of over 120 Spread sheets using Excel VBA and MS Access.
• 1 year experience in R, Shiny dash board. Developed 3 big applications in no time (handles the back end data retrieval and business logic and designed all the functions). Shiny Dash board is used as UI.
• 5 years of experience in .Net Web applications- C#, ADO, ASP.Net, SQL, MVC Frame Work, web services, XML parsing (in both C# and SQL procedures), Java Script, J Query, IIS, TFS. WORK HISTORY:
Employer : INFOSYS LIMITED
Duration : JUNE 2008 - PRESENT
Current Role : TECHNOLOGY LEAD – US
Previous Roles : Software Engineer, Systems Engineer, Senior Systems Engineer and Technology Analyst TECHNICAL SKILLS:
• Microsoft Excel VBA Version 2007 and 2010.
• R Version 3.1.3. R studio Version 0.99.484, Shiny Dash board.
• .Net Frame Work 2.0/3.5/4.0. Visual Studio 2005/2008/2010/2013.
• SQL server 2005/2008 and MSSQL Reporting Service.
• C#, ASP.Net, HTML, Java script, jQuery.
• Web services, Windows Services XML Parsing (C#, SQL, VBA).
• Requirement Gathering, estimates and analysis.
• Requirement and Design Documentation. UAT, unit Test plans and Configuration management documentation.
• Configuration Management – worked on TFS, VSS, and GIT.
• Maintenance, Deployment, Bug Fixes and Application Support. Awards& Certifications:
• Won Most Valuable Team Player award 4 times in 8 years.
• Won on the spot award thrice for my contribution in fixing the issues in production.
• 10’s of Client appreciation for the work I have automation work. EDUCATION:
• BACHELOR OF TECHNOLOGY in Electronics and Communications from Jawaharlal Nehru Technological University, Hyderabad – Year of Passing 2008.
Visa Details:
Visa Type : H1-B
Valid Till : 14-Dec-2017
Swadeep Vendoti Email : *****.*******@*****.***
Phone : +1-312-***-****
Projects
1. Client : BP Oil Limited
Employer : Infosys Limited
Project : Excel VBA Applications
Role : Worked on over 120 Spreadsheets- Includes Automation, Web Scraping, PDF to Excel Conversion, Chart generation, Mail generation, Scraping historical Data from ill formatted PDFs and Excel etc. Software : Excel VBA, MS Access, Adobe Acrobat Reader, SQL Server 2008 Duration : Sep 2013 – Present
Description of the major Projects:
Rig Count Tool: Created a Tool to show the changes of the rig Counts in USA (On USA Map as well as State Map with Counties in Excel) over the period of time and User can look at the Change of the Rig counts w.r.t any week or Quarter or month or year.
The actual or Difference in Rig Count will be displayed on the USA map in Excel and on Click of each state it will take you to the enlarged State map with all the counties in the state. The rig Count will be displayed at County Level and State Level. The input Data is scrapped from the website by downloading a csv and processing the data and storing it into the Tool. This tool has ability to generate a PDF with all the maps in it with different combination of dates and sends the PDF an email attachment to different users. Gain Loss Report: Created an Excel tool to capture the Gain Loss report of all the operators from different terminals. User will have the master sheet and a macro will create a gain loss report for every month and will send across to all the operators who will fill the gain Loss and Comments and will send back to the user. Then user will upload the file from operator using a macro to upload all his comments and the gain loss details. Generate Reports, charts based on user defined parameters. It has saved at least 30-40 hours of effort per month across all the terminals. Ship Tracker Optimization and Automation: The Spreadsheet was around 90 MB and I brought it back to 10MB with Huge data still in it. Removed the duplicate and redundant data across the 12 tabs (Previously Macro used to copy the same set of data into 12 different tabs and then apply different filters on different tabs. Now I have made changed the macro such a way that apply filters in master data and copy only required data to the Tab). Move the old, monthly charts and data to a new file. (Automated this for future use: to save the monthly charts to a new file).Removed dead tabs. Developed a macro to remove all the formulae and in sheet calculations. Rail Operations: Developed a new application to automate the Rail Data. Data needs to be scrapped the rail Data from Website as well as users mailbox. Developed a macro to generate Orion data and email the report. Developed a macro to generate CPBR Report data and email the report. Update volumes based on the cars and volumes. Import the detached car list, Fleet, Buffer list. Match the computed data with OWB data and fix the anomalies in the data with user defined rule set. This saves at least couple of hours a day. Pipe Line Tariff Tool: Created an application to show all the routes between source and destination. User will have list of all the tariffs between different locations for different type of material and additional Charges like Tankage etc. First challenge was to create all the possible mapping between all the locations possible between different pipelines up to 6 levels. A user form has been developed for user to choose the origin, destination and type of grade. Then Macro will display all the possible routes and the combined tariff for the type of crude. User has been given option to add additional charges, Tankage cost etc. This application has saved lots of money and time. TARDIS Data Upload automation: There is an excel Add-in and a database to track the forecast of all the products at different levels and different regions. Managements have mandated all the analysts to upload data into TARDIS database on daily or weekly basis. I came up with an idea to automate the process. Developed a macro to call the functions of the excel add-in once the data is in the required format. I implemented the same in over 200 Swadeep Vendoti Email : *****.*******@*****.***
Phone : +1-312-***-****
spreadsheets. Each spread sheet had its own data layout and data spread across multiple work sheets and work books. Because of my effort all the forecast are in one application and can be accessed across the globe. Other Applications: I worked on wide range of application and requirements. When I joined BP most of the users are performing manual operations on the spreadsheets. I automated as many excel sheets as I can. Few of the requirements are Automation comparing few excel sheets and copying data from one sheet to other, Web Scraping – from different websites and historical PDF, Excel files and text files, PDF to Excel Conversion using Acrobat Adobe reader, Chart generation, Mail generation – mail body with charts, table, text, Images, HTML, Adding charts, spreadsheet as attachments in the mail, Spreadsheet stability analysis – Reducing the size of the spreadsheets, making the spreadsheets stable and reliable.
Responsibilities:
Understanding the existing process and business around it and designing a new excel application.
Requirement gathering, Analysis and Designing the application.
Estimating the Requirements.
Sole developer for all the above applications.
Testing and Bug fix.
Maintaining the spreadsheets.
2. Client : BP Oil Limited
Employer : Infosys Limited
Project : Application developed in R
Role : Completely developed the app from the scratch. Software : R, R Studio, SQL Server 2008.
Duration : Aug 2015 – Present.
Description of the major Projects:
Refinery DB Tool: Refinery DB Tool in R is designed to reduce the manual effort and manual errors while displaying the Turn outs. The original Process is an user from each Bench (There are 6 benches in one location and there are around 4 locations across the globe.) downloads data from SQL data base on to Excel and run a macro (will take 20 minutes) and print 20- 40 copies of which contains 10-12 papers each and distribute to every analyst in the bench and this will be done once in a week. I designed a tool to get Data from Refinery DB every hour and do all the calculation, aggregation and replicate the Excel output. I extended the application to all new level. User can select the Type of Crude and all the sub regions he is interested then it gives the turnaround data and colour the value based on type of turn around type. User can also see the difference between 2 days of forecast. User can also aggregate the values on week, quarter and yearly Data. Implemented a function to display the chart at refinery level as well as refinery and Type of Plant .Now we have over 100 users of the application in just over a month. With great response from the users in USA and Canada, we are working on making this tool global. Ship Tracking Tool: There is a data base which tracks all the Ship movement, content, quantity, start and ends Date, type of crude, load and discharge location. There is a small Excel add-in which generates couple of reports based on the data. I came up with an Idea to create a sophisticated tool with every possible scenario and functionality. Then I learnt R and Shiny Dash board (got the template from internet). I designed an application to generate charts at different levels like all the Exports from USA, all the imports to Canada. User can add filters at Product, Charterer, Discharge location (Region Group, Region, Country, and Port), Load location (Region Group, Region, Country, Port). Data can be aggregated with different combination like Charterer, Grade, Product, Discharge and load locations. User can also calculate Net flows at Country, Region, Region Group and Port Level. Data would be pulled from ship tracking DB every hour. Pricing Dash Board: PROS database stores the retail prices for all the benchmarks (like Shell, Marathon, and Mobil) at different locations, brands, products. There was no tool to check the price comparison between Swadeep Vendoti Email : *****.*******@*****.***
Phone : +1-312-***-****
different benchmarks. We extracted data from PROS Data base and designed an application to see the price variations between benchmarks, locations, brands.
User can plot a chart between BP vs multiple Benchmarks at a location or BP vs benchmark at different locations. This gave user ability to price the brands at a very competitive end compared to the competitors and helped company save more than a million USD in first month. Responsibilities:
Understanding the existing process and business around it and designing a new tool.
Requirement gathering, Analysis and Designing the application.
Estimating the requirements.
Script to download the Data from the data base every hour or once a day.
Except for the Pricing Dah board application. I am the only developer.
Testing and Bug fix.
Configuration management using GIT.
Deploying the applications on to the server.
Maintaining the application.
3. Client : BP Oil Limited
Employer : Infosys Limited
Project : GPCW (Global Pricing Curve Website)
Role : Developed couple of key functionalities.
Software : .Net 3.5, SQL, MVC frames work, Web services. Duration : Mar 2014 – Dec 2014.
Project Description:
GPCW application was designed as a charting tool for plotting price curve data for IST Global Oil. The site holds BP proprietary data as well as key market quotes from data providers. When I took as a sole developer and point of contact there are predefined charts like Spreads, Cracks, cash, swaps, Fly markers. For ex : if user selects a Time Spread user will be given option to choose one product and 2 contract months which I turn generates the Chart over the year. But the functionality was very limited. If User has to create a complex Time spread between 2 or more products it was not possible. I designed an advanced filter option which allows user to create different options and also user can choose the operator between the previous and this contract. I have created a complex dynamic query for getting the advanced query option. Also gave an option to user to save all the queries as favourites. So that user does not have to create them every time he logs in to the system.
Developed Reporting functionality where user can save all the reports he would like to see the next day with option like Years of data to be included at both chart and report level, frequency of report generation like daily, Weekly. Once user save the charts required in the report. A windows service runs every day at 2AM in the morning and sends a PDF with all the charts in the report as an email. Responsibilities:
Requirement gathering, Analysis and Designing the application.
Estimating the requirements.
Developing new functionalities which are robust and stable.
Developing and maintaining complex dynamic SQL queries.
Testing and Bug fix.
Configuration management using TFS.
Deploying the applications on to the server (Helping Configuration management team with the process and procedure as we do not have permissions for PROD and UAT deployment).
Maintaining the application.
Swadeep Vendoti Email : *****.*******@*****.***
Phone : +1-312-***-****
4. Client : Schlumberger
Employer : Infosys Limited
Project : RITE (Regular Inspection of Tools and Equipment) Role : Developed couple of key functionalities.
Software : .Net 2.0/3.5, remote scripting, Java script, C#, HTML, ASP.Net, SQL, Web services. Duration : Jun 2008 – Aug 2013.
Project Description:
RITE is a system developed to support the maintenance methodology. The focus of the application is to provide a means to keep track the location and station of testing and measuring equipment across the client’s network. RITE is primarily a maintenance scheduling system for field technical equipment and vehicles including recording and analysis of Jobs performed, scheduling of maintenance, engineering modifications, recording and analysis of equipment failure, recording and reporting on asset history. The benefit of using this system is reduced server infrastructure at locations and reduced support cost. RITE is designed to use minimum network bandwidth for connectivity from the locations to the data centre. RITE had a great value add on to the client in terms of data and workflow integration, operational efficiency, understanding and usage, robustness and quality control.
I was part of 16 big releases as a team member and lead. I have developed the ALS release alone. When I joined RITE team the data from the application is processed as an XML and then sent to the stored procedure. It takes time to create an XML and parse it in procedure and every operation was XML. Then I came with option to replace XML with a data table. It saved a lot of time and we were able to change the complex stored procedures which first parse the XML and insert or modify the table to just couple of lines of code. Created complex stored procedure which runs once a day and check all the assets for due for different maintains event scheduled and if one or more events are due the priority of the events. If the asset is due for maintenance a service request is created which in turn creates a work order. If the maintenance cannot be completed on site the asset has to be moved to a facility which is a new movement form in the application. Responsibilities:
Requirement gathering, Analysis and Designing the application.
Requirement and design documentation.
Estimating the requirements.
Training new team members with unique Remote scripting and architecture used in the application.
Developing new functionalities.
Developing and maintaining complex dynamic SQL queries.
Testing and Bug fix.
UAT and Unit test plans creation.
Configuration management using IIS and TFS.
Deploying the applications on to the server (Helping Configuration management team with the process and procedure as we do not have permissions for PROD and UAT deployment).
Maintaining the application.
Contact this candidate