SUMMARY

• Over 8+ years of IT experience in gathering requirements, documentation, developing, designing, testing, implementing, and deploying BI Solutions.
• Over 5 years of extensive experience utilizing the MicroStrategy Suite (MicroStrategy Desktop, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, MicroStrategy Architect, MicroStrategy Web, MicroStrategy OLAP services and MicroStrategy Distributed Services).
• Designing Data Marts using different multi - dimensional modeling techniques such as Star Schema and Snowflake Schema, Fact and Dimensional tables, Logical and Physical data modeling.
• Extensively worked on Geo-Maps in projecting the performance analysis in terms of revenue and sales all across United States. For example, in one of my project in Autotrader, I used the concept of Geo Maps to project the user with the flexible analysis capabilities. In which state or city a particular Dealer is performing good in terms of sales and which region falls low in inventory and many things. Even the user has the flexibility to drill to a particular dealership and compare the results with the nearby competitor.
• Experience in working with data modelers to translate business rules/requirements into conceptual/logical dimensional models and worked with complex de-normalized and normalized data models.
• Expertise in working on both Direct Project Source (Two-Tier) and Server Project source (Three-Tier).
• Well versed in designing the reporting applications according to BRD, SRS and TDS.
• Good experience in schema objects (Facts, Attributes, Hierarchies, and Transformations).
• Expertise in developing Application Objects (filters, prompts, metrics, Custom Groups, Consolidations, DrillMaps, Templates, Searches), developed Reports, Documents and Dashboards .
• Good experience with pass-through Expressions like Apply Simple and Apply Comparison to develop complex Filters and Transformations.
• Extensively worked in creating and integrating MicroStrategy objects (Reports, Attributes, Filters, Metrics, Facts, Prompts, Custom Groups and consolidations) with the data warehouse.
• Expertise in developing Reports by using Freeform SQL Queries and Logical Views in MicroStrategy Desktop.
• Expertise in creating dashboard reports in an Interactive and Flash Mode by using Selector, Sliders and Widgets to view personalized reports based on user requirements.
• Expertise in fine tuning of the MicroStrategy reports using Data Mart Reports, Partition Mappings, Aggregate Tables and Intelligent Cubes.
• Good knowledge in using administration tools like System Monitor, System Administration, User Manager, Object Manager and Command Manager.
• Experience in code optimization and performance tuning of database queries both in MicroStrategy environment and in database.
• Experience in problem solving and delivering practical solutions.
• Responsible for MSTR On-Call Support on Rotation Basis.
• Proven ability to work under pressure, prioritize and meet deadlines. Open to dynamic work environment and ability to work collaboratively with business analysts, testers, developers and other team members in the overall enhancement of software product quality
• Excellent communication skills, Self-starter, good team player, enthusiastic, innovative and challenge oriented.

TECHNICAL SKILLS

Business Intelligence: MicroStrategy 9.3/9.2.1/9.0.2/8.1.2/8.1.1/8.0.2 (MicroStrategy Desktop, Web, Intelligence Server, OLAP Services, Report Services, Narrowcast Server, Command Manager, Administration), Business Objects XIR2/6.5,Cognos 8.4.1,SSIS,SSRS,SSAS, Framework Manager, Query Studio, Report Studio, MicroStrategy Mobile Application for iPad and iPhone

SAS Tools: SAS V9.1, SAS/BASE, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/ SQL, SAS/ACCESS, SAS/ODS

ETL: Informatica 8.6.1/8.1/7. x/ 6.x, Oracle warehouse Builder 10.2, DataStage 7.5.2

Operating systems: Windows 95/98/2000, Windows XP, UNIX, DOS, Mainframes

Data bases: Oracle 10g/9i/8i, SAP, MS SQL Server 2000/2005, Netezza 5.0, DB2 7.0, Teradata 13/12/11.

Office Tools: MS Word, Excel/VBA, Access, PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, Grand Rapids, MI

MicroStrategy Consultant

Responsibilities:

• Created Complex reports and dashboards for Pricing Analytics Team with the drill down methodology in all options.
• Involved in developing MicroStrategy Dynamic Dashboards in the Flash Mode using several controls and widgets like micro charts, time series slider, fish eye, radio boxes, Gauges.
• Enhanced existing dashboards and scorecards using KPIs and enabling drill functionality.
• Implement OLAP functionality within report service documents to enhance performance.
• Created mockup versions of dashboards and presented to the stake holders to make sure it was effective on usability perspective.
• Tested and validated all the reports by running queries against the warehouse. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Built and optimized intelligent cubes for the Visual Insights Tool in MSTR 9.2.1 by configuring working memory set, working memory and VLDB properties.
• Created customized Custom Groups with complex filters and Relationship filters.
• Created Metrics, Prompts, Filters, Custom Groups and Transformations for the report development.
• Extensively used report services to create dashboards to create summary level reports using multiple datasets.
• Reduced the time taken for the reports to run by taking advantages of VLDB properties like star join, query and sub query optimizations.
• Fixed Defects and performed upgrades for existing projects.
• Ensured proper relationships were established between the attributes to avoid any improper SQL query joins.
• Worked extensively with the compliance officer to finalize the dashboard layouts and also worked on fine detail formatting for a desired look and feel.
• Created logical views in MicroStrategy for complex report creations situations.
• Designed and developed several Intelligent Cubes and its incremental refresh design, defining incremental refresh rules, Cube maintenance and support etc.
• Planning and Design Narrowcast development
• Service development
• Debugging service failure
• Automation of event based service execution
• Narrowcast Design and test case document

