PROFESSIONAL SUMMARY:

• 8+yrs of experience in IT industry as BI Developer with Tableau and Business Objects with strong background in Databases and Data warehousing concepts.
• Expertise in Tableau 10.4/10.3/10.2/10.1/9.3/9.2/9.1/8.0 , Tableau Server, Tableau cloud, Tableau Online, Tableau Mobile, Tableau Public, Tableau Reader
• Designed several business dashboards using Tableau Desktop, Tableau Server, Tableau reader and Tableau Cloud
• Worked on different Tableau versions (Tableau 10.4/10.3/9.3/9.2/9.1/8.0/7.0 )
• Worked on several interactive dashboards with Filtering, highlighting, ability to combine multiple data sources, fast creation by a business user, easy sharing with support for existing security using several visual analysis best practices
• Setup and configuration of Tableau server 10.0/9.2 in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices.
• Worked on several interactive dashboards with Filtering, highlighting, ability to combine multiple data sources, fast creation by a business user, easy sharing with support for existing security using several visual analysis best practices
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.
• I worked on Microstrategy Developers are experienced designers with extensive.
• Designed, developed and implemented Tableau Business Intelligence reports.
• Create basic calculations including string manipulation, basic arithmetic calculations, custom aggregations and ratios, date math, logic statements and quick table calculations.
• Conducted ETL development in the Netezza environment using standard design methodologies.
• Assessed the Netezza environment for implementation of the ETL solutions.
• Collaborated with software architects to ensure alignment of the Netezza environment.
• Aws Redshift Cloud by using SQLWorkBench
• Representing data using the visualizations such using Charts.
• In WebFOCUS it’s an security layout that makes configuration difficult to accomplish without bringing in the vendor for installs.
• Responsible for verifying business requirements, ETL Analysis, ETL develop and design of the flow and the logic for the Data warehouse using Informatica and Shell Scripting
• Expertise in analysis, design and implementation of data warehousing applications using Teradata understanding the status of production, machine utilizations, web traffic, or other critical systems
• Combined multiple data sources using blending in Tableau to keep track of sensor data, operator inputs, and real - time systems all in one dashboard.
• Used Tableau’s flexibility to build a tabbed application with wide range of options like quick filters, calculated fields, dynamic interaction, flexible ad-hoc capability in various functional areas like finance, sales, marketing and HR
• Used SAML for configuration of Tableau Server SSO supplementing Kerberos authentication on the side
• Used Kerberos for user authentication thru Active directory (Win AD).
• Used Sign in Method using the REST API for successful sign in operations
• Setup of SSO between Tableau portal and Oracle.
• Used Kerberos for user authentication thru Active directory (Win AD).
• Performance tuning for the Tableau Visualizations and Tableau server for more than 150 concurrent users.
• Improved Reports performance in tableau using extracts and context filters.
• Published Workbooks by creating User filters and sites (User groups, access) so that only appropriate teams can view it.
• Created calculated fields to interact with parameters dynamically to visualize the data on the fly.
• Used the Tableau Online sync application to schedule automatic refresh tasks for extracts of data and to maintain on local network.
• Setup security profiles for various user groups and users using Tab admin and Tabcmd Tools.
• Created various User groups by assigning row and column level security at application level, folder level and user level.
• Configured the distributed Tableau Server environment for real-time replication and failover support. involved in loading data from Hive and imported to R for data analysis and visualization
• Involved in importing data from Hive to R for data exploration and data cleaning for developing predictive models as per requirements.
• Created a form and integrate it with the client's everyday
• Solved problems using a combination of JavaScript, JSON, and JQUERY
• Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards. Participated in day to day activities like creating workbooks, dashboard, published on server.
• Created cascading filters to filter the data within the hierarchy and prompt to specific filter that is applied by cascading.
• Good understanding of OSIModel , TCP / IP protocol suite ( IP, ARP, TCP, UDP, SMTP, FTP, and TFTP ). Used SQL to perform basic database administration.
• Strong knowledge on Java, PHP, JavaScript, JQuery, HTML, CSS, Bootstrap, JSON, XML .

TECHNICAL SKILLS:

DevOps Tools: Data Connectivity, Automation, Data science Integration, embedded analytics

Build Tools: Maven, Ant

