S A M E R G E R I E S H

703-***-**** adj767@r.postjobfree.com

C A R E E R S U M M A R Y

PROFESSIONAL SUMMARY

• Business Intelligence and Data Warehousing certified professional with 16+ years of experience, specializing in MicroStrategy Enterprise suite, among other BI tools in development, integration and administration.

• MicroStrategy experience includes:

Architect/Developer: Design and develop MicroStrategy BI solutions BI Engineer: Implement and integrate BI product Suite Support Engineer: Maintain and support BI product Suite Administrator: Upgrade and enhance up to and including v 2020

• Exceptional analytical and troubleshooting abilities with past experience as overall systems Tier 3 support

• Expertise in data architecture, integrity and maintenance

• Easily able to function in a client-facing role and serve as liaison between client and technical teams

• Strong oral and written communication abilities, including deep technical documentation experience

• Adept at training both end users and technical teams as well as mentoring new team members P R O F E S S I O N A L E X P E R I E N C E

District of Columbia Government (OCTO), Washington, D.C Feb 19- Current Senior MicroStrategy Consultant

• Supported optimization of Redshift database for MicroStrategy Server and developed an implementation plan on enhancing performance on the Server/Application and Database level.

• Create, manage, and delete users and groups as per the request using Amazon Identity and Access Management.

• Updated MicroStrategy enterprise to 2020 in all environments including (DEV, TEST, and PRD).

• Design and manage multiple agencies MSTR dashboard/BI solution including Metadata, Data Source(s), database queries/performance tuning, MSTR/REST/API/JSON calls, SDK implementation and all dashboards/reports.

• Supported the Data Mart Business Intelligence Team in the Information Technology Services

• (ITS) Department.

• Migrated 15 existing Tableau reports to Microstrategy.

• Integrated tableau directly as a data source in the MicroStrrategy Application to access all reports.

Environment: MicroStrategy v2019, Oracle 11g, JDK1.6, CentOS, FLUME, HBase, Maven, Map- Reduce, Hadoop, Hive, Pig, Sqoop, Oozie, Zookeeper, AWS, UNIX, Linux

\

National Aeronautics and Space Administration (NASA), Washington D.C. Sept 17- Feb 19 Business Intelligent Architect

• Support the modernization of applications for deployment to the NASA HQ Managed AWS Cloud environment.

• Involved in source control management with GitHub and GitLab Enterprise level repositories. Regular activities include configure user’s access levels, monitor logs, identifying merge conflicts and managing master repository.

• Migrated SAP Business Objects and Crystal/BO Reports to MicroStrategy BI Platform for SIERA (System for International External Relations Agreements) and HATS (Headquarters Action Tracking System) NASA Systems.

• The deliverable included printing Open Overdue Executive Orders Reports from the White house and automating delivering it to all the recipients’ Federal department/agency's POC.

• Responsible for designing and developing components used by all applications that are integrated into NASA’s new single sign-on system, a process called Access LaunchPad.

• Work with Quality Assurance (QA) team to ensure quality software is delivered to the customer Other responsibilities include presenting ideas to the team in well-organized and concise manner. Environment: SAP Business Objects 3.1, Crystal Reports 2008, MicroStrategy v10.5, SAS 9.2, GreenPlum, SQL SERVER 2012, Oracle 11g

General Services Administration (GSA), Washington D.C. Aug 16 – Sept 17 Sr. Business Intelligence Developer

• Lead the support request of Federal Acquisition Service Office within the GSA to upgrade the Back-Engine legacy system used for data extraction of SAM.gov to MicroStrategy 10.3 Software. Upgrade efforts included development of new custom reports, standardizing the federal organization labeling across the new SAM.gov

& enforce the DADA Act standards.

• Analyzed Cassandra database and compared it with other open-source NoSQL databases to find which one of them better suites the current requirement.

• Established security authentication for an I-Server and a Web Server using SSL.

• Collaborated with different Federal Department Agency’s Stakeholders, IAE & Business Development to apply strategy, and enhance operations to understand and anticipate the MicroStrategy Reporting requirements of the federal government to match those requirements to firm’s capabilities for both existing and new BI Tool

system.

• Installed and configured an Intelligence Server, a Web Server, and 3 Mobile Servers (MicroStrategy 10.3).

• Designed multiple Python packages that were used within the processes to load 2TB of data from an existing Oracle database into a new PostgreSQL cluster.

Environment: MicroStrategy v10.3, SQL SERVER 2012, Oracle 11g Transportation Services Administration (TSA), Arlington, VA Jan 15- Sept 17 Sr. Business Intelligence Architect

• Lead a team to program, develop, and maintain the Performance Measurement Information System (PMIS), and supporting applications. The enterprise system allows TSA headquarters to collect and analyze mission critical performance, operational, and security information from over 450 airports and 14,000 users throughout the United States. The system consists of SQL Server databases, front-end web interfaces in ASP.NET, web services, mobile interfaces, desktop support applications, and ETL processes.

• Worked on a large enterprise database used by over 450 federalize airports. The database consists of over 450 tables, 1500 stored procedures, collects millions of data records of data monthly, and has ETL processes transferring information into TSA’s Oracle data warehouse used for Business Intelligence reporting. Utilized best practices in database design by implementing keys, relationships, indexes, triggers, functions, views, and stored procedures to maximize database performance and data integrity.

• Supported the request of custom reports and data extraction by using complex ad-hoc database queries and the MicroStrategy Business Intelligence Tool. Created MicroStrategy Objects such as Reports, Dashboards, filters, and metrics. Many of these reports are used in presentations to Congress, press releases, and TSA headquarters/field airports to determine airport policies and operations. The MicroStrategy implementation used at the TSA was ranked by Computer World to be among the top 5 implementations of Business Intelligence, and saves the TSA over $100 million annually.

