Manager Sql Server

KULDIP KUMAR

MicroStrategy Developer/Architect

609-***-**** (Cell)

******.**@*****.***

Professional Summary

. Over 7 years of IT experience with well acquainted in performing Micro

Strategy Developer, Micro Strategy Architect and Micro Strategy

Administrator.

. Comprehensive working Knowledge with MicroStrategy Desktop,

MicroStrategy Architect, Microstrategy Web, MicroStrategy Narrowcast

Server and OLAP Services Environment.

. Extensively worked in creating and integrating MicroStrategy reports

and objects (Attributes, Filters, Metrics, Facts, Prompts, Custom

Groups and consolidations) with the data warehouse.

. Expertise in MicroStrategy Business Intelligence Architecture

. Designing Data Marts using different multidimensional modeling

techniques such as Star Schema and Snowflake Schema, Fact and

Dimensional tables, Logical and Physical data modeling

. Extensive Experience in Software Analysis, Design, Development and

Production Support of business intelligence application using

MicroStrategy 9.x/8.x/7.x versions Oracle 10g/9i/8i and SQL Server

2000/2005.

. In-depth understanding of fundamental data warehousing concepts such as

Dimensional Modeling, Star and Snowflake Schemas, Data marts, Security

and deployment, FACT and Dimensional tables, Logical and Physical data

modeling.

. Managing schema objects and application objects across the project by

using Object Manager

. Expert in creation of Report Service Documents, Scorecards and

Dashboards which helps in better understanding of business trends.

. Experience in Data Modeling using ERWIN 3.x/4.0 Data Mart and OLAP for

business analysis using star and snow flake schemas, for faster and

effective querying.

. Strong SQL Skills related to information retrieval and analysis.

Exposure to Clients interaction, user- requirement analysis and user

support.

. Involved with the Full Life Cycle Development of the data warehouse

project.

. Performance monitoring, System optimization and tuning experience in

Multiple BI applications.

. Clarified client requirements, business needs and project objectives,

via feedback sessions and client meetings, in collaboration with all

stakeholders

. Conducted business analysis, project assessment and feasibility

determination.

. Excellent problem solving skills with strong technical background and

good interpersonal skills.

. Involved extensively in Database Performance tuning

. Quick learner and excellent team player, ability to meet deadlines and

work under pressure.

Technical Skills:

