Project Sales
Resume:
Sekhar +91-959*******
***********@*****.***
Professional Summary:
Experience of Design, Development and the implementation of applications in Business
Intelligence Micro strategy 9.0.x/9.2.x/9.3.x
Create Reports, Dash boards and Documents using MSTR Desktop and Web.
Understanding BRD and Semantic Layer Documents Prepare REPORT ANALYSIS and
METRIC Design Documents.
Having Good Knowledge on Schema Objects( Attributes, Facts, Hierarchies and
Transformations)
Expertise at creating Complex and Comprehensive Reports using Custom Groups,
Consolidation, Prompts, Filters, Metrics and Drill Maps.
Hands of Experience on Creating Dashboards and Documents using widgets for analysis
and more interactivity at Flash mode.
Experience of Creating Dynamic Reports Using OLAP Services.
Customize the Expressions using PASS THROUGH Functions (Apply Simple, Apply
comparison, Apply Logical)
Good Knowledge in moving Reports from Dev Environment to QA Environment.
Good Exposure on Dimensional Modeling using different Schemas such as Star and Snow
flake.
Strong Knowledge on Database like Oracle, SQL Server
Excellent Interpersonal and Communication skills,An excellent team player with highly
favorable, interpersonal, multitasking, hard working with Analytical skills, fast learning and
prioritizing capabilities.
Technical Skills:
BI Tools : MicroStrategy 9.0.x/9.2.x/9.3
DBMS : Oracle 9i/10g, SQL Server2005.
Operating System : Windows XP, Windows 7
Educational Profile:
Completed Bachelor of Science (B.Sc.,) From Acharya Nagarjuna University.
Professional Experience:
Working as a Report Developer in Accenture, Bangalore from June’2011 to Till Date.
Previous worked as a Team Member in Enoahisoluations, Chennai from Oct’ 2009 to May’2011.
Project Summary:
Project #1
Project Name : Sales Enhancement System
Client : Limited Brand Inc., Columbus, OH
Description:
Limited Brands selected the MicroStrategy Business Intelligence Platform as its strategic
enterprise reporting and analysis standard. Limited Brands sells women’s intimate apparel, personal care
and beauty products, and women’s and men’s apparel under various trade names through its specialty
retail stores and direct response (catalogue and e commerce) businesses. Limited Brands currently uses
MicroStrategy for calculating the yearly performances and various functional specifications.
Responsibilities:
As a MicroStrategy Developer designed & created Templates, Filters, Metrics, Consolidations,
Prompts, etc., in MicroStrategy Desktop.
Developed MicroStrategy application objects such as Metrics, Filters, and Prompts to compare
monthly, quarterly, and annual sales.
Created Base formulas and used them in multiple metrics and categorized those metrics to create
complex metrics.
Created transformations using transformations for YTD (Year to date), MTD (Month to date) and
WTD (Week to date) analysis.
Created Complex Metrics forcing Dimensionality and Conditionality.
Created Complex reports for Analysis with Transformations, Custom Groups and Complex Filters.
Created reports for sales and marketing with the drill down methodology in all options.
Project #2
Project Name: pharma Lynching Intelligence
Client : Forest Laboratories, New York
Description:
The Objective was to apply the Business Intelligence solutions built on the MicroStrategy platform
to give the Pharmaceutical Company an opportunity to efficiently manage their enterprise using the
results that come from the BI tool. The ideas was to give them the capability for analysis of data from the
available IT that helps determine, track and take appropriate responses in the branch of business needed
for the betterment of the enterprise
Responsibilities:
Empathized the Business requirement and design applications to meet client requirements.
Configuring and designing analytical reports through MicroStrategy 9.0.x Environment.
Creating Exotic Public Objects like Metrics, Filters, Prompts, Custom group, Consolidation, Drill
mapping based on project Requirement.
Manipulating relevant reports using thresholds, Auto styles, Banding, Page By, data pivoting and
Totals.
Create and Apply Relevant Pass through functions in the MicroStrategy Reports.
Developing and formatting report service documents with appropriate datasets.
Creating Scorecards and Dashboards which helps in better understanding of business trends.
Designing reports using OLAP Features like derived metrics, derived elements and dynamic
aggregation.
Having judicious awareness on Data modeling and creation of schema objects like attributes,
facts, transformations and hierarchies.
Project #3
Project Name : Safe BI Reporting
Client : Safeway inc., USA
Description:
The safe BI reporting is mainly deal with Sales and Marketing. The Safe BI reporting provides the
foundation for managing information across Safeway’s Commercial Enterprise. Safeway’s future
Commercial Architecture will facilitate the flow of information between numerous systems through its
Common Integration Layer (CIL). The architecture will provide Safe BI applications with a foundation to
communicate with each other through a hub and spoke architecture, increasing flexibility and reducing
point to point interfaces. This is accomplished through the implementation of information integration
services that provides semantic abstraction, matching, cleansing, aggregation, extraction, transformation,
publishing, and subscription.
Responsibilities:
Responsible for the Analysis and Sizing the MicroStrategy efforts to execute the Projects.
Going through the Business requirement and designed applications to met client requirements.
Responsible for the performance tuning of Reports and Documents using various performance
approaches like SQL tuning, optimizing the Reports using VLDB Properties.
Created distinct metrics, filters, prompts used to generate Standard reports for business
requirements.
Developed public objects like custom groups, consolidations and templates.
Designed and formatted RS documents with appropriate datasets for better Business Intelligence.
Sekhar
Contact this candidate