• Upgraded 4 servers from MicroStrategy 9.2.1 to 10.2 (2 Web servers and 2 Intelligence servers). DHS

(Department of Homeland Security): TSA (Transportation Security Administration)

• Lead a team to program, develop, and maintain the Performance Measurement Information System (PMIS), and supporting applications. The enterprise system allows TSA headquarters to collect and analyze mission critical performance, operational, and security information from over 450 airports and 14,000 users throughout the United States. The system consists of SQL Server databases, front-end web interfaces in ASP.NET, web services, mobile interfaces, desktop support applications, and ETL processes.

• Built Intelligent Cubes and set them up for optimal complex document performance in need of 20,000,000+

• records.

• Gathered, analyzed, and documented functional and technical system requirements for enhancing existing application modules (Used enterprise manager).

• Supported the performance optimization of data aggregation and real-time reporting (Analyzed SQL at run- time).

• Coordinated the development and migration of new application capabilities for deployment into the production modules (Used object manager, system manager, and project merge). Environment: Microstrategy v10.1, Oracle 10/11g, DataStage 9.1 US Department of State (DoS), Arlington, VA July 13- Jan 15 Senior MicroStrategy Consultant

• Audited the MicroStrategy environment and brought the application’s infrastructure back within compliance with the application’s license policies.

• Configured the environment’s security to meet the client's requirements through developing and creating security roles and groups. In addition, through customizing individual user privileges.

• Configured and connected a new intelligence server as the staging environment.

• Successfully resolved numerous impediments to the SDLC by troubleshooting the intelligence servers’

• configurations, the metadatas, and database connections (Oracle and Redshift).

• Migrated all the application and schema objects as well as project source configurations throughout the SDLC

• using Project Merge as well as Object Manager. As an architect and developer, I have:

• Pulled in new data warehouse tables as well as updated pre-existing ones.

• Refined the environment by re-architecting attributes and facts and mapping them to the proper tables and table columns. Also, by rebuilding pre-existing metrics to ensure they display the correct values based on the required grain-levels.

• Created various attributes, facts, hierarchies, transformations, table aliases, metrics, filters, and

• prompts for two complex dashboards.

• Created a complex document dashboard per user requirement with multiple layouts, panel stacks, panels, selectors, grids, and graphs for a project. In addition, developed schema and application objects for another project.

• Successfully performed troubleshooting on multiple reports and fixed them (through schema re-architecting, application objects re-developing, or re-configuring the VLDB settings). Environment: Microstrategy v9.2, SQL SERVER 2008, Oracle 10g Vision Chain, Washington, DC Aug 11-July 13

Sr. Business Intelligence Engineer

• Developed highly visual dynamic Dashboards/ OLAP Report Services Documents that provided insight into Lead the implementation of one of the company's largest multi-retailer demand signal repository solutions for numerous Fortune 500 companies including PepsiCo, Coca Cola, Bayer, Heinz, Rubbermaid, Danone, Closet Maid, Kellogg's, Frito-Lays, Quakers and Nestlé.

• Lead the development of an inventory void tracking solution for a large consumer beverage company, resulting in the recapture of lost sales due to distribution voids across several retailers.

• Oversaw the on-boarding and integration of extended offshore development teams, including the development of a new sprint based workflow process for capturing customer work, and assigning that work across a matrix team structure.

Environment: Microstrategy v8, v9.2 SQL SERVER 2008, Oracle 10g, Teradata, DB2, Informatica Power Center MicroStrategy, Tysons Corner, VA Jan 04- Aug 11

Business Intelligence Support Engineer

• Manage all technical aspects of MicroStrategy Business Intelligence implementation for high- visibility companies. Companies include Apple, Amazon, Facebook, Best Buy, E-Harmony and Guess.

• Ensure the success of existing clients and cultivate relationships with prospective clients by highlighting value of MicroStrategy platform through customized demonstrations.

• Facilitate the customer's continued familiarity and expertise using MicroStrategy software by: monitoring and supporting ongoing projects; solving business problems; delivering classes of up to 30 participants; driving innovation within the business unit.

Environment: MicroStrategy v8, v9.0.1, SQL SERVER 2005, Oracle 9g, Teradata, DB2, Sybase, MS Access T E C H I N C A L S K I L L S S U M M A R Y

Databases: MS SQL Server 2008,R2/2012, Oracle 9/10/11g, Sybase, Greenplum, Hadoop. BI Platform Tools: MicroStrategy v10.6, SAS v9.4, Spark/Cognos, Tableau. Operating Systems: Windows 9x/XP/2000/Server 2012, UNIX, Linux, Active Directory, Mac OS X Languages: SQL, HTML5, XML, Java/ JavaScript, PHP, Perl, C, C++, Hardware Platform: Cisco, HP, VMWare, Blackberry, VPN\Citrix, Remote Support and Microsoft products D E G R E E S A N D C E R T I F I C A T E S

EDUCATION

Strayer University, Alexandria, VA

Master of Science in Business Administration

expected 2021

George Mason University, Fairfax, VA

Bachelor of Science in Computer Engineering

2008

TRAINING/CERTIFICATION(S)

MicroStrategy 9.4.1. (MCD certified) 2014

MicroStrategy 9.4.1. (MCE certified) 2014

MicroStrategy 9.4.1. (MCEP certified) 2014

Personal and Professional References Available Upon Request

Contact this candidate