Application Servers: Web Logic 9.x, 10.x, Apache Tomcat 5.x/7.x, JBoss 4.22. GA Web Sphere 6.x/7.x/8.x

Tableau Desktop, Server: 10.5/10.4/10.3/10.1/9.3/9.2/9.1/8.0

Database System: MS SQL Server, MySQL, PL/SQL, Oracle 9i/10g, IBM DB2, Sql WorkBench

Tableau: Tableau Cloud, Tableau Reader, Tableau Public, Tableau Mobile

Networking/protocol: DNS, DHCP, TCP/IP, NIS, NFS, SMTP, LAN, FTP/TFTP

Scripting: Perl, Python, JavaScript, Ruby, Bash shell, Power shell scripting

VMWare ESXi, Windows Hyper: V, Power VM, Virtual box, Citrix Xen

Cloud Environments: AWS Redshift, Azure

Monitoring Tools: Tableau, CloudWatch, Splunk

Programming Languages: C,C++, Java, Python, Ruby

Web Programming: PHP, HTML, Javascript, JQuery, CSS, AJAX

Operating system: Redhat Linux 6.x/7.x, Ubuntu, CentOS, Solaris, Windows

Volume manager: VERITAS volume manager, LVM with Linux

ETL Tools: Informatica, Abnitio,Brust

PROFESSIONAL EXPERIENCE:

Sr. Tableau Developer IV

Confidential - Herndon, VA

Responsibilities:

• Gathers business requirements from different Department in single family & Creating Data Structure According in Spread Sheets & Creating Scripts in Oracle Database.
• Experienced working with unstructured data creating workflows in Alteryx software with documentation and implementation of the processed data.
• Design, develop, and deliver interactive data visualizations using Tableau desktop and Tableau server and also design, develop, and deliver reports using other business intelligence tools
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
• Advised top management on Appropriate Employee Corrective actions in Alteryx
• Created organizational flow charts in Single Family score cards to path reports
• Working with Mortgage Loan payment processing, Accounting and reporting etc
• Worked with senior-level management to create fair and consistent HR policies and procedures.
• Used to be Maintains security permission structure in Tableau server and in Bi Tools
• Worked on Data consulting Activities & in client support
• Conducts other data analysis and data consulting activities as required to support client delivery.
• Create dashboards and reports within Tableau used Design and implement proof of concept solutions and create advanced BI visualizations
• Expert in optimization and query performance tuning in Netezza using various techniques involving distribution analysis, data-type analysis, zonemaps, CBTs, configuration parameters etc.
• Expertise in working with different databases like Netezza, Teradata, MS
• SQL Server 2008 R2, Oracle 10g/9i/8i and tools like Aginity, Toad, SQL
• Experience in creating complex formulas and calculations within Tableau to meet the needs of complex business logic
• Creating Strong SQL Skills
• Proposed solutions to improve system efficiencies and reduce total expenses Worked with Microsoft Power BI for visualizing and filtering date/time data, and Hive will construct the Map/Reduce jobs necessary to parse the string data as date/time to satisfy the queries Tableau generates.
• Used Hive and Hadoop configuration variables for a given connection from Tableau to tune performance characteristics
• Used additional UDFs which Tableau does not yet expose as formulas for use in calculated fields in HIVE.
• Used Tableau "Pass Through" functions for using UDFs, UDAFs (for aggregation) and arbitrary SQL expressions in the SELECT list
• Published Tableau dashboard on Tableau Server and embedded them into portal.
• Setup trusted authentication in Tableau server and pass requests from Web server
• Worked heavily using Tabadmin tools and Tableau Cmd for setting up security profiles for various User groups and Users.
• MicrostrategyDSS Agent create cache table on schedule
• Created External filter, internal filter and Context filter to improve performance.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Used Tableau and Google Analytics to analyze web traffic and make business decisions on the traffic coming from different locations.

Sr. Data Analyst III/Tableau Developer

Confidential - Richmond, VA

Responsibilities:

