Project Developer
Resume:
Jimi Minipara
Associate Technical Consultant
*************@*****.***
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: *************@*****.***
Contact: +91-996*******
Languages known
Hindi, English, Gujarati, French (Learning)
Date Jimi Minipara
Contact this candidate