Business Intelligence Lead

• BUSINESS INTELLIGENCE * PROJECT& TECHNICAL LEADERSHIP * INFORMATION GOVERNANCE &ARCHITECTURE
• SUMMARY OF QUALIFICATIONS
• Microsoft BI leader and evangelist. Hands on working knowledge of current and pipeline technologies; BI Semantics, Data Quality Services, Big Data Support (Hadoop), PowerPivot andPowerView, SharePoint Services, metrics\KPI\scorecard driven analytics and management.
• Twenty plus years of data warehouse planning, engineering, and development expertise delivering best in class warehouse solutions and actionable insights for Related Management, AIG, JP Morgan Chase, NCR, Lehman Brothers, Price Waterhouse and AT&T. Architected, designed, built, implemented and managed warehouses with >20TB of data, 20MM customers and 40k users which service >$50B portfolio’s.
• Defined and outlined the EDW strategic planning including roadmap, context diagrams, and process maps. Presented findings to the EDW Executive Board (company Presidents / Vice Presidents) as well as top ISG officials including SIOs and CIOs.
• Creative problem solver/engineer that excels in conceptualizing, analysis, and rapid development of Pre-sales, Proof of Concepts, and prototyping of industry and company specific data/information solutions.
• Working / reporting directly to / with the CIO, CFO, and Director of Operations, initiated, conceptualized, personally developed, and customized an EIS / Dashboard program / approach for President level reporting, broker analysis, and national accounts.
• Information Architect for Data Warehouse (DW) and Business Intelligence (BI) projects; expertise in the design, data modeling methodologies and development for n-tier data warehouses. Hands on implementer / manager of MDM / Data Governance solutions to provide a single version of the truth to be used throughout the organization.

SELECTED CAREER ACHIEVEMENTS

• BUSINESS INTELLIGENCE PROJET & TECHNICAL LEADERSHIP
• As EDW Working Committee Lead scheduled and led meetings, collected requirements, developed consensus among diverse members, led discussions on open issues, provided education about Data Warehouse technology, produced meeting minutes, and made presentations to the ISG / Business Steering Committee.
• Project manager for three simultaneous DW / BI / CRM development efforts for the Health Insurance, Life Insurance, and Airlines industries at NCR. Led weekly project status meeting with both client and project team to track progress toward established milestones. Proactively addressed client issues and concerns, set client expectations, and ensured customer satisfaction.
• Defined and built Information Management Practice: identified and architected IBM Product focus (DataStage, QualityStage, Information Analyzer, and Business Glossary); hired and trained technical team; educated Sales and Solution Directors; handled pre-sales materials and presentations; identified and developed targeted services, solutions and programs

  MICROSOFT BUSINESS INTELLIGENCE

