SUMMARY:

• Over six years of IT consulting experience in business intelligence, enterprise data warehousing and ETL in multiple industries including retail and consumer products, food services, automotive, IT services, and financial services.
• Expertise in the design, development, integration, administration and testing of Business Intelligence (BI) solutions built upon MicroStrategy platform and product suite including logical and physical data modeling, project design and architecture, report and dashboard development, performance tuning and troubleshooting, UI customization using SDK, system administration and Production support.
• Experience in implementing all phases of the System Development Life Cycle (SDLC), including business requirements gathering, design, development, testing, and implementation of client - server, multi-tier, Web (Internet/Intranet), and data warehousing/OLAP applications.
• Extensive knowledge of SQL, relational databases, data modeling, ETL and web based applications.
• Experience with data visualization and analytics using BI tools, JavaScript libraries and frameworks.

TECHNICAL SKILLS:

BI: MicroStrategy 8.x/9.x/10.x, Tableau

Data Warehouse/ETL: Teradata, Netezza, SQL Server, Oracle, Informatica, SSIS, Talend

Data Modeling Tool: Visio, Erwin

Programming: SQL, PL/SQL, HTML, CSS, JavaScript, R, Python, Java, PHP, XML, XSL

Others: SPSS, Microsoft Project, Photoshop, Illustrator, InDesign

PROFESSIONAL EXPERIENCE:

Confidential,MI

Sr. MicroStrategy Consultant

• Responsible for maintaining and monitoring performance of existing BI solutions and developing new objects pertaining to new data or new reports/dashboards. Maintain existing reports/dashboards in PROD environment and work on enhancements of the existing reports/dashboards. Work with PM, ETL developers and business users to prioritize business requirements, administer projects and create new objects.
• Develop documents/dashboards for visualization; create drill maps and enable drilling to drill and recover data at different geo levels. Create mobile dashboards in both offline and online mode and apply security authentication function on mobile app through single sign-on using form based authentication.
• Create data visualization and analysis using Visual Insight. Provide Visual Insight training for business users and design Intelligence Cubes to support Visual Insight users.
• Perform optimization of report SQL queries by tuning VLDB properties at database instance, report, attribute and metric level, such as tuning SQL join type to achieve outer joins between attributes and metrics, intermediate table types and table join types for best performance with multi-pass SQL queries, as well as pre/post-string to add additional criteria and set distribution key to tune the performance in Teradata.
• Customize the interface of MicroStrategy Web with MicroStrategy SDK by creating new plugins. Utilize pageConfig.xml and styleCatalog.xml files. Build image carousel using JavaScript and jQuery to enable users to preview the dashboards or reports while hovering over icons of dashboards or reports before running them.
• Re-structure one MicroStrategy project which has data modeling defects. Resolve the many-to-many data relationship using common child attributes. Fix ragged hierarchies by inserting “artificial” data elements. Use logical tables to create role attributes. Streamline metrics creation process using base formulas to improve objects re-usability and reduce maintenance cost.
• Prepare Migration List to list MicroStrategy objects for each major release or defect fixes. Assist the MicroStrategy Admin to perform MicroStrategy project duplication and object migration.

Confidential,MI

MicroStrategy Developer

• Responsible for developing MicroStrategy schema objects and application objects, and troubleshooting existing reports and documents within both MicroStrategy level and database level.
• Prepared and presented wireframe or prototype reports and dashboards to end users and get acceptance to develop reports and dashboards.
• Created dashboards with various selector styles, DHTML wizards, and HTML container to satisfy business users.
• Configured MicroStrategy Mobile and developed mobile dashboards utilizing heat map widget, microcharts widget, time series widget, data cloud widget, data selection widget, interactive selectors, grid/graph, panel stacks, multiple tabs and allowing drilling from high level dashboards and scorecards to detailed reports.
• Tuned the performance of dashboards using Intelligence Cubes, caching, filter selectors, VLDB properties, etc. Monitored users’ action to improve the performance of Intelligence Cubes using Cube Advisor and Enterprise Manager.
• Designed and modified the table and data structure of database to make it more efficient and robust for reporting.
• Designed and implemented ETL mappings and workflows using Talend for loading data from multiple source systems to targets, including: delimited text files, Excel files, JSON, XML, Microsoft SQL Server, Netezza.
• Utilized MicroStrategy R Integration Pack to create metrics for data analysis and data mining.
• Involved in MicroStrategy administrative tasks. Created and managed users and groups using User Manager. Participated in the migration management across DEV/UAT/PROD environments using Object Manager and Project Merge Wizard.
• Involved in testing and validating report data with data analysts. Used Integrity Manager to verify report SQL and validate report data between two environments after object migration.

