SUMMARY

• Over 8+ years of experience in Data Analysis, Design, Implementation, Administration, Data warehousing and support of Business Intelligence technologies along with strong experience of data visualization using Tableau and Power BI.
• Experienced in developing BI applications utilizing SQL Server, Power BI, and Tableau.
• Experience with the development of automated reporting solutions
• Experience with Analyzing Business Operations to understand strengths and weaknesses to determine opportunities to automate processes and functions
• Delivered on - demand reports in multiple rendering formats with standard and data driven subscriptions.
• Strategic expertise in designing of experiments, data collection, analysis, and visualization.
• Extensive Tableau Desktop, Tableau Server Experience in Enterprise Environment, in various Tableau versions of 6.x, 7.x, 8.x, 9.x and 10.x as a developer and Administrator.
• Experienced in developing rich Interactive reports and dashboards integrating various reporting components from multiple sources and proficient in Tableau 2020/2019/10. x/9.x/8.x/7.x (Desktop, Server, Public),
• Experienced in leading or contributing to an agile project management approach that emphasizes communication, coordination, flexible reassessment of plans, and iterative phases of work.
• Experienced in handling sensitive data and exercising judgment and discretion.
• Experienced in independently interacting with senior non-technical business stakeholders and their reactive needs to ambiguous and changing priorities.
• Experienced in managing, manipulating, and validating large data sets from multiple systems, tools, and reports using statistical software or other methods
• Experienced in working with large data sets and will have in-depth experience in data-driven decision making.
• Experienced in assessing various data sources to determine accuracy, completeness, quality and structural characteristics.
• Involved in Communication of data assessments, prepare data for use in reporting and other solutions, and communicate those conclusions within a business context
• Experienced in adoption of powerful, cloud-based tools and be an important part of developing and obtaining value from Gallagher's growing data assets
• Experienced in Building key parts of analytical solutions in Azure and working with the team to ensure any business-accepted solutions can be moved into production.
• Experienced in Partnering with the data engineer, analyst, consultant, and researcher functions to develop and publicize mutually beneficial best practices and processes.
• Experienced in identifying product opportunities and measured impact and collaborate with multiple cross-functional partners across sales, marketing, planning and operations, product, engineering, and others.
• Experienced in developing scaled insights solutions to drive business performance, accelerate product success and unlock partner value.
• Experienced in quantitative analysis, experimentation, data mining, and data visualization to see Confidential the numbers and pull insights to help identify trends & opportunities to drive growth of our product & business, and measure impact.
• Experienced business analyst specializing in requirements analysis and SDLC documentation. Waterfall, UP, Agile and Scrum methodologies. Business Process Re-engineering (BPR). Experience in full life cycle. Provide project coordination.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations, and complex calculations to manipulate the data.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Excellent knowledge in Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports.
• Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources.
• Experienced in working with data modelers to translate business rules/requirements into conceptual/logical dimensional models and worked with complex de-normalized and normalized data models.
• Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.
• Designed and Optimized Connections, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets
• Quickly and effectively diagnose and respond to service desk requests regarding data integrity and functional or interactive issues in existing and future dashboards in Finance and Funds sector.

TECHNICAL SKILLS

BI Tools: Tableau 2020.3/2019/9 x/ 10x (Desktop, Server, Public), Looker. Business Intelligence Development Studio (SSRS), SSIS, Alteryx, Qlik sense, Einstein Analytics and Power BI, Crystal Report, Cognos.

ETL Tools: Informatica Power Center 7/8, SQL Server Integration Services (SSIS), OLAP(Cubes)

Databases: Teradata, SQL Server, MySQL, SQLite, Hadoop/HBase, Hive, MS Access, Oracle 12c, Vertica, Salesforce, DB2.

Applications: Microsoft Office, MS Visio, Visible Analyst, Share point

Web Technologies: HTML, CSS, JavaScript

Web Scripting: XML, XHTML, JavaScript, Ajax, J Query, ASP 3.0, Visual Studio

