Jimi Minipara

Associate Technical Consultant

acoid6@r.postjobfree.com

http://in.linkedin.com/pub/jimmy-minipara/39/68a/708/en

Education Qualifications and Certifications :

• TD12 SQL Certified

• Teradata Certified TD12 Certified Professional

• Bachelor of Engineering (Information & Communication Technology), MIT, Manipal, India (2010)

• Diploma (Information Technology),M.S.Ramaiah Polytechnic, Bangalore, India (2006)

• Senior Secondary School, N.P.Bhalodiya School, Junagadh, India (2000), GSEB Board

Profile and Experience:

• 5 years of experience in Business Intelligence Domain (Microstrategy).

• Ability to analyze the data model provided by client.

• Strong knowledge of schema object creation in Microstrategy.

• Experience in development of attractive dashboards.

• Strong knowledge in analyzing SQL and comparing the report data by executing manual SQL.

• Tuning report SQL through VLDB settings.

• Able to work in shifts except night shift.

• Knowledge of Tableau Development.

Primary Area of expertise

• Business Intelligence solution for Banking, Retail and Gaming industry.

• Designing and Developing creative dashboards and reports in microstrategy.

• Troubleshooting, Debugging, ensuring smooth implementation and testing of dashboards and

reports in Microstrategy.

• In addition to this abundant reporting expertise, the hands–on experience on Cognos, Tableau BI

tools plus SQL, Teradata and DB2 database.

Skill Sets:

Operating Systems Windows

Reporting Tool Microstrategy(9.x.x)

RDBMS DB2, SQL, Teradata, Oracle

Other Tools and Utilities DataStage, Cognos, Tableau

Other Languages/ C,C++, Vb.Net, ASP.Net

Technologies / Platforms

Project experience:

Client : H-E-B

Period : July-2014 to Till date

Industry : Retail

Project Name : TMS

Project Type : Development

Environment : Microstrategy, Teradata

Role : Microstrategy Senior Report Developer

About H-E-B:

H-E-B also known as H-E-B Grocery Stores, is a privately held supermarket chain based in San Antonio,

Texas, with more than 350 stores throughout the U.S. state of Texas, as well as in northern Mexico. The

company also operates Central Market, an upscale organic and fine foods retailer.

Project Description:

Creation of TMS(Transportation Management System) reports from scratch through which user can

analyze the data on Delivery Performance, Driver Utilization, Driver Bid Matching Comparison, Store

Schedule Confirmation Reporting, Store Delivery System Reconciliation, Planned vs. Actual Freight

Performance, Carrier Management.

Responsible for:

• Analysis of data model provided by client and discuss it with client .

• Analyzing the business requirement documents and discuss it with clients

• Analysis of existing objects for reusability.

• Designing mapping documents which describes the mapping of MSTR objects with database

tables or views.

• Import the tables in Microstrategy for reporting

• Creation of Schema Objects like attributes, Facts, Hierarchy.

• Creation of Metrics, Base formula, Prompts and Filters as per the requirements.

• Creating reports by combining report objects and perform unit testing.

• Analyze the SQL generated by MSTR and make tuning to increase performance.

• Setting VLDB properties within MSTR to meet the requirement and to tune the SQL.

• Troubleshoot and Debug the defects by comparing data with database through manual scripts on

Teradata.

• Create documents to establish standards, guidelines for new team members

• Support the SIT and work on defects raised by testing team.

Project experience:

Client : Electronic Arts (EA)

Period : October-2013 to May-2014

Industry : Gaming

Project Name : EA Digital

Project Type : Development

Environment : Microstrategy, Teradata

Role : Microstrategy Report Developer

About Electronic Arts (EA):

Electronic Arts(EA) is an American developer, marketer, publisher and distributor of video games. The

company was a pioneer of the early home computer games industry and was notable for promoting the

designers and programmers responsible for its games. EA develops and publishes games under several

labels including EA Sports titles, Madden NFL, FIFA, NHL, NCAA Football, NBA Live, and SSX

Project Description:

