Manager Project

KRUNAL VANASOLA

646-***-****

PROFESSIONAL SUMMARY

. More than 6 years of IT experience in Data warehousing, Data modeling,

Data architecture, Business Intelligence.

. Almost 5 years of Experience with MicroStrategy 9.0/8.1.2/8.1.0/7.5.2/7.5

reporting Suite. MicroStrategy Desktop, MicroStrategy Web, MicroStrategy

Narrowcast Server, MicroStrategy Intelligence Server, MicroStrategy

Architect, MicroStrategy OLAP services, MicroStrategy Administration.

. Enrich Experience with Retail, Pharmaceutical, Health care, Insurance

Domains.

. Highly familiar with RDBMS likes Oracle, SQL server, DB2, Teradata,

Netezza.

. Experienced in creation, implementation and modification of schema

objects and application objects (Attributes, Facts, Filters, Metrics,

Prompts, Custom Groups, and Consolidations) using Microstrategy Desktop

. Experienced in performing MicroStrategy Administration task that includes

Intelligence Server Administration, configuration of Memory settings,

Performance monitoring, Scheduling, Security filter and VLDB.

. Created Documents and Dashboards using Multiple Datasets using

MicroStrategy report services document.

. Working with End users, Business analysts & Team members to understand

their requirement & providing technical solution & implementation of

