SUMMARY

• Over 10+ Years of extensive work experience in the field of Information Technology implementing Data warehousing, Decision Support Systems.
• Has managed and executed all phases of a Data warehouse project life cycle during the tenure that includes Scoping Study, Requirements Gathering, Architecting, Design, Development, Implementation, Quality Assurance, Application Support for end - to-end IT solution offerings in Datawarehousing,OLAP & BI space.
• Extensively worked in developing DW applications using MicroStrategy Desktop, Web, Administrator, Narrowcast Server, and Intelligence Server. Also have a good familiarity with MicroStrategy SDK.
• Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Custom Groups and consolidations) with the data warehouse.
• Designing Data Marts using different multidimensional modeling techniques such as Star Schema and Snowflake Schema, Fact and Dimensional tables, Logical and Physical data modeling.
• Very good experience in interacting with the clients and understanding business application, business data flow and data relations from them.
• Created complex Reports in MicroStrategy including freeform SQL reports, data mart reports, etc.
• Experience in creation of Dashboards and scorecards which helps in better understanding of the Business trends.
• Experience in Data Modeling using ERWIN3.x/4.0, Data mart and OLAP for business analysis using star & snowflake schemas, for faster and effective querying.
• Experience with integratingMicroStrategywith heterogeneous data sources and the implementation of dynamic-sourcing.
• Handled Slowly Changing dimensions in a Data warehouse depending on the changes in business dimensions.
• Decent Database development skills using SQL, PL/SQL, stored procedures, stored functions, packages and triggers
• Very good experience in working with very large databases on Oracle, Teradata, SQL Server, DB2 with Micro strategy Suite. Strong SQL skills in a Netezza and SQL server Environment.
• Experience in developing and deploying microstrategy mobile apps on Apple IOS/iPad and/or similar other devices.
• Expertise in test planning and testing methodology for Quality Assurance validation of MicroStrategy configuration, reports and other output.
• Exceptional analytical and problem solving skills.Self motivated team player with the ability to communicate effectively at all levels of the development process.

TECHNICAL SKILLS

