· Created a prototype Data Engineering pipeline to ingest 250M+ daily hit-level Clickstream feed from Adobe Analytics and mParticle into the Databricks Lakehouse platform.· Created Clickstream metrics of customer engagement with the McD mobile app.· Designed and coded Databricks data pipelines connecting McDonald’s first party data with Epsilon Paid Media data warehouse, New Relic, and mParticle / Braze.· Led the project to connect the customer data MDM AWS Redshift database for the first time with the Databricks platform, leading several contractors in design of AWS security enhancements.· Prototyped a data pipeline to ingest New Relic mobile app crash reports and logs into the corporate AWS Redshift data warehouse.· Designed a cost monitoring solution for Databricks MosaicAI GenAI POC to classify free-form customer comments.· Gained approval for a GenAI POC from Cybersecurity and Data Governance.· Investigated customer reports of mobile app glitches by leveraging Clickstream and New Relic data.

· Support e-commerce and digital marketing efforts centered around the McDonald's mobile app.· Collaborate with consultant teams from Accenture, Publicis, Sapient, Brillio, Cap Gemini, and Adobe· Designed several Tableau dashboards to illustrate data patterns to narrowly targeted audiences.· Discovered and recommended resolution of complex data issues in digital customer data in order to increase trust in enterprise BI tools and marketing campaigns.· Monitored data flows via tools such as AWS Redshift, Adobe Analytics, New Relic, Databricks Lakehouse, Elastic Kibana, HBase, Athena, Postman/Insomnia, AWS CloudWatch.· Aligned BI governance of three BI tools, independently developed in Tableau, Google Looker, and Java, which increased the desire of several hundred people to trust data. · Developed datasets to support daily, monthly and annual reporting and marketing campaigns via Databricks PySpark and Pandas, which allowed marketing to send 40M+ additional customer touchpoints.· Established automated monitoring of a Data Engineering pipeline that extends across AWS Redshift, Databricks, and Google BigQuery platforms, which resulted in a simplification of the pipeline for greater reliability.

· Part of the Core Customer Platform (CCP) team in Global Technology, Data & Architecture organization.· Created technical requirements for a customer data MDM system that maintains compliance-related data elements covered by digital privacy, GDPR, and CCPA regulations in five countries.· Contributed to many SDLC phases of a new customer data pipeline that feeds an Enterprise Digital Marketing initiative.· Investigated a variety of Data Quality issues with compliance-related data elements maintained by the system.· Performed data research in Pandas, SQL, Tableau, and Excel to prepare for cleaning of dirty data from the system.· Applied data science techniques to measure the quality of data processed by the CCP system. Techniques include FB-Prophet and Random Forest prediction, association analysis, and clustering via DBSCAN and Jenks-Fisher.· Created Tableau dashboards that illustrate customer data health and cleanliness.· Created a Tableau dashboard to visualize mobile app upgrade patterns by iOS and Android users.· Created a Tableau dashboard to illustrate customer marketing Opt-In and Unsubscribe patterns.· Created a Tableau dashboard that published an automated English-language explanation of DBSCAN clustering algorithm results, using Narrative Science Tableau extension and TabPy.· Reviewed test cases prepared by the QA team.· Started as a contractor and converted to FTE.

· BA and ScrumMaster of two Pune-based teams, each composed of 3 developers and 1-3 QA.· Managed requirements of a REST API that connected with external and internal applications.· Prepared 60+ Front-end and Back-end user stories, complete with detailed Acceptance Criteria.· Wrote Python scripts to collect JSON data from REST APIs for hands-on analysis in Excel.· Created reports in SAP Business Objects Data Warehouse.· Managed requirements of a .NET application that facilitated peer-to-peer fundraising and non-profit project social networking among 33,000 Rotary Clubs around the world.· Assisted SOW negotiations by writing requirements for iPhone mobile app enhancements for implementation by Ideastudio vendor.· Coordinated IT activities and performed data cleansing for launch of a corporate training system provided by DoceboLMS vendor.

