SUMMARY:

• 8 years of strong experience in Business Intelligence in designing and implementing Web based and Stand alone software application with major focus on Data Warehousing and Database Applications.
• Extensive experience as MicroStrategy Developer, Architect & Administrator building projects and creating reports and Dashboards using MicroStrategy 7.i/ 7.5/8.0/8.1/9.0/9.0.1/10.0/10.4, Narrowcast Server, MicroStrategy Desktop, MicroStrategy Web, MDX Adapter, Office, MicroStrategy Intelligence Server and MicroStrategy Architect.
• Involved in training Business Users on MicroStrategy OLAP Services (such as view filter and derived metrics, Adhoc reports).
• Used MicroStrategy tools like Object Manager to migrate the objects/projects between MicroStrategy environments. Strong data modeling (Logical and Physical) experience with high proficiency in using Erwin for Dimensional Modeling (Star, Snowflake schemas) and Entity - Relationship Modeling.
• Experience in creating Report Service Documents, pixel perfect Dashboards and Visual Insight analytics templates.
• Installing and Configuring of MicroStrategy suite including MicroStrategy Desktop, Administrator, Intelligence Server, Web, and Narrowcast Server on NT Servers and Sun Solaris Environments.
• Creating users, user Groups and assigning security roles for the project.
• Monitoring user connections, caches and jobs.
• Developed basic and user-specified Metrics (level and conditional).
• Created drill maps for end users to drill down and recover data.
• Worked with Logical and physical modeling along with design and implementation.
• Involved in job scheduling, monitoring and production support in a 24/7 environment.
• Strong experience in understanding Business Applications, Business Dataflow and Data relations. Exception ability to quickly master new concepts and capable of working in-group as well as independently.
• SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Extensive knowledge of SQL, PL/SQL and worked on very large databases in Teradata V2R5/V2R4, Oracle 10g/9i/8i/7.x, and SQL Server 2005/2008.
• Excellent analytical and communication skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.

TECHNICAL SKILLS:

