SUMMARY

• Over 8 years of IT experience in application design, development, and implementation.
• Experience in Data warehousing and OLAP tools including MicroStrategy 9i/8i.
• Hands on experience with MicroStrategy Product Suite including MicroStrategy Dynamic Dashboards, Visual Insight, MicroStrategy Intelligence server, MicroStrategy Architect, MicroStrategy Administrator, MicroStrategy Web, and MicroStrategy Narrowcast Server.
• Profound knowledge of data in the field of retail including inventory, sales, distribution, retail ecommerce data.
• Successful at transforming business ideas and processes into complete solutions and configuring applications to fit the company's business model.
• Successful at working in a Team as well as independently, under little or no supervision. Excellent interpersonal, communication and presentation skills.
• Proficient in creating MicroStrategy logical models and Reports by following best Business rules, practices, and design methodology.
• Proficient in MicroStrategy Administration tools Object Manager, Command Manager.
• Experience in creating Dashboards that can provide an insight analysis on the business for senior management.
• Supported the end users on reports where they needed assistance. Performed Knowledge Transfer to the business users, documented the general design of the reports, and trained other team members on MicroStrategy reports, MicroStrategy Metadata
• Experience in Tableau Server, Tableau Desktop with in depth knowledge in report, dashboard development and system administration.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• End to end experience in designing and deploying data visualizations using Tableau
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues withinTableau Server and Reports.
• Fair Knowledge in Installation, Configuration and administration ofTableauServer in a multi - server and multi-tier environment.
• ExtensiveTableauExperience in Enterprise Environment andTableauAdministrator experience including technical support, troubleshooting, report design and monitoring of system usage.
• Extensive experience in Data Analysis, and good understanding on Data Modeling.
• Document project plans, action plans, presentations and project results for clients.
• Created roll forward and roll back packages to deploy Microstrategy objects from one environment to another.
• Experience with different database technologies like oracle, SQL Server and netezza.
• Define & produce client policies, procedures, processes & other documentation as required.
• Created reports using MicroStrategy Office Excel, the End user can use Microsoft excel functionality to manipulate data use pivot tables and other analytical tasks within the workbook.

TECHNICAL SKILLS

Database Technologies: Oracle 10g/9i/8i, MS Access, SQL Server 7.0/2000, DB2, Netezza, Metadata

Languages: SQL, PL/SQL, Teradata SQL, T-SQL

Business Intelligence: MicroStrategy 9.4.0/9.0.2/8.1.2/8.0.2 , Tableau 9.0

Web Servers: IIS, Apache Tomcat

Operating Systems: WINDOWS 2008, Windows Server, UNIX, LINUX

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

MicroStrategy / Tableau Consultant

Responsibilities:

• Created MicroStrategy Dynamic Dashboards to analyze the sales by brand, time and division for GID division of Confidential Inc.
• Created the required MicroStrategy objects and changes to the schema objects as per the report requirements.
• Created mapping documents and unit test scripts to validate the report data before delivering the reports to QA team.
• Involved in code review and QA of MicroStrategy reports developed by other developers.
• Assisted business users in providing and analyzing the data between the corporate data warehouse system with the Venus reporting system.
• Provided business users with required data by writing custom queries to help in decision making.
• Created complex relationship filters to build month end finance reports.
• Involved in production validation and data analysis of the MicroStrategy reports.
• Involved in migration of objects from one environment to the other.
• Improved the report performance by analyzing the SQL and making the required changes to the VLDB settings.
• Developed ETL programs using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Generated data extracts in Tableau by connecting to the view using Tableau provided connectors.
• Configured data extraction by schedule, every business day at 6 am to enhance performance.
• In-depth knowledge on Tableau Desktop, Tableau Server.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters in Tableau.
• Experience includes technical support, troubleshooting, report design and monitoring of system usage.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• End to end experience in designing and deploying data visualizations using Tableau.
• Organized dashboards in Tableau to analyze the sales, returns, exchanges, cancels by brand, division, and department.
• PerformTableauServer admin duties; add users/groups from Active Directory; and schedule instances inTableauServer including weekly data dump.
• Installation and configuration ofTableauserver in development and production environment.
• Implemented sets to display Top N products sold based on business defined conditions.

