SUMMARY

• 7 plus years of extensive experience in the field of Information Technology with Data Warehousing, Data Architecture, Data Modeling, Business Intelligence and ETL Applications.
• Good working knowledge of Software Development Life Cycle and contributions towards various artifacts during active development followed by quality and testing
• Solid experience in MicroStrategy 10/9.x/8.x using MicroStrategy Desktop, MicroStrategy Intelligence server, MicroStrategy Architect, Microstrategy Web, MicroStrategy Report Services, Microstrategy Object Manager, Microstrategy Command Manager, Microstrategy Integrity Manger and MicroStrategy Narrowcast Server
• Good understanding of fundamental Data warehousing concepts such as entity relational modeling, dimensional modeling, star and snowflake schemas, modeling data marts.
• Strong knowledge of Relational Database Design, Data Warehouse/OLAP concepts and methodologies
• Expertise in working with Schema Objects like Attributes, Facts, Tables, Transformations, Hierarchies, Functions and operators
• Extensively worked in creating and integrating Public Objects (Filters, Metrics, Prompts, Reports, Templates, Documents, Custom groups and Consolidations)
• Tested and validated all the reports by running queries against the warehouse. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Created intelligent cubes based on the user requirements & developed reports from cubes
• Used Advanced Prompts, Conditional Metrics, Transformation Metrics and Level Metrics for creating complex reports and generated Key Performance Indicators (KPI) metrics
• Good knowledge in creating interactive Dashboards, scorecards & visual insights
• Strong troubleshooting capabilities in Microstrategy Desktop
• Experienced working with ETL developers to find the balance between ETL and BI tool involvement to produce fast loading and functionally rich dashboards, documents and reports
• Created Physical/logical data models for big Data warehouse projects using ERWin.
• Cross functional experience working with business clients, developers, administrators and testers
• Coordinated with offshore team in developments, change management and problem solving
• Excellent verbal and written communication skills

TECHNICAL SKILLS

Business Intelligence: MicroStrategy Desktop, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Intelligence Server, Narrowcast Server, Business Objects, Tableau and QlikView

Databases: Oracle 8i/9i/10g, MS Access, MS SQL Server, Teradata, MySQL

Programming Languages: SQL, PL/SQL, Unix shell scripting, C, C++

Operating System: Windows, Linux, Unix, Mac OS X

ETL Tools: Datastage, Informatica

Email Clients: Microsoft Outlook, Lotus Notes

PROFESSIONAL EXPERIENCE

Confidential, Long Beach, CA

Microstrategy Developer

Responsibilities:

• Recognize source tables and columns and build Schema objects necessary for creation of project semantics and metadata
• Coordinate with Architect & Administrator in implementing different Schemas to fit the business requirements
• Worked on Prompts, filters, Conditional, Transformation and Level Metrics for creating complex reports
• Created grid reports with drill capabilities by using appropriate Facts, Attributes, Compound metrics and filters
• Created consolidations and custom groups in the repots according to the requirement
• Implemented pass through functions Apply Simple, Apply Comparison in filter definitions, attribute and metric definitions
• Used various VLDB properties at different levels to optimize the performance
• Used Transformations (table based, formula based) for comparative reports for Investment Operations
• Designed Interactive Dashboards & Visual insights in MicroStrategy Web & Mobile to assess business performance and monitor the overall business performance
• Developed Intelligent Cubes to slice and dice the data
• Participated in testing reports upgraded from 9.4.1 to 10
• Worked on Distribution Services to send the Reports automatically to respective users
• Developed dashboards/ scorecards for quick and easy visualization of business users
• Performed knowledge transfer to the business users and documented the general design of the reports
• Worked as production support for business users.

Environment: Microstrategy 10 (Desktop Reports, Web Intelligence Reports, OLAP Services, Architect, Narrowcast Server, Administration, Dashboards), Oracle 11g, SQL Server 2008, Windows

Confidential, Aiken, SC

MicroStrategy Consultant

Responsibilities:

• Gather requirements by interacting with business clients and end users
• Communicate with offshore development team to explain client requirements and develop reports
• Recognize source tables and columns and build Schema objects necessary for creation of project semantics and metadata
• Implemented different Schemas (Star and Snow Flake) to fit reporting, query and business analysis requirements
• Worked on Prompts, filters, Conditional, Transformation and Level Metrics for creating complex reports
• Created grid reports with drill capabilities by using appropriate Facts, Attributes, Compound metrics and filters
• Created consolidations and custom groups in the repots according to the requirement
• Perform Daily Checks for job Monitor, user sessions and Cache Monitor to keep the system stable
• Responsible for design and development of Narrowcast Services, Schedules, Subscription sets, documents for narrowcasting reports to file server/ via email
• Actively involved in walkthroughs and meetings with various cross functional teams to discuss on issues regarding MicroStrategy reports
• Worked with team lead and business analyst to provide support and contribution in preparing critical User Acceptance scenarios
• Deployed/migrated product in Quality and production environment using Object Manager; served as the subject matter expert for systems in production - helping to ensure a stable, robust production environment
• Production support, trouble-shooting and fixing of reports were handled successfully

