SUMMARY:

• Business Intelligence professionalover 9 years of experience in Information Technology specializing in BI mid - tier Windows and Linux based solutions including architecture, planning, upgrades, performance tuning and security.
• Experienced in architecture planning and upgrades of Tableau Server, Tableau Desktop, and Tableau Reader in various versions of Tableau 10, 9.x, 8.x, Tableau 7.
• Master as a Tableau administrator including security, data connections, promotion of content etc.
• Installed & Configured Reporting Server 6.0 on a standalone database oracle 11g. 
• Expert in designing and development of Tableau visualization solutions using GUI standards and Created Business requirement documents and plans for creating dashboards.
• Experience in performance tuning the Hadoop cluster by gathering and analyzing the existing infrastructure. 
• Migrated applications from internal data center to AWS.
• Skilled in Analytics, Data Visualization techniques and building BI applications according to the requirements.
• Provided Support to the customer on a medium to high priority issues (P1, P2 level) and resolved with in SLA agreements
• Worked on designing data security models/architectures for appropriate data access and implemented data security design.
• Consistent in publishing multiple interactive dashboards, and workbooks from Tableau Desktop to Tableau Servers.
• Ensured Technical Quality, Accuracy, Efficiency and Adherence to timelines of solution delivery by consistent interaction with Business teams.
• Strong knowledge of data warehouse concepts including data modeling, data governance, metadata quality, ETL, reporting and analytics.
• Ability to work with both the business and technical experts and can build dynamic interconnected scorecards and dashboards and provide insights into operations.
• Involved in writing Java API for Amazon Lambda to manage some of the AWS services. 
• Responsible for research, data analysis and making recommendations for the development of new products or services in support of the marketing function
• Worked closely with statistical modelers in performing Cluster Analysis and Logistic Regression.
• Hands on experience in publishing various interactive dashboards, and workbooks from Tableau Desktop to Tableau Servers.
• Very Strong knowledge of relational databases - SQL Server, Oracle, Teradata and DB2. Proficiency in SQL including the use of SQL editors, stored procedures, database triggers and optimizing SQL statements.
• Extensive data extraction from numerous data tables, helped modelers to develop time series models for use in demand forecasting for marketing and product analysis.
• Hands-on experience in using Web analytics tools like Tealeaf and Web Trends and analyzing the click stream data.
• Proficient in UNIX, Batch and Power shell scripting.
• Knowledgeable in BI software development lifecycles/agile methodologies.
• Experience in working with data visualization/presentation tools like Qlikview, Datameer and maintaining the Platforms throughout the Enterprise.

TECHNICAL SKILLS:

Operating Systems: Windows 2012 R2, RedHat Linux, AIX

Databases: Netezza, Oracle, MS SQL Server, Redshift, MS Access.

Reporting Tools: Tableau, Cognos, Datameer, Qlikview, Spotfire.

ETL: Datastage v8.7, 7.5.2

Languages: C, C++, SQL, PL/SQL, Java

Web Technologies: Java Script, VBScript, HTML, DHTML

PROFESSIONAL EXPERIENCE:

Tableau Developer, Jersey City, NJ

Confidential

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements.
• Prepared Business Requirement Document and then converted that into Functional Requirements Specification oriented.
• Experience with cloud: Hadoop on AWS, Cloudera Manager.
• Involved in writing Java API for Amazon Lambda to manage some of the AWS services. 
• Migrated applications from internal data center to AWS.
• Experienced in Performance Tuning and Query Optimization in AWS Redshift. 
• Ability to design application on AWS taking advantage of Disaster recovery. 
• Exporting data from RDBMS to HIVE, HDFS and HIVE, HDFS to RDBMS by using SQOOP. 
• Wrote Hive queries for data analysis to meet the business requirements. 
• Created and extracted data to compare the performance of Tableau's Data Engine with star schema.
• Combined structured and semi-structured data using snowflake.
• Worked closely with business users to create reports/dashboards using tableau desktop.
• Designed and Developed Various Analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Published the developed dashboard, reports on the Tableau Server so that the end users having access to the server can interact the data.
• Scheduled frequency and time to refresh data for the when sources are published or exported to server.
• Identified problem trends and responded with appropriate actions needed and documented using guidelines.
• Was responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
• Interacted with Business partner to understand their business needs in identification of critical metrics and KPI’s.
• Included reference lines as per requirements and generated what if analysis reports for sales using forecasting logic.
• Created Prompts, customized complex calculations, Conditions and Filter (Local, Global) for various analytical reports dashboards and presentations.
• Modified Dashboards by including guided navigation links within the Interactive Dashboards.
• Created Backup scripts to take periodic backups for the content on Tableau server.
• Actively participated in clarification meeting with the Clients.
• Generated dashboards to compare the expected weekly sales vs projected sales used dual axis for comparison with consideration data flow.
• Provided customer support to Tableau users and Wrote Custom SQL to support business requirements.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.

Environment: Tableau 8, 7.x, SUSE-Linux -12, Oracle 10g, Autosys, Datameer, Access Manager, LDAPTOAD, PL/SQL, Windows 2008 Server.

Tableau Developer/ Administrator, Danvers, MA

Confidential