Business Intelligence/OLAP: MicroStrategy 9.2.1/9.0.2/8.1.2/8.1.1/8.0.2/ (MicroStrategy Desktop, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, Business Objects, Microsoft Excel

Database: Teradata/SQL Server-2000/2005,ORACLE 10g/9i/8i, Netezza, MS-Access

Tools: Crystal Report, Microsoft-Office, Microsoft Visio, N Unit, I Rise

ETL Tools: Informatica8.1/7.1/6.2,Ab Initio

Data Modeling: ERWIN Platinum4.1.4, Enterprise Architecture, Microsoft VISIO

Programming Languages: C, C++, Java, JavaScript, Jsp, Ajax, Visual Basic6.0, PL/SQL

Operating Systems: Windows 95/98/NT/XP/Vista, Windows 2005 Server, UNIX

Others: HTML4.0,DHTML,XML,LDAP,VBScript,JavaScript,MS Office, Macromedia Dreamweaver, Macromedia Fireworks, Macromedia Flash, Microsoft FrontPage

PROFESSIONAL EXPERIENCE

Confidential, MI

Microstrategy Developer/Architect

Responsibilities:

• Interacted with the Business Analysts and Enterprise users.
• Involved in architecting the schema objects Attributes, Facts, Hierarchies.
• Involved in the 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.
• 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.
• Involved in development interactive dashboards and scorecards for high level management.
• 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.
• Optimized query performance by updating VLDB properties at project level and report level.
• 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.2.1, Architect,Web Intelligence, Object Manager, Integrity manager, Configuration Wizard, Informatica 9, Report Studio 8,Netezza 5.0, Windows NT and UNIX.

Confidential, Omaha, NE

MicroStrategy Developer/Architect

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--Utilised standard templates and added panels.
• 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 Adhoc Analysis.
• Created transformations using Transformations by tables for YTD (Year to date), and MTD (Month to date) 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.
• Experience in Informatica mapping specification documentation, tuning mappings to increase performance, proficient in using Informatica Server Manager to create and schedule workflows and expertise in Autosys and ESP scheduling.
• 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: MicroStrategy9.2.1, MicroStrategy Intelligence Server and web (AIX), Informatica8.1/7.1/6.2, Teradata, Oracle.

Confidential, Des Moines, Iowa

MicroStrategy Developer/Architect

Responsibilities:

• Worked with business requirements analyst’s subject matter experts to identify and understand requirements and produce the report design specification and estimates the project.
• Created the Detail design documents and Technical Specification Documents based on Business requirement documents.
• Participate in daily status and monthly planning meetings
• As per business requirement, Designed developed and maintained MicroStrategy based reports.
• Design and development of MicroStrategy schema objects like Attributes, Facts and Hierarchies using MicroStrategy Architect.
• Created complex metrics with different level dimensionality condition and transformations for user and business specific reporting needs.
• Closely worked with ETL team for maintaining the quality of the data and reconcile Fact and lookup tables for finding the Gap analysis.
• Extensively used filters, prompts, custom groups, consolidations and transformations to generate reports for business analysis.
• Respond to business users inquires directly to provide technical support and best-practice report consulting.
• Perform code review and unit, system, regression testing.
• Involved in Performance tuning of SQL for long running reports.
• Created Dashboard for Corporate Financial Forecasting.
• Unit/System Testing & validation of reports using Complex SQL,PL/SQL scripts.
• Deployment automation of report objects from Serena Dimensions using shell scripts.
• Used report services for various banded report to satisfy the printing requirements of the user.
• Provide production support ofMicroStrategy reporting application.
• Create users in MicroStrategy and grant required access for projects.
• Coordinated in moving the objects from Development to Production Environment in MicroStrategy by using Object Manager.
• Configuration of Narrowcast server and Involved in various Narrowcast task like creating Documents, service designs, subscription, administration and scheduling.
• Prepared technical project related documentation.

Environment: MicroStrategy Desktop, MicroStrategy Intelligence Server8.1.0, MicroStrategy Web8.1.0, MicroStrategy Narrowcast Server8.1.0. MicroStrategy OLAP Provider, Oracle 10g and UNIX

Confidential, Dallas, TX

MicroStrategy consultant

Responsibilities:

• Effectively Tuned MicroStrategy implementation for greater performance based on recommendations from internal testing.
• Communicate business user requirements and provide clarifications as needed.
• Speed up project loading process by increasing/extending the size of element and object caches.
• 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.
• For complex reporting needs, worked extensively on creating Metrics and Compound Metrics, Custom Groups and Consolidations.
• Developed Documents to show prompted Grid and Graph modes of reports for users working with MicroStrategy Desktop interface.
• 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.
• Managing schema objects and application objects across the project by using Object Manager.
• 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.
• Best practices using standardized methodology for coding, development, test and implementation processes.
• Create and manage MicroStrategy application objects, schema objects and configuration objects.
• Define/Create system hierarchy/user-defined hierarchy and controlling (lock, limit and filter out) the attribute elements in hierarchy.
• Involved in the creation of Data mart Reports, Partition Mappings and Aggregate tables to improve performance of Enterprise Reports.
• 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 Desktop8.0.0, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Narrowcast Server, SQL Server 2005 and Windows Server 2000.

Confidential, MI

MicroStrategy consultant

Responsibilities:

• Designed and Developed Customized Attributes, Hierarchies, Facts, Metrics, Filters, Prompts, Custom Groups, Consolidations and Reports.
• Extensively used Pass-through (Apply Functions) expressions to pass special functions.
• Create connection maps to map users to different homogeneous databases or table spaces in a single project to direct end users against production and power users against development database.
• Designed, Developed and altered html document objects by placing multiple reports on it in Grid as well as Graph View applying XSL formatting for each in the process of automating IT Dashboard reports.
• Project duplication within and in between different project sources of Prod, Dev and UAT environments.
• Installed and configured complete MicroStrategy product suite on Prod, Dev and RE&I Lab environments.
• Personalize the end user experience at report runtime by providing flexibility with reusable prompts/report parameters
• Validate, Detect and Repair logical/physical inconsistencies and corruptions of MicroStrategy metadata by running Scan MD/MD Doctor utilities.
• Actively involved in the Implementation of Novell LDAP authentication for MicroStrategy Products.
• Extensively used Object Manager, Project Merge and User Merge utilities to manage MicroStrategy Tier 1/ High Impact applications and objects.
• Responsible for creating the MicroStrategy DB instances, DB connections, DB logins and ODBC DSNs.
• Actively involved in the full life cycle of Migration process from MicroStrategyv7.2.3 to MicroStrategyV7.5.1
• Actively participated in the proof of concept for the MicroSrategyv8.01 upgrade.

Environment: MicroStrategy tool suit 7.2.3/7.5.1/8.0 , MicroStrategy Office 7.5.1, DB2 UDB V7.1/V8.1 for Unix/Windows, Teradata, Windows 2000/2003, Sun Solaris V9/V10, Altiris Client Management Suite V6.0.

Confidential, Sunnyvale, CA

MicroStrategy Consultant

Responsibilities:

• Interacting with business users for requirement definition analyzing the business requirements and translating them in to functional and technical specifications
• Worked with data architect to design and build MicroStrategy schema.
• Performed Design & Code reviews Unit testing and data validation of MicroStrategy reports.
• Provided the users the facility to create customized reports for Business Analysis by creating Hierarchical filter prompts Attribute filter prompts Attribute.
• Used the Object Manager to move the objects from Development to Production Environment in MicroStrategy.
• Extensively worked on Report Services to create performance dashboard reporting.
• Metric prompts templates and drill downs. The end users were able to generate ad-hoc reports by drilling up down within and across dimension or anywhere.
• Customized the MicroStrategy web interface and the Intelligence Server settings for the project.
• Customized reports, Documents and deployed them to MicroStrategy web.
• Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.
• Configured the Enterprise Manager for statistical reporting purposes.
• Design and creation of reports transformation and derived metrics filter objects prompts drill maps user hierarchies dynamic custom groups consolidations Worked with DBA's to tune SQL generated by MicroStrategy reports and to collect DB statistics and in creation of additional indexes if necessary Designed dynamic dashboards for easy data magnification.
• Performed administrative activities like invalidating the report cache loading and unloading the projects merging & deleting projects and creating security roles.
• Involved extensively in troubleshooting support and resolving all outstanding issues.
• Assisting project team with determining the appropriate technical platform (hardware and software) for new applications

Environment: MicroStrategy7.5 / 8.0x (Administrator, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), Oracle 9i, SQL Server2000/2005, Desk MS VISIO MS Office 2003

Confidential

Oracle Developer

Responsibilities:

• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Implemented a Database design using Designer/2000 in an Oracle 7.3 environment.
• Designed the database based on requirements of the system.
• Designed the User interface for forms with developer 2000 features.
• Generated necessary reports periodically using Reports.
• Created the database, table spaces, tables, indexes and other database objects.
• Loaded the data into the Oracle database using SQL Loader
• Responsible for performing various database administration duties using advanced querying tools and PL/SQL scripting techniques, Procedures.
• Responsible for troubleshooting various aspects of the client/server architecture in both a UNIX and an Oracle setting.

Environment: Oracle7.3, PL/SQL, SQL, Developer 2000 Forms 4.5, Reports3.0, UNIX and Windows 95