YONG JOON UH

ad0x8g@r.postjobfree.com

571-***-****

U.S. Citizen / Secret Clearance

OBJECTIVE Certified MicroStrategy Business Intelligence Developer seeking a full-time position in Data Analytics.

SUMMARY OF SKILLS

MicroStrategy Developer with experience working as a MicroStrategy Architect and MicroStrategy Dossier Developer.

Proficient in creating report datasets, report services documents and dossiers with MicroStrategy.

Proficient in MicroStrategy administration including setting up users and user security, and object migrations on an as needed basis.

Proficient in the use of AWS Redshift, AWS S3 bucket, VitaraCharts, Visual Crossing, Excel, Access, Microsoft Project and Microsoft Visio.

Participates in the development of the department’s strategic plans, training materials and tools.

Effectively trains and mentors staff on departmental tools and systems.

Highly experienced in working in an Agile / Scrum environment.

Develop ad-hoc report to the user community and provide unit testing on an as needed basis

Skillful in working with large databases in SQL Server and writing SQL queries used for reporting.

Designed and implemented complex SSIS package to migrate data from multiple data sources.

Created SSIS package to extract, validate and load data into Data warehouse.

An in-depth grasp of SQL reporting, analytics and business intelligence.

Great understanding of database structures, principles, theories and practices.

Utilized JIRA reflect performance and deliverables of tasks.

Excellent communication, analytical, interpersonal, and presentation skills; adept in managing multiple projects simultaneously.

TECHNICAL SKILLS Databases: AWS Redshift, SQL Server, MySQL, MS Access,

GUI/Tools: MicroStrategy 2021 Update 9, 9/10, VitaraCharts, Visual Crossing, MS Visual Studio, MS Project, MS Excel (VBA), Visio, Blue J (Java)

Platforms: Windows7/8/10, Linux

Programming: ASP.NET, PHP, XML, HTML5, Java Script, VBA, Java

CERTIFICATIONS

MicroStrategy Certified Project Designer (CPD) - Version 9

MicroStrategy Certified Report Developer (CRD) - Version 9

MicroStrategy Certified Dashboard and Mobile Designer (CDMD) - Version 9

MicroStrategy Certified Analyst (MCA) Project – MCSA Certification, 10.10

MicroStrategy Certified Designer (MCD) Project – MCMA Certification 10.10

MicroStrategy Certified Platform Administrator (MCPA) Project – MCSAD Certification 10.10

MicroStrategy Certified Master Administrator (MCMAD) Project—MCMAD Certification 10.11

Amazon Web Services – AWS Cloud Practitioner, AWS Certified Solutions Architect (Associate)

TRAINING

AWS Cloud Practitioner, AWS Associate Solutions Architect

Cerstaffix (Certified Staffing Solutions)

Class of SQL Querying – Advanced

Class of Data Modeling and Development

EDUCATION

2010 – 2014 Virginia Tech, Blacksburg VA

Bachelor of Science in Business Information Technology, (Decision Support System)

Dean’s List (2011-2013)

WORK HISTORY

November 2018 – Current SMX Tech, Herndon, VA

Role: MicroStrategy Developer/Administrator

Environment: MSTR 2021 Update 9, AWS Redshift/S3, VitaraChart (5.2.2), Visual Crossing

Perform a wide range of tasks from resolving development/production issues in MicroStrategy platform.

Work extensively on creating Application Objects like Metrics and Compound metrics, Dynamic Filters, Custom Groups and Consolidations for complex reports.

Create Grid, Freeform SQL Reports, Graph and Reports using the Schema (Attributes, Facts) and public objects (Metrics, Filters, Custom Groups, Consolidation, Drill maps, Prompts and derived elements).

Create Level Metrics as per reporting needs and tuned the report SQL as much as possible for better performance.

Involve in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties or at the database level.

Perform MicroStrategy administrative tasks (Intelligent Cubes, cache scripts, etc) to support product delivery.

Create new users for client requesting to have access to BI environment.

Create Migration Packages for objects from Development to Production using Object Manager.

Create testing scripts using Integrity/Command Manager.

Involved in MicroStrategy objects (schema, public, etc) creations/updates for the datasets/dossiers development.

Interact with the customer to define requirements and provide development guidance.

Collaborate cross functionally to achieve customer satisfaction and resolve customer issues in a timely fashion.

October 2017 – 2018 MicroStrategy, Tysons Corner, VA

Role: Technical Support Engineer (Web/Mobile)

Environment: MSTR 9 ~ MSTR 11

Work on technical support cases related to web/mobile

Work with individual engineers and subject matter experts to find high quality, tim ely resolution of customer issue.

Inform Technical Support Management about any escalations or difficult situations that require his/her involvement

Prioritize and communicate product defects and enhancements to development teams

Develop strong technical understanding of all MicroStrategy products.

Execute programs to ensure that MicroStrategy is fully aware of the customer’s adoption level, value realization, and overall satisfaction with the technology solution(s).

Contribute to research and growth of the MicroStrategy Knowledge Base and identify ways to increase customer satisfaction

Accurately document tasks/time in internal systems.

Attend all training courses and workshops by participating in Internal Training Programs

Make sure assigned customers have the best customer experience when engaging Technical Support

April 2014 – August 2017 Altruista Health, Reston, VA

Role: MicroStrategy Developer / SQL Developer

Environment: MSTR 9.4/10.4, SQL Server

Redesign the Schema to a true Star Schema to enable faster development time for report building. Creating mapping documents and other architectural documents to facilitate data modeling.

Involve in upgrading the MicroStrategy 9 version to 10 versions. Executed some sample test before and after the upgrade to verify the successful upgrade.

Constantly gather requirement from clients to modify BRDs to make it easier for developers to create reports.

Troubleshoot issues for clients and testers, assisting with production support tasks.

Create test script for the QA team to test new created reports. Developing test plans for various projects/ task that will be reused and modified as needed based on the requirements.

Unit testing, fixing defects from the QA team.

Work with the ETL team to identify data error on reports (MSTR & Data Warehouse) by locating the source table affected from the previous load and to maintain the data integrity.

Metadata and Unicode testing, before and after migrations and upgrades.

Responsible for Project Duplication in QA and Production environment.

Create Ad Hoc (Complex SQL Extracts) Reports for clients if the report is complex. Training clients on how to create their own Ad Hoc reports.

Create stored procedures in the SQL Server to increase the productivity of the data.

Generated daily, weekly and monthly Ad-hoc reports in SQL Server Reporting Service (SSRS) on the products for the end users.

Contact this candidate