Environment: MicroStrategy 9.4.0/9.0.1 , MicroStrategy Dynamic Dashboards, Tableau, Oracle 10g, Windows 2003 Server Standard Edition, IIS 6.0, Data stage 7.5, Tableau 8.0

Confidential, Pleasanton, CA

MicroStrategy Consultant

Responsibilities:

• Involved in gathering business requirements, writing technical design documents, report design, creating MicroStrategy reports and the required MicroStrategy objects
• Administered MicroStrategy user creation, project maintenance and cache maintenance.
• Involved in maintenance of the MicroStrategy projects by running SCANMD to clear any inconsistency in the metadata
• Wrote MicroStrategy command manager scripts to create users, user groups, security filters, changes project status during data loads
• Maintained the project across all the three environments, which included duplication of project, using object manager to move objects from one environment to another
• Created narrowcast server services to deliver the weekly server and project usage reports from the enterprise manager
• Created narrowcast server services to deliver custom reports to the end user based on user preferences using narrowcast server question objects.
• Configured narrowcast server File device to deliver MicroStrategy reports to a physical location on a Windows directory.
• Automated all the manual reports generated by business using MicroStrategy report services document.
• Involved in performing stress test on the MicroStrategy application.
• Trained end users to create ad-hoc reports.
• Created custom MicroStrategy report links to be published on the corporate portal.

Environment: MicroStrategy 9.0.1/8.1.2/8.0.2 , UDB DB2 8.1, Windows 2003 Server Standard Edition, IIS 6.0, Data Stage 7.5.2

Confidential

MicroStrategy Consultant

Responsibilities:

• Involved in the complete development life cycle of the Branch Metrics project including report design, creating MicroStrategy objects like Metrics, Filters, prompts and reports.
• Developed report services documents that is Funding Report and Cycle Time Reports.
• Developed reports using MicroStrategy Freeform SQL and Query Builder.
• Maintained the project across all the three environments, which included duplication of project, using object manager to move objects from one environment to another.
• Involved in the development of OLAP reports.
• Involved in maintenance of the MicroStrategy metadata by running SCANMD to clear any inconsistency in the metadata
• 24/7 Production Support.

Environment: MicroStrategy 8.0.2, Netezza 2.5.3, Microsoft SQL Server 2000, Oracle 9i, XMLA, Microsoft Analysis Service 2000, Windows 2003 Server, IIS, Site Minder 6.0

Confidential

MicroStrategy Consultant

Responsibilities:

• Involved in the application development life cycle which include reports, hardware requirements gathering, report design, development, testing, implementation, and maintenance of reports.
• Involved in the complete cycle of requirements gathering, design and development of the MicroStrategy Data marts and writing SQL scripts to extract the data from the data mart tables.
• Frank and timely internal communication within the bank about risk, both across the organization and through reporting to the board and senior management.
• Involved in the architecture changes of the project to meet the user and report requirements by creating additional attributes, facts and hierarchies.
• Involved in the building of MicroStrategy components such as metrics, filters, prompts, custom groups and templates to build the reports.
• Tuned the MicroStrategy Intelligence Server by changing the server parameters to handle huge volume of user requests, caching and history list.
• Involved in user level and project level security settings of the reports for the end users and the testing teams.
• Setting up a file device in the narrowcast server to convert a report documents into PDF format and automatically placing the PDF file in a particular directory.
• Installed and Configured the Enterprise Manager project to collect the statistics of the daily activities of the users and the reports and analyze the performance of the reports.
• Developed custom enterprise manager reports as per the requirements of the user.
• Involved in the maintenance and customization of MicroStrategy Web.

Environment: MicroStrategy 7.2.3/7.5, Oracle 9i, RDW 10.2, RETL, RMS 10.0, Windows NT 2003 Server, Sun Solaris, Decision Master, TOAD 6.3, IIS