various Key Performance Indicators (KPI's).

. Experienced with performance tuning at project and report level.

. Experience with Upgradation of MicroStrategy one version to MicroStrategy

another Version to improved Performance, Speed & new Features.

. Copied various MicroStrategy objects from one project to another project

using Object manager & moved entire project from Development to testing

to production environment using MicroStrategy Project merge wizard.

. Performed various tasks using Intelligence server & Narrowcast Server to

schedule execute & deliver reports using different delivery methods.

. Improved Server speed & share server work load though Clustering.

. Increase report execution time & maintain server load by creating Caching

& Intelligence cube of reports which are frequently needed by users

. Extensive Experience in creation of Freeform reports.

. Strong programming experience in SQL, PL/SQL, T-SQL for creating Stored

Procedures, Views, Triggers and other database objects.

. Strong experience in Understanding Business Applications, Business

Dataflow and Data relations from them. Great enthusiasm to learn, highly

goal-oriented and always strive for the best performance.

TECHNICAL SKILLS

Business Intelligence Tools: MicroStrategy 9/8.1.2/8.0.1/8.0.2/7.5

(MicroStrategy Desktop, MicroStrategy Web,

MicroStrategy Intelligence server, MicroStrategy

Narrowcast server, MicroStrategy Object Manager,

MicroStrategy Enterprise manager, MicroStrategy

Architect, MicroStrategy OLAP services, MicroStrategy

SDK, MicroStrategy Office.)

Databases : Oracle 11g/10g/9i, SQL 2008/2005/2000,

Teradata 12/V2R 6.1.1/6.0.2,Netezza, DB2 9.5/9/1/8, MS

Access, My SQL

Languages : SQL, T-SQL, PL/SQL, C/C++.

Scripting Languages : HTML, XML, PHP and JavaScript.

Data modeling Tools : Toad data modeler, ERwin Data modeler

Tools : SQL loader, SQL *Plus, Toad,

Queryman.

ETL Tools : Informatica

Operating Systems : Window vista/XP/2003/NT/98, MS-DOS, UNIX,

LINUX

Office Tools : MS Excel, Access, Visio, PowerPoint,

Word

PROFESSIONAL EXPERIENCE

Ross Stores Inc., CA

Jan 09-

June 10

MicroStrategy Developer

Ross is third largest off-price retailer with fiscal revenue around $7-8

billion. Company operates more than 900 stores in around 27 states. Project

was to establish BI support to team of Ross, develop reports & documents

which provide intuitive Information to executives, managers & employee

about Supply chain operation, purchase orders and sales performance of

company

Responsibilities

. Analyzed the business model to understand the existing systems and

business requirements

. Built and implemented various MicroStrategy Reports using attributes,

filters, metrics, hierarchies & templates in project.

. Developed metrics, compound metrics, custom groups, and consolidations,

templates using filters & prompts in MicroStrategy 9.

. Created (table based transformation) using YTD (year to date), MTD (month

to date), last year, last quarter, last month table in comparative

reports like sales this year to last year.

. Extensively worked on various Prompt reports to facilitate end users

requirement at run time.

. Improved the performance of the reports using VLDB properties and report

data option.

. Communicated with the users to understand the requirements of dynamic

dashboards and reports

. Designed layout of dynamic dashboard that would help managers and team

leader to effectively manage their branches and teams performance.

. Troubleshooted problems with existing reports to resolve multiple issues.

. Worked with data warehouse team to resolve data issues

. Created Intelligence cube to reduce database load and decreasing the

report execution time using cube.

. Used Object manager to move the MicroStrategy Objects from development to

test & test to production environment.

. Delivered various reports using MicroStrategy Narrowcast Server to

business users by different methods with distinct formats.

. Identified & granted privilege to users & user groups using Security

filters in MicroStrategy Desktop (administration).

Environment

MicroStrategy 8.1.2/9 (MicroStrategy Desktop, MicroStrategy Web,

MicroStrategy Intelligence server, MicroStrategy Administration,

MicroStrategy Object manager, MicroStrategy Narrowcast server), Oracle10g,

Teradata, Netezza Queryman, Window 2003

IMS pharmaceutical, NJ

Jan 08 -Dec 08

MicroStrategy Developer

IMS health is which supplies the pharmaceutical industry with sales data

and consulting service. Collect 75% of sales data from 100 countries & 90%

from USA alone. The purpose of Project was creating reports using

Microstrategy on vast array of healthcare data. Reporting was done on

collected data, forecast sale, specific therapy will change overtime &

syndicated report.

Responsibilities

. Worked with Business user to understand their necessities for better

decision making whenever it's needed.

. Installed the MicroStrategy 8.1.2. Business intelligence tool to enhance

company profitability.

. Created ODBC Connection & setting up project Configuration of project.

. Developed 3-tier client connection in company to access relational Oracle

database using MicroStrategy tool.

. Built projects basic objects like Attributes, Fact, Filter, prompts to

help business analyst to view reports at multiple perspectives.

. Extensive worked on Metric & Compound metric using various filter & group

by functions to point out specific Product sale data in specific region

for business intelligence.

. Worked with Data modeler in MicroStrategy architect for creating

dimension data modeling.

. Created Documents & Dashboard using various formatting tools for quick

analysis of Company's KPI on daily, weekly and monthly basis.

. Done VLDB setting for optimization of report performance to reduce the

report run-time.

. Duplication of project objects from developing to testing to production

environment using Object manager.

. Frequently maintenance of Intelligence server in various environments for

better performance & Scalabilities.

. Installed & configured Narrowcast server to deliver reports to users

using various deliver methods in different format likes excel, PDF, text

file, HTML.

. Schedule report was done in spare time to maintain server load.

. Created several Security roles according to user group's requirements and

assigning security role to specific user groups.

Environment

MicroStrategy 8.1.2 (MicroStrategy Desktop, MicroStrategy Web,

MicroStrategy Narrowcast server, MicroStrategy Intelligence server,

MicroStrategy Object manager), Teradata, Oracle 10g, Window 2003.

Forest Laboratories, Inc., NY

Aug 06 - Nov 07

MicroStrategy developer

Forest identifies, develops and delivers pharmaceutical products. Company's

R&D spending is approaching almost at billion US dollar and listing under

top 100 global Corporation in R&D spending.

Responsibilities

. Understanding of historical data & discuss user requirements before

creating reports.

. Created metadata repository and statistical tables in data warehouse

using Configuring wizard.

. Developed & customized Ad-hoc reporting objects likes attributes,

filters, metrics, prompts, consolidations, transformations, hierarchies,

drill maps.

. Prepared auto prompted to support end user to give flexibility of

filtering desire object when they run report every time.

. Created customized Auto-style to allow users to create customized reports

in MicroStrategy Desktop & MicroStrategy Web.

. Actively involved in troubleshooting in project issues like prompts,

metrics, filters, grid & graph display and more enterprise data warehouse

team environment.

. Used Object manager to promote duplication of objects into test project

and finally to production.

. Developed various complicated reports using Complex filters & metrics in

Desktop.

. Created schedules, services & subscription sets using Narrowcast server.

. Good in using Analytic engine bypass function like Applysimple &

Applycomparison.

. Created different Transformations to compare last year, quarterly,

monthly, daily sale versus current data using table base formula.

. Optimized query performance by VLDB settings.

. Worked with end user frequently to resolve various issues in day-to-day

activities.

Environment

MicroStrategy 8.0.2 ( MicroStrategy Desktop, MicroStrategy Web,

MicroStrategy Narrowcast server, MicroStrategy Administration,

MicroStrategy Object manager) Oracle9i, SQL server 2005, IIS, MS office, MS

Visio, Window server 2000, Window XP.

Heartland Bank, MO

Jan 06 - Aug 06

MicroStrategy Developer

Heartland bank is a full-service regional bank. More than one billion

dollars in assets, you can rely on heart bank to deliver customized

solution that meets your specific requirement. Create reports of checking,

saving & credit card amount observe the cash flow. Create dashboards to get

intuitive information on daily, monthly & yearly basis from personal &

mortgage loans.

Responsibilities

. Worked with source system to understand the data flow & interact with

users to collect important information.

. Used customers, geographic, payment & time dimensions and generated

forecasting reports.

. Designed Metadata using MicroStrategy configuration wizard.

. Developed Ad-hoc reports using templates, metrics and filters for

business analysis using MicroStrategy Desktop with features of drilling

options [drill up, drill down and drill across].

. Developed an Auto-prompted report, which gives user choice of various

filtering feature each time they run reports.

. Configured Metrics filters and attributes for each reports.

. Created Dashboards & Scorecards using report service documents using

various formatting features like Selector, Panel, PanelStack & Widgets.

. Provided time dimension solution & analysis on different issues using

Transformation metrics.

. Optimized MicroStrategy Intelligence server speed & workload using

Caching, Scheduling & Clustering.

. Played important role in user acceptance testing reports.

Environment

MicroStrategy 8.0.1 (MicroStrategy Desktop, MicroStrategy Web,

MicroStrategy Intelligence server, MicroStrategy Administration) SQL

server, IBM DB2, Java, HTML, XML, Window 200.

Keystone Mercy Health Insurance, PA

April 05 - Dec 05

MicroStrategy Developer

The purpose of project was to develop reports & documents of payment

methods, customer claim & other medical reports. Designed around 10

dashboards and 50 reports which help manager to take effective decision in

company.

Responsibilities

. Worked in team to identify MicroStrategy objects requires supporting

performance.

. Created Facts, Attributes, Compound Metrics, Filters, Prompts.

. Generated reports using Custom groups, Consolidations, Prompts, Filters

in Graph/ Grid mode.

. Prepared interactive Auto-prompts reports for end-users to change

report objects dynamically.

. Identified sources tables and columns from the data warehouse to create

MicroStrategy Objects & Reports.

. Produced Schema objects, Application objects, and various Reports &

Dashboards.

. Constant interaction with functional analyst to translate business

requirements into configurable components & designs.

. Developed report using Free form SQL where Outer joins betweens two

tables is needed.

. Created user, user groups and assigned privileges through Security

roles.

. Worked with back end database administration to provide necessary

tables as per requirements.

Environment

MicroStrategy 7.5.2 (MicroStrategy Desktop, MicroStrategy Web,

MicroStrategy Administration) SQL Server 2005, Informatica, Oracle 9i,

Window XP professional.

Intas pharmaceutical, India

Jan 04 - March 05

Intas pharmaceutical is one of the leading pharmaceutical companies

in India. It provides wide range of products, R&D and supply chain etc.

Responsibilities

. Created login ID, setting up privileges and procedures for protection of

data.

. Built the Report specification and Report documentation for the reports.

. Keep all employee data (Grades, salary, department, Promotion).

. Built numbers of Normalized tables with different Constraints to improve

data integrity.

. Generate & execute SQL scripts against database.

Environment

Oracle 9i, SQL2000, SQL, VB script, TOAD, SQL *Plus, PL/SQL navigator,

Window 98.

Education

. Bachelor of Science from Gujarat University, India.

Contact this candidate