Manager Project
Resume:
Curriculum Vitae
Raghu H M Mobile: +**-
Current Company : Intel India. Email: *****.*.*@*******.***
***********@*****.***
Professional Summary:
Microstrategy:
Extensively worked on Microstrategy Desktop, Mstr Web and Object Manager.
Extensively worked in creating and integrating Microstrategy reports and objects
(Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom
Groups, Drill maps,Logical Tables,Hierarchies).
Experience in migrating the objects between projects using Microstarategy Object
Manager.
Experience in Creating Transformations for time-series analyses.
Experience in Designing/Developing Ad-hoc Reports.
Experience in Designing/Developing Documents and Dashboards.
Experience in Installing, Configuring and Using Microstrategy 8.1 tool Suite and 9.0.1,
9.2,9.3 (Microstrategy Desktop).
Hands on experience of Mstr Administration.
Knowledge on Dimension Modeling, Star Schema and Snowflake Schema.
Teradata:
Experience in Teradata database and Utilities.
Worked on creating Teradata Stored Procedures.
Created many complex views with varied level of viewing the data.
Cetrification: Teradata Basics V2R5 Certrified Proffessional
Informatica:
Experience of creating mapping in Informatica Power Centre @ Supervalu.
Experience in analyzing and debugging the mappings through Informatica Mapping
Designer, Warehouse designer and Warehouse Monitor.
Ab Initio:
Attended training on AbInitio Basics @ Intel from AbInitio.
Worked on adding additional columns to the existing graphs.
Debug few AI errors regarding data quality and graph settings.
Possess knowledge on AI graph migration process.
SAP Business Objects:
Took vendor training on SAP Business Objects @ Intel.
Worked extensively with Excel Analysis Reports.
Working on POC’s for the existing MSTR reports to be built on BOBj.
Character:
Highly motivated IT professional with the extremely valuable combination of technical
knowledge, interpersonal skills & business acumen.
Good Team member with the ability to motivate & lead team members.
Effective Team Player with excellent analytical, programming, written & verbal
communication skills.
1 Experience:
Working as a Application Developer/System Analyst in Intel Corporation
from June 2011 to till date
Worked as Software Engineer in Computer Sciences Corporation from
June 2010 to June 2011
Worked as Software Engineer in Supervalu Services India from Jan 2008
to June 2010.
2 Technical Skills:
Reporting : Microstrategy 8.1,9.1,9.2 and 9.3, SAP Business
Objects.
ETL : Informatica7.3, Ab Initio
Databases : Teradata 6,12 and 13.
Scheduler : Autosys and ESP.
Operating Systems : Windows 98/2000/XP/7, Unix
1 Academic Qualification
GRADUATION : B.E in Electronics and Communication from VTU Karnataka.
Dayananda Sagar College of Engineering 2007.
1 PROJECT PROFILES:
3
4 Project # 1
Title : Work Flow Data Staging
Client : Intel SNC
Company : Intel Corporation
Duration : Jun 2011 to Till Date
Role : Microstrategy and Teradata Developer/SA.
Tools Used : Microstrategy 9.0.1, Teradata 13
Team Size : 10
5
6 Description:
Work Flow Data Staging provides a comprehensive data foundation for all Supply
Planning at Intel enabling an agile build plan business processes. WFDS is on Teradata’s
Master Data Management and provides a centralized place to sync, clean and complete data
BEFORE it gets moved to the various use cases.
Sub-Project1 : WFDS Schedule IT Reports
Responsibility:
There are about 75+ reports in this project.
The reports cater different set of planners like, Subcon planners,Material
Planners,Chipset Planners and MWG(Mobile Wireless group) Planers.
Reports helps in Studying and reporting out trending of Subcon performance
as well as Demand performance for Pricing and Supply Chain loading
strategies
Most reports compare data between Actuals and Schedules data.
Sub-Project 2 : WFDS Teradata
Responsibility:
Altered the Stored Procedures to include the new columns as per business
requirement.
Created Stored Procedures which are to be called from Teradata MDM UI .
Changed the view and table definition to get the new columns and hence
archive the data for a longer time period.
Sub-Project 3 : WFDS AbInitio
Responsibility:
Changed the existing AI graphs to cater the newly added columns to the
source and Target tables.
Learnt of debugging the AI errors while encountered in executing the graphs.
Possess AI export process and scripting knowledge.
7 Project # 2
Title : Intransit Cycle Time Reduction.
Client : Intel SNC
Company : Intel Corporation
Duration : Jun 2011 to Dec 2011
Role : Microstrategy and Teradata Developer/SA.
Tools Used : Microstrategy 9.0.1,9.3 Teradata 13
Team Size : 1 Developer and 200+ Business Users.
8
9 Description:
10 Intel being a manufacturing company is keen on reducing the cycle time
(shipment time between different sites) between sites.
11
12 Responsibility:
13 Identify right Information sources and data latency requirements from
enterprise environment for each of the Cycle Time metric master and transactional
data
14 Scope would include IA CPU product family and Intel ATM factories from sort
out process till finished good warehouse
15 Document the business process and building blocks which constitute the
cycle time for the identified metric implementation
16 Build the consumption data mart in EDW approved subject area which would
have the fact tables used in the metric
17 Report out the CT Metric in Micro strategy report and have capability for roll up
and drill down with EDW data.
18
19
20 Project # 3
Title : GAP China Growth Initiative
Client : GAP
Company : CSC(Computer Sciences Corporation)
Duration : Jun 2010 to Till-date
Role : Microstrategy Developer
Tools Used : Microstrategy 9.0.1, Teradata 12,13
Team Size :3
Description:
Gap is a retailer, which operates stores selling Casual / Fashion apparel for men, women and
children under five brand names like GAP, GAPKIDS, BABYGAP, BANANA REPUBLIC, OLD
NAVY, PIPERLIME and ATHLETA Clothing Co. GAP has outlets throughout the United States,
Canada, United Kingdom, France, Germany and Japan.
The objective of FI Reporting is to implement an integrated merchandise supply chain
solution to enable business growth and flexibility, to improve inventory visibility and
accuracy, to integrate unit and financial inventory, to enable exception management, and
to forecast customer demand.Based on these information inventory goods will be
produced.
Gap has opened it’s first store in CHINA and wanted to analyze the store
performance,customer satisfaction,Sales and Inventory, Forecasted sales data using
microstrategy reports. Our team was responsibl for the creation of Grid reports,
Documents and Dashboards for the analysis.
Responsibilities:
Understand the business questions to be answered as a part of BI analytics having
series of meeting with the user. Make sure that the data needed for the BI reports are
captured as a part of Data in. If not facilitate the Data In process.
Create report templates using mock up data and get it verified from the user to make
sure that is what they want. Have a green flag, initiate the development process.
Once the report has been created analyse the SQL generated by the tool to ensure
the correctness of the data.
Tracks time and fulfils required status reporting requirements. Estimates tasks for
project planning and sets timelines
Provides management and other team members clear and timely updates on status
of assigned responsibilities
Creating Public Objects (filters, prompts, metrics, Custom Groups, Consolidations,
and Searches) to develop Documents and Reports.
Creating Schema Objects (facts, attributes, Hierarchies, Transformations) to
Develop User Objects.
Creating Project Objects (Subtotals and Security Filter) to implement in a Report.
Created the Intelligent Cubes to increase the performance of the reports.
Expertise in using Pass-Through Expressions like Apply Simple and Apply
Comparison
Developed user specified complex Metrics (level and conditional)
Hands on Experience in Dashboards.
Created Documents from multiple Datasets like Grid and graph reports.
Created Drill maps for end users to drill down and recover data
Migrated the objects from development environment to Testing environment using
Object Manager.
Created User groups and User Profiles to test and apply Security Filters.
Project #4
Title : Six Sigma Reports
Client : Supervalu Services US
Company : Supervalu Services India
Environments : Microstrategy 8.1.1 and 9.0.1, Teradata 6 and 12
Role : Microstrategy Developer
Duration : Jun 2008 to Jun 2010
Team Size : 6
Description:
SUPERVALU is a grocery and pharmacy company serving a wide range of customers
in USA, through stores ranging from hard discount to traditional and premium grocery
formats. SUPERVALU reaches millions of families with the products and services they need
through owned, licensed, franchised and affiliated stores.
SUPERVALU nationwide network of approximately 2,500 retail stores embodies the full
range of grocery retailing formats, blending value and service .
Six Sigma is a process that uses statistical analysis to help determine the true
CAUSES of inefficiency in business practices. SixSigma certified black belts looks to improve
the business by reducing shrink, waste of labour and money.
Web based request form are raised by the black belts mentioning the column names, store
num and the time period for which the report is to be prepared.
There are about 80 requests which are to be delivered on both weekly and monthly basis to
compare the improvement in the process.
Responsibilities:
Creating Schema Objects (facts, attributes, Hierarchies, Transformations) to
Develop User Objects.
Developing Public Objects (filters, prompts, metrics, Custom Groups,
Consolidations, and Searches) to develop Documents and reports.
Created Security Filters and applied the same to the same profiles.
Expertise in using Pass-Through Expressions like Apply Simple and Apply
Comparison to develop complex Filters and Transformations.
Using Administration tools like Object Manager and Command Manager.
Creating interactive dashboards to view personalized reports based on user
requirements.
Actively participated in the automation process of 800 continuous requests.
Project #5
Title : Scan Based Trading
Client : Supervalu Services US
Company : Supervalu Services India
Environments : Informatica 7.1.3, Teradata 6
Role : Informatica Developer
Duration : Jan 2008 to Jun 2008
Team Size : 14
Responsibilities:
In every stores under Supervalu banner there will be thousands of transactions happens
every day. These data has to be stored somewhere to analyse the customer response on
each day.
Also for reporting purposes, aggregated data has to be used to make certain decision about
the sales. Hence the transaction data is aggregated and loaded to the data warehouse.
Developed Mappings/Workflows to meet the ETL requirements
Designed the Stored Procedures to meet the project requirements.
Wrote complex Teradata bteqs for aggregation of data.
Assisted and set Script and Informatica Coding Standards for easy maintenance.
Interpreted technical design requirements effectively
Fine tuning of long running SQLs and Bteq.
Personal information:
Name : Raghu H M
Date of Birth : 07-02-1986
Nationality : Indian
Place : Bangalore, Karnataka.
Sex : Male
Languages : English, Kannada, Hindi
Email-id : *****.*.*@*******.***
Mobile No : 998-***-****
Raghu H M
Contact this candidate