SUMMARY:

• Around 5 years of Full Life - cycle Data warehousing and BI projects experience.
• Proficient in Designing, Architecture, Development & Testing Processes of Data warehousing & BI Projects.
• Experience in Data Analysis, Data Reporting, BI Dashboards
• Develops technical plans for new development efforts
• Experience in gathering requirements from business users, defining KPIs, presenting POC (Proof of Concept) to business Users and suggesting alternative solutions as part of application improvement.
• Experience in creating microStrategy 10.3 (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) in the data warehouse
• Experience with other BI tools like Microstrategy, Tableau 10,MS-Power BI, Google Analytics
• Created schema, metrics, reports, and documents supporting client business goals
• Domain expertise in Retail, Medical Domain, Banking.
• Proficient SQL and Advanced Excel skills, using large-scale, complex datasets
• An analytical, hardworking individual with good communication & presentation skills and ability to lead and mentor team

TECHNICAL SKILLS:

Business Intelligence Tools: MicroStrategy 9.4,MicroStrategy 10.3 tool Components:- MSTR Architect, Desktop/Developer and Web, Tableau,Google Analytics, Power BI

Normalized, De: normalized, Star and Snow Flake Schemas, Creating Logical Data Model, creating MicroStrategy Schema and application objects such as attributes, facts, metrics, different types of hierarchies in MicroStrategy 10.3/Microstrategy 9.4

MS: SQL Server Studio Management 2008, SQL server 2005, Hadoop

PROFESSIONAL EXPERIENCE:

Confidential

Senior BI Analyst

• As Project Lead managed the team built data model and dashboards for ipad and iphone
• Designed the app whose main goal was to monitor health in Parkinson’s Disease provide insights
• Data Gathering and do required Analysis on data
• Study the data and do Storyboarding
• Mockup Finalization so that development team can proceed with the development
• Created schema objects such as Attributes, Facts and Hierarchies and worked on relationship between attributes
• Good experience with MicroStrategy Visual Insight Reports.
• Created various reports which are part of dashboard having different interactive widgets that are accessed by top level executives.
• For complex reporting needs, worked extensively on creating Metrics, Filters, consolidations
• Resolved Cross joins in the SQL's by modifying the attribute definitions to generate the accurate results.
• Leveraged Microstrategy 10.3 OLAP services to develop reports, which use the functionality of the intelligent cubes and Derived Metrics.
• Created security filters and other report objects, drilling, defined hierarchies.
• Involved in troubleshooting Microstrategy 10.3 Web Reports, optimizing the SQL using the VLDB Properties.
• Worked on creating the Visual Insights including the various widgets and demonstrated to the business users.
• Experienced in doing the quick POC's to satisfy business requests using Tableau.
• Provided insights on Dashboard creating in Google Analytics and Power BI platform
• Tested all the reports by running queries against the warehouse using SQL Server management studio tool.
• Worked on support measure for the other related projects and responsible for re-architecting required changes and checking the report results.
• Created documents using panels, panel stacks, sections, grids, graphs and widgets.
• Used the Object Manager to move the objects from Development to QA and to Production environment in Microstrategy

Environment: Microstrategy 10.3, Desktop, Microstrategy VI(Visual Insights),Intelligence Server, Web, SQL Server Studio Management, Window10, Tableau, Power BI, Hadoop,Web Scrapping

Confidential

BI Analyst

• Provided D3 Visualization to offer better performance in Microstrategy 10.3
• Implemented interactive and Intuitive UI
• Configurabled Styling on Axis labels, Fonts, Tooltips, Highlighting features on hover
• Made Reports and gave insights by building rich, high-visibility reports/dashboards
• Conducted end-to-end analysis that includes data gathering, requirements/KPI specifications, processing, statistical analysis, ongoing deliverables and presentations
• Worked as MicroStrategy Architect to design schema & develop Public Objects like Metrics, Prompts, Filters, Consolidations, Custom Groups, Templates, Reports and Documents as per prototype.
• Provided end-to-end analysis that includes data gathering, requirements/KPI specifications, processing, statistical analysis, ongoing deliverables and presentations
• Build statistical models to understand our customers network experience and predict/prevent failures at our broadcast centers to reduce outages
• Responsible for designing and executing Application objects and Schema objects using MicroStrategy Desktop.
• Created POC’s in Google Analytics and Power BI
• Created Special technically directed documents for better acceptance of the reports.
• Environment: Microstrategy 9.4,Desktop, Intelligence Server, Web, SQL Server Studio Management, GoogleAnalytics

Confidential

Business Intelligence Specialist

• Document functional business requirements.
• Communicate with clients at all stages of the project development.
• Monitor and measure progress at milestones predefined in the project development life cycle.
• Bidding for Android and iOS Projects
• Determine a project’s requirements by extracting them from business as well as from current and future users, through interaction and research.
• Translate business requirements to technical requirements. This includes using powerful analysis to match strategic business objectives with practical technical solutions.

Environment: Word Processing: Microsoft Word, Analysis & Data Crunching: Microsoft Excel, Presentation: Microsoft PowerPoint, Bidding Tool- Odesk, Microstrategy 9.4