We provide IT Staff Augmentation Services!

Senior Microstrategy Architect And Reporting Lead Consultant Resume

Sunnyvale, CaliforniA

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%

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, California

Senior MicroStrategy Architect and Reporting Lead Consultant

Responsibilities:

  • 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.

Confidential, New York, New York

Senior Mobile Business Intelligence Consultant

Responsibilities:

  • 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.

Confidential, Parsippany, New Jersey

Manager, Business Intelligence Development

Responsibilities:

  • 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.

Confidential, Rye Brook, New York

Senior Consultant, Business Intelligence Architect

Responsibilities:

  • 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.
  • 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.

Confidential, Waltham, Massachusetts

Responsibilities:

  • 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.
  • 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.
  • Based on the previous MicroStrategy Change Management Recommendation assignment, composed. 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.

Confidential, Norwalk, Connecticut

Senior Database Administrator

Responsibilities:

  • 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.

Confidential, New York, New York

Senior Database Administrator

Responsibilities:

  • 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%.
  • 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%.
  • 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%.

Confidential, White Plains, New York

Senior Database Administrator

Responsibilities:

  • 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.
  • 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.

Confidential, New York, New York

Senior Database Administrator, Operations and Systems

Responsibilities:

  • Directed and mentored 2 onshore Sr. DBA and DBA consultants and 3 offshore DBA members.
  • 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.
  • Proactively recommended and implemented a preventive maintenance and tuning such as following the "DBA Checklist". Some batch processes now complete 40% faster.
  • 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.
  • 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.
  • 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%.
  • Automated and fine-tuned Oracle software deployments resulting in 30% gain in efficiency.
  • 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.

Confidential, Parsippany, New Jersey

Business Intelligence Analyst

Responsibilities:

  • 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.

Hire Now