Web Tools: MS-Front Page, Dream Weaver

Methodologies: Agile, TDD, Waterfall.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr Data Analyst/ Business Intelligence Consultant

Responsibilities:

• Responsible for assessing change, analyzing impacts, recommending business solutions, devising test strategies, and documenting outcomes and may act as Product Owner for technology initiatives following Agile methodologies
• Partnered closely with business and process SMEs, data managers, and technology teams to implement the solutions.
• Ensured the integrity, consistency and scalability of Product and Partner reporting and provides insightful analysis to support management’s decision making.
• Coordinated and guide stakeholders through a process of creating reports and data models that successfully address business issues
• Participated in multiple projects by completing and updating project documentation; managing project scope; building a business case; determining daily priorities; ensuring efficient and on-time delivery of project tasks and milestones.
• Assessed existing reports, data sources, business processes and initiatives.
• Involved in Troubleshooting data sources and address questions as identified.
• Find improvement opportunities and strategies to evolve the current capabilities
• Maintained standard monthly reports and metrics used to measure partner compliance and improve overall department efficiency
• Conducted a variety of ad-hoc analysis based on business needs
• Established and maintained data governance processes and strategies to minimize data integrity and business risk
• Validated, researched, and audited data sources and internally develop collections to minimize data integrity risk.
• Provided tactical analyses and troubleshooting of the business unit’s existing reports and data sources.
• Crafted and published weekly and monthly dashboards and reports.
• Researched unusual trends and provided supporting detail to management.
• Analyzed the efficiency and effectiveness of programs and recommend improvements.
• Used dynamic Year Parameter in Custom SQL connection to pull in data for the year of User’s choice, this reduced the data load and improved dashboard performance.
• Created Views on TM1 to store complex query results and use them in the Tableau Connection. Worked with TM1 Connect team to ensure the data views are created properly.
• Identify and Resolve errors occurred during Live data connection.
• Created various types of charts like Waterfall Chart, Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Gantt Charts and Histograms.
• Developed various Dashboards using objects such as Chart Box (Drill Down/Drill up/Cyclic Grouping), List, crosstab
• Created Aggregates, Hierarchies, Context Filters, Quick filters, Table Calculations, Trend lines and calculated measures and more.
• Created Single Bar chart to showcase both Top and Bottom N geographic locations in terms of Sales/Profits/Revenue, sorted and color coded in descending order on Positive and Negative axis.
• Developed sheets for dynamic Dimensions and Measures using Parameters to help User check the data distribution based on multiple combinations of Dimensions and Measures.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps
• Created interactive dashboard and applied actions like filter and highlight to dashboard.
• Developed Dashboards and stories in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with quick filters to filter needed information.
• Worked on Performance tuning and optimization of the reports.
• Provided support to the applications/workbooks created to validate the reports on daily basis and perform bug fixes and re-publish the dashboards to the production Server.

Environment: Tableau 9.2 Desktop, Tableau 9 Server, TM1 Connect, Excel, Hive, SQL, R, Python, Snowflake, Big Query, Spark, Airflow.

Confidential, Chicago, IL

Sr. Data/BI Consultant

Responsibilities:

• Gathered user requirements, analyzed, and designed software solution based on the requirements.
• Played critical role in establishing best practices for tableau Reporting by conduct meeting with the clients for gathering reporting requirements; identify the KPI's and developing POC Dashboards.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to created summary level and detailed Reports.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in -memory in both tableau and excel.
• Tested Dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data
• Created organized, customized analysis and visualized projects and dashboards to present to executive leadership.
• Created Complicated Calculation Based LOD (Level of detail) feature.
• Designing and developing data warehouse and Amazon Redshift BI based solutions.
• Involved in managing the application's users, groups, and integration with Active Directory
• In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
• Evaluated database performance issues and executed database optimization.
• Prepared backups using Tab admin and Tab cmd commands.
• Developed Scatter Plots and Area Maps to show states utilizing the Mobile App.
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed Story Telling behind the Mobile App usage with Quick Filters for on demand needed information with just a click of a button.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies, and procedures.
• Good Experience in publishing reports and dashboards to tableau server.
• Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.

