We provide IT Staff Augmentation Services!

Bi Lead Resume

Philadelphia, PA

SUMMARY:

  • 1 2+ years of experience with Microstrategy 9.4/9.2.1/9.0.2/8.1.1/8.0.1 product suites including Microstrategy Desktop, Microstrategy Mobile, Microstrategy Intelligence Server, Microstrategy Narrowcast Server and Microstrategy Architect and many other areas.
  • Currently working as the Business Analyst and working on the Report Transformation.
  • Expertise in OLTP/OLAP System Study, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
  • Good Exposure to Cognos, SAP Business Objects and Informatica 7.1. Trained in SAP BI/BW.
  • Participated in Requirement Workshops to gather and understand Client requirements.
  • Documented requirements using Functional and Technical Specifications and delivered them to the Business stakeholders.
  • Conducted Design Workshops based on requirements to conduct FIT/GAP Analysis.
  • Designed Dashboards from multiple data sets by summarizing key business indicators by presenting them in visually intuitive, easy - to-read, interactive documents.
  • Created interactive dashboards using the new selectors like radio buttons, check boxes, panels, slider, button bar etc.
  • Extensively worked on Cubes and Report Services to create performance dashboard reporting.
  • Designed Dashboards from multiple data sets by summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents. Created interactive dashboards using the new selectors like radio buttons, check boxes, panels, slider, button bar etc.
  • Extensive work experience with Ad-hoc reporting using reporting environment.
  • Good experience in the creation of report objects including Prompts, Filters, Templates, Transformations, Custom Groups, Consolidations and Metrics.
  • Worked on Enterprise Manager Reports to know the Report Usage.
  • Experience in SLA and leading all phases of the software life cycle (feasibility studies, estimating, system analysis, design, development, quality assurance and implementation). Ex: Waterfall Model.
  • Good experience in Microstrategy Schema and Star Schema configuration.
  • Experience with Microstrategy SDK, used to implement highly customized and Powerful web reporting BI applications.
  • Exposure in dealing with variety of Relational Databases like Oracle, SQL Server.
  • Experience with Teradata Database.
  • Experienced in administrating Microstrategy Platform creating the users, licence management, load balancing of projects on the Intelligence servers with UNIX and Windows 2000/XP operating systems .
  • As a Microstrategy Lead, gathered business requirements, Analyzed & did feasibility study of the client’s requirements, Estimated the project, prepared functional and technical specifications, provided technical guidance/support to the team, reviewed deliverables from the offshore team, prepared test scripts, resolved support issues at Onsite.
  • Good Experience in developing the IPAD based dashboards for the field users.

PROJECTS/ENGAGEMENTS:

Confidential, Philadelphia, PA

BI Lead

Tools/Environments : Microstrategy 11, Windows

Responsibilities:

  • Created new schema objects attributes and facts pointing to new database tables.
  • Created new metrics and filters based on the new schema objects.
  • Build the legacy reports in MSTR Ad-hoc reporting.
  • Testing the report using the Microstrategy Integrity Manager.
  • Granted access to the new users.
  • User setup with LDAP authentication.
  • Created Application, Configuration and Schema objects.
  • Extensively used created Hierarchical prompts& object prompts.
  • Restricted access to users by implementing Security Filters & Security Roles.
  • Used Object Manager to migrate objects between various environments.
  • Used the VLDB properties for performance tuning and SQL optimization.
  • Created Transformations, complex filters/objects with advanced qualifications involving the ‘Pass-Through’ functions.
  • Worked extensively on creating Application Objects like Metrics, Compound Metrics, Filters, Custom Groups and Consolidations for Complex Reports.
  • Worked with back end Database Analysts/Administrators to provide requirements for necessary back end tables.
  • Customer Requirements Gathering, Requirements Analysis, Design, Development, Testing, End User Acceptance Presentations, Implementation and Post production support of BI projects.
  • On-call support on rotation basis with onsite-offshore model.
  • Extensively worked on Microstrategy Dossiers.
  • Extensively worked on scheduling/subscribing formula based Excel reports and PDF reports using Narrowcast.
  • Used Integrity Manager during the upgrade from version 10 to 11.
  • Used the VLDB properties for performance tuning and SQL optimization.
  • Created Transformations, complex filters/objects with advanced qualifications involving the ‘Pass-Through’ functions.

Confidential

BI Lead

Tools/Environments : Microstrategy 9.4.1, Windows

Responsibilities:

  • Created new schema objects attributes and facts pointing to new database tables.
  • Created new metrics and filters based on the new schema objects.
  • Build the legacy reports in MSTR Ad-hoc reporting.
  • Establish reports delivery.
  • Testing the report using the Microstrategy Integrity Manager.
  • Granted access to the new users.
  • User setup with LDAP authentication.
  • Created Application, Configuration and Schema objects.
  • Extensively used created Hierarchical prompts& object prompts.
  • Restricted access to users by implementing Security Filters & Security Roles.
  • Used Object Manager to migrate objects between various environments.
  • Used the VLDB properties for performance tuning and SQL optimization.
  • Created Transformations, complex filters/objects with advanced qualifications involving the ‘Pass-Through’ functions.
  • Worked extensively on creating Application Objects like Metrics, Compound Metrics, Filters, Custom Groups and Consolidations for Complex Reports.
  • Worked with back end Database Analysts/Administrators to provide requirements for necessary back end tables.

