SUMMARY

• 7+ years of experience in Data warehousing and Business Intelligence technologies along with 3+ years of data visualization using Tableau Desktop
• Tableau tools include Tableau Desktop versions 6/7/8.1/9.x, Tableau Reader, Tableau Public, and Tableau Server.
• Created dashboards by using Level of Detail concept (LOD’s)
• Produced attractive visuals/dashboards to convey the story inside the data
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects
• Administered user, user groups, and scheduled instances for reports in Tableau Server
• Strong knowledge of Software Development Life Cycle (SDLC)
• Good understanding and background in financial services, media, and telecom industry
• Comfortable working independently or with team with limited supervision and working in tighter schedules, meeting deadlines, and ability to learn on the fly
• Ability to interact professionally with a diverse group including executives and managers
• Technically hands - on commercially experience mainly with full range of BI Skills with Tableau 7x, Tableau Desktop, Tableau Server and Tableau Public, MS SQL Server, SSIS, SSAS, SSRS, MS Performance Point Server (PPS 2007) and Informatica
• Expertise in Tableau BI reporting tools & Tableau Dashboards Developments & Server Administration
• Designing, building and deploying, publishing data analysis reports/dashboards for large volumes of data
• Mastered in creating solution driven dashboards by developing different chart types including Crosstab’s, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop
• Extensive experience in creating several reports such as drill down, drill through reports, parameterized reports, linked reports, Heat Maps, Dual Charts, Action Dashboards and cascading reports using Tableau
• Experience in designing stunning visualizations using Tableau software and publishing and presenting dashboards on web and desktop platforms
• Experience in configuring reports from different data sources using data blending
• Implemented Tableau/oracle BI security at the Data (Data security) and object (Roles and Permissions) security
• Proficient in developing Entity-Relationship diagrams, Star/Snow Flake Schema Designs, and Expert in modeling Transactional Databases and Data Warehouse
• 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
• Expertise in Teradata, Oracle, SQL Server, Informatica, SSIS, SSRS, UNIX, Microsoft Office Suite
• Proficient Star Schema dimensional modeling, which includes understanding business processes, modeling dimensions, hierarchies and facts
• Posses’ strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues
• Good knowledge of Business Intelligence/Data Warehousing BIDW Fundamental architecture concepts, dimensional modeling, requirement gathering
• Proven as a dedicated, worth full and energetic well-rounded Business Intelligence/DWH background professional in growth oriented reputed organizations that gives me scope to apply my knowledge and skills
• Self-motivated high-energy person who enjoys challenging assignments and good at working on multiple engagements

TECHNICAL SKILLS

BI Tools: Tableau 7.x/8.x, Micro Strategy, SSRS, Alteryx

ETL Tools: Informatica, Data Stage, Microsoft SQL Server Integrated Services(SSIS)

Requirements Management: Requisite Pro, Microsoft Office (Word, PowerPoint Excel)

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst

Databases: Teradata 13.10, Oracle, SQL Server, DB2 etc

Document management: Visual Source Safe 6.0, Share point, Ultra Edit, Documentum

Programming Languages: C, C++, HTML, SQL, PL/SQL, XML.

Data modeling: Power Designer, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Tableau Developer/Data Analyst

Responsibilities:

• Expertise in creating dashboards by extracting data from different sources.
• Performed conversion of Micro strategy reports to Tableau Workbooks.
• Micro strategy 9.x, Teradata.
• Created dashboard using parameters, sets, groups and calculations.
• Extensively experienced in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Experience in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Configured in creating data blending in case of merging different sources.
• Experience in creating a dual-axis bar chart with multiple measures.
• Mastered in extraction, transformation and loading of data directly from different source systems like flat files, Salesforce, Oracle, Teradata and SQL Server.
• Developed LOD reports on various KPI’s.
• Performed Tableau type conversion functions when connected to relational and SAP BW data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Experience in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
• Manages platform admin functionalities including installations/configuration, upgrades, patches, change management, performance tuning, standards/ best practices, mentoring, metadata management, cluster/distributed management, cache/ history management, user management, scheduling.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: Tableau 9.0, Windows, SQL Server, Excel, Data stage and other internal source applications

