Successfully led the migration of legacy data systems to a modern, tech stack and infrastructure, reducing processing times by 30%.Designed and implemented robust ETL frameworks that improved data accuracy and consistency across multiple platforms.Spearheaded automation initiatives that reduced manual processes and increased operational efficiency by 40%.

Partnered with the Director of Pricing and Analytics to develop new pricing models extrapolating from first, second and third party data sources.Assisted product owners/ product teams across various portals to report KPI trends, YOY variances and anomalies.Ran descriptive and diagnostics reporting/analysis and presented it to relevant stakeholders.Created scripts for Analytics team members to automate repetitive reports and worked with BI team to schedule them on BI servers.Used SQL skills to identify boats that are under/overvalued, pricing trends, changes in the supply and demand dynamics for boats across the U.SPartnered with Sales and Operations to report on display products performance.Presented BI- Weekly reporting to senior management about the state of the portals and any active issues that need to be addressed by cross functional teams.Partnered with Network director to improve Network CPM based on various ad units and portals to maximize revenue and fill rates.Worked to prototype Projects ranging from data engineering using SSIS / stored procs/views/in-line SQL to reporting using PowerBI/Tableau/Spreadsheet.

Worked on a very cross-functional role and reported directly to CIO. Change Agent for Digital Transformation, Data-Driven Decision Making, and Business Process Optimization. Helped organization on a very broad range of expertise ranging from Business Process Automation, Data Storage/ Data Engineering/ Integration/ Migration/Data Visualization as well as problem-solving with Machine Learning. Helped Sales organization with Demand Planning fitting econometrics models such as ARIMA/SARIMA/Holt-Winters/FB Prophet. Helped Supply Chain Team to estimate inventory levels into the future. Helped Marketing in Competitor analysis, Sentiment Analysis, and Web Analytics.

Helped critical business area of Power Delivery to get full visibility of outage data. Managed end to end work workflow as well as provided subject matter expertise as a Lead Power BI Developer. Worked on prototyping the solution as well as hands on development throughout the full project.

Partnered with Online subscription Product Manager to grow the digital subscription business. Worked as a part of Consumer Data Platform team to integrate data and deliver consumer insights. Initiated, developed and managed a small BI team of contractors to support business operations, analytics and marketing campaigns performances. Helped subscription business detect patterns and operational anomalies. Built data platform to track KPI that business valued. Provided data assistance for forecasting function as well as helped business carry out strategical initiatives with data extraction, analysis and research. Together we grew business by 18% YOY during my engagement.

Helped Client(Marketing Agency) on critical time sensitive project by creating visualization layer on top of search, digital and content data for its fortune 50 partner. Assisted the data warehouse team with data warehouse design as well as provided front end expertise with sharing data across partners and customers. Project involved the newest technologies including Azure Data Lakes and other Hadoop technologies. Learned the technologies , delivered on deadlines and also managed an offshore staff by adopting an onshore /offshore model.

Helped the client to digitize Property and Casualty Claims reporting. Worked on a code heavy environment authoring complex SQL code based on Guidewire data. Authored complex SSRS financial reports that were used internally and reported externally. Developed requirement documents for ETL team to automate related data load into Data warehouse systems from application systems. Helped client to transition reporting to Power BI for their Marketing Call center.Worked on finance department’s initiative to roll out automated reporting system to be operated across multiple continents. Created automated Financial reporting at scale to be operated across different geography and across multiple currencies. Worked independently to set up infrastructure, databases and security from the ground up to delivery and training.

Worked under Digital Marketing and Analytics arm of Scholastic to provide necessary data and insights to all involved departments. Worked with Sales Data, Marketing Data as well as Digital Subscription Data to give a 360 view of operations to the business. Maintained existing data warehouse to make sure Jobs were successful and data was continuously integrated between Oracle. IBM, Microsoft and Adobe Systems. Applied fixes to the job schedule wherever necessary. Worked cross functionally with teams to triage data and reporting issues.