SUMMARY:

• 25+ years of experience in IT, with over 15+ years focusing on building BI applications and Data Modeling
• Experience in software analysis, design, and development of applications, providing Business Intelligence solutions using MicroStrategy - Desktop, Web, Intelligence Server, Architect, Mobile, Narrowcast Server and Distribution Services.
• Strong understanding of Data Warehouse concepts, dimensional modeling using various Schemas and Multi-Dimensional Model with respect to query and analysis requirements.
• Expertise in building projects and creating reports using MicroStrategy Desktop and MicroStrategy Web.
• Extensively worked in creating and integrating MicroStrategy reports, cubes, dashboards and objects (Attributes, Filters, Metrics, Facts, Prompts, Custom Group and Consolidations) with the data warehouse.
• Involved in building large warehouses, by gathering data requirements and business rules.
• Developed and maintained the Projects in MicroStrategy for defining the business oriented data structure from the star schemas for various data warehouses.
• Extensively worked on MicroStrategy Administration that includes MicroStrategy Installation, Configuration, Intelligence Server Administration, configuration of Memory settings, Performance monitoring and VLDB Settings.
• Configured the Enterprise Manager for statistical reporting purposes Performed all admin-related tasks in MSTR environment (I-server setup and configuration, user/security administration, project creation, DB connectivity, server clustering, project upgrades from older to newer MicroStrategy Versions, object management, cache management, etc.). Experience from MicroStrategy version 7.0 to 10.4.1 Hotfix 2.
• Worked extensively on Object Manager to move the objects between different environments
• Experience in planning and implementing upgrades across MicroStrategy versions.
• Experience creating and maintaining documentation for technical and non-technical users.
• Experience in unit testing, system testing, customer acceptance testing, and regression testing in release management and upgrade across MicroStrategy versions.

TECHNICAL SKILLS:

DSS/BI Tools: MicroStrategy 7.x/8.x/9.x/9.2.x/9.4.1 HF2/10.2.x HF4 (Administrator, Architect, Intelligence Server, Desktop, Narrowcast Server, Web, Report Services)

Databases: Oracle 12c/9i/8i/7, SQL Server 2000, Teradata V2R5/R4/V10/V13, DB2 UDB, MS Access.

Web Technologies: MS FrontPage, IBM WebSphere, HTML, VBScript, and XML

Software: Microstrategy Developer, Microstrategy Administration and API, NCR Teradata (Data Warehouse), Microsoft Visual Basic, Microsoft SQL Server, Oracle, Microsoft Project, Crystal Reports, Windows Server 2000, PowerBuilder, COBOL, DOS, C, Tuxedo, Sybase, Office XP, DB2, JCL, CA7, FTP, Windows.

Operating Systems: UNIX, Linux, Windows 2000/NT/XP/2005/2008

PROFESSIONAL EXPERIENCE:

Confidential

Technology Project Lead

Responsibilities:

• Researched reporting, development, design, and architecture issues in over 50 production projects with data warehouses in Teradata and Oracle. Needed to step in as a developer, architect and project DBA to correct issues in Development and Production.
• Worked on an existing project to identifying the missing relationships and optimizing the data model for faster performance by suggesting proper indexing and normalizing the data.
• Involved in troubleshooting Microstrategy Web Reports, optimizing the SQL using the VLDB Properties.
• Successfully fulfilled management and leadership responsibilities for a MicroStrategy Administration team, when team leader left suddenly. MicroStrategy team needs 5 team members to support over 100 development teams. With a team of two people, I was able to manage, direct, and implement all daily work requests along with addressing issues and concerns. As new team members were added, trained and mentored each team member to be able to be a fully functioning and effective MicroStrategy Administrator within 4 weeks.
• Successfully stepped into senior technical leader and technology leader roles once the project leader transferred off the team. Under pressure and constricted deadlines with no training or information turnover. Develop and established new lines of communications with upper management and other teams in order to resolve tasks and issues in a timely manner. Without my intervention there would have been many issues and tasks unfinished or resolved.
• Completed daily change control processing which is the process of work requests assigned to the team, process each request to insure it following change control processes and procedures, then assigned the work requests to fellow team members in a timely manner to insure the team member had time to review, implement and send email confirmations when the work was completed. There are about 25 to 30 work requests per day to process along with addressing any questions or concerns about past and future work requests.

