At NBCUniversal’s Ad Sales Technical Product Management Team, I play a key role in connecting data analytics solutions with our business growth strategies. My focus has been on managing the development of data analytics and business intelligence solutions, from their conceptualization to full implementation, specifically within the Ad Sales sector.Key Contributions:★ Solutions Design: I've been responsible for designing and implementing technology solutions that improve our Ad Sales operations. This involved making sure requirements were clearly defined and that our technology practices enhanced our software development processes.★ Data Product Lifecycle Management: I've led the management of various Analytics and Data Products in different stages of their lifecycle, from initial ideas to ready-for-market products. This process included thorough engagement with the Ad Sales ecosystem to ensure our products meet and adapt to market needs and tech developments.★ Strategic Alignment: My role involved aligning our product development plans with NBCUniversal’s business strategies and technology frameworks, ensuring our efforts support both immediate objectives and long-term goals.★ Data-driven decision-making: My skills in AWS, Snowflake, and BI tools like MicroStrategy, Tableau, and Power BI have been crucial for conducting detailed data analysis. These analyses have informed our product development, allowing us to make decisions based on solid data insights.

★ Strategic Data Product and Solutions Management: Led business-critical applications, delivering comprehensive insights and streamlining processes that contributed significantly to organizational success, driving data-driven decision-making.★ Cloud Migration Leadership: Successfully managed the migration of on-premises applications and data to AWS, enhancing scalability and improving operational efficiency, ensuring a seamless transition to cloud infrastructure.★ Automation of Critical Application: Spearheaded the automation of a business-critical application that managed duplicate commitments from mortgage lenders. The automation completely eliminated frequent human errors and freed up a full-time employee and an intern in the process, allowing the process to be completed before the start of the business day, as opposed to the previous manual completion by the end of the day with two dedicated resources.★ Innovative Calculations Automation: Pioneered the automation of pull-through and hedge factor calculations, significantly reducing manual effort and optimizing key processes within the organization.★ Custom Report and Dashboard Development: Designed and developed custom reports and interactive dashboards using Business Intelligence tools, empowering stakeholders with actionable insights and improving operational efficiency.★ Mentorship and Team Leadership: Played a pivotal role in mentoring team members, fostering a collaborative environment, and guiding the team towards excellence in delivering high-quality results.★ Stakeholder Collaboration: Acted as a liaison between traders, business stakeholders and the development team, ensuring clear communication and alignment on project goals, which led to successful project outcomes.★ Talent Acquisition: Collaborated with hiring teams, participating in interviews, and contributing to the acquisition of skilled professionals, strengthening the team with top talent.

Tools & Technologies: Tableau Desktop, Tableau Server, SQL Server, SQL Server Reporting Services (SSRS), SQL Server Integration Services(SSIS), Microsoft Dynamics AX, Advanced Excel, Service Now, Redmine, WhereScape Red★ Led Data Migration Project: Spearheaded the full lifecycle of a data migration project, transitioning from cube-based reporting systems to data lake-based systems. Managed all phases from planning to implementation, ensuring seamless integration and improved reporting efficiency.★ Enhanced Cowboys Merchandising Catalog: Led the design and development of a state-of-the-art catalog for Cowboys merchandising, featuring images, weblinks, webforms, and a direct ordering system. This innovation increased customer satisfaction by 15% and improved sales revenue by 10%.★ Enhanced Reporting and Analytics: Improved existing reports and introduced new analytics to provide visibility to the business by leveraging Business Intelligence (BI) tools and metrics, driving actionable insights for decision-making.★ Managed and Optimized Data Warehouse & BI Solutions: Supported the implementation of DW/BI solutions by monitoring and tuning queries, managing data loads, and addressing user questions related to data integrity. Actively monitored performance and communicated functional and technical issues to ensure smooth operations.★ Designed and Developed ETL Processes: Designed and implemented ETL processes to support the population of the Enterprise Data Warehouse (EDW), ensuring efficient data movement and integration using SSIS and SQL Server.

Technologies: SQL Server Reporting Services (SSRS), SQL Database, SQL Server Integration Services, Tableau, Python, Microsoft Access, Advanced Excel, ASP .NET, C#, JavaScript, Visio★ Designed and Developed Advanced Reports: Created multi-parameterized, drill-down, drill-through, sub, and linked reports using complex formulas with MS SSRS, leveraging expertise in Business Intelligence and Data Visualization for effective reporting and decision-making.★ Handled sensitive Personally Identifiable Information (PII) by following best practices for data protection, including masking, encryption, and strict access control, while adhering to industry-specific compliance regulations such as GDPR and HIPAA.★ Developed BI tools: Built a C# .NET-based web application and a portable Windows desktop application to gather and manage data of fixed assets and consolidate data of thousands of assets, documents, and tax questionnaires in automated fashion.★ Developed ACH File Decryption Tool: Created a BI tool for a banking client to decrypt encrypted ACH files for daily transfers in accordance with provided encryption keys, ensuring secure and efficient processing of financial transactions using Data Security protocols.★ Automated Tax Team Processes: Automated tax team workflows, including remediation checks, data validation, and report scheduling, significantly improving efficiency through Process Automation and Python scripting.★ Performed Ad-Hoc ETL and Data Analysis: Executed ad-hoc ETL, analysis, and reporting on large datasets, using SQL and Tableau, showcasing skills in Data Analysis, Business Intelligence, and ETL Processes.

