SUMMARY

• Over 15 years of data warehousing and business intelligence experience with strong experience in MicroStrategy products
• Strong ability to quickly master new concepts and capability of working in groups as well as independently
• Well organized, quick learner, self - motivated team player who has the experience in all phases of the System Life Cycling including project definition, analysis, design, development, testing, implementation, and support
• Compelling sense of responsibility, service-minded attitude, proactive attitude, and willing to put forth suggestions to constructive improvement in provision of service, and translating business/functional requirements into technical requirements
• Great analytical, interpersonal, and communication skills with clear understanding of business process flow
• Experience in change management, problem solving, coordinating with other internal development team (if applicable), and mentoring team members
• Excellent knowledge on following industry best standards recommended by MicroStrategy
• Excellent knowledge in working with very large databases like Teradata, Oracle, and SQL Server with MicroStrategy suites

TECHNICAL SKILLS

• MicroStrategy (Versions 6.0-2020; Web, Intelligence Server, Mobile, Narrowcast, Library, Desktop, Developer, Dossier, Report Services, Integrity Mgr, Command Mgr, Objects Mgr
• Enterprise Mgr, Platform Analytics, and Office), Progress 4GL (Versions 5.2J-9.1D), MFG/PRO (Versions 8.6D-9.0 NetUI), ASTEA Dispatch1, ShopperTracker, Adobe, ADS, Neilson
• FedEx, VSI-FAX, Taxware, QlikView, HEAT, BMC Control-M, Tableau, SQL, Teradata, Toad, Teradata SQL Assistant, SQL Management Studio, Oracle 12, DB2
• Microsoft SQL Server 2008/2012/2016. Microsoft Access, Linux, Unix, SCO Open Server, Microsoft Windows 7-10, Microsoft Office Suite

PROFESSIONAL EXPERIENCE

Confidential

Sr. MicroStrategy Analyst/Administrator

Responsibilities:

• Analysis of business and user reporting needs, documentation of requirements, and translation into functional and technical requirement specifications
• Worked with the end users and internal business analysts for data requirements gathering, designing, prioritizing business goals and informational data needs
• Worked closely with DBA’s to conduct any data model, data profiling, or database design and development changes required to support business intelligence projects
• Responsible for installation, configuration, and administration of all MicroStrategy products including MicroStrategy Developer, Intelligence Server, Web Server, Narrowcast Server, Library, Mobile, Platform Analytics, and Enterprise Manager
• Responsible for all aspects of upgrading a MicroStrategy environment from setting up a test upgrade environment that mimics production, performing the upgrade of software, metadata, Narrowcast repository and statistics repository; in addition to using integrity manager to validate the stability of objects and statistics to determine performance issues by testing user interfaces
• Team lead for the upgrade of MicroStrategy from version 9.4.1. to the latest 2020, migrate from Windows Server 2008 to 2016, and the migration of SQL databases from version 2008 to 2016
• Development of MicroStrategy schema and application objects such as attributes, facts, transformations, logical tables, hierarchies, templates, advanced filters, metrics, prompts, consolidations, and custom groups
• Proficient in creating MicroStrategy reports, documents, dashboards, and dossiers in web and developer
• Worked with VLDB settings at report and metric levels to tune the SQL for best performance
• Responsible for all MicroStrategy Narrowcast Server Objects like services, schedules, information objects, information sources, and subscriptions
• Scheduled and published MicroStrategy reports using MicroStrategy Distribution Services and Narrowcast Subscription Services with BMC Control-M
• Coordinated the software development lifecycle with vendor partners and provided support to such projects
• Extensively worked on setting up proper securities using security roles and privileges, security groups, and security filters along with creating end user accounts

Confidential

Sr. MicroStrategy Analyst/Administrator

Responsibilities:

• Responsible for installing and configuring of MicroStrategy products, all MicroStrategy upgrades, and administration of MicroStrategy Intelligence Server, Web Server, Narrowcast Server and Mobile Server
• Gathered requirements from user and converted them to technical specifications
• Expertise in creating complex reports in MicroStrategy Desktop and Web
• Extensively used MicroStrategy Report Services to generate report documents
• Involved in design of an efficient BI Dashboard for the company executives through efficient use of MicroStrategy Report Services and OLAP Services
• Experienced in setting up VLDB properties at different levels to customize SQL generation by MicroStrategy
• Performance monitoring and tuning experience for MicroStrategy

Confidential

Programmer Analyst

Responsibilities:

• Created an interface that consolidated order entry using an order system from PROIV application with an existing MXP application (manufacturing software)
• Upgraded Progress from version 8.3B to version 9.1C
• Setup a test environment for application modification by interfacing a FedEx system to this test environment
• Created and/or modified an existing application, troubleshooting errors, and performed unit/system testing
• Provided the end users and technical staff with assistance