We provide IT Staff Augmentation Services!

Microstrategy Architect Resume

Hoffman Estates, IL

SUMMARY:

  • 9+ years of Professional experience in Design, Development and Implementation of Data Warehousing applications, with proficiency in Making Reports, Scorecards, Dashboards using MicroStrategy 10.5/9.5/9.4/9.3.1/9.2.1/8 i.
  • Experience with all the modules of MicroStrategy Product Suite.
  • Experienced in creating Ad - Hoc report by using Visual Insight.
  • 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.
  • Experience with other BI tools like Tableau.
  • Experience in working with Oracle RDBMS database.
  • Experience working with Star and Snow-flake schema.
  • Build MicroStrategy architect by using RDBMS database as project source.
  • Experience working with the Business Analytics and Business Users in gathering and documenting user requirements.
  • Experience in managing the team, working in agile environment.

TECHNICAL SKILLS:

Business Intelligence: MicroStrategy 10.5/9.5/9.4/9.3/9.2.1/8 i (Desktop, Architect, Web, Intelligence Server, Narrowcast Server, Object Manager). Tableau 9/10, Statistical analysis software package (SAS), OBIEE10g/11g

Databases: SQL Server 2000/05/08, DB2, Teradata 10, Oracle 11g/10g/9i/8i, MS-Access, Sybase IQ, MySQL

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

Web Technologies: HTML, XML, DHTML, ASP.Net

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

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

ETL Tools: Informatica 7.1.2/7.1, DataStage

Business Analyst Documents: Business Requirement Document (BRD), Functional Requirement Document (FRD), Use Case

WORK EXPERIENCE:

MicroStrategy Architect

Confidential, Hoffman Estates, IL

  • Initiated BI projects for business reporting
  • Simultaneously working on multiple projects, define scope, develop and implement
  • Provides reporting solutions, visualization for reports and dashboards for Supply Chain team
  • Provides end to end solution of supply chain process by defining metrics and KPIs.
  • Handle a team of 4 people to delivery projects on MicroStrategy Platform.
  • Perform project management of estimating, scheduling, and monitoring tasks and life cycle BI Development.
  • Interface with different departments within the organization regarding new deployments
  • Research/analyze data processing functions, methods and procedures
  • Involved extensively in the overall lifecycle of the Data Warehouse integration project
  • Experienced in doing the quick POC's to satisfy business requests using Tableau.
  • Involved in design/development life cycle including gathering requirements, user interaction and report design.
  • Create MicroStrategy Schema object based star schema, snow flake schema and hybrid schema.
  • Developed Metrics, Filters, Prompts to achieve the functionality of the canned reports and created advanced objects like Derived Metrics, Compound Metrics, OLAP reports.
  • Developed MicroStrategy Dynamic Dashboards using several controls and worked extensively on widgets.
  • 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.

Environment: - MicroStartegy 10.5, Teradata 10.0, MySQL

Technical Specialist

Confidential, Nashville, TN

  • Gather and translate business requirements into technical specifications
  • Design and code from specifications, analyzes, evaluates, tests, debugs, documents, implements complex apps.
  • Perform project management of estimating, scheduling, and monitoring tasks and life cycle BI Development.
  • Interface with different departments within the organization regarding new deployments
  • Research/analyze data processing functions, methods and procedures
  • Monitor program execution for expected performance
  • Design and build pixel perfect report service documents and interactive Flash dashboards.
  • Created Dashboards using various widgets like Micro charts, Time Series Slider, Heat map and Gauge.
  • Used intelligent cube reports in dashboard as datasets to achieve performance.
  • Involved in moving the objects between two projects and two different environments by using Object Manager.
  • Provided post implementation production support.
  • Extensively involved with data modeling.

Environment: - MicroStartegy 9.5, Teradata 10.0

Technical Leader

Confidential, Warren, NJ

  • Leading a team of six people in offshore onshore model.
  • Facilitate daily one to one discussion with client and Business user. Give demo to business user and constantly sync up with customer.
  • Working on Sybase IQ and Oracle 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 extensively in the overall lifecycle of the Data Warehouse integration project

Environment: - MicroStartegy 9.5, Oracle, Sybase

Programmer Analyst

Confidential, Warren, NJ

  • Worked as a MicroStrategy developer/ analyst in a team of six for design and development in the product development.
  • Performed Customer Requirements Gathering, Analysis, Design, Development, Testing, End User Acceptance Presentations, Implementation and Post Production support of Precision Market Insights Project.
  • Took part in full data warehousing application lifecycle starting from creating logical and physical data model, to implement and test ETL processes in Teradata environment.
  • Created Schema Objects and Application Objects using MicroStrategy Desktop and Architect.
  • Designed and Developed Reports and Dynamic Dashboards with challenging requirements.
  • Used different types of selectors/controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
  • Created logical views in MicroStrategy for complex report creations situations.
  • Created advanced grid reports, consisting of data analysis by combining a template with filters. The end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.
  • Experienced in doing the quick POC's to satisfy business requests.
  • Implemented 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 and insufficient data.
  • Involved in managing Migration of MicroStrategy projects and objects from Dev to Testing and to Production.
  • Performed Design & Code reviews Unit testing and data validation of MicroStrategy reports.
  • Experience in Dashboard integration with ACI Portal (Java based web application).
  • Extensively worked on various Pass-Through functions like ApplySimple, Apply Comparison.
  • Worked on Admin tools including Command Manager, Object Manager, and Enterprise Manager and Integrity manager.

Environment: - MicroStartegy 9.2, Teradata

Graduate Public Service

Confidential, Springfield, IL

  • Worked as HIV/AIDS Surveillance Assistant Data Manager
  • Worked with software including MicroStrategy 9.2, SAS, MS-ACCESS, the evaluation HIV/AIDS Reporting System (eHARS) database.
  • Working in SAS 9.2 reporting tool for generating different reports for various departments.
  • Received advanced training in the statistical analysis software package (SAS).
  • Responsible for transmitting statewide data to the U.S. Centers for Disease Control and Prevention (CDC) on a monthly basis and processing the acknowledgement file from CDC monthly.
  • Providing data management and computer programming support for the Surveillance Program staff.
  • Generated different reports using SAS Reporting tool on weekly and monthly basis.
  • Writing SAS Program with using SQL as per requirement.
  • Developed MicroStrategy Schema objects, Application objects.
  • Worked on the performance tuning of the MicroStrategy reports.

Environment: - MicroStartegy 9.2, Oracle

Project Engineer

Confidential

  • System Analysis, Data Analysis and Computer Aided Design.
  • Proficiently worked on JDE (ERP) for handling logistic work, purchase and finance.
  • Actively involved in preparing periodic reports for management decision using DSS.
  • Developed a computer based module which handled Purchase, Planning, and Logistics & Supply Chain process.
  • Have experience in doing excellent documentation on business requirements.
  • Experience in business functionality implementations, developing Data Models, Data Warehouses, and Data Marts from logical models as per specific business requirements.
  • Extensively used MicroStrategy Report Services to generate Report Documents.
  • Strong knowledge and understanding of SQL and ability to write SQL queries.

Assistant Manager

Confidential

  • Work as an Assistant Manager in NPI (New Product Introduction) planning.
  • Associated in Project of ABS.
  • Worked on SAP for data keeping and planning of different business process.
  • Responsible for logical and physical design of SQL Server databases.

Hire Now