Environment: MicroStrategy Suit 9.3.1, Narrowcast Server, Teradata V2R12/13, Teradata SQL Assistant 12, Windows 8.

Confidential, Atlanta, GA

Sr. MicroStrategy Consultant

Responsibilities:

• Interacted with the Business Analysts and Enterprise users.
• Architecting the schema objects Attributes, Facts, Hierarchies.
• Worked on Geographical maps this allows users to drill to their own respective regions and other types of graphical representation of data (heat maps).
• Worked on advanced visualizations like interactive heat maps and bubble charts and grid of graphs.
• Heatmap advanced data analysis widget allows a user to look at the data in 2 dimensions. One is the size of the heatmap bar, which depicts the relative size of the metric data. Second metric, gives the color to the data. We can design a heatmap to show these kind of analysis, when a user wants to see the data in size and colors.
• Development of Data Models (physical/logical) using Erwin tool as KBB data and reporting requirements are completely different from the existing scenario.
• Extensively giving mock-ups to the Enterprise user to better understand the reporting analysis and also making their life easier.
• Development interactive dashboards and scorecards for high level management.
• Designed the configuration objects Filters, Base Metrics, Derived Metrics, Templates and Reports.
• Involved in changing the existing Sales Organization Hierarchy, which is required to be modified as underlying data were reorganized.
• Analyzed the best way of approaching towards the reporting with minimum amount of maintenance effort, QA work and also giving the flexibility to the users to pick and choose whatever data they like from different key tables.
• Assisted the team in integrating the current project with new Enterprise analytics.
• Optimized query performance by updating VLDB (very large database) properties and by modifying cache behavior.
• Worked on SDK (Software development Kit) environment to enables easy customization and integration of the MicroStrategy BI platform with enterprise business applications
• Optimized query performance by updating VLDB properties at project level and report level.
• Customized the drilling options specific to the reports using drill map editor to give access to more detailed and supplemental information.
• Assisted the team in identifying the errors in the underlying data.
• Customized reports using Custom Groups and Consolidations.
• Designed Compound metrics and Complex filters and Time filters.
• Developed various Prompts supporting end users to interactively choose different filtering criterion.
• Configured Data Marts in MicroStrategy Desktop to update tables in database.
• Performed optimizations using Report Data Options.
• Used MicroStrategy Web to offer interactive reporting to the end users through a web browser
• Extensively used MicroStrategy Web to enable users to run-predefined sales and inventory reports for building their own customized reports.
• Unit tested the reports developed by the other developers.

Environment: MicroStrategy 9.3,9.2.1, Architect, Web Intelligence, SDK, Teradata13,Object Manager, Integrity manager, Configuration Wizard, Informatica 9, Report Studio 8,Netezza 5.0, Windows NT and UNIX.

Confidential, CA

Sr. MicroStrategy Consultant

Responsibilities:

• Co-ordinate meetings with clients and business users to discuss and understand requirements.
• Discussion with data modelers to understand data modeling of existing schema.
• Worked with client to gather requirements and prepared technical specifications documents.
• Responsible for the preparation and presentation of proto-type reports to end users and get acceptance to develop reports.
• Building schema objects: Highly involved in building schema objects in MSTR with Teradata as the backend. I was involved in Architecture meeting where we discussed the schematic layer (tables and views) and discussed the better way to address the schema in MSTR. Teradata, being a robust tool allows a MSTR architect to build schema in such a way that supports the all features of Teradata. Building schema in MSTR with Teradata as backend is similar to building schema with any other DB tool, except Teradata has its own data fetching capabilities with its unique data processing units.
• Expertise in using Apply simple Function in Attributes and Metrics to make manipulations to values.
• Responsible in developing of public objects (Filters, Prompts, Metrics, Consolidations, Custom Groups, Templates and Reports) on top of Schema Objects
• Responsible for the creation of metrics like Compound metric, Derived Metric, Filter Metric and Transformation metric to generate more complex MicroStrategy reports in an efficient way.
• Worked on Geographical maps which allows users to drill to their own respective regions
• Creation of logical views and Freeform SQL Reports.
• Synthesize and translate Business data needs into creative visualizations in Tableau
• Used Apply Simple and Apply Comparison functions to develop Advanced Filters and Transformations
• Creation of reports at Aggregate Level as well as Detail Level Tables to retrieve data in an efficient way.
• Setting of VLDB Properties to improve performance of reports as well as passing hints to the SQL queries.
• Creating Dense Rank function metric at report level to generate sequence numbers for PDE Transactions.
• Highly involved in developing dashboard reports in MicroStrategy by combining multiple reports in Cognos by using selectors. moving the objects between two projects and two different environments by using Object Manager and resolve conflicts between environments by using conflicts resolution window
• Creation of Users/User Groups and assigning appropriate privileges through User Manager in Administration.

