SUMMARY

• 6+ years of experience in Data warehousing and Business Intelligence technologies along with data visualization using Tableau Desktop.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Created 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.
• Tableau tools include Tableau Desktop versions 6/7/8.1/9.x, Tableau Reader, Tableau Public and Tableau Server.
• Expertise in Data Discovery and Advanced Visualization concepts.
• Experience creating joins, joins with custom SQL & blending data from different data sources using Tableau Desktop.
• Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
• Performed thorough data profiling to understand the quality of source data and to find data issues using IDQ.
• Experienced in developing Confidential - SQL (DDL, DML) and in developing and deploying packages within SSIS.
• DTS packages to SSIS, package migration wizard and storage management.
• Effective Skills on DTS, SSIS, SSRS, SSAS, XML, Service Broker, MDX, TFS, Full Text, Data Cleaning, Data Scrubbing and Data Migration.
• Hands on experience with Actimize Full life cycle Implementations in the following areas:KYC, CDD, EDD, SAM, AML Monitoring, Watch list Filtering and Case Management.
• Proven knowledge of working with various Tableau Desktop functionalities & capabilities (Filters, Hierarchies, Sorting, Sets, Parameters, Custom Groups, Creating Story, Mapping, Custom Geocoding, etc.)
• Guiding the team and organization on how to use Agile/Scrum practices and values to achieve a high level of customer satisfaction.
• Produced attractive visuals/dashboards to convey the story inside the data using different data sources such as Teradata, Oracle.
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD. Expert on creating multiple kinds of Power BI Reports and Dashboards.
• Worked with Teradata utilities like BTEQ, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Responsible for developing Sun's Data Center management and automation products. This includes functions such as monitoring, server provisioning, virtualization and cloud management.
• Established Scrum as the project management framework, coached teams to embrace agile values, principles and practices, mentored junior scrum masters and successfully led multiple distributed technology teams on their agile transformation journey.
• Advance development and deployment of industry specific business solutions built on and around Office 365, Microsoft InfoPath, SharePoint, Project Server, Business Intelligence (Power BI), Dynamics CRM, Windows Server, SQL Server, Office, Exchange and Windows client and mobile technologies.
• Knowledge of CIDR to reduce the problem of wasted address space by providing a new and more flexible way to specify network addresses in routers.
• Administered user, user groups, and scheduled instances for reports in Tableau Server.
• Expertise in using Version controllers likeClear Quest,Clear Case, SVNandPVCS.

TECHNICAL SKILLS:

BI/Visualization Tools: Tableau Desktop6/7/8.1/9.x, Tableau Public 8.x/9.x, Tableau Reader 8.x/9.x, Tableau Server 8.1/9.x, Cognos 8.4/10.1.

Programming: SQL, UNIX Shell, XML, HTML, C, Java, Java script.

Utilities: MS Office Suite, MS SharePoint, MS Project.

Databases: Oracle 10g/11g, DB2, Teradata, SAP HANA, SQL Server 2008 R2, MS Access, MS Excel, MS SQL Server 2005.

Platforms: Windows7/8/2003/NT, MS Server 2008 R2, Mac OS.

Networking: TCP/IP, LAN/WAN Technologies.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Tableau / BI Developer

Responsibilities:

• Involved in creating dashboards by extracting data from different sources.
• Oversee Tableau/Alteryxon-boarding process, deliver training, consultation and support services.
• Experience in administering user, user groups, and scheduled instances for reports inTableau.
• JSONand BSON structure manipulation for Adhoc Reporting functions and data mining.
• Communicated with the developed Web Services using REST Client andJSON.
• Analyzed and built data visualization models usingAlteryxand Tableau.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Set-up Enterprise Gateway and SSAS Connector on Azure VM for Power BI Report Deployments.
• Expertise in working with Informatica Data Quality (IDQ) in the discovery and coding of cleansing, de-duping and enrichment processes used to enhance the quality of information.
• Analyzed the data based on requirements, wrote down the techno-functional documentations and developed complex mappings using Informatica Data Quality (IDQ) 9.6.1.
• Created/modified reference tables for valid data using IDQ Analyst tools.
• Initiating and facilitating all agile ceremonies and providing Agile coaching to teams on all aspects of the project management framework, with a strong focus on Scrum practices.
• Worked on migrating reports from legacy systems Cognos 8.4.1 to Cognos 10.2.1.
• Created complex, multipage reports using most of the Cognos functionality (such as Prompts, Conditional Formatting, and Conditional Rendering).
• Worked on Cognos 8 Suite (Event Studio, Query Studio, Analysis Studio, and Report Studio).
• Defined data sources and their associated connections in Cognos Connection.
• Experience in Extraction, Transformation and Loading (ETL) of Data into Data Warehouse using Informatica Power Center 9.0, 8.x, versions.
• Designed the Workflows, Mappings, Creation of Sessions and scheduling them using Informatica Power Center 9.0, 8.6.

Environment: SQL Server, Tableau Desktop 8.x/9.x, Tableau Server, SAP HANA, SSIS, MS Office Suite, Oracle, MS-SQL Server, Teradata, Salesforce, CSV, Informatica Power Center 9.0,8.x, MS Excel, WordPress, HTML, CSS, JavaScript andjQuery.

Confidential, Atlanta, GA

Tableau / BI Developer

Responsibilities:

• Involved 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.
• Migrated tables from Oracle to Teradata.
• Managed scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos Connection.
• Utilized Cognos Connection to administer and scheduling reports to run Confidential various intervals as well as the Report Server.
• Managed scheduling of reports, public and my folders and distribution lists, users, groups and roles using Cognos Connection in COGNOS.
• Wrote Bteq and Mload scripts to load data from Oracle to Teradata.
• Migrated Cognos Reports from one environment to another environment for SIT/UAT Testing.
• 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.
• Responsible for creating user groups and roles to manage security in Cognos Connection.
• Creation of customized Mload scripts on UNIX platform for Teradata loads using Ab Initio.
• Written Teradata BTEQ scripts to implement the business logic.
• Modified and updated the Framework Model when new metadata is imported, created and published packages using Framework Manager.
• Hands on with Teradata Queryman to interface with the Teradata.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Environment: Windows XP, Tableau Desktop 7 & 8.1, Tableau Server, Teradata, SSIS, Salesforce, CSV, Informatica, MS Office Suite, Oracle SQL Server R2, MS Excel.

Confidential, Atlanta, GA

Tableau Developer

Responsibilities:

• Involved 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.
• Involved in 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: Windows XP, MS Visio, SQL Server, MS Access, MS Project, Tableau Desktop, Tableau Server, Oracle SQL Server, MS Excel, MS Access, Win Server 2008 R2, Active.

Confidential

Sql Developer

Responsibilities:

• Involved in Database design, creation and maintenance of Databases.
• Managing the use of disk space, memory & connections by monitoring.
• Created tables and views.
• Created functions, stored procedures, triggers and constraints using Confidential -SQL.
• Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for production Database and supporting it.
• Server & Application fine-tuning & trouble shooting.
• Wrote maintenance plans and code optimization. Worked on database designing, logical and physical data modeling, worked on large scale data migration using SQL Scripts, stored procedures, triggers, views, etc.
• Recovered the backups of SQL Server production databases in test server environment.
• Analyzed poorly performing SQL queries to improve application performance.
• Coordinating with peer groups for Network, Infrastructure and DataCenterOperations.
• Built SSRS report to support reporting needs.

Environment: Windows XP, MS SQL Server 2005/2008, Windows 2000 Advanced Server, VB 6.0, and XML.