SUMMARY

• Around 6 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 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 /Tableau (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups, Calculated fields Measures, Dimensions, Quick Filters) in the Data warehouse
• Worked on the development of Tableau Dashboard reports for Key Performance Indicators for the top management.
• Created schema, metrics, reports, and documents supporting client business goals
• Domain expertise in Retail, Medical Domain.
• Formulated and executed analytics strategies for properties.
• Analyzed and reported latest industry trends for business implications.
• Prepared and documented specifications for business intelligence reports.
• Maintained and reviewed technical designs for development of reporting solutions.
• Participated in market research analysis for determination of commerce trends.
• Aided in online campaigns and online marketing strategy execution.
• An analytical, hardworking individual wif excellent communication & presentation skills and ability to lead and mentor a team

TECHNICAL SKILLS

Business Intelligence Tools: MicroStrategy 9.x, MicroStrategy 10.x tool Components - MSTR Architect, Desktop/Developer and Web, Tableau, Google Analytics, MS-Power BI, Web Scrapping, Pentaho Data Integration (Kettle)

Data Model: Normalized, De-normalized, Star and Snow Flake Schemas, Creating Logical Data Model, creating MicroStrategy Schema and application objects such as attributes, facts, metrics, several types of hierarchies in MicroStrategy. Created dimensions, Measures, Quick Filters, Calculated fields, Parameters in Tableau 10x.

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

PROFESSIONAL EXPERIENCE:

Confidential, Virginia

Senior Business Intelligence Analyst

Responsibilities:

• Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
• Developed various reports using best practices and different visualizations such as Tornado Charts, Donut Charts, Gantts, Bars, Lines, Pies, Maps (Filled and Symbol), Highlight tables, Bubbles, Scatter Plots, etc.
• Work on Performance tuning of the report to meet the business requirement of executing the report in less than one minute.
• Create schema objects and public objects required for the reports.
• Developed complex reports using advanced filters, conditional formatting, transformation metrics, level metrics, custom groups and consolidations.
• Creating relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and Excel.

  Creating customized reports using various chart types like, crosstabs, highlight tables, bar graphs, pie charts, tree maps, heat maps, line graphs, pivot tables, combination charts using Tableau Desktop.

• Developed cubes, reports, metrics, attributes, filters, prompts for MicroStrategy Reports, Report Documents and VI dashboards.
• Created business driven dashboards using different chart types like Crosstab's, Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Gantt charts, Bubble charts, Scatter Plots, Trend lines, Bullets, Bullet Graphs, Highlight tables and Histograms in Tableau Desktop.

Environment: Tableau 10x, MicroStrategy 10.2, Desktop, Intelligence Server, Web, SQL Server Studio Management

Confidential

Business Intelligence Analyst

Responsibilities:

• Build reports and dashboards for iPad and iPhone using BI tools like MicroStrategy and Tableau
• Data Gathering and do required Analysis on data
• Study the data and do Storyboarding
• Mockup Finalization so dat development team can proceed wif the development
• Created schema objects such as Attributes, Facts and Hierarchies and worked on relationship between attributes
• Created various reports which are part of dashboard having different interactive widgets dat 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.
• Created security filters and other report objects, drilling, defined hierarchies.
• Involved in troubleshooting 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 usingTableau 9x.
• 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
• Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.

Environment: MicroStrategy 10.2, Tableau 9x, Desktop, Intelligence Server, Web, SQL Server Studio Management, Window10, Google Analytics

Confidential

Business Intelligence Analyst/Developer

Responsibilities:

• Provided D3 Visualization to offer better performance
• Implemented interactive and Intuitive UI
• Configured 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 dat includes data gathering, requirements/KPI specifications, processing, statistical analysis, ongoing deliverables and presentations
• Work 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 dat 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 Special technically directed documents for better acceptance of the reports.
• Responsible for building reports inPowerBIfrom the Scratch.
• Responsible for creating and changing the visualizations inPowerBIreports and Dashboards on client requests

Environment: MicroStrategy 9x, Desktop, Intelligence Server, Web, SQL Server Studio Management, Pentaho Data Integration Tool, Web Scrapping, MS-Power BI

Confidential

Business Intelligence Specialist

Responsibilities:

• Document functional business requirements.
• Communicate wif 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. dis includes using powerful analysis to match strategic business objectives wif practical technical solutions.

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