OVERVIEW:

Over 13 years of experience in Development, Testing, Implementation and maintenance of Data Warehouse environments using different OLAP tools. Excellent understanding of architecture, scope and functionality with a hands - on experience in all areas of BI environment. Have good experience on MicroStrategy, Tableau, SAP Business Objects, Jaspersoft, BIRST. Knowledge on Hadoop, Data Science and R Programming.

EXPERIENCE SUMMARY:

• Excellent experience working on MicroStrategy 9.x/10.x, Tableau, Jaspersoft, BIRST, SAP BO.
• Demonstrated project winning capabilities in terms of constructing different types of Reports/Dashboards using latest widgets and visualizations.
• Business Analyst and Data Analyst to support Business Intelligence implementations from project initiation, requirements gathering, architecture support, project planning.
• Experience in preparing BRD- Business Requirements Document by conducting requirement gathering workshops
• Source systems identification, creation of mapping documents by data analysis on source systems to support Data Architect.
• Expertise in conducting Gap Analysis, analyzing existing data, Support Architecture and Development teams to provide clarifications and provide answers.
• Expertise in Data Modeling, Star/Snow flake Schema modeling, Fact and Dimension Modeling.
• Strong experience in designing, development and deployment of semantic layers.
• Strong working knowledge in Development Life Cycle of DWH with Data Analysis skill.
• Successfully worked in all phases of MicroStrategy Upgrade and Installation on both Windows and UNIX platforms.
• Worked extensively on various MicroStrategy versions and components like Desktop/Developer, MSTR Web, MSTR Architect, MSTR Object Manager, MSTR Integrity Manager, MSTR Command Manager etc.,
• Worked on full life cycle of BI projects with different ETL tools like Pentaho/ODI/DataStage/Informatica and reporting tools like MicroStrategy/SAP Business Objects/Jasper soft/BIRST/Tableau etc.. based on the client requirements.
• Adept in Performance Tuning of MicroStrategy reports using VLDB properties at different levels.
• Extensively worked on Analysis, Design, Configuration, Data Migration and Production Support areas.
• Skilled in developing Tableau visualizations and dashboards using Tableau Desktop and handled Tableau Administration side.
• Worked on Effort estimation sheet for MicroStrategy/BO/Tableau projects and created a template for estimation for semantic layer /Reports creation.
• Participated in all phases of Software Development Life Cycle SDLC (Requirement Analysis, Design, Development, Testing and Documentation).
• Good exposure on domain Knowledge in Financial Management, HRM, Retail, Oil and Gas and PB Processes.
• Worked on Oracle and have good knowledge in concepts/Coding in Databases.
• Through understanding in Big Data tools like Hadoop, Hive, Pig, MongoDB and Data Science tools R and Python.
• Solid business communication and presentation skills, adept at creating & coordinating extensive communication networks (technical, business reviews) sessions.

TECHNICAL SKILLS:

MicroStrategy: Desktop/Developer, Dashboards, Documents, Web, Object Manager, Integrity Manager, Command Manager, Free Form Reports, Visual Insight

Business Objects: SAP Business Objects XI R2/3.1/4.1, Web Intelligence, Universe Designer InfoView, CMC, Promotion Management tool/Import wizard, Report Conversion Tool, Xcelsius 2008

Other BI Tools: Tableau, Pentaho, Jasper soft, BIRST

ETL: Pentaho, Pervasive Data Integrator, Informatica Power Center

Databases: SAP HANA, Oracle, SQL Server, DB2, Teradata

Languages: SQL, R

Data Modeling: ERWin

Operating System: Windows Server 2008, Unix, Linux

Products: Advantage 3.8/3.9/3.10/3.11, Info Advantage, FAS, LAND

SQL Tools: TOAD, SQL Developer

Big Data Technologies: Hadoop, Hive, Pig, HBase, MongoDB, Cassandra

Data Science Tools: R, Python

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst

Responsibilities:

• Experience in preparing BRD- Business Requirements Document by conducting requirement gathering workshops
• Source systems identification, creation of mapping documents by data analysis on source systems to support Data Architect.
• Expertise in conducting Gap Analysis, analyzing existing data, Support Architecture and Development teams to provide clarifications and provide answers.
• Expertise in Data Modeling, Star/Snow flake Schema modeling, Fact and Dimension Modeling.
• Strong experience in designing, development and deployment of semantic layers.
• Strong working knowledge in Development Life Cycle of DWH with Data Analysis skill.
• Successfully worked in all phases of MicroStrategy Upgrade and Installation on both Windows and UNIX platforms.
• Worked extensively on various MicroStrategy versions and components like Desktop/Developer, MSTR Web, MSTR Architect, MSTR Object Manager, MSTR Integrity Manager, MSTR Command Manager etc.,
• Worked on full life cycle of BI projects with different ETL tools like Pentaho/ODI/DataStage/Informatica and reporting tools like MicroStrategy/SAP Business Objects/Jasper soft/BIRST/Tableau etc.. based on the client requirements.
• Adept in Performance Tuning of MicroStrategy reports using VLDB properties at different levels.
• Extensively worked on Analysis, Design, Configuration, Data Migration and Production Support areas.
• Skilled in developing Tableau visualizations and dashboards using Tableau Desktop and handled Tableau Administration side.
• Worked on Effort estimation sheet for MicroStrategy/BO/Tableau projects and created a template for estimation for semantic layer /Reports creation.
• Participated in all phases of Software Development Life Cycle SDLC (Requirement Analysis, Design, Development, Testing and Documentation).
• Good exposure on domain Knowledge in Financial Management, HRM, Retail, Oil and Gas and PB Processes.
• Worked on Oracle and have good knowledge in concepts/Coding in Databases.