We provide IT Staff Augmentation Services!

Bi Manager Tampa, Florida

SUMMARY:

  • 14 years of experience in Information Technology that includes Design, Development, Implementation and Support.
  • More than 12 years of experience with Microstrategy working with Desktop, Architect and Web.
  • Microstrategy Certified Project Designer/Report Developer.
  • Working experience in many industrial sectors like Financial, Retail.
  • Extensively worked on Schema Design creating Attributes, Facts, Hierarchies and Transformations.
  • Experience in developing public objects like Metrics, Advanced Metrics, Filters, Advanced Filters, Prompts, Custom Groups, and Consolidations as per the user requirements.
  • Experienced in creating/using intelligent cubes, view reports in various reports and dashboards.
  • Worked on various VLDB Settings/Properties for performance tuning of reports/dashboards.
  • Experience in creation of Dynamic Enterprise Dashboards, Scorecards (KPI’s) using nested panels, report hyperlinks, various Widgets and Selectors for better understanding of Business trends.
  • Implemented optimization techniques on different Dashboards and Document Objects using best practices recommended by MicroStrategy.
  • Expert in Creating MicroStrategy reports, generic cubes and implementing MicroStrategy projects.
  • Tuning of the MicroStrategy reports using Data Mart Reports, Aggregate tables and Intelligent Cubes.
  • Worked on Conditional Metrics, Level metrics and advanced prompts for creating advanced reports.
  • Knowledge on ER Diagraming, Dimension Modeling, Star Schema and Snowflake Schema.
  • Participated in demo sessions and also had hands - on experience with MicroStrategy.
  • Performed various product upgrades on Microstrategy and migrated metadata to different database environments.
  • Strong troubleshooting capabilities in Microstrategy Desktop.
  • Experience in full Software Development Life Cycle (SDLC)
  • Involved in dimensional modeling of Databases for data warehouse using Erwin.
  • Very good knowledge in Informatica and Work Fusion.
  • Familiar with Big Data/Hadoop integration to MicroStrategy; Hadoop, HDFS, MapReduce, Pig, Hive, HBase, NoSQL, IBM Spark
  • Strong skills of working with databases like Oracle and Teradata
  • Extensive experience in development of SQL Queries, Stored Procedures and Triggers.
  • Excellent analytical, communication and problem solving skills.

TECHNICAL SKILLS:

Operating Systems: Windows 7, Windows Server 2003/2008/2012, UNIX and Linux OLAP Micro Strategy 10.4,9.2.1 (Intelligence Server, Desktop, Web, NarrowCast Server), QlikView 12, Tableau, Business Objects (Designer, Business Object, Supervisor, Web Intelligence).

Tools: Toad Data Modeler, ERWIN 3.5.2/4.1,MS Project, MS Excel, MS Word, MS PowerPoint, Visio, SQL*Loader, SharePoint, Documentum.

ETL: Informatica Power Center 8.1.1 and Accentual Data Stage

Languages: PL/SQL, SQL, C++, JAVA, .Net, Visual Basic

RDBMS: Oracle 11g, Teradata, MS SQL Server and MS Access

PROFESSIONAL EXPERIENCE:

Confidential,Tampa, Florida

Senior BI Manager/ Microstrategy SME (Architect/Administrator/Developer)

Responsibilities:

  • Performed Customer Requirements Gathering, Requirements Analysis, Design, Development, Testing, End User Acceptance Presentations, Implementation and Post production support of BI projects.
  • Created technical and functional specifications, including relational database design, using business and system use cases and Visio diagrams.
  • Worked with the Business users (UK) and Offshore technical Team (India). Co-ordinated weekly meetings and acted as IT contact for the Business users.
  • Transitioned from traditional waterfall model to Agile methodology.
  • Performed Administration tasks, like User Creation, Session Handling, Creating Security roles, Analyzing Report performance, administered all aspects of web and intelligence server and Narrowcast Server.
  • Extensively worked with MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Administrator reporting basics using MicroStrategy Desktop and MicroStrategy Web. Involved in troubleshooting MicroStrategy prompt, Filter, Template, Consolidation, and Custom Group objects in an enterprise data warehouse team environment.
  • Customized Microstrategy web using SDK.
  • Revision/update of MicroStrategy reports that change as a result of Engineering release related changes to the data warehouse structure and functionality.
  • Worked extensively on creating Application Objects like Metrics, Compound Metrics, Filters, Custom Groups and Consolidations for Complex Reports.
  • Automated and improved existing manual processes. Optimizing the server platforms using Caching and Scheduling.
  • Successfully upgraded Microstrategy 9.2.0 to 10.4
  • Migrated Microstrategy project from Oracle 12g to SQL Server 2014.
  • Performed PoC on integrating the system with Hadoop.
  • Managed the project/team with ITIL framework.
  • Worked with back end Database 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.

Environment: Microstrategy 10.4, 9.2.0/8.1.2 (Desktop, Administrator, Web), Microstrategy Intelligence Server 9.2/8.1.2, Microstrategy Narrowcast Server 9.2/8.1.2, QlikView12, Oracle 12g, SQL Server 2014 Windows 7, Toad Data modeler.

Confidential,Tampa, Florida.

Microstrategy Architect/Developer/Admin

Responsibilities:

  • Performed Customer Requirements Gathering, Requirements Analysis, Design, Development, Testing, End User Acceptance Presentations, Implementation and Post production support of BI projects.
  • Created technical and functional specifications, including relational database design, using business and system use cases and Visio diagrams.
  • Performed Administration tasks, like User Creation, Session Handling, Creating Security roles, Analyzing Report performance, administered all aspects of web and intelligence server and Narrowcast Server.
  • Extensively worked with MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Administrator reporting basics using MicroStrategy Desktop and MicroStrategy Web. Involved in troubleshooting MicroStrategy prompt, Filter, Template, Consolidation, and Custom Group objects in an enterprise data warehouse team environment.
  • Customized Microstrategy web using SDK.
  • Revision/update of MicroStrategy reports that change as a result of Engineering release related changes to the data warehouse structure and functionality.
  • Worked extensively on creating Application Objects like Metrics, Compound Metrics, Filters, Custom Groups and Consolidations for Complex Reports.
  • Automated and improved existing manual processes. Optimizing the server platforms using Caching and Scheduling.
  • Successfully upgraded Microstrategy 8.1.2 to 9.2.0.
  • Worked with back end Database 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.

Environment:: Microstrategy 9.2.0/8.1.2 (Desktop, Administrator, Web), Microstrategy Intelligence Server 9.2/8.1.2, Microstrategy Narrowcast Server 9.2/8.1.2, Oracle 10g, Windows 7.

Confidential,White Plains,New York

Microstrategy Architect/Developer

Responsibilities:

  • Involved in gathering of business requirements.
  • Involved in design of the project logical model.
  • Architected schema objects such as attributes, facts and transformations.
  • Created various MicroStrategy objects such as Metrics (simple and compound), Filters, Prompts, Custom Groups, Consolidations, etc.
  • Created a DB instance for MicroStrategy and added all the tables, table prefixes and updated the table structure required for the Project.
  • Worked with Microstrategy Object Manager to move objects among the Development, Testing and Production environments.
  • Writing BAT file to call Command manager to execute Service.
  • Set Up MicroStrategy and Windows Performance Counters and Log them to Text or CSV for Performance Tracking.
  • Perform Daily Checks for job Monitor, user sessions and Cache Monitor to keep the system stable.
  • Micro strategy IServer Tuning for performance.
  • Created various event based Schedules.
  • Deploying Flash Widgets on Servers and Uploading the New ones from Support site.
  • Created reports with various object prompts to generate various Ad hoc reports.
  • Worked with Erwin in designing the schema for database views.
  • Created many Materialized views in Oracle which act as Mart tables.
  • Created various Report Services Documents for SPG and SVO Activity with various transformation metrics to report on Monthly, YTD and Trailing 12 month’s period.
  • Created various Monthly Dynamic Dashboard documents for Field marketing people with multiple panel stacks, selectors and customized widgets.
  • Created various Narrowcast reports, subscriptions and schedules.
  • Created Informatica Mappings for Monthly data load from FTP site to the Data warehouse.
  • Involved in Microstrategy version 9.0 product evaluation.

Environment:: Microstrategy 9.0/8.1.2 (Desktop, Administrator, Web), Microstrategy Intelligence Server 8.1.2, Microstrategy Narrowcast Server 8.1.2, Oracle 10g, IBM Websphere and Linux

Confidential, FL

Microstrategy Architect/Developer/Narrowcast Developer

Responsibilities:

  • Involved in gathering of business requirements.
  • Architected schema objects such as attributes, facts and transformations.
  • Created various metrics using statistical functions.
  • Created reports with various object prompts to generate various Ad hoc reports.
  • Involved in Testing of reports and Migrated Microstrategy7i projects from development to acceptance and to production.
  • Worked with creating of views in Teradata.
  • Optimized the Intelligence Server for better performance.
  • Worked with Test Director 7.6 to fix and close the defects for the project.
  • Created multiple projects pointing to staging, testing and production data warehouse.
  • Migrated projects from Microstrategy 7.5.0 to Microstrategy 8.0.1 environments.
  • Involved in testing of the project after migrating the projects from 7.5.0 to 8.0.1
  • Involved in testing of the entire project when Teradata is upgraded from V2.5 to V2.6.
  • Created various Narrowcast reports, subscriptions and schedules.
  • Helped Microstraetgy Administrator with regards to administrative tasks like Cache and Job monitoring, Database instance creation, user creation.
  • Created various report services and Dashboard documents on sales sent monthly to vendors.
  • Created various alert based services and Page Personalization Subscriptions.
  • Used Teradata Mload script and OLE Load for loading data into Teradata from various sources.
  • Worked with Microstrategy Object Manager to move objects among the Development, Testing and Production environments.

Environment:: Microstrategy 7.5.0/8.0.1 (Desktop, Administrator, Web), Microstrategy Intelligence Server 7.5.0/8.0.1, Microstrategy Narrowcast Server 7.5.0/8.0.1, Teradata V2.6, Windows XP/2000.

Confidential

Programmer analyst/Datawarehouse Developer

Responsibilities:

  • Responsible for designing of Warehouse Data model. Involved in requirement gathering and analysis for the same. Involved in designing of SDS (System Design Specifications).
  • Setup microstrategy environment and architect the microstrategy project
  • Worked with Intelligence Server Configuration wizard to create metadata tables and set up the Intelligence server.
  • Design and development of MicroStrategy schema objects like Attributes, Facts, Hierarchies, and Transformations using MicroStrategy Architect.
  • Created various microstrategy objects such as Metrics (simple and compound), Filters, Prompts, Custom Groups, Consolidations, etc.
  • Manipulated various attribute properties to enforce right table joins.
  • Optimized the Intelligence Server for better performance.
  • Setup the Microstrategy environments for Development, Testing and Production environments.
  • Created multiple projects pointing to staging, testing and production data warehouse.
  • Migrated projects from Microstrategy 7.5.0 to Microstrategy 8.0.1 environments.
  • Worked with Microstrategy Object Manager to move objects among the Development, Testing and Production environments.
  • Worked with Microstrategy Command Manager to create bulk users for the projects.
  • Responsible for backup and restoring of microstrategy projects.
  • Evaluated Microstrategy Reporting Services.
  • Worked with web customizations, modified the ASP files in the web server to display Company and Project logo for the project in Web.

Environment:: Microstrategy 7.5.0/8.0.1 (Desktop, Administrator, Web), Microstrategy Intelligence Server 7.5.0/8.0.1, Business Objects, Microstrategy Narrowcast Server 7.5.0/8.0.1 Oracle 9i, ErWin 4.0, Visio 5.0, SQL * Loader, VB, ASP, C#, Windows 95/NT/2000

Confidential

Programmer Analyst/Data warehouse Developer

Responsibilities:
  • Involved in data modeling and design using Erwin.
  • Responsible for setting up Development, Testing and Production environments.
  • Administration of Intelligence Server and User management.
  • Responsible for creating facts, attributes, hierarchies for the project.
  • Extensively created micro strategy objects such as Metrics (simple and compound), Filters, Prompts, Custom Groups, and Consolidations.
  • Manipulated attribute and attribute forms properties to enforce right table joins.
  • Used Microstrategy functions such as ApplySimple, ApplyComparision, Case, ln (log function) in the metric calculations and used in different reports.
  • Used advanced sorting, smart totals, different types of prompts such as object, value, hierarchy etc.
  • Used Documents to display company logo and multiple graphs and reports in the same page.
  • Created various types of graphs based on the user requirements includes gauge reports,
  • Extensively worked with customizing the XSL for documents to set appropriate header, font size, HREF links etc. Worked with different types of XSL provided with micro strategy.
  • Responsible for validation and approval of the test cases provided by testing team.
  • Worked with Test Director 7.6 to fix and close the defects for the project.
  • Coordinated the UAT testing team and provided guidance for UAT.
  • Documented the project for maintenance team and business.

Environment:: Microstrategy7.2.3/7.50 (Desktop, Web), Business Objects, Teradata v.2.5, Informatica Power center, MS Projects, Erwin, Visio 5.0, ASP, VB, Java, Windows 95/NT/2000

Hire Now