SUMMARY:

• Fifteen years of experience delivering decision support solutions via the MicroStrategy Business Intelligence platform.
• Currently working to obtain Version 9.4 certification.
• Advanced functional knowledge of MicroStrategy Developer.
• Experienced Dashboard and Visualization developer.
• Understanding of Dimensional Data Modeling concepts.
• Worked multiple projects as MicroStrategy Architect.
• Certified MicroStrategy Version 9 Project Designer, Report Developer, and Dashboard Developer.

PROFESSIONAL EXPERIENCE:

Confidential, Kansas City, MO

MicroStrategy Developer: BI Applications

Responsibilities:

• Provided front - line Production Support and Report Development in an Agile environment, for both the Consumer and Business Class MicroStrategy projects.
• Led an audit effort for the Bus Class group, resolving dozens of discrepancies with legacy reporting.
• Worked with the Project Re-Design team to identify Dimensional Modeling requirements.

Confidential, Bellaire, TX

MicroStrategy Developer

Responsibilities:

• In a five-week engagement, developed a prototype Daily Sales Report document and dashboard for presentation to the CEO.
• Conducted a cleanup and re-org of the DEV environment.
• Constructed new, and modified existing metrics, filters and reports and oversaw the migration of all development to PROD.

Confidential, Charlotte, NC

MicroStrategy Developer

Responsibilities:

• Re-mapped, data validated and documented all project metrics as part of data conversion effort for the Confidential group.
• Developed several dashboards and reports and documented all object development.
• Prepared objects and submitted forms for migration. Identified data issues.

Confidential, Bellaire, TX

MicroStrategy Developer

Responsibilities:

• Developed a library of reports, graphs, visualizations & dashboards, and alerted the client to critical data issues, identified and fixed numerous architecture errors, and provided end-user training.
• Responsible for all MicroStrategy schema and report development.
• During the current project re-build, conducting detailed data validation against legacy project, identifying a number of issues with the data and schema.
• Reconstructing the legacy report library, and developing dashboard content.
• Meetings with end users to assess their analytic requirements.

Confidential, Washington, DC

MicroStrategy Developer

Responsibilities:

• Constructed a successful prototype project to report on key department-wide performance metrics.
• Developed an interactive dashboard, using inconsistent data from disparate Confidential offices.
• Built all schema and application objects.
• Worked closely with the Phase II consulting team to provide requirements feedback and data modeling recommendations.
• Developed a project to measure participation in the Confidential Neighborhood Networks program.
• Designed the logical model, defined ETL specs, and built all schema and application objects.

Confidential, Charlotte, NC

MicroStrategy Developer

Responsibilities:

• Developed all schema and public objects in support of a Client-level Profitability Reporting initiative.
• Constructed Client Profitability and Revenue Ranking dashboards, including all underlying datasets, filters and metric objects.
• Generated mappings of project data against legacy and ETL systems, and published project documentation.

Confidential, Morrisville, NC

Technical Analyst, Data Warehouse - Business Intelligence

Responsibilities:

• Supported the integration of Dex and Donnelley decision support data onto an enterprise MicroStrategy Business Intelligence platform.
• Issued data conversion and report requirements.
• Participated in data model design.
• Developed and migrated all schema objects, synchronized development environments, resolved production issues and testing defects.
• Conducted audit and cleanup of all project application and schema objects.
• Developed a Users’ Guidebook and delivered individual interface training to end-users.

Confidential, Wilkes-Barre, PA

Technical Analyst, Data Warehouse - Business Intelligence

Responsibilities:

• Managed an effort to audit and synchronize a four-environment Retail Sales analytic platform supporting all Confidential Service branches.
• Conducted object usage and dependency reviews, and supervised two analyst/testers.
• Submitted action plan, project reporting and clean-up proposal.

Confidential, Denver, CO

Senior Database Analyst

Responsibilities:

• Performed all functional life-cycle activities in implementing each Microstrategy analytic mart: published functional requirements; built all Schema and Public objects, including most production reports; project-managed all mart development milestones; conducted individual and classroom end-user training; published detailed project documentation.
• Initiated and project-managed a proof-of-concept effort to demonstrate how Confidential ’s telemarketing campaign management and lead generation could be conducted on Microstrategy BI platform. Defined over 900 telemarketing campaign profiles and all underlying segmentation rules using Microstrategy Desktop filter objects. Leveraged the product’s extraction capabilities to execute lead-generation. The migration of these functions from an in-house application reduced man-hours and the production cycle by 50%, and had significant impact on segmentation accuracy, analytic and reporting power and market responsiveness.
• Developed an automated prospect inventory reporting and audit system, providing the campaign management team with unprecedented report availability and data insight. Designed a highly optimized mart architecture using data aggregation, partitioning, report caching, ETL transformations and table write-backs. Proposed and delivered on an aggressive service level agreement for query responsiveness, guaranteeing results in minutes for even the most complex queries.
• Built thousands of MicroStrategy Schema, Public and Configuration objects since the release of Version 8. Performed user and license administration, production support, problem tracking and resolution of all mart and application issues to a group of 30 power users. Designed and managed an internal reporting web site.
• Designed a lookup table database, delivering robust, accurate metadata in the form of element descriptions and rollups for hundreds of mart attributes. Audit scripts and user-alerts ensured all tables were kept current. Used table views to a centralized database to ensure consistency across all marts. Built dozens of new lookup tables. Defined many new element rollup categories, permitting even more powerful reporting and analytic capabilities to the user community.

Confidential, Golden, CO

Systems Analyst

Responsibilities:

• Developed and conducted system test plans of customer care and billing software platforms for international cellular service providers.
• Executed detailed test scripts, documented test results.
• Identified all software issues and worked with developers to implement resolutions.
• Was part of the implementation team of a large billing software rollout for a french-language cellular provider
• Assisted in the translation of instruction manuals and technical documents.

Confidential, Denver, CO

Data Analyst

Responsibilities:

• Responsible for growing prospect inventory and improving the data accuracy and productivity in the high-value International and In-Language data segments.
• Using language and affinity scoring techniques, doubling the size of the in-language prospect base, while improving lead quality from 65% to 95%.
• Generated in-language and affinity data for six new emerging-market calling campaigns.
• Contributed to a 50% increase in year-end net sales and a 15% improvement in outbound telemarketing sales per hour for the in-language segment.

Confidential, Arlington, VA

Systems Analyst

Responsibilities:

• Responsible for all functional and analytic support of the Private Line commercial billing system, including issuing requirements for and project managing all software development, production support, report audits, issue identification and resolution, and training and roll-out reviews with billing specialist teams.
• Identified and captured over $500k in lost revenue and $50k in subsequent monthly charges through the resolution of over 200 tariff-related billing errors.