Environment: MicroStrategy9.2,9.0.1, Architect, Web Intelligence, Object Manager, Cognos8.4.1 Framework Manager, Query Studio, Report Studio, Informatica8.6.1, Teradata 13, DB2 8.x/9.1, Oracle 10GR2, SAP, SQL, PL/ SQL, Windows NT and UNIX.

Confidential, Edison, NJ

Sr. MicroStrategy Consultant

Responsibilities:

• Interacted with the Business Analysts and Enterprise users designing ad-hoc reports.
• Architected the schema objects Attributes, Compound Attributes, Facts, Hierarchies.
• Development of Data Models (physical/logical) using Erwin tool.
• Designed the configuration objects Filters, Base Metrics, Derived Metrics, Templates and Reports.
• Changing the existing Sales Organization Hierarchy, which is required to be modified as underlying data were reorganized?
• Extensive use of Location Intelligence Components (LIC), mainly in building geographical queries and geographic drilldown.
• Worked on Geographical maps and heat maps this gives the flexibility to look at the business at different levels of regions.
• Assisted the team in integrating the current project with new Customer inventory analytics.
• Extensively created Documents, Publications and Services and assisted the MicroStrategy Developer in creating Narrowcast objects.
• Assisted the team in identifying the errors in the underlying data.
• Customized reports using Custom Groups and Consolidations.
• Designed Compound metrics and Complex filters and Time filters.
• Developed various Prompts supporting end users to interactively choose different filtering criterion.
• Configured Data Marts in MicroStrategy Desktop to update tables in database.
• Optimized query performance by updating VLDB properties at project level and report level.
• Performed optimizations using Report Data Options.
• Extensively used MicroStrategy Web to enable users to run-predefined sales and inventory reports for building their own customized reports.

Environment: MicroStrategy 9.0.2, 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, San Antonio, TX

MicroStrategy Developer

Responsibilities:

• Worked with the business analyst and executives to understand requirements for the Executive dashboard and designed the prototype.
• Collaborate with database architect and ETL developers to aid in the design of efficient and robust data structures for reporting and analysis.
• Architected the Schema for the project by creating facts, attributes, and hierarchies.
• Created the application objects metrics, filters, Prompts and Reports using MicroStrategy Desktop to meet report requirements.
• Created daily, monthly reports and dashboards for iPhone, iPad using MicroStrategy mobile.
• Dashboard design--Utilized standard templates and added panels.
• Worked on advanced visualizations like interactive heat maps and bubble charts and grid of graphs.
• OLAP services & Intelligent cube design for advanced analytics and Trend analysis reporting.
• Developed the OLAP services by creating the cubes, view filters and derived elements to improve the performance of the Executive dashboards.
• Designed and built pixel perfect report service documents and interactive Flash dashboards.
• Build the report builder interface for the Ad-hoc Analysis.
• Created transformations using Transformations by tables for YTD and MTD for Time Series Analysis.
• Set up the distribution services for distributing the report output to the different levels of users.
• Involved in troubleshooting MicroStrategy Web Reports, and optimizing the SQL using the VLDB properties.
• Resolved the defects during the QA and UAT testing process.
• Having experience in leading team and possess excellent communication and interpersonal skills, ability to quickly grasp new concepts, both technical and business related and utilize as needed.
• Designed and develop VB.net application that utilized MicroStrategy SDK to automated e-mail and multiple MicroStrategy attachments.
• Strong skills in Requirement gathering and study, Gap Analysis, Scope Definition, Recommendations to Business Process Improvements, Development of Procedures, Forms & Documentation, Effort Estimation, Resource Planning, Project Tracking, UAT.

Environment: MicroStrategy 9.0.2,Architect, MicroStrategy SDK, Web Intelligence, Object Manager, Cognos 8.4.1,Framework Manager, Query Studio, Report Studio, Informatica 8.6.1, Teradata 12, DB2 8.x/9.1, Oracle 10GR2,SAP, SQL, PL/SQL, Windows NT and UNIX.