• Creating tables in database in Aws Redshift Cloud by using SQLWorkBench, and also objects like tables, views, procedures, triggers, and functions.
• Writing python script to Automate the data from Teradata to cloud Environment.
• Configure the VPC, EC2 instances, S3 buckets, RDS (MySQL)
• Configuration of AWS in built SNS/SQS setup for job scheduling
• Create required shell or python scripts for data push from Tableau/Teradata to S3
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Experience in SQL development with understanding of relational and multi-dimensional design.
• I used to work on HadoopTable, Impala and HIVE update the table and create Tables, Insert, Delete etc
• In Server provide production support for Tableau users. Troubleshooting issues and engages with Tableau Support if necessary.
• Participate in client meetings to understand project definitions and offer design reviews.
• We Use agile methodology for Projectrelated issues and Monitor according to that. I used to slove according to that issues immediately.
• Expert in optimization and query performance tuning in Netezza using various techniques involving distribution analysis, data-type analysis, zonemaps, CBTs, configuration parameters etc.
• Expertise in working with different databases like Netezza, Teradata, MS
• SQL Server 2008 R2, Oracle 10g/9i/8i and tools like Aginity, Toad, SQL
• Navigator, Teradata SQL Assistant
• I am working on opens workbook in Tableau Desktop 10.7, refreshes the. tde extract, publishes to Tableau Server 10.7
• Working on Tableau Desktop 10.7 and Tableau Server 10.7 can read. tde and. hyper extracts, so you can open and view workbooks with extracts in either format such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Provide database coding to support business applications using Sybase T-SQL.
• Perform quality assurance and testing of SQL server environment.
• Develop new processes to facilitate import and normalization, including data file for counterparties.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Used Tableau Cmd for various Dashboard migrations from one environment to another.
• Setup of Distributed Server environments for optimum load balancing.
• Experienced in developing applications using Agile Methodologies and Scrum stories in a python-based environment
• Knowledge in Model View Controller (MVC) frameworks.
• Installed various packages in python using pip and easy install.
• Experience in using LAMP (Linux, Apache, MySQL, and Python) Architectures.
• Experience in working with different operating systems like LINUX and WINDOWS.
• Experience in handling REST Web Services.
• Experience in using various version control systems like Gitlab.
• Having knowledge on deploying applications by using Jenkins that provides Continuous Integration and Continuous Deployment.
• Design and maintain databases using Python and developed Python-based API (RESTful Web Service) using Django models and PostgreSQL.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Creating New Schedule's and checking the task's daily on the server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Sr. Data Analyst/Tableau Developer

Confidential, Radnor, PA

Responsibilities:

• Involved in creating database objects like tables, views, procedures, triggers, and functions.
• By using T-SQL to provide definition, structure and to maintain data efficiently. Create Oracle SQLs/Pl SQL procedures and queries.
• Ability to write complex queries and use MS Excel for executing comparisons. CMDB knowledge (HP/Service Now)
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Extensive GAP analysis in the project.
• Design, build and run Tableau Dashboards
• Assisted business analysts with requirements gathering and in design and development of ETL processes.
• Develop documentation as required and implements standards as well as complex modeling and enhance the capacity and performance of the Tableau environments.
• Interpret business plans for automation requirements.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Tableau migration and scheduling.
• Validated the schema and found the errors present in the ETLand also took part in giving the recommendations to fix the problem.
• Proficient in writing stored Procedures in Netezza and converting cursorbased PL/SQL procs into set based nzsql procs
• Hands-on and extensive working experience on Business Intelligence IT solution ETL processes using Informatica.
• Creating Dashboards, action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of multiple ETL tools as Informatica
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Experience in SQL development with understanding of relational and multi-dimensional design.
• In Server provide production support for Tableau users. Troubleshooting issues and engages with Tableau Support if necessary.
• Having knowledge on DVO in Informatica
• Participate in client meetings to understand project definitions and offer design reviews
• In source data and give input to help DBAs structure the best SQL and Excel data sources
• In Tableau desktop server schedule exports of your views (PDF, image, CSV) and distribute them via email through a simple web interface.
• I am working on opens workbook in Tableau Desktop 10.5, refreshes the. tde extract, publishes to Tableau Server 10.5
• Working on Tableau Desktop 10.5 and Tableau Server 10.5 can read. tdeand .hyper extracts, so you can open and view workbooks with extracts in either format.

