Business Intelligence Power Bi
Resume:
VARUN KAPILA
Netsuite WMS Administrator
San Diego, California, United States
*************@*****.***
WORK EXPERIENCE
September 2024-Current
Netsuite WMS Administrator
AMC Technology
* Netsuite WMS, Administrator
* Responsible for Warehouse Database maintenance and management
* Inventory Database management
* Manufacturing, Advanced Manufacturing, Financials, Demand Planning
* Created new Sales Orders and Purchase orders while modifying existing Sos and Pos.
* Managed inventory database in conjunction with handling various Warehouse manufacturing and shipping processes.
* Implemented Netsuite workflows for regulating inventory sales and quantity data processes. August 2023-September 2024
Salesforce Administrator
Saasguru.com
*Experienced in designing, building and customizing new objects, fields and field/object hierarchy creation.
*Experienced in designing customized salesforce lightning apps, customized dashboard and advanced layout tailored uniquely to user specific experience.
*Designed a customized lightning Insurance policy app based on specific client needs providing client specific tailored coverage.
*Experienced Data Field Mapping.
*Experienced in external .csv files Data Mapping with specific objects.
*Experienced in customizing, creating and modifying workflows.
*Building automation to automate business use cases based on user preferences.
*Experienced in creating automated workflows for capturing business lead information through interactive UI for qualification of record creation.
June 2022-August 2023
Business Intelligence Analyst
Reality Homes
*Created comparative data analysis utilizing external and internal data sources and utilizing Ms Dynamics369, MS SQL and Csv files.
Remote
Los Angeles, CA
San Diego,CA
*Observed and maintained sales database through inventory management tools such as salesforce and microsoft power BI.
*Recognized quarterly revenue trends through data fusion and data importing via SQL servers.
*Determined and initiated process improvements that increase sales by 30 % over a quarter.
*Implemented business intelligence solutions and advanced analytics techniques to identify opportunities to meet and exceed business goals.
*Presented and communicated actionable insights tailored to specific audience and client needs
*Created Data visualizations, that educated and informed management, and senior partners on key metrics and performance measures utilizing Business Intelligence tools.
*Gathered, and cleaned data, 10+ Power BI reports while utilizing excel, Tableau and SQL. June 2021-March 2022
Netsuite Support Consultant
NextTechnik
*Experienced in order to cash
*Experienced in inventory management to improve efficiency.
*Experienced in creating Power BI reports for data analysis
*Experienced in creating performance tracking through Power BI
*Experienced in data interaction through Power BI
*Tracked company profits through generating KPI reports
*Tasked with in Suite Scripting
*Created modifications using .config & .Json
*Responsible for the creation and maintenance of Netsuite customized dashboards
*Conducted NextService client calls, gathering requirements and implementation.
*Perform UAT (User Testing) for multiple internal projects January 2021-June 2021
Automated Retail Technologies
*Performing Chip-set testing integrated with Machine language
*Experienced in creating and Netsuite Fields, Records, Sub records and Entity hierarchy implementation & deployment
*Created and modified Netsuite customized dashboards
*Employing Zoho toolkit for custom forms & fields creation
*Experienced in minor Suite Scripting
March 2020-May 2020
Sales Technology Administrator contract
AbacusNext
*Performed NetSuite Customization, and scripting
Denver, CO
Carlsbad, CA
Miramar, CA
Netsuite Administrator IT Technical Support Operations
*Executed Data Conversions during multiple testing phases
*Oversaw System Test Case Preparation and System Testing with Functional Consultant
*Resolved Trouble Reports during User Acceptance Testing
*Tracked, Monitored & resolved bugs/issues identified during SIT and UAT
*Provided operational support to the growing Abacus sales.
*Processed new Sales Orders.
February 2017-October 2018
Web Development Intern
Victorize
*Hired on to help test and analyze data gathered from software geared toward extreme motorbike sport equipment through a phone application
*Analyzed sample size data who was gathered by software developer and inputted into the program
*Tested the program to see if data was analyzed correctly and if the graphs and charts were processed correctly
*Assisted in troubleshooting the software when bugs or glitches were found then reported to the developer
*Assisted in the design of the interface and dashboard of app
*Offered advice on how the software could be approved March 2015-August 2015
Business Analyst
Stratacare
*Participated in project review meetings and gathering Business Requirement Documents (BRD)
*Used agile methodology throughout SDLC, including planning and cost estimation through
*requirements, translating into data design and providing oversight in development and execution
*Conducted JAD Sessions with the subject-matter experts, stakeholders and other management teams in the finalization of the User Requirement Documentation
*Created as-is data flow, work flow and to-be data flow charts while also conducting walkthrough sessions for the diagrams to make sure that the business was all educated on the topics EDUCATION
-2017
Certification
LEARN Academy
United States
LEARN Academy
HTML 5, Ruby/Rails, Javascript, CSS, SQL, Jquery, AngularJS, NodeJS 2017 Mobile Application and Design, Certification
Carlsbad, CA
Irvine, CA
-2010
San Francisco State
United States
San Francisco State University 2010
• Mathematics
SKILLS
NetSuite Sales Manufacturing Database Administration Demand Forecasting/Planning Purchase Orders Warehousing Reporting Dashboards Salesforce.com Home Automation Data Mapping Insurance Use Cases Data Analysis Inventory Management Power BI Business Intelligence Business Intelligence Software Data Fusion Data Visualization Metrics Microsoft Product Family Microsoft SQL Server Process Improvement SQL (Structured Query Language) Tableau Scripting (Scripting Languages) Acceptance Testing JSON Order to Cash Testing Technical Support Operational Support System Test Test Case Identify Issues Web Programming AngularJS CSS (Cascading Style Sheet) HTML5 JavaScript jQuery Mobile Applications Node.js Ruby Agile Programming Methodologies Cost Estimates Software Development Lifecycle (SDLC) Arts Mathematics Electrical Engineering Customer Relationship Management (CRM) Data Migration ERP (Enterprise Resource Planning) Python Programming/Scripting Language Retail Shipping/Receiving Financial Planning Manufacturing/Industrial Processes Data Warehousing Field Mapping Data Formats Business Case User Interface/Experience (UI/UX) Analysis Skills Revenue Growth Financial Trend Analysis Microsoft Dynamics Exceeded Sales Goal Comparative Analysis Business Solutions Revenue Recognition Performance Metrics Data Collection Data Cleaning Consulting Reporting Skills Multitasking Customer/Client Research Performance Analysis Information Systems/Technology IS/IT Administration Technical Operations Contract Management Sales Administration Technology Sales Order Processing Problem Solving Skills Bug Tracking/Defect Management Functional Testing Software Development Specimen Analysis Software Administration Bug Tracking Software Business Analysis Java Decompiler (JAD) User Documentation Requirements Management Software Design NetSuite CRM Administrative Skills NetSuite ERP
CERTIFICATIONS
Mobile Application and Design, Certification
WMS
LANGUAGES
English - Fluent
Contact this candidate