SUMMARY:

Experienced in leadership of teams and hands on development of Business Analytics, Reporting, Business Intelligence solutions, and Data Management, and Systems Integration projects. Wide range of work with Information Architecture, Design, Development, Support and Project Management. Additional areas of focus include Reporting and Visualizations Systems, Portals, Web Apps, Web Dev, Web Analytics and SEO.

KEY SKILLS:

Solution Architect: Lead and Design technical solutions for Business as part of a larger team in a timely and effective manner. Supports project management to manage scope, issues, and escalations. Develop and maintain relationships with Business Organizations. Drive consensus and arbitrate business demands within architecture and in cooperation with business teams or partners. Proof - of-concept prototype and design; demos to customers to elicit feedback and review. Help develop testing, training, and roll out plans. Hands-on, where needed.

Business Systems Analyst, and Technical Systems Analystis: Interacts and presents from C-Level management through all levels of business users and stake holders, both written and verbal means. Lead the translation of Business requirements into successful operational systems, designed to continuously improve as needs evolve. Extensive experience in requirements gathering and analysis, documentation of current and future process design. Creation and review of specifications and requirements documents. Act as subject matter expert throughout the life cycle of the projectInteracts and presents from C-Level management through all levels of business users and stake holders through written and verbal means.

Project Management: Plans out solution implementations and project plans to hit project milestones, functionality, and key deliverable dates. Acts as the communications conduit to executive sponsor; conducts regularly scheduled briefings and status updates. Identify project gaps and critical path elements. Build and maintain plans with PM tools such as MS Project. Ensure that project documentation is produced as required, author same when needed. Direct and supervise in teams or matrixed responsibility environments.

Business Intelligence & Analytics: Develop Key Performance Indicators (KPI), Metrics, Advanced Visualization methods, and Self Service to provide actionable reporting

Tech Lead, Manager: Effectively led/managed teams including direct reports, contract and off-shore people. Directed cross-functional teams to ensure attainment of established objectives.

Systems Integration, Architecture, and Design: Drive use of Rapid prototyping and Agile methodologies to ensure systems solve Business problems. Design, implement, and monitor solutions through successful project delivery.

Data Engineering and Development: Design and enhance End to End ETL/ELT data pipelines, from multiple sources through semantic layers to presentation systems. Deliver closed loop systems to ensure and improve data quality and data integrity using data cleansing and data profiling. Implemented data synchronization, data testing, and data reduction solutions.

Data Architecture: Implement Business-Driven Data Design: Conceptual, Logical, Physical. Develop complete systems and enhancements for Online Analytical Processing (OLAP). .Build and implement Data Management and Data Governance

Scrum Master: Run multiple Scrum Teams in parallel. Worked with Product Owners to maintain backlogs and prioritize User Stories. Tracking of Stories, Scrum boards, tracking assignments. Maintenance of Stories and Reporting using Rally. Assisted with running Kanban groups

Programmer: Experience across multiple languages and scripting, .Net, C++, VBA, Macros, Stored Procedures, MS-Access and Excel programming, T-SQL, D-HTML, XML, CSS, JavaScript, Business Objects (BOBJ), IBI Web Focus, Informatica PowerCenter, Visual Dev

TECHNICAL EXPERTISE:

