SUMMARY

• Over 7 years of experience in Analysis, Report design, Dashboard development, Testing and Implementation of Business Applications and Client/Server applications.
• Strong expertise in using Tableau software as applied to BI data analytics, reporting and dashboard projects.
• Strategic expertise in design of experiments, data collection, analysis and visualization.
• Expert in Data Visualization development using Tableau to create complex, intuitive, and innovative dashboards.
• Proven ability to deliver and ensure success in high - pressure/high-risk situations.
• Involved in many aspects of teh SDLC including requirements gathering, proof of concept delivery, implementation, user support and maintenance.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization, dashboards.
• Good Knowledge of Data Warehousing/Data Modeling using ERwin, staging tables, stored procedures, Functions, cursors, Dimension tables, Fact tables, Surrogate Key, Primary keys, Foreign Keys, Star Schema, Snow Flake Schema, Triggers and Normalization/Denormalization.
• Good at Relational Database Management System (RDBMS) concepts.
• Working Knowledge on Kimball/Inmon Methodologies.
• Experience in Data Extraction, Transformation and Loading data using Informatica Power Center 9.x/8.x/7.x.
• Worked on tools like Repository Manager, Workflow Manager, Workflow Monitor, Designer consists of objects like Mapping Designer, Transformation Developer, Mapplet Designer, Source Analyzer and Target Designer, Admin console and Data Administration.
• Experience in designing complex mappings using Source Qualifier, Update Strategy, Expression, Sequence Generator, Aggregator, Filter, Joiner, JAVA, Router, Connected Lookup, Unconnected Lookup, Normalizer, Rank, XML, Sorter, Transaction Control and Union to load data into different target types from different sources like Flat files(Delimited files and Fixed width files) like text files or CSV files, XML, Oracle, IBM Mainframe, Cobol files, SQL server, Teradata, Netezza.
• Experience in managing Slowly Changing Dimensions (SCD) Type 1, Type 2 and Type 3, Data Marts, OLAP, OLTP and Change Data Capture (CDC).
• Worked on Workflow Manager by creating Sessions/tasks, Workflows, Worklets, Reusable Tasks like Sessions, Command, Email and Non-Reusable tasks like Decision, Event Wait and Event Rise.
• Good at Pre-SQL and Post-SQL at session level in Informatica.
• Knowledge on Data Cleansing, Data Staging, Data profiling, Error Handling, Session log files, Workflow log files and Performance optimization like Push Down Optimiation (PDO), session partitioning, which troubleshoots teh bottleneck problems at different levels like source, target, mapping, session and system.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.5/9.1.0/8.6.0/8.1.1 PowerMart6.2/5.1/4.7, Informatica Data Quality 8.5, Power Exchange 9.1

Data Modeling: Erwin 7.2/4.0/3.5

BI Tools: Tableau 8.1/8.0/7.0, SAP BO 4.0/3.1

Databases: Oracle10g/9i/8i, Teradata 12, MS SQL Server 2010/2008/2005/2000

Languages: SQL, PL/SQL, SQL*Plus, UNIXTools: SQL plus, TOAD, Autosys

Operating Systems: UNIX, Windows (XP, NT/95/98/2000)

PROFESSIONAL EXPERIENCE

Confidential, Cleveland,OH

Sr Tableau Developer

Responsibilities:

• Understand teh Requirements and Functionality of teh application from specifications
• Designed, developed, tested, and maintained Tableau reports and dashboards based on user requirements.
• Involved in trouble shooting of performance issues which were associated wif Tableau reports.
• Utilized Tableau server to publish and share teh reports wif teh business users. Also involved in administration tasks such as providing access to teh users and adding them to teh specific group.
• Strong report/dashboard design experience and passionate practitioner of TEMPeffective data visualization. Familiarity wif best practices around visualization and design..
• Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Provided customer support to Tableau users and Wrote Custom SQL to support business requirements.
• Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets.
• Designed mappings using different transformations like Lookup’s (connected, Unconnected, Dynamic), Expression, Sorter, Joiner, Router, Union, Transaction Control, Update strategy, Normalizer, Filter, Rank, and Aggregator using Informatica Power center designer.
• Analyzed different data sources like Oracle, DB2, Flat files including Delimited and Fixed width like text files, SQL Server, XML files from which teh contract data and billing data is coming and understand teh relationships by analyzing teh OLTP Sources and loaded into Oracle data warehouse.
• Worked on Slowly Changing Dimension (SCD) Type 1 and Type 2 and 3to maintain teh full history of customers.
• Responsible for performance optimization by writing SQL overrides instead of using transformations, implementing active transformation like filter as early as possible in teh mapping, selecting sorted input when using Aggregator or Joiner transformations .
• Implemented performance tuning at all levels like source level, target level, mapping level and session level.
• Created and configured workflows, worklets and sessions using Informatica Workflow Manager.
• Used workflow level variables for teh reusability of teh code.
• Used Mapping Parameters and Variables to implement Object Orientation techniques and facilitate teh reusability of code.

Environment: Tableau 8.1/8.0, Sql,Oracle 11g, Unix, Shell scripting, Toad.

