SUMMARY:

• Total 10 years of experience in MicroStrategy (6 years) based Business Intelligence Reporting projects and JEE Web Application (8 years) application design, development, maintenance, upgrade and support
• Extensively worked on Installation, Configuration, Version Upgrade, Hotfix Upgrade of MicroStrategy 9.4.1/9.3/9.2/9.0.2/8.1/8.0 tool suite (MicroStrategy IntelligenceServer, MicroStrategy Administrator, MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Narrowcast Server, MicroStrategy OLAP Services and MicroStrategy Distribution Services)
• Extensive experience in MicroStrategy Architect role functions such as Creating a Project, building and implementation of Schema Objects (Facts, Attributes, Hierarchies and Transformations) and Public Objects (Filters, Prompts, Metrics, Custom Groups, Consolidations, Searches and Templates) to develop documents and reports
• Expert in MicroStrategy Developer role functions such as developing Reports, Documents and Dashboards
• Expert in MicroStrategy Administrator functions such as designing Security Roles, Security Filters, User Groups, setting up Custom Authentication for MicroStrategy Web, determining system capacity, Clustering, analyzing system usage statistics using Enterprise Manager project, using Command Manager scripts to automate maintenance tasks
• Expert in MicroStrategy Web Customization, MicroStrategy SDK and Web API and an expert in MicroStrategy Web Portal Integration in OEM fashion
• Experience in migrating MicroStrategy Web Customization using the new plug - in architecture from 8.x to 9.x
• Experience in using Web Customization Editor for making layout changes and creating plug-in for Prompt Answers, External Security Module, Toolbar customization, Portal customization
• Expert in determining system level parameters such as Governing Settings, User Session management, Job Management, MCM parameters, Cache and History List Optimization based on warehouse data refresh, Job Prioritization settings, Performance Tuning using VLDB settings
• Experience in handling MicroStrategy Metadata integrity tools such as ScanMD and Metadata Doctor for removing logical and physical metadata inconsistencies and using Integrity Manager for version upgrade
• Experience in using data warehouses hosted in DB2 v9.7, Oracle 10g, Netezza, Teradata, SQL Server 2005 and MS Access databases
• Experience in using TOAD for DB2, Oracle 9.1, PL/SQL Developer, Teradata SQL Assistant 12.0, Netezza Performance Server, SQL Server Management Studio client tools to connect to data warehouse
• Good exposure to Stored Procedures, Stored Functions, Packages and Triggers
• Experience in developing enterprise class Web 2.0 JEE applications using Java, JSP, Servlet, Struts, Spring, Hibernate, Custom Tag Libraries, EJB, JMS, ExtJS and DOJO JavaScript frameworks, POI, Ant frameworks
• Expert in using iPlanet, WebLogic 10/9 for Application Hosting on Solaris servers
• Expert in using BEA Workshop for WebLogic 10, Eclipse 3.2, NetBeans 5.0, JBuilder 9 IDEs
• Experience in using source control tools such as Microsoft VSS and ClearCase
• Experience in scheduling Autosys jobs using Shell Script, SQL Script, Java Batch programs
• Good knowledge in Banking, Systems Engineering and IT Services sector
• Operational knowledge in ITIL processes to formalize the policies and procedures to run technology services division of an organization
• PCMM Level5 quality procedures and knowledge on complete Software Development Life Cycle
• Having good team, analytical, interpersonal communication and documentation skills

TECHNICAL PROFICIENCY:

BI Tools: MicroStrategy 9.4.1/9.3/9.2/9.0.2/8.1/8.0 (Admin, Architect, Developer tools and SDK) Actuate 9

Database: DB2 v9.7, Oracle 10g, Netezza Performance Server, Teradata, SQL Server 2005

DB Clients: TOAD 9.0, Netezza Performance Server 4.0.2, Teradata SQL Assist and SQL Server management studio

Languages: Java, JavaScript, SQL, PL/SQL, HTML, CSS

Web Technologies: J2EE/JEE, JSP, Servlet, Struts, Spring, Hibernate, JMS, EJB, XML, ExtJS, DOJO, AJAX

IDEs: BEA Workshop for WebLogic 10, Eclipse 3.2, NetBeans 5.0, JBuilder 9

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

JEE & MSTR SDK Consultant

Responsibilities:

• Architect conformed dimensions, shared attributes and sub-system attributes
• Design, develop and maintain User Administration program and the Performance Analytics Web application
• Architect and develop user security, enhance sub-system functionality using Java/JEE, MicroStrategy & MicroStrategy SDK
• Coordinate, mentor and provide architectural guidance to other MicroStrategy Developers in various public and schema object developments
• Application platform, architecture and infrastructure team liaison to sub-system teams
• Coordinate Web server upgrades and configuration changes
• Define deployment process guidelines, develop automation scripting for sub-system teams

Environment: MicroStrategy 9.4.1, Teradata 13.10, Eclipse Juno, Java, JEE, Microsoft Team Foundation Server for Agile Development Lifecycle

Confidential, Plano, TX

MicroStrategy Consultant

Responsibilities:

• Develop a custom JEE application platform by leveraging MicroStrategy Web report delivery capabilities
• Optimize navigation across reports/dashboards and auto-prompt answering
• Grouping of prompts and prompt page changes for better usability of MicroStrategy Web product
• Develop Session filters, Saved answers, Loading saved answers at run time to quickly switch filtering conditions
• Develop ability to bundle report and documents into Books with custom ordering, sharing and publishing/briefing/record-keeping purpose