Confidential, PA

BI Lead

Tools/Environments : Microstrategy 9.4.1, Windows 7

Responsibilities:

  • Understanding the existing system and the Investment Business.
  • Reports rationalization of the existing 500 reports in current systems running on various BI applications like PowerBuilder etc.
  • Coordinating the Offshore team in the development activities.
  • Define Business Intelligence Architecture / Framework
  • Build/Migrate the legacy reports in MSTR and develop Ad-hoc reporting
  • Establish reports delivery
  • Developed Flash Dashboards in 9.4 using Widgets and Selectors for summary level reporting.
  • Worked extensively on creating Application Objects like Metrics, Compound Metrics, Filters, Custom Groups and Consolidations for Complex Reports.
  • Worked with back end Database Analysts/Administrators to provide requirements for necessary back end tables.
  • Extensively worked in both Ad-hoc and Standard Reporting Environments and Involved in creating Reports scalable to large volumes of data. Managed projects through entire Systems Development Life Cycle, including creating timely/thorough status reports and leading status meetings.

Confidential, Wilmington, DE

Business Analyst and Microstrategy Architect

Tools/Environments : Microstrategy 9.4, Windows 7

Responsibilities:

  • Responsible for gathering business requirements, Analysis & feasibility study of the client’s requirements, estimating the project, preparing functional specifications, preparing the technical specs, preparing Design documents, providing technical guidance/support to offshore.
  • Involving in the overlap analysis between the excel reports and existing production dashboards.
  • Discussing on the efforts and estimates with the client on the new requirement.
  • Involved in data flow discussion i.e. how the data flows into data mart if any new Team/brand is going to launch.
  • Experience in Microstrategy MOBILE.
  • Good involvement in the dashboard design to make it efficient in IPAD. Because we will have very small screen in IPAD when compare to web, so we need to design in an efficient way to fit multiple graphs and grids in a single page by satisfying all the requirements.
  • Created IPad dashboards both in offline and online mode.

Confidential, Collegeville, PA

Microstrategy Architect

Tools/Environments : Microstrategy 9.2.1, Windows XP

Responsibilities:

  • Responsible for gathering business requirements, Analysis & feasibility study of the client’s requirements, estimating the project.
  • Responsible for Performance Tuning of various Microstrategy Reports.
  • Creating Project source and various schema objects.

Confidential, Baltimore, MD

Microstrategy Architect/Developer

Tools/Environments : Microstrategy 9.2.1, Windows XP

Responsibilities:

  • Responsible for gathering business requirements, Analysis & feasibility study of the client’s requirements, Estimating the project and executing the tasks.
  • Extensively created Attributes, Facts, Metrics, Filters, Consolidations, Transformations, Prompts and Custom Groups using Microstrategy Desktop to generate reports for Business analysis.
  • Developed multiple Ad-hoc and Dashboard Analysis reports.
  • Created Metrics, Attribute-to-Attribute qualification, Metric-to-Metric qualification prompt using Microstrategy for report development.
  • Responsible for Performance Tuning of various Microstrategy Reports.
  • Worked on various types VLDB options to exclude report SQL cross joins.
  • Created LLD for testing team and user guide for End users.

Confidential, St. Louis, MO

Microstrategy Administrator/Microstrategy Lead

Tools/Environments : Microstrategy 9.2.1, Linux

Responsibilities:

  • Involved in the Project duplication.
  • Performed various tasks on Intelligence Server like restarting the server, purging the caches.
  • Responsible for fixing all the production issues from Confidential Microstrategy Team.
  • Responsible for gathering business requirement, Analysis & feasibility study of the client’s requirements, Estimating the project and executing the tasks.
  • Responsible for creating Services, Subscriptions on Narrowcast server issues.
  • Creating users and User Groups using Command Manager.
  • Creating various types of usage reports by using Enterprise Manager.

Confidential, Collegeville, PA

Microstrategy Developer/Microstrategy Architect

Tools: /Environments: Microstrategy 9.2, Windows XP, Oracle 11g

Responsibilities:

  • Responsible for meeting with business users to discuss and finalize the requirements and design of the reports.
  • Extensively created Attributes, Facts, Metrics, Filters, Consolidations, Transformations, Prompts and Custom Groups using Microstrategy Desktop to generate reports for Business analysis.
  • Worked on OLAP Services.
  • Generated Reports for CF and RP Reports on Microstrategy Desktop.
  • Developed multiple Ad-hoc and Dashboard Analysis reports.
  • Developed different types of Dashboards.
  • Created Metrics, Attribute-to-Attribute qualification, Metric-to-Metric qualification prompt using Microstrategy for report development.
  • Created Transformations (table based, formula based).
  • Responsible for Performance Tuning of various Microstrategy Reports.

Hire Now