Sr. Tableau Developer Resume
Nyc, NY
SUMMARY
- Over 7 years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
- Extensive Tableau Experience in Enterprise Environment and Tableau Experience including technical support, troubleshooting, report design and monitoring of system usage.
- Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
- Extensive experience working as a Business Intelligence Consultant with specialization in Business Objects 6.0/ 6.5/ XIR2/ Crystal XI and WebIntelligence.
- Extensive experience working in Windows, UNIX, LINUX environments.
- Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star - schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), Mainframes, SAP BW, MS Access and client/server applications.
- Experience working with Data Quality tools Data Insight and Exeros Validator and Discoverer.
- Extensive experience working on trend reports, service provider functionality, sample assessment, online business intelligence, fleet management systems and capital markets.
- Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
- Worked extensively with the major functionality of BO like breaks, alerter, filters, sorts, query Prompt and Drill filters.
- Professional in writing complexFormulas,Sub Reports,Summary Reports,Cross-Tabsin DESKI & WEBI against Universe and Relational data sources.
- Providingtechnicalandanalyticalexpertise in responding tocomplex,specializedreport requests requiringhigher-level data analysisanddata management services.
- Involved inTrouble Shooting, Performance tuning of reportsand resolving issues with inBusiness Objects EnterpriseandReports.
- Installation, configuration and administration of SAP Business Intelligence 4.x suite and Business Objects Enterprise XI R1/ R2 / 3.x.
- Extensively usedPublishing Wizard,Import Wizardand Central Management Console.
- Deployed the reportsonto InfoView andScheduled Reportsfor the use of end users and customers.
- In-depth knowledge on Tableau Desktop, Tableau Viewer and Tableau Server.
- Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
- End to end experience in designing and deploying data visualizations using Tableau
- Extensive working experience inPackages, Procedures, Cursors, Triggers and UNIX Scripting.
- Experienced in tuning Long running SQL queries for better performance.
- In-depth knowledge in formal Systems analysis design, implementation of Operational/Database systems, utilizing Oracle RDBMS Methodologies.
- Expertise in using Version controllers likeClear Quest,Clear CaseandPVCS.
- Stronginterpersonalskills with demonstrableverbalandwrittencommunications to maintain effective work relationships with all levels of personnel.
TECHNICAL SKILLS
Languages: HTML, PL/SQL, SQL, XML, Java/J2EE
Applications: Eclipse, NetBeans, Oracle SQL Developer
Reporting tools: Crystal reports XI/2008, Business Objects XI R1/R2/R3.x/4.x, BO Universe Designer, BO Web intelligence, Tableau Desktop, Tableau Server
Databases: Oracle 8i/9i/10g/11g, MS Access, MS SQL Server 2000/2005/2008 Operating Systems Windows XP/7/8, MS-DOS, Sun Solaris, Linux
Web/App Servers: Apache Tomcat, Web logic Server 8.1/9.2/10, MS IIS 5/6.0, JBoss
Packages / Tools: MS Office, Toad, Putty, FrontPage 2000.
PROFESSIONAL EXPERIENCE
Confidential, NYC, NY
SR. TABLEAU DEVELOPER
RESPONSIBILITIES:
- Worked as Tableau Developer in standardizing Tableau for shared service deployment.
- Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
- Created SSIS packages in SQL Server 2008 for sources database for Tableau dashboards.
- Extensively used data blending, embed functionalities in Tableau.
- Installed Tableau Server in Dev, QA, UAT and Prod environments.
- Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
- Monitored Vizql and WGSQL Server activity to track performance and system stability.
- Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
- Created report schedules, data connections, projects, groups in Tableau server.
- Involved in license management SLA’s with Tableau support.
- Created scripts on windows task scheduler for auto sync of users from Active Directory groups.
- Defined and created procedures to install Tableau desktop in silent mode.
- Defined best practices for Tableau report development.
- Administered user, user groups, and scheduled instances for reports in Tableau.
- Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
- Provided 24/7 production support for Tableau users.
- Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues
ENVIRONMENT: S: Tableau Server v6/v7/v8, Tableau Desktop v6/v7/v8, Windows Server Standard R2, Clearquest, Clearcase, Oracle 11i, Netezza, Sybase, Crystal XI, Info view, CMS, CMC, Excel, JAVA, J2EE, Tomcat., TSQL, UNIX, Linux RHEL 5.4.
Confidential, REDMOND, WASR.TABLAU DEVELOPER/ANALYST
RESPONSIBILITIES:
- Involved in creating dashboards and reports in Tableau 6.1.
- Created report schedules on Tableau server.
- Worked as technical architect in developing strategy, architecture, and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
- Created and assisted users in Tableau dashboard development
- Administered and provided production support for CHOP Enterprise wide Tableau application consisting of multiple key functional business domains.
- Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
- Defined and created procedures to install Tableau desktop in silent mode.
- Defined best practices for Tableau report development.
- Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
- Administered user, user groups, and scheduled instances for reports in Tableau. Installed patches on server and documented upgrade plan form Tableau 6.0 to Tableau 6.1
- Provided 24/7 production support for Tableau users.
ENVIRONMENT: Tableau Server 6.1, Tableau Desktop 6.1, MYSQL Server, MS SQL Server 2005, MS SQL Server 2008, Oracle 11i, Netezza, Sybase, Crystal XI, Info view, CMS, CMC, Excel, JAVA, J2EE, Tomcat., TSQL, UNIX, Linux RHEL 5.4.
Confidential, HERNDON, VA
SR.BO/DATA FEDERATOR/WEBI REPORTS/SME
RESPONSIBILITIES:
- Managed data federator for Equity Management Systems and Human Resources universes.
- Developed and deployed WebI and Crystal Reports in BO XI 3.1
- Involved in complete SDLC of reports lifecycle on WebI and Crystal XI.
- Involved in requirement analysis and definition of business process for COMP payroll business process.
- Coordinated with system analyst, deployment teams and DBA in deployments
- Developed mission critical Human Resources payroll WebI reports with multiples queries.
- Supported private equity management team day to day adhoc report requests.
- Performed UAT of Web Intelligence reports in development
- Assisted BODI team and Data Federator team in troubleshooting data discrepancies and mappings.
- Provided roadmap for Business Objects Reports.
- Supported BO environments in dev, test and prod.
- Extensively used Crystal Integration kit in delivering reports through Infoview, external web interface.
- Business View Manager (BVM) was used extensively to create user defined prompts for financial reports.
- Extensively used BO security features on folders, categories, universes and reports to protect sensitive data access.
- Worked extensively with report level variables in WebIntelligence.
- Assisted in migration of reports and universes from Development to QA and Production.
- Worked extensively with @functions such as (@aggregate aware, @select, @prompt, @where) to overcome the problems with database when integrating with BO
- Created row-level and object level security.
- Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts.
- Worked extensively with the major functionality of BO like Breaks, Alerter, Filters, Sorts, Query Prompt and Drill filters.
- Created and developed Tableau data visualization reports for KPI’s.
- Trained users in Tableau functionality.
- Worked closely with client team members in developing and delivering BOBJ blueprint deliverables.
- Coordinated with Data Federator and Data Integrator teams in resolving issues with data sources.
- Worked with Business View Manager in creating cascading list of value prompts for Crystal Reports.
ENVIRONMENT: S: Business Objects 3.1, MS SQL Server 2005, MS SQL Server 2008, Data Federator, SAP BVM, SAP BODI, Web Intelligence 3.1, Crystal XI, Info view, CMS, CMC, Excel, JAVA, J2EE, Tomcat., TSQL.
Confidential
BUSINESS OBJECTS DEVLEOPER
RESPONSIBILITIES:
- Responsible for analyzing the new requirements and writing the functional requirement documentation and estimating the man-hours.
- Co-coordinated with developers and business users in formulating report requirements for CAP (Corrective Action Program).
- Involved in blueprint process by designing User Training Manual for training end users in reporting functionality and performed end user training through online and in-class sessions.
- Reviewed business cases and managed report development schedule from design to release.
- Involved in design/approach, project team calls and meetings.
- Translated business requirements into architecture and functional requirements.
- Addressed system-specific issues, and evaluated alternate approaches and new additional requirements
- Installed and configured Business Objects Enterprise edition XIR2.
- Administered user security, and folders.
- Reviewed data mapping of Business Objects Universes from BO 6.5 to XIR2.
- Created project plan for conversion of reports from Spescom eBDirector to Crystal XI.
- Assisted in business analysis for Calver Cliffs, e Ginna, Nine Mile Point universes.
- Conducted reporting sessions and presentations for business users.
- Created Aliases and Contexts for resolving Loops and checked the Integrity of the Universe.
- Worked extensively with @functions (@aggregate aware) to overcome the problems with database when integrating with BO
- Updated existing universes in XIR2 with additional objects according to user requirements.
- Communicated project status to the Project Portfolio Manager (PPM), client(s), stakeholders and upper management.
- Consolidated canned reports from different data sources that included Excel, Oracle and Access.
- Involved in documenting alternate approaches for data consolidation for different business units.
ENVIRONMENT: S: MS Project, MS Access, MS Excel, TOAD, asp. NET, Windows XP, UNIX, Web Intelligence 6.1.3, Oracle 9i, Teradata, Share Point, MS PowerPoint, SQL, BO 6.5, ClearQuest, Business Objects XIR2, CMC, Info View, UNIX.