PROFESSIONAL SUMMARY:

• Over 6 years of experience as a Business Intelligence (BI) and Reports Developer
• Experience in designing interactive Dashboard using various data visualizations using Tableau Desktop and Tableau Server.
• Experience in designing and developing Tableau Reports, Documents, Dashboards and Scorecards per specified requirements.
• Excellent in administering tasks in Tableau Server, such as setting user permissions, managing ownership by assigning users to specific groups within organization
• Experience in developing reports using SQL Server Reporting Services and creating various types of reports like Drill Down, Drill Through and Parameterized Reports.
• Experienced in SQL for developing complex stored procedures, triggers, tables, user functions, SQL joins and query writing.
• Good knowledge in Microsoft Business Intelligence tools like MS SQL Server Integration Services (SSIS) and MS SQL Server Reporting Services (SSRS).
• Experience in Microsoft Power BI tool to develop dashboards in Report view and publishing to share with specific user groups
• Excellent in rendering reports, managing subscriptions, creating reports using report builder and report snapshot.
• Sound knowledge of software development life cycle (SDLC) as well as Agile methodologies in production environment.
• Worked closely with Business users, Report developers and other members of Reporting teams to analyze and simplifying requirements.
• Well - organized and highly motivated. Excellent in communication & collaboration, interest & ability to learn new technologies in short time.

TECHNICAL SKILLS:

Operating Systems: Microsoft Windows 10/8/7/Vista/XP/2000, Windows Server 2012/2008/2003

Languages: T-SQL, MySQL, MDX, HTML, XML, Python

Reporting Tools: Tableau 10.x, 9.x, 8.x, 7.x, MS Power BI, Business Objects, SQL Server Reporting Services (SSRS 2012/2008 R2), Workday, Excel, Crystal Reports

Databases: MS SQL Server 2014/2012/2008 R2/2005, PostgreSQL, Teradata, DB2, Oracle 11g, MS Access 2014/2012/2008

ETL Tools: SQL Server Integration Services (SSIS 2014/2012/2008 R2)

Environment: Tableau 10.x, 9.x, 8.x, 7.x Tableau Server 8.x, 9.x, 10.x, MS Excel, MS SQL Server 2014, Management Studio 2014, Business Intelligence Development Studio (SSIS, SSRS), MS Power BI, PL-SQL, DB2, Teradata, PostgreSQL, Workday, MS Access, SAP Business Objects, Oracle PeopleSoft, ServiceNow

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Sr. Reporting Analyst

Responsibilities:

• Analyzed data from Excel, Business Objects, DB2 Database to design, develop, dashboards in Tableau Desktop.
• Involved in extracting, converting and loading data into Excel from different source systems like SQL Server, PostgreSQL, Workday, Business Object, DB2, and Oracle PeopleSoft to visualize in Tableau Desktop
• Worked with report development Manager and other team members on gathering report requirements based on existing reports and dashboards in Business Objects.
• Worked in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Geographic Map, Pie Charts, Bar Charts, Page Trails Chart and other various charts to provide better visualization.
• Developed drill through reports in dashboard as per business requirements. Formatting Tableau worksheets for better look and feel as per the requirements.
• Created complex dashboards for HR in areas like Attrition, Demographics, Recruiting and Internal Transfer Movement.
• Developed dashboard with usage data of PostgreSQL to track usage. Designed and maintained active and non-active tableau users report to help People Analytics team to better understand usage growth.
• Writing SQL to work with Tableau Dashboards and rectifying the errors in Tableau visualization as they occur based on business logic.
• Maintained scheduled subscriptions (with email notifications) of several SSRS reports to specific users and groups
• Designed and developed crosstab reports in Workday and scheduled them to share it with specific group of users.
• Involved in improving current tableau visualization after the feedback of end-user to better leverage the data visualization according to specific department need.
• Published Reports, workbooks & data source to Tableau Server and exporting the reports in different formats.
• Trained several end-users on existing HR dashboards to help understand complex reports in seamless manner. Created technical and training documentation as well for end to understand existing reports in Tableau
• Involved in Full Life Cycle Development of Reporting Projects, includes Requirements Gathering/ analysis, Design, Development, Testing and Production rollover.

Confidential, Bingham Farms, MI

Tableau/BI Developer

Responsibilities:

• Created complex formulas and calculations within Tableau to meet the needs of complex business logic
• Worked in different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Heat maps and Highlight tables.
• Proficient in creating Aggregated Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels using Tableau Desktop.
• Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published them to Tableau Server.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Developed various data connections from data sources like DB2, SQL Server, Teradata, etc., to Tableau Desktop for report and dashboard development
• Created Technical Documentation for reports and maintenance/enhancements of all the existing Tableau Dashboards and Reports.
• Transferred data from various sources like MS Excel, MS Access, and SQL Server into a centralized data warehouse using SSIS.
• Used various Data Flow Transformations, like Lookup, Derived Column, Data Conversion, Union All, Multicast and Copy Column while developing the SSIS packages.
• Involved in query optimization for faster processing of queries.
• Implemented Power BI Power Query to extract data from external sources and modify the data to generate the reports.
• Expertise in publishing Power BI reports of dashboards in Power BI server and scheduling the dataset to refresh live data in Power BI server

Confidential, Atlanta, GA

Tableau Developer

Responsibilities:

• Designed Tableau Workbooks, cross-tab Reports and maintained them on Tableau Server.
• 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.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Designed multiple Dashboards for Reporting teams, helping them to convert from manual reporting.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from SQL Server and MS Excel.
• Creating Conditional Block according to the client requirements and created multiple Dashboards.
• Scheduling the Reports on quarterly, monthly and weekly according to the client requirements using Report Studio.
• Understand Software/System components and associated specifications and Identify new feature requests and work with Business and Engineering team to develop new database based on the Business Requirements.
• Scheduled and Monitored SQL Server Agent Jobs to run various SSIS packages in SQL Management Studio.