SUMMARY:

• Over 25 years experience of production environment management, data and software publishing, business analytics and data warehousing, technical project management, commercial software development, package software implementation, commercial internet site development, business process analysis and redesign, and technical staff management.

TECHNICAL SKILLS:

Hardware/OS: PC systems, Windows 9x/2k/XP, Windows 2003/2008 Server, Router Configuration,Wired & Wireless Networking

Software: Microsoft Office Applications including Access, Visio, Project, Folio Views, WISE Installation Systems, SQL Server 2005/2008/2012 including SSIS, Rbase, Oracle 10i, TOAD, DB2, Visual InterDev, FrontPage, MicroFocus Cobal, Visual Basic 4 thru 6

Packages: Lawson Financials, Adaytum (Cognos) Planning, Cybermation ESP, Kalido, Enterprise Crystal Reporter, Cognos Series 7 PowerPlay / IWR, Cognos Business Intelligence Reporting versions 8 and 10, Cognos TM1

PROFESSIONAL EXPERIENCE:

Confidential

BI/DW Consultant

Responsibilities:

• Participant on project team working on data warehouse redesign for primary source platform, including ETL and database design changes and subsequent reporting impacts. Also supplementing current staff working on maintenance issues and user request backlog.

Confidential

Cognos Developer

Responsibilities:

• Worked in team environment on transformer cube restructures, Cognos BI 10 and BI 8.4 report redesigns, and in the design and development of Cognos Active Report dashboards.

Confidential

BI/DW Systems Analyst

Responsibilities:

• Data Warehouse end - to-end responsibility, including design, development and optimization of the data warehouse staging and production databases on SQL Server 2008.
• ETL design and development utilizing SSIS as well as creating stored procedures, views and sql jobs to accomplish the various ETL requirements for multiple data sources and source platforms, updating 600+ source tables, dimension/fact/aggregate tables and original master dimensions.
• Installation, administration and development of the Business Intelligence Cognos platform, versions 8 thru 10, including reporting package development with Framework, cube development and production with Transformer, and development of hundreds of reports with Reporting Studio.
• Installation, administration and development of the Cognos TM1 platform, version 10, for the annual budgeting process and continuous forecasting process, including import/export processes, dimension and cube design and development.
• 24/7 production support for the entire data warehouse, Cognos BI and TM1 platforms.

Confidential

Sr. Software Architect

Responsibilities:

• Production Support for Crystal Enterprise and Cognos, including server monitoring, OS upgrades, application upgrades and tuning, Crystal Reports development and publishing, SQL Server DTS process support and enhancements.
• Enhancements to and production support for ETL process generating an Oracle datamart and Cognos Powerplay Cubes, used for contract labor invoice reconciliation and reporting.

Confidential

Managing Partner

Responsibilities:

• A lead designer and developer on team customizing Lawson-based Merchandise Payables Match & Reconciliation system for multiple divisions of $12B retailer TJX Companies, utilizing Lawson A/P system, Crystal Enterprise reporting, DB2, Java-based web interface.
• Managed delivery of several projects using offshore resources, including development of a commercial web site and construction of a component for the Notiva ASP service.
• Consulted with retailer ToysRUs for Notiva Match/Recon system implementation.
• Directed company activity in defining/developing internet-based businesses for partners with subject matter experts in Publishing, Insurance, Recruiting and Sales Prospecting.
• Directed company activity operating staff augmentation services in partnership with consulting/staffing companies.
• Performed as Managing Partner, including company formation, legal agreements and partnerships, accounting and tax reporting.

Confidential

Sr. Consultant

Responsibilities:

• Data and process analysis as well as operational support on several projects for Confidential within the Order Management unit. Presented results of customer data analysis, developed automated fulfillment process for establishing law student user ids.
• Joined team at TJX Companies on Lawson merchandise payables project in role emphasizing process analysis and database design.

Confidential

Manager, Commercial Software Team

Responsibilities:

• Managed growth of commercial software unit, growing staff to eleven with tripled revenue.
• Led new product development and design activities, incorporating customer panels for concept and design input and development review.
• Initiated and facilitated first company web site, lead site evolution and development of web-based continuing and fee-based publishing strategy.

Confidential

Reengineering Team, Continuous Improvement Coordinator, Production Team Lead

Responsibilities:

• Participant on 5-person team for redesigning data production flow for company leading to reorganization of over 800 staff and multiple technology projects.
• Coordinated process improvement efforts for 130-member production department, from process design projects to recognition and personnel development systems
• Created production scheduling and measurement analysis system for on-time performance for non-legal production department, covering 600+ publications.