Manager Project

Sandeep

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 the 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 knowledge of data in the 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 the 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 the business for

senior management.

Supported the end users on reports where they needed assistance. Performed Knowledge

Transfer to the business users, documented the general design of the 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, the End user can use Microsoft excel

functionality to manipulate data use pivot tables and other analytical tasks within the workbook.

TECHNICAL SKILLS:

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

Technologies:

2.5.3

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

Business Intelligence: MicroStrategy 9.4.0/9.0.2/8.1.2/8.0.2

1

Email:- **************@*****.*** Mobile: 618-***-****

Web Servers: IIS, Apache Tomcat Webserver

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

PROFESSIONAL EXPERIENCE:

Gap Inc, San Francisco, CA May 13 – Present

MicroStrategy Contractor

Project: Venus

Followed the agile methodology in planning and implementing new requirements in MicroStrategy.

Created MicroStrategy Dynamic Dashboards to analyze the sales by brand, time and division for

GID division of Gap Inc.

Created the required MicroStrategy objects and changes to the schema objects as per the report

requirements.

Created mapping documents and unit test scripts to validate the report data before delivering the

reports to QA team.

Involved in code review and QA of MicroStrategy reports developed by other developers as a part

of the agile implementation.

Assisted business users in providing and analyzing the data between the corporate data

warehouse system with the Venus reporting system.

Provided business users with required data by writing custom queries to help in decision making.

Created complex relationship filters to build month end finance reports.

Involved in production validation and data analysis of the MicroStrategy reports.

Wrote MicroStrategy command manager scripts to purge report, element caches.

Involved in migration of objects from one environment to the other.

Improved the report performance of the reports by analyzing the SQL and making the required

changes to the 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

Blackhawk Network, Pleasanton, CA Sep11 – Apr 13

MicroStrategy Contractor

Project: Gift Card Sales Reporting

Involved in gathering business requirements, writing technical design documents, report design,

creating MicroStrategy reports and the required MicroStrategy objects

Administered MicroStrategy user creation, project maintenance and cache maintenance.

Involved in maintenance of the MicroStrategy projects by running SCANMD to clear any

inconsistency in the metadata

Wrote MicroStrategy command manager scripts to create users, user groups, security filters,

changes project status during data loads

Maintained the project across all the 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 the three environments.

Created narrowcast server services to deliver the weekly server and project usage reports from

the enterprise manager

Created narrowcast server services to deliver custom reports to the 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 the manual reports generated by business using MicroStrategy report services

document.

Involved in performing stress test on the MicroStrategy application

Trained end users to create ad hoc reports

Created custom MicroStrategy report links to be published on the 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

3 Email:-**************@*****.*** Mobile: 618-***-****

ToysRUs Inc., India May 09 – Dec 10

MicroStrategy Consultant

Project: Loan Life Cycle

Involved in the complete development life cycle of the 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 the project across all the three environments, which included duplication of project,

using object manager to move objects from one environment to another

Involved in the development of OLAP reports.

Involved in maintenance of the MicroStrategy metadata by running SCANMD to clear any

inconsistency in the 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

Bank of America, India Oct 08 – Apr 09

MicroStrategy Contractor

Project: Merchandising Operations

Involved in the application development life cycle which include reports, hardware requirements

gathering, report design, development, testing, implementation, and maintenance of reports.

Involved in the complete cycle of requirements gathering, design and development of the

MicroStrategy Datamarts and writing sql scripts to extract the data from the datamart tables.

Involved in the architecture changes of the project to meet the user and report requirements by

creating additional attributes, facts and hierarchies.

Involved in the building of MicroStrategy components such as metrics, filters, prompts, custom

groups and templates to build the reports.

Designed and developed Ad hoc reports to train the end users.

Tuned the MicroStrategy Intelligence Server by changing the server parameters to handle huge

volume of user requests, caching and history list.

Involved in user level and project level security settings of the reports for the end users and the

testing teams.

Wrote command manager scripts to automate the process to keep the project in execution idle

mode and purge the report, elements and object caches.

Installed, configured the MicroStrategy Narrowcast Server on the Development and Production

environments.

Setting up a file device in the narrowcast server to convert a report documents into PDF format

and automatically placing the PDF file in a particular directory

Installed and Configured the Enterprise Manager project to collect the statistics of the daily

activities of the users and the reports and analyze the performance of the reports.

Improved the performance of the reports by tuning the report SQL and changing the VLDB

properties of the reports.

Developed custom enterprise manager reports as per the requirements of the user.

Involved in the 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

EDUCATIONAL RPOFILE:

Bachelors In Computer Science Aug 04 June 08

5 Email:-**************@*****.*** Mobile: 618-***-****

Contact this candidate