Creation of EA Digital dashboard for origin partners and reports from scratch through which user can

analyze the data on Sales analytics, Game analytics, User analytics, User Activity Analytics, Subscription

Analytics. These reports have functionality of all existing reports of Digital Metrics project, which will be

replaced by these new reports.

Responsible for:

• Analyzing the business requirement documents and discuss it with clients

• Analysis of existing objects for reusability.

• Designing mapping documents which describes the mapping of MSTR objects with database

tables or views.

• Creation of Metrics, Base formula, Prompts and Filters as per the requirements.

• Creating reports by combining report objects and perform unit testing.

• Analyze the SQL generated by MSTR and make tuning to increase performance.

• Setting VLDB properties within MSTR to meet the requirement and to tune the SQL.

• Troubleshoot and Debug the defects by comparing data with database through manual scripts on

Teradata.

• Create documents to establish standards, guidelines for new team members

• Support the SIT and work on defects raised by testing team.

Project experience:

Client : American Express (AMEX)

Period : April-2012 to November-2012

Industry : Banking

Project Name : Card Reporting Transformation Phase 2

Project Type : Development

Environment : Microstrategy, DB2

Role : Microstrategy Report Developer

About American Express (AMEX):

American Express Company is an American multinational financial services corporation. The company is

best known for its credit card, charge card, and traveler's cheque businesses. Amex cards account for

approximately 24% of the total dollar volume of credit card transactions in the US.

Project Description:

Creation of 6 Global category reports through which user can get the reports on his spent on Global

Airline, Hotels, Cars hired on rent and spending on Industries. Suppler Activity and Organization summary

reports give the information of spending by different suppliers and organizations. These reports have

functionality of 29 existing reports which will be replaced by these new reports.

Responsible for:

• Analyzing the business requirement documents and discuss it with clients

• Analysis of existing objects for reusability.

• Reviewing high level UML design documents.

• Create peer review design documents.

• Generate DDL to create views and implement it on semantic layer to increase the performance of

report execution.

• Designing mapping documents which describes the mapping of MSTR objects with database

tables or views.

• Creation of facts, Metrics, Attributes, Base formula, Prompts and Filters as per the requirements.

• Creating reports by combining report objects and perform unit testing.

• Analyze the SQL generated by MSTR and make tuning to increase performance.

• Setting VLDB properties within MSTR to meet the requirement and to tune the SQL.

• Troubleshoot and Debug the defects by comparing data with database through manual scripts on

DB2.

• Create documents to establish standards, guidelines for new team members

• Support the SIT and work on defects raised by testing team.

• Support warranty period of three months after deployment.

Project experience:

Client : American Express (AMEX)

Period : March-2012 to April-2012

Industry : Banking

Project Name : vPayment Enhancement

Project Type : Development

Environment : Microstrategy, DB2

Role : Microstrategy Report Developer

About American Express (AMEX):

American Express Company is an American multinational financial services corporation. The company is

best known for its credit card, charge card, and traveler's cheque businesses. Amex cards account for

approximately 24% of the total dollar volume of credit card transactions in the US.

Project Description:

Merging of Billed and Unbilled report into a single report which gives billed and unbilled data.

Responsible for:

• Analyzing the business requirement documents and discuss it with clients

• Analysis of existing objects for reusability.

• Generate DDL to create views and implement it on semantic layer to increase the performance of

report execution.

• Designing mapping documents which describes the mapping of MSTR objects with database

tables or views.

• Designing web customization document for reports where needed.

• Creation of facts, Metrics, Attributes, Base formula, Prompts and Filters as per the requirements.

• Creating reports by combining report objects and perform unit testing.

• Analyze the SQL generated by MSTR and make tuning to increase performance

• Setting VLDB properties within MSTR to meet the requirement and to tune the SQL

Project experience:

Client : American Express (AMEX)

Period : July-2011 to March-2012

Industry : Banking

Project Name : Card Reporting Transformation Phase 1

Project Type : Development

Environment : Microstrategy, DB2

Role : Microstrategy Report Developer

