SUMMARY:

• 5 years of Total IT/Data warehousing experience in analysis, design, development and implementation including extensive experience in MicroStrategy Development tools.
• Extensive experience in creating and integrating MicroStrategy Reports and Objects like Attributes, Filters, Facts, Prompts, Custom Groups, Consolidations, Transformations, Fact extensions, Hierarchies with the data warehouse to enable clients to assess their services against the data assets to increase profitability and manage risks by reducing operational costs.
• Ability to design dashboard work - flow based on requirements
• Extensive knowledge of MicroStrategy resource usage pattern to fine tune reports and dashboards for optimum performance
• Ability to understand design impact to reporting, resource usage, and performance
• Hands on experience in Databases like MS SQL Server, Oracle and MySQL.
• Expertise in Database development using SQL, PL/SQL, Stored Procedures, Functions and Triggers.
• Strong Understanding of Data Modeling concepts. Comprehensive knowledge of physical and logical data modeling.
• Extensive experience in design and development of Data Warehousing systems.
• Ability to identify and resolve performance related issues at the DB level for MicroStrategy deliverables.
• Ability to interact with Business owners to understand their requirements and translate them into technical specifications
• Involved in all stages of data warehousing and reporting projects
• Excellent development skills using latest technologies including Java, EJB, JMS and Web services.
• Knowledge of XML, XML parsers and SOAP.
• Solid background in Object-Oriented analysis and design.
• Worked on Software-as-a-Service (SaaS) based solutions.
• Oracle Certified PL/SQL developer.
• Good team working skills with a proven ability to interact with individuals at all levels.
• Was awarded the Customer Service Excellence Award by Confidential, USA for demonstrating outstanding leadership.

TECHNICAL SKILLS:

Operating systems: Windows 2000, Windows XP/NT, Windows 2003, Windows Vista

Reporting Tools: MicroStrategy 9.x, PS-Query, SQR

Databases: SQL SERVER, Oracle, MySQL

Languages: Java, Ruby (basics), HTML, XML, PeopleCode, JavaScript

Technologies: JMS, JDBC, JUnit, J2EE, Business Intelligence

ORM: JPA, Hibernate

Server: JBoss, Apache Tomcat

PeopleSoft: PeopleTools, PeopleSoft HRMS, PeopleSoft Payroll

PROFESSIONAL SUMMARY:

Confidential

Project Lead/Architect

Operating System: Windows Server 2003

Software used: MicroStrategy 9.0.1

Database: SQL Server 2008

Responsibilities:

• Responsible for end to end implementation of the project.
• Involved in analyzing business requirements, reviewing and communicating with business users.
• Responsible for providing support in resolving moderately complex program problems. Worked with client and management to resolve issues and validate programming requirements within their areas of responsibility.
• Responsible for Multidimensional Data Modeling using Star Schema.
• Designing, Developing and Testing of ETL jobs and Sequences.
• Responsible for MicroStrategy installation, administration and security
• Responsible for MicroStrategy Schema Design and Development.
• Created MicroStrategy Metadata Objects and Reports.
• Created various report services and Dashboard documents.
• Responsible for providing recommendations on technical issues.
• Responsible for configuring MicroStrategy web for access by end users.
• Responsible for testing and delivery.

Confidential

MicroStrategy Developer

Operating System: Windows Vista

Software used: MicroStrategy 9

Database: Oracle

Responsibilities:

• Mainly involved in MSTR Report development.
• Building of design Documents as per the client requirements.
• Validating reports to user requirements by testing developed Reports.
• Alter existing reports and making necessary changes as required.
• Creating test cases for each report and cross verifying the outputs.

Confidential

Team Lead/Project Architect

Operating System: Windows Vista

Software used: Force.com IDE, MicroStrategy

Database: Salesforce Database

Responsibilities:

• Involved in database and UML design.
• Involved in writing business logic in APEX language.
• Involved in developing reports in MicroStrategy.
• Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop.
• Responsible for creating user and user groups using the command manager of MicroStrategy Administrator.
• Worked extensively in creating complex reports using simple metrics, compound metrics, relationship filters.
• Played an important role in coordination with the entire team and managing time estimates for the entire project.
• Identified the Source tables and columns required to create the MicroStrategy Project, thereby achieving a logical mapping of the physical data warehouse in the MicroStrategy Metadata Repository.
• Designed MicroStrategy Schema objects and Application objects using MicroStrategy Desktop and maintained data dictionary for the project.
• Set up of Metadata Structure using MicroStrategy Configuration Wizard.
• Executed testing of all reports for the final deployment.
• Involved in configuring MicroStrategy web for access by end users.

Confidential

Architect/Lead

Operating System: Windows NT

Software used: MicroStrategy

Database: Oracle 8i.

Responsibilities:

• Interacted with the users extensively and gathered the requirements, and analyzed the needs of the end users.
• Gathered information from existing systems, analyzed program and time requirements
• Involved in architecting Fact columns and development of Hierarchies with related Attributes required for reporting.
• Created projects, attributes, hierarchies, metrics, filters, and templates using MicroStrategy Desktop.
• Extensively worked in developing Metrics, Compound Metrics and Filters for complex reports
• Involved in troubleshooting MicroStrategy prompt, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment.

Confidential

Developer

Operating system: Windows NT

Software used: MicroStrategy, PeopleSoft HRMS 8.x, PeopleTools 8.42, SQR

Database: MS SQL Server

Responsibilities:

• Responsible for requirement gathering.
• Involved in Data mapping i.e. recognizing the Tables and Fields required for reports.
• Involved in ODS Design.
• Worked as a MicroStrategy Developer for development using desktop.
• Created MicroStrategy Metadata Objects and Reports.
• Responsible for Building new reports.
• Responsible for System testing and end-to-end testing for Reporting Phase of the project.
• Conducted quality assurance activities such as peer reviews.
• Handled MicroStrategy training sessions to the team members with in the project and Data Warehousing group for trainees.