Samir Agrawal

12+ years of hands-on experience focusing on Business Analysis, Design, Development, Testing and Deployment in IT Industry. 10+ years of experience in QuickBase including building applications, creating reports, workflows with email alerts and updates, summary reports, dashboards, assigning roles and responsibilities, and writing formulas. OCJP/SCJP (Oracle Certified Java Programmer) with detailed understanding of JAVA programs to help debug and improvise efficiency between team members.

Experienced Project Management

Professional with Certified QuickBase Expert Builder to improvise and develop an efficient Project Management and Tracking system. Experienced in discovering time critical steps in the Business Process and fixing them through automations like VBA scripting and macros. Adept in RDBMS such as Oracle, MS SQL Server and MS Access & also skilled at writing SQL queries and Stored Procedures.

Highly motivated team player with leadership, team management skills and professional ethics (Time Management, Work Management, People Management).

Experience in using the Microsoft tools like excel (VLOOKUP's, Pivot tables, charts, etc.) to present the data, status in effective and efficient manner.

Experience working closely with the Senior Management to deliver promising results to clients on time.

QuickBase Developer - Agrasen Technologies - Wardha, Maharashtra, India

(2019-08)

Agrasen Technologies provides IT Consulting Services. The project was undertaken to move all the data from Excel files and pdfs to QuickBase. It requires efficient Requirements Gathering, Business Analysis, Project Management, Issue Resolution, Testing and Tracking.

• Creating QuickBase Applications for various clients.
• Some of the applications include Supply chain management, Ticketing System, ERP, CRM, Issue tracking system and so on.
• Moving Data from Excel files and pdfs to QuickBase and organize the flow and format correctly.
• Gathering Client requirements and implementing them in QuickBase
• Weekly meeting with Clients to provide updates.
• Testing the systems to make sure the migration is done successfully.

Business Analysts/Software Developer - Universal Music Group (Subsidiary of Universal Studios) - Los Angeles, California, US

(2019-02 - 2019-07)

Universal Music Group works with artists, singers and other celebrities. It collects revenue and distributes Royalties to all the associated artists. The project was undertaken to move all the data from Oracle system to AWS. It requires efficient Business Analysis, Project Management, Issue Resolution, Testing and Tracking.

• Creating QuickBase Application for Project Management and Tracking.
• Creating Database schemas
• Moving Data from Oracle to AWS
• Testing the two systems to make sure the migration is done successfully.

Business Analysts/Analyst Programmer - GE Lighting - Cleveland, Ohio, US

(2016-08 - 2019-01)

GE Lighting provides lighting solutions that allows customers to save money on rebates and electricity bills by using energy efficient lights. This project was undertaken to make sure GE not only sells lights but also installs lights at all the approved customer locations. Selling the products and installing it is a complicated process.

It requires efficient Business Analysis, Project Management, Issue Resolution, Testing and Tracking to make sure we understand the existing environment, propose a possible solution, get it approved from the client, ship it to 1000s of different locations, install all the lights and take care of the damaged goods under warranty.

Business Analysts/Analyst Programmer - GE Lighting - Project 1: Sainsbury (Europe Project) - Cleveland, Ohio, US

(2016-08 - 2019-01)

A European project providing lighting installation data to Customers, Vendors and GE Employees. Dashboards are built using QuickBase and Smartsheet, an online Project Management application. These dashboards are presented to Client and GE Management to get the latest update on the Project. Dashboards are customized based on roles so that Customers and Vendors can see their respective metrics.

• Responsible for gathering requirements to ensure scope and feasibility of a project.
• Tracked Millions of dollars' worth of inventory by creating Inventory Management and Tracking Application in QuickBase.
• Analyzed all the scattered project documents in Excel files and other applications to create QuickBase Application for Project Management and Supply Chain Management.
• Migrated the Project from legacy systems to QuickBase and Smartsheet Application.
• Improvised Project Management and Tracking efficiency by 50%.
• Integrated online application QuickBase with Offline MS Access as a solution for vendors who must work in an environment with no internet access.
• Integrated QuickBase with Salesforce to fetch information and save time to repeatedly enter the same information.
• Worked efficiently using Agile methodology to include frequent change requests and testing.

Business Analysts/Analyst Programmer - GE Lighting - Project 2: JPMC Retail - Cleveland, Ohio, US

(2016-08 - 2019-01)

This Project installs lights in 1000s of locations across United States. Dashboards are built using QuickBase and Smartsheet, an online Project Management application. Dashboards are customized based on roles so that Customers and Vendors can see their respective metrics. Macros are built in VBA Script to automate the Business process and save months' worth of efforts.

• Responsible for Project Management and tracking using QuickBase and Smartsheet.
• Improved business process by coordinating between the Vendors and the development team.
• Snapcount application training, bug fixes, creating tickets, providing workarounds, requesting changes to improve the applications and testing the changes for quality assurance.
• Automated time critical business process by writing VBA scripting in Excel macros to save months of efforts.
• Created Business Requirement Document (BRD) and Functional Specifications Document (FSD) and mapped the data from these documents to create Use-Case Diagrams and UML Diagrams.
• Performed Test Planning, Test Preparation, Test Execution and Issue Resolution and Report Generation to assure that all aspects of the Project follow the Business Requirements.
• Developed Project Plans and Schedules and managed resolution of Project issues and conflicts.

Intern/Business Analyst/Web Developer - Orbital Socket - Charlotte, NC, US

(2015-10 - 2015-12)

Orbital Socket is a multi-dimensional highly skilled team of creative strategists equipped to leverage customer behaviour and cultural context in developing user centred connection points to identify new meaning to products, services, experiences and thus companies.

• Performed Business Analysis activities.
• Collected requirements from clients and team to upgrade websites.
• Performance tuning of commercial websites.
• Improvised SEO (Search Engine Optimization) for multiple client website by using WordPress, tools and plugins.

Intern/Business Analyst/Software Developer - Ventureprise Inc - Charlotte, NC, US

(2015-06 - 2015-08)

Ventureprise is UNC Charlotte's innovation and entrepreneurship center serving the campus and Charlotte region as a center of excellence for evidence-based entrepreneurship. We designed their website and helped students understand and utilize the opportunities provided by Venturprise for their startup business.

• Effectively communicated business goals between entrepreneurs and Ventureprise.
• Designed a professional website using WordPress and SQL.
• Created a BRD (Business Requirement Document) and FRD (Functional Requirement Document) for a commercial Website.
• Performed Test Planning, Test Preparation, Test Execution

Business Analysts/Software Engineering Analysts - Accenture Services Pvt. Ltd - Pune, India

(2012-02 - 2014-12)

Accenture is a global management consulting and professional services firm that provides strategy, consulting, digital, technology and operations services. Worked on multiple projects in Accenture.

Business Analysts/Software Engineering Analysts - Accenture Services Pvt. Ltd - Project 1: PA-DOR (Pennsylvania Department of Revenue) - Pune, India

(2012-02 - 2014-12)

This is a banking project which we migrated from legacy system to SAP system. We discussed requirements with the clients and created Business Requirement Document (BRD) and Functional Requirement Document (FRD). Worked closely with designing team and development team to get the migration done successfully and efficiently.

• Excellent knowledge of Software Development Life Cycle (SDLC)
• Understanding of SAP ABAP and SAP Workflow to work with design team and development team.
• Automated the orders placed to Vendors when the stock is running low using SAP ERP system.
• Improved overall user experience up to 30%.
• Mastered the tools QuickBase, HPQC and ITSM for Project Management, quality assurance and testing.
• End to end implementation of SDLC (Software Development Life Cycle).
• SAP Workflow Consultant with practical knowledge of setting up system for workflow.
• Successfully learned and implemented SAP NetWeaver, WebDynpro, ERP, Business Intelligence, SAP Portal, SAP R/3, IDoc, Smart forms, BAPI, Enhancement, BDC, BRF+.
• Assist QA personnel in creation of Test cases to identify any defects in the new developed systems.
• Member of Change Request team which handles changes or new development from workflow point of view.
• Ticket resolution for the SAP MM, FI and HR related areas and answering how-to questions.

Business Analysts/Software Engineering Analysts - Accenture Services Pvt. Ltd - Project 2: AMO- BHP Billiton - Pune, India

(2012-02 - 2014-12)

The project we worked on was a manufacturing company dealing with 100s of vendors, PRs, POs, Cost Centre allocation and automatically processing all the information with user interactions for approvals. We designed Business Workflows to make sure every step is followed, and it is independent.

• SAP Workflow Consultant with practical knowledge of setting up system for workflow.
• Actively trained business users involved in User Acceptance Testing (UAT) and helped them understand UAT Procedure.
• Member of Change Request team which handles changes or new development from workflow point of view.
• Ticket resolution for the SAP MM, FI and HR related areas and answering how-to questions.
• Business Analysis for detailed problem solving and determination of issues.
• Providing support after the successful deployment of the project.
• JAVA implementation for automation tool used in Testing.
• Tool simplified the testing and reduced the manual work up to 70%.

Intern/Business Analyst - Lloyds Steels Industries Ltd - India

(2010-06 - 2010-08)

Lloyds Steel is a manufacturing company which gave us exposure to product life cycle. We used SAP ERP system to manage their raw materials, venders and inventory.

• Trained in different modules SAP ERP system.
• Worked with the team to improve communication between design and development team with the management goals by conducting weekly meetings.
• Prepared design and development related documents to keep the teams on track.
• Performed UAT and performance tuning to ensure the systems are efficient.

Master of Computer Science - Computer Science - University of North Carolina at Charlotte

Bachelors - information technology - Rashtrasant Tukdoji Maharaj Nagpur University