SUMMARY:

• Ten years of IT experience in gathering requirements, documentation, developing, designing, testing, implementing, and deploying BI Solutions.
• Over 7 years of extensive experience utilizing the MicroStrategy Suite MicroStrategy Desktop, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, MicroStrategy Architect, MicroStrategy Administration, MicroStrategy Web, MicroStrategy OLAP services and MicroStrategy Distributed Services .
• Having experience with all reporting phases such as MicroStrategy Installation on Unix and Windows platform , creating project source and configurations, user group security setup, schema design and public object development including reports and dashboards, Intelligent Cubes, data Mart and SDK setup.
• Extensively worked as MicroStrategy Developer, Architect, Administrator and Production support specialist.
• Designing Data Marts and Data Warehouse using different multi-dimensional modeling techniques such as Star Schema and Snowflake Schema, Fact and Dimensional tables, Logical and Physical data modeling.
• Experience in working with data modelers to translate business rules/requirements into conceptual/logical dimensional models and worked with complex de-normalized and normalized data models.
• Well versed requirement gathering, preparing all delivery documents like BRD, SRS, TSD etc.
• Three years of onsite and external customer-facing experience.
• Experience with onsite-offshore model as a team lead role in development and maintenance projects using SDLC and Agile methodologies.
• Extensively worked on Enterprise manager and Integrity Manger, Object Manager, Report Governance Setting.
• Extensively worked with MicroStrategy User/Group/Security filters creation and mapping.
• Extensively worked on complex reports and dashboards design and optimization query optimization as well as other strategies such as VLDB and Intelligence server optimization .
• Developed some DTS packages with SQL Server 2000 with Query optimization for Visa Inc.
• Working experience with UNIX environment to check Intelligence Server specific different logs/processes and restarting the Intelligence servers to debug and rectify the production issues.
• Having extensive working experience with Incident and change management and production initiatives.
• Experienced with Object manager to migrate MicroStrategy objects from Development to QA to Production environment.
• Given multiple MicroStrategy training across organization and at team level to prepare development team.

Domain Knowledge: Having 6 years of experience in electronics payment domain and 3 years' experience with Retail domain.

TECHNICAL SKILLS:

BI Tools : MicroStrategy 8.x, 9.x, Business Object XI R2/R3, Crystal

Report.

Core Skills : Business Intelligence/ Data warehouse Implementation

Core Tools :

• MicroStrategy 8.X, 9.X MicroStrategy installation and
• Configuration, MicroStrategy Desktop, MicroStrategy Web,
• Report Services, Integrity Manager, MicroStrategy Intelligence
• Server, MicroStrategy Narrowcast Server, Object manager,
• Integrity Manager, Enterprise Manager, MicroStrategy
• Administration, User Management, Group management,
• Security management, reporting governor setting etc.

ETL Tools : DTS, Informatica 8.6.1/8.1, Data Stage 7.5.2

Databases : SQL Server 2000, 2005 , DB2, Netezza Server, Teradata

Web Technologies : ASP. Net 1.1, 2.0 , HTML, Xml, CSS, Web Services, XSLT,

C .Net, VB.Net.

Web Server : IHS IBM HTTP Server

Application Server : Web sphere Application Server, Web Logic.

Business analysis tool : Visio2003, Visio2007.

Operating Systems : Windows 2000/XP/2003 server , UNIX.

PROFESSIONAL EXPERIENCE:

Confidential

Role: Developer/Architect

Responsibilities:

