Candidates About

Sathish Bairy

________________________________________________________________

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 HF1/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	Tableau10.4/10.3/102/10.1/9.0/8.2/8.1,Business Objects XIR2/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,IBM-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

 

Education:

 

§  MBA from ITU, California, 2007

 

 

Certifications:

 

 

 

§  SAFe V4.5 Agilist

 

 

 

WORK EXPERIENCE   

 

Eli Lilly and Company, Indianapolis, IN                                                            Mar’2016 - Till date

 

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.

Western Union, SFO, CA                                                                                 Sep’2015 - Mar’ 2016

 

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

 

 

Kaiser Permanente, Pleasanton, CA                                                             Mar’ 2015 – Sep’2015

 

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

 

Google, Mountain View, CA                                                                      Feb’2014 – Mar’ 2015

 

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(google unix machine)

 

 

 

Western Union, SFO, CA                                                                                   Jan’2013 - Feb'2014

 

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

 

Symantec, Mountain View, CA                                                                     Dec’ 2011- Jan' 2013

 

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

 

 

 

 

JP Morgan Chase, Whippany, NJ                                                                Mar’ 2011- Dec’ 2011

 

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

                                                                                                                       

Charles Schwab, Denver, CO                                                                      Sep’ 2010 - Mar' 2011 

 

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,IBM AIX, UNIX Shell Scripts, BO, Erwin

 

IBM, Dublin, CA                                                                                             Aug’ 2009-Sep’ 2010 

 

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

 

Aetna Healthcare Networks, Hartford, CT                                                       Jan’ 2008-Jul‘ 2009

 

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