SUMMARY

• Over 12 years of experience in designing, developing, maintaining and building large business applications such as data migration, integration, conversion, data warehouse and Testing.
• Over 5 years of working experience using Tableau products including Tableau Desktop, Tableau Server.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in Tableau
• Experience in creating different visualizations using Bars, Lines and Pie charts, Maps, Scatter plots, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Experience in Tableau Reporting, creating Dashboards using Tableau Desktop
• Experience in integration of various data sources like SQL Server, Oracle, Flat files, DB2 Mainframes.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Extensive Tableau Experience in Clinical Trials and Enterprise Environment and experience including technical support, troubleshooting, report design and monitoring of system usage.
• Involved in writing Unit test cases for complex scenarios.
• Good knowledge of Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modelling using Erwin and OLAP.
• Knowledge on implementing complex SQL logic using transformations.
• Experience in creating UNIX shell scripts and Perl scripts.
• Knowledge in Installation and configuration of Informatica server with SQL server, oracle and able to handle the Informatica administrator tasks like Configuring DSN, creating Connection Strings, copying & moving mappings, workflows, creating folders etc.
• Expert in all phases of Software development life cycle(SDLC) - Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, Post Implementation Support and Maintenance.
• Experience includes thorough domain knowledge of Business Financial system, Banking, healthcare information technology, Insurance, Pharmacy claims systems, Telecom Industry, Clinical Trials.
• Generated notifications through email from Pentaho and familiar with logging mechanisms.
• Experience in Installation, Configuration of Tableau Server in a multi-server and multi-tier environment.
• Experience in writing Pentaho transformations.
• Enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability.

TECHNICAL SKILLS

Data warehousing: Pantaho, Informatica Power Center9.5.1 HF 1/8.6/8.5/8.1/7.1/6.2/5.1 , Metadata Reporter Data Profiling, IDQ, Data cleansing, OLAP, OLTP, Star & Snowflake Schema, FACT & Dimension Tables, Physical & Logical Data Modeling, Erwin 4.0

BI Tools: Tableau 10.4/10.3/102/10.1/9.0/8.2/8.1 , Business Objects XIR 2/6.0/5.1/5.0

Databases: SQL Server 2005/2000/7.0/6.5 , Oracle 10g/9i/8i/8/7.3, Sybase, My SQL, MS-Access, DB2 8.0/7.0

Languages: C, C++, XML, SQL, PL/SQL, UNIX Shell Scripting, Python

Operating System: HP-UX11/10/9, Confidential -AIX4.0/3.1, Sun Solaris 9/8/7/2.6/2.5, SCO-UNIX, LINUX, Windows 7/XP Professional/2000/NT/98/95

Other Tools: MS Visual Source Safe, PVCS, Autopsies, Mercury Quality center, Star Team.

DB Tools: SQL Developer, SQL*Plus, SQL*Loader, Export/Import, TOAD, SQL Navigator, SQL Tool

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

Sr.Tableau Lead/Architect

Responsibilities:

• Involved in creating different kinds of analytics in risk based monitoring system for on boarding studies based on existing clinical trials
• Involved in requirement discussions with customer and developing the dashboards using tableau desktop and publish in the server
• Implemented complex SQL logic while creating RBM analytics
• Involved in performance tuning by using complex custom SQL queries
• Connected Tableau server to publish dashboard to a central location for .Net application while publishing the dashboards, Involved in scheduling and incremental refresh of the dashboards
• Created different types of calculated fields to meet the customer requirements
• Experienced working with various kinds of data sources such as Flat Files, Oracle, and processing large datasets
• Implemented various kinds of dashboards for treatment compliance, stratification factors, missing scales and treatment vs. randomization analytics.
• Used multi table joint and also blend the data from different data sources based on the common dimension
• Created user filters for the data security
• Involved in creating test scripts and update data scenarios based on the business requirements
• Involved in formal and informal testing using HP Application Life Cycle Management Systems
• Involved in source code review and design document
• Involved in supporting analytics after deployment in production
• Involved in scrum and followed the agile methodologies
• Supporting Business Requirements review, assessment, gap identification, defining business process, deliver project roadmap detailed development specifications and operations documentation