Environment: MicroStrategy 9.4.1 (Architect, Web Intelligence, Object Manager, Integrity manager, Configuration Wizard), Informatica 9, Oracle 10GR2, Oracle Hyperion 11, Cognos Framework Manager 8, Report Studio 8, SQL, PL/SQL, Windows NT and UNIX.

Confidential, Columbus, GA

MicroStrategy Consultant

Responsibilities:

• Involved in Dimensional Modeling by selecting the business process, declaring the grain, and choosing the dimensions and facts
• Good understanding of the type of schemas that best support MicroStrategy in different scenarios
• Involved in project discussions related to Schema Objects which acts as a semantic layer for the MicroStrategy project
• Analyzed and developed Public Objects (Metrics, Reports, Documents, filters, prompts) using MicroStrategy Desktop and MicroStrategy web
• Created metrics (simple & compound), advanced filters, advanced prompts, advanced report designs and drill maps
• Involved in migration of Business Objects documents to Micro Strategy documents
• Developed Intelligent Cubes to slice and dice the data
• Tuning MicroStrategy Intelligence Server for better performance
• Extensively used MicroStrategy Report Services to generate Report Documents
• Involved in defining and designing the Report Templates
• Created various Monthly Dynamic Dashboard documents for Field marketing people with multiple panelstacks, selectors and customized widgets
• Created three types of reports to show the users - Enterprise reports, Dashboard analysis reports, Ad-hoc reports
• Developed dashboards/ scorecards for quick and easy visualization of business users

Environment: Microstrategy Desktop, Microstrategy Report Services, Microstrategy Web, Microstrategy Intelligence Server, Microstrategy Narrowcast Server, Informatica, Oracle SQL Developer, Windows Vista/XP.

Confidential, San Antonio, TX

MicroStrategy Developer

Responsibilities:

• Involved in developing logical data model by creating attributes, facts and relationships between attributes
• Used Advanced Prompts, Conditional, Transformation metrics and Level Metrics for creating complex reports
• Created several base formulas (mathematical expressions) using existing facts in MicroStrategy Desktop that can be re-used to build any number of metrics
• Created Derived elements and derived metrics in the repots according to the requirement
• Involved in troubleshooting Micro Strategy Prompts, Filters, Templates, Consolidations, and Custom groups
• Applied OLAP and statistical functions for analyzing the differences in the revenue generated by a particular segment of customers
• Enabled the Advanced Qualification option for the Filter Editor and created Custom Expressions to build Relationship filters according to the Business logic
• Implemented pass through functions Apply Simple, Apply Comparison in filter definitions, attribute and metric definitions
• Used various VLDB properties at different levels to optimize the performance
• Involved in performance tuning of reports and created intelligence cubes. Also, created reports against intelligence cubes to get the data faster

Environment: MicroStrategy 9.2.1 (Desktop, Architect, Intelligent Server, Web, Object Manager), Teradata 13.0, VLDB, Oracle 10GR2, Oracle Hyperion 11, Cognos Framework Manager.

Confidential

Jr. BI/MicroStrategy Analyst

Responsibilities:

• Clear understanding of the source systems, data flow and interacted with end users to collect business requirements.
• Created requirements documentation for MicroStrategy Projects as well as MicroStrategy Environment.
• Generated reports based on MicroStrategy Schema objects and Public Objects and other MicroStrategy Components
• Created reports using Complex Filters, Compound Metrics and Prompts
• Created and Used Advanced Prompts, Transformation Metrics and Level Metrics for complex reporting purposes
• Customized reports, documents that were later deployed to MicroStrategy Narrowcast Server
• Developed Ad-hoc reports by using Templates, Metrics and Filters for strategic business decision making using MicroStrategy
• Performed administrative tasks like Performance Tuning, Caching, Query Governing, Report Optimization, Maintenance and other Configuration Tasks
• Extensive experience using VLDB properties to tune performance with the SQL engine while dealing with Null values and Zeros in the data warehouse
• Tested reports created by business users for final deployment

Environment: MicroStrategy 8.0.2 (Administrator, Architect, Desktop, Object Manager), SQL Server, Informatica, Oracle 9i, HTML & DHTML.

Confidential

PL/SQL Developer

Responsibilities:

• Designed and developed complex procedures to handle errors and exceptions at both application and database level using PL/SQL and shell scripts.
• Used export and import utilities for logical backups.
• Analysed and discussed the business requirements with the business owners and business analysts.
• Optimized and modified the triggers, complex store functions, procedures.
• Wrote test scripts for testers to test the system before it goes to production.
• Maintained user accounts.
• Created PL/SQL Procedures, function Packages and SQL queries starting from middle level to high level complexity based on system needs
• Reorganized existing automated reporting scripting system to increase performance and reliability.
• Wrote technical design documents for conversions, extensions, interfaces, and reports.
• Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs).

Environment: Oracle 9i/10g, PL/SQL, HTML, SQL, TOAD, VSS, UNIX, Shell script.