Alteryx, Xceptor (RPA), VBA macros, Automation, Data Analyst

KUNDAN SINGH

+91-750******* ***********@*****.***

+91 7977114034mailto:********@*******.***

A-503, Shiv Sadan Society, Kamla Nagar, Chincholi Bunder, Malad-W, Mumbai-64.

DATE OF BIRTH: 5TH January 1991

PASSPORT DETAILS: Number: - R9244732

Place of issue: - Mumbai

Valid up to: - Jan 29, 2028

CAREER OBJECTIVE

Data Analyst, VBA & RPA Developer with 6 years of total experience in interpreting and analyzing data for driving business solutions. Proficient knowledge in statistics, mathematics and analytics. Excellent understanding of business operations and analytics tools for effective analysis of data.

CAREER PROFILE

As a Consultant (Xceptor Developer) in Corporate & Investment Banking at

JP MORGAN CHASE & Co. (Client Site)

On-contract with Ampcus Tech Private Limited. Ampcus Inc. is a Global leader in end-to-end IT Business Solutions and Services with latest Technologies and Insights to our customers. We are listed among the top 50 fastest growing companies in USA.

Involved from: 6th June 2019 to 5th Nov 2019.

JOB PROFILE & RESPONSIBILITIES as an XCEPTOR DEVELOPER (RPA)

Review and understand business requirements, then determine the feasibility of development in Xceptor & Alteryx.

Undertake scripting and development of requirements in coordination with the business in Xceptor; in accordance with lifecycle methodology and risk and control guidelines. This includes raising relevant requests, performing QA and UAT testing.

Capture multiple structured and unstructured data formats including PDF, XML, CSV, XLSX, and TXT.

Liaising with CIBIL operations, Regulatory reporting, Market Value Reconciliation & other teams to understand their requirements script accordingly.

Perform root-cause analysis and provide technical trouble-shooting on current and existing Xceptor builds.

Cater to the Ad-hoc requests such as incorporating HTML CSS code to beautify the outcome, modify the XML structuring and assisting external teams in complex Excel requirements.

Ongoing coordination and communication with the business and appropriate technology teams, to ensure on-time completion of project as per requirements.

Partnering with teams in other locations to support Xceptor development work for the business.

Responsible for delivery of the entire process as per defined SLA's.

Design, develop, and execute VBA macros to automate data entry inputs.

Communicate effectively to an audience at all levels of management.

KEY RELATIONSHIPS/ CUSTOMERS

National & International Associates, Scripters and SME’s.

As a Data Analyst in Business Operations at QUALITY APPLICATION

SOLUTIONS Pvt. Ltd. formerly known as APPCO GROUP INDIA

Quality Applications Solutions Pvt. Ltd. is a one-stop direct sales management service provider that believes in investing its sales and support expertise on established brands as well as new start-ups, thus enabling them to enhance their customer acquisition.

Involved from: 8th May 2017 to 2nd April 2019.

JOB PROFILE & RESPONSIBILITIES as a Data Analyst / VBA Automation.

Interpreting data, analysing results using statistical techniques & providing ongoing reports

Developing & implementing databases, data collection systems, data analytics & other strategies that optimize statistical efficiency & quality

Acquiring data from primary or secondary data sources and maintaining data systems

Publish periodic (daily / weekly / monthly) BI reports, with ad-hoc reporting as and when required

Undertake regular variance analysis between actual performance and target levels to identify areas of improvement; and forecast requirements and operational performance for assigned processes

Undertake data mining exercises and support business owners on forecasted hotspots

Track key metrics such as sales pipeline and monthly results to help business leads interpret how sales team is tracking against goals

Generate ad hoc reporting for sales & business planning

Deliver insightful reporting, improve data integrity & management, and create analytics to help the leadership team evaluate and drive business performance

Partner with functional leaders, Strategic Business Partners and senior leaders to assess and provide reporting and analytical solutions to fulfil business requirements

Analyze sales and performance records, interpret results of overall sales

Maintaining extensive reports & depicting the analysis through strong power point presentations

Monitor and distribute detailed analysis of data and reports to support business initiatives, to provide data driven business

Validate, Analyse and report information across teams

Draft and edit reports as per requirement including monthly, quarterly reports, summary reports, detailed reports, ad hoc reports, dashboards and analysis

Understand the requirements from business users and design and develop reports and analysis accordingly

KEY RELATIONSHIPS/ CUSTOMERS

Internal & External stakeholders

