Developer Data
Resume:
LAXMAN
ac5jsb@r.postjobfree.com
Professional Summery
MicroStrategy Certified Project Designer (CPD).
MicroStrategy Certified Report Developer (CRD).
Around 8 years of professional IT experience Business Intelligence Tool with MicroStrategy.
Experience in designing and generation of business reports using OLAP reporting tool MicroStrategy.
Expertise in creating and integrating MicroStrategy reports with objects (Attributes Metrics, Hierarchies, Filters and Prompts).
Experience in creating complex reports in MicroStrategy Desktop using features like Templates, Transformations, Custom Groups and Consolidations.
Experience in creating Intelligent Cubes, Documents, interactive Dashboards and Scorecards.
Experience in using MicroStrategy Architect for creating Project, Attributes, Facts, Hierarchies and Transformations.
Experience in migrating projects using MicroStrategy Object Manager and Project Merge.
Experience in administrative tasks like User Creation, Scheduling the reports and report service documents.
Experience in using MicroStrategy Desktop, MicroStrategy Intelligence Server and MicroStrategy Web.
Having experience in creating and Performing Unit Test Cases
Good knowledge in ETL using Informatica 8.6
Having excellent SQL skills and good knowledge in data warehouse concepts.
Excellent communication skills with ability to work independently as well as collaboratively in team environment to contribute problem-solving strategies. At ease in interacting with people at all levels, able to work under pressure.
Excellent team player with good analytical, communication and interpersonal skills
Professional Experience
•Working as a MicroStrategy Report Developer with Wipro Technologies, from July 2010.
Education:
•M.S (IT) from UNIVERSITY OF WOLVERHAMPTON, UNITED KINGDOM, 2010.
IT skills:
Business intelligence : MicroStrategy 10.4/ 9.4/9.2/8.0, SAP BO XI 3.1/4, SSRS, Tableau 9.0
Databases : Oracle 12/11, TERADATA, SQL Server 2012/2008, Netezza
Languages : SQL, C
ETL tool : Knowledge on Informatica 8.6, SSIS
Operating Systems : Windows 2000/XP/Vista/7
PROJECT 1
Wipro Technologies, Tampa, FL Aug 2017 – Till Date
Client : CITI Bank
Role : MicroStrategy Report/Dashboard Developer, Architect
Environment : MicroStrategy Desktop 10.4, Intelligence Server, Web, SQL server
Description :
Citi is an American multinational banking and financial services corporation headquartered in Manhattan, New York City. Citibank was founded in 1812 as the City Bank of New York, later First National City Bank of New York. As of March 2010 Citigroup is the largest bank holding company in the United States by total assets. Citigroup had the world's largest financial services network, spanning 140 countries with approximately 16,000 offices worldwide and holds over 200 million customer accounts in more than 140 countries.
Responsibilities:
•Communicating directly with Clients and Gathering user requirements.
•Created Schema Objects like Attributes, Facts, and Hierarchies using MicroStrategy Architect.
•Identified and Created Public Objects like Metrics, Compound Metrics, Prompts, Filters using MicroStrategy Desktop.
•Creating Reports using Consolidations, Custom Groups and Drill maps.
•Creating Complex grid reports with OLAP and drill capabilities.
•Performed the report data manipulations using various options like: Data Pivoting, Page by, Sorting, Totals, and Thresholds etc.
•Created Customized Auto Styles to allow reports in MicroStrategy Desktop and MicroStrategy Web to apply customized formats
•Creating Reports using Intelligent Cubes.
•Designed various Grid and Graph reports and Dashboards based on customer requirements.
•Optimized reports for better performance using VLDB properties.
PROJECT 2
Wipro Technologies, Hyderabad, India Nov 2016 – July 2017
Client : PETSMART
Role : MicroStrategy Report/Dashboard Developer, Architect
Environment : MicroStrategy Desktop 10.4, Web, Netezza.
Description :
PetSmart is an American retail chain operating in the United States, Canada, and Puerto Rico engaged in the sale of specialty pet supplies and services such as grooming and dog training, cat and dog boarding facilities, and day-care. PetSmart also offers a varied selection of animals for sale and adoption such as birds, fish, amphibians, reptiles, and several breeds of small animals like guinea pigs, chinchillas, gerbils, hamsters, and mice. PetSmart has a yearly re-organization of the product hierarchy to better respond with the market changes. This re-organization involves changes to the product hierarchy and a re-organization of SKU's under the new structure.
Responsibilities:
•Communicating directly with Clients and Gathering user requirements.
•Creating Functional and Technical Design Documents as an input to application design business solution components.
•Creating Report mockups and templates from business requirements.
•Creating Projects, Configuring Database Instances and Importing tables using Warehouse Catalog.
•Configuring Projects with Multi-Source Database Instances as data coming from multiple servers.
•Creating MicroStrategy Schema and Application objects such as Attributes, Facts, Transformations, Metrics, Prompts, Filters, Drill Maps, Consolidations and Custom groups.
•Creating complex MicroStrategy reports using Advanced Filters, Level Metrics, and Transformation Metrics and using Pass-Through Functions in the schema objects.
•Designing various Report Services, Dynamic Dashboards based on Customer Requirements
•Creating Reports using Intelligent Cubes.
• Creating Complex grid reports with OLAP and drill capabilities.
•Performing the report data manipulations using various options like: Data Pivoting, Page by, Sorting, Totals, and Thresholds etc.
•Created Customized Auto Styles to allow reports in MicroStrategy Desktop and MicroStrategy Web to apply customized formats.
•Troubleshooting and tune MicroStrategy reports to determine and fix data issues, incorrect joins and performance issues.
PROJECT 3
Wipro Technologies, Banglore, India Dec 2015 – Oct 2016
Client : MASHREQ BANK
Role : MicroStrategy Report/Dashboard Developer, Architect
Environment : MicroStrategy Desktop 9.4.1, Web, SQL Server 2012.
Description :
Mashreq Bank is one of UAE's leading financial institutions with a growing retail presence in the region including Egypt, Qatar, Kuwait and Bahrain. It focuses on providing its customers access to a wide range of innovative products and services. It has provided banking and financial services to millions of customers and businesses since 1967. Mashreq is invariably among the highest performing banks in the Region. Its financial performance reflects on its commitment to continue leading the UAE banking industry. Its branch network extends across the UAE with one in every two households in the UAE banking with Mashreq. It also has customer service centers in key retail locations and one of the largest ATM networks in the country. It also have 12 overseas offices in nine countries, including Europe, US, Asia and Africa.
Responsibilities:
•Communicating directly with Clients and Gathering user requirements.
•Creating Functional and Technical Design Documents as an input to application design business solution components.
•Creating Report mockups and templates from business requirements.
•Creating Projects, Configuring Database Instances and Importing tables using Warehouse Catalog.
•Configuring Projects with Multi-Source Database Instances as data coming from multiple servers.
•Creating MicroStrategy Schema and Application objects such as Attributes, Facts, Transformations, Metrics, Prompts, Filters, Drill Maps, Consolidations and Custom groups.
•Creating complex MicroStrategy reports using Advanced Filters, Level Metrics, and Transformation Metrics and using Pass-Through Functions in the schema objects.
•Designing various Report Services, Dynamic Dashboards based on Customer Requirements
•Creating Reports using Intelligent Cubes.
• Creating Complex grid reports with OLAP and drill capabilities.
•Performing the report data manipulations using various options like: Data Pivoting, Page by, Sorting, Totals, and Thresholds etc.
•Created Customized Auto Styles to allow reports in MicroStrategy Desktop and MicroStrategy Web to apply customized formats.
•Troubleshooting and tune MicroStrategy reports to determine and fix data issues, incorrect joins and performance issues.
PROJECT 4
Wipro Technologies, Hyderabad, India May 2015 – Nov 2015
Client : CALIFORNIA REPUBLIC BANK (CRB) AUTO
Role : MicroStrategy Report Developer
Environment : MicroStrategy Desktop 9.4.1, Intelligence Server, Web, SQL Server 2012.
Description :
California Republic Bank (CRB Auto) goal of establishing itself as a leader in auto financing and having path breaking growth in last 3 years since its inception is highly commendable. As CRB Auto grows its footprint in this domain, building the foundation aspects of a strong and robust business intelligence platform supported by an accurate and timely decision support system (EDW) will be a critical initiative and a step in right direction. CRB – Auto is building an EDW using SSIS ETL tool to enable enhanced reporting to their end users using MicroStrategy. All organizations in today global footprint need to make proactive decision based on facts, an Enterprise Data Warehouse accompanied by BI reporting will help CRB Auto in the competitive market.
Responsibilities:
•Going through Functional Requirement Documents and Understanding the User Requirements.
•Created Schema Objects like Attributes, Facts, and Hierarchies using MicroStrategy Architect.
•Identified and Created Public Objects like Metrics, Compound Metrics, Prompts, Filters using MicroStrategy Desktop.
•Creating Reports using Consolidations, Custom Groups and Drill maps.
•Creating Complex grid reports with OLAP and drill capabilities.
•Performed the report data manipulations using various options like: Data Pivoting, Page by, Sorting, Totals, and Thresholds etc.
•Created Customized Auto Styles to allow reports in MicroStrategy Desktop and MicroStrategy Web to apply customized formats
•Creating Reports using Intelligent Cubes.
•Designed various Reports and Dashboards based on customer requirements.
•Optimized reports for better performance using VLDB properties.
•Created and Performed Unit Test Cases.
PROJECT 5
Wipro Technologies, Hyderabad, India Apr 2014 – Apr 2015
Client : CITI Bank
Role : MicroStrategy Report Developer
Environment : MicroStrategy Desktop 9.4.1, Intelligence Server, Web, Oracle 10g
Description :
Citi is an American multinational banking and financial services corporation headquartered in Manhattan, New York City. Citibank was founded in 1812 as the City Bank of New York, later First National City Bank of New York. As of March 2010 Citigroup is the largest bank holding company in the United States by total assets. Citigroup had the world's largest financial services network, spanning 140 countries with approximately 16,000 offices worldwide and holds over 200 million customer accounts in more than 140 countries.
Compliance Architecture & Strategy (A&S) generates a large number of metrics and reports on a weekly basis. The metrics and reports are distributed globally to all countries and regions where Citi has a presence.
A&S requires an enterprise class internet based solution for the construction and distribution of metrics and reports. Citi has selected MicroStrategy as the enterprise tool for data visualization. A&S will therefore move all metric and report data visualization to MicroStrategy.
Responsibilities:
•Going through Functional Requirement Documents and Understanding the User Requirements.
•Created Schema Objects like Attributes, Facts, and Hierarchies using MicroStrategy Architect.
•Identified and Created Public Objects like Metrics, Compound Metrics, Prompts, Filters using MicroStrategy Desktop.
•Creating Reports using Consolidations, Custom Groups and Drill maps.
•Creating Complex grid reports with OLAP and drill capabilities.
•Performed the report data manipulations using various options like: Data Pivoting, Page by, Sorting, Totals, and Thresholds etc.
•Created Customized Auto Styles to allow reports in MicroStrategy Desktop and MicroStrategy Web to apply customized formats
•Creating Reports using Intelligent Cubes.
•Designed various Grid and Graph reports and Dashboards based on customer requirements.
•Optimized reports for better performance using VLDB properties.
•Created and Performed Unit Test Cases.
PROJECT 6
Wipro Technologies, Hyderabad, India Jul 2012 – Mar 2014
Client : National Grid
Role : MicroStrategy Report Developer
Environment : MicroStrategy Desktop 8.x, Intelligence Server, Web, Oracle 9i
Description :
National Grid is more than an international electricity and gas company. It is one of the largest investor-owned energy companies in the world and it plays a vital role in delivering energy to millions of people across Great Britain and the north-eastern US. National grid has around 15 million customers in US and United Kingdom. National grid has its own high voltage electricity transmission system and high pressure gas transmission system. It is an innovative leader in energy management, championing secure, sustainable energy, to safeguard its global environment for future generations.
MicroStrategy software is the heart of Business intelligence at National Grid, which is used to track financial, connections and customer usage in order to take decisions which improve business performance and strengthen customer relationships.
Responsibilities:
•Going through Report Specification Documents and Understanding the User Requirements.
•Identified and Created Public Objects like Metrics, Compound Metrics, Prompts, Filters using MicroStrategy Desktop.
•Creating Reports using Consolidations, Custom Groups and Drill maps.
•Creating Complex grid reports with OLAP and drill capabilities.
•Performed the report data manipulations using various options like: Data Pivoting, Page by, Sorting, Totals, and Thresholds etc.
•Created Transformations for comparative reports like sales this year to date, Month to date, Quarter to date etc.
•Created Customized Auto Styles to allow reports in MicroStrategy Desktop and MicroStrategy Web to apply customized formats
•Creating Reports using Intelligent Cubes.
•Designed various Grid and Graph reports and Documents based on customer requirements.
•Created and modified schema objects (facts, attributes and hierarchies) using MicroStrategy Architect.
•Optimized reports for better performance using VLDB properties.
•Created and Performed Unit Test Cases.
PROJECT 6
Wipro Technologies, Hyderabad, India Jul 2010 – Jun 2012
Client : Williams Sonoma Inc
Role : MicroStrategy Report Developer
Environment : MicroStrategy Desktop 9.02, Intelligence Server, Oracle 10g.
Description :
William Sonoma Inc. is transforming its business through a series of customer-centric initiatives and aligned technology solutions. To enable this transformation, WSI has embarked on a major corporate master data management (MDM) project to implement a robust, globally scalable MDM platform. The Customer Data Management (CDM) initiative will focus on establishing the MDM foundation targeted to actively support WSI Business Applications, Data Warehouse, Reporting and establishing corporate level Data Governance policies and procedures for master data.
Responsibilities
•Going through Report Specification Documents and Understanding the User Requirements.
•Identified and Created Application objects like Metrics, Compound Metrics, Prompts, Filters using MicroStrategy Desktop.
•Creating Reports using Consolidations, Custom groups and Drill maps.
•Performed the report data manipulations using various options like: Data pivoting, Page by, sorting, totals, thresholds etc.
•Created Transformations for comparative reports like sales this year to date, Month to date, Quarter to date etc.
•Created Customized Auto Styles to allow reports in MicroStrategy Desktop and MicroStrategy Web to apply customized formats
•Creating Reports using Intelligent Cubes.
•Designed various Grid and graph reports and Documents based on customer requirements.
•Created and modified schema objects (facts, attributes and hierarchies) using MicroStrategy Architect
•Optimized reports for better performance using VLDB properties.
Contact this candidate