Confidential,MI

MicroStrategy Consultant

• Closely worked with DBA, data modelers, ETL developers and the validation team to streamline development process, understand requirements and data patterns, resolve problems and provide production support from Beta 2.0 to 3.0 Releases. Fixed issues identified by MicroStrategy Team and Report Validation team.
• Actively investigated various options for performance tuning to avoid the compromise of performance by utilizing MicroStrategy OLAP Services, Intelligent Cube, VLDB properties and data warehouse aggregate tables. Optimized query performance by experimenting and configuring VLDB properties in MicroStrategy.
• Designed proof of concept (POC) dashboards to improve operational performance in MicroStrategy 9.4.1. Provided headquarter users with demos on the dashboard design and functionality.
• Data modeling and data marts design based on business requirements for streaming data at the detail (staging) and aggregation (analytics) level in Oracle 11g environment.
• Integrated 50 new tables into one MicroStrategy project that already has over 300 tables. Created new facts and attributes. Updated existing facts and attributes. Used logical views to support role attributes, user hierarchies to support global drilling in the application.
• Reviewed the detailed system specifications to better understand business process and users’ requirements. Created MicroStrategy report mockups in Excel and reviewed them with System Engineer and Validation Team. Identified key performance indicators and business logics. Custom-designed drill-maps for reports and dashboards.
• Built supply chain cost analysis dashboard to help evaluate supply chain performance of manufacture procedure. Made changes to the initial reports, and created additional reports based on feedback of users for cost analysis, project planning and resource management.
• Performed production support for troubleshooting and resolution of ongoing issues. Provided post-production support for multiple projects and for end-users up to senior management teams. Closely worked with system DBA on database performance tunings and investigation of SQL query execution plan. Reported and monitored multiple data alarms including the 100% data coalescing and aggregate processing to ensure data quality. Worked with ETL developers to troubleshoot data problems.

Confidential,NM

MicroStrategy Developer

• Worked with MicroStrategy Team to fulfill the full Systems Development Life Cycle (SDLC) including requirements gathering, documentation design, data preparation, development work in DEV environment, POC presentations, developer unit testing, data validation and user manual preparation. Worked with MicroStrategy Admin in the UAT and PROD migration process, and suggested to set up a pre-UAT environment to make the process more seamless. Also assisted QA in creating Testing plan for MicroStrategy UAT testing.
• Involved in dimensional data modeling (snowflake, star schema), data architecture, and data analysis. Created public objects including filters, prompts, metrics, consolidations, custom groups, templates and drill maps to develop canned reports, and ad-hoc reports. Created static and dynamic dashboards using Report Services documents.
• Utilized advanced components such as: custom groups, consolidations, advanced metrics, extensive knowledge/experience of widgets/graphs. Created consolidation objects for grouping of attribute elements and custom groups to group attribute elements based on advanced filtering conditions.
• Set VLDB properties at report, metric and database instance levels to manage outer join, metric calculations and query optimizations. Used Intelligence Cubes and Cache Sharing to speed up the processing time of reports.
• Worked with Data Warehouse Architect to write Type-2 Dimension Incremental Loading test scripts using SQL and PL/SQL. Helped test the dimension data after ETL has performed incremental loading.

Confidential,TX

Business Intelligence Consultant