Business Intelligence: MicroStrategy9/8.1.1/8.0.2/7X(MicroStrategy

Desktop, MicroStrategyWeb, MicroStrategy

Intelligence Server, Report Services, MicroStrategy

Narrowcast Server, Enterprise Manager, Business

objects XIR2/6.5

Databases: MS SQL Server 2008/2005/2000,

Oracle 8i/9i/10g/11g,Teradata, DB2, MS Access, DB2

Database Version 9.0

Development Tools: TOAD, PL/SQL Developer, SQL-Navigator,

SQL*Plus, Test Director, Win Runner

Operating System: Window XP, MS - DOS, UNIX, AIX

EDUCATION: Bachelor's of Science, North Gujarat University, India

Professional Experience:

Dean Foods, Franklin Park, IL

Jan 2010 - Present

Dean Foods is an American food and beverage company with two operating

divisions: Fresh Dairy Direct and WhiteWave-Morningstar.

Sr. MicroStrategy Consultant

Responsibilities:

. Involved in Administrating and Maintaining MicroStrategy Intelligent

Server, Distribution Services.

. Involved in the meetings with business users to discuss and finalize

the requirements and design of the reports.

. Created the technical specification for the reports for offshore

developers to build the reports using the public object.

. Worked as team with DBA, ETL, Business Users and QA for performance

tuning of the reports and meet the requirement.

. Involved in scrum meetings for fast track development for day to day

work status and set the goal for the time period.

. Architected and performed the Report Development for the MicroStrategy

projects by creating Shema Objects like facts, attributes, hierarchies

and Application objects like reports, filters, metrics and templates

using MicroStrategy Desktop to meet report requirements

. Involved in Dimensional Data Modeling (Star Schema, Snow-Flake Schema)

Data Architecture, Business and Data Analysis

. Architected the projects and created all the necessary schema,

application and configuration objects.

. Created advanced and transformational metrics, filters, consolidations,

custom groups and reports with VLDB properties.

. Created ad-hoc reports by drilling up, down, within and across

Hierarchies.

. Involved in creation of Security filters to end users to access

database on their privileges.

. Used Apply Simple and Apply Comparison functions to develop complex

Filters and Transformations.

. Created Analytics and Metrics to build Dashboards using Dashboard

Manager.

. Created rules and goals using Performance manager and used them in

creating Dashboards. Extensively used filters, templates,

consolidations and custom groups and VLDB Properties to generate

reports for business analysis using MicroStrategy 8i.

. Developed an extensive collection of interactive dashboards using

MicroStrategy Report Services for distribution to executives and field

sales teams.

. Extensive hands on Dashboard and reports regarding Profitability

Analysis of Customer.

. Created different reports like Tabular, Cross tab, Master detail,

Graphs using different reporting features like Slice and Dice, Drill-

down, Prompts, filters, Alerts, Sorts and Breaks.

. Responsible for creation of mappings using filter, splitter, lookup,

sequence, constant operators in Oracle warehouse Builder.

. Created transformations for rolling time period reporting and trending

of prescription counts.

. Extensively used filters, templates, consolidations and custom groups

and VLDB Properties to generate reports for business analysis using

MicroStrategy 8i.

. Developed an extensive collection of interactive dashboards using

MicroStrategy Report Services for distribution to executives and field

sales teams.

. Design, Develop, Test and Implement MicroStrategy reports.

. Analyzed Business Requirements and interacted with the Business

Analysts for designing Ad-hoc reports.

. Developed various Simple and Compound Metrics, Attributes, Facts,

Hierarchies, Prompts, Filters etc.

. Worked with back end Database Administrators to provide requirements

for necessary back end tables

Environment: MicroStrategy 9(Desktop, Web, Architect), SQL Server 2008,

Teradata, Oracle11g, Windows 2003 Server, Distribution Services.

Barclays Bank, Delaware

Nov 2007 - Dec 2009

Barclays is a major global financial services provider engaged in

retail and commercial banking, credit cards, investment banking,

wealth management and investment management services, with an extensive

international presence in Europe, the Americas, Africa and Asia

MicroStrategy Architect/Developer

Responsibilities:

. Involved in interacting with users and gathering the requirement and

analyzed the needs of the business user.

. Gathered and documented business requirement and making mock up reports

in Microstrategy Excel by understanding the clients reporting

requirement.

. Worked with database admin to identify Entity Relationship attribute

and tables.

. Worked with ETL team for loading data in database.

. Architected and performed the Report Development for the MicroStrategy

projects by creating Shema Objects like facts, attributes, hierarchies

and Application objects like reports, filters, metrics and templates

using MicroStrategy Desktop to meet report requirements

. Involved in Dimensional Data Modeling (Star Schema, Snow-Flake Schema)

Data Architecture, Business and Data Analysis

. Used Workflow Manager for Creating, Validating, Testing and running the

sequential and concurrent Batches and Sessions and scheduling them to

run at specified time with required frequency

. Actively involved in walkthroughs and meetings with Business team to

discuss related issues and review of the Objects and reports.

. Created various event based Schedules.

. Involved in requirement gatherings and Initial Implementation of

Microstrategy 64 bit version 9.0

. Upgraded from MicroStrategy 9.0 to MicroStrategy 9.0.1

. Responsible for keeping team members on track toward completing the

terms of goals.

. Created Schema Objects (facts, attributes, hierarchies) and application

objects (filters, prompts, metrics, reports)

. Created and managed database connections to various data store

. Created project plans for development of MicroStrategy projects.

. Created Relation Ship tables to avoid Many-Many relationship between

parent and child attributes.

. Involved in the creation of three types of reports like Map Application

Reports, Reference reports and Adhoc Reports.

. Involved in creation of Datamart Reports, Partition Mappings and

Aggregate tables to improve performance of reports.

. Creating Dash Board Reports to view personalized reports based on user

requirements.

. Involved in the Creation Document from multiple Datasets like Map

Application Diagram, Grid and graph.

. Responsible for using Report services to have High performance In-

Memory, faster reporting for more people and to Drill from cube to

cube, with no hard coded links

. Developed reports by using Free Hand SQL Queries in MicroStrategy

Desktop.

. Added new tables and objects in already existing universes, resolved

the design issues like loops and traps

. Worked on data movement utilities like EXTRACT, TRANSFORM and LOAD

(ETL)

. Exporting universes to repository, so that the users can easily access

the resources.

. Responsible for creating process flows to execute mappings with the

dependencies in Oracle warehouse Builder.

Environment: MicroStrategy 9(Desktop, Web, Architect), SQL Server

2008, DB2 EE v9.5, Oracle11g, Windows 2003 Server

National Life Insurance, VT

Mar 2006-Oct 2007

National Life Insurance pleased to offer a range of flexible insurance

products including health, dental, vision, and life insurance, as well

as prescription drug coverage

Microstrategy Architect/Developer

Responsibilities:

. Involved in Administrating and Maintaining MicroStrategy Intelligent

Server, Narrowcast Server and Web Server.

. Developed and Implemented Security Roles, User Groups, Privileges and

Object Security for developers and end Users.

. Developed and Implemented Event and Time-based Schedules.

. Created Metrics, Prompts, Filters, and Custom Groups for the Report

Development

. Assisted during the project migrations to various environments using

the MicroStrategy Object Manager

. Prepared product scope documents, product requirement specifications,

product business designs, product system testing, and involved with

final product deployment

. Gathered and analysed business requirements from clients and End-users.

. Developed schema objects (facts, attributes, hierarchies, tables) using

MicroStrategy Architect.

. Created transformations for rolling time period reporting and trending

of prescription counts.

. Extensively used filters, templates, consolidations and custom groups

and VLDB Properties to generate reports for business analysis using

MicroStrategy 8i.

. Developed an extensive collection of interactive dashboards using

MicroStrategy Report Services for distribution to executives and field

sales teams.

. Created advanced filters, advanced prompts, advanced report designs and

drill maps.

. Built Logical Views in MicroStrategy 8.1.1 to combine warehouse tables

at runtime during report execution.

. Resolved attribute role problems in Data models by developing table

Aliases and Attribute Role recognition methods in VLDB settings.

. Used SQL Developer extensively to test and debug MicroStrategy reports

as a key step in data validation.

. Analyzed and developed partitioning and indexing strategies for

performance improvement.

. Worked on Performance Tuning of the MicroStrategy reports after

implementation

Environment: MicroStrategy 8.1.1(Desktop, Web, Architect), Microstrategy

Narrowcast Server, SQL Server 2005, DB2 EE v8.1, Windows 2003 Server

Johnson&Johnson,NewBrunswick,NJ Nov 2004- Jan

2006

Johnson & Johnson is a global American pharmaceutical, medical devices

and consumer packaged goods manufacturer founded in 1886.

Sr.Microstrateg Administrator/Developer

Responsibilities:

. Worked closely with Business Users in gathering Business Requirements

and created Documentation for all Report Requirements.

. Participated in business requirements analysis, report designing and

modeling, development of technical specifications, testing and

Implementation.

. Installed, upgraded and managed MicroStrategy 7.2 - 7.5 Intelligent

and Web servers for development, test and production environments

. Designed, developed and maintained logical and physical enterprise data

warehouse schemas using Erwin.

. Design and Developed MicroStrategy Schema Objects and Application

Objects to provide ad-hoc reporting capability against Forecast

Application Tables.

. Performed User Training Sessions for New MicroStrategy Web Users and

help them understand the reporting data dictionary.

. Used Object Manager to migrate objects from DEV to QA and QA to PROD

Environments.

. Used Narrowcast Server to Deliver Reports.

. Involved in writing VBA macro's to populate data from Micro Strategy

Reports to Excel files.

. Involved in creation of Datamart Reports, Partition Mappings and

Aggregate tables to improve performance of reports.

. Set-up the narrowcast environment and created services using

subscription sets, schedules, Information objects.

. Creating Dash Board Reports to view personalized reports based on user

requirements

. Involved in the Creation Document from multiple Datasets like Map

Application Diagram, Grid and graph.

. Involved in customization of Grids and graphs by using SDK.

. Responsible for using Report services to have High performance In-

Memory and faster reporting for more people.

. Responsible for using Report services to Drill from cube to cube, with

no hard coded links.

Environment: MicroStrategy 7.5(Web,Desktop), Oracle 9i and Retek, SQL

Server 2000/2005, Microstrategy Narrowcast server

APPOLO HOSPITAL, India

Sep 2003-Nov 2004

Apollo Hospitals is a group of hospitals which has several branches

spread all over India. Through their excellent service and

hospitalization they are the largest healthcare providers in Asia

MicroStrategy Developer

Responsibilities:

. Modeled the data warehouse by applying dimensional modeling principles.

Identified source tables and columns required to create the

MicroStrategy projects, which references the IBM DB2 data warehouse.

. Developed in a conformed dimension framework to eliminate expensive

redundancy and rework.

. Evaluated and documented strengths and weaknesses of MicroStrategy 7i

for implementation.

. Designed the data model and forward engineered the model into the data

warehouse using Erwin Data Modeler 4.0.

. Developed new reports and converted existing reports for the business

line to satisfy the specifications using DSS Agent.

. Created metrics, filters and templates for the reports.

. Created reports objects such as Filters, Metrics and Templates in

MicroStrategy Desktop.

. Designed report templates to generate reports in grid and graph mode.

. Created Drill Maps to obtain aggregated results.

. Applied OLAP and statistical functions to calculate metrics.

. Created user accounts and group privileges

. DB instance for MicroStrategy and added all the tables, table prefixes

and updated the table structure required for the Project.

. Perform Daily Checks for job Monitor, User sessions and Cache Monitor

to keep the system stable

. Designed many Prompts with different options like Filters, Objects and

Value to facilitate Ad hoc reporting.

. Developing Auto prompts to give end users a choice of different

filtering criteria each time they run the report.

Environment: MicroStrategy 7.2 (Administrator, Web, Desktop), Oracle

8i, SQL Server.

Contact this candidate