Sign in

Business Intelligence Professional

Morristown, New Jersey, 07960, United States
January 31, 2018

Contact this candidate

Business Intelligence Professional

Professional Summary

Manager, Business Intelligence Business Intelligence Leader VP, Business Intelligence Director, Business Intelligence

MicroStrategy 7.2 – 10.4 Business Objects XI R3 Oracle 7 – 11g SQL, SQL Plus, PL/SQL SQL Server Personal Computers, Intel Servers LINUX iPhone, iPad, Android

MicroStrategy Reporting Lead MicroStrategy Mobile Lead Senior Consultant, Business Intelligence Architect MicroStrategy Custom Training Creator Data Warehouse, Data Mart Creator Streamlined Oracle Administration Optimized Oracle Databases by 40% Improved ETL Success by 35% Improved ETL Time by 62%

MicroStrategy Certified Engineering Principal (MCEP) Oracle 9i Certified Associate “Count On Me” Award 2013 Constellation Award 2014

Professional Experience

Xoriant Corporation, Sunnyvale, California Mar 2016 – Jan 2018

Senior MicroStrategy Architect and Reporting Lead Consultant Citi, Warren, New Jersey

Facilitated the identification, definition, and documentation of client needs and will decide as to which MicroStrategy functionality will best support the customer's long and short-term needs.

Acted as client liaison to support ad-hoc demonstrations and interactive design sessions with client on 4 projects.

Led a team of 1 onshore and 3 offshore MicroStrategy developers.

Acted as a part analyst, developer, and lead working with clients extensively on 4 projects.

Created 12,000 supporting metadata objects, reports, and dashboards using the latest version of MicroStrategy.

WinterWyman, New York, New York Jan 2016 – Mar 2016

Senior Mobile Business Intelligence Consultant Coach, New York, New York

Was responsible for leading the strategic design and maintenance of business intelligence applications. Identified, researched, and resolved technical problems.

Ensured that the use of business intelligence applications enhanced business decision-making capabilities with 3 mobile applications.

Familiar with a variety of the field's concepts, practices, and procedures. Relied on extensive experience and judgment to plan and accomplish goals with 3 mobile applications.

A wide degree of creativity and latitude was expected when creating 10 to 20 graphic images.

Performed a variety of tasks; fixed 5 to 10 bugs.

Wyndham Hotel Group, Parsippany, New Jersey Sept 2012 – Nov 2015

Manager, Business Intelligence Development

My key requirements were the ability to not only lead a team but to understand the strategy and objectives of each business organization and interpret their vision, description or objective while being able to make recommendations or suggestions on how to use data to be more successful.

Managed a team of 3 to 4 MicroStrategy Developers and subsequent development of applications, dashboards, reports, and tools to enable the operational teams to interpret an opportunity, identify a problem or understand more about a business scenario.

Was also responsible for the team’s development pipeline as well as holding each developer accountable to timelines, budget, deliverables and high standards. Quality improved 50%.

This unique position is responsible for mentoring and developing the BI Team of 20 with regards to functional capabilities and training on new features of the MicroStrategy toolset.

Worked closely with the Enterprise Data Architecture team and Database Administrators as an integral contributor to the model that promotes a service based, centralized solution that correlates multiple KPI’s and exposes through a single point of access for 25 to 50 projects.

Software By Design, Inc., Rye Brook, New York Jul 2010 – Sept 2012

Senior Consultant, Business Intelligence Architect

Responsible for leading the strategic design and maintenance of business intelligence applications. Identifies, researches, and resolves technical problems. Familiar with a variety of the field's concepts, practices, and procedures. Relies on extensive experience and judgment to plan and accomplish goals. Leads and directs the work of others. Obtained MicroStrategy 9 Certified Project Designer (CPD), Certified Report Developer (CRD), Certified Document Developer (CDD), MicroStrategy Certified Developer (MCD), MicroStrategy Certified Engines Specialist (CES), the MicroStrategy Certified Platform Administrator (CPA), and MicroStrategy Certified Engineering Principal (MCEP) certifications.

Olympus Surgical Technologies America, Southborough, Massachusetts Jun 2012 – Sept 2012

Created a MicroStrategy Mobile iPad executive dashboard based on Revenue, Gross Margin, Backorder, Booking and Shipping, and Cost Center subject areas. The subject areas included a variety of key performance indicators represented by simple to advanced visualizations. Performance objectives were achieved by implementing MicroStrategy Intelligent Cubes. Mentored staff on dashboard creation, iPad implementation, and iCube implementation.

Brandeis University, Waltham, Massachusetts Apr 2012 – May 2012

MicroStrategy Change Management Recommendation: The MicroStrategy Administrator requested an extensive analysis of three change management techniques they were considering streamlining their growing 9.2.1 environment due to limited staff. Shortcuts, Hybrid, and Without Shortcuts. Outlined the different strategies for managing user access to MicroStrategy Objects and the associated workflows needed to carry out typical tasks in the context of each strategy for their environment. The Hybrid approach was the most efficient for the administrator.

Custom MicroStrategy User Training: Composed two custom MicroStrategy Web training classes that are administered by Brandeis staff, Consumer or End User and Creator or Power User Training. The custom training cost 50% less than directly from MicroStrategy. The Consumer Training consisted of Getting Started, Executing Reports & Documents, Manipulating an Executed Report, and Other Interactions with a Report. The Creator Training consisted of Attributes and Hierarchies, Modifying Existing Reports, Creating Existing Reports, Ad Hoc Analysis Using Visual Insight, and working with Custom Groups, Filters, and Prompts.