• Business Analyst for hyatt.com E-commerce team, filling in for a Sr. BA on maternity leave.• Member of a highly successful Agile team comprised of PO, BA, UI/UX, developers, and QA.• Prepared 50+ Front-end and Back-end user stories for hyatt.com E-commerce Booking team.• Created Acceptance Criteria for 40+ stories.• Redesigned REST API Confluence documentation for 11 API endpoints.• Researched Splunk Enterprise logs.• Analyzed bulk JSON data in Tableau and MS-Excel.• Researched REST API data through Postman, Swagger and in bulk through bash scripts.

• Started as a TEKsystems contractor and was converted to FTE.• Created and managed requirements for an Identity and Access Management web platform that controlled access for 40,000+ employees in the Consumer LOB.• Organized business needs into 400+ user stories, epics, and releases.• Led numerous presentations to technical and executive stakeholders.• Designed and reviewed intermediate and complex SQL queries.• Attained experience in dashboard design in Tableau 9 based on SQL Server and Excel data.• Created Confluence-based API documentation.• Piloted a move off Waterfall into Scrum, using JIRA.• Onboarded 100+ staff to a Scrum-oriented DevOps system based on Microsoft TFS 2017.

• Several roles on contracts listed below• Facilitated requirements gathering meetings with many active and potential clients• Supported sales efforts through the creation of technical presentations and SOW documents• Coordinated several projects with up to four offshore developers

Tools: Mingle, JIRA, Confluence, Visio / OmniGraffle, MongoDB, Ruby on RailsBusiness Analyst working in the Online Business Unit, Open Source Division, located on 1 N State St, Chicago. • Create design documents, user stories and test cases• Conduct Iteration Planning Meetings and demos with business• Create site traffic trends and other presentations for Product Owners• Resolve technical and business requests coming from Network Ops, DevOps, UX teams and business leadership

Ruby on Rails developer in the team responsible for financial products for Great Britain market. This was a staff augmentation position on contract from Sphere Consulting, Inc.

Tools: JIRA, Amazon Web Services, Visio / Omnigraffle, Javascript, Github• Transformed high-level client requirements into detailed system requirements• Conducted weekly demos with the client and translated feedback into actionable requirements• Tested the site with manual and automated tools

Tools: JIRA, Amazon Web Services, Basecamp, Github, many 3rd-party APIs• Created user stories and design documents• Created UI wireframes and wrote the system’s operations manual • Benchmarked site performance and managed site’s Amazon Web Services infrastructure

The annual Ruby USA Conference. Held in San Francisco in November 19 - 21, 2009.

Tools: C++, Perl, Unix/Linux, Location-Based Services on a mobile 3G network• Developed GPS software with Singapore and San Diego teams• Led two consultants in this project

Tools: C++, Oracle, SQL, Unix, Perforce SCM• Converted components of Navigon’s European-oriented software for the USA market• Led a maintenance project with up to four offshore developers and QAs• Created map data analysis documents and presentations with SQL, Excel and Visio• Administered an Oracle 10.2g database server

I researched topics on Chicagoland passenger rail transport. It was part of my hobby - public policy combined with technical approach.I wrote a summary article about substantial Chicago Transit Authority (CTA) challenges during the first wave of the Great Recession. On a tactical level, the income challenges of CTA were exacerbated by its highly inflexible cost structure. On a strategic level, CTA is hostage to the varying Chicago general business and residential climate, which drives rider population. It also drives the population of sales tax payers and real estate transfer tax payers in the city of Chicago. Parts of these two taxes are routed to the CTA.Finally, CTA It is hostage to its own user-insensitive management culture.The article served as a base for a video clip by the Sam Adams Foundation.

Tools: C, C++, Unix Shell, IBM AIX Unix• Developed key street map database features for Magellan Roadmate, Best-of-Category Award recipient from PC Magazine; multiple car and hand-held navigation systems• Improved user responsiveness by interleaving cartographic and routing maps for faster performance of both features (Google results for patent number 6,112,200 will explain the details)• Accomplished 200% improvement in performance of automated database creation by parallelizing processing of geographic map sections on multi-CPU servers• Enabled accurate street name placement by inserting precise curvature details into street name data• Validated advertised value of 97% ground truth accuracy through automated trigonometric measurements of street geometry.