Environment: MicroStrategy 9.3, Teradata 13.10, Eclipse Juno, Java, JEE, Rally for Agile Development Lifecycle

Confidential, Foster City, CA

MicroStrategy Consultant

Responsibilities:

• Gather the Merchant reporting requirements and Architect new Lookup and Fact tables to bring in new Attributes and Facts into the MicroStrategy project
• Design and Develop new MicroStrategy Dashboards both Homepage and Quick View Dashboards
• Design and Develop MicroStrategy Prompted Reports / Report Builders where user can build their own reports and share across other users
• Design new Security Roles and User Groups for MDEX Merchants of Confidential
• Work with CDIMI Portal team for integration and develop new Addons using MicroStrategy SDK for Dashboard export requirements

Environment: MicroStrategy 9.0.2, IBM DB2, IBM Data Studio 2.2, Eclipse, Java, JEE, WebSphere, IBM Rational ClearCase

Confidential, Foster City, CA

MicroStrategy SDK Consultant

Responsibilities:

• Strategize and execute MicroStrategy server, projects and web upgrade from v8.1.2 to v9.0.2
• Design and Develop new MicroStrategy Dashboards and Reports for international users
• Customize MicroStrategy Web for report delivery through Confidential portal which involves seamless integration of header, menu, toolbar, report page, design pages through custom plug-ins
• Use MicroStrategy SDK and Web Customization Editor for quick development and various portal integration needs
• Implement External Security Module for MicroStrategy session and security handling
• Design and Creating User Groups, Security Roles, Security Filters and Access Control List
• Create custom Add-ons, Transformations and Features
• Auto prompt answering using URL API and Add-ons based on portal user profile ps

Environment: MicroStrategy 9.0.2 / 8.1.2 , IBM DB2, IBM Data Studio 2.2, Eclipse, Java, JEE, WebSphere, IBM Rational ClearCase

Confidential, Charlotte, NC

IT Analyst

Responsibilities:

• As a MicroStrategy consultant I am responsible for creating and maintaining user, security roles, user groups, project groups and security filters using MicroStrategy Desktop and automate compliance requirements such as terminated associate access removal using MicroStrategy Web API
• Develop Facts, Attributes, Hierarchies using corresponding editors
• Develop Metrics, Compound Metrics, Filters, Custom Groups, Templates, Consolidations, Auto Prompt Filters and OLAP Reports
• MicroStrategy Listener service implementation to increase the system availability
• Maintain folder level access and setup ACL for various public folders
• Upgrade the environment to the latest hotfix. I was invovled in upgrading the whole platform (MicroStrategy Desktop, MicroStrategy Web, MicroStrategy IntelligenceServer) to MicroStrategy 9.0.0 Hotfix 4 and MicroStrategy 9.0.1
• Handling customization request such as changing MicroStrategy Web messages during data load and handling custom authentication requirements using MicroStrategy Web API
• Perform administrative functions such as Tuning, Cache, History List maintenance, setting up project level and IntelligenceServer level Governing Settings for memory, user session, job and query execution for all the 14 projects deployed in our platform
• Using Enterprise Manager project to report system statistics such as Usage Report, Long running reports, Highly used project / report, etc
• Coordinating with the project team to Tune the reports for best performance and minimum load to the system
• Periodic maintenance of Metadata using ScanMD and MD Doctor
• Coordinated with MicroStrategy Premium Support group to resolve server stability issues
• Migrating projects and objects between production and lower environments using Object Manager
• Reverse migration of objects from production environment to non production environments for user created objects using Object Manager and Project Merge Wizard
• Keeping the environment in compliance with the license using MicroStrategy License Manager
• Using TOAD for Oracle 9.1, PL/SQL Developer, Teradata SQL Assistant 12.0, Netezza Performance Server, SQL Server Management Studio client tools to connect direct to data warehouse for data analysis

Environment: MicroStrategy 9/8.1 ( MicroStrategy Desktop, Architect, IntelligenceServer, MicroStrategy Web, Command Manager, Object Manager, License Manager, Scan MD, MD Doctor, MicroStrategy SDK for customization) Oracle 10g, Netezza Performance Server 10200, Teradata, SQL Server 2005, BEA Workshop for WebLogic 10, ClearCase, Microsoft VSS

Confidential

Senior Java Developer

Responsibilities:

• Using Struts framework for the UI part of the application
• Design and Development of Custom Tag Libraries
• Designing various subcomponents such as EJBs, DAO, VO, Business layers, etc
• Developing Cascaded Style Sheets (CSS), JavaScript and using it along with custom tags for meeting the standards of Rich Internet Application (RIA).
• HTML, JavaScript and CSS coding for prototype development
• Deploy the prototype to Apache Tomcat
• Application build using Apache Ant, deploy and post delivery support

Environment: Java, JSP, Servlet, Struts, HTML, JavaScript, CSS, NetBeans 5.0, Apache Tomcat, Apache Ant, Microsoft VSS 6.0

Confidential

Senior Java Developer

Responsibilities:

• Using Java Swing framework for the UI customization
• Application architecture review and change make it more flexible for OEM requirements
• Developing Unix Shell Scripts and Batch programs for building different InstallShield packages
• Unit testing

Environment: Java, Java Swing, Unix Shell Scripting, InstallShield, JBuilder 9, JTest, Microsoft VSS