Confidential, Oklahoma

Tableau Report Developer/ Informatica Developer

Responsibilities:

• Involved in review and finalizing teh technical specifications of source-target mapping documents
• Responsible for Data Extraction and Transformation from disparate sources like Oracle and XML files and loading in to XML files using Informatica Power Center 9.1.
• Use Tableau Desktop to analyze and obtain insights into large data sets.
• Create visually compelling and actionable interactive reports and dashboards.
• Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart.
• Manipulating data using Tableau versus using a programming language to find teh right balance.
• Updating teh Reports according to teh client Requirements.
• Prepared Unit Test Cases for reports.
• Perform Gap Analysis and feasibility study for implementing Extract/reporting enhancements.
• Involved in understanding teh reporting requirements and providing Tableau reporting solutions.
• Develop, maintain and document highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
• Work wif subject Matter Experts to identify data relationships, report field mappings and translate them into technical requirements for development.
• Presented to teh higher management teh discovered trends and analysis, forecast data, recommendations and risks identified.
• Coordinating and conducting business, systems requirements analysis meetings wif business and technology partners, business analysts, data modelers, solution architects, DBA's and project managers.
• Design mockups/wire frames for various reports by using MS Visio and Excel.
• Write and execute SQL scripts, Stored Procedures to develop reports and perform data/report validation.

Environment: Tableau 8.0/7.0, Informatica 9.1, Oracle 10g, PL/SQL, DB2, TOAD and Windows NT/2000, XML, UNIX

Confidential, Columbus,OH

ETL/Data warehousing Developer

Responsibilities:

• Involved wif business in gathering requirements and preparing technical design document.
• Analyzed source to target mapping sheet.
• Worked on ETL design, development, administration, source to target mappings, data warehouse transformations, on call support, troubleshooting, testing, and documentation. Used Informatica Power Center/Power Exchange to extract/transform and load data from different operational data sources like Oracle, Sybase, Flat files in to staging area (Oracle) and load in to Oracle data warehouse.
• Developed complex mappings using various transformations like source qualifier, Update strategy, joiner, filter, router, expression, Transaction control, Normalizer, Union transformations etc.
• Worked on simple/complex SQL queries and joins to has a override in source qualifier.
• Worked on PL/SQL procedures to load teh data.
• Worked on data profiling which is used in teh process of data investigation, discovery, and mapping to scan all records from any source to identify and quantify data quality.
• Involved in teh design of incremental load strategy and error handling strategy.
• Developed standard and re-usable transformations and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and Router.
• Developed reusable tasks at session level in teh Informatica Workflow Manager.
• Worked on teh huge workflows wif worklets, event waits, assignments, Email and command tasks.

Environment: Informatica Power Center 8.1, Work Flow Manager, Oracle 10g, SQL Server 2005, Erwin, TOAD, UNIX Shell script.

Confidential, Arizona

ETL Developer

Responsibilities:

• Extensively used Informatica Power center for extracting, transforming and loading data from relational sources and non-relational sources.
• Extensively used teh transformations Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, LOOK UP (Static and Dynamic), Update Strategy, Source Qualifier, Joiner, Normalizer.
• Developed Informatica mappings, re-usable transformations, re-usable mappings and Mapplets for data load to data warehouse.
• Designed complex UNIX scripts and automated it to run teh workflows daily, weekly and Monthly.
• Developed mapping parameters and variables to support SQL override.
• Setting up Batches and sessions to schedule teh loads at required frequency using Power Center Workflow manager.
• Created sessions, database connections and batches using Informatica WorkflowManager. Developed mappings to load data in slowly changing dimension.
• Created mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities and Transaction Data Sets for Automatic Position Reporting.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL
• Comprehensive knowledge in Debugging, Optimizing and Performance Tuning of Oracle database
• Provided reliable, timely support of integration, performance and user acceptance testing processes.
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool.

Environment: Informatica Power Center 8.1, Oracle 8i/9i, MS SQL Server 2005/2000, XML

Confidential

ETL Developer

Responsibilities:

• Worked wif data analyst to know teh requirements of teh project.
• Worked wif various data sources like oracle, flat files, Sybase data coming as customers data and load into Oracle warehouse.
• Involved in designing of Informatica mappings by using transformations like source qualifier, expression, update strategy, router, joiner, connected lookup, unconnected lookup, dynamic lookup, transaction control, rank, sequence generator, Aggregator.
• Implemented Slowly Changing Dimensions (SCD) Type 1 and Type2.
• Created reusable transformations and Mapplets and used them in mappings.
• Worked on shared folder.
• Worked on oracle utility, scheduling tool and versioning tool.
• Worked on perl scripting.
• Created PL/SQL procedures for certain Business Requirements
• Designed SQL overrides in source Qualifier according to business requirements
• Created sessions and workflows for designed mappings and created Sequential Workflow using
• Monitoring teh session logs to check teh progress of data load.

Environment: Informatica Power Center 6.1, Data modeling, Oracle 8i, SQL, PL/SQL, MS SQL Server 2000, Flat Files, Windows 2000.