Environment: Tableau 10.4/10.3, Oracle 11g, HP QC/ALM, Service Now, TFS (Team Foundation Server), Microsoft Visual Studio.

Confidential, SFO, CA

Sr.Tableau Developer

Responsibilities:

• Involved in monitoring loads and tack performance challenges whenever issues are observed during the production load
• Used context filters, quick filters and customer filter
• Implemented complex SQL logic while creating worksheets
• Involved in performance tuning by using complex SQL extracts
• Connected Tableau server to publish dashboard to a central location for portal integration
• Involved in scheduling and incremental refresh of the dashboards
• Involved in Business Requirements review, assessment, gap identification, defining business process, deliver project roadmap detailed development specifications and operations documentation
• Created visualization for logistics calculation and department spend analysis using Tableau
• Created different types of calculated fields to meet the customer requirements
• Experienced working with various kinds of data sources such as Flat Files, Oracle, DB2, SQL Server and processing large datasets
• Implemented various kinds of dashboards for charge backs and fraud transactions.
• Used multi table joint and also blend the data from different data sources based on the common dimension
• Created user filters for the data security
• Experience in Hadoop Hive SQL and big data technologies

Environment: Tableau 9.1.1, Oracle 11g, SQL Server, DB2, My SQL, Hadoop, Hive SQL

Confidential, Pleasanton, CA

Sr.Tableau Developer

Responsibilities:

• Participation in Business Requirements, review meetings and defining business process, deliver project plan including documentation
• Developed reports and dashboards using Tableau desktop 9
• Created Bar charts, Pie Charts, Line charts, Area charts, geo maps, Heat maps, Symbol maps, Scatter plots, Crosstabs, Tree maps, Bullet Graphs, Grant Charts, Histograms etc.
• Created different dashboards by consolidating 3 or more worksheets in a single workbook depends on the client requirement specification
• Created various table calculations, parameter, sets and groups
• Involved in testing and make sure all calculations, parameter and sets are working as per the business logic
• Involved in creating different types of quick filters, custom SQL filters and context filters
• Involved in data blending for two or more data sources based on the common dimension and create different types of visualizations
• Published various kinds of charts and dashboards to Tableau server for decision making
• Created user groups, provide privileges like view, edit, download and interact with dashboards
• Implement advanced geographic mapping techniques
• Creating Ad-hoc reports on demand
• Involved in improving the performance of dash boards and reports
• Created user filter for user specific visualizations and data security
• Scheduled incremental refresh of the views and dashboards
• Sending email alerts of the dashboards to the business on regular basis
• Involved in data aggregation in building metadata layer
• Communicate with offshore team to sync with the business logic and share the knowledge
• Involved in all phases of Software development life cycle

Environment: Tableau 9, Oracle 11g, Flat files, Netezza, SQL Server, DB2,Hadoop

Confidential, Mountain View, CA

Sr.Tableau Developer

Responsibilities:

• Created bar, pie, line charts, area, geo maps, heat maps, scatter plots, crosstabs, and combined them into dashboards which allowed interactivity within data
• Creating Ad-hoc reports on demand, Gathering Business requirements for custom reports
• Created views and dashboards that are presentable to internal and external vendors.
• Build advanced chart types and visualizations bar in bar charts- bullet graphs, box and whisker plots - pareto charts
• Implement advanced geographic mapping techniques and using custom images and geo coding to build visualizations of non-geographic data
• Combine data sources by joining multiple tables and using data blending, visualizations techniques
• Created Backup scripts to take periodic backups for the content on Tableau server
• Assign access privileges to the groups, users to the individual dashboards
• Worked on the requirement gathering of the reports
• Analyzed the database tables and created database views based on the columns needed
• Created dashboards displaying sales, variance of sales between planned and actual values
• Implemented calculations and parameters wherever needed
• Published dashboards to Tableau server
• Build dashboards using techniques for guided analytics, interactive dashboard design, and visual practices
• Implement efficiency tips and tricks
• Experience in building ETL pipe lines in Pentaho kettle transformation, to bring data from various sources i.e. spread sheets, flat files, relational data sources
• Experience in using various transformation like text file input, table input, stream look up, filter, merge join, transformations and jobs in Pentaho
• Experience in migrating the code from Dev to UAT, UAT to PROD and create change list and submit schedules on daily basis