About American Express (AMEX):

American Express Company is an American multinational financial services corporation. The company is

best known for its credit card, charge card, and traveler's cheque businesses. Amex cards account for

approximately 24% of the total dollar volume of credit card transactions in the US.

Project Description:

Creation of 17 Market which replaces 75 existing reports with all the functionality of existing reports which

helps in below activities.

• Monitoring compliance by anticipating charges that could be declined due to Card members

approaching their limits,

• Monitoring Card member spend activity, Monitoring past due Card Accounts to manage

delinquency fees

• Monitoring compliance by reviewing declined transaction information for all types of declines

• Analyzing hotel, car and Airline spend to support budgeting, compliance, and supplier negotiation

activities.

• Analyze spending with an analysis of supplier spend which supports budgeting, compliance, and

supplier negotiation activities.

Responsible for:

• Analyzing the business requirement documents and discuss it with clients

• Analysis of existing objects for reusability.

• Reviewing high level UML design documents.

• Create peer review design documents.

• Generate DDL to create views and implement it on semantic layer to increase the performance of

report execution.

• Designing mapping documents which describes the mapping of MSTR objects with database

tables or views.

• Designing web customization document for reports where needed.

• Creation of facts, Metrics, Attributes, Base formula, Prompts and Filters as per the requirements.

• Creating reports by combining report objects and perform unit testing.

• Analyze the SQL generated by MSTR and make tuning to increase performance

• Setting VLDB properties within MSTR to meet the requirement and to tune the SQL

• Troubleshoot and Debug the defects by c comparing data with database through manual scripts

on DB2.

• Create documents to establish standards, guidelines for new team members

• Support the SIT and work on defects raised by testing team.

• Support warranty period of three months after deployment.

Project experience:

Client : American Express (AMEX)

Period : September-2010 to May-2011

Industry : Banking

Project Name : SAM2CAR

Project Type : Development

Environment : Microstrategy, DB2

Role : Microstrategy Report Developer

About American Express (AMEX):

American Express Company is an American multinational financial services corporation. The company is

best known for its credit card, charge card, and traveler's cheque businesses. Amex cards account for

approximately 24% of the total dollar volume of credit card transactions in the US.

Project Description:

Creation of 8 new reports which gives the functionality of Monitor Card member spend and allocation

activity, Manage and analyze spend with a focus on 3rd party data, e.g., Purchase Order data. And

Monitor compliance by reviewing account detail information along with basic, line item detail

Responsible for:

• Analyzing the business requirement documents and discuss it with clients

• Analysis of existing objects for reusability.

• Reviewing high level UML design documents.

• Create peer review design documents.

• Generate DDL to create views and implement it on semantic layer to increase the performance of

report execution.

• Designing mapping documents which describes the mapping of MSTR objects with database

tables or views.

• Creation of facts, Metrics, Attributes, Base formula, Prompts and Filters as per the requirements.

• Creating reports by combining report objects and perform unit testing.

• Analyze the SQL generated by MSTR and make tuning to increase performance

• Setting VLDB properties within MSTR to meet the requirement and to tune the SQL

• Troubleshoot and Debug the defects by comparing data with database through manual scripts on

DB2.

• Create documents to establish standards, guidelines for new team members

• Support the SIT and work on defects raised by testing team.

• Support warranty period of three months after deployment

Training History:

Company Name Undergone Professional Training

Teradata India Pvt Ltd Tableau, Teradata

IBM India Pvt Ltd Microstrategy, Cognos, Datastage, Oracle, UNIX

Career History:

Company Date Position

3rd December 2012 Till

Teradata Corporation Associate Technical Consultant

Date

17th June 2010 to

IBM India Technical Lead

30th Nov 2012

Personal Information:

th

Date Of Birth: 17 Nov 1985

Marital Status: Married

Nationality: Indian

PASSPORT NO: F9437824

Email: acoid6@r.postjobfree.com

Contact: +91-996*******

Languages known

Hindi, English, Gujarati, French (Learning)

Date Jimi Minipara

Contact this candidate