SUMMARY

• 11+ years of experience in Data Analytics, SQL, PL/SQL, ETL tool and Reporting tools
• E excellent knowledge of the Microstrategy Suite of tools (Desktop, Mobile configuration,Narrowcast, Object Manager, Command Manager, Hyper Intelligence card, etc ), Tableau and Microsoft Power BI
• Developed dashboards for web and Mobile by using different BI tools
• Involved in the complete lifecycle of the projects
• Strong knowledge of sprint/agile practices
• Involved in the process analysis, design, development and performance optimization of Business Intelligence Reports
• Knowledge o f Data modeling and Object Modeling
• Strong knowledge in Internet based and mobile based reporting
• Strong knowledge in developing operational reporting
• Strong analytical skills and attention to detail
• Excellent team player
• Excellent organizational and time management skills
• Excellent oral and written communication skills
• Quick learner, drive and motivation to gain new skills.
• Having working knowledge in SAS code and SSIS.
• Having experience in cloud based environment

TECHNICAL SKILLS

OLAP Tools: Microstrategy 11.1/10.4/9.4/9.3/9.2.1/9.0.2/9.0.1/ 8.0 .1./8.0. 2/8.1 ( Developer,Desktop, Web, Narrowcast, Object Manager, License Manager), SSIS, Tableau, Microsoft Power BI

Operating Systems: Windows 2003/07, Linux

Programming skills: Java, C, C++

Scripting Languages: JavaScript, VB Script, ASP

Databases: Oracle 10g/9i, Sybase IQ 12.6, SQL server 7.0/200 8/2005 , MS Access 97/00/XP/03, Hadoop

Microsoft Tools: MS excel, MS word, MS Visio, MS PowerPoint

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst

Responsibilities:

• Involved from requirement gathering, design and development of the Dossier, Dashboards, Hyper intelligence card and documents in MicroStrategy.
• Designed and developed HyperIntelligence cards and plugged in with webpage.
• Designed and Created Dossiers to provide more visibility of the data in MicroStrategy.
• Design and developed a document and used MicroStrategy bursting features to deliver the documents.
• Created the schema objects such as tables, attributes, facts, hierarchies, transformation, and so on.
• Created complex metrics for analyzing the data.
• Created templates and wizards for creation of dynamic reports.
• Created client specific reports, Dossier for web on the business requirements.
• Created Free form SQL report to provide the user required documents.
• Suggested to use static and dynamic subscriptions to deliver the reports.
• Followed industry standard best practices.
• Worked closely with ETL developers in data loading and in designing of the staging and reporting tables.
• Implemented performance improvement by changing VLDB settings.
• Involved in MicroStrategy upgradation from 10.11 to 11.1
• Develop mobile dashboards in MicroStrategy suite of tools.

Environment: MicroStrategy 10.4 and 11.1, SQL Server 2008, Amazon redshift

Confidential

MicroStrategy Architect and Developer

Responsibilities:

• Involved in data analyzing of various Risk data and worked closely with ETL team to Load data into SQL Server using SSIS.
• Designed and Created dashboards to provide more visibility of the data in Microstrategy.
• Created all the schema objects such as tables, attributes, facts, hierarchies, transformation, and so on.
• Created complex metrics for analyzing the data.
• Created templates and wizards for creation of dynamic reports.
• Created client specific reports, dashboards for web and mobile based on the business requirements.
• Created to use static and dynamic subscriptions to deliver the reports.
• Automated the report delivery to the management Team.
• Designed the Schema to create ad - hoc Dashboards by the Users
• Created the SSIS Package to Load the data from different excel file to Data base
• Converted the SAS code into SQL procedures to load the data into SQL server.
• Managing the offshore Team.

Environment: MicroStrategy 9.10, SQL Server 2008, SSIS, SAS®9

Confidential

MicroStrategy Architect and Developer

Responsibilities:

• Installed MicroStrategy Intelligent server and Web server on different windows 2008 servers.
• Configured I server, web server and Project with Big data Hadoop using 32 bit Hive ODBC Connect (Cloundera) and Hive 0.11 database component.
• Created configuration objects like DB Instance, users and Groups.
• Involved in requirement gathering, Analyzed and understand the Client data and requirement to create report and dashboard.
• Developed Schema objects like Attributes, Facts, Transformation and tables. Public Objects like Metrics, Filters, prompts, reports and dashboards.
• Created OLAP Services like View filters, derived elements, derived metrics, Intelligent Cubes and published I cubes using Incremental fetch functionality for specific periods.
• Created Visual Insight Dashboards in web using I cubes and I cube reports as a dataset and also Import Data functionality

Environment: MicroStrategy 9.4.1/9.4, SQL Server 2008, Oracle, Big data Hadoop

Confidential

Data analyst

Responsibilities:

• Involved in analyzing various financial systems and sub system’s financial letters and performed reconciliation process.
• Worked on tracing the Bookmarks, Conditions and Letter Logic’s from various source letters.
• Performed thorough quality check to make sure the all deliverables are as per client standards and on time.
• Consolidation of completed and reconciled letters and uploaded them on to SharePoint.
• Interacted with onsite engagement team on daily basis

Environment: MS Excel, SQL Server 2008