-Developed and debugged pipelines and stored procedures, optimizing query time by 15% and ensuring data integrity.-Combined structured data from multiple sources and stored transformed data in data warehouse, utilizing SSMS.-Conducted quality assurance checks to reconcile outdated data for CHS reports to reduce data validation efforts by 20%.-Restructured SAS data outputs and structured data regarding disease count utilizing Pandas/Polars to track KPI’s.-Lead SDLC of data products within and across multiple departments through communication with multifaceted teams.-Generated custom reports and assisted stakeholders with ad hoc requests, and data related technical issues.-Provided data validations on new reporting process outputs, ensuring alignment and consistency with legacy reporting system outputs.

-Pulled ad hoc requests from I.T and Digital Culture teams and owned communication pipelines to maintain workflows.-Implemented data classes in ETL pipelines to provide consistently structured line items ensuring data quality and accurate data ingestion for client engagements.-Prototyped data-driven solutions using GraphQL for client engagements/data standardization in collaboration with the data science team.-Built MVP deliverables and mentored client tech practitioners demonstrating digital solutions capabilities to client problems.-Led some client/stakeholder engagements during periodic check-ins to go over MVP application progress.-Created an introductory Data Viz course for Digital Culture teams, enhancing the Rolls-Royce’s offerings package when on-boarding clients.

Learning various DE principles, disciplines, workflows through projects, exercises and lesson plans.

Enrolling in a Fullstack Immersive bootcamp where I developed my skills with these projects.Projects:-Terminal Teller-Web Trader-Transity Buddy-Pretty City

-Aggregated data from 3+ sources (Sizmek, Neilson, Datorama) to build comprehensive datasets for analysis.-Implemented Python to transition team from using legacy Excel tool for data cleaning and aggregation.-Assisted the data engineering team with mass data migrations when developing new data tool, ensuring accuracy and data integrity.-Analyzed data to uncover correlations between business drivers and sales performance using Excel and Pandas.-Implemented data visualization to demonstrate strategic findings, performance and talking points for each product campaign.-Used historical and current campaign performance to optimize future campaign strategies and ensure data-driven decision making.-Provided support to team leads during presentations with internal adjacent teams and external client engagements.-Led internal meetings with D.I, planning and M.S teams, facilitating collaboration and aligning strategies for comprehensive reporting and optimal performance.Generated reports that delivered meaningful insights resulting in 5x – 10x return on client investments.-Clients: Volvo, Chanel.

-Setup and tracked ads in ad server (Google Ad Manager), including placing ad tags, creatives, and ensuring correct targeting.-Aggregated daily data on the weekly, monthly, and year to date level for comprehensive reporting.-Ensured proper functioning of ads on all web pages optimizing revenue generation by monitoring and troubleshooting issues.-Optimized ad inventory for high-traffic website by ensuring max fill rates and efficient use of available ad space resulting in a 20% increase in overall ad revenue.-Performed keyword performance analysis to optimize search engine rankings and drive organic traffic, using SEO strategies, Google Analytics and keyword research tools.

Being a part of the Android Mobile App Development Team for Etching-it.com-Learning mobile app software development, scripting, and project management-Using Java, Xml and Android Studio to develop a phone authentication system for app registration process.-Creating UML diagrams to map user journey for mobile application.-Working on discovery, requirements, test scenarios, user stories, functional and integration testing.

-Pulled Excel reports from various Ad Network API portals to analyze ad performance on website.-Used comprehensive reporting to determine validity of continued partnership with Ad Network or renegotiating partnership details. -Developed formulas to calculate daily, month-to-date, and year-to-date impressions, impressions sold, eCPM rates, ad revenue and forecasting potential earnings using Excel/Google Sheets.-Focused on maximized ad revenue by working closely with Ad operations and sales team to understand revenue goals. -Developed detailed data driven reports for sales, ad ops and management teams that summarize monthly performance.

Assisting the Manager of Ad Operations with data collection, organization, and visualization tasks. Analyzing company revenue from ad networks and creating spreadsheet reports on a daily basis to see how the company is doing with it's supplemental form of revenue aside from direct sales.Responsibilities: *Data Entry/Organization/Visualization.*Analyze income stream data from ad network's revenue and and decide which ads to incorporate from which network based on performance on company website. * Learn how to write API queries to retrieve data from tools like Google Analytics, Facebook, Twitter, MailChimp, and SalesForce. * Reformat spreadsheets department heads are currently using to work in our dashboard system. * Find creative ways to visualize data in Excel as well as our online dashboard tool. * Various marketing tasks as needed by the marketing team.

Working in a fast pace retail sales environment learning various skills that aided in future roles including customer-facing, inventory/restocking analysis, and assisting team members in order to provide the best customer service:-Addressed customer issues efficiently, enhancing my ability to quickly diagnose and resolve problems,-Gained proficiency with POS systems and inventory management software, providing a technical foundation.-Worked closely with team members to meet sales targets, honing my ability to communicate effectively and collaborate within a team-Ensured transaction accuracy and maintained detailed inventory records.-Adapted to new products, promotions, and technologies demonstrating flexibility and a continuous learning mindset.Accomplishments:-Exceeded daily/weekly sales goals.-Ranked among star sales of the week.