As a Sr. Data Analyst in Operations at RADIANCE VISION Pvt. Ltd.

RADIANCE VISION Pvt. Ltd. hosts multiple segments under one umbrella business structure. Radiance Vision Private Limited is the brainchild of a team of television journalists and we are majorly into E-commerce services, Event management, Celebrity Management, Corporate films, corporate presentations, Digital domain management, Media Consultancy, Audio video film production and Animation arts.

Involved from: 2nd July 2015 to 5th May 2017.

JOB PROFILE & RESPONSIBILITIES as a Sr. Data Analyst cum TEAM LEADER.

Handle end to end E-commerce operations for Top rated sellers on multiple Ecommerce Marketplaces.

Proficient in handling FLIPKART, EBAY & AMAZON’S seller central Dashboards.

Analysing and initiating RTV on low potential products to avoid LONG TERM STORAGE FEE.

Creating and monitoring Promotions.

Perform Automations using SQL queries, VBA macros & Advanced EXCEL.

Good hands-on experience in creating Dashboard, Charts, Pivot, Graph, Lookups, Advanced formulae’s, etc. for MIS/Analytics purpose.

Upload & Extract data from MS-SQL server for team operations.

Managing team which deals with more than 100 brands that enables retailers and manufacturers to integrate, manage and optimize their merchandise sales.

Performing monthly RECONCILIATIONS for :-

1.Brand Funding, Promotional Rebates & AMPP

2.Sales & Stock Analysis.

Thorough experience in Listing & Uploading (Cataloguing) for any Marketplace.

Experienced in handling SALES PROJECTION, preparing PO & Shipment requests.

Handling Sales & Inventory Analysis used while preparing Stock update reports for the Vendor/Marketplace.

Challenging self and others and also keeping Service, Quality and Accuracy oriented team approach towards the customer needs.

As a Data Analyst at MATRIX PARTNERS Pvt. Ltd.

Matrix Partners is a 360 degree e-commerce solutions provider. With hundreds of online sales channels to work with, both in India as well as internationally, e-commerce management can become quite challenging. We, at Matrix Partners, provide e-commerce solutions that enable retailers and manufacturers to integrate manage and optimize their merchandise sales across various online channels including eBay, Flipkart, Amazon, Snapdeal, Shopclues, Paytm, Google, Facebook and still counting.

Involved from: 19th August 2013 to 30th June 2015.

JOB PROFILE & RESPONSIBILITIES

Coordinate with customers and staff and provide support to all data analysis.

Create and upload product listing, update prices, stocks, images and other relevant data on the website.

Managing Buyer & Handling Complete Product Line.

Coordination with client for handling all needs in relation to the project.

Perform audit on data and resolve business related issues for customer base.

Handling SEO keywords, Content writing & Title for a product.

Responsible for all the activity regarding online products.

Maintain admin panel & product upload.

Train the new joinee / joiner as how to list the product.

Check the quality of data and maintain consistency.

Satisfy clients/sellers queries with proper explanations.

Providing tech support and participate in forming or modifying strategies for organisations and customers benefit.

EDUCATION QUALIFICATIONS

2006, S.S.C. ( Mumbai Board )

Institute: Bangur Nagar Vidya Bhavan

Class: First (64%)

2010, Diploma in Information Technology ( Mumbai University)

Institute: Thakur Polytechnic

Class: First (70%)

2013, Bachelor of Engineering in Computer Science & Engg (NMU)

Institute: SSGBCOET

Class: First (63%)

ADDITIONAL INFORMATION

Skills: Good understanding of MS SQL Server programming, VBA Macros, Xceptor development (RPA tool), Alteryx, Advanced MS Excel, Power Pivot, Pivot table, Dashboard, MS Access & PowerPoint presentation.

Analytics Applications: Marketplace Dashboards, MS SQL Server, BIDS (Business Intelligence Development Studio), MIS4NOW, Google Analytics.

Operating Systems: DOS, Windows (98, 2000, XP, Vista, 7, 8, 10), Linux (Ubuntu, Red Hat), Apple Macintosh (10.6-10.9).

Hardware Programming: Microprocessor Assembly Language (8085, 8086 etc.).

MORE ABOUT ME

Languages Known: - Proficient (can read, write and speak) in English, Hindi and Marathi Qualities: - Good inter-personal, Collaboration and Managerial skills.

High learning ability.

Excellent Team player.

Highly adaptable.

Contact this candidate