Environment : - Tableau Server 10.4, Tableau Desktop 9/7, Informatica, MS SQL Server 2008,Oracle 10g, SQL BI Suite (SSIS, SSRS, SSAS, Visual Studio 2010, Windows 7, oracle, Sales Force

Tableau Developer

Confidential, Raleigh, NC

Responsibilities :

• Deep experience with the design and development of Tableau visualization solutions.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Importing data from HDFS to Hive using Sqoop The connector then gets the closing price for the specified company for one year back from today's date.
• Created External filter, internal filter and Context filter to improve performance.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Used data connectors that are already available in Tableau, to create web data connector (WDC) that reads data from virtually any site that publishes data in JSON, XML, or HTML.
• Used Tableau and Google Analytics to analyze web traffic and make business decisions on the traffic coming from different locations.
• Configuring and creating reports based of Hive.
• Big Data Ecosystems: HDFS, MapReduce, Hive, Pig, Sqoop
• Used the Web Data Connector JavaScript library for enabling the app to interface with the Tableau API
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Created parameters and quick filters. Created sets to display top products based on their sale.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created Dashboards with interactive views, trends and drill downs.
• Published Workbooks and Dashboards to the Tableau server.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Created groups and users in Tableau server
• Used commands in Tab cmd. and Tab admin utility tool and migrated Workbooks and Dashboards

Environment : Oracle 11g, Python, Chef, Puppet, Kickstart, Cron, Perl, Tableau Desktop 8.2, Tableau server, Oracle SQL developer, SQL Server 2012, Oracle 10g, PL/SQL, T-SQL,MS Access, Windows 2007 server, Teradata, MS Office 2007

Data Analyst

Confidential

Responsibilities

• Installed and configured Oracle 10g/11g RAC databases as per company standards.
• Installation, Configuration, upgradation and administration of Sun Solaris , Linux .
• Implemented and managed Oracle 10g RAC and 11g RAC databases on UNIX , LINUX and Windows platforms.
• Manipulating, cleansing & processing data using Excel, Access and SQL. Responsible for loading, extracting and validation of client data.
• Liaising with end-users and 3rd party suppliers.
• Analyzing raw data, drawing conclusions & developing recommendations Writing T-SQL scripts to manipulate data for data loads and extracts.
• Developing data analytical databases from complex financial source data. Performing daily system checks.
• Data entry, data auditing, creating data reports & monitoring all data for accuracy. Designing, developing and implementing new functionality.
• Monitoring the automated loading processes.
• Advising on the suitability of methodologies and suggesting improvements. Carrying out specified data processing and statistical techniques.
• Supplying qualitative and quantitative data to colleagues & clients.
• Using Informatica & SAS to extract, transform & load source data from transaction systems.
• Environment : Tools and Tableau for setting up security profiles for various User groups and Users, Data tracking, sql, monitoring,sas.

System Administrator

Confidential

Responsibilities:

• Maintained History of all the repositories using Subversion.
• Used Clear case (Base) as version control to store source code.
• Helped developers to resolve subversion code merging issues.
• Involved in creating new elements in vobs.
• Responsible for designing and deploying best SCM processes and procedures.
• Used ANT as build automation tool for Java based projects.
• Build and release software baselines, code merges , branch and label creation and interfaced between development and infrastructure.
• Good Quality release notes. Implemented sustainable branching models for organizations.
• Performed regular builds and deployment of the packages for testing in different Environments.
• Production Support & Systems engineering duties related to Red hat system administration DNS, DHCP, NFS, NIS, LDAP, user account maintenance, backup & recovery, Auto-mounting, License Management, Printer configuration.
• Following up with the Test Team & Development Team to resolve the build issue. Documented the policies and procedures for branching, labeling, code merging, check-in/check-out, and builds.
• Deployed artifacts to WebSphere application servers.
• Installing and configuring Apache Tomcat and supporting them on Linuxproduction servers.
• Troubleshooting the network issues and response problems.
• Installation and configuration of Logical volume manager- LVM and Netbackup .
• Experience with Nagios Network management and System monitoring tool.
• Documentation of all the setup procedures and System Related Policies ( SOP's ).
• Experience in configuring DNS, NFS, NTP, FTP on Linux servers.
• Worked in the Java development team, assisting in coding using core java programming and MS SQL Server.

Environment : Kickstart , Cron, Solaris, RedHat, Tomcat, Java, LVM, Nagios, Oracle Virtual box, VMware, SSH, RHEL, FTP, SCP, WinSCP, Subversion, Clear Case, Red hat Linux, ANT, Web sphere, Shell Scripts, Clear Quest.