We provide IT Staff Augmentation Services!

Bi Microstrategy Analyst Resume

CA

SUMMARY:

  • 5+ years of IT industry experience in implementing all phases of the System Development Life Cycle (SDLC), including Business requirements gathering, Design, Development, Testing, and Implementation.
  • Experience with Ad hoc reporting and standard reporting environment.
  • Solid understanding in Meta Data Strategies, Warehouse Standards.
  • Experience in latest BI Tools Microstrategy, Tableau and Qlikview Dashboards Design.
  • Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.
  • Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues/tickets. Implemented advanced geographic mapping techniques.
  • Created Data Mart Reports using Complex Filters and Compound Metrics
  • Extensively worked in creating and integrating reports and objects (Attributes, Facts, Metrics, Filters, and Prompts) with the data warehouse.
  • Designed and Developed Dashboards and Scorecards using Report Services Documents
  • Proficient in Analysis, Design and Development of applications using Oracle, SQL Server, Teradata and MS Access .
  • Worked on the ETL mappings Design, Analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets
  • Design of system requirements, specifications, and design documents of large systems using Object Oriented Modeling Techniques .
  • Design and build integration logic and components to support source to target mapping, edit rules and validation, transformations, and business rules
  • Good analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals. Excellent written and verbal communication skills including experience in proposal and presentation creation
  • Aptitude for problem solving and making critical decisions on a short time frame.
  • Well - Organized, Quick learner, Self-motivated Team Player and have experience in all phases of the Systems Life Cycle including Project Definition, Analysis, Design, Coding, Testing, Implementation and Support.

TECHNICAL SKILLS:

BI &Reporting: MicroStrategy, Tableau, Qilkview,Crystal Reports, MS Access Reports

OS: WINDOWS 95/98/NT/2000, UNIX & MAC 7.x

Databases: Oracle, MS SQL Server, Teradata, Db2, MS Access

Internet skills: HTML, DHTML, XML, ASP.net, C#.net and VBScript

Languages: C, C++, SQL, PL/SQL

Web & Application: IIS, SMTP, Apache, BEA Web Logic Servers

PROFESSIONAL EXPERIENCE:

Confidential, CA

BI Microstrategy Analyst

Responsibilities:

  • Worked with Business users and was involved in requirements gathering, design /development life cycle, user interaction and report design and development
  • Extensively worked and developed Metrics, filters and prompts to enable decision-makers to choose the condition for reports as well as to view reports in different perspectives.
  • Worked with MicroStrategy Architect to build Attributes, Facts, Hierarchies and Relationships between various attributes and developed perfect logical models for reporting environment.
  • Created dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights
  • Designed and Developed Ad hoc reports using Templates, Metrics, Filters, Auto Prompts, Custom Groups, and Transformations.
  • Designed and Developed Dashboards and Scorecards using Report Services Documents.
  • Created Customized Auto Styles to allow reports in MicroStrategy Desktop and MicroStrategy Web to apply customized formats
  • Used analytical and governing settings in VLDB properties to tune the SQL and for calculating the metrics in dealing with the nulls and Zeroes in data.
  • Created Transformations for using in comparative reports like this year to last year (year to date and month to date).
  • Converted existing interactive reports with prompts to non-prompted reports for Narrow casting.
  • Involved in trouble shooting MicroStrategy prompt, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment.
  • Built SQL scripts and queries for data analysis and extraction.
  • Involved in Testing and Tuning of Reports and Objects.
  • Involved in giving demos/Presentations to end-users and training other developers in MicroStrategy Desktop and Web.

Confidential, CA

Business Analyst

Responsibilities:

  • Involved in requirements gathering from the Business users, design /development life cycle, user interaction and report design and development.
  • Build Attributes, Facts, Hierarchies and Relationships between various attributes and developed perfect logical models for reporting environment.
  • Identify Source tables and columns required to create Schema Objects.
  • Created dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights
  • Designed and Developed Ad hoc reports using Templates, Metrics, Filters, Prompts, and Transformations.
  • Extensively worked in developing Metrics, Derived metrics, Compound metrics and Filters for complex reports.
  • Designed and Developed Dashboards and Scorecards using Report Services Documents
  • Used MicroStrategy Web to offer interactive reporting to the end users through a web browser.
  • Designed Components, Templates and Filters to generate reports in grid and graph mode. Used Auto prompt filter features.
  • Created source and target definitions, mappings and transformation rules.
  • Provided Data Access to executives, managers (Casual users) and Business Analysts (Power Users). Worked as a link between Business and Technical groups.
  • Involved in creating user groups and security filters for users and assign privileges.

Involved in giving demos/Presentations to end-users and training other developers in MicroStrategy Desktop and Web

Confidential, CA

BI Analyst

Responsibilities:

  • Identify Source tables and columns required to create a MicroStrategy project.
  • Configured reports for end users in Desktop, MicroStrategy Web.
  • Employed MicroStrategy Desktop in designing the MicroStrategy projects. The business rules of the data warehouse were implemented in MicroStrategy Architect.
  • Developed logical models, building hierarchies, attributes and facts, extracting tables from warehouse.
  • Extensively worked in developing Metrics, Derived metrics, Compound metrics and Filters for complex reports.
  • Designed and Developed Dashboards and Scorecards using Report Services Documents
  • Used MicroStrategy Web to offer interactive reporting to the end users through a web browser.
  • Created report formats and delivered personalized messages from the Data warehouse through MicroStrategy Narrowcast Server to a wide range of users.
  • Designed Components, Templates and Filters to generate reports in grid and graph mode. Used Auto prompt filter features.
  • Created source and target definitions, mappings and transformation rules..
  • Provided Data Access to executives, managers (Casual users) and Business Analysts (Power Users). Worked as a link between Business and Technical groups.
  • Provide End user training by giving Demos/Presentations.
  • Involved in creating user groups and security filters for users and assign privileges.

Confidential, CA

BI Developer

Responsibilities:

  • Involved in requirements gathering from the Business users, design /development life cycle, user interaction and report design and development.
  • Extensively worked and developed Ad hoc reports and standard reports.
  • Developed filters and prompts to enable decision-makers to choose the condition for reports as well as to view reports in different perspectives.
  • Developed Metrics, Derived metrics, Compound metrics and Filters for complex reports.
  • Created and implemented Consolidations and Custom Groups to better accommodate user requirements.
  • Created Transformations for using in comparative reports like this year to last year (year to date and month to date).
  • Involved in trouble shooting MicroStrategy prompt, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment.
  • Involved in giving demos/Presentations to end-users and training other developers in MicroStrategy Desktop and Web.
  • Involved in creating user groups and security filters for users and assign privileges

Hire Now