SUMMARY

Accomplished business intelligence, data warehousing, and data management with over 6 years of extensive, diverse experience working with organizations that are leaders in their specific domain. Consistently focus on BI Governance as the driving force to assure that the investments in BI delivered business value enabling organizations to achieve and maintain a strong competitive advantage. Deep ability to understand business requirements, articulate a vision, evaluate risks and define roadmaps to build and strengthen the organization’s capabilities, processes, and infrastructure/system investments.

TECHNICAL SKILLS

Platforms: Z/OS, VM, Windows, Linux, UNIX, Microsoft, CICS, Stored Procedures, Batch

Tools: Microsoft Office (Word, Excel, PowerPoint, Access), Syncsort, SMP/E, ETL, JDBC, SQLJ

Data Platforms: DB2, Oracle, MS/Access, Datacom, VSAM, BDAM, BSAM, TCP/IP, DB2II (Federation), EMC, R programming

Database Tools: ERWIN, Embarcadero, IBM’s Admin, CA/Platinum, Query Monitor, SQLPA, Automation, DB2 Util, Omegamon, Explain, EEE, BMC, Power BI/DW Concepts.

PROFESSIONAL EXPERIENCE

Confidential

TABLEAU ADMINISTRATOR

Responsibilities:

• Setting up active directory on the tableau server for the effortless password management for the single sign on in the Salesforce and to view the embedded dashboards.
• Demonstration of the tableau dashboards and its functionality to the business users for the self - service business intelligence.
• Ensure user login access, server level, and database level access to application users and developers.
• Connecting and extraction to different data sources including Teradata, MS SQL Server, flat files using ODBC driver installation on the tableau server machines.
• Developed tableau dashboard landing page for the embedding into Salesforce in order to provide integrated views and navigation inside Salesforce for the users.
• Creating daily, weekly and monthly reports in Cognos for the internal teams and external vendors.
• Addressing the Performance and other Production issues with the Cognos reports.
• Best practices to enhance the response time of tableau dashboards and speed for the embedded dashboards.
• Tableau administration and development roles and helping the client with the issues of data connections, extraction and maintenance.
• Tableau server and desktop upgrade from 8.3 to 9.0 to 10.3

Confidential

TABLEAU DEVELOPER/ ADMINISTRATOR

Responsibilities:

• Monitor server activity/usage statistics to identify possible performance issues/enhancements
• Run cleanup and create backups of the database/ Performance tuning for Tableau server
• Upgrade server software
• Enforce policies; assist users with workflows
• Upgrading servers
• Help in migrating from tableau 9x to tableau 10x
• Production and Developments
• Adding additional nodes if needed
• Help analytics teams in building drill-down visualizations as well as prototype dashboards
• Installation of tableau software unto user laptops
• Licensing of installed tableau setup
• Upgrading systems from lower versions of tableau to current versions
• Gather data from different data sources like MySQL, Oracle and Sql Server.
• Develop reports, dashboards using Tableau 8.3 for quick reviews to be presented to Business and IT users.
• Developed POCs by building reports and dashboards using Tableau to perform statistical analysis of large data.
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control.
• Developed Ad-hoc reports using Tableau Desktop, Excel.
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis.
• Used SQL Server Reporting Services (SSRS) and SQL Server Management Studio 2008 -SSIS, SSAS, and SQL Profiler, including Crystal Reports to run scripts and maintain stored procedure and code functions across company's Databases.
• Performed schema changes in the database per request and met with clientele and with various subgroups for requirement gathering in order to allow self-extracted reports and created critical field reporting tools for Enterprise Data Management customer segments

Confidential

TABLEAU DEVELOPER ADMINISTRATOR

Responsibilities:

• Contract Interacted with business users for gathering requirements for analytics and dash board development
• Developed various dashboards, used context filters, sets while dealing with huge volume of data.
• Used excel sheet, flat files, CSV files to generate Tableau adhoc reports.
• Designed dash boards for actionable, non-actionable complaints from Multidimensional database.
• Generated dashboards to compare data using dual axis for comparison.
• Generated Dashboards by joining multiple complex tables.
• Generated dashboard for Finance team, provided security by using user filters.
• Design, build, and maintain Tableau server and desktop environments;
• Monitor Tableau server activity/usage statistics to identify performance issues/enhancements;
• Upgrade server software on a quarterly basis and perform patching as necessary;
• Work with product owners, development teams, and program managers as necessary to design and implement new solutions or remedy any issues
• Engage with software vendor(s) as needed to contribute to roadmap discussions as well as incidents

Confidential

Data Analyst/ TABLEAU DEVELOPER

Responsibilities:

• Involved in design and architecture of the entire project flow and integration with third party tools.
• Interfaced with Business in understanding the present functionality of Planner Reports and defining the phases in which the development would be done.
• Experience in ACTIVE-X script tasks for file verification, e-mail notifications and data transformation tasks in DTS for logging records and future Agent Term Dates drop.
• Creates technical specifications, test plans and test data to support ETL processes
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS packages before migration, scheduling jobs for DTS packages.
• Expert in cleansing data for data consistency whether the data source is a single system or multiple disparate sources
• Expert in Merge Join transformation, which can take two different inputs and merge them together by comparing a set of key columns, which performs different types of joins.
• Cleaned, created, massaged & integrated (ETL) Analytics data from Emails, Marketing & SalesForce so clean and relevant data is available for Marketing Dashboard in Tableau, using, Vsql, perl & Shell
• Created Reports for Marketing and Finance in Tableau based on the all the Analytics Data from Multiple Sources of Data residing in Vertica DB with 35 TB of data.
• Designed and Developed DB with Tables, Views, Triggers and stored procedures for SalesForce Data for Marketing Dept., updated daily fromSalesForce.com, with scripts in Perl & Unix Shell.
• Created Daily batch feeds to ingest Data from various Data Sources for Marketing Dashboard.
• Implemented complex requirements with many & multiple types of reports for multiple clients each had specific requirements for data, format, criteria, schedule, dynamic file names etc.
• All requirements for a report are specified in an Excel File Template by the User.
• The process developed, takes input requirements from Excel File and outputs multiple data feed files at multiple schedules, file names, and w/without control files, as specified.
• These Reports are verified and published to the clients per specified schedule.
• Integrated this Custom Report System with existing infrastructure that generates all the dat