Angelo F

From system modeling to big data analytics, I am passionate about technological applications that make people's lives easier and information friendlier.

• Report developer and wrangler of data - partnered with engineering, finance, shop floor, and other business units to cleanse and analyze data, then build visualizations and reports using programs such as Power BI and WebFOCUS , e.g., KPI tracking, daily sales trend analysis, part repairs planning, etc. 
• SQL DBA - oversaw 4TB+ data warehouse including entire data pipeline, from initial ETL processing of raw data, to creating complex views and stored procedures for data mining, to writing reports
• Primary owner of enterprise reporting software, supporting 30+ company divisions and 7,500+ users across the globe running 10,000+ reports daily
• Leader of multiple phases of data warehouse development and project life cycle, including project management, conceptualization, programming, testing, and delivery while acting as subject matter expert
• Delivered custom data visualization solutions tailored to business needs and processes, going above and beyond to enhance functionality and features
• Managed Microsoft SQL Server data warehouse and ETL processing for ad hoc reporting and data mining of MRP, time-keeping, project management, budgeting, and manufacturing information
• Re-architected 100+ SSIS packages to eliminate legacy server dependency and expand and streamline data
• Upgraded servers reducing processing time by 30% and service disruptions from 1/month to 18 months uninterrupted; assumed on-call data processing responsibility, handling crises and system contingencies
• Handled major software upgrades, including SQL Server, working closely with business to ensure user satisfaction and compliance with business rules on top of regression and A/B testing
• Worked with .NET development team to build a customized part and customer contract administration tool by developing a normalized SQL back end with data from MRP system along with ETL data feeds
• Collected performance metrics then reallocated memory and also implemented proper indexing, statistics updates, and SARGable queries to tune report and query performance
• Investigated and remedied data and reporting issues by troubleshooting complete back and front end components, from unearthing bad data to reengineering complex reports
• Spearheaded project management efforts by coordinating multiple divisions’ team members, software vendor teams, and independent consultants in major software version upgrades, achieving over 75% cost savings
• Collaborated with users and upper management to gather requirements and construct custom accounting and manufacturing interactive and graphical reports and dashboards
• Enhanced and maintained DML for dynamic SQL Server Agent job creation during ETL; write SQL views, stored procedures, functions
• Administrated WebFOCUS enterprise reporting software, resolving user tickets such as access and data issues
• Converted, consolidated, and decommissioned 150+ legacy and mission critical IBM Cognos reports, improving process efficiencies and heeding business process standardization and automation initiatives
• Adapted, rewrote, and tested disaster recovery plans; planned and performed database migrations and backups
• Liaised with auditors and ensured SOX compliance, such as completing automated user disabling program
• Evaluated new technology such as WebFOCUS upgrades, Power BI, SSRS, and Tableau
• Selected to participate in high performance team and dynamic change leadership training
• Interviewed and assessed job candidates and then onboard and cross train junior team members

Loyola Marymount University, BS in Applied Information Management Systems