Senior Business Systems Analytics Architect, Enterprise Application Products Sep 2016 – Jun 2024● Architect and implement a data warehousing strategy that integrates Oracle Financials ERP modules such as Accounts Receivable (AR), Accounts Payable (AP), Cash Management, Fixed Assets, Procurement, Inventory Management, and other pertinent data sources. Manage ETL development initiatives, leveraging DataStage and Oracle Financials to enhance data workflows and boost the reliability of business… Show more Senior Business Systems Analytics Architect, Enterprise Application Products Sep 2016 – Jun 2024● Architect and implement a data warehousing strategy that integrates Oracle Financials ERP modules such as Accounts Receivable (AR), Accounts Payable (AP), Cash Management, Fixed Assets, Procurement, Inventory Management, and other pertinent data sources. Manage ETL development initiatives, leveraging DataStage and Oracle Financials to enhance data workflows and boost the reliability of business analytics tools.● Spearheaded the creation of specialized financial and customer experience reports and dashboards, employing HTML, CSS, and JavaScript for select advanced analytics visualizations.● Utilized Distribution Services for efficient report dissemination, ensuring timely delivery of insights to stakeholders.● Innovated with automated solutions for report distribution via Google Drive, enhancing the accessibility and management of business intelligence data.● Developed a Confluence SaaS-based BI User Portal, enhancing real-time user interaction with a suite of operational tools and custom scripting.● Implemented a Python-based monitoring system for automated email alerts, promoting server uptime and system reliability.● Implemented JavaScript toggles in the UI, using a Google Drive file for script settings storage, enabling quick activation and deactivation of BI reporting automation without the need for a database.● Composed Python scripts for data manipulation and server health monitoring, enabling immediate notifications and operational tag updates for clear communication during system outages. Show less

● Spearheaded the StatsLite business intelligence platform's creation, significantly boosting ad placement tactics for top publishers. With the Creative Strategist (CS) guiding the charge, we heightened search visibility and refined ad displays, using clickstream analytics to bolster campaign performance. Our Ad Optimization Strategists (AOS) and Account Managers (AM) collaborated, applying key metrics like click-through rates and engagement times to deliver Yahoo's sales team actionable… Show more ● Spearheaded the StatsLite business intelligence platform's creation, significantly boosting ad placement tactics for top publishers. With the Creative Strategist (CS) guiding the charge, we heightened search visibility and refined ad displays, using clickstream analytics to bolster campaign performance. Our Ad Optimization Strategists (AOS) and Account Managers (AM) collaborated, applying key metrics like click-through rates and engagement times to deliver Yahoo's sales team actionable insights into user behavior. This integrated approach led to smarter, data-driven decisions, redefining advertising success.● Streamlined the MicroStrategy user creation process with ServiceNow, integrating approval workflows and automating profile setups, while also establishing a manager-based hierarchy access system, ensuring managers have secure visibility into their own expense data and that of their subordinates.● Automated the retrieval and integration of data feeds from Concur SAP into the reporting system, enhancing data availability for refined reporting and analytics. Show less

● Refined the management of Insertion Order (IO) ad campaign budgets, defined by customers for designated advertising periods, by designing and implementing algorithms that ensure the efficient allocation of funds. Our approach leveraged algorithms to analyze close to real-time performance dataand user engagement trends, guaranteeing that customers' advertising budgets were optimally utilized throughout their campaigns. This strategic oversight not only maximized return on investment but… Show more ● Refined the management of Insertion Order (IO) ad campaign budgets, defined by customers for designated advertising periods, by designing and implementing algorithms that ensure the efficient allocation of funds. Our approach leveraged algorithms to analyze close to real-time performance dataand user engagement trends, guaranteeing that customers' advertising budgets were optimally utilized throughout their campaigns. This strategic oversight not only maximized return on investment but also significantly improved the relevance and effectiveness of ads for end-users.● The strategic tools and actionable insights generated by the StatsLite platform empowered us to customize ad campaigns with unmatched precision. This initiative resulted in a remarkable uplift in user engagement and a notable boost in the success rates of advertising campaigns, showcasing the unparalleled benefits of data-driven strategies in the evolving landscape of digital marketing.● Designed an innovative, cross-platform ad marketplace with sophisticated audience targeting, utilizing JavaScript and HTML5 to deliver seamless experiences on a variety of devices.● Championed big data initiatives, integrating Hive and Apache Drill with Hadoop ecosystems to provide deep analytics insights, setting new standards for data exploration and utilization.● Devised strategic performance dashboards, upholding campaign fidelity and partner agreement adherence, directly contributing to trusted business relationships.● Delivered outstanding support and enhancements for a large-scale analytics platform, enabling data-centric strategic growth and optimizing business processes for over 1000 end-users globally. Worked on MicroStrategy SDK enhancements enforcing business rules and displaying data availability at MicroStrategy web interface (Web SDK and dashboard plugins utilizing HTML, CSS & JavaScript). Show less

