Sign in

Data Analyst

Plainview, New York, United States
February 11, 2018

Contact this candidate



** ******** ******, *********, *******-11803• 516-***-****• PROFILE:

Proactive analytical professional with strong interpersonal, team management, client service and leadership qualities. Highly developed technical skills in Excel (Complex Formulas, Pivot table, Macros, Solver), PowerPoint, spreadsheet modeling, data analysis (data cleaning, statistical modeling, data mining, data visualization), forecast analysis, risk management, quality assurance, report development and process improvement. Passionate about learning new skills.

Software skills: PowerPoint, Excel (advanced), SQL (advanced), JAVA, J2EE, HTML, JSP, jQuery, XML, Web services, C/C++, VBA, Outlook, Databases (Oracle, MySQL), Windows O/S, Google Sheet (Scripting), R

Tools: Eclipse Juno, Cordys, HP Quality Center, HP Application Lifecycle Management, Tableau, SharePoint, JIRA, Spiceworks, QuickBooks, Justworks


Shelfmint Inc. (E-commerce Startup) Data Analyst Intern New York City, NY (Oct’17 – Present)

Took initiative to improve existing process of Invoicing and KPI Tracking, by reducing processing time by 75% (using systematic and organized approach, querying database, utilizing SQL, Google Sheet scripting)

Gathered, interpreted, manipulated and analyzed the comparative high-volume market price data of the brands from varying sources (Retailers, Distributors and E-commerce) to accomplish the business goal of having competitive advantage over delivered pricing

Formulated repeatable methods, developed interactive reports and dashboards to model monthly sales report that helped to bring in US’s largest retailer-owned co-op, Shoprite and to partner with Acosta, US’s largest food brokerage

Forecasted and analyzed financial data to establish as well as evaluate baseline performance measures and trends, prepared the pitch deck for board meeting with the investors

Managed multiple projects simultaneously which involved assuring quality, solving problems effectively to address business needs, determining operational impact, taking strategic decision that improvised the current business process McQuilling Services Market Analyst Intern Garden City, NY (Sep’17 – Oct’17)

Conducted market research and developed weekly, daily reports and deliverables for clients (ship owners, bank investor, charters) that included market news, bunker rate, spot rate and TCE analysis to assist in their investment deals

Automated a daily tedious task with a button-click that extracted bunker data and populated in Excel using macros TATA Consultancy Services LTD. Systems Engineer (Java, J2EE, ESB Developer/Tester) India (Aug’13 – Aug’16)

Awarded with “Outstanding Role Model to Colleagues Award” Projects: ESB Developer, TATA Steel- Smart Steel Factory Project (Jan ’16 – Aug ‘16)

Developed Business Process Models in Cordys, working closely with Designers, designed workflows to execute data flow starting from customer order and billing to production level systems

Integrated various systems with the help of XML to provide communication within factories by performing Data Transformation based on the mapping sheet designed in excel Java Developer/ Onsite-Offshore Coordinator, Johnson & Johnson- EDMS Upgrade Project (Aug ’14 – Dec ‘15)

Developed an automated process in EDMS application to improved business manual processes by 80%

Handled user data in database by executing multiple SQL queries

Prepared hand-over documents (technical and functional specifications) and conducted testing with Business users

Managed team of four in an organized manner and developed status reports Tester/ Team Member, Johnson & Johnson- MIDAS-UNITAS Integration Project (Nov ’13 – Aug ‘14)

Analyzed the potential impact of application risks, tracking and maintaining the risk register

Assured quality of the application by formulating test cases and by performing Unit, Integration and System Testing

Spear-headed team meetings, communicated with cross-functional team and maintained sprint backlogs

Executed the project with 0% error adhering to critical project timelines by prioritizing time-sensitive assignments EDUCATION: (my article on Analytics - Frank G Zarb School of Business, Hofstra University Hempstead, NY Expected May’18 MBA in Business Analytics, GPA 3.87, Zarb Scholarship Sikkim Manipal Institute of Technology, Sikkim Manipal University India Graduated May’13 Bachelor of Technology in Electronics and Communications Engineering, GPA 8.86/10 BUSINESS PROJECTS:

Performed data visualization and basic statistical analysis on Olympics medal winning trend with 112 years’ worth of data since the first day of Modern Olympics using Tableau and identified key stories. LEADERSHIP EXPERIENCE:

HOFSTRA: Consultant- Hofstra Business Consulting Group, Secretary- Hofstra IT Graduate Association, Active Member- Zarb Women in Business Club, Hofstra Badminton Club SMU& TCS: Media and Sponsor’s Secretary- Student’s Council Board, Editorial Member- College magazine, Organizer, Volunteer - Social Activities

Contact this candidate