• Detailed study of the Requirement documents Agile methodology so user stories .
• Preparing Technical Specification documents.
• Reviewing TSDs and raising Comments what can be done with MicroStrategy or what cannot be done in MicroStrategy, or suggesting best way to do that in MicroStrategy.
• Designed the schema object and public object and Development of Reports and dashboards. We implemented new dashboard and new features available with MicroStrategy 9.3.1.
• I worked on different kind of widgets like Heat map, Bubble, Gauge, Time Series etc and dashboard performance management.
• Used SDK for few existing plugin change/update, got from MicroStrategy direct vendor.
• Doing unit testing for reports
• Given UAT support for these reports after successful migration.
• We are also responsible to provide 90 days warranty period support after QA to Prod Migration.
• Created many Narrowcast based daily/weekly/monthly services for the users.
• Setting up or changing EM Load setting for new or existing projects.
• Monitoring EM loads and purging as per schedule or manually.
• Used SDK for few existing plugin change/update, got from MicroStrategy direct vendor.
• Performing multiple admin roles like creating user groups, new users, giving folder permissions. Creating users at Narrowcast end and assigning different roles. Changing device setting for distribution services. Creating many distribution services/schedule and subscription in different format and delivery type like Shared folder delivery mail delivery etc.
• Object migration between different environments by using Object Manager.
• Pre and post Validation after any production changes, by using Integrity Manager.
• Created multiple Enterprise manager reports for debugging purpose and to check system utilization and performance parameters of production reports. And modified setting and capacity to make application more scalable.
• Changing different governance limit after trend analysis through different Enterprise Managers reports or as per business request for production reports.
• Working on existing reports and Dashboards for optimization query optimization as well as other strategies like VLDB setting change and Intelligence server setting.
• Taking care of Intelligence server stop and restart to resolve some issue with development or on the event of weekend migrations.
• Checking Intelligence server's specific logs in Linux environment to debug the issues or to validate the Intelligence server's health after any JVM level change or MicroStrategy change.
• Frequently using Integrity Manager for pre and post validations and base lining.
• Working on existing reports and Dashboards for optimization query optimization as well as other strategies.

Environment: MicroStrategy 9.3.1, SDK, Db2, WebSphere, IHS, UNIX.

Confidential

Role: Developer/Architect

Responsibilities:

• Co-ordinate meetings with clients and business users to discuss and understand requirements.
• Discussion with data modelers to understand data modeling of existing schema.
• Worked with client to gather requirements and prepared technical specifications documents.
• Responsible for the preparation and presentation of proto-type reports to end users and get acceptance to develop reports.
• Designed the schema object and public object and created Complex reports and dashboards with the drill down methodology in all options.
• Developed MicroStrategy Dynamic Dashboards in the Flash Mode using several controls and widgets like Heat Map, time series slider, radio boxes, Gauges, Bubble Graph etc.
• Doing unit testing and UAT support for reports and Dashboards deployment.
• Created many Narrowcast based daily/weekly/monthly services for the users.
• Creating many distribution services/schedule and subscription in different format and delivery type like Shared folder delivery mail delivery etc.
• Migrating the objects between two projects and two different environments by using Object Manager and resolve conflicts between environments by using conflicts resolution window.
• Pre and post Validation after any production changes, by using Integrity Manager.
• Created multiple Enterprise manager reports for debugging purpose and to check system utilization and performance parameters of production reports. And modified setting and capacity to make application more scalable.
• Changing different governance limit after trend analysis through different Enterprise Managers reports or as per business request for production reports.
• Working on existing reports and Dashboards for optimization query optimization as well as other strategies like VLDB setting change and Intelligence server setting.
• Frequently using Integrity Manager for pre and post validations and base lining.
• Working on existing reports and Dashboards for optimization query optimization as well as other strategies.

Environment: MicroStrategy 9.2.1, Db2

Confidential

Role: MicroStrategy Production Support.

Responsibilities:

• Worked as main point of contact for DC Production support. Where my responsibilities ware to resolve incident as per SLA Service Level Agreement , it can be report related work around, Performance improvement, Governance Setting, user/group management, Creating ad hoc reports, Situation report, Intelligent Cube, Data Mart, NC Service management and creating different narrowcast services for different KPIs and alerts. User's ad hoc query resolution. Creating many free form SQL reports for different type of reporting data analysis.
• We have full ownership of DC Production support so responsible to give approval for CRQs/weekends maintenance after proper impact analysis.
• Taking care of Intelligence server stop and restart to resolve some issue with production or on the event of weekend migrations.
• Checking Intelligence server's specific logs in Linux environment to debug the issues or to validate the Intelligence server's health after any JVM level change or MicroStrategy change.
• Planning and implementing change management best practices across applications.
• Worked on WebSphere initiations to improve the performance of the Java based applications/UIs.
• Supporting multiple Web server IHS and App server WebSphere Application Server -with all responsibilities like validating different kind of logs, leading improvement initiatives, checking server health and parameters, providing go ahead for all web/app servers related RFCs, related with patch installation, remediation activities and other regular maintenance activities.
• Creating RFC and coordinating with Server team to get executed all web/app server related initiatives and validating after change and report improvements with higher management and other stake holders.
• Monitoring and changing the Web/App/Intelligence server related alert/warning before raising major severity incident and rectify the issue before it impact production environment.
• Handling all phases of RFC execution as initial engagement knowledge transfer , Creating Artifact PET/CDT , uploading all change related document, Storing all test result before giving any final approval.
• Taking care of Intelligence server stop and restart to resolve some issue with production.
• Checking Intelligence server specific logs on UNIX environment to debug the issues and to validate the I server's health, restarting the I server and taking back up of logs etc.
• Checking app server and web server specific logs on UNIX environment to debug the issues and to validate the server's health. Coordinate with server team for any JVM restart etc with instruction to resolve any issues with the server.
• Resolving the real time issues over bridge calls by engaging different teams.
• Sending global user notification to impacted users.
• Created many Enterprise manager report and prepare presentation for management to check health of Intelligence servers and suggest the points to improvement on MSTR platform like improving DB queuing, improve average report execution time, improve complex queries execution time, Tracking current governance setting and recommended setting. Traced top 5 reporting issue and error and resolved the error scenarios.

Environment: MicroStrategy 9.0.2, Teradata

Confidential

Role: Designer/Architect

Responsibilities:

• Detailed study of the Requirement document.
• Preparing Technical Specification document.
• Reviewing TSDs and raising Comments what can be done with Business Object or what cannot be done, and suggested best way to do that in Business Object.
• Designed the schema object and public object and Development of Reports.
• Done unit testing for reports
• Given UAT support for these report after successful migration.

Environment: Business Object XI R2.

Confidential

Role: Developer, Architect

Responsibilities:

• Detailed Requirements Gathering and Analysis.
• Schema Design as Attribute, Hierarchies and transformations.
• Reporting Design and development.
• Ensuring on-time delivery of all the reports
• Coordinating reviews and walkthroughs of the deliverable with the RS BI head.
• Design of Grid/Graph based Reports, Documents and Dashboards.
• Design Development of Public Objects: Advanced Metrics, Prompts, Filters, Templates etc.
• Involved in the estimation and design of MicroStrategy development.
• Developing Modifying Ad hoc mock up Reports.

Environment: MicroStrategy Suite of Tools 8.1, SQL server 2005

Confidential

Role: Developer

Responsibilities:

• Detailed study of the Requirement document and preparing the Estimation Worksheet,
• Database Design.
• Preparing Design document.
• Requirements Gathering and Analysis
• Design and Development of Reports

Environment: Asp.net1.1, C .Net, Web services, SqlServer2005, Crystal Report 11.0.

Confidential

Role: Developer.

Responsibilities:

• Requirements Gathering and Analysis.
• Design the DTS Package.
• Created a package that includes complex work flows that include multiple steps using conditional logic.
• Optimizing DTS query performance.
• Tuning Sql queries for faster response time.
• Coordinating with the onsite team for reviews, feedback and issue resolutions.

Environment: SQL Server 2000, DTS Packages.

Confidential

Responsibilities:

• Detailed study of the Requirement document and preparing the Estimation Worksheet,
• Work involved to designing user interface. Creating database, procedure, invoking query, procedure. Implementation of project
• Database Design.
• Preparing Design document.
• Design and Development of Reports in Crystal report.