Environment: Tableau (Desktop and Server), SQL Server, JIRA, Share Point, SQL,2019.4, 10x, Tableau Server, SQL Server 2008/2008 R2, Netezza, Tableau Prep, SharePoint, MS Visio, spark, Agile.

Confidential, Minneapolis, MN

Data Analyst/ Business Intelligence Consultant

Responsibilities:

• Participated in requirements gathering and translate business requirements into report visualization specifications design documents.
• Translate business requirements into Tableau Dashboards
• Created and managed plans using JIRA Portfolio.
• Assigned the appropriate resources to the JIRA agile Portfolio - Story, Epics.
• Experience in using python API, java script API.
• Produce high quality and high value visualizations in Tableau that are widely adopted by CPI
• Facilitated discussion, decision making, and conflict resolution to ensure consistent progresses.
• Tracked metrics that are important to the team to deliver success and continuous improvement.
• Helped the scrum team ensure they meet the definition of 'done' for each product feature and removed internal and external impediments to their progress
• Quickly resolve any internal customers issues raised and publish new versions of dashboards on a regular basis.
• Conducted stakeholder Joint Application Design (JAD) interviews and facilitated meetings with project teams.
• Translated business user concepts and ideas into comprehensive business requirements and design documents.
• Created project plans in accordance with project management framework standards and procedures. Identified ongoing issues and gaps within project plans, to eliminate implementation issues.
• Planned, facilitated, and reported on quality assurance testing efforts.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Work with existing data model to produce accurate dashboards with respect to Rally and other tools.
• Involved in the user requirement gathering and Design meetings. Translate business needs into reporting and analytic requirements.
• Created different views in workbook to visually analyze the data.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Gathered user requirements analyzed and designed software solution based on the requirements.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created many Dashboard reports for company's decision-making purpose and made them Key Performance Indicators (KPI).
• Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Drilldown, Drill-Through, Multi-valued parameters etc.
• Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Restricted data for users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.

Confidential

Data Analyst

Responsibilities:

• Involved in complete software development life cycle - Requirements gathering, Conceptual design, Analysis, Detailed design.
• Created EPICS, Themes, Features, User stories, Tasks, subtasks, and acceptance criterion.
• Worked closely with Product Owners to understand their need and communicated to tech team and leveraged information to create User stories.
• Followed Scaled Agile Methodology to Implement the Project and used JIRA to track and mange Iteration progress.
• Enacted as Scrum master to track project activities and to make sure project velocity is on track.
• Planned and designed the solutions artifacts & recommended business processes to improve and support business activities.
• Analyzed the client requirement and the basic crux of application and system how it is going to benefit the client’s object.
• Interacted with stakeholders, performed workshops to extract the requirement, conflict management performed.
• Facilitated JAD sessions with SMEs’, Business Change managers (BCM) managers to understand the business process; gather Business Requirements and identified changes for the applications.
• Interacted with stakeholders and gathered requirements as per thebusinessneeds.
• Conducted GAP analysis byunderstanding the AS-IS and TO-BE system requirements by having discussions with BCM’s and Directors.
• Served as a critical liaison between Product Owners, developers, device engineers, device quality assurance, software quality assurance, DevOps, management, and other stakeholders
• Architected the System using Micro Services and deployed them to Pivotal Cloud Foundry (PCF).
• Used Gradle as build tool, log back for logging, Junit for unit testing, Cucumber for Behavior Driven Development and Serenity for Automated Test Reports.
• Used Splunk for Centralized log management and Analysis.
• Participate in Code Analysis, and Test Plan Reviews
• Handled the Release Process and provided implementation support
• Responsible for resolving design issues and developed strategies to make ongoing improvements that support system flexibility and performance.

Environment: Oracle11g, ABC 11g, OWB 10g Release2, TOAD, PL/SQL, Bigdata (python, java) JDE, SQL Loader, Microsoft SQL Server, Unix