• Designed and implemented standard weekly and monthly executive summaries to track and monitor Key Performance Indicators. Unraveled key data to support strategic planning, operational effectiveness, highlight changing trends and issues with products and services. Successful implementations included: weekly preview sales dashboard, weekly acquisition scorecard, weekly seminar sales report, product sales report, and daily inside sales scorecard.
• Designed and automated new customer acquisition report which helped improve ROI and cost-effectiveness for new customer acquisition, effectiveness of acquisition campaigns (direct marketing), and increased conversion to higher value customers.
• Worked with business analysis team to identify business model, financial environment and user requirements.
• Created MicroStrategy schema objects and application objects as the foundation of BI solution. Developed fully-prompted reports to facilitate user’s ad-hoc reporting requirement such as marketing performance of different channels. Created custom group and consolidation. Used passthrough ApplySimple and ApplyComparison functions and attribute-to-attribute relationship filters to build custom attributes and metrics to satisfy reporting requirements.
• Built proof of concept dynamic dashboard with MicroStrategy. Performed MicroStrategy projects administration and application lifecycle management support. Participated in the business intelligence tool evaluation process. Created Data Visualization reports using bar Graphs, pie charts, trend lines for data analysis and used various MicroStrategy widgets including bubble grid, data cloud, fish eye selectors and slide bars.
• Responsible for source system data analysis, system architecture and development. Communicated with business users and analysts on system requirements, mentored report and document developers, provided production support and performance tuning. Helped the business partners on preparing training documentation and users training.
• Used visualization SDK to develop custom flash widget to meet user’s dashboard requirements beyond MicroStrategy out-of-box experience. Used web SDK to customize single sign-on to MicroStrategy Web. Added a custom trusted authentication provider and customize MicroStrategy environment to use PHP-based authentication for trusted authentication.
• Designed and implemented campaign modules and reports for email campaign management. Automated email campaign tracking from end to end. Consultant to campaign managers in the design, execution and tracking of A/B tests for email optimization. Suggested improvements to campaign executions to increase conversion to sales, including: tacking and analyzing customer lists, offers, subject lines, and layouts etc.

Confidential

BI Solution Consultant

• Responsible for source system data analysis, system architecture and development. Communicated with business users and analysts on system requirements, mentored report and document developers, provided production support and performance tuning. Architected data models and database design for BI solutions in business areas including compliance reporting, broker and channel level reporting (management of assets and revenue), investment plans management and monitoring.
• Provided detailed plan to identify and communicate best practices for system migration into the new environment of MicroStrategy 9.0.2. Tasks include upgrade plan of the entire platform (8.2.1 to 9.0.2) and projects migration, new application lifecycle management process evaluation, integration of LDAP server with MicroStrategy, and enterprise manager data warehouse migration plan.
• Extensive experience in using MicroStrategy Office to connect to MicroStrategy projects. Familiar with running reports and documents, accessing preferences, and refreshing data using MicroStrategy Office in Excel, PowerPoint, and Word with full security and prompts.
• Built proof of concept dynamic dashboard with MicroStrategy 9.0.2. Performed MicroStrategy projects administration and application lifecycle management support. Participated in the business intelligence tool evaluation process. Created Data Visualization reports using Bar Graphs, Pie charts, Trend lines for data analysis and used various MicroStrategy widgets including Bubble grid, Data Cloud, Fish eye selectors and slide bars.
• Created MicroStrategy schema objects and application objects as the foundation of BI solution. Developed fully-prompted report builder to facilitate user’s ad-hoc reporting requirement using Object Prompts and Hierarchy-in-template. Created custom group and consolidation objects to meet user’s reporting requirements. Involved in application performance tuning by utilizing both MicroStrategy OLAP Services, Intelligent Cube, VLDB properties and data warehouse aggregate tables, index optimization, partition tables and investigation of query explain plans.
• Used the administrator tools like Object Manager, Project Merge Wizard, Project Duplication, Integrity Manager and Command Manager in moving the projects/objects among different environments, validating report SQL/data between two environments and generating scripts for bulk operations.