Confidential, St Francisville, LA

Tableau Developer/Data Analyst

Responsibilities:

• Extensive experience in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Projected and forecasted future growth by developing reports to show in detai.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• 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.
• 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.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Collaborate with development team on data approach for coding Understand data guidelines, and understand data sources available, what is new based on requirements, and how the project will impact common data stores
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: MySQL, Oracle, Essbase, Teradata, Source System Applications and Data Visualization Tableau 8x Desktop and Server, MS Excel.

Confidential, Bloomfield, NJ

Tableau Developer/ Data Analyst

Responsibilities:

• Mastered in reviewing requirements and data sources form MS Excel and MS Access for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
• 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 various types of charts to provide better visualization.
• Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Review Vendors Status Reports with Project Team and created visualization for budget forecasting.
• Published views and dashboards in Tableau Server for auditor review.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
• Performed troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Micro Strategy (Desktop/Server), Teradata 13.10, Oracle, SSIS, SSRS, Teradata SQL Assistant, Teradata Administrator, SQL Developer, Power Designer, MS Office Suite (Word, Excel, PowerPoint).

Confidential

BI Developer/ Data Analyst

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements
• Elicit business solutions to develop SOX compliance into the existing procurement workflow executed through IT channels.
• Performed Analysis of Reference Data, Data sets and Asset classes in order to bring data into the central repository.
• Worked extensively with MS Visio and Rational tools to document requirements.
• Created the AS-IS and TO-BE process flow diagrams.
• Defined the scope of the project based on the gathered business requirements including documentation of constraints, assumptions, business impacts, project risks and scope exclusions
• Defined functional business requirements, analyzed client requirements, and generated workflow processes
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Assisted in project management activities like planning, development, task allocation, project execution
• Provided full project life cycle flow charting, analysis and documentation.
• Responsible for extracting, transforming, and loading data from ODS, flat files and placing it into data warehouse.
• Designed, developed, and tested the jobs using Data Stage
• Involved in some part of performance tuning.
• Developed simple and complex jobs using Data Stage to load dimensions and fact tables as per STAR schema techniques.
• Created Data Definitions and help maintain Metadata repository.
• Utilized Erwin for reverse engineering the database from DDL scripts.
• Experience in using Micro Strategy in creating and managing reports for an organization.
• Created documentation, worked with users for new module enhancements and testing.
• Designed and Developed Drill through Reports, Dashboards and modified the existing Dashboards using Micro Strategy desktop.
• Interacted with the End users on a regular basis for resolving issues pertaining to the reports.
• Defined project milestones, schedules, monitoring progress and updating plans using MS Project.
• Prepared monthly status reports for Enhancement Requests to the project team that was used in efficient tracking and monitoring of open issues of the project.

Environment: Oracle, Toad, Data Stage, Micro Strategy, UNIX, Microsoft (Word, Access, Excel, Outlook), MS VISIO, MS Project.

Confidential

SQL Server Developer

Responsibilities:

• Worked on the project that involved development and implementation of a data warehouse.
• Created Store Procedures, Functions, Triggers, Indexes and Views using T-SQL in all the environments for SQL Server 2000.
• Developed DTS Packages to transfer the data between SQL Server and other database and files.
• Scheduled jobs & Re-Scheduled on Production Databases.
• Created report form with Stored Procedure using T-SQL
• Wrote and optimized Triggers, Stored Procedures and Queries in T-SQL.
• Created database objects like tables, views and indexes.
• Created and modified stored procedures, triggers and cursors.
• Designed, developed and modified various Reports.
• Handled and managed customer relationship management system.
• Designing and modeling database according to Requirement. And made changes according to it.
• Designed, developed, and tested complex queries for Reports distribution.
• Built and performed user acceptance testing on modified reports.
• Skilled in running jobs in Enterprise Manager using job-scheduling tool.

Environment: MS SQL Server 2005, MySQL, Lotus Notes, MS Access, MS Office Suite (Word, PowerPoint, Excel), SSRS, SSIS