Technical Project Manager & Business Analyst

PAMELA CHAKRABARTY https://www.linkedin.com/in/pamelachakrabarty

**** ****** ****** *, *******, WA, 206-***-****, **********@*****.*** https://github.com/Pamela2016 SUMMARY: 6+ years of experience in advanced analytics in Digital Product, Customer Engagement, Marketing & Supply Chain Operation for global customers along with managing tech projects in Cloud Infrastructure Operations for international financial clients by data driven problem solving EDUCATION

● Master of Science in Information Systems Management, University of Washington, Seattle,WA, GPA 3.79 (Scholarship) May 2017

• Bachelor of Technology in Information Technology, West Bengal University of Technology, India, GPA 3.5 Jun 2012

• Machine Learning University, Amazon Jun 2019

• Digital Product Management, University of Virginia, Coursera Jun 2020 TECHNICAL SKILLS

Business Intelligence tools: Tableau, Power BI, SSIS, SSRS, OLAP, ERD, MSSQL, ETL, Reporting, Data-Warehousing, Google Analytics, : Python, R, SQL, Datanet (ETL Development), AWS Redshift, SQL, Code.Amazon.com, Hubble, Hoot, EDX, Eider, Andes, Running DJS on Cloud Devbox, Tableau, QuickSight, AWS, EC2, S3, or DynamoDB, Hadoop, Hive Data Mining & Big Data tools: Python, R, SQL, AWS, EC2, S3, or DynamoDB, Hadoop, Hive Statistical Techniques: A/B Testing, Segmentation & Clustering, Descriptive Analysis, Regression & Predictive Modelling, Classification. Program Management tools: Visio, Scrum, Agile, Lean, ITIL, Six Sigma, Kanban, Balsamic, JIRA, Confluence, PMO, SDLC, User Experience Design

PROFESSIONAL EXPERIENCE

Product Analytics Manager, Digital Product Marketing AWS, WA, United States Sep 2019- Present

● Owning the query design, mapping and reporting roadmap and pipeline for recently launched products from end to end

● Captured all marketing related activity journey of customers and prospect visitors to site, customer web page activity and usage behavior to understand product first time adoption, funnel analysis that enabled marketing teams with action driven business insights at a weekly level to leadership

● Designed sql query, validated data and created automated BI reporting to track monthly service usage and revenue data for all customers across all marketing products & services at (daily/weekly/monthly) cadence.

● Owned and designed the new SIM ticket intake process for team which was based on different types of data requests from stakeholders across the entire organization and integrated the process with the team documents page. This helped stakeholders with easy access to adhoc data analysis requests

● Designed business logic and reporting to measure Customer Adoption, Engagement and Churn which enables product marketing managers to design relevant targeting marketing campaigns to existing & prospective customers based on recency, frequency and monetary values.

● Partnered with various senior marketing leaders to configure new targeting market segments on the backend datawarehouse by deploying sql codes. Business Intelligence Analyst II, Supply Chain Operations, Amazon, Seattle, WA, United States Jul 2019- Aug 2019

● Worked on a project to create and track package level scanning performance from FC to last node to measure vendor compliance

● Worked with developers to design a process to track packages missing flight and getting rolled at gateways to provide visibility to Ops leaders by designing a real-time Tableau dashboard with daily/weekly details. Business Intelligence Analyst I, Supply Chain Operations, Seattle, WA, United States Sep 2017- Jun 2019

● Owned design, development, automation and maintenance of ongoing metrics, reports, analyses, dashboards to drive key operational decisions. Published, analyzed and improved management information dashboards, operational business metrics decks and key performance indicators.

● Owned query/KPI design & automation and creating comprehensive insightful dashboard reporting for team WBR (daily/weekly/monthly) including data presentation and operational deep-dives.

● Designed and developed a scalable, stable & cost-effective end-to-end Vendor- Amazon data pipeline to streamline data pull from vendors using python scripts that loaded data into Redshift tables and designed dashboards in Tableau that replaced daily manual email from vendors.

● Directly partnered with Ops senior leaders & other across the NA Air Org, gathered requirements, formulated biz metrics by building ETL pipelines

(extract, transform and load data from a wide variety of data sources using SQL (Redshift,MySQL) and used scripting language(Python) to process data).

● Improved existing reporting dashboards and analytical processes to enable teams to self-service 80% of data needs by designing data infrastructure/ automated reporting tools.

Business Analyst, Analytics, IT Infrastructure, Apptio, Bellevue, WA, United States Jun 2016- Apr 2017

● Extracted data from diverse sources to highlight customer interaction with product and compute resources consumption over 1 year

● Performed descriptive analysis on memory and disk usage of servers for European customers to aid in forecast capacity planning for 2017

● Conducted exploratory data analysis on IT Operational tickets datasets to capture KPIs of service level performance by functions and global regions

● Created interactive Tableau dashboards on relevant KPIs and drove meetings to communicate findings to the Director of IT Operations

● Wrote HIVE and SQL queries on 50k+ customer dataset to analyze usage pattern of an B2B product that optimized container space allocation Quality Control Program Lead, University of Washington, Seattle, WA, United States Mar 2016- Present

● Leading team on conversion of hundreds of Kindle articles/books to easily accessible readable formats for the Disability Resources team.

● Evaluating file accessibility features for articles and captioning videos and files to categorize and distribute books and Kindle articles. Technical Program Manager, Global Data Center Operations, Cognizant Technology Solutions, India Dec 2012 -Jun 2015 Actively facilitated in transition of server provisioning process from VMware to HP Cloud for a banking client

● Drove global client engagement to migrate server provisioning process from VMware to HP cloud which increased service delivery by 30%

● Interacted with clients to capture testing requirements for provisioned servers and executed test cases with a 98% success rate

● Led off-shore quality assurance team of 10 for testing provisioned servers resulting in 97% adherence to SLA quality standards.

● Worked on deploying virtual server machines, based on system specifications and application packages.

● Provisioning, installation, administration and maintenance of all cross platform web, database and business application servers.

● Interacted with the onsite team and the clients on business requirements and providing them with the process updates. ACADEMIC PRODUCT RELATED PROJECTS

Exploratory Data Analysis & Regression modelling on NYC Flights dataset (using R and Python) Analyzed dataset, merged data tables to find co-relation & created linear regression and multi-panel plots to infer insights between variables Business Intelligence to Improve Product Sales (MS SQL, SSIS, SSRIS, SSAS, Tableau) Developed an end to end BI data warehouse system to analyze 2 years of sales data & created and dashboards to recommend business actions Product Manager, Design Challenge Microsoft 2016 – Global Winner

● Designed a user interface to offer a comprehensive learning and career development platform to learning enthusiasts.

● Created user personas, designed userflows, wireframes and a high fidelity prototype to test ideas with customers. Product Design: Designed a Website app prototype for Business Travelers

● Managed an entire project to design a information website layout to offer a pleasant travel experience to business travelers

● Performed competitive SWOT analysis on other websites and companies to design and shape the app.

● Conducted user research and surveys to understand target user needs, created use cases and user stories to test fulfillment of user needs

Contact this candidate