We provide IT Staff Augmentation Services!

Senior Bi/ Microstrategy Developer/architect/analysts Resume

San Francisco, CA

SUMMARY:

  • Around 8 years of Professional experience in Design, Development and Implementation of Data Warehousing applications, with proficiency in Making Reports, Scorecards, Dashboards using MicroStrategy 2019/10.4/10.2/9.5/9.4/9.3.1/9.2.1 and also in Tableau & Power BI.
  • Certified MicroStrategy Architect and Analyst.
  • Certified Tableau Developer & Designer.
  • Experience in BI applications in many industrial sectors like Banking, Travel, Retail.
  • Worked as a MicroStrategy Developer/Architect/Analyst.
  • Experience with all the modules of MicroStrategy Product Suite namely MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Dashboard, MicroStrategy Narrowcast Server, and MicroStrategy Desktop.
  • Experience working with OLAP cube, Cube partition, prompt - based report on Cube, transaction services Report
  • Experienced in creating Ad-Hoc report by using MicroStrategy Analytics.
  • Experience in Dashboard integration with ACI Portal (Java based web application).
  • Participated in the Full life Cycle Development (FLCD) of the data warehousing project; project planning, business requirement analysis, data analysis, logical and physical database design, setting up the warehouse physical schema and architecture, developing reports, security and deploying to end users.
  • Optimizing report generation with respect to Very Large Databases (VLDB) to make absolute use of database flexibility, caching, security and scalability issues suited for Oracle, Teradata, DB2 and SQL Server.
  • Prepared Implementation plan, best practices, document for s& learning from the projects.
  • Worked on Admin tools including Command Manager, Object Manager, and Enterprise Manager and Integrity manager.
  • Experience working with the Business Analysts and Business users in gathering and documenting user requirements.
  • Hadoop, Hive integration with MicroStrategy. Tested raw data and executed performance scripts. Validation of data on Hadoop vs DB2.
  • Experience working with Star and Snow-flake schema
  • Experience in all latest BI Tools Tableau, MicroStrategy dashboard design.
  • Experience in Working on Tableau Server and Desktop 10.2 & 10.4.
  • Created complex Workbooks and dashboard in Tableau.
  • Created dashboard and visualization in Power BI
  • Created Workspace and content packs for business users to view the developed reports.
  • Scheduled Automatic refresh and scheduling refresh in Power BI service.
  • Experience in doing POC for the feature comparison between Tableau and MicroStrategy.
  • Created live and Extract connection for the sheets and Workbooks data source in Tableau.
  • Worked on interactive and highly formatted workbooks in Tableau to meet the user requirements.
  • Positive work attitude, interpersonal, and organizing skills matched with the ability to manage stress, time and people effectively.
  • Working on Agile methodology of SDLC. Experience on working with Jira and Rally tool.

TECHNICAL SKILLS:

Business Intelligence: MicroStrategy 2019/10.11/10.4/10.2/9.2/9.3/9.4 (MicroStrategy Desktop, MicroStrategy Web, MicroStrategy architect, MicroStrategy administrator, MicroStrategy Intelligence Server, MicroStrategy Narrowcast ServerTableau Server and Desktop 10.4/10.2

SQL Server 2008/201212/2014/2015 : Performance tuning, Replication, Query Optimization, Data Migration, SQL Profiler.

SQL Server 2008/2014/2015 : , SSIS 2005, DB2. Teradata 11.0, Oracle 11g/10g/9i/8i, MS-Access

Big Data Ecosystems: Hadoop, Hive

Languages: C, C++, Java, CSS, ASP.Net, SQL, PL/SQL, Oracle SQL*Plus

Web Technologies: HTML, XML, DHTML

Microsoft Visio2007/10:, Erwin 4.0/3.5.2, Designer 2000, UML

Operating Systems: Windows 7/ NT / XP / 2000/98, UNIX

WORK EXPERIENCE:

Confidential, San Francisco, CA

Senior BI/ MicroStrategy Developer/Architect/Analysts

Responsibilities:

  • Design, Architect and Lead Data Analytics solutions.
  • Design, Build, Test and Maintain Alerts for KPIs, Reports, Dashboards and Visualizations for all
  • Stakeholders.
  • Responsible to deliver daily reports with all KPIs.
  • Responsible for administering the Business Intelligence Reporting environments.
  • Responsible to test and confirm all MSTR objects works with 100% data match after Netezza migration and report any table/data need to be fixed.
  • Responsible to solve all the existing open issues.
  • Develop and deliver ad-hoc reports, documents and dashboards for users using metadata as well as free from SQL.
  • Responsible to change reports, documents and dashboards to include new metrics, filters to satisfy new report logic change.
  • Responsible to address all data issues and fix reports reported by stakeholders. Working directly with ETL team to analyze the changes and updates to the tables in Teradata for the implementation in the MicroStrategy.
  • Created dashboard and visualization in Power BI
  • Created Workspace and content packs for business users to view the developed reports.
  • Scheduled Automatic refresh and scheduling refresh in Power BI service
  • Suggested and develop some value add to current solution
  • Responsible to prepare the requirement document, technical understanding document, source to target mapping document and test document with sample outputs and get the signoff from business.

Environment: MicroStrategy Desktop 2019, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Dossier, Teradata. Power BI.

Confidential, Wilmington, DE

Senior BI/MicroStrategy/Tableau Developer/Architect

Responsibilities:

  • Working as a MicroStrategy developer/architect in a Small Business Team.
  • Created different schema objects like Attributes, facts by using MicroStrategy BI Suite.
  • Generated reports using Advanced Metric objects, Filters, Prompts and created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
  • Involved in creating MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports
  • Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc.
  • Created Ad-hoc reports by gathering specific requirements from the different users.
  • Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
  • Working with OLAP cube, Cube partition, and prompt-based report on Cube.
  • Using derived metric to do calculation on Analytical Engine and enhance performance of dataset.
  • Developed MicroStrategy Dynamic Dashboards using several controls and worked extensively on widgets.
  • Validate data model compatibility with MSTR architecture.
  • Used intelligent cube reports in dashboard as datasets to achieve performance.
  • Working on Tableau 10.2 & 10.4 server and desktop.
  • Created complex Workbooks and dashboard in Tableau.
  • Experience in doing POC for the feature comparison between Tableau and MicroStrategy.
  • Created live and Extract connection for the sheets and Workbooks data source in Tableau.
  • Worked on interactive and highly formatted workbooks in Tableau to meet the user requirements.
  • Involved extensively in the overall life cycle of the Data Warehouse integration project.
  • Working directly with ETL team to analyze the changes and updates to the tables in SQL Server & Teradata for the implementation in the MicroStrategy.
  • Suggest and develop some value add to current solution
  • Co-ordinate with client for requirement and UAT signoff

Environment: MicroStrategy Desktop 10.2/10.4/10.11/2019 , MicroStrategy Intelligence Server, MicroStrategy Web, Teradata, SQL Server 2014/2015. Tableau Server and Desktop 10.4/10.2

Confidential, Foster City, CA

Micro Strategy Architect/Lead/Technology Analyst

Responsibilities:

  • Worked as a MicroStrategy developer/architect/analyst for design and development.
  • Performed Customer Requirements Gathering, Analysis, Design, Development, Testing, End User Acceptance Presentations, Implementation and Post Production support.
  • Worked on full data warehousing application lifecycle starting from creating logical and physical data model, to implement and test ETL processes in DB2 environment.
  • Created Schema Objects and Application Objects using MicroStrategy Desktop and Architect.
  • Designed and Developed Reports and Dynamic Dashboards with challenging requirements.
  • Designed Ad hoc reports by using Visual Insight component of MicroStrategy.
  • Used different types of selectors/controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
  • Worked extensively with the End Users to finalize the dashboard layouts and also worked on fine detail formatting for a desired look and feel.
  • Created logical views in MicroStrategy for complex report creations situations.
  • Experienced in doing the quick POC's to satisfy business requests.
  • Implemented URL based SAVE and Export Links for dashboards.
  • Experienced in working with Maps using Visual Crossing Map widget.
  • Excellent experience configuring VLDB properties to fine-tune reports.
  • Extensively involved in troubleshooting support and resolving all outstanding issues.
  • Troubleshoot and tune MicroStrategy reports by analyzing the MicroStrategy generated SQL to determine data issues such as double counting, hitting incorrect fact tables, incorrect joins.
  • Done Migration task using Object Manager.
  • Performed Design & Code reviews Unit testing and data validation of MicroStrategy reports.
  • Created complex Functions, Scripts, Stored procedure and triggers to support application development in DB2.
  • Participate in database design and architecture to support application for DB2.
  • Hadoop, Hive integration with MicroStrategy. Tested raw data and executed performance scripts. Validation of data on Hadoop vs DB2.
  • Perform design specification and functional documentaries for database.

Environment: MicroStrategy Desktop 9.4, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Narrowcast Server, DB2, Hadoop, Hive.

Confidential, Phoenix, AZ

MicroStrategy Consultant

Responsibilities:

  • Responsible for overall MicroStrategy Architect design and Development.
  • Facilitate daily one to one discussion with client and Business user. Give demo to business user and constantly sync up with customer.
  • Worked on, Teradata 11.0 and Netezza 2.5 database management.
  • Responsible for data analysis and Data modeling for projects.
  • Involved in design/development life cycle including gathering requirements, user interaction and report design and development
  • Developed Metrics, Filters, prompts to achieve the functionality of the canned reports and created advanced objects like Derived Metrics, Compound Metrics.
  • Developed MicroStrategy Dynamic Dashboards using several controls and worked extensively on widgets.
  • Created report services documents for HR and Finance Data.
  • Developed a web course and took several classes to train the end users to efficiently use MSTR.
  • Involved in tuning of longer running queries by setting appropriate VLDB properties and by applying various design techniques to minimize the number of SQL passes generated by MicroStrategy.
  • Customized and optimized reports for various users using MicroStrategy features like VLDB properties at Project level and report level.
  • Worked with end users along with Business Analysts to build reports and dynamic dashboards.
  • Worked on administrative tasks like User Groups, Roles, Privileges, Cache Management.
  • Involved in POC for the reports and dashboard on Tableau. Initial setup for introducing Tableau into the project.
  • Involved extensively in the overall lifecycle of the Data Warehouse integration project

Environment: MicroStrategy Desktop9.2.1,9.4, MicroStrategy Web, Teradata 11.0, Netezza 2.5.

Graduate Intern

Confidential, Boston

Responsibilities:

  • Worked on the Installation, Configuration and design of MicroStrategy.
  • Developed logical models, build hierarchies, attributes and facts extracting tables from warehouse.
  • Identified Source tables and Columns required creating a MicroStrategy project.
  • Designed Templates, Filters to generate Reports in grid and graph mode.
  • Extensively used filters, facts, Consolidations, Transformations and Custom Groups to generate reports for Business analysis.
  • Provided personalized reports to end users through MicroStrategy Narrowcast Server.
  • Created Advanced Dashboards with panel stacks, complicated grids and graphs, customized widgets.
  • Implemented Drill Down/up functionality in various reports.
  • Designed Components, Templates and Filters to generate reports in grid and graph mode. Auto prompt filter feature gave end-user a choice of different filtering criteria each time they run the report.
  • Extensively worked in developing Metrics, Derived metrics, Compound metrics and Filters for complex reports.

Environment: MicroStrategy Desktop9.2.1, Oracle10g, SQL Server 2012, Tableau, Hadoop, Hive.

Hire Now