Manager Project
Resume:
Jagadish Kalaga
Data Warehouse Consultant
********@*****.***
SUMMARY:
. 10 years of IT experience in designing, modeling and developing
Enterprise Data Warehouse and Business Intelligence applications
. 9 years of experience in MicroStrategy product suites namely Desktop,
Web, Office, Report Services, Developer, Architect, Administrator,
OLAP Services, Intelligence Server, Web Server, Narrowcast Server,
Object Manager, Command Manager, Enterprise Manager, Integrity
Manager, Mobile, SDK
. 3 years experience in Extraction, Transformation and Loading (ETL)
process and usage of Teradata ETL tools. Experience in working on
Teradata, Oracle, SQL Server, MS-Access databases
. Extensive experience in dimensional modeling, star schema modeling,
snow-flake schema modeling, OLAP concepts, developing conceptual,
logical and physical Data Models using designing tools. Involved in
building enterprise wide data warehouse using Multi Dimensional Model
. Extensive experience working with end users, business analysts in
understanding the requirements, providing and implementing technical
solutions
. Involved in estimating, design, architecting, administration,
upgrading, troubleshooting and supporting MicroStrategy Projects
. Experienced in business intelligence, enterprise data warehouse life
cycle, software development life cycle, project management,
documentation
SKILLS:
MicroStrategy MicroStrategy 9.0/8.1.x/8.0.x/7i, Desktop,
Suite Architect, Agent, Web, Intelligence Server,
Narrowcast Server, MDX Adapter, Administrator,
OLAP services, SDK, Report Services, BI Developer
Kit
ETL Tools Teradata ETL Tools (Fastload, Multiload, TPUMP,
BTEQ, Warehouse Builder Operators), Informatica
Data Modeling Sybase PowerBuilder, ERwin 7.2, MS Visio 2007
Database Systems Teradata V2R6, Teradata V2R5, Oracle 10g/9.x, MS
SQL Server
Languages C, C++, Java (J2EE, EJB, Servlet, JSP, JDBC, Java
Beans), XML, SQL (PL/SQL, Transact SQL, SQL
*Plus)
Operating Systems Windows 9x/NT/2000/XP, Unix, Linux
Application IIS, BEA Web Logic, Tomcat
Servers
Reporting Tools MicroStrategy, Business Objects, OBIEE, Crystal
Reports
Proficiencies Enterprise Data warehouse, Business Intelligence,
Data Modeling, Decision Support Systems, OLAP
Certifications Teradata Certified Implementation Specialist V2R5
EXPERIENCE:
Harvard Pilgrim Health Care, Boston, MA Oct 2009 - Present
Sr. MicroStrategy Architect
Harvard Pilgrim is a full-service health benefits company serving members
throughout Massachusetts, New Hampshire, Maine and beyond. For more than 35
years, Harvard Pilgrim has built a reputation for exceptional clinical
quality, preventive care, disease management and member satisfaction and
has consistently rated number one for five years in a row among the health
plans in the country.
Responsibilities:
. Worked in Agile project methodology on developing Enterprise Data
Warehouse containing data about members, providers, customers,
brokers, claims, services, invoices
. Created and developed Employer Analytics, Finance Reporting, Provider
Analytics projects in MicroStrategy
. Set up configuration management procedures for migration of objects
from development through UAT and production
. Imported views from teradata database, created attributes and parent-
child relationships through MicroStrategy Architect
. Developed required schema objects, application objects to support
reports
. Designed dynamic dashboards and report services documents as per the
due diligence documents
. Created packages to promote the required objects from development to
UAT through MicroStrategy Object Manager
. Moved the tested objects to production environment
. Used integrity manager to create a baseline and compare it with the
future versions of metadata as a process of migration
. Integrated MicroStrategy web to HPHC intranet using web SDK
Environment:
MicroStrategy 9.0.0, Desktop, Web, Intelligence Server, Web Server,
Narrowcast Server, Object Manager, Command Manager, Enterprise Manager,
Integrity Manager, Teradata V2R6, Teradata SQL Assistant 12.0, Oracle 10g,
Rally, Windows Server 2003, Linux
NV Energy, Reno, NV Nov 2007 - Sep
2009
MicroStrategy Lead
NV Energy has served customers in northern Nevada and northeastern
California for over 150 years and southern Nevada since 1906. Nevada Power,
Sierra Pacific Power and Sierra Pacific Resources merged in July 1999 to
create one of the fastest growing energy companies. NV Energy provides
electricity to nearly 2.4 million customers throughout Nevada and in
northeastern California.
Responsibilities:
. Worked on implementation project by estimating, architecting,
developing and supporting 5 terabyte Enterprise Data Warehouse
containing data about Energy Efficiency - Demand Response, Energy
Supply - Resource Procurement, Supply Chain Management, Financial
Planning & Analysis, Customer Service Channel Performance, Call Center
Predictive Model, Call Volume Analysis
. Involved in writing Business Requirement Document and designing
Conceptual, Logical and Physical data models for all subject areas
. Analyzed the source system tables and created source to target mapping
documents
. Estimated the timeline for developing and testing different subject
areas in MicroStrategy
. Setup Development, UAT and Production environments by installing and
configuring MicroStrategy 8.1.2 software on the servers and citrix
environment
. Wrote Technical Specification Document mapping columns in the
warehouse to attributes, facts and metrics
. Architected Master project in MicroStrategy that holds schema objects
like logical tables, attributes, hierarchies and transformations for
all the subjects areas
. Built metadata layer, implemented security in it and defined parent-
child relationships between attributes
. Created subject area specific projects containing facts and related
public objects
. Created dynamic dashboards involving multiple graphs, panel stacks and
selectors
. Deployed widgets from MicroStrategy Widget Library to MicroStrategy
Web and developed Microchart widgets containing sparkline, bullet, bar
charts
. Migrated projects from development server to UAT server for user
testing. Resolved report and data issues and moved the projects to
production server using MicroStrategy object manager
. Conducted user training sessions to demonstrate the features of the
dashboards and reports and resolve user queries about the data flow
from source systems to reports
. Analyzed the MicroStrategy system usage by configuring Enterprise
Manager
. Setup services in Narrowcast server to email reports, alerts that
sends the status of Intelligence Server
. Created a security model with security roles, user groups and security
filters enabling LDAP single sign-on access
. Upgraded the MicroStrategy Environments and project metadata from
8.1.2 to 9.0.0
. Used VLDB properties and stored procedures for tuning the SQL
generated by MicroStrategy
. Worked on MicroStrategy Integrity Manager to create integrity tests to
uncover errors and inconsistencies
. Worked with Change Control Management by creating test script,
migration checklist documents for auditing purposes
. Created standards and procedure documents to pass onto fulltime
employees about the system architecture, object development and naming
standards for the projects moving forward
Environment:
MicroStrategy 9.0.0, Desktop, Web, Administrator, Intelligence Server, Web
Server, Narrowcast Server, Object Manager, Command Manager, Enterprise
Manager, Integrity Manager, Oracle 10g, Informatica 8.1.1, Erwin 7.2, Toad
9.0.1, Windows Server 2003, Citrix Metaframe XP, Unix HP
Retail Ventures Inc, Columbus, OH Mar 2007 - Nov
2007
MicroStrategy Consultant
Retail Ventures, Inc. (RVI) is the parent company of DSW, Value City,
Filene's Basement Department Stores, LLC retail stores. The mission of RVI
is to deliver effective and cost-efficient corporate and support services
for each of the retail brands, while still maintaining their uniqueness.
Responsibilities:
. Involved in the development and production support of DSW, Value City
and Filene's Basement BI and Enterprise Wide Reporting
. Worked on Restructuring, Re-architecting and Redeploying MicroStrategy
projects to align with EDW 2.0
. Involved in business requirements gathering for Supply Chain, Store
Ops, Customer/Marketing, Finance/Sales Audit, Loss Prevention, Human
Resources, Logistics departments
. Used the related subject areas in Teradata Retail Logical Data Model
and developed physical data model
. Moved the MicroStrategy Metadata from small production server to
robust system
. Upgraded the MicroStrategy environment from 8.0.1 to 8.1.1 and
upgraded the projects metadata
. Configured the Enterprise Manager to analyze the user traffic and the
projects/reports that are being used. Worked with users to determine
which projects are required moving forward
. Created a new enterprise MicroStrategy project that consists of the
modeled subject areas
. Developed useful existing reports and created 100 reports with 300 Key
Performance Indicators
. Created Customer behavior dynamic Dashboards and Spending pattern
Scorecards involving graphs and statistical calculations
. Moved the MicroStrategy objects from Development to Test system for
user testing and to Production system
. Created and troubleshooted Narrowcast services for emailing the
reports as attachments to the users/ user groups
. Interacted with DBA team in tuning queries by collecting statistics,
creating indexes
. Followed best practices and created standards document for
MicroStrategy project development
Environment:
MicroStrategy 8.1.1, Desktop, Web, Intelligence Server, Narrowcast Server,
Teradata V2R6, Teradata Administrator 7.1, Teradata SQL Assistant 7.1,
ERwin 7.2, Visio 2003, Windows XP
FedEx Services, Memphis, TN Feb 2005 - Mar
2007
MicroStrategy Lead
FedEx provides access to a growing global marketplace through a network
of supply chain services, transportation services and business and
information services.
Responsibilities:
. Corporate Express Safety
. Involved in designing Human Resources data warehouse for FedEx Express
Corporate Safety. It is responsible for reporting and analysis of
employee training, payroll, injury accidents, retirements, dangerous
goods spills and other details at FedEx Express, Services and
Corporate
. Safety Analysts (Users) maintained two reporting systems - Mainframe
SAS and HTML/web based SAS. They have been replaced by MicroStrategy
to complete the daily, weekly, monthly, quarterly, yearly and fiscal
year analysis for Injury and accident data
. Participated in business requirement gathering meetings and designing
logical and physical data model
. Created Teradata tables and views, created ETL scripts for pulling
data from mainframe systems to Teradata warehouse using Fastload,
MultiLoad and Tpump. The source systems were Payroll, Employee,
Training, Injury, Accident
. Upgraded the MicroStrategy development server from 7.2.3 to 8.0.2.
Pointed existing metadata and upgraded the projects metadata.
Configured LDAP so that users can logon to MSTR using LDAP login and
password
. Architected attributes, parent child relationships, configuration
objects and implemented security through user groups
. Created time, geography and employee hierarchies to link to accidents,
injury, payroll attributes for drilling and browsing.
. Created the YTD, QTD, MTD, Fiscal YTD, Last Year, Last Quarter, Last
Month transformations
. Created security filters for users of different orgcodes using
MicroStrategy command manager
. Created required MicroStrategy objects and reports for FedEx safety
users
. Moved the metadata from Development to Stage using MicroStrategy
object manager for user testing. Resolved issues and moved to
production server
. Created custom reports in MicroStrategy Enterprise Manager, for
efficient tracking of the access of warehouse tables and columns by
users
. Used MicroStrategy Narrowcast server for emailing the reports, bulk
exports, creating excel files by inserting number of grid reports with
data sources
. Maintained MicroStrategy Intelligence Server for performance
monitoring, managing caching expiry times
. Ran ScanMD and MD doctor tools to fix the Metadata inconsistencies
. Worked with Training team from MicroStrategy to train the power users
by identifying the canned production reports which consists of all the
features of prompts, templates and drilling. Created a Web
Professional training manual with project specific content
. FedEx Retirements
. Involved in creating a controlled group database which provides a
central resource of information to monitor retirement benefits of all
employees across operating companies
. Developed a fully automated employee payroll tracking active data
warehouse with input files arriving from operating data sources
. Created teradata tables and views. Wrote multiload scripts to load the
files to the data warehouse from mainframe and imported the teradata
views to MicroStrategy.
. Created schema objects, public objects. Used report services to create
enterprise reports which pull data from different dataset reports
. Implemented drill to template feature
. Developed a corporate dashboard with employee hiring, attrition rates
for different departments and employee dashboard that lists the
employee tenure along with their pension and 401k information
. Did parallel testing of data between mainframe reports and
MicroStrategy reports.
. Reduced retirement plans advisor(s) monthly manual work from 2 weeks
to 4 hours by redesigning, modifying and automating the reports
Environment:
MicroStrategy 8.0.2, Desktop, Web, Intelligence Server, Narrowcast Server,
Teradata V2R5, Teradata Administrator, Teradata SQL Assistant 6.2, Sybase
Power Designer 11.0, Windows XP
Publix Super Markets, Lakeland, FL Sep 2004 -
Jan 2005
Sr. MicroStrategy Architect
Publix Super Markets is the largest and fastest-growing employee-owned
supermarket chain in the United States. Publix and associates excel in
community involvement, volunteerism and a commitment to our market areas
and beyond.
Responsibilities:
. Involved in restructuring the Sales Enterprise Data Warehouse (EDW)
. Created views in Teradata and imported into MicroStrategy using
Warehouse Catalog and architected schema objects
. Created public objects including complex canned and ad-hoc reports
. Moved MicroStrategy projects using Object Manager from Development to
Stage for UAT, resolved the issues and moved Production Environment.
. Developed concise training manuals for MicroStrategy Desktop and Web
users
. Implemented windows authentication login for the users. Identified
Power users and gave MicroStrategy Desktop Agent, Web Professional
privileges
. Developed reports with more functionality in EDW that previous project
. Checked all the reports available in previous project, Scandata were
developed with same or more functionality in EDW
. Created services in Narrowcast Server to deliver reports via email for
event driven reporting
Environment:
MicroStrategy 7.5.2, Desktop, Web, Intelligence Server, Narrowcast Server,
Teradata V2R5, Teradata Administrator, Teradata SQL Assistant 6.2, Windows
XP
Koch Materials Company, Wichita, KS Apr 2004 - Sep
2004
Sr. MicroStrategy Architect
Koch is involved in refining, asphalt, natural gas, gas liquids, chemicals,
plastics, chemical technology equipment, minerals, fertilizers, ranching,
trading and finance businesses, as well as a host of new, technology-
oriented ventures. A Data warehouse was built to track and analyze the
sales.
Responsibilities:
. Upgraded MicroStrategy suite and project metadata from 7.2.2 to 7.5.2.
. Studied the Physical Data Model and created a "Hierarchy Helper Table"
between the fact table and dimension table for displaying different
levels of hierarchies on a report
. Architected schema objects such as facts, attributes, hierarchies,
transformations using MicroStrategy Architect
. Created dynamic, static filters, prompts for different levels of
hierarchy to display the records of lower levels in a hierarchy on a
report
. Developed Month-to-Date, Quarter-to-Date, Year-to-Date, Life-to-Date
transformations and created metrics using them
. Used Report Services and above mentioned metadata objects to create
Managed Metric Reports, Production and Operational Reports, Business
Reports
. Used MicroStrategy Object Manager to migrate MicroStrategy project
from Development to Testing to make it available to QA testing.
Resolved the issues and moved to Production environment
. Reports are being used by 250-340 users consisting of financial
accountants, Koch business executives. Created MicroStrategy
Narrowcast services to distribute reports to users
Environment:
MicroStrategy 7.5.2, Intelligence Server, Narrowcast Server, Desktop, Web,
Report Services, Informatica 7.0, Oracle 9i, SQL Programmer for Windows
32bit, Windows 2000
Discover Financial Services, Riverwoods, IL Mar 2003 -
Apr 2004
MicroStrategy Architect/ Administrator
Discover Financial Services, a business unit of Morgan Stanley, operates
the Discover Card brands. To track the usage of its credit cards at
merchant locations, Discover Financial Services uses MicroStrategy's
technology to run reports against an Oracle database that contains merchant
information. Approximately 600 employees use the MicroStrategy platform to
easily perform intuitive query and web-based reporting.
Responsibilities:
. Interacted with Marketing and Finance department personnel to gather
business requirements
. Participated in data modeling by selecting business processes,
declaring the grain of the data warehouse, choosing the facts and
dimensions
. Created relationships between different dimensions and developed a
logical data model using ERWin tool and physical data model for
Teradata database
. Worked in loading OLTP data into warehouse using Teradata ETL tool
. Worked with Fast load, Multiload, TPUMP, BTEQ to create batch jobs to
load the data into the data warehouse tables
. Architected schema objects such as facts, attributes, hierarchies,
transformations
. Developed basic and user specified metrics (level, conditional,
compound, non-aggregatable),prompts and filters in customer tuned
reports and documents
. Generated customized reports using consolidations, custom groups and
VLDB properties
. Used MicroStrategy Desktop and Web to enable users run predefined
reports
. Implemented data drilling features to view reports of greater detail
. Created Dashboards and board room quality reports using web and report
services
. Used MicroStrategy Object Manager to move projects and objects from
development to Test and Production servers.
. Used MicroStrategy Command Manager to perform bulk administration
activities
. Developed customized reports in MicroStrategy Enterprise Manager to
better track the activities of the users
. Implemented asynchronous reporting, centralized administration,
security features using MicroStrategy Intelligence Server
. Installed and used MicroStrategy Narrowcast server and delivered
reports through email and network files
. Provided Integrated query, reporting and powerful iterative analysis
to end users
Environment:
MicroStrategy 7.5, Intelligence Server, Narrowcast Server, Desktop, Web,
ERwin 4.1, Teradata, Windows 2000
Gateway Computer Systems, Denver, CO Feb 2002 - Mar
2003
MicroStrategy Developer
Gateway has been a technology and direct-marketing pioneer, using its call
centers, web site, direct sales force and retail alliances to build great
customer relationships.
Responsibilities:
. Developed a MicroStrategy Data Warehouse project for analyzing the
sales of computers and other electronic equipment.
. Architected MicroStrategy metadata model from the physical data model
. Involved in architecting the MicroStrategy Projects by identifying the
required attributes, facts and other schema objects
. Worked on developing derived and compound metrics, prompts and filters
for complex reports
. Developed custom groups and consolidations for grouping of desired
elements to be shown in reports
. Created canned and ad-hoc reports using MicroStrategy Desktop and
Report Services
. Created and documented dashboard reports, production and operational
reports, invoices, statements and business reports
. Created proactive reports and delivered to various end users using
Narrowcast Server
. Used Command Manager to create users and group them into user groups
. Configured Enterprise Manager to analyze the bottle necks and
performance issues
. Involved in MicroStrategy Intelligence Server performance monitoring
and managed cache expiry times
Environment:
MicroStrategy 7.2.3, Intelligence Server, Web, Narrowcast Server, Desktop,
Web, Architect, ERwin 4.0, SQL Server 2000, Windows 2000
Citadel, Hyderabad, India May 2000 - Jan
2002
Programmer Analyst
Responsibilities:
. Analyzed the user requirements and project specifications to identify
entities
. Developed ER models and process models and transferred to physical
database
. Involved in database programming with SQL and PL/SQL
. Performed database administrator duties that includes creation of
tables, views, indexes, user roles, regular backups and monitored the
performance
. Involved in developing test cases and oversee the manual testing
Environment:
Erwin 3.0, Crystal Reports 6.0, MS SQL Server, Oracle 7.0, SQL, HTML,
Windows NT 3.5, Sun Ultra 10 servers, Compaq workstations
Education:
Bachelor of Technology in Electrical Engineering, Jawaharlal Nehru
Technological University, India
Contact this candidate