Confidential, Baltimore, MD

MicroStrategy Consultant

Responsibilities:

• Co-ordinated meetings with clients and business users to discuss and understand requirements.
• Discussion with data modelers to understand data modeling of existing schema.
• Worked with client to gather requirements and prepared technical specifications documents.
• Responsible for the preparation and presentation of proto-type reports to end users and get acceptance to develop reports.
• JAD (Joint Application and Design) sessions and GAP analysis sessions to understand existing reports and convert Cognos reports into MicroStrategy by creating corresponding Attributes, Metrics, Filters and Prompts.
• Migration of Cognos reports into MicroStrategy Reports.
• Designing of schema objects like Attributes, Facts, Hierarchies and Transformations from data warehouse.
• Expertise in using Apply simple Function in Attributes and Metrics to make manipulations to values.
• Responsible in developing of public objects (Filters, Prompts, Metrics, Consolidations, Custom Groups, Templates and Reports) on top of Schema Objects.
• Responsible for the creation of metrics like Compound metric, Derived Metric, Filter Metric and Transformation metric to generate more complex MicroStrategy reports in an efficient way.
• Creation of logical views and Freeform SQL Reports to translate Freeform SQL Cognos Reports into MicroStrategy Reports.
• Used Heat Map widget to quickly grasp the state and impact of a large number of variables at one time.
• Expertise in developing MicroStrategy reports by combining multiple Cognos reports based on functionality and usability of reports.
• Used Apply Simple and Apply Comparison functions to develop Advanced Filters and Transformations.
• Involved in creation of reports at Aggregate Level as well as Detail Level Tables to retrieve data in an efficient way.
• Setting of VLDB Properties to improve performance of reports as well as passing hints to the SQL queries.
• Creating Dense Rank function metric at report level to generate sequence numbers for PDE Transactions.
• Expertise in developing dashboard reports in MicroStrategy by combining multiple reports in Cognos by using selectors.
• Development of reports on Sap Cubes.
• Moving the objects between two projects and two different environments by using Object Manager and resolve conflicts between environments by using conflicts resolution window.
• Involved in creation of Users/User Groups and assigning appropriate privileges through User Manager in Administration.
• Preparing Test Plans, Test Conditions for developed reports and uploaded test conditions into the Quality Center and Pass those conditions into the Test Lab.

Environment: MicroStrategy 9.0.2, Architect, Web Intelligence, Object Manager, Cognos 8.4.1,Framework Manager, Query Studio, Report Studio, Informatica 8.6.1, Teradata 12, DB2 8.x/9.1, Oracle 10GR2,SAP, SQL, PL/SQL, Windows NT and UNIX.

Confidential, Palo Alto, CA

SAS Developer

Responsibilities:

• Reviewed and rebuild of automotive model ETL code.
• Reengineered several programs in order to efficiently score in existing environment, and to provide the code base to migrate into modeling services
• Worked with Confidential Scheduler application to schedule jobs and run post processes with the partitions.
• Quickly appended Syndicated models to Client files.
• Built routines to manage and update the field’s meta-data.
• Made the 3rd party syndicated data organized and available for analytical use.
• Re-designed database and participated in importation processes.
• Used shell scripting to schedule SAS jobs on UNIX environment.
• Used advanced macros to automate the SAS code.
• Used R SUBMIT feature to run jobs on a remote machine.
• Took part in creating Data Models for different level of test validation based on the reports.
• UsingSAS for extract, transfer and load ("ETL") methodology and processes
• Interacting with Project Managers to understand reporting requirements and translate into SAS code.
• Creating and maintaining database tables, web pages, also format, edit, manipulate and merge large-scale datasets.

Environment: BASE SAS, SAS/ MACRO, SAS/ SQL, SAS/ STAT, SAS/CONNECT, SAS/Access, SAS/Graph, UNIX Shell, MS Excel, Windows7.

Confidential

Database Developer and Admin

Responsibilities:

• Carried out detailed study of business, data analysis and configured the material management module to user specification.
• Developed and maintained logical schema, physical records and SQL queries for ORACLE application.
• Tuned Oracle for performance improvement and resolved network configuration and connectivity related problems.
• Created triggers and stored procedures based on the functionality.
• Located and corrected problems involving file operations, process management, I/O operations and memory management for pre-compilers and SQL*net modules.
• Involved in developing ER diagrams.
• Designed and implemented utilities which automated several DBA functions.
• Developed the user interface and menus using triggers, functions and procedures.
• Constructed several normalized database tables with different constraints to maintain integrity.
• Established customer support tracking database.
• Represented the team in documenting and maintaining the changing requirements, design review feedbacks and work discussions with the client.
• Generated Reports and Charts using BO.

Environment: PL/SQL, Developer 2000, Oracle 9i, Windows XP, Business Objects Enterprise 6.