SUMMARY

• Around five years of industrial and academic IT experience in application development, design and implementation
• Five years of experience in Data warehousing and OLAP tools including MicroStrategy 9i/8i
• Hands on experience with all teh Products of MicroStrategy Product Suite including MicroStrategy Dynamic Dashboards, Visual Insight, MicroStrategy Intelligence server, MicroStrategy Architect, MicroStrategy Administrator, MicroStrategy Web, and MicroStrategy Narrowcast Server.
• Experience working in an agile development environment.
• Profound noledge of data in teh field of retail including inventory, sales, distribution, retail ecommerce data.
• Successful at transforming business ideas and processes into complete solutions and configuring applications to fit teh company's business model.
• Successful at working in a Team as well as independently, under little or no supervision. Excellent interpersonal, communication and presentation skills.
• Proficient in creating MicroStrategy logical models and Reports by following best Business rules, practices and design methodology.
• Proficient in Microstrategy Administration tools Object Manager, Command Manager.
• Experience in creating Dashboards that can provide an insight analysis on teh business for senior management.
• Supported teh end users on reports where they needed assistance. Performed Knowledge Transfer to teh business users, documented teh general design of teh reports and trained other team members on MicroStrategy reports.
• Experience with Microstrategy Web customization with XML/XSL etc.
• Proficient in Microstrategy Administration tools Object Manager, Command Manager.
• Created reports using Microstrategy Office Excel, teh End user can use Microsoft excel functionality to manipulate data use pivot tables and other analytical tasks within teh workbook.

TECHNICAL SKILLS

Database Technologies: 2.5.3 Oracle 10g/9i/8i/7.0, MS Access, SQL Server 7.0/2000, DB2, Netezza

Languages: SQL, PL/SQL, Teradata SQL, T - SQL

Business Intelligence: MicroStrategy 9.4.0/9.0.2/8.1.2/8.0.2

Web Servers: IIS, Apache Tomcat Webserver

Operating Systems: WINDOWS 95/98/2000/2003/ NT/2008, UNIX, LINUX

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

MicroStrategy Contractor

Responsibilities:

• Followed teh agile methodology in planning and implementing new requirements in MicroStrategy.
• Created MicroStrategy Dynamic Dashboards to analyze teh sales by brand, time and division for GID division of Confidential Inc.
• Created teh required MicroStrategy objects and changes to teh schema objects as per teh report requirements.
• Created mapping documents and unit test scripts to validate teh report data before delivering teh reports to QA team.
• Involved in code review and QA of MicroStrategy reports developed by other developers as a part of teh agile implementation.
• Assisted business users in providing and analyzing teh data between teh corporate data warehouse system with teh Venus reporting system.
• Provided business users with required data by writing custom queries to halp in decision making.
• Created complex relationship filters to build month end finance reports.
• Involved in production validation and data analysis of teh MicroStrategy reports.
• Wrote MicroStrategy command manager scripts to purge report, element caches.
• Involved in migration of objects from one environment to teh other.
• Improved teh report performance of teh reports by analyzing teh SQL and making teh required changes to teh VLDB settings.

Environment: MicroStrategy 9.4.0/9.0.1 , MicroStrategy Dynamic Dashboards, Oracle 10g, Windows 2003 Server Standard Edition, IIS 6.0, Datastage 7.5

Confidential, Pleasanton, CA

MicroStrategy Contractor

Responsibilities:

• Involved in gathering business requirements, writing technical design documents, report design, creating MicroStrategy reports and teh required MicroStrategy objects
• Administered MicroStrategy user creation, project maintenance and cache maintenance.
• Involved in maintenance of teh MicroStrategy projects by running SCANMD to clear any inconsistency in teh metadata
• Wrote MicroStrategy command manager scripts to create users, user groups, security filters, changes project status during data loads
• Maintained teh project across all teh three environments, which included duplication of project, using object manager to move objects from one environment to another
• Installed and configured MicroStrategy Enterprise Manager in all teh three environments.
• Created narrowcast server services to deliver teh weekly server and project usage reports from teh enterprise manager
• Created narrowcast server services to deliver custom reports to teh end user based on user preferences using narrowcast server question objects.
• Configured narrowcast server File device to deliver MicroStrategy reports to a physical location on a Windows directory.
• Automated all teh manual reports generated by business using MicroStrategy report services document.
• Involved in performing stress test on teh MicroStrategy application
• Trained end users to create ad-hoc reports
• Created custom MicroStrategy report links to be published on teh corporate portal.
• 24/7 production support.

Environment: MicroStrategy 9.0.1/8.1.2/8.0.2 , UDB DB2 8.1, Windows 2003 Server Standard Edition, IIS 6.0, Data Stage 7.5.2

Confidential

MicroStrategy Consultant

Responsibilities:

• Involved in teh complete development life cycle of teh Branch Metrics project including report design, creating MicroStrategy objects like Metrics, Filters, prompts and reports.
• Developed report services documents i.e. Funding Report and Cycle Time Reports.
• Developed reports using MicroStrategy Freeform SQL and Query Builder
• Maintained teh project across all teh three environments, which included duplication of project, using object manager to move objects from one environment to another
• Involved in teh development of OLAP reports.
• Involved in maintenance of teh MicroStrategy metadata by running SCANMD to clear any inconsistency in teh metadata
• 24/7 Production Support.

Environment: MicroStrategy 8.0.2, Netezza 2.5.3, Microsoft SQL Server 2000, Oracle 9i, MicroStrategy SDK, XMLA, Microsoft Analysis Service 2000, Windows 2003 Server, IIS, SiteMinder 6.0

Confidential

MicroStrategy Contractor

Responsibilities:

• Involved in teh application development life cycle which include reports, hardware requirements gathering, report design, development, testing, implementation, and maintenance of reports.
• Involved in teh complete cycle of requirements gathering, design and development of teh MicroStrategy Datamarts and writing sql scripts to extract teh data from teh datamart tables.
• Involved in teh architecture changes of teh project to meet teh user and report requirements by creating additional attributes, facts and hierarchies.
• Involved in teh building of MicroStrategy components such as metrics, filters, prompts, custom groups and templates to build teh reports.
• Designed and developed Ad-hoc reports to train teh end users.
• Tuned teh MicroStrategy Intelligence Server by changing teh server parameters to handle huge volume of user requests, caching and history list.
• Involved in user level and project level security settings of teh reports for teh end users and teh testing teams.
• Wrote command manager scripts to automate teh process to keep teh project in execution idle mode and purge teh report, elements and object caches.
• Installed, configured teh MicroStrategy Narrowcast Server on teh Development and Production environments.
• Setting up a file device in teh narrowcast server to convert a report documents into PDF format and automatically placing teh PDF file in a particular directory
• Installed and Configured teh Enterprise Manager project to collect teh statistics of teh daily activities of teh users and teh reports and analyze teh performance of teh reports.
• Improved teh performance of teh reports by tuning teh report SQL and changing teh VLDB properties of teh reports.
• Developed custom enterprise manager reports as per teh requirements of teh user.
• Involved in teh maintenance and customization of MicroStrategy Web.
• 24/ 7 Production support.

Environment: MicroStrategy 7.2.3/7.5, Oracle 9i, RDW 10.2, RETL, RMS 10.0, Windows NT 2003 Server, Sun Solaris, Decision Master, TOAD 6.3, IIS