Environment: Tableau 8.2,PantahoKettle(Pantheon), Big Query, Oracle 11g, SQL Server, MySql, Gbuntu( Confidential unix machine)

Confidential, SFO, CA

Tableau Developer

Responsibilities:

• Involved in Business Requirements review, assessment, gap identification, defining business process, deliver project roadmap detailed development specifications and operations documentation
• Created visualization for logistics calculation and department spend analysis using Tableau
• Created different types of calculated fields to meet the customer requirements
• Used context filters, quick filters and customer filter
• Implemented complex SQL logic while creating worksheets
• Involved in performance tuning by using complex SQL extracts
• Experienced working with various kinds of data sources such as Flat Files, Oracle, DB2, SQL Server and processing large datasets
• Involved in monitoring loads and tack performance challenges whenever issues are observed during the production load
• Implemented various kinds of dashboards for charge backs and fraud transactions.
• Used multi table joint and also blend the data from different data sources based on the common dimension
• Connected Tableau server to publish dashboard to a central location for portal integration
• Connected Tableau server with share-point portal and setup auto refresh feature
• Involved in scheduling and incremental refresh of the dashboards
• Created user filters for the data security
• Experience in Hadoop Hive SQL and big data technologies

Environment: Tableau 8.1,Oracle 11g,SQLServer, DB2,My SQL, Hadoop, Hive SQL

Confidential, Mountain View, CA

Tableau Developer& Admin

Responsibilities:

• Interacted with business Clients and gathered requirements based on business process.
• Developed reports and dashboards using Tableau as front-end to data in Microsoft Access and Excel
• Designed and built Tableau dashboards for market intelligence, product pricing, and competitive
• Involved in tableau migration and scheduling
• Experienced in tableau administration and used various tabcmd and tabadmin commands
• Experience in building hierarchies, attributes and measures
• Used tabadmin commands to automate tasks
• Automate monitoring and server job processes
• Working with team of DBA’s, modified data structures and optimized Tableau extracts for performance improvements
• Build complex calculations in Tableau to manipulate data, using statistical techniques to analyse data, using parameters and input controls to give users control over certain values
• Manage tableau users, groups, and integration with active directory
• Capable of doing Tableau Server Management like Clustering Architecture, Load Balancing, User Management
• Knowledge of Tableau Server architecture and clusters
• Experience in taking back ups and restoration of Tableau repository
• Involved in troubleshooting the load failure cases, including database problems
• Involved in Production Deployment and Support
• Familiar with Installation, configuration, patching and upgrading of Tableau tool across the environments
• Familiar with Python scripting

Environment: Tableau 7, Tableau 8, Oracle 11g,SQLServer, DB2, SQL, Flat Files, Teradata

Confidential, Whippany, NJ

Sr.Informatica Developer

Responsibilities:

• Involved in the Design, Development, Testing, Analysis, Requirements gathering, functional/technical specification, deploying
• Interacted with business community and gathered requirements based on changing needs
• Incorporated identified factors into Informatica mappings to build the Data Mart
• Involved in Design and Data Modeling using the Star schema
• Logical & Physical Database Layout Design
• Created Informatica mappings for initial load and daily updates
• Modified mappings as per the changed business requirements
• Extracted the data from different sources like Flat files, Oracle and transformed the data based on the business rules and loaded in to target database
• Created Dynamic parameter files and changed Session parameters, mapping parameters, and variables at run time
• Identifying and tracking slowly changing dimensions and implemented in complex Mappings
• Designed reusable transformations and shortcuts to share different mappings
• Responsible for determining the Performance bottlenecks and fixing the bottlenecks
• Responsible for Unit Testing and Integration testing of mappings and workflows
• Involved in troubleshooting the load failure cases, including database problems
• Involved in Production Deployment and Support
• Experience in Shell scripting would be plus