Custom MicroStrategy Object Manager Training: Based on the previous MicroStrategy Change Management Recommendation assignment, composed “MicroStrategy Object Manager Recommendations for Brandeis University”. The custom training cost 50% less than directly from MicroStrategy. This document summarizes The Application Lifecycle, MicroStrategy’s Methodology, Overview of Object Manager and different strategies for using Object Manager to duplicate projects or propagate objects from a single origin project to additional projects.

Diageo North America, Norwalk, Connecticut Jul 2011 – Apr 2012

Reporting And Decommissioning F12 North American Restructuring Program: Led a team of 3 junior to senior MicroStrategy resources from analysis through implementation. Completed this very aggressive, short timeline project before deadline and under budget.

MicroStrategy Bug and Performance Remediation: Identified and corrected 5 MicroStrategy hierarchy architecture flaws correcting many errant grid reports. Identified and corrected 3 attributes causing inefficient query generation and inaccurate results.

Provided expertise in the development of MicroStrategy Dashboards, functionality, designed and quoted effort for the new version(s) of the Sales and Marketing dashboard consisting of 30 pages.

Investment Technology Group, Inc. (ITG), New York, New York Mar 2011 – Jul 2011

ITG Net® Execution Transparency Reporting: Architected the solution from the analysis, MicroStrategy multi-fact POC, logical design, conformed dimension database design, database implementation, ETL design, and MicroStrategy design through MicroStrategy implementation enabling enhanced analysis and insight for customers to increase customer base and volume by 10%.

Indication of Interest (IOI) Messaging System Reporting Migration: Performed analysis and design for migrating the semi-manual Excel statistical reporting to MicroStrategy enabling enhanced analysis and insight to increase customer base and volume by 10%.

Connections Reporting Migration: Performed analysis, design, and POC for migrating the semi-manual Excel statistical reporting to MicroStrategy enabling enhanced analysis and insight to increase customer base and volume by 10%.

Starwood Hotels and Resorts, White Plains, New York Jul 2010 – Mar 2011

Sellers Performance Report Book Automation: Converted a 10-tab, 15 report Excel spreadsheet to MicroStrategy 8 Report Services Document. It took the SME about a week or two to manually create the entire report. Completely automated the process by creating this report in MicroStrategy Web. This resulted in savings of multiple staff weeks as now the report is available the instant the books are closed at the end of the month.

Sales Performance Report Book Automation: Converted a 15 tab, 55 reports, 39 graphs Excel spreadsheet to MicroStrategy 8 Report Services Document. Originally this report was put together manually by a subject matter expert by running queries directly against the warehouse. Once again completely automated the process by creating this report in MicroStrategy Web. The conversion involved evaluating the client’s current MicroStrategy implementation and adding more attributes and metrics as needed for the report. The task consisted of creating some very complex Report Services Document structures to meet the client’s formatting needs.

AIG Enterprise Risk Management, New York, New York Jul 2007 – Jul 2010

Senior Database Administrator, Operations and Systems Sept 2008 – Jul 2010

In addition to Change Management activities, became responsible for all Development (DEV), Quality Assurance (QA), User Acceptance Testing (UAT), and Production (PROD) databases. Provide 24x7 support. Worked with developers to troubleshoot and tune their code.

Directed and mentored 2 onshore Sr. DBA and DBA consultants and 3 offshore DBA members.

Immediate Remediation: Identified Oracle users that were taking up lots of storage and reduced it by 10%. Identified 150 GB of orphaned Oracle data files and removed them.

Preventative Maintenance: Proactively recommended and implemented a preventive maintenance and tuning such as following the "DBA Checklist". Some batch processes now complete 40% faster.

New Hardware Upgrades: Pointed out hardware capacity issues. Replaced two Sun Fire 15K servers with four Sun Sparc M5000 servers. Participated in planning and implementation resulting in a 40% performance improvement.

Senior Database Administrator, Change Management Jul 2007 – Sept 2008

Deployed Oracle and SQL Server software into 4 Quality Assurance (QA), 2 User Acceptance Testing (UAT), and 1 Production (PROD) databases in a timely and accurate manner. Worked with developers to diagnose, correct, and improve software deployment issues.

Database Environment Refresh (Baseline): Led the initiative to standardize and document the process of database baseline which significantly improved its efficiency and reduced the level of errors by 20%.

Oracle Software Deployment Automation: Automated and fine-tuned Oracle software deployments resulting in 30% gain in efficiency.

Oracle Software Deployment Replication: Created methodology and standards for replicating or synchronizing Oracle software deployments into all Quality Assurance (QA) databases once the software has been deployed and verified in Production (PROD). Reduced preparation time by 15% for QA tests.

CommonHealth, Parsippany, New Jersey Aug 2005 – May 2007

Business Intelligence Analyst

Scoped, planned, prioritized, directed, and implemented Business Intelligence and Data Warehousing. Managed all aspects of warehouse and presentation such as data sourcing, migration, quality, design, and database administration. Developed and implemented security and integrity policies and procedures and resolved database performance and capacity issues.

Improved data load success rate from 60% to 95%, a 35% improvement, by implementing configuration changes and introducing daily maintenance.

Reduced data load time from 13 hrs. to 5 hrs., a 62% improvement, by upgrading hardware, O/S, Ascential DataStage, MicroStrategy, and additional configuration changes.


Montclair State University, Montclair, New Jersey 1997

Bachelor of Science, Computer Science (Dean’s List)

County College Of Morris, Randolph, New Jersey 1987

Associate Degree, Computer Technology (Dean’s List)

Contact this candidate