Candidate Information Title Business Intelligence Sql Server Target Location US-VA-Fairfax Email Available with paid plan Phone Available with paid plan	20,000+ Fresh Resumes Monthly     View Phone Numbers     Receive Resume E-mail Alerts     Post Jobs Free     Link your Free Jobs Page     ... and much more Register on Jobvertise Free
Search 2 million Resumes Keywords: City or Zip:	Related Resumes

YONG JOON UHEMAIL AVAILABLEPHONE NUMBER AVAILABLEU.S. Citizen / Secret ClearanceOBJECTIVE Certified MicroStrategy Business Intelligence Developer seeking a full-time position in Data Analytics.SUMMARY OF SKILLSMicroStrategy 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 departments 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 basisSkillful 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, LinuxProgramming: ASP.NET, PHP, XML, HTML5, Java Script, VBA, JavaCERTIFICATIONSMicroStrategy Certified Project Designer (CPD) - Version 9MicroStrategy Certified Report Developer (CRD) - Version 9MicroStrategy Certified Dashboard and Mobile Designer (CDMD) - Version 9MicroStrategy Certified Analyst (MCA) Project  MCSA Certification, 10.10MicroStrategy Certified Designer (MCD) Project  MCMA Certification 10.10MicroStrategy Certified Platform Administrator (MCPA) Project  MCSAD Certification 10.10MicroStrategy Certified Master Administrator (MCMAD) ProjectMCMAD Certification 10.11Amazon Web Services  AWS Cloud Practitioner, AWS Certified Solutions Architect (Associate)TRAININGAWS Cloud Practitioner, AWS Associate Solutions ArchitectCerstaffix (Certified Staffing Solutions)Class of SQL Querying  AdvancedClass of Data Modeling and DevelopmentEDUCATION2010  2014 Virginia Tech, Blacksburg VABachelor of Science in Business Information Technology, (Decision Support System)Deans List (2011-2013)WORK HISTORYNovember 2018  Current SMX Tech, Herndon, VARole: MicroStrategy Developer/AdministratorEnvironment: MSTR 2021 Update 9, AWS Redshift/S3, VitaraChart (5.2.2), Visual CrossingPerform 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, VARole: Technical Support Engineer (Web/Mobile)Environment: MSTR 9 ~ MSTR 11Work on technical support cases related to web/mobileWork 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 involvementPrioritize and communicate product defects and enhancements to development teamsDevelop strong technical understanding of all MicroStrategy products.Execute programs to ensure that MicroStrategy is fully aware of the customers 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 satisfactionAccurately document tasks/time in internal systems.Attend all training courses and workshops by participating in Internal Training ProgramsMake sure assigned customers have the best customer experience when engaging Technical SupportApril 2014  August 2017 Altruista Health, Reston, VARole: MicroStrategy Developer / SQL DeveloperEnvironment: MSTR 9.4/10.4, SQL ServerRedesign 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.