Manager Project
Resume:
********@*****.***
Louisville, KY 40220
SUMMARY:
. MicroStrategy Certified Engineer - 2007/2008 (Certified Platform
Administrator, Certified Narrowcast Developer, Certified Project
Designer, Certified Report Developer)
. Strong IT experience in implementing Business Intelligence, expertise
in Datawarehousing, Data architecture, Data modeling, using
MicroStrategy, Informatica, DataStage, SQL Server DTS and ERwin.
. Four years of experience using MicroStrategy suite.
. Over Two years of Business Analyst/Team Lead experience.
. Hands on experience on MicroStrategy 9 product.
. Performed all admin-related tasks in MSTR environment (I-server setup
and configuration, user/security administration, project creation, DB
connectivity, server clustering, upgrades, object management, cache
management, etc).
. Extensively worked in creating and integrating MicroStrategy reports
and objects (Attributes, Filters, Metrics, Facts, Prompts and
Hierarchies) with the Datawarehouse.
. Created complex Reports in MicroStrategy Desktop using features like
templates, freeform sql, custom groups and consolidations.
. Experience delivering reports in Desktop, Web and via the Narrowcast
server.
. Extensive knowledge on SQL/PLSQL and very proficient in working with
very large databases in Oracle 10g /9i, DB2, NCR TERADATA, SQL Server
2000/7.0/6.5, Netezza.
. Excellent communication skills and the ability to work individually as
well as in a team environment
SOFTWARE SKILLS:
OLAP Tools: MicroStrategy 6.0/7.x/7i/8.0/8.0.2/8.1/8.1.2/9 (Administrator,
Architect, Intelligence Server, Desktop, Narrowcast, Web
and Report Services)
Data Modeling: Erwin 4.0/3.5.2, Designer 2000
ETL Tools: Informatica 5.0/6.0(Power center, Power Mart), Data
Stage6.0/7.0, Abinitio, Fast Loads, Multi Loads, OWB.
RDBMS: Oracle10g/9i/8i/8.0/7.0,MS SQL Server 6.5/7.0/2000/2003/2005.
NCR TeradataV2R4/R5/12, Sybase, MS Access, DB2, Netezza
Languages: C, C++, Java, SQL, PL/SQL, T-SQL, .NET
Web: MS FrontPage, HTML, DHTML, JavaScript, VB Script, ASP, JSP, XSL, XML
and CSS.
Other tools: QTP, Win Runner, Load Runner, QA Test Director, JD
Edwards and MS Project.
Environments: Windows, UNIX, Linux (RHEL)
1 PROJECT EXPERIENCE:
Employer: DatafactZ
Client: YUM Brands, Louisville, KY
Microstrategy Solutions Architect/Designer
June'09 - Present
Responsibilities:
. Responsible for doing the POC for MicroStrategy against IBM Cognos.
. Designed the LMS Reporting project based on the requirements gathered
from the Business users to show the MicroStrategy functionality.
. Designing schema, reports, dashboards layout based on the
requirements.
. Data modeling and Data loading from the Source OLTP system. (SABA)
. Helping with the Administration and Scheduling issues.
. Designing Freeform SQL Reports and security layer.
Environment: Microstrategy 8.1.0 (Administrator, Architect, Desktop,
Narrowcast Server, Object Manager, Command Manager, SDK), DataStage,
Netezza, SQL Server, Teradata, UNIX
Employer: DatafactZ
Client: McDonalds Corporation, Oakbrook, IL
Microstrategy Architect/Designer/QA lead
February'09 - June' 09
Responsibilities:
. Heavily engaged in requirements gathering with the Business users and
create MicroStrategy Design specifications.
. Working with the Data modelers in designing the LDM and the PDM in
accordance with the reporting needs and the Source system structure
. Studied the business rules and understood the clients reporting
requirements by interacting with the Business managers and users.
. Designing report layout based on the requirements.
. Gap analysis for the project which involved transition from BO reports
to MicroStrategy Reports.
. Assisting with MSTR reviews, sign-off and communication of all changes
or modifications to specification documents
. Conducted data validation testing to ensure data quality
. Unit testing of MSTR reports and troubleshooting the production
issues.
. MSTR QA lead handling onsite-offshore Co-ordination
. Identified the areas for scope of improvement and worked with the
respective teams on Guidelines/Enterprise Standards and Best
Practices.
Environment: Microstrategy 8.1.2 (Administrator, Architect, Desktop,
Narrowcast Server, Object Manager, Command Manager, SDK), DataStage,
Teradata v12, UNIX
Employer: DatafactZ
Client: Con-way Freight, Ann Arbor, MI
MicroStrategy Narrowcast/Administrator/Architect August'07 -
January'09
Responsibilities:
. Heavily engaged in requirements gathering for the Business users.
. Created the Report Specification document and had it signed of after
suggesting some useful alterations.
. Defined recommended architecture including performing hardware
capacity planning
. Involved in and provided solutions for complex Time Dimension related
issues and analysis.
. Created Complex Metrics forcing Dimensionality and Conditionality
embedded with prompts.
. Created Complex reports for Analysis with Transformations, Custom
Groups and Complex Filters using Pass through Expressions.
. Tested all the reports by running queries against the warehouse-using
TOAD. Also compared those queries with the MicroStrategy SQL engine
generated queries.
. Reduced the time taken for the reports to run by taking advantages of
VLDB properties like star join, query and sub query optimizations for
oracle 9i and SQL hints.
. Played a key role in User Acceptance Testing of the reports.
. Devised and implemented performance improvement techniques at all
levels (VLDB, DB, server/project configuration, etc).
. Installed and used Scan MD and MD Doctor to diagnose and solve
metadata corruption issues
. Set up and monitored clusters of I-server, W-Server and NC Servers
. Worked on the upgrade of the MicroStrategy projects from 8.0.2 to
8.1.1
. Implemented Event Based Scheduling Services in I-server and NC Server
. Used Object Manager to migrate objects from DEV to QA and to
Production
. Collaborated with the DBA on issues of database performance and
security
. Designed Command Manager scripts for server administration, cache
management, etc
. Installed and Created various statistic reports from Enterprise
manager to depict the usage and performance of reports, User activity
and Cache analysis
. Used Report cache sharing and Data mart reports to enhance the Report
response time.
. Worked with the ETL group to optimize the Performance of Reports.
. Provided Production support for the Project and worked on the
Enhancements.
. Worked on POC for Databases (Netezza vs Oracle 11i)
. Worked with Netezza DBA on user timeout/security/tuning.
. Worked on MicroStrategy 9 (Orion) beta Testing.
Environment: MicroStrategy 8.0.2/8.1.1 (Administrator, Architect, Desktop,
Narrowcast Server, Object Manager, Command Manager, EM), Oracle 10g, Oracle
Warehouse Builder, Informatica 7.1.2, Netezza, UNIX
Employer: DatafactZ
Client: Ryder System, Inc., Miami, FL
MicroStrategy Architect/Developer/Support May'07
- August'07
Responsibilities:
. Participated in the user meetings to obtain the business requirements
for creating reports.
. Heavily engaged in requirements gathering for the Business users.
. Extensively worked on Dimensional Data modeling for the reporting data
marts and resolved outstanding data modeling challenges.
. Heavily worked on Dashboards requirements and have build performance
summary level dashboards involving multiple data sets.
. Involved in Testing and Data Validation of Reports.
. Designed and Developed Attributes, Facts, and Hierarchies.
. Designed and Developed Metrics, Filters, Dynamic Dates, and Prompts.
. Worked with the ETL group to optimize the Performance of Reports.
. Developed Dashboards to fulfill the Business needs.
. Provided Production support for the Project and worked on the
Enhancements.
. Worked with Netezza team to help optimize report execution time.
. Worked on the migration of the MicroStrategy suite 8.02 to 8.1
. Tested the 8.0.2 Reports for MicroStrategy 8.1.
. Testing 8.1 Dashboards against Test Data.
Environment: MicroStrategy 8.0.2/8.1 (Administrator, Architect, Desktop,
Narrowcast Server, Object Manager, Command Manager, SDK), Informatica
7.1.2, Netezza.
Employer: DatafactZ
Client: Bank of America, Charlotte, NC
May'06 - May'07
Business Analyst/MicroStrategy SDK/Administrator/Architect/Narrowcast
Responsibilities:
. Involved in collecting the business requirements from users by
understanding the Source System (OLTP) and interacting with the users.
. Planning, requirements analysis, design and development of new
MicroStrategy projects or enhancements of existing projects.
. Supported and maintained the entire MicroStrategy Application. (Only
resource for MSTR)
. Installed and configured MicroStrategy in both QA and Production
environments.
. Remodeling, redesign and cleaning of existing MicroStrategy projects
. End user training and knowledge transfer, off-shore projects co-
ordination
. Extensively worked on the MicroStrategy SDK for Web Customization.
. Conducted complete web interface re-design and implementation using
MicroStrategy Web API and Java.
. Worked on Single Sign On to allow seamless login to MicroStrategy Web
Application and also customized MicroStrategy web application.
. Heavily worked with end users to support ongoing requests and
Production support.
. Planned and upgraded the MSTR versions from 8.01 to 8.02
. Worked on MSTR Project design like building Attribute, Facts &
Hierarchies.
. Created reusable Transformation objects that enabled time-series
analysis for comparative analysis.
. Working on complete report development aspects like building Filters,
Metrics, Reports, Custom Groups, Consolidation etc.
. Administered and managed the I server to setup the users, security
roles, managing the caches etc
. Used MicroStrategy Object Manager to deploy the MicroStrategy Objects
from the Development Environment to the Test Environment and then to
the Production environment.
. Used Scan MD and MD Doctor for metadata scans.
Environment: MicroStrategy 8.0.2/8.0 (Administrator, Architect, Desktop,
Narrowcast Server, Object Manager, Command Manager, SDK), Informatica
7.1.2, Oracle 9i, Toad, Java, Linux (RHEL).
Employer: DatafactZ
Client: Pharmacare, Pittsburgh, PA
Dec'05 - May'06
MicroStrategy Architect/Developer/Business Analyst
Responsibilities:
. Involved in the complete Life cycle of the Project.
. Involved in collecting the business requirements and documenting the
specifications.
. Played an important role in coordination with the entire team and
managing the time estimates for the entire project.
. Identified the Source tables and columns required to create the
MicroStrategy Project, thereby achieving a logical mapping of the
physical data warehouse in the MicroStrategy Metadata Repository.
. Designed MicroStrategy Schema objects and Application objects using
MicroStrategy Desktop and maintained data dictionary for the project.
. Created complex filters with advanced qualification involving
'ApplySimple' and 'ApplyComparison' functions.
. Worked extensively in creating complex reports using simple metrics,
compound metrics, relationship filters.
. Created several base formulas (mathematical expressions) using
existing facts in MicroStrategy Agent that can be re-used to build any
number of metrics.
. Extensively used MicroStrategy Report Services to generate Report
Documents.
. Created advanced grid reports, consisting of data analysis by
combining a template with filters. The end-users were able to generate
ad-hoc report by drilling up, down, within and across dimension or
anywhere.
. Worked as a support resource for other related projects and was
responsible for re-architecting required changes and checking the
report results in QA.
. Tested all the reports by running queries against the warehouse using
SQL Navigator. Also compared those queries with the MicroStrategy SQL
engine generated queries.
. Responsible documentation and configuration of Enterprise Manager for
logging statistics and reporting purposes.
. Reduced the time taken for the reports to run by taking advantages of
VLDB properties like star join, query and sub query optimizations for
oracle 9i and SQL hints.
. Used Report cache sharing and Data mart reports to enhance the Report
response time.
. Worked along with MicroStrategy Support to troubleshoot some Report
related issues.
Environment: MicroStrategy 8.0/7.5.2/7.2.3/7.x (Administrator, Architect,
Desktop, Narrowcast Server, Object Manager, Enterprise Manager, MDX
Adapter), SQL Server, Oracle 9i, HTML & DHTML.
Education: Master's in Computer Science and Engineering, Bachelors in
Computer Science and Engineering.
5
Contact this candidate