• Profiled the legacy database tables using T-SQL queries to provide data cleansing issue reports to the client.• Developed data reconciliation SQL queries to validate the overall data migration.• Formulated DAX Expressions create Date to yearly columns and implemented partitions in Tabular Models for Power BI.• Performing complex data analytics, ETL data integration with Alteryx framework.• Wrote DAX expressions to create new measures, calculations per business requirements.• Effectively used data blending, filters, actions, and hierarchies feature in Power BI.• Published the developed dashboard, reports on the Power BI Services so that the end-users can view the data.• Successfully integrated custom visuals based on business requirements in Power BI desktop.

• Participated in the configuration of an on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards.• Created complicated reports such as parameter-based reports, graphical reports, excel reports, drill-down charts, and tabular reports using SSRS.• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information. • Created extracts and published data sources on tableau Server for the users from various databases in Green Plum. Used complex joins and validated them by running and tuning long SQL queries.• Worked with Business manager to gather requirements and translate them into Technical Documents.• Used Alteryx, Tableau create data workflow, cleanse and validate the data.• Created dynamic dropdown measures in slicer with the help of DAX in Power BI Desktop.• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately• Worked on Tableau Command line tools tabadmin for Configuration settings in tableau Server and tabcmd for users, group’s creation.• Effectively involved in the maintenance of Data Server, metadata management, creating shared Data sources and publishing them to Tableau Server.• Create action filters, parameters and calculations for preparing dashboards and worksheets in Tableau

• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information. • Created extracts and published data sources on tableau Server for the users from various databases in Green Plum. Used complex joins and validated them by running and tuning long SQL queries. • Processed the spend and goals data in Alteryx in such a way that it is suitable for reporting• Provided training to end-business users on Power BI, enabling them to create reports and dashboards.• Having good knowledge on row level security by using User functions and user filters• Developed Detailed cross reports for business as per ad-hoc requests. • Worked with Business manager to gather requirements and translate them into Technical Documents.• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately• Worked on Tableau Command line tools tabadmin for Configuration settings in tableau Server and tabcmd for users, groups creation.• Effectively involved in the maintenance of Data Server, metadata management, creating shared Data sources and publishing them to Tableau Server.• Create action filters, parameters and calculations for preparing dashboards and worksheets in Tableau• Continuous monitoring of tableau server for user availability and refreshes schedule. • Created custom admin views for monitoring the usage of server and users in addition to pre-built administrative

• Configured and managed data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies and implemented cell level security in cubes using SSAS.• Understand the business needs and convert into the Data Models using Erwin tools for Data modeling, Table design, DB Objects.• Expertise in DAX & MDX languages which helps understanding analyzing the data.• Design and monitor construction of user facing presentation tools such as SSRS reports• Generated reports ,cross tab ,conditional, drill down and drill through reports using SSRS• Imported data from multiple data sources in to Excel workbook, created relationships between heterogeneous data, created calculated columns and measures using VLOOKUP and formulas, built PivotTables and pivot charts using power pivot skills• Understand the Requirements and Functionality of the application from specifications.• Organize and facilitate project planning, daily stand-ups, reviews, retrospectives, sprint/release planning, demos and other Scrum-related meetings• Ensures that the process is followed, including issuing invitations to daily scrums, sprint reviews, and sprint planning and sprint retrospective• Implemented several DAX functions for various fact calculations for efficient data visualization in power BI.• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.• While design the Power BI reports and dashboards, the measures are created using DAX programming language.• Writing all the calculations using DAX formulas.• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.• Created different KPI using calculated key figures and parameters• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart

• Developed Reports – Package and Premium Migration by Daily, Monthly and Quarterly. Free View Customer Usage Report. Funnel Report with Details of active and inactive streamers. Channels viewed Prime Time, Weekly, Monthly and Quarterly. View stats on the seasonal sport channels. • Worked on multiple Data Sources including Tableau Server, MySQL, SQLServer (ETL Tables), Excel to get the data needed for the dashboards. • Handled the Data Transformation using SQL for the reporting purposes. • Created Rich dashboards using Tableau Desktop and prepared user stories to create compelling dashboards to deliver actionable insights.• Built dashboards for measures with forecast, trend line and reference lines.• Involved in Design/Lead/Develop Prototypes for business solutions (dimensional models, model builds) so that business users may visually understand and explore a new feature or functionality before implementation to expose design assumptions and drive ideation. Ensured prototypes meet the organization standards to allow transfer to production.• Developed compelling, Interactive Dashboards using different features like Filters, Parameter, Actions, Calculations (using logical, String, Table, Aggregate functions) and formatting the reports/dashboards (Layout Containers, Annotations, Mark Labels etc.,)• Trained and supporting Business Users on Tableau’s self-service model for creating their own dashboards and Publishing/Accessing them from Tableau online.

• Creating Sales Pipeline Report for different Brands of IBM for the Higher Management of Europe and North America for different Sales Stages and different Quarters as per the requirements.• Work with sales operations teams to analyze pipeline and revenue trends.• Manage a team that collates data sets and arrange the data for reporting in COGNOS and driving efficiency through automation.• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases. Used filters for efficient data retrieval.• Ensure strong linkages and partnerships with external and internal (e.g., IOTs/IMTs/GMU/GMTs and BUs) Stake Holders• Analyzing pre-exits reports and solving the existing issues within it• Maintenance and Schedule management for the daily email reports.• Creating Sales dashboards provided drill though capability for more analysis

• Worked on Project A/R, Cash and other resolution-oriented reporting to the client directly• Worked on RFP (Requisition for Proposal) whenever a new project proposal is put forth by a Deloitte director• Providing FTE requirements for a start-up project, setting up the database for initial kick off and go live of any healthcare client• Representing the analyzed data in Excel or on PPT representation.• Extensive experience in Cognos8 BI including Framework manager, Report studio, Query Studio, Analysis studio.• Involved in the Dimensional modeling in the Framework manager.• Major areas of expertise in designing and developing, creating and modifying different reports like List, Crosstaband Chart reports using Report studio, Ad-hoc reports using Query studio and Analysis studio.• Worked on different types of reports like Cross tab, Master/Detail, Drill through reports Created Advanced Prompts.• Experienced with Complete application development life-cycle including requirements gathering, analysis and design, implementing and testing.