SUMMARY

• Adaptable Data Analyst & Catalog management skilled in recording, interpreting and analysing data in a fast - paced environment. Advanced proficiency in all aspects of Excel. Experienced in preparing detailed documents and reports while managing complex internal and external data analysis responsibilities.
• Over 5 years of experience as Data Analyst including analysis, design, development and implementation of Data warehouses/business intelligence projects.
• 2+ year of extensive experience Power BI which included working with complex DAX query, DAX table functions, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Extensive experience on interaction with system users in gathering business requirements and involved in developing projects.
• Experience in working with banking, Financial and Insurance verticals.
• Ability to meet deadlines and handle pressure coordinating multiple tasks.
• Proficient with Microsoft Suite which includes visualization tool Power BI, ETL Tool (SSIS), SSRS and RDBMS MS SQL server 2014/16 and cloud base Azure SQL DB; designed, developed and published multiple report and dashboard in MS SQL Server/Azure cloud environment
• Having experience on Creating groups and Content pack in Power BI
• Having good experience on manual refresh and automatic refresh using gateways created in context filters, quick filters, table calculations, calculated measures and parameters in Power BI also experience working large volume of data.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients.
• Strong experience in creating advanced chart types, visualizations and complex calculations to manipulate the data as per business need through Power BI
• Extensively worked on Data Extraction, transforming and Loading by using SSIS, Developed and implemented ETL processes by using SSIS to move data from different sources to targets.
• Working on scheduling Jobs to execute SSIS packages.
• Extensive experience to Generating Tabular, Parameterized, Drill Through, Drill Down, Matrix and Sub Reports in SSRS.
• Having experience to deploying the reports on different Servers (Report Server and Share Point integrated mode).
• Proficient with SQL Server Tools like profiler, Database-Tuning Advisor.
• Having experience on data visualization tool using Tableau; created different Types of filters, Book mark and Drill trough etc
• Expert in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc. using Power BI and Tableau.
• Strong experience in creating advanced chart types, visualizations and complex calculations to manipulate the data as per business need through Power BI and Tableau
• Strong experience in using Excel and MS Access to analyse data based on users needs.
• Perform Data profiling and analysis using complex SQL query; worked with T-SQL also.
• Hands on Experience in performance tuning and query optimization.
• Experience in working with in different databases like using SQL SERVER 2014/2016, Oracle 10g/11g, Teradata 14and PostgreSQL.
• Strong verbal and written communication skills; Ability to work on multiple initiatives at the same time
• Demonstrated strong interpersonal skills with the ability to work effectively with upper management and excellent leadership skills in motivating others.

AREAS OF EXPERTISE

• Data Visualization using Power BI, Tableau
• MSBI Integration
• Advance Excel
• DAX
• Data Transformation (ETL)
• Complex SQL Query
• Power Query & Power Pivot
• RDBMS like ORACLE, SQL Server, Teradata

PROFESSIONAL EXPERIENCE

Confidential

Power BI Developer

Responsibilities:

• Read business user requirements, analyzed data, and designed software solutions in Power BI Desktop based on the requirements.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Deep experience with the design and development visualization solutions through Power BI.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Reports.
• Worked with Power BI Desktop workbooks and data models that are created using Data Analysis Expressions (DAX)
• Built multiple data visualizations using Power BI in the form of interactive reports and dashboards; delivered different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps etc.
• Worked on various Visualization types; also mapped data structures into compatible Visualization formats as per user preferences
• Used advanced calculations using MS Power BI Desktop (Aggregate, Date, Logical, String, Table)
• Gathered functional and non-functional client requirements in order to optimize the design of BI deliverables (reports, dashboards, alerts, visualizations).
• Loaded the customer profiles data, customer claims information, billing information etc. into SQL Server DB using SSIS.
• Developed rich interactive graphics and data visualizations of large structured data in browser-friendly formats.
• Supported customers in optimization and improvement of existing features of all API applications.
• Built and published interactive reports and dashboards using Power BI Desktop.
• Created advanced chart types, visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Writing complex SQL queries to perform testing of reports.
• Blended data from multiple databases including SQL Server, MS Excel and Oracle SQL database.
• Participated in cross-functional meetings to resolve recurring issues of vendors.
• Interacted with vendors directly through scheduled daily / weekly Business Conversation (Email).
• Prepared live Dashboard reports and presenting it to the concern team.
• Handled multiple reports, working with formulae, pivot tables & pivot charts, and various other excel components for accurate results.

Environment: Microsoft Power BI 2.6, DAX, Advance Excel reporting, Oracle 11g, SQL Server 2012, ORACLE 11g, Azure SQL DB

Confidential

Tableau Developer

Responsibilities:

• Created dashboards according to user specifications and prepared document to provide an understandable and helpful vision to users.
• Created data visualizations and dashboards and applied various actions (URL, Filter, Parameters) in Tableau.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Assisted users in creating and modifying worksheets and visualizations dashboards.
• Mapped the prime locations to posted localities with their geo tagging, in order to provide the user a better navigation to desired property with amenities.
• Reconciled the data of exiting localities in the all metropolitan cities & zones, in order to clean the data.
• Prepared data with ZIP codes/Geo Tags for a hierarchy-based locality search to provide a better user experience to navigate to the localities in desired location.
• Run supporting web-site file and compile reports of the localities in upcoming & growing cities.
• Rectified daily basis records of the newly posted localities.
• Created dashboards by extracting data from different sources and used data blending to blend two data tables in case of merging data using Tableau Desktop.
• Created dashboards from different source systems such as CSV, Oracle and MS SQL Server.
• Maintaining server activities, user activity and customized views on Server Analysis.
• Integration of Tableau reports with web apps and usage of JS API for performance improvement.
• Designed standardized data mart with aggregated data, calculated metrics to suffice the source that the data need for various tableau reports and also worked with ETL developers, DBAs to implement the same in Development, Test and Production environment.
• Used SQL, PowerPoint and Excel daily to generate various performance reports for report validation and analysis.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau Desktop 8.2, Tableau Server 8.2, SSIS, MS Office Suite, Teradata 14, Oracle SQL Server R2 2008, PostgreSQL, MS Excel, T-SQL

Confidential, Minneapolis, Mn

Tableau Developer

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements.
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Developed various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Actively involved in Setting up Tableau Environment.
• Creating Visualizations in tableau using Excel, RDBMS and SharePoint data.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations
• Actively participated in clarification meeting with the Clients.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Environment: Tableau Desktop 8.1/8.2, Tableau server, SQL developer, Oracle 11g, Microsoft Excel, MS Access