BI Tools: Micro strategy Desktop 7x/8x/9.x/10.x (Microstrategy Desktop, Microstrategy Web and Web Universal, Microstrategy Intelligence Server, Report Services, Documents, Dynamic Dashboards, Narrowcast server & Enterprise Manager.

Database: Oracle 8i/9i/10g/11g, Teradata, MY SQL, MS SQL server 2008/2005/2000, MS Access.

ETL Tools: Informatica Power Center 9.x/8.x, SQL Server SSIS services. Other Tools Toad, SQL Assistant, PL/SQL Developer, MS Office, Microsoft Visio, Erwin, DB Visio

PROFESSIONAL EXPERIENCE:

Confidential, MD

Sr. Micro Strategy Developer

Responsibilities:

• Involved in implementing the Full Life Cycle of the project starting with gathering requirements from the business users and documenting the specifications to delivering the end reporting solutions
• Created MicroStrategy Schema objects and Application objects by creating Attributes, Facts, User hierarchies, reports, filters and metrics using MicroStrategy Desktop
• Designed and Developed Reports and Templates (Standard and Ad Hoc) using complex Filters, Prompts and compound Metrics
• Experience in creating complex reports in MicroStrategy Desktop using features like Templates, Transformations, Custom Groups and Consolidations
• Extensively created MicroStrategy Report Services Documents, Dashboards for Web & Mobile (iPad) users
• Created Report Builder, Visual Insight screens for power users to help them create their own reports, dashboards
• Depending on the requirement, used database specific MicroStrategy OLAP pass through functions like ApplySimple, Apply Comparison to overcome complex logic in creating objects
• Widely used VLDB properties to set default criteria at project level and at individual report levels to overcome performance issues
• Created Intelligence Cubes in MicroStrategy to overcome performance issues related to Report Service Documents using high volume datasets. Using Intelligent cubes improved performance of the RS documents significantly
• Analyzed existing SAP Business Objects reports, documented the Technical specifications and converted SAP Business Objects reports to MicroStrategy for CRES Workplace Utilization project
• Used the Object Manager to migrate the objects from Development to UAT environment in MicroStrategy
• Involved in MicroStrategy Upgrade to 9.4.1 and then to version 10.4. Used MicroStrategy Integrity Manager for regression testing during upgrade
• Used Narrowcast Server to automate FX TCA Order Completion reports, Aggregate reports to internal and external clients
• Involved in MicroStrategy migration from Solaris to Linux, also database migration from Physical Oracle database to DHS Virtual hosts

Environment: MicroStrategy 10/9.4.1 (Intelligence Server, Administrator, Desktop/Developer, Web, Distribution Services, Visual Insight, Mobile, Object Manager, Command Manager, OLAP), UNIX, Windows Server, Oracle 11g, DB2.

Confidential, Pittsburg, PA

Sr. Micro Strategy Developer

Responsibilities:

• Involved in the documentation of technical specifications of the Sales and Inventory Project.
• Worked with Connectivity Configuration Wizard to configure the Metadata connectivity information, metadata DSN name etc.
• Created different Project Sources for different environments like production, testing and development.
• Created different schema objects like Attributes, facts by using Micro-Strategy Architect of the Micro-Strategy BI Suite.
• Extensively worked on Desktop to create Applications Objects, Reports and Dashboards (Documents & Scorecards).
• Generated reports using Advanced Metric objects, Filters, Prompts and also created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
• Involved in creating MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports
• Created Ad-hoc reports by gathering specific requirements from the different users.
• Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
• Using Informatica Power Center Designer analyzed the source data to Extract & Transform from various source systems.
• Created Data mart Reports, Partition Mappings and Aggregate tables to improve performance of reports.
• Worked in MicroStrategy Administration creating new users, roles, privileges, shared folders, access controls Lists.
• Worked on Narrowcast Server Application environment creating services using subscription sets, schedules, and Information objects.
• Also tuned ODBC driver to improve data transfer rates between database and MicroStrategy servers located at different physical locations.
• Used database specific MicroStrategy OLAP pass through functions like Apply Simple,
• Involved in production support (24/7)
• Maintained a stable platform by proactively identifying and resolving any issues or bugs.

Environment: MicroStrategy 10/9.4.1 (Intelligence Server, Administrator, Desktop/Developer, Web, Distribution Services, Visual Insight, Mobile, Object Manager, Command Manager, OLAP), UNIX, Windows Server, Oracle 11g, Sybase.

Confidential, Newark, NJ

Sr. Micro Strategy Developer

Responsibilities:

• Worked with business users to gather requirements and prepared technical specification Documents.
• Understanding the reporting requirements and developed the reports and redesigned the legacy reports in MicroStrategy
• Involved in Dimensional Data Modeling, Data Architecture, Business and Data Analysis
• Developed MicroStrategy Schema objects and Application objects like Metrics, Filters, Prompts, Consolidations, Custom Groups and Project objects like Subtotals.
• Designed Reports, Documents and Dashboards using Desktop.
• Created advanced metrics (level, conditional), filters, consolidations, custom groups and reports with VLDB properties.
• Created ad-hoc reports by drilling up, down, within and across Hierarchies.
• Created Transformations to calculate YTD (Year to date), MTD (Month to date) metrics
• Implemented Report Data Options, Formatting, Dynamic Dates, Advanced Sorting, Prompt Ordering, and Totals, Outline Mode based upon the business user change request during UAT Testing.
• Validated end user report requests using SQL queries and MicroStrategy tools.
• Using Object Manager to move the reports from Development Project to QA/Production Project.
• Involved in Deployment and Administration on SSIS packages with Business Intelligence development studio.
• Involved in extracting the data using SSIS from OLTP to OLAP
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
• Involved in optimization of code and tuning queries for performance.
• Production Support has been provided for ongoing issues.

Environment: MicroStrategy 9.4.1/9.3 (Administrator, Desktop, Web, Distribution Services, Object Manager, Command Manager, Narrowcast server), UNIX, Windows Server, SQL server.

Confidential, Boston, MA

Microstrategy Devleper

Responsibilities:

• Using Object Manager to move the reports from Development Project to QA/Production Project.
• Involved in providing solutions for Complex Time Dimension related issues
• Designed MicroStrategy Schema objects and Application objects by creating Facts, Attributes, Hierarchies, Reports, Filters, Metrics and Templates using MicroStrategy Desktop and Architect.
• Worked extensively on Complex reporting needs, which involved creating Consolidations and Custom Groups.
• Enabled the Advanced Qualification option for the Filter Editor and created Custom Expressions to build Relationship filters according to the Business logic
• Created the Analytical engine bypass functions like Apply Simple & Apply Comparison whenever necessary.
• Created different Transformations to get the last year actual transactions, Month to Date (MTD), Quarter to Date (QTD), Year to date (YTD) calculations and effectively used them with the metrics
• Implemented Drill Maps functionality in various reports
• Used the Object Manager to migrate objects between DEV, UAT and Production environments
• Optimized Query Performance using VLDB settings
• Created and configured the Narrowcast Server to execute and deliver reports to your emails using dynamic subscriptions
• Worked as MicroStrategy support admin to handle some of the administrative tasks.

Environment: MicroStrategy 9.3/9.0 (Administrator, Desktop, Web, Distribution Services, Object Manager, Command Manager, Narrowcast server), Windows Server, SQL server

Confidential, Beaverton, OR

BI Devleper

Responsibilities:

• In design/development life cycle including gathering requirements, user interaction and report design and development
• Developed Metrics, Filters, Prompts to achieve the functionality of the canned reports and created advanced objects like Derived Metrics, Compound Metrics.
• Developed MicroStrategy Dynamic Dashboards in the Flash Mode using several controls and worked extensively on widgets.
• Configured Enterprise Manger and developed customized reports to depict the usage and performance of reports, User activity and Cache analysis.
• Created several data marts using MSTR for different tools to access large datasets.
• Worked closely with all aspects of the Business Intelligence group in order to deliver the required solutions in a timely manner.
• Customized and optimized reports for various users using MicroStrategy features like VLDB properties at Project level and report level.
• Worked with end users along with Business Analysts to build reports and dynamic dashboards.
• Worked with the DBA on issues of database performance and security.
• Worked on administrative tasks like User Groups, Roles, Privileges, and Cache Management.
• Involved extensively in the overall lifecycle of the Data Warehouse integration project.

Environment: MicroStrategy 9.x/8.x (Administrator, Desktop, Web, Distribution Services, Object Manager, Command Manager, Narrowcast server), Linux, Windows Server, SQL server, Oracle.

Confidential,

MicroStrategy Developer

Responsibilities:

• Started with gathering requirements from the users and documenting the specifications
• Created the Report Specification document and had it signed of, after suggesting some useful alterations.
• Analyzed the source system data
• Creation of new users, roles, privileges, shared folders, access controls Lists using security roles in MicroStrategy
• Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop
• Created Complex Metrics forcing Dimensionality and Conditionality which are mainly used in Client scorecards, summary, detail level reports and trending related reports
• Created Complex reports for Analysis with Transformations, Custom Groups and Complex Filters
• Created Complex filters with advanced qualifications involving the ‘Apply’ functions
• Used MicroStrategy Narrowcast Server to monitor the business data and alert the users to unexpected exceptions and trends
• Created Report Service documents with both Grids and graphs as per user requirements
• Tuning of SQL Scripts, Analyzing the Tables, Indexes, Involved in Data cleansing.
• Tested all the reports by running queries against the warehouse-using TOAD. Also compared those queries with the MicroStrategy SQL engine generated queries
• Reduced the time taken for the reports to run by taking advantages of VLDB properties like star join, query and sub query optimizations for oracle 9i and SQL hints
• Played a key role in User Acceptance Testing of the reports.

Environment: MicroStrategy 8.x.x (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), SQL Server 2008, Teradata.