Web Technologies: MS .Net, (C#, VB), Classic ASP, VBScript, Visual Studio, MS-FrontPage, JavaScript, HTML, D-HTML, XML, CSS, WebTrends, WebPosition

Enterprise Applications/Systems: WebFocus, Cloudera Hadoop, Oracle Exadata, Salesforce, SAP BO R2, 3.1, and 4.1. SAP BODS 4.1, Workbench, Dataloader, Oracle OBI, OBIEE, Informatica PowerCenter, Plumtree 4.5, 4.5ws, 5.0, Hyperion Analyzer and Essbase, Siebel

Database/Systems: MS-SQL, Oracle, T-SQL, SSIS, MS-Access, stored procedures, triggers, database design optimization, and administration.

Business Apps: Mercury LoadRunner

Microsoft Office Suite: Expert level experience in Microsoft Office, especially Excel, Access (MS-Access), Word, and PowerPoint. Including VBA, macros, forms, interoperability, database connectivity, queries, Excel to Access, front ends to SQL Server and other databases

EXPERIENCE:

Confidential, Mason, OH

Architect and Tech Lead

Responsibilities:

• Led the team, collected the current Use Cases and methodologies utilized to create the improved version of the Decision Tree based tool for Legal Disputes.
• Designed the overall architecture; then managed to implement the 4 key elements:
• A Portal to collect and standardize the key inputs and decision points
• An XML schema to flexibly store the information passed from Portal to Excel
• Developed an Excel template with macros to build the tree and provide ways to interact,
• A Tableau instance fed from Excel to produce advanced visualizations
• Engineered a ‘shorthand’ notation to represent the Decision Trees, allowing a concise way to represent complex trees for users and code generation
• Delivered the project on time and on budget using rapid prototyping and Agile methods

Confidential, Cincinnati, OH

Head Business Analyst

Primary Technologies: WebFocus, Cloudera Hadoop, Oracle Exadata, MS Access and Excel

Responsibilities:

• Drove analysis of a key acquisition’s reporting methodology, providing key insights to all layers of the Confidential architecture. Identified that the project consisted of 2 key features not known before.
• Designed and ran new and repeatable QA procedures to identify data integrity issues before User Acceptance Testing
• Authored and maintained key analysis documents used by IT and the Business departments.
• Re-architected an MS-Access based reporting system as part of the migration process, documented the process for IT solutioning, and adding data quality checks to the process
• Ensured the delivery of required features with additional Business Value, beyond Business’ expectations

Confidential, Hartford, CT

Project Lead

Primary Technologies: Business Objects R2, 3.1 and 4.1, Crystal Reports, WebI, and DeskI

Responsibilities:

• Managed team of 7 Developers and Analysts; interface to all Confidential departments
• Designed and maintained a system to generate metrics on the migration of all content (Reports, Instances, Users, Security). This drove programs to trim unneeded content, and accurately identify content to migrate across all of the Lines of Business
• Project delivered to an updated schedule that included requirements changes, to the satisfaction of Confidential IT and the Confidential Lines of Business

Confidential, Hartford, CT

Project Lead

Primary Technologies: Business Objects 3.1 and 4.1, Crystal Reports, VBA, BOBJ SDK

Responsibilities:

• Established a status reporting method to focus on issues, re-establishing customer confidence
• Improved Development Environment testing procedures; reducing the back-flow of failed tests from the QA Test organization, increasing resources available for development
• Directly assisted development efforts to correct the outstanding development issues
• Delivered the upgraded solution of all reports, pixel perfect, to the satisfaction of Confidential

Confidential, Lexington, KY

Project Lead

Primary Technologies: MS-Access and Excel programming, VBA, MS SQL, T-SQL

Responsibilities:

• Managed entire Vendor Assessment program, lead the effort with 2 additional analysts, delivering final presentation on time and on budget
• Designed and developed the anonymized Vendor Test data sets with an automated measuring tool to produce metrics to score the Vendor’s results

Confidential, Lexington, KY

Scrum Master

Primary Technologies: Rally, Salesforce CRM, MS-Access and Excel programming, VBA, T-SQL

Responsibilities:

• Re-established Agile/Scrum Methodology, managing all 6 Development teams initially, a second Scrum Master was added after 6 months
• Organized and ran all meetings (Scrums, Sprint Planning, Grooming, Reviews, and Retrospectives), developing the processes internal to the Agile team, managing the Teams in Rally.
• Developed and maintained a reporting package used across the Teams to monitor performance and analytics beyond the capabilities in Rally
• Improved productivity by 47%, average, across all Teams

Confidential, Lexington, KY

Data Migration/ETL Data Architect

Primary Technologies: SAP (Business Objects Data Services) BODS 4.1, Workbench, Dataloader, MS-Access and Excel programming, VBA, MS SQL, T-SQL

Responsibilities:

• Revamped existing migration methods to provide more accurate processes, including automated result and error logs. Included development of SAP BODS scripts and data flows to standardize messages and provide audit trails.
• Managed team through multiple rounds of migration while the range of data and set of database objects evolved.
• Produced documentation on migration processes to permit transition of the process to resources within Confidential .
• Developed and implemented a Data Quality measurement process to improve the Data Integrity and Quality of the migrated data

Confidential, Maynard, MA

Web Analyst

Primary Technologies: WebTrends 8.5 and 9.0; ODBC and RESTapi, MS-Access and Excel programming, VBA, MS SQL, MS .Net, (VB), JavaScript, D-HTML, XML, CSS

Responsibilities:

• Developed and instituted automated utilities to proactively monitor the processing of web traffic. These tools used both WebTrends ODBC and WebTrends Confidential to alert the team and our customers to problems with both the legacy and the new systems.
• Designed and launched a tool to review QA and Production environments to ensure that the multiple methods using for ‘website tagging’ (WebTrends codes to collect data) remained consistent across product releases and/or evolved according to new specs.
• Built and maintained a common code base, shared across the team and other departments, that provided consistent connectivity to WebTrends backend services, usable in both legacy and cloud-based environments
• Created a series of tools to jointly measure the data integrity of both legacy and cloud-based environments in pre-launch and post-launch environments

Confidential, Boston, MA

Architect, Project Manager, Technical Lead

Primary Technologies: MS SQL, MS-Access and Excel programming, VBA, MS .Net, (VB), Visual Studio, MS-FrontPage, JavaScript, D-HTML, XML, CSS. SharePoint, IIS. MS SQL 2000/2005

Responsibilities:

• Developed Analytics tool allowing for review of Sales and Inventory performance on a daily basis against Monthly planning goals. Flexible, configurable to varied Client data schemas and changes in hierarchies.
• Designed and developed a Business Intelligence tool for analysis of key performance metrics that syncs with a client’s transactional system. Drill down and drill across capabilities to review data across multiple hierarchies. Added capability to ‘scrub’ noisy data for dimension tables, increasing usability of the data.
• Developed and implemented ETL automation tools for data migration of monthly data feeds, increasing data quality above 99.999%
• Led standardization of primary business planning tools (which use an Excel front end); optimizing data storage and display. Also developed tools to auto-generate these same planning tools. This decreased development time required to implement new clients
• Enhanced the standard Excel UI to include interactive graphical capabilities, reducing time to plan data.
• Developed and maintained synchronized copies of customer Transactional Databases to provide custom reporting and adhoc analysis
• Architected and implemented Security and protection controls, providing appropriate layers of access across all tools. Multiple Confidential and Client level access controls implemented.
• Numerous process improvement initiatives to render manual procedures into automated functionality; resulting in reduction in times and increases in data quality.

Confidential, Boston, MA

Business Technical Lead

Primary Technologies: MS .Net, (VB), Visual Studio, MS-FrontPage, JavaScript, HTML, D-HTML, XML, CSS. IIS. MS SQL 2000/2005, Oracle. IBI Web Focus, Informatica PowerCenter

Responsibilities:

• Developed multi-layer schemas to represent current data and planned data environments
• Lead training sessions to the business to promote understanding of how data is modeled in Business Intelligence systems to improve on business requirements
• Authored requirements documents and led discussions on review
• Reviewed architecture and development plans for IT implementation
• Developed and implemented data migration and validation plans to ensure accuracy.
• Authored Reporting layer objects and member of team to review Reporting layer objects

Confidential, Merrimack, NH

Architect, Project Manager, Technical Lead

Primary Technologies: MS .Net, (C#, VB), Classic ASP, VBScript, Visual Studio, MS-FrontPage, JavaScript, HTML, D-HTML, XML, CSS. IIS. MS SQL 2000/2005, Oracle, Informatica PowerCenter

Responsibilities:

• Initial release of product in use within 1 month of project inception, provided multiple functions
• Real time, Historical, Day-to-Day, Analytical, and Metrics based reporting capabilities
• Complete drill down paths to individual ticket details with links to source systems
• Individual personalization of views across common/group oriented reports
• Integration with multiple sources to provide aggregation and reporting for multiple ‘dimensions’
• Chosen as an Early Adopter of Service Level Metrics for ISO/ITIL Certification
• Common Ticket Object Model to provide consistent reporting metrics and calculations
• Flexible, adaptable representation of Geographical, Functional, and Organizational views
• Customer view, Service view and Vendor view reporting, sharing common data and metrics

Confidential, Pittsburgh, PA

Architect, Project Manager, Technical Lead

Primary Technologies: Plumtree 4.5ws, IIS, Bea WebLogic, Analyzer, Essbase, .Net, ASPX, VB, XML, JavaScript, CSS, MS SQL 2000, Oracle

Responsibilities:

• Multiple Hyperion reporting methods (Analyzer Reports, Essbase MDX Query Language) were commonly accessed by a single User Interface through the Plumtree Portal
• Parallel access of up to 8 individual reports at once with a common application of dimensions
• Community managed collections of Reports provide business focus, additionally customizable by users
• Specialized reports provide ‘at a glance’ profitability and growth metrics Interactive controls to allow users to identify successes and weaknesses for further analysis