Environment: - Informatica Power Center 9.0.1/8.6,IDQ, Oracle 11g,Sybase, Teradata, SQL, PL/SQL, UNIX Shell Scripting, BO, Erwin

Confidential, Denver, CO

Sr.Informatica Developer

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build the Data Mart
• Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology
• Developed mappings to extract data from SQL Server, Oracle 11g, Teradata, Flat files and load into Data Mart using the Power Center
• Troubleshooting database, workflows, mappings, source, and target to find out the bottlenecks and improved the performance
• Written Indexes, primary keys and checked other performance tuning at data base level
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc
• Involved in Production Deployment and solved various Production issues
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, Workflows and database tuning
• Written shell scripts in UNIX to execute the workflow
• Cleansed the source data, extracted and transformed data with business rules, and built Applets using Informatica Designer
• Extensively used PL/SQL for creating Packages, Procedures and Functions
• Written shell scripts to run the workflows and automated them through maestro job scheduler
• Developed Slowly Changing Dimension for Type 2
• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, work lets and workflows
• Involved in generating reports using Business Objects

Environment: - Informatica Power Center 8.6/8.5,Power Exchange B2B, Oracle 11g, MySql, PL/SQL, Confidential AIX, UNIX Shell Scripts, BO, Erwin

Confidential, Dublin, CA

Informatica Developer

Responsibilities:

• Assisted in designing Logical/Physical Data Models, forward/reverse engineering using Erwin 4.0
• Developed mappings to extract data from SQL Server, Oracle, Teradata, Flat files, XML files, and load into Data warehouse using the Mapping Designer
• Used Source Analyser and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target
• Interacted with business community and gathered requirements based on changing needs
• Incorporated identified factors into Informatica mappings to build Data Warehouse
• Involved in troubleshooting the load failure cases, including database problems
• Involved in Production Deployment and Support
• Written Queries, procedures, created Indexes, primary keys and data bases testing
• Defects were tracked, reviewed and analysed
• Used Source Analyser and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target
• Worked with Reporting team to Generate reports using Business Objects
• Identified sources, targets, mappings and sessions and tuned them to improve performance

Environment: - Informatica Power Center 8.1/7.1, Oracle 9i, Teradata, PL/SQL, SQL Server 2000,Flat files, Sql loader, UNIX Shell Scripts, Business Objects, Erwin

Confidential, Hartford, CT

Informatica Developer

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build Data Warehouses
• Identified all the dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables
• Made use of mapping variables, mapping parameters and variable functions
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD
• Created various cross-tabs, master-detail reports containing ranking, charts etc. using Business Objects
• Checked performance tuning/debugging at different levels like workflows, mappings, database etc
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows
• Performed System Testing, Regression Testing, Acceptance Testing, Functional Testing and Stress Testing
• Created reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports

Environment: - Informatica Power Center 7.1, Informatica Power Exchange, SQL Server 2000, Teradata 6, Oracle 9i, DB2,SQL, PL/SQL, Mainframes, Sun Solaris, UNIX Shell Scripts, Business Objects, Erwin, Autosys

Confidential

Informatica Developer

Responsibilities:

• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, worklets and workflows
• Created new mappings according to business rules to extract data from different sources, transform and load target databases
• Debugged the failed mappings and fixed them
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Defects were tracked, reviewed and analysed
• Modified the mappings according to the new changes and implemented the persistent cache in several mappings for better performance
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows
• Identified the issues in sources, targets, mappings and sessions and tuned them to improve performance
• Created and used reusable mapplets and worklets to reduce the redundancy
• Developed robust Informatica mappings and fine-tuned them to process lot of input records

Environment: - Informatica power center7.1, Oracle9i, SQL, PL/SQL, Solaris, MS Vision.