SUMMARY:

• Around 6 (Six) years of Experience in Business Analysis, System Analysis, Data Analysis, Software Design, Development, Implementation and Maintenance of Business Intelligence and Data Warehousing.
• Professional Data Management Analyst who is fluent in data trends and able to manage large databases of information, identifying data quality issues, and proposing solutions.
• Adapt in utilizing computer productivity software, gathering data from multiple sources and working with management to develop halpful reports. Specializes in developing reports on Financial and data trends as well as delivering data for large projects. Expert in Database and ETL Design.
• Tableau Experience in enterprise environment including report / dashboard design, development, maintenance and support using various versions (10.x/9.x/8.x/7.x) of Tableau Desktop and Tableau Server
• Extensive experience in Microsoft SQL Server (2016, 2012, 2008R2) including writing T - SQL Programming, SSIS and SSRS.
• Used SSIS for Slowly Changing Dimensions, Lookup, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Expertise in Creating, Deploying and managing Reports through SQL Server Reporting Services (SSRS).
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS and Crystal reports.
• Developed Standard Reports, Sub Reports, Drill Down, Drill Through Reports, Used various Charts and graphs like Bar Chart and Line graphs in SSRS.
• Good noledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Highly Proficient in Agile, Iterative, and Waterfall software development life cycles.
• Expert in Data Visualization, Data Analysis, Business Intelligence, IT Analysis/Design, and Client/Server System Architecture.
• Hands on experience of implementing end-to-end BI solution using Tableau.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, line diagrams, pareto charts, funnel charts, scatter plots, pie-charts, donut charts, bubble charts, funnel charts, heat maps, tree maps according to the end user requirements.
• Expertise in using advance Tableau features like Calculated fields, Sets, Groups, Parameters, context filters, quick filter, global filters, Actions, etc.
• Integrated Tableau into Front-End Web Application using JavaScript API to call parameters and filters as well as individual sheets.
• Expertise in designing and developing analytical reports, dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data by integrating data from multiple sources and halp users to identify critical KPIs and facilitate strategic planning in the organization.
• Proficient in analysis, design and implementation of data warehousing/ BI solutions using Tableau, Informatica, MicroStrategy, Tableau and Database technologies.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Posses’ strong noledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.

TECHNICAL SKILLS:

Analytical Tools: Tableau 10.x, 9.x, 8.x (Desktop/Server/Public/Online), Google Analytics (Adobe Site Catalyst), SQL Server Integrating Services (SSRS)

Operating Systems: UNIX, LINUX, Windows 8/7/XP/2000

Databases: MySQL, SQL Server 00,05,08, Oracle, Teradata

Scripting Languages: C, C++, SQL, Python, PERL, SQL, PL/SQL

Profiler: DQ Analyzer

ER Tools: Oyster

WEB technologies: XML, HTML, Java Script, PHP, Java

Modelling language: UML

Modelling Tools: MS Visio, MS Project

WORK EXPERIENCE:

Confidential, Salt Lake City

Data Analyst/ Tableau Developer

Responsibilities:

• Interact with the stakeholders to capture and convert the high-level requirements of the project and design flows using MS Visio.
• Analyze dimensional and fact tables in campaign data mart dat details inclusion, exclusion and segmentation criteria for loan processing, offer assignment and campaign response by campaign.
• Process extract data sources from MS Excel and Access to analyze metrics, implement custom procedures, and create reports fulfilling client requirements.
• Extracted data using Parsing, Data Mining, Joins, Aggregations using Alteryx 9.5.
• Create and modify analytical reports with visually rich and interactive dashboards at each stage of loan approval using Tableau Desktop.
• Developed customized calculations as required for different areas of post approval processing namely Funding and Book Keeping.
• Use geographic view to understand and leverage the key areas of the business by line of business and geographical area.
• Create filter actions to share/send information with other tableau worksheets.
• Provide rich visual interaction between the views, create URL actions to connect the data views to external resources.
• Implement new features of Tableau namely new Visualizations, Forecasting, Data Blending and Hyperlink Objects based on use case.
• Publish the dashboards to report server using Tableau Server.
• Agile mode of project management methodology and participate in weekly sprint resource planning, implementation and tracking using Microsoft Team Foundation Server (TFS).
• Update status of the work task in daily scrum meetings with the team and higher management; for milestone tracking and avoiding scope creep issues.
• Involve in bi-weekly Change Advisory Board (CAB) meetings with internal organizations regarding status of all assigned projects and tasks or for any future requests.

