Professional Summary

• 6 plus years in Data warehousing, Business Intelligence systems, OLAP environments and tools.
• In-depth knowledge of fundamental data warehousing concepts such as entity relational modelling, dimensional modelling, star and snowflake schemas, modelling data marts, front and back room architectures, security and deployment.
• Well versed with the MicroStrategy product suite namely MicroStrategy Desktop, MicroStrategy Intelligence server, MicroStrategy Architect, MicroStrategy Administrator, MicroStrategy Web, MicroStrategy Report Services, MicroStrategy Dashboards and MicroStrategy Narrowcast Server.
• Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse.
• Handling slowly changing dimensions in a data warehouse depending on the user needs.
• Extensive experience in creation of Dashboards and scorecards which helps in better understanding of the Business trends.
• Working closely with the business to gather, review, validate and document the business requirements.
• Team lead experience with Documentation and developing Dashboard reports.
• A self motivated team player with exceptional communication skills.

OLAP/ Business Intelligence
/Reporting Tools:

MicroStrategy Desktop 9.2.1, 9.0.x, 8.x, 7.5; MicroStrategy Architect; MicroStrategy Web; MicroStrategy Intelligence Server; MicroStrategy Narrowcast Server; MicroStrategy OLAP Services; MicroStrategy Object Manager; MicroStrategy Mobile.

ETL Tools:

Informatica and Data Transformation Services (DTS)

Databases:

Oracle 11/10g/9i/8i/8.0/7.0, MS SQL Server, MS Access.

Programming Languages:

C/C++, Java, Objective C, PL/SQL

Others:

MS Office Suite, MS Project

Operating Systems:

Windows, Unix/LINUX

Client: Confidential, Sept 2011 – May 2012
Location: Seneca Falls, NY
Role: MicroStrategy Developer

Confidential,is a leading global water technology provider, enabling customers to transport, treat, test and efficiently use water in multiple industries.

Responsibilities:

• Involved in gathering and documenting business requirements from end clients and translating them into report specifications for the MicroStrategy platform.
• Worked closely with data modelling 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 9.2.1 to build schema objects Hierarchies, Transformations, Attributes, Facts and Relationships as a function of the logical model.
• Extensively used filters, prompts, consolidations and custom groups to generate canned reports and ad hoc reports.
• Created Transformations for using in comparative reports like revenue this year to last year.
• Generated Key Performance Indicators (KPI) metrics and other metrics
• Used Project documentation feature: Documented all MicroStrategy objects like reports, prompts, filters and metrics for user reference. Developed reports for MicroStrategy Web users.
• Created Intelligent Cubes to solve the performance issues.
• Extensively used “Apply Simple” function for creating attributes.
• Designed developed and maintained reports, involved in data validation, analysis, testing and debugging
• Introduced the Dashboard to business users and they liked the idea and requested to continue developing the dashboards with the existing reports.
• Developed several dashboards to be delivered to an ipad for the business user.

Environment: Micro Strategy 9.2.1, Narrowcast Server, Intelligence Server, Web, Administration, MS SQL Server, T-SQL, Teradata V2R3, Unix, Windows NT

Client: Confidential, Dec 2010 – Sept 2011
Location: Atlanta, GA
Role: MicroStrategy Developer

Confidential,created in 1997 and headquartered in Atlanta, GA, is the Internet’s leading auto classifieds marketplace and consumer information Web site. AutoTrader.com aggregates in a single location more than three million vehicle listings from 40,000 dealers and 250,000 private owners, which provide the largest selection of vehicles attracting more than 13 million qualified buyers each month.

Responsibilities:

• Served as Primary Micro Strategy developer for the full lifecycle of the data warehousing project from requirement gathering from business analysts to rollout.
• Designed and developed Dashboards using MicroStrategy Report Service Documents for various products and services in Insurance Service Group.
• As per business requirement, Designed developed and maintained MicroStrategy based reports.
• Created Enterprise Manager Reports for various analyses.
• Administration of ASKIG project including maintenance and User Management.
• Configuration of Narrowcast server and Involved in various Narrowcast tasks like creating Documents, service designs, subscription, administration and scheduling.
• Created Attributes, Metrics, security filters and other report objects, drilling, defined hierarchies using Micro Strategy Desktop.
• Manipulated attribute and attribute forms properties to enforce right table joins.
• Used MicroStrategy functions such as ApplySimple, ApplyComparision in the metric calculations and used in different reports.
• Involved in Migration process of ASKISG project from Insurance Service Group environment to Centre of Excellence, Bank of America.
• Closely worked with ETL team for maintaining the quality of the data and reconcile Fact and lookup tables for finding the Gap analysis.
• Upgraded the MicroStrategy 8.0.1 version on Windows to the 9.0.1 Version on UNIX.

Environment: MicroStrategy 9.0.1/8.x (Desktop, Architect, Report Services Document, Web, Narrowcast Server), DTS, SQL Server 2000, Teradata, Windows.

Client: Confidential, Aug 2009 – Nov 2010
Location: Chevy Chase, MD
Role: MicroStrategy Architect

Confidential, operational data from the front end source systems are loaded into the Central Repository (CR) and then realigned in the EDW Data Marts to facilitate reporting. The EDW is all about making important GEICO information accessible to our business users so they can evaluate our insurance results and make better-informed decisions.

Responsibilities:

• Effectively Tuned MicroStrategy implementation for greater performance based on recommendations from internal testing.
• Provide mentorship to the peers in the areas of performance and tuning and best practices for all projects across all environments.
• Experienced administrative capabilities; Project Setup (Installing, configuring, managing and controlling) and Project Lifecycle Management.
• Perform periodic Health Checks of the Intelligence Server and Narrowcast server installation in all environments to determine the current state of server parameters, performance, as well as identify potential issues and limitations.
• Run Integrity Manager to Compare/Analyze discrepancies at the Data, SQL and Graph levels before Project migrations and software upgrades.
• Migration planning and implementation with all supported service packs, hot fixes, and patches.
• Configure, Manage clustering of Multiple Intelligence server nodes and web server nodes to implement automatic failover, load balancing and boost the performance and scalability.
• Best practices using standardized methodology for coding, development, test and implementation processes.
• Create and manage MicroStrategy application objects, schema objects and configuration objects.
• Embed hand-crafted SQL statements directly into the MicroStrategy BI platform using The Freeform SQL editor.
• Define/Create system hierarchy/user-defined hierarchy and controlling (lock, limit and filter out) the attribute elements in hierarchy.
• Defined advanced prompt expressions to create Hierarchy prompt, prompt-in-prompt and nested prompts
• Provide optimum performance and scalability through Multi-pass SQL, Aggregate tables and VLDB settings.
• Automate all repetitive tasks, and allow them to be initiated on time-based or event-based triggers.

Environment: MicroStrategy Suit 9.0.1, IBM DB2/AIX64 9.1.3, Service Centre 5.1, Windows 2000/2003.

Client: Confidential,LLC September 2008 – June 2009
Location: Green Bay, WI
Role: Microstrategy Architect/Developer

Confidential,LLC is an affiliate of Sun Capital Partners, Inc., a leading private investment firm focused on leveraging buyouts, equity, debt, and other investments in marketleading companies that can benefit from its in-house operating professionals and experience

Responsibilities:

• Meeting with business users for requirements gathering
• Worked with the Data Modelers for creating the Dimensional Model based on the requirements
• Involved in Analysis, design and Construction of the Metadata
• Architected the projects and created Schema Objects like Attributes, Facts, Hierarchies, Transformations and Public Objects like Metrics, Filters, Prompts, Consolidations, Custom Groups, Drill maps and Templates.
• Managing Schema Objects and application objects across the project by using Object Manager.
• Created reports and dashboards for users to slice the Data across various Hierarchies.
• Involved in the creation of Intelligent Cubes and Aggregate Tables to improve performance of Enterprise Reports.
• Expertise in customize SQL query by setting VLDB properties at different levels Database Instance, Report and Metric.
• Created Administration Tasks like creating User Accounts, Assigning Privileges and applied Security Filters.
• Involved in migration of Business Objects Documents to Microstrategy Documents.
• Created services using Subscription sets, Schedules, Information Objects.
• Involved in setting Result Caches, Object Caches at Intelligence Server to improve performance of the report.
• Involved in Microstrategy Intelligence Server performance monitoring and managing cache expiry times.
• Used Enterprise manager to create reports on the project usage and report usages.

Environment: Microstrategy Desktop 8.1, Microstrategy Architect 8.1, Microstrategy Intelligence Server 8.1, Microstrategy Web 8.1, SQL, SQL *Loader, Oracle 10g, Windows 2003, UNIX

Client: Confidential, November 2006 –August 2008
Location: India
Role: Microstrategy Developer / Tester

Confidential,is an IT Service firm offering IT solutions to different organizations in banking, retail, Credit services and Telecommunications & media.

Responsibilities:.

• Created Microstrategy objects like Reports, Ad-hock reports, Documents, Prompts, Filters, Metrics, Facts, Consolidations, Custom Groups, Attributes Transformations and Hierarchies.
• Created Schema Objects like Attributes, Facts and Hierarchies that map to the physical warehouse.
• Created several base formulas (mathematical expressions) using existing facts in Microstrategy Agent 7.x that can be re-used to build any number of Metrics.
• Customized Reports, Documents and Deployed them to Microstrategy Web.
• Created customized interfaces using ASP and Web API’s.
• Extensively used Bugzilla to report and resolve the bugs encountered in the QA process.

Environment: MicroStrategy 7/7.5, Oracle 9i, Oracle IAS, Windows NT/Windows 2000.

Client: Confidential, Jan 2006 – Oct 2006
Location: India
Role: MicroStrategy Consultant

It is India\'s largest private sector enterprise in power utility and it\'s a company under the Reliance Anil Dhirubhai Ambani Group banner, one of India\'s largest conglomerates. The company is headed by Anil Ambani.

Role:

• Created reports using MicroStrategy 7.x, created users, roles and privileges on Monitored and tuned SQL scripts. Creating upgrade scripts for production Database and supporting it.
• Extensive interaction with the Database experts to understand the Source System and efficient translation of technical data to Business terms through self developed design templates.
• Gathered the Reporting requirements from business user and created BRD (Business Requirement documents) for SDLC process.
• Created and established KPI’s based on BRD and logical data model.
• Created and implemented MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom groups in reports and documents using MicroStrategy Desktop.
• Used Advanced Prompts, Conditional, Transformation metrics and Level Metrics for creating complex reports.
• Created user groups, roles, privileges using MicroStrategy Command Manager.
• Involved in creating users in MicroStrategy Desktop for testing the reports on Web.
• Implemented drill functionality on the reports using Drill Maps

Environment: MicroStrategy 7.x, SQL Server 6.x, Visual Basic 5.0/6.0, Developer 2000, oracle databases.

Bachelor of Science in Engineering