★ Performed Extensive Data Mining: Conducted in-depth data mining on comprehensive corporate client files to maximize their tax credit potential, utilizing Data Analytics and Business Intelligence (BI) tools.★ Extracted, Transformed, and Loaded (ETL): Managed large-scale ETL processes to extract, transform, and load massive datasets, ensuring data quality and performance, with a strong focus on Data Warehousing and Data Management.★ Data Profiling and Quality Assurance: Profiled data to evaluate quality, integrity, accuracy, and completeness, ensuring Data Profiling and Quality Assurance practices were upheld to meet business needs.★ Developed ETL Tools and Scripts: Created tools, scripts, queries, and applications to streamline ETL processes, driving improvements in Software Development and Business Process Improvement.★ Data Security Analysis: Analyzed data security risks and implemented preventative solutions, focusing on safeguarding sensitive information and enhancing Data Security protocols.★ Troubleshot Proprietary Software: Identified bugs and troubleshot issues during software releases, demonstrating strong Problem Solving and Software Development skills.★ Client and IT Collaboration: Interfaced with clients and IT teams to manage data transfer protocols and processes (FTP, SFTP, Parcelpost), emphasizing Cross-functional Collaboration and Stakeholder Management.

Tools Used: Visual Studio, SQL Server 2005 Express, Microsoft Visio, SSRS, Crystal Reports, RedHat SQL Dependency Tracker, Adobe Photoshop and Adobe FireworksTechnologies: SQL, ASP .NET, SSRS, Ajax, HTML, CSS★ Redesigned SQL Server 2005 Database: Redesigned a database consisting of 200 tables for the Work Management System (WMS) of Garland Water Utilities. Established foreign key constraints between related tables and normalized the database, optimizing data storage and overall efficiency.★ Impact Analysis and Dependency Recording: Conducted a comprehensive Impact Analysis and recorded dependencies between database objects while planning for a new database system.★ Developed ASP .NET Web Reporting Pages: Designed and developed ASP .NET web reporting pages to meet business requirements, enhancing internal reporting capabilities.★ Improved User Interface: Designed and created interactive features and graphical buttons using Adobe Photoshop and Fireworks for the company’s internal website, improving the user interface and experience.★ Documented System Pages: Documented the system pages of the company’s Work Management System (WMS), ensuring clarity and consistency for future reference.

★ Developed a Membership Database: Gathered requirements and built a comprehensive membership database to manage registration details and member information.★ Maintained and Enhanced Web Applications: Ensured smooth operation of web applications by performing regular updates, bug fixes, and implementing feature enhancements.★ Led Testing Efforts: Conducted thorough testing, including unit and system testing, while engaging end-users for feedback to ensure the functionality of web applications.★ Designed Monthly Newsletters: Created and developed content for monthly newsletters, ensuring clear communication and engagement with the membership community.★ Event Coordination: Assisted in organizing banquets, seminars, and other events, contributing to smooth event operations and successful outcomes.★ Managed Communications: Handled email correspondence, phone calls, and in-person inquiries to address member concerns and ensure efficient office operations.

★ The Recovery-Oriented Computing (ROC) project was a joint Berkeley/Stanford research project that investigated novel techniques for building highly-dependable Internet services.★ Conducted analysis on the viability of Disaster Recovery Oriented Computing for the client Netwatch Solutions Inc.

Accomplishment: Promoted to Senior Software Engineer within the first year of being a software engineer.★ Developed an automated test suite for Video Graphics APIs of Advanced TV Set-Top Boxes using C/C++ in a UNIX/Linux environment.★ Designed a graphical user interface for Set-Top Box applications.★ Gathered requirements from various stakeholders and conducted feasibility analyses for system enhancements, ensuring the implementation aligned with business needs.★ Automated the execution of test cases and managed code integration for new releases, improving efficiency and reducing manual intervention.★ Conducted gap analysis to assess discrepancies between current functionality and desired outcomes. This involved: * Identified areas requiring development or enhancements. * Proposed technical solutions to address gaps, ensuring alignment with business goals and technical feasibility. * Collaborated with the development team to prioritize gap resolution, ensuring alignment with release schedules and project timelines. This systematic approach helped drive product evolution while maintaining technical efficiency and meeting business objectives.