Summary:
7+ years ofProfessional experience in Design, Development and Implementation of Data Warehousing applications, with proficiency in Making Reports, Scorecards, Dashboards using MicroStrategy 9/8i/7i/7.0/6.0. Over 6 years of strong experience in MicroStrategy 7.x/8.x/9.x, which includes Micro Strategy Desktop, MicroStrategy Web, MicroStrategy Intelligence server, MicroStrategy Developer, MicroStrategy Architect, MicroStrategy OLAP Services. Full life cycle implementation encompassing Business requirements definition, Data Analysis, Data Warehouse Architecture, Logical Data modeling and Physical Data modeling and Validations. Good knowledge in Star schema and Snowflake Schema. Experience in BI applications in many industrial sectors like retail, Finance, Banking, pharmaceutical, payments technology and Health insurance. Expert in Architecture of creating Schema objects with MicroStrategy Desktop like Facts, Attributes, Hierarchies, Transformations, Fact extensions. Extensive experience in creating and integrating MicroStrategy Reports and Application Objects like Filters, Metrics, Prompts, Custom Groups, Consolidations with the data warehouse. Experienced in creating Advanced Metrics, Advanced Prompts, Advanced Filters in MicroStrategy Reports development and also created Data Mart reports using complex filters and compound metrics. Configured Enterprise Manager and Object Manager in MicroStrategy. Good knowledge of MicroStrategy Web and Web Administration. Expertise in Schedule and Delivered reports in Desktop and Web via Narrowcast Server to multiple users. Expertise in creating Intelligent Cubes which is optimized for reducing total Database Time, Job Load. Expertise in creating interactive Dashboard Reports and Scorecards reports based on user requirements. Worked extensively on customizing and optimizing the query performance of report using VLDB property like star join, query and sub query. Familiar with Data Management Systems-SQL Server, Oracle, Teradata, DB2. Strong working knowledge of SQL, ability to understand and write complex SQL queries using Stored Procedures, Joins, Views, Triggers and Indexing strategies. Used ETL methodology for supporting Data Extraction, Data transformations and Data Loading process, in a corporate-wide ETL solution, Dimensional modeling, Star schema, Snowflake modeling, Data marts, Normalized data models and De-Normalized data models using fact and dimension tables. Well-Organized, Quick learner, Self-motivated Team Player and have experience in all phases of the Systems Life Cycle. Ability to adjust to new and challenging situations with experience in handling high pressure situations and problem solving. Excellent analytical, programming, written, verbal, communication and interpersonal skills and Leadership Qualities. Technical Skills
BI Tools: MicroStrategy 9.0/8.1.x/7.5.x [Desktop, Architect, Intelligence Server, Project Builder, Narrowcast Server, Distribution services, OLAP services, RS Documents, Score Cards, Dashboards, Command Manager, Enterprise Manager, Object Manager], Business Objects Web Intelligence
ETL Tools:
Data Stage 7.5, Informatica 8.1/7.1/6.2.
Operating Systems:
Windows 2000/XP-Pro/Vista/7, UNIX/ LINUX
Languages:
C & C++, SQL, PL/SQL, VB.NET, HTML 4.0
Modeling Tools:
ERwin 4.0/3.5.x/3.0, Microsoft Visio 2002.
RDBMS:
Oracle 10g/9i/8i/8.0, IBM DB2, MS Access 2003/2007, SQL server 2000/2005/2008, Teradata V2R5.
Professional Experience
Confidential,New Jersey, NJ Jan 2011- Present
MicroStrategy Developer/ Architect
Confidential,is one the companies which provides the banking services in USA. This project was involved in building reports based on accounts, products and customers and also created enterprise manager reports for various analyses.
Responsibilities:
.
Performed customer Requirements Gathering, requirements Analysis, Design, Development, Testing, end User Acceptance Presentations of BI Projects. Ensures the testing and verification of new reporting processes Used MicroStrategy Web to offer interactive reporting to the end users through a web browser. Worked extensively on creating MicroStrategy Objects like Metrics, Compound Metrics, Facts, Filters, Custom Group, Consolidation, Attributes, Hierarchies and Prompts for MicroStrategy reports using MicroStrategy Architect. Performed Administrator tasks like User Creation and Creating Privileges Scheduled and Delivered Reports to Business Users in Desktop and Web via Narrowcast Server. Worked with MicroStrategy Object Manager to move objects among the Development, Testing and Production environments. Designed Advanced filter, Advanced metrics, Advanced Prompts to create complex reports. Created Drilling reports across different within the Hierarchy and other hierarchies. Implemented Transformations using in comparative reports like revenue this year to last year. Involved in troubleshooting of MicroStrategy Prompts, Filters, Templates, Consolidations, Custom Groups objects in an Enterprise data warehouse team environment. Created Intelligent Cube to decrease the Load on server while users watching same reports same time. Taken advantages of VLDB properties like star join, query and sub query optimization to optimize the query. Automated and improved existing manual processes and Optimizing the server platforms using Caching and Scheduling. Created reports using MDX Data source and Free Form SQL. Worked with DBA to provide requirements for necessary back end tables. Worked with Database Architect and ETL Developer for Data availability and data model related issues by providing solutions that support MicroStrategy application. Extensively worked in both Ad-hoc and standard reporting Environments and Involved in creating reports scalable to large volumes of data. Created a wide variety of fully interactive scorecards, dashboards, and enterprise reports. Created dynamic dashboard using Widget, Panels, Selectors, Map, Graphs and Grid. Involved in the ongoing delivery of migrating client mini-data warehouses or functional data-marts from Oracle environment to Teradata. Environment:
Microstrategy 9.0.1 (Desktop, Architect, Intelligent Server, Web, Narrowcast Server, Object Manager,Teradata 13, SQL Assistant, Db2,Oracle 10, PL/SQL,LINUX, Windows XP Professional, UNIX.
Confidential,King of Prussia, PA Oct 2010-Jan 2011 MicroStrategy Developer
Confidential,is the nation\'s leading provider of specialty managed care services for the workers\' compensation community. The Medrisk expert provider network is accessible to all claims adjusters, nurse case managers, prescribing physicians, and injured workers. This project was about to generates reports on their prescription, patients and regards their products.
Responsibilities:
Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using Microstrategy Desktop and Architect. Worked extensively on creating Application Objects like Metrics and Compound metrics, Filters, and Custom Groups for complex reports. Created Complex filters with advanced qualifications involving the ‘Pass through’ functions. Involved in troubleshooting Microstrategy Prompts, Filters, Templates, Consolidations, and Custom groups in an enterprise data warehouse team environment. Created comparative reports using Transformations like (Year to date, Month to Date). Implemented Intelligent Cube to decrease the Load on server while users watching same reports same time. Used Intelligent Cube Monitor and Cube Advisor to optimized memory use of server. Extensively worked on Hierarchy/Parent-Child relations for attributes. Created Data Mart and Freeform reports in order to overcome the Data Model deficiencies. Identified Source tables and columns required to create a MicroStrategy project, which references Teradata database Created Interactive and Dynamic Dashboards in Flash modes for Business Users using Widgets, Panels, Selector Controls, etc. and trained BU to best utilize the advanced features in MicroStrategy for Dashboards. For testing purposes created and implemented multiple tests and test cases (unit, regression, and user acceptance tests) for the products report in both web and desktop environments to ensure the report results were complete and accurate. Involved Upgrading the MicroStrategy environment from 8.0 to 8.1 and then 8.1 to 9.0. Extensively used Narrowcast Server for delivering the reports to the BU by using Services, Information Objects, Question Objects, Documents and using the File device to save the reports to a location. Created User Acceptance Presentations Using MS PowerPoint. In the report also included other non-functional features such as security, performance, portability, scheduling, data retention, data availability and governance limits. Tested all the reports by running queries against the warehouse-using SQL Assistant. Also compared those queries with the MicroStrategy SQL engine generated queries.
Environment:
MicroStrategy 8.0/8.1/9.0, MicroStrategy Agent, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Narrowcast Server, Microstrategy Architect, Oracle9i, Teradata (FastLoad, MultiLoad, FastExport, TPump), ERWIN, UNIX, Windows 2000 Server, Windows XP Professional, Toad.
Confidential,Highlands Ranch, CO Jan 2010- Sep 2010 MicroStrategy Developer
Confidential,is a global payments technology company that enables consumers, businesses, financial institutions and governments to use digital currency instead of cash and checks. The project was about to building reports on customer’s details, products and accounts.
Responsibilities:
Gathered and analyzed business requirements from clients and end users to make reports. Identified base tables in the Visa check card system in the Oracle environment. These tables were mapped to the Snowflake dimensional data mart in Teradata Enterprise Data warehouse (EDW). The new dimensional data mart formed the source for MicroStrategy reporting. Worked closely with data modeling and ETL teams to develop the data model. Developed the logical and physical data models, created data definition language statements and worked with database administrators to transition these models to database administrators for successful physical implementation. Used MicroStrategy Desktop 8.0.1 to build schema objects, Hierarchies, Transformations, Attributes, Facts and Relationships as a function of the logical model. Involved in the creating Document from multiple Datasets likeMap Application Diagram, Grid and graph. Created Profitability Analysis reports based on account, product and customer. Extensively used filters, prompts, consolidations and custom groups to generate canned reports and ad hoc reports. Applied OLAP and statistical functions for analyzing the differences in the revenue generated by a particular segment of customers. Resolved attribute role problems in Data models by developing table Aliases and Attribute Role recognition methods in VLDB settings. Created Transformations for using in comparative reports like revenue this year to last year. Used MicroStrategy report services to create dashboards. Worked extensively on customizing and optimizing the query performance of reports for various users using MicroStrategy features like VLDB property and changing database properties like adding indexes, creating aggregate tables and partition strategies. Scheduled reports through the MicroStrategy Narrowcast server and created services to deliver a wide range of personalized information to users through email. Used Project documentation feature: Documented all MicroStrategy objects like reports, prompts, filters and metrics for user reference. Developed reports for MicroStrategy Web users.
Environment:
MicroStrategy 8.0.1 (Desktop, Architect, Report Services, Web), Teradata, Informatica 8.2, DTS, SQL Server 2000/2005, Oracle 10g, MS Office, Windows XP, UNIX, LINUX.
Confidential,Middletown, CT April 2009- Dec 2009
MicroStrategy Developer
Confidential,is health insurance company, providing a range of traditional and insurance products and related services. The project involved in making reports on issued health insurance by year, departments, and regarding their policies.
Responsibilities:
Extensively created filters, facts, Consolidations, Transformations and Custom Groups using MicroStrategy Desktop to generate reports for the Business analysis. Used pass-through functions (applysimple and applycomp) in attributes and filters definitions. Involved in creating MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports. Created ad-hoc reports by drilling up, down, within and across dimensions. Developed Informatica Power Center mappings using transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy Created Metrics, Filters, Attribute-to-Attribute qualification, Metric-to-Metric qualification prompts using MicroStrategy for report development. Worked along withMicrostrategyKnowledge Base to troubleshoot some Report related issues. Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes, Cursors and Views in Development and Production environment in PL/SQL and SQL*Plus. Worked in writing SQL Queries (Sub queries and Join conditions, correlated sub queries) Involved in back end development of Oracle PL/SQL objects for report creation.
Environment:
Environment:MicroStrategy7.5.2 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, MDX Adapter) Oracle, SQL Server, Informatica, IBM DB2, ASP, XSL, HTML
Confidential,Atlanta, GA Feb 2008- March 2009
MicroStrategy Developer
Confidential,is products and services. The project was about to create sales report of different products and keep the track on them for better management purpose.
Responsibilities:
Used MicroStrategy Desktop in creating different Reports to meet the in-house Business Requirements. Generated and implemented advanced MicroStrategy Reports concepts by creating Projects, Attributes, Hierarchies, Facts, Metrics, Filters, and Templates using MicroStrategy Architect, MicroStrategy Agent. Extensively used Filters, Facts, Consolidations, Transformations and Custom Groups to generate reports for Business analysis. Gone through various Levels of Dimensionalities to execute the reports with different result sets. Used Project Creation wizard for creating Facts and Attributes. Created Complex Metrics using different Conditional and Level settings. Created Complex reports for Analysis with Transformations, Custom Groups and Complex Filters. Created Complex Filters with advanced qualifications involving the \'Apply\' functions. Involved in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom Group objects in an enterprise data warehouse team environment. Created Transformations for using in comparative reports like Sales this year to Sales last year. Created reports for sales and marketing with the drill down methodology in all options. Tested all the reports by running queries against the warehouse-using Queryman. 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.
Environment:
MicroStrategy 7.5/8.0, Desktop, Narrowcast Server, Informatica 6.2, Teradata V2R5, UNIX/LINUX, Window XP, oracle 9i,SQL.
Confidential,Mumbai February 2007- November 2007 MicroStrategy Developer
.
Responsibilities:
Architected Schema Objects such as attributes, facts and transformations. Troubleshootingwith MicroStrategyprompt, Filter, Template, Consolidation, and Custom Group objects in an enterprise data warehouse team environment. Created reports with various Object Prompts to generate various Adhoc reports. Created Enterprise Manager Reports for various analyses. Collected PRDs from various departments and created reports and dashboards as per business requirements and analyzed users feedback to make enhancements to the newly created reports and documents, from time to time. Including creating timely/thorough status reports and leading status meetings Created Transformations for using in comparative reports like Sales this year to Sales last year. Created profitability analysis reports based on accounts, products and customers. Involved in and provided solutions for complex Time Dimension related issues and analysis. Created various report services and Dashboard documents on sales sent monthly to vendors.. Worked with MicroStrategy Object Manager to move objects among the Development, Testing and Production environments. Environment:
MicroStrategy 8.1.1 (Desktop, Administrator, Web), MicroStrategy Intelligence Server 8.1.1, V2R5, Informatica 7.1 Windows XP-Pro, UNIX, LINUX
Confidential,Kalol Jan 2004 – Dec 2006
SQL Developer
Responsibilities:
Performed System Analysis, Dataflow Diagram, Entity Relationship Diagram (ERD) and Created tables. Prepared prototype screens and reports and set standards. Involved in the Design and Development of the product. Developed various user interfaces and report presentation mainly for on-line analysis using Oracle Forms 4.0, Reports 2.0 and interfaces between them. Responsible for writing Stored Procedures using PL/SQL and designing the reports. Used PL/SQL extensively for writing Functions and Database Triggers. Performed Database testing & maintaining the data by using the procedures. Designed and validated the Forms according to client requirement by using VB. Performing Data Transfer/Migration using Export/Import. Involved in developing cross-reference and report generation programs. Environment:
MS-SQL Server 2000, Developer 2000(Forms 4.0, Reports 2.0), SQL, PL/SQL, UNIX, Windows
Education
Bachelors in computer Application
Privacy Policy
