Functional Skills

Business Analysis
Wealth Management
Performance Management
Data Analysis
Agile Software Development
Data Modeling
Quantitative Research
Digital Transformation
Risk Management
Data Management
Data Transformation
Data Mining
Data Governance
Data Architecture
Business Analytics

Software Skills

MySQL
AWS
Microsoft Excel
SAS
Python
Google Analytics
Linux
SQL
Flask
Data visualization
Database design

Certifications

AWS Certified Cloud Practitioner
Six Sigma Yellow Belt

Sector Experience

Business Services
Financial Services
Real Estate
Technology

Notable Clients

Accenture
Cognizant
Deloitte
Magnit
McKinsey & Company

Bulge Bracket Investment Banks
Fortune 500

Experience

CSI Tech / WorkForce Logiq / Magnit - Remote Data Science / Analytics
Sr. Information Architect
2/2021 - 8/2023
Established enterprise information catalog, standards, policies, strategies and programs aimed to optimize data discovery, valuation, classification, governance, cataloging, data curation, data quality, data lineage, controlled vocabularies, data management, business alignment and minimize risk and operational ineffectiveness.
• Evaluated and recommended Data Governance platforms Microsoft Purview, Dataedo, Collibra, Alation, etc.
• Implemented enterprise semantic layer data governance / metadata, taxonomy management platform supporting on-prem and Azure cloud enterprise data assets, business rules, transformation, lineage, quality, data policy, glossary and compliance regulation
• Aligned business, technology and data architectures to support enterprise initiatives
• Architected enterprise data and reporting platforms using Azure Data Lake, Azure SQL Database MI, Azure Data Factory, Flask/React API, Python, CI/CD, Azure DevOps.
• Member of the Enterprise Data Governance Committee

SmartIMS Inc. Data Science / Analytics
Data Architect – Consultant – Contract Furloughed
1/2020 - 6/2020
Responsible for architecting, designing and implementing data strategies and solutions to support operational Reporting & Analytics, Performance Management, Data Visualization, Data & Text Mining, and Data Governance initiatives.
• Performed data architecture, data modeling and design sessions to ensure optimal operational, data, business and technology alignment
• Implemented Data Integration and Interoperability best practices by ensuring business and technical glossaries, data lineage and dictionaries are developed and maintained
• Ensure data integrity and quality by implementing data quality best practices and performing data analysis, testing, data profiling and implementing data quality processes
• Facilitated requirements gathering sessions, interpreting, analyzing, evaluating and developing required business and technical documents to ensure optimal operational, business Analytics and decision-making in order to innovate and generate a competitive edge

MetLife Information Technology
Manager – Data and Analytics – Digital Office
10/2009 - 5/2019
Managed and architected various $5+ million enterprise insights and visualizations initiatives. Established and implemented strategy, direction, best practices, solutioning and delivery for Disability, Dental, Vision, P&C, and Annuities LOBs and Finance, Marketing and other enterprise areas.
• Rationalized, standardized, cataloged and mapped numerous data sources and thousands of data elements to be compliant with enterprise Data Governance standards via Collibra HTTPS://WWW.LINKEDIN.COM/IN/WILLIAMVILLON/
● • Managed an agile team, including coaching, performance reviews, hiring, firing and promotions; managed onshore and offshore cross functional teams on project basis
• Led enterprise products and channels insights initiative providing statistical, financial, demographic, and operational KPIs in support of national accounts generating 70% of group business revenue and earnings.
• Evaluated and recommended customer experience research vendors; partnered with vendors to implement t

MetLife Data Science / Analytics
Senior Technology Liaison II
10/2009 - 12/2013
Business Intelligence lead responsible for managing business analytics, reporting, and data warehousing teams. Mentored and supervised associates on project and software lifecycle principles and best practices.
• Partnered with business users and IT groups to develop and implement project plans, User Acceptance Test plans, Business Requirements documents, migration plans, functional requirement documents, project road maps, key indicators and metrics, Entity Relationship diagrams, data models, data dictionaries, data lineage, business and technical glossaries, etc.
• Architected and developed MS SQL Server data warehouses and data marts, SSIS data pipelines, self-service dashboards using QlikView, Tableau and SSRS
• Managed support of partner quantitative research / advanced analytics organization including data acquisition, integration, interoperability, data modeling, data mining, transformation, and technical guidance
• Leadership and hands on development of business intelligenc

Better Homes and Gardens Information Technology
Independent Consultant
2/2009 - 7/2009
Solution Architect
• Designed and architected a real estate web based content management system utilized by numerous real estate agents and brokers. Incorporated leading opensource technologies such as Linux, Apache, MySQL, Joomla, and PHP (Hypertext Preprocessor), along with HTML, Flash, and Javascript.
• Solely responsible for all details of the system, including SQL database design, modeling, and management, web server configuration, template integration and modification, PHP development, search engine optimization and Google analytics

Citigroup Information Technology
Assistant Vice President – Sr. Programmer / Analyst
6/1998 - 1/2009
Led all aspects of systems development life cycle (SDLC) including feasibility analysis, business requirements, systems analysis, technical design, database design, ETL processes, systems development, user acceptance testing, change management, production support, and post project review. Established various departmental standards and performance matrix, cultivated strong business and departmental relationships, collaborated on product and process planning.
• Led the reengineering of the Equity / Wealth Management System to be self sufficient and capable of processing in batch mode reducing operational cost and improving performance
• Instrumental in the development of key legacy Equity Management system Web based platform
• Implemented automated stock option exercise delivery process to systematically generate and deliver exercise confirmation statements to clients, brokers, and transfer agents
• Designed and developed an automated financial reporting process which included monthl