SUMMARY

• 10+ years as Senior Architect in MicroStrategy/BI development of business data warehouse systems. Complete BI project life - cycle development and experience in Administration, Architecture in a variety of vertical industries including SEC, Investment Banking, Hospitality, Insurance, Manufacturing etc.
• Extensive hands-on experience in the design, development, implementation, and administration of MicroStrategy technologies (up to MicroStrategy 2020) and enterprise data warehousing
• Extensive database and SQL skills of experience of data modeling and store procedure development to support the Mobile/ Web dashboards and reporting. Familiar with various database including but not limited to Oracle database, SQL server database, Amazon Redshift, Teradata, Sybase, Netezza, Access, SharePoint, DB2 etc.
• Thorough understandings of the MicroStrategy tool itself and its best practices. Extensive experience working with MicroStrategy products, including MicroStrategy Architect, Desktop, Web, Mobile, Object Manager, Enterprise Manager, Command Manager, and Distribution/Transaction/Report Services.
• Design, develop, validate, and maintain Tableau function reports based on user requirements including data visualization using Cross Tabs, Heat Maps and Geographic Map.
• Excellent problem solving, analytical and interpersonal skills; a self-starter and a team player. Effective verbal and oral communications with IT and business audiences and significant experience with collecting and discussing inputs at the appropriate level of detail and drive towards a consensus.

TECHNICAL SKILLS

Business Intelligence: MicroStrategy 2020/2019, IBM SPSS; SAP Business Objects 11; Tableau; Appian

Programming language: SQL, Python, PL/SQL, HTML, SOQL

RDBMS: Netezza; Oracle 11g, Teradata, SQL Server, Sybase, My SQL, Microsoft SSIS, Salesforce, Amazon Redshift

Cloud Environment: Amazon Web Services (AWS), Microsoft Azure

Query Tools: Aginity Workbench, SQL Server Management Studio; SQL Developer; Teradata SQL Assistant

ETL: Informatica Power Center 8.x/9.x, SQL Loader, SSIS, IBM InfoSphere DataStage

Data Modeling Tool: Erwin, Microsoft Visio

PROFESSIONAL EXPERIENCE

Senior MicroStrategy Architect/Mobile and Web Developer

Confidential

Responsibilities:

• Lead the development team of 5 to develop schema objects, supporting datasets and dashboards on top of the source data database or operational data warehouse. The development process is engaging an agile-based development sprint (2-months) for each project.
• Customized HTML scripts in the HTML container to implement wild-card search to pass through SQL queries statements into Free Form SQL Report executions against database system and return expected formalized report result back to the front end solutions.
• Extensively applied URL API to pass portfolio parameters such as ticker symbol or selector elements into to HTML link to display real-time stock chart page in the HTML container.
• Rich hands-on experiences on Web Dashboards/Documents/Dossiers developments by Data Blending, optimizing structure by reducing unnecessary datasets/metrics/panels, sizing space by filter panels, incorporating business image and background, Information Windows and links between summary and granular level reports.
• Created pixel-perfect Mobile dashboard on iPhone for Corporate Events as a prototype which includes selectors for Industry dimensions across all the public companies and provided controlling button/image on Portfolio/Operating/Financial panels with graph matrix display. Enable advanced threshold to display different metric ranges.
• Design and develop the database tables and stored procedures to fulfill the requirements with complicated transactional process and workflow beyond out of box MicroStrategy capabilities.
• Communicate with the shareholder for their business requirement and provide consultancy to design customized analytical solution to meet their requirements.

Environment: MicroStrategy 2020/2019; Oracle Client11g/10g; Netezza: SQL Server ; ServiceNow.

Solution Architect

Confidential

Responsibilities:

• Provide insightful evaluations in project SOW to identify the replication process of the BO architecture into MicroStrategy with best practices. Detailed project research includes assessing the objects classes and amounts, investigating the table join behaviors and the system hierarchy redesign.
• Fully transform bulky SAP Business Object components including Dimensions, Measures, Universes as well as Reports into MicroStrategy schema and public objects by implementing MicroStrategy Command Manager tasks through customized scripts.
• Loads of work on interactive Report Service Documents development, mobile and web dashboards with use of tooltips and highly customized features like subtotal, alerts, derived metrics, conditional formatting, drill maps etc. Create Data Visualization reports using Bar Graphs, Pie charts, trend lines for data analysis and use various MicroStrategy widgets including heat map, data cloud, fish-eye selectors and slide bars.
• Design and create Visual Insight dashboard using Interactive bubble chart with numerous components and merge it into RSD using layout import function to achieve fully integrated functions across.
• Develop fully-prompted reports to facilitate user’s ad-hoc reporting requirements. Create custom group and consolidation objects to diversify reporting functions. Also use Passthrough, ApplySimple functions and attribute-to-attribute relationship filters to build custom attributes and metrics to fulfill reporting complex.
• Identify approaches to rationalize several reports in BO into a single MicroStrategy document. Develop and deliver the MicroStrategy reports that replace several MIDR BO reports and showcases the rationalization approach identified.

Environment: MicroStrategy 10.4; SAP Business Object 11; Windows 7; Linux OS; Oracle Client11g/10g; SQL Developer; ServiceNow.