Senior MicroStrategy BI Architect, Lead

Scott Lee – Senior BI Application Developer, Tech Lead

703-***-****, **********@*****.***

*SUMMARY

Senior Business Intelligence (BI) Solution professional with experience in full life cycle of BI Application Development bridging customer data and business group by leading the team performing data modeling and design, architecture, report visualization in Business Intelligence solutions to meet various business requirements.

*QUALIFICATIONS:

Senior BI solution role leading the project to meet the business client requirements and the project stakeholder’s expectation with deliverables.

Advisory services in BI Application development in SDLC.

Competitive problem-solving skills with strong analysis.

18 years of experience with wide product knowledge for all MicroStrategy products.

Ability to set balanced priorities with effective time-management skills.

Hands-on technical skills in dashboard and report visualization for BI solution.

Excellent understanding of data model with strong SQL skill ETL between OLTP and OLAP.

Passionate personality to bring positive energy to the team and the department.

Excellent communications skills.

*EXPERIENCE

Senior BI Application Lead, Federal Reserve System Dec 2013 - Present

Leading the project success as a team to meet the complicated business requirements with minimizing the gap between internal management and business user expectation.

Leading the business requirements to set the client expectation with immediate understanding of the detail level of efforts within the team’s resource.

Translating Business Requirement into technical data model design, planning, and developing with the project plan.

Performing Architect role as reports/schema/dashboard/report services document/dossier/transaction service development.

Using SQL server for table/view/stored procedure development in dimensional data model supporting as backend data for MicroStrategy schema.

Working in a complete SDLC with DEV, QA, UAT, Contingency, and Production environments.

Web custom plug-in using SDK for minor cosmetic changes.

Assisting MSTR admin for Object Manager and tuning MicroStrategy projects and Intelligence/Web Servers.

User Security with Active Directory.

User Activity statistics with MicroStrategy Enterprise Manager and Command Manager. Sr. MicroStrategy Admin/Architect/Developer, CSOSA May 2013 – Dec 2013

Providing Architect service and advisory roles for the employee performance reporting system powered by MicroStrategy visualization.

Admin/Tuning MicroStrategy projects and Intelligence/Web Servers.

Install/upgrade Enterprise Manager.

Setup MicroStrategy user/data/folder level security. MicroStrategy Architect/Developer, CACI Aug 2008 - May 2013

Building MicroStrategy reports/Dashboards/Report Services document/schema development for expenditure/trend analysis

OLAP script development to feed MicroStrategy reports/documents.

MicroStrategy Project Development with designing complex MicroStrategy schema.

Web Single Sign-On with SiteMinder authenticated security objects.

MicroStrategy 9 migration and testing including MicroStrategy Mobile server

Data level security per user group by using Security Filter in MicroStrategy.

LDIF script for LDAP server for User security in Single Sign-On.

MicroStrategy Project promotion using Object/Command Manager from Dev thru Production system.

Analyzing DB tables to increase MicroStrategy query efficiency. Senior Support Engineer, Technical Support, MicroStrategy April 2003 – Aug 2008

Providing complex and challenging technical support for MicroStrategy's premium level customers with multiple clustered environments.

Supporting customers’ business requirements with MicroStrategy development and sizing with multi-tenancy.

Maintaining customers’ backup MicroStrategy environments.

Analyzing customers’ data model.

Developing technical knowledge of all products.

Identifying critical product enhancements/defects for customers upgrade schedule.

Mentoring new members of team.

Motivating peers and new engineers with enthusiastic personality.

Working in a strong team environment to provide on-going support to customers in a wide variety of industries.

Building Technical knowledge of MicroStrategy Desktop, Server, Narrowcast, and Web products.

Prioritizing product defects and enhancements to MicroStrategy Technology teams.

Contributing to growth of the MicroStrategy Knowledge Base by creating Technical documentation of all technical solutions.

Internal Project development using MicroStrategy Products including reports, documents, Dashboards, and MicroStrategy Narrowcast development. Web Application Developer, IT Services, Mississippi State Univ. May 2002 – Dec 2002

Maintained school websites in the Division of Student Affairs at Mississippi State University.

Skills: SQL, PHP, ASP, SQL server, MS office.

Web/DB Application Developer, SAIC, New Orleans, LA Aug 2001 – May 2002

Developed/maintained the internal project team websites.

Maintained data/backup/restore two SQL servers.

Designed the internal project status reports using query and SQL server and posted them to Website.

Provided technical support for business analysts.

* TECHNICAL SKILLS:

Application Development and Business Intelligence Experience (18 years):

-MicroStrategy 11.x, Report/Dashboard/Visual Insight/Transaction Service/Schema development,

-Developer/Desktop/Enterprise Manager/Integrity and Object Manager tools/SDK Editor,

-Mobile/Intelligence Server/Web configuration with clustering Certification: MicroStrategy MCE 9.0.3

Web (7 years): ASP, .NET, JDK, Java, JavaScript, XML, XSL, HTML, SharePoint Single Sign On (2 years): LDAP, Active Directory, SiteMinder Web Application server (7 years): IIS, WebLogic, Tomcat, Sun One Data/Database (17 years): SQL, SQL server, Oracle, Teradata, Netezza, DB2, MS Access OS (7 years): Linux, Sun One, AIX, Windows, Windows Server

*EDUCATION:

Master of Science in Information Systems, GPA 3.4, Mississippi State Univ., Aug 2000- Dec 2002

Contact this candidate