Product Data Analyst with MS in Information Systems from Stevens Institute of Technology – a professional with 1.5+ years of experience interpreting and analyzing data in order to drive successful business solutions - seeking Data Analyst position using SQL and Excel for Data Cleaning and Tableau and Power BI for creating visualizations, reports and dashboards.
A detail - oriented data enthusiast who is passionate who values ‘Design Thinking’ and believes in ‘Learning over Knowing’. Driven by goal of helping organizations grow their business, the aim is to learn, contribute and push boundaries in every role or assignment that is taken up.
Excellent communication skills, never say die attitude, incredible organizational skills merged with aptitude and diligence to meet a challenge should enable me to make a difference in an organization.
-
Experience
Product Analyst, JONATHAN Y, New York City, NY April 2020 – Present
• Collaborating and sharing of results and data with internal/external cross-functional partners like Target, Groupon, Amazon, BBB
• Analyzing data to observe trends, identify opportunities/solutions, and support short-term and long-term deliveries
• Creating clear, accurate data reporting to communicate meaningful metrics to stakeholders and make strategic business decisions
• Aggregating and analysing consumer feedback data and providing insightful intelligence about consumer behaviour, purchasing habits, and competitive conversion
Product Data Analyst, VIGO Industries, New York City, NY May 2019 – Feb 2020
• Facilitated product publishing for clients like Home Depot, Wayfair and Amazon for product feed centralization using Salsify
• Acted as a liaison between all functions of business to coordinate the product content lifecycle (creation, management, sharing)
• Analyzed metrics and data using Excel to track improvements in merchandising and customer experience for different products
• Created visually impactful dashboards in Tableau for data reporting. Extracted, interpreted and analysed data to identify key metrics and transform raw data into meaningful, actionable information
• Utilized Google Analytics to track visitor flow, conversion rate, bounce rate and interaction throughout the company website
Business Data Analyst intern, Mobile Programming, New York, NY Sept 2018 – Dec 2018
• Implemented Agile methodology by adaptive planning and evolutionary development resulting in faster deployment of software
• Designed and developed dashboards, reports and visualizations using Tableau, SQL and Excel to analyze market performance
• Analyzed and evaluated business requirements and translate these into technical requirements and specifications, providing insights on system and technical components to incorporate into the technical design
• Produced wireframes that contributed to user-centred design (UCD) efforts for dozens of Web pages
Data Analytics intern, United Nations, New York City, NY June 2018 – Sept 2018
• Led the change management protocol using MS project for country offices and bureaus for managing complex projects
• Extracted, manipulated and prepared HR data using tools like Power BI, SQL Server and MS Excel to identify KPIs, analyse trends in data and performed gap analysis
Graduate Assistant, Stevens Institute of Technology, Hoboken, NJ May 2018 – May 2019
• Leveraged Salesforce to monitor faculty, student and alumni information; Excel and Tableau for data cleaning and presenting complex analytical reports to achieve continuous improvement in data quality
-
Projects
Data warehousing & Business Intelligence, CFPB Aug 2017 – Dec 2017
Project description•Developed a BI system using Tableau for visualization that was used by the Consumer Financial Protection Bureau (CFPB) to analyze their everyday business
•Performed ETL on database using SQL Server Integration Services (SSIS) through Visual Studio for business process
•Built a data warehouse on star schema by OLAP dimensional modeling for consumer complaints
Marketing Analytics, Vodka Sales in Iowa Jan 2018 – May 2018
Project description• Developed marketing strategies for liquor store in Iowa which would help them boost their sales of different liquor brands
• Created a Google Analytics Dashboard to track progress of their marketing strategy by monitoring website traffic
•Performed data visualization using Tableau and Excel
•The data set used was provided by Kaggle and analysis was performed on 6 of the most famous vodka brands in the US
Re-engineering Process, Stevens Institute of Technology
Sep 2018 – Dec 2018
Project description•Identified bottlenecks within the current service process and re-engineered it by introducing organizational as well as technological changes
•Developed a high-level conceptual data model, process goals, relationship map, responsibility matrix, job model and BPMN
•Defined targets for the TO-BE process by addressing productivity constraints and reducing cycle time significantly
System Analysis, Quicken Loans Jan 2018 – May 2018
Project description•Analysed the competitive landscape in the mortgage lending industry and developed UML, process flow and Data flow diagrams to understand processes at Quicken Loans
•SWOT Analysis, Porter’s Five Forces and PIECES Framework to understand the Life Cycle