Senior Consultant

Posted on by kwitt

2000 – 2001

Painted Word

Boston, MA

Senior Consultant

Served as Data Architect and Lead Consultant on high-profile Business Intelligence (BI) and Data Warehousing projects for Fortune 500 clients, including General Electric (Corporate Offices), Liberty Mutual, Prudential Securities, Fidelity, and CVS. Led the design, development, and implementation of enterprise-scale data solutions, ensuring strategic alignment with business objectives and technology frameworks.

Key Responsibilities:

  • Led data architecture and modeling efforts for large-scale Data Warehouses, Data Marts, and Clickstream Analytics platforms, providing actionable insights for decision-making.
  • Designed and implemented Meta Data Repositories to improve data lineage, governance, and accessibility across enterprise systems.
  • Developed and optimized ETL pipelines, integrating structured and unstructured data from diverse sources into centralized data warehouses.
  • Implemented Hyperion Essbase to enhance multi-dimensional analytics and financial reporting, improving enterprise decision-making.
  • Spearheaded clickstream data warehouse initiatives, utilizing Hyperion Web Site Analytics to enable advanced user behavior tracking, digital engagement insights, and web traffic analysis.
  • Provided strategic guidance on ETL tool selection, implementation, and optimization, ensuring efficient data extraction, transformation, and loading across multiple environments.
  • Designed and built custom reporting applications, leveraging Microsoft SQL Server, Crystal Reports, and WebLogic-based solutions for enterprise reporting needs.
  • Led cross-functional teams in Agile/Scrum environments, promoting collaboration, rapid iteration, and continuous improvement.
  • Worked closely with client leadership and stakeholders to define BI strategies, implement Master Data Management (MDM) frameworks, and ensure data governance best practices.
  • Provided technical leadership in full Software Development Lifecycle (SDLC) implementations, from requirements gathering and architecture design to deployment and support.

Technologies & Tools:

  • Databases: Microsoft SQL Server, Oracle
  • Business Intelligence & Reporting: Hyperion Essbase, Crystal Reports
  • ETL & Data Integration: Various ETL tools for data extraction, transformation, and loading
  • Clickstream Analytics: Hyperion Web Site Analytics for real-time visitor tracking and behavioral analytics
  • Data Governance & MDM: Meta Data Repositories, Master Data Management solutions
  • Agile & SDLC: Scrum, Agile methodologies, Visio for system design
  • Enterprise Data Management: Data Warehousing, Data Modeling, Data Marts

This role reinforced expertise in enterprise data architecture, business intelligence, data analytics, and governance, setting the foundation for future leadership in data strategy, engineering, and advanced analytics solutions.

Leave a Reply