• Responsible for setting up, maintaining and automation of regular reports and scorecards (e.g., customer engagement/retention, feature performance and usage, monetization).
• Being Tableau Developer, involved in building schema objects to support business process change or enhancements throughout projects.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations and Parameterized using Tableau.
• Familiar with Installation, configuration, patching and upgrading of Tableau tool across the environments.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Involved in creating calculated fields, mapping data items and hierarchies.
• Created incremental refreshes for data sources on Tableau server.
• Implemented data blending on EMPI databases and generated interactive dashboards and also Involved in Planning, Defining and Designing data based on business requirements and providing documentation.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Analyzed the data source and handled efficiently by modifying the data types.
• Generated context filters and used performance actions while handling huge volume of data.
• Used Java Script API to customize the views, selects, filters, date and time.
• Interacted with business users for gathering requirements and enhance the feel of the applications to be developed.
• Expert in summarizing performance trends and depict problems in it.
• Maintained server activities, user activity, and customized views on Server Analysis.
• Used excel sheet, flat files and CSV files to generate Tableau ad-hoc reports, used batch scripts to automate this process.
• Developed standard reports, charts, drill-down reports, master detail reports and bursting reports using Report Studio.
• Designed dash boards for actionable, non-actionable complaints from Multidimensional database and optimized user experience.

Environment: Tableau 8.3, 8.1, Framework Manager, Query Studio, Report Studio, Event Studio, Metric Studio, Transformer, Life cycle Manager, Access Manager, LDAP, PerfMon, Unix, RHEL, MS Visio, Word, Excel, Access, HTML, XML SQL Server 2005, Windows 2003, SSIS, Oracle 11, DB2, Batch scripting.

Tableau Administrator, Charlotte, NC

Confidential 

• Upgraded Tableau Environments from 8.1, 8.3 to v 9.2.4, 9.2.9 and v10.
• Re-design Tableau architecture, security and creating various user groups by assigning row and column level security at application level, folder level and user level.
• Expertise in designing and Development of Tableau Visualization Solutions.
• Implementing a separate Tableau Environment for demo and training for external customers.
• Guided developers in redesigning complex dashboards for better performance.
• Creating new Tableau sites for new onboarding customer hospitals.
• Deployed of new dashboards to Tableau Production and setup embedded credentials for the backend Netezza databases.
• Developed daily scorecards for monitoring user activity on the Production servers and utilized these reports for charge back to the customers.
• Installed a three server Tableau environment for the BizAnalytics department.
• Best practice advice for internal development teams in auto import options for Data sources.
• Extract, creation and maintaining for each Tableau site. Setup scripts to cleanup log and temp files.
• Setup Schedules on which Dashboards were dispersed to consumers.
• Performance test evaluations to check production worthiness of dashboards.
• Closely worked with Tableau documentations on Tableau cases and provided technical support.
• Maintained and updated the Tableau License keys for Tableau servers and Desktops.
• Implemented Tableau SSO using SAML tokens.
• Working on self-service patching incompliance with the company wide quarterly patching.
• Worked with the network, storage and OS teams to setup Eternal facing URLs, preemptive storage addition and patching.
• Solved business requirements and delivered reporting projects on cross function peers to the clients
• Worked on a complex upgrade projects where content from two versions of Production environments are merged into a single Production platform.
• Setup scripts to take weekly backups of the Tableau repository.

Environment: Tableau 10.0, 9.2.9, 8.3, 8.1, MS Visio, Windows 2003, Windows 2008 R2, Oracle 11, DB2, LDAP, AD, Shell Scripting, RHEL6/Tomcat/IBM HTTP/DB2, Perfmon.

Developer

Confidential

Responsibilities:

• Gathered User requirements and review them from a technical perspective and conducted meetings with end users to establish business rules, schedule deliverables and identify potential issues that could impact the development effort.
• Involved in Installation, Configuration, Customization and Maintenance of Cognos Products.
• Interacted with the user community and development teams for gathering information regardingthe model used in Framework manager.
• Created scorecard reports and dashboard using Cognos 8 report studio.
• Deployed the obtained reports from development to testing and then to productionby deployment tool.’
• Generated Ad-hoc visualizations reports as per management requests from live environment for on spot validation.
• Manage data flow from data warehouse to visualization tools. Perform data auditing and troubleshooting.
• Work with Different team includes Offshore coordination, Solution drive, Project Management.
• Trained business users in Cognos connection and query studio.
• Provided SME support for end-users of the system, including: training, responding to questions, resolving problems and providing ad-hoc reporting and mentor other Client system administrators.
• Migrated existing Cognos series 7 reports to Cognos 8 BI.
• Extensively used Quest's Toad for database analysis, performance tuning and trouble shooting.
• Involved in unit testing and functional testing to finalize the report accuracy.

Environment: Cognos, Framework Manager, Data Manager, Query Studio, Report Studio, Informatica 6.2, Adobe Flex 2.0, SQL 2005, SSIS, Event Studio, Metric Studio, Map Manager, Crystal Reports, Unix, Apache Tomcat, Windows 2003, iSeries access to AS/400 - DB2.

Developer

Confidential

Responsibilities:

• Participated in Joint Application Development session (JAD) to gather information about clients need and to get familiar with vendor’s product.
• Wrote T-SQL statements to ensure data consistency by filtering corrupt data and implemented various constrains and triggers to preserve data integrity.
• Developed effective stored procedures, functions to implement business logic.
• Utilized BCP to move in or out data from different sources.
• Designed, tested and managed disk/tape Backups and Recovery strategies.
• Used Bulk Insert to copy large amount of data into database.
• Backed up master & system databases and restored as well.
• Design and automation of disaster recovery procedures.
• Developed Merchandise Business Analysis report for Top management and Category Buyers using reporting services (SSRS) and deployed to report server.
• Migrated data from text files and Excel spreadsheets to SQL Server databases using Integration Services (SSIS)
• Maintained and created Replication, Including Merge, Transaction, Snapshot and also implemented data transformation into published articles.
• Improved query performance, necessary for statistical reporting after monitoring, tuning, and optimizing indexes by using Performance Monitor, Profiler, and Index tuning wizard.
• Participated in testing and debugging to validate data after the export/import/delete.

Environment: SSRS, SSIS, SQL  Server, VB 6.0, XML, VB.Net, batch scripting.