• Technical leadership and has hands on design. Development, monitoring, tuning, and management of integrated ETL (SSIS), Aggregations\Cubes\MDX (SSAS), reporting (SSRS), Excel Pivot Tables, Analysis and Forecasting, SharePoint, Data Governance, and Team Foundation Server.
• Managed in house, regional vendor, and off-shore support and development in a number of industries and large $5million+ multi phased and year projects.
• Adaptation and enhancements of an ETL Framework which is integrated into SSIS packages to control and track execution, time, number of records, control reports, and provide detailed error identification.
• Advanced visualization tools and integrated BI\analytics through the use of Scorecards (Balanced Scorecards, Metrics, Dashboards (3 tiered), Decision Trees, Visio Flow Charts and Diagrams.
• Designed, developed, and architected complete and integrated BI on demand single version of corporate data that has been portioned, aggregated, highly indexed, portioned and secured for use through SharePoint, Excel Services, and Excel Pivot tables through the use of SSAS cubes
• Provided guidance and leadership in the monitoring and enhancement of cubes, measure groups, and reporting platforms\solutions.
• Owned\lead Design, Development, Deployment, Training and Support of SSRS reports and data query systems for standardized corporate reporting and self service BI, regulatory reporting (including Fannie Mae), and Executive Information Systems.
• Advanced development knowledge and hands-on skills in integrating SQL Server, T-SQL, MDX, passing parameters, automation and SharePoint Server and Services.
• Design and development of large 500+ corporate clients, in-house Regional and Project managers, and Senior Executives SharePoint 2010 solution with detailed security, access, navigation, parameterization, and dozens of multi-tiered,linked , and summary and detail reports.
• Design and maintenance of a robust Team Foundation Server application, report and documentation process and document framework\architecture\solution.
• INFORMATION ARCHITECTURE
• Worked in partnership with the AIG DBG Controllers group and CFO to support Financial Data, BI, and Reporting needs. Lead full project life cycle development to provide an N- tier data and reporting solution including Business Case, ROI, Analysis, BRD, Data quality/Mining, Use Cases, Testing, Implementation, and Enhancements.
• Lead the definition, requirements, architecture, master data management and development of corporate post bind, corporate data marts and defined / maintained corporate standards, access, definitions, and integration (MS SQL Server SSIS/DTS jobs/packages) for new data and reporting.
• Identified and documented full project Business Requirements definition, data analysis and Dimensional Modeling. Delivered PoC and pilot for selected Credit Suisse Wealth Manager Group.
• Hands on Project Manager / Lead of the ETL team with DataStage and MetaStage, including product evaluation, training, architecture, and team management. Led Data Governance and One Vision of Data initiatives.
• Conceptualized and Managed Business Information Architect and DW / BI initiative to provide balanced scorecard re-engineering reporting and management of AIG service centers (MS SQL Server/.NET). Integrated and replaced current metrics management reporting with dashboards, data mining, and guided analysis to manage the Financial, Operational, Customer Satisfaction, and Employee perspectives of our service centers.
• DATA GOVERNANCE\MASTER DATA MANAGEMENT
• Hands on BA implementer / manager of MDM / Data Governance solutions to provide a single version of the truth to be used throughout the organization. Designed and administered Control Reports and Routines (tests and balances) to identify missing data, outliers, and corrected in the ETL process.
• Lead Tallan's efforts at Vertrue\Adaptive Marketing to complete BPM\DW\BI requirements, build Bus Matrix, identify and document Conformed Dimensions and Measures, and revised Project Plan for ETL load and analytics initiative.
• Project lead to model, design and build reporting and analytics for Business Process Management (BPM) system (MS SQL Server back end) to control submission and renewal processes and workflow management. Extensive use of market segmentation and analysis to direct daily work efforts to optimize prioritization and forecast / manage performance.
• Defined and built Information Management Practice: identified and architected IBM Product focus (DataStage, QualityStage, Information Analyzer, and Business Glossary); hired and trained technical team; educated Sales and Solution Directors; handled pre-sales materials and presentations; identified and developed targeted services, solutions and programs.
• DATA WAREHOUSE/BUSINESS INTELLIGENCE
• Lead Lehman Brothers Financial Reporting initiative to re-engineer Financial Reporting and Analysis with an Excel based OLAP tool.
• Project lead and full SDLC architectural design and review for Data Management and Operations for Wealth Manager Project (Oracle 9i and vendor product - XEYE/Wealth Manager).
• Performed extensive Data Mining analysis on Analyst/Management queries and usage to improve performance and provide batch reporting and identify risks and problems when they first appeared.
• Expert knowledge and experience with Visio/BPMN/UML architecture and process/data/systems flow development/ documentation to illustrate current and future end states for multi-million dollar corporate initiatives in Regulatory Reporting, Operations Re-engineering, Systems Architecture, and Financial Projects.

SELECTED Experience

Confidential FEB 2012 - CURRENT
Microsoft BI Manager (consultant)

• Microsoft BI Lead (SQL 2008 r2 and 2012) to design and build integrated SSIS\SSAS\PowerPivot Master Data Services and Balanced Scorecard solution for dynamic International Pharmaceutical company linking Financial, Clinical Trials, Sales, Customer and Internal perspectives.

Confidential Aug 2010 –JAN 2012
Business Intelligence Specialist

• Lead integrated business and technical\application team to provide required Fannie Mae quarterly reporting through the design and development of an integrated Excel\SQL Server (stored procedures) and dashboard Cash Flow reporting.
• Supported and enhanced Fannie Mae and Affordable Properties (200+ properties 80,000+ units) Financial and Operational dashboards, reporting (i.e., Income Statement, Balance Sheet, Cash Flow, NOI, exception reporting, Lead a team of on and off shore developers to enhance and support existing ETL, Cubes, Reports, Security, Access, and Operational Guidance.
• Under direction of the CFO designed\architected a Data Governance program of Data Stewards, Processes, Views, Control Tables, SharePoint lists, and single

Confidential Aug 2009 – Feb 2010

Sr. Technology Consultant, Business Intelligence Applications

• Managed DW\BI ETL team supporting our various clients and system architecture. Designed and implemented enhancements to the ETL, Recon, and data marts to support analytics, analysis, and reporting.
• Designed and prototyped scorecard\dashboard management reporting systems for pre-sales efforts and future corporate vision.
• Liaison between Data Warehouse team, client, and front end systems group. Identified required enhancements, architecture, ETL, and Use Cases\testing.

Confidential Jun 2009 – Aug 2009

Consultant, Manager Data Warehousing and Business Intelligence,

• Managed the rollout, training, and support of an integrated MS Cube/Excel Pivot table reporting solution.
• Managed vendor development, support, identified\generated requirements, tested and evaluated enhancements.

Confidential Oct 2000 – Jun 2007

Project Manager Systems Design / Development, Business Intelligence Technical Solutions Group

• Lead the acquisition of the EDW from Sales and Marketing and its redesign as an Operational EDW with 26 underwriting systems, diverse platforms (databases), vendors, products, and reporting requirements while providing a consolidated view of the overall business and still provide/support the individual business data and reporting needs and perspectives.
• Served as both the Business and Technical leads for the EDW, diverse business leaders, IT – architecture, DBA’s, BA’s, ETL (DataStage) and Reporting (Cognos). Developed and Maintained multi-year roadmaps, wrote\championed all business cases ($5million+ per year), negotiated\resolved priorities, schedules and EDW evolution.
• Led project to model, design and build reporting and analytics for Business Process Management (BPM) system (MS SQL Server back end) to control submission and renewal processes and workflow management. Extensive use of market segmentation and analysis to direct daily work efforts to optimize prioritization and forecast / manage performance.
• Defined and outlined the EDW strategic planning including roadmap, context diagrams, and process maps. Presented findings to the EDW Executive Board (company Presidents / Vice Presidents) as well as top ISG officials including our SIO and CIOs.

PROFESSIONAL EXPERIENCE

BUSINESS INTELLIGENCE CONSULTANT Feb 2012 – Present
Confidential Parsippany, NJ
BUSINESS INTELLIGENCE STAFF SPECIALIST Aug 2010 –Jan 2012
Confidential NYC, NY
SENIOR CONSULTANT - Training May 2010 –July 2010
Confidential NYC, NY
TECHNICAL LEAD - CONSULTANT Aug 2009 – Feb 2010
Confidential Morristown, NJ
CONSULTING Jun 2007 – Aug 2009
Confidential NJ/NY
PROJECT MANAGER SYSTEMS DESIGN/DEVELOPMENT Oct 2000 – Jun 2007
Confidential Jersey City, NJ
DATA WAREHOUSING - CONSULTANT Jan 2000 – Oct 2000
Confidential Somerville, NJ
PROJECT MANAGER - CONSULTANT Jun 1999 – Dec 1999
Confidential Iselin, NJ
ASSISTANT VICE PRESIDENT, FINANCIAL REPORTING Sep 1998 - May 1999
Confidential Jersey City, NJ

EDUCATION

BA, Sociology,