● Contract Assignment: Served as a Senior Business Intelligence Engineer/Architect contracted to Yahoo! Inc. during this period.● Responsibilities and Achievements: For detailed descriptions of roles, responsibilities, and accomplishments during this tenure, please refer to the corresponding entry under Yahoo! Inc. on my profile.

● Developed a SaaS model to support Healthcare Analytics.

● Developed and oversaw Microsoft SQL Server data warehouses for renowned studios including Sony Pictures Studios, NBCUniversal, Paramount Pictures, 20th Century Fox, Warner Bros. Entertainment, The Walt Disney Studios, CBS, and others, impacting health and pension plans of over 110K members.● Revolutionized claims processing by innovatively using MicroStrategy as a robust claims assignment and distribution system, significantly streamlining operations and enhancing both efficiency and… Show more ● Developed and oversaw Microsoft SQL Server data warehouses for renowned studios including Sony Pictures Studios, NBCUniversal, Paramount Pictures, 20th Century Fox, Warner Bros. Entertainment, The Walt Disney Studios, CBS, and others, impacting health and pension plans of over 110K members.● Revolutionized claims processing by innovatively using MicroStrategy as a robust claims assignment and distribution system, significantly streamlining operations and enhancing both efficiency and accuracy.● Created advanced analytical models and interactive dashboards, equipping executives with critical insights for participant eligibility and claims management.● Engineered and refined ETL processes for data consolidation, enhancing the data warehouse integrity and supporting comprehensive analytics for strategic decision-making.● Identified and preempted fraudulent activities through sophisticated analytics, strengthening system trustworthiness.● Worked collaboratively with analysts and stakeholders to convert complex requirements into customized BI solutions, providing decision-support tools and improving user engagement.● Automated and optimized SQL-based data retrieval, significantly expediting the availability of actionable intelligence for key business indicators. Show less

Senior BI Engineer/Architect Oct 2005 – Sep 2011● Oversaw BI operations, optimizing ETL and database management, while maintaining MicroStrategy platforms to ensure ongoing operational excellence.● Collaborated with stakeholders to create tailored reporting systems, maximizing resource utilization and optimizing database performance.● Led the development and implementation of Market Basket analysis within the CRM framework to identify key product affinities, significantly… Show more Senior BI Engineer/Architect Oct 2005 – Sep 2011● Oversaw BI operations, optimizing ETL and database management, while maintaining MicroStrategy platforms to ensure ongoing operational excellence.● Collaborated with stakeholders to create tailored reporting systems, maximizing resource utilization and optimizing database performance.● Led the development and implementation of Market Basket analysis within the CRM framework to identify key product affinities, significantly influencing inventory management and personalized marketing strategies.● Automated complex reporting mechanisms, partnering with the Finance team to streamline financial data workflows.● Managed the integration of nationwide store and online customer data into the data warehouse, implementing a rolling update process that ensured reporting accuracy across various time zones and supported real-time insights into customer behavior and loyalty program performance.● Developed comprehensive MicroStrategy-driven initiatives for promotions, pricing, and vendor compliance, bolstering business processes.● Maintained data integrity through strategic data warehousing techniques, such as Slow Changing Dimensions, during product lifecycle changes.● Crafted reusable SQL scripts and FTP tools to accelerate data processing and ETL efficiency.Senior Programmer/Analyst Sep 2004 – Oct 2005● Successfully spearheaded key system upgrades and custom module development for warehouse management, improving operational workflows.● Pioneered a quality control module keyed to vendor performance, enhancing product intake efficiency.● Streamlined the returns process with a user-friendly Return to Vendor module, promoting transparencyand efficiency.● Deployed database auditing tools that provided vital change tracking and data integrity within the logistics infrastructure. Show less

● Led the migration and modernization of enterprise resource planning (ERP) systems, streamlining operations for the Biomedical division's divestiture.● Innovated automated document management solutions, enhancing distribution and reporting efficiencies, and significantly reducing manual workload.● Implemented database integration and automated data exchange protocols to optimize global supply chain and export compliance procedures.● Pioneered the development of a flexible… Show more ● Led the migration and modernization of enterprise resource planning (ERP) systems, streamlining operations for the Biomedical division's divestiture.● Innovated automated document management solutions, enhancing distribution and reporting efficiencies, and significantly reducing manual workload.● Implemented database integration and automated data exchange protocols to optimize global supply chain and export compliance procedures.● Pioneered the development of a flexible e-commerce back-end infrastructure, adapting to diverse sales platforms and improving order fulfillment cycles.● Advocated for and implemented an enterprise-wide analytics and business intelligence platform, advancing data-driven decision-making capabilities. Show less