Confidential, Eagan MN

MicroStrategy Administrator

Responsibilities:

• Assigned to specific MicroStrategy projects with data warehouses in Teradata and Oracle. Needed to research architecture and design issues, then provide steps for the Development teams to correct issues in object design and development.
• Successfully updated, implemented, and tested SOX controls for MicroStrategy. Provided required SOX artifacts to prove that MicroStrategy Operations team as well as USPS accounting project were SOX compliant. Managed MicroStrategy processes to insure SOX controls successfully completed every time the control is executed. Took additional responsibility to be very involved in the updating of MicroStrategy SOX controls, as well as worked closely with our SOX representatives assigned to our department.
• Completed maintenance and upgrades to MicroStrategy infrastructure which are planned, scheduled and implemented on a monthly, quarterly and yearly basis. Due to continual planning and coordination, the maintenance is completed without any technical issues nor were any unnecessary helpdesk tickets opened during the maintenance windows. This allowed the downstream systems to execute their work tasks without difficulty. For all maintenance windows, they were completed at least an hour or more ahead of schedule. I made sure our systems were down and completely available to the downstream teams for any preliminary work or research. I was also able to address any issues or concerns the downstream teams might have about the MicroStrategy environments and infrastructure.
• Successfully maintained and distributed documentation for the system architecture, change control process, and administration tasks.

Confidential, Franklin Lakes, NJ

• Managed the development and enhancement of a report scheduler software package on a client/server platform, with a Visual Basic frontend, MicroStrategy Server backend and NCR Teradata information warehouse. Package has Microstrategy Objects as middleware and uses Microsoft Excel as the report generator.
• Provide development support and production support for development of new MicroStrategy objects.
• Roles include MicroStrategy Administrator and Architect, as well as, Teradata Performance DBA since I would help identify run-time improvements when generating SQL which is submitted to the Teradata warehouse.
• Increased company’s capacity to introduce new releases from 1 per year to 4 per year. Design, develop, test, coordinate user acceptance testing, and manage production implementations.
• Functions include project planning and reporting, and developing, executing and managing detailed test plans. Use version control management tools such as Visual Source Safe and PVCS. Develop and test installed packages.Senior Application Architect
• Provide customer support and enhancement implementation for new releases.

Confidential

Systems Engineer

Responsibilities:

• Coded, tested and implemented change requests, and developed a separate mail processor for clients that do not have access to the software. Administered production and help desk support for all users and clients.
• Managed the development and enhancement of an issue resolution software package on a client/server platform, with a Visual Basic frontend, Microsoft SQL server as the backend, and Crystal Reports as the report generator.
• Coordinated special projects involving Crystal Reports and Visual Basic for applications to generate new ad hoc reports.

Systems Engineer

Confidential, Atlanta, GA

Responsibilities:

• Provided analysis of the Business Long Distance Message Processing system, including mapping, developing and implementing a vendor coordination procedure, defining, documenting, implementing and managing the entire Post-Production System Integration Testing process, and clearly defining roles and responsibilities related to the process.

Systems Engineer

Confidential

Responsibilities:

• Created a GUI reporting system using PowerBuilder and Microsoft SQL server. F eatures included threshold reports, graphical representation of data, and quick response to user inquiries.
• Transferred a large application system from the Confidential Information Processing Center to an Confidential processing center.
• Administered the analysis, review and move of the application software. Setup and implemented the system, and assisted in the development of production support standards and procedures. Established SOP’s and protocols that allowed gradual reduction of support team from 25 to 2 members.
• Converted a mainframe system to a client server based system.
• Provided daily maintenance of interface and VSAM files, pre- and post-cycle monitoring, emergency data recovery procedures, and customer support.
• Tested and ran complete cycles of quarterly enhancements for a card provisioning system. Created, executed and verified test cases to validate enhancements. Release Coordinator for multiple releases, initialized, maintained and shutdown test environment.
• Developed and maintained testing programs.

Business Associate

Confidential, MI

Responsibilities:

• Provided help desk support for 100 users. Maintained systems for union and non-union personnel, executed shutdown phase of the System Development Life Cycle, and oversaw daily operations.