- 10+ years' experience in business intelligence, web analytics and data wrangling, adept at using complex data sets to identify key opportunities to increase revenue and improve conversion
-Quick learner and known problem solver with an innate sense of curiosity and the ability to quickly identify and prioritize opportunities in terms of value to organization
- Ability to express and present complex ideas and concepts to broad parts of the organization (Senior Management, Merchandising, Planners, Product Management and Data architects) as well as external clients.
- In-depth familiarity with the complex data needs of ecommerce across all parts of the business, and comfortable working with different data types
Data Mining, SQL, IBM Digital Analytics, Google Analytics, Data Collection and Validation, Cognos, Tableau
Cross functional analytics, business intelligence, and data expert that assessed, identified and helped create report suites and dashboards to meet Macy's analytics needs.
-Led the analysis and served as a subject matter expert to build a large and robust site merchandising business intelligence reports and Cognos reports for approximately ~250 end users. Reports combined diverse data sets including web, mobile, transactional, inventory and in store data. Instrumental in each step of the process; writing the business requirements based on listening to end users' needs and existing problems, partnering with data architect(s) to have the precise and most relevant data go into the reports, worked closely with the developers to test the reporting suite to ensure the reports were accurate. Communicated consistently with project manager any risks or issues to accomplish very tight timelines to meet a business-critical deadline. Collaborated and communicated at all levels including project management, data architects, engineers, stakeholders and management. Conducted in person and online trainings for end users
-Designed complex hive SQL queries for ETL type transformation to create summary data tables, and then partnered with Tableau expert to provide to self-sufficient reporting to stakeholders
-Created requirements and did UAT for real time dashboards to identify merchandising opportunities and inventory gaps for key events in the Macy's marketing calendar as well as day to day needs
-Web analytics data collection and validation expert for all onsite and merchandising needs
-Performed deep dive analyses to identify opportunities in product sequencing for onsite search terms and product categories that generated additional revenue (>$100K am month)
-Mentored junior members on team on learning and improving their SQL skills, improving their analytic insights and communications, and identified methods to streamline their workload
-Sophisticated Ad-hoc analyses using relational databases for senior management based on their business needs and questions
Worked with senior management at Brooks Brothers and Neiman Marcus to lead roll-out and adoption of novel decision intelligence software, Dynamic Action.
- Created and delivered weekly presentations that identified opportunities for clients to improve their online business, such as finding $3 million of inventory that was not listed for sale
- Audited web analytics tagging for numerous retailers such as Neiman Marcus, Express Fashion, and Eddie Bauer, across all major web analytic solutions: Adobe Omniture, q112IBM Digital Analytics, and Google Analytics.
-Performed numerous ad-hoc analyzes on large data sets to identify opportunities and pin-point data discrepancies and gaps in client's data feeds.
-Developed novel size availability analysis for Brooks Brothers that demonstrated up to $8 million in lost sales for dress shirts.
-Established weekly and monthly KPI metrics for all key Men's Wearhouse brands
-Designed tracking requirements and had tags implemented for the relaunch of both the retail and tuxedo rental websites
-Worked closely with creative and marketing to identify opportunities to improve conversion and sales via onsite and email marketing tactics.
-Implemented weekly analytics review meetings with key business stakeholders
-Designed program to measure increase in conversion and sales from re-platforming of Macys.com onsite navigation and presented to senior management that the re-platforming of navigation led to 8% increase in site conversion.
-Developed reporting requirements to measure novel customer experiences from the change in onsite navigation.
-Created a weekly KPI report for the rapid growth of mobile device usage on internet and devised plan on how to measure mobile traffic with third party integrations.
-Worked across teams to design site experimentation tests that improved email conversion for key private sale events.
-Provided advice and guidance in web analytics to Bloomingdales.com, sister company of Macys.com.
-Trained other web analysts, product managers, and merchandisers at Macys.com in the effective use of web analytics.
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
Job Titles Held: