We provide IT Staff Augmentation Services!

Business Intelligence Developer Resume

Baltimore, MarylanD

SUMMARY:

  • Over 8 years of Experience in Software Development life - cycle and implementing in Data Warehouse, Business Intelligence, Client/Server Technologies.
  • Expertise in identification of business and data requirements and converting them to conceptual and logical data models.
  • Experience in designing of Multidimensional Modeling in MicroStrategy, regulating Star and Snowflake Schemas.
  • Strong experience in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts and Hierarchies) with the Data warehouse.
  • Extensively worked on designing projects using MicroStrategy and worked with team to develop many dashboards in the past 6 years. Have extensive knowledge in creating datasets and working with complex metrics and filters.
  • Have good knowledge and working experience with Object Manager, Integrity Manager and Narrowcast Server.
  • Expertise in SQL troubleshooting, VLDB Properties & Performance Tuning, SQL, PL/SQL, Stored Procedures, Triggers, MS Excel Pivot Tables.
  • Extensively worked on MicroStrategy Administration that includes Intelligence Server Administration, configuration of Memory settings, and Performance monitoring.
  • Involved in managing users, groups, folders and published & delivered reports using Narrowcast Server.
  • Experienced in Managing Servers, Repositories and Connections, solving any Administration and Production issues that are escalated to the development team, to have minimal impact on delivery of new reports.
  • Extensive experience in working with MicroStrategy Technical Support to fix issues and bugs in newer versions of MicroStrategy and using workarounds.
  • Good Technical, Interpersonal and Communication skills and consider self a good team player.
  • Clear understanding of business procedures and ability to work as an individual and as a part of a team.
  • Excellent 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.
  • MicroStrategy Certified Project Designer and Certified Reports Developer working to become a Certified Document developer.
  • Data Warehousing ETL experience of using Informatica 10.2/9.6 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools, Informatica Server, Repository Server manager.
  • Experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.

TECHNICAL SKILLS:

Reporting Tools: MicroStrategy 10.x/9.2.1/ 9.x, Crystal Reports XI, WebFocus, OBIEE, Business Objects, QlikView

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

Web Technologies: Visual Studio 2008/2010, JavaScript, JAVA 2.0, EJB, JNDI, Servlets, JSP, XML

ETL Tools: Informatica Power Center 10.2,9.6 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server)

Databases: Oracle 10g, SQL Server, DB2, Teradata

Operating System: Windows, MAC

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, Maryland

Business Intelligence Developer

Responsibilities:

  • Developed logical models, building hierarchies, attributes and facts, extracting tables from warehouse.
  • Created MicroStrategy Public Objects Metrics, Filters, Prompts, Templates, Consolidations, Transformations, and Custom Groups using MicroStrategy Desktop.
  • Developed reports based on the Business Object reporting platform and developed from scratch in MicroStrategy.
  • Created and implemented MicroStrategy reports by creating projects, Custom Groups, Cubes, attributes, hierarchies, metrics, filters, and templates.
  • Extensively worked in developing Metrics, Derived metrics, Compound metrics and Filters for complex 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.
  • Created various types of reports like group by, ranking on some condition, fact comparison with past year, prompted report, consolidation reports.
  • Designed custom drill maps using drill map editor as required in the reports for drill through functionality.
  • Generated advanced reports in grid, graph and SQL mode, consisting of data analysis by combining a template with filters, using MicroStrategy Desktop and Web
  • Created various pass through functions like apply simple, apply comparison and case statements to support various business requirements.
  • Created various Monthly Dynamic Dashboard documents for the decision makers with multiple panel stacks, selectors and customized widgets.
  • Worked on Intelligent Cubes to provide performance for dashboards and reports.
  • Extensively worked on creating Report Services documents using multiple Grids and Graphs
  • Applied OLAP and statistical functions to calculate metrics
  • Designed Schema and public objects using Pass through functions (Apply Simple, Apply Comparison, Apply Agg etc.)
  • Created different Transformations to get the last year actual transactions, week-to-day, week-to-period, week-to-quarter, and week-to-year
  • Involved in creating user groups and assigning user privileges according to the types of reports that they can generate or view in MicroStrategy Web
  • Worked on report services documents to create graphs as per user objective
  • Used freeform SQL to create Enterprise Manager Reports & Parametric Data Transfer analysis reports
  • Created Drill Maps to obtain aggregated results
  • Involved in creation of security filters to end users to access database on their privileges
  • Configured Intelligence server to generate pre-generated cache reports and used Narrowcast server to execute and deliver reports via web or email
  • Involved in troubleshooting MicroStrategy Web Reports, and optimizing the SQL using the VLDB properties.
  • Developed multiple Transactions Services documents for the business users to write back into the database table.
  • Used URL-API concept to build web links to access/execute reports/documents.
  • Performed a complete Production Support for the end users using MicroStrategy Web & also MicroStrategy Desktop.
  • Involved in building the ETL architecture and Source to Target mapping to load into Data warehouse.
  • Created mapping documents to outline data flow from sources to targets.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
  • Developed mapping parameters and variables to support SQL override.
  • Created mapplets to use them in different mappings.
  • Developed mappings to load into staging tables and then to Dimensions and Facts.
  • Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
  • Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: MicroStrategy 10.x (Desktop, Administrator, Web), MicroStrategy Intelligence Server 10.x, MicroStrategy Narrowcast Server, Business Objects, Informatica Power Center 10.2/9.6, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, DB2, Oracle11g, SQL Server, Windows.

Confidential, Woonsocket, Rhode Island

Business Intelligence Developer

Responsibilities:

  • Involved in the design/development life cycle including gathering requirements, user interaction and report design and development.
  • Generated and implemented MicroStrategy Reporting concepts by creating attributes, facts, Attribute Relationships and Hierarchies using MicroStrategy Architect.
  • Worked with Business Analyst to prepare requirement and report design document which is useful for MicroStrategy development.
  • Since it is a migration project from WebFocus to MicroStrategy, prepared several documents in the step by step process of creating requirements which will be useful for developing objects/reports in MicroStrategy.
  • Decoded WebFocus code to SQL, finding all the table joins, metric calculations and columns used from different tables.
  • Worked on understanding the logical data models by recognizing the source tables and columns, to build Attributes, Facts, Hierarchies and Relationships that are necessary to create a MicroStrategy project.
  • Developed Metrics, filters, prompts to achieve the functionality of consistent reports for the Web.
  • Created Complex reports for Analysis with Transformations, Custom Groups and Complex Filters.
  • Designed Dashboards, summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents.
  • Developed scorecards and dashboards that provide users a highly graphical, summary view of key metrics.
  • Extensively worked on creating datasets which involved creating advanced filters, prompts and metrics.
  • Involved in creating users and users’ group and restricting data to teams based on their access in MicroStrategy Desktop for testing the reports.
  • Used Built-in advanced functions in conjunction with metrics.
  • Extensively used MicroStrategy Desktop and Web to enable users to run pre-defined sales and inventory reports, build their own customized reports and download information into Excel spreadsheets.
  • Provided technical support and training for user groups. Worked with 5 FTE’s to develop a training document for business users and was involved in several training session and presentations.

Environment: MicroStrategy Desktop 9.4 Suite, Object Manager, Enterprise Manager, Integrity Manager, WebFocus, OBIEE, QlikView, Oracle 11g and Windows

Confidential, Jersey City, New Jersey

Business Intelligence Developer

Responsibilities:

  • Worked with Business Analysts & Subject Matter Experts to identify and understand requirements to produce reports design specification and estimate the project development efforts.
  • Worked on understanding the logical data models by recognizing the source tables and columns, to build Attributes, Facts, Hierarchies and Relationships that are necessary to create a MicroStrategy project.
  • Worked with the team in developing 6 Dashboards catering to Campaign and Promotion Management.
  • Created Datasets which feed into the dashboard and validated the data on the datasets.
  • Took the advantage of various controls like widgets and selectors to provide more user friendly and interactive Dashboards.
  • Implement OLAP functionality within report service documents to enhance performance.
  • Created conditional metrics, level metrics and modified fact definition when needed to calculate certain complex metrics.
  • Worked with the team to redesign the schema, modify attribute definitions and fact definitions to improve the performance of the report.
  • Extensively created filters, prompts, custom groups, consolidations and transformations to generate reports for Business analysis.
  • Performance tuning of SQL for long running reports.
  • Customized and optimized reports for various users using MicroStrategy features like VLDB properties at Project level and report level
  • Worked in 3 environments: Development, UAT and Production and used Object Manager to migrate objects in all the environments.
  • Created security roles, users and user groups. Assigned privileges to users and groups through security roles and assigned predefined grouping and custom grouping of permissions to objects using Access Control List (ACL),
  • Implemented Security filters at the user level for data level security.
  • Used Command Manager to automate the whole MicroStrategy administrative tasks including, purge cache, user management, and trigger reports according to event load.
  • Worked on installation of Enterprise Manager on to Windows server for statistics of all the projects in Production environment.
  • Extensively used Enterprise manager to monitor server usage and user activity.
  • Took regular backups of the metadata and used ScanMD to remove inconsistencies in the metadata. Also used MD Doctor to remove certain physical inconsistencies in the metadata.

Environment: MicroStrategy Desktop 9.3 Suite, Object Manager, Command Manager, Enterprise Manager, Integrity Manager, Oracle 11g, Crystal reports XI R2, T-SQL, Requisite PRO, Clear Quest

Confidential, Lincoln, Rhode Island

Business Intelligence Developer

Responsibilities:

  • Created Attributes and worked with Subject Matter Experts in defining relationships and working with parent-child relationships.
  • Generated and implemented MicroStrategy Reporting concepts by creating attributes, facts, Attribute Relationships and Hierarchies using MicroStrategy Architect.
  • Developed Metrics, filters, prompts to achieve the functionality of consistent reports for the Web.
  • Created Complex reports for Analysis with Transformations, Custom Groups and Complex Filters.
  • Developed scorecards and dashboards that provide users a highly graphical, summary view of key metrics.
  • Resolved several issues with cross joins by fixing the definitions of Attributes and Facts.
  • Created Advanced Reports in grid and graph mode using MicroStrategy Desktop which replaced several of the existing Main Frame and Cognos reports.
  • Worked on report enhancement requests and mostly involved in creating/modifying filters, custom groups, and conditional metrics.
  • Used Object Manager extensively and effectively to migrate objects in the 3 environments.
  • Worked with the team in validating and testing the reports and used Integrity Manager to test reports in both Development and Production environment.
  • Provided production support for the MicroStrategy application and helped users in resolving report related issues.
  • Extensively worked on creating datasets which involved creating advanced filters, prompts and metrics.
  • Involved in creating users and users’ group and restricting data to teams based on their access in MicroStrategy Desktop for testing the reports.
  • Used Built-in advanced functions in conjunction with metrics.

Environment: MicroStrategy Desktop 9.2.1, SQLServer 2005, Clear Quest, and Windows

Confidential, Austin, TX

MicroStrategy Developer

Responsibilities:

  • Involved in gathering Business Requirements from users by understanding the Source System (OLTP) and Interacting with the users.
  • Involved in the Data modeling for Business Process specific Data Mart.
  • Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop.
  • Created ad-hoc reports in grid and graph mode consisting of data analysis by combining a template with filters using MicroStrategy Desktop and web and created reports using complex Filters, Compound Metrics and Advanced Prompts.
  • Developed different Dynamic Dashboards and Scorecards and using MicroStrategy best practices as recommended by visual design experts, using selectors, widgets and multi-panels.
  • Reduced the time taken for the reports to run by taking advantages of VLDB properties like star join, query and sub query optimizations.
  • Used Non-Aggregatable Metrics, Conditional, Transformation metrics and Level Metrics for creating complex reports.
  • Used Pass through functions and free form SQL editor to meet the requirements for complex reports.
  • Created transformations (Table Based and Formula Based) for YTD (Year to date), MTD (Month to date) and WTD (Week to date) analysis.
  • Extensively used MicroStrategy Report Services to generate Report Documents.
  • Customized reports, Documents and deployed them to MicroStrategy web.
  • Extensively used Narrowcast Server for Report distribution.
  • Tested all the reports by running queries against the warehouse. Also compared those queries with the MicroStrategy SQL engine generated queries.
  • Worked with the team in validating and testing the reports and used Integrity Manager to test reports in both Development and Production environment.
  • Supported business users with technical requirements and issues with tool.

Environment: MicroStrategy Desktop 9.2.1, SQLServer 2005, Crystal reports XI R2, BO Data Integrator 11.5.3, T-SQL, Requisite PRO, Clear Quest, and Windows

Confidential, Atlanta, GA

MicroStrategy Consultant

Responsibilities:

  • Involved in the design/development life cycle including gathering requirements, user interaction and report design and development.
  • Generated and implemented MicroStrategy Reporting concepts by creating attributes, facts, Attribute Relationships and Hierarchies using MicroStrategy Architect.
  • Developed Metrics, filters, prompts to achieve the functionality of consistent reports for the Web.
  • Created Complex reports for Analysis with Transformations, Custom Groups and Complex Filters.
  • Designed Dashboards in 8.1.1 summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents.
  • Developed scorecards and dashboards that provide users a highly graphical, summary view of key metrics.
  • Extensively worked on creating datasets which involved creating advanced filters, prompts and metrics.
  • Involved in creating users and user group and restricting data to teams based on their access in MicroStrategy Desktop for testing the reports.
  • Used Built-in advanced functions in conjunction with metrics.
  • Extensively used MicroStrategy Desktop and Web to enable users to run pre-defined sales and inventory reports, build their own customized reports and download information into Excel spreadsheets.
  • Provided technical support and training for user groups. Worked with 5 FTE’s to develop a training document for business users and also was involved in several training session and presentations.

Environment: MicroStrategy Desktop 8.1.1, 8.1.2, SQLServer 2005, Crystal reports XI R2, BO Data Integrator 11.5.3, T-SQL, Requisite PRO, Clear Quest, and WindowsNT/2003

Confidential

Data Warehouse Designer/ Developer

Responsibilities:

  • Created SQL* loader control files script for moving data from flat files to staging area database
  • Created PL/SQL procedures, functions and packages for moving the data from staging area to final database
  • Written many database triggers for automatic updating the tables and views
  • Partitioned the fact tables and created materialized views to enhance the performance
  • Fine-tuning the database by creating indexes and running explain plan on SQL scripts
  • Database and log backups & restoration, backup strategies, scheduling the backups. Backing up System & User Databases and restoring them when necessary
  • Designed and deployed DTS Packages
  • Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance
  • Optimized the performance of various SQL scripts

Environment: Windows NT 4.0/2000/XP, Oracle 9i, PL/SQL, SQL*Loader, SQL* Plus, TOAD, SQL

Hire Now