Environment: Tableau 9.1.x, Tableau Server (9.1), Alteryx 9.5, Oracle 11g, PL-SQL, Teradata, Microsoft Team Foundation Server (TFS), Microsoft Office Suite 2013 - MS Excel, MS Access, MS Visio, Windows 2012 R2 Server, Agile Methodology, Scrum

Confidential, Denver, CO

Tableau Developer/ Data Analyst

Responsibilities:

• Gatheird Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
• Performed data analysis and data profiling using SQL on various sources systems including Oracle and Teradata
• Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.
• Creating customized Tableau Dashboards, integrating Custom SQL from Teradata and Oracle and
• Performing data blending in reports.
• Designed, developed, tested, and maintained Tableau reports and dashboards based on user requirements.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets.
• Mastered the ability to design and deploy rich visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created Complex calculated fields in getting Turn Around Time and Aging of the devices as per business requirement for the given time frame.
• Created side by side bars, Scatter Plots, Stacked Bars, Filled Maps and Symbol Maps according to deliverable specifications.
• Actively involved in the creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logins.
• Involved in Performance Tuning of the database which included creating indexes, optimizing SQL statements and monitoring the server.

Environment: Tableau 10.x/9.x (Desktop/ Server), Erwin 9.1, Teradata, Oracle 11g, Google BigQuery, VISIO, JIRA, MS Office Suite (Word, Excel, PowerPoint).

Confidential, ‎Louisville, KY

Data Analyst/ Tableau Developer

Responsibilities:

• Created Schedules and extracted the data into Tableau Data Engine.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps.
• Executed and tested required queries and reports before publishing dashboards.
• Analyzed the required Report Specification Documents and created the dashboards according to the User requirements.
• Effectively implemented the data blending feature in tableau.
• Developed parameter and dimension-based reports, drill-down reports, charts, and Tabular reports using Tableau Desktop.
• Created procedures to ensure the quality, usability and accuracy of reports.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Implemented action filters, parameters and sets for preparing dashboards and worksheets in Tableau.
• Built and published customized interactive reports and dashboards, reported schedules on Tableau server.
• Managed the Tableau solution architecture, administration and actively managed the performance and usability.
• Aligned and standardized team members on best practices around Tableau driven implementations.
• Scheduled the monthly, weekly, daily reports to run automatically.
• Defined best practices for Tableau report development.
• Created Data extracts for better performance and accessed data offline.
• Provided support once the dashboards were published and updated any data changes, system changes, or requirement changes.
• Written SQL queries for data validation by using join conditions.
• Extensively worked on Tableau Desktop, by creating Complex reports & Dashboards.
• Implemented Data blending with multiple data sources on a single worksheet for data analysis.

Environment: Tableau Desktop (Version 8.1.2 - Version 9.0.2), SQL Server, Microsoft Visual Studio, Microsoft Visual Basic, Oracle, SQL Server Management Studio, MS Excel, MySQL.

Confidential

Report Developer

Responsibilities:

• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports, Drill Through Reports and Charts using SQL Server Reporting Services (SSRS)
• Created linked, unlinked and on-demand sub Reports.
• Created Query Parameters and Report Parameters to control data returned by the query and filter data at report level
• Created DDL, DML scripts, stored procedures, CTE according to the requirement and designed ad hoc queries on the database tables.
• Developed tables, Views, Stored Procedures and Triggers using SQL Server Management Studio.
• Created subscription for the reports in SharePoint
• Created the packages based on mapping document using SQL Server Integration Services (SSIS).
• Loading multi format data from various sources like flat-file, Excel, MS Access, Oracle etc. using SSIS and performing file system operation.
• Requirement clarification with the clients
• Involved in coding, module integration, unit and integration testing and release activities.
• Build and deployment
• Code reviews.
• Implementing the functionality changes as per the requirement
• Preparation specs and all other required documents
• Provided support on deployment in UAT and Live environment
• Analyzed the requirements based on business concept

Environment: SSRS, SSIS, MS SQL Server 2012

Confidential

SQL BI Analyst/ Report Developer

Responsibilities:

• Analyzed the requirements based on business concept
• Created the System test case scenarios
• System testing
• Preparing Traceability Matrix
• Requirement clarification with the clients
• Preparation specs and all other required documents
• Provided support on deployment in UAT and Live environment
• Worked on SSRS reports and fixing the issues in it.

Environment: C#, SSRS, Web Services, MS SQL Server 2012, SSIS