TABLEAU DEVELOPER

• 7 Years of TOTAL IT EXPERIENCE in Software development and data warehousing using both ETL and BI Reporting tools.
• 2 Years of progressive experience in Tableau.7 & 8 versions for Business Analysis, Reporting and Dash - boarding for enterprise applications.
• 4 years work Experience in using ETL Tool INFORMATICA.
• Exceptional analysis skills with an ability to transform the needs of business users and stakeholders into
• Functional/technical requirements.
• Experience in creating Scorecards, Dashboards using Tableau Desktop 8.3/8.2/8.1/8.0/7.0, Publish dashboards to Tableau Server.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images,Maps,
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI’s
• Expert in Writing Stored procedures, functions, triggers and Views in SQL.
• Experience in using various MS office tools for analyzing, arranging and presenting data.
• Excellent command in writing complex routines for Data Validations, Data Extraction, transformation and loading to target decision support systems using MS Excel and SAS on various environments.
• Experience in mortgage lending lifecycle, including origination, sale/servicing, default management/loss mitigation is a major plus.
• Experience in creating test scenarios to find errors and confirm programs meet specifications. Program Documentation and Review.
• Experience in analysis of data using different statistical procedures.
• Strong experience in coding using SQL, Procedures/Functions, SAS macros.
• Experience in creating SAS programs and performed data validation on raw data sets and created data set for analysis
• Strong experience in data mining, database, analysis, and problem solving skills
• Experience in statistical and methodological concepts and techniques
• Good analytical skills pertaining understanding a business domain coupled with excellent teamwork and strong communication skills.
• Extensive experience in preparation of reports, tables, listings and graphs
• Strong leadership, interpersonal and oral/written communication skills
• Ability to work independently as well as collectively & willing to relocate
• Professional, proactive, collaborative, conscientious and results-oriented individual.

TECHNICAL SKILLS

BI Tools: Tableau 7, 8.1,8.3

ETL Tool: Informatica Power Center 9.6/9.5/9.1/8.6

Language: SQL,PL/SQL

RDBMS: Oracle 9i, 10g

Scripting Language: XML, CSS, Java Script, WSDL, XSD

Data Base: SQL Server-2000/2005/2008, Ms-Access, Oracle 10g

Web server: IIS5.1, IIS 6.0 AND IIS 7.0

Operating Systems: Windows 9x/NT/2000/XP/2003

PROFESSIONAL EXPERIENCE

Confidential

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis project withinTableau Desktop.
• Created views inTableau Desktop that was published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current services by color that was broken into regions allowing business user to understand.
• Experience with other BI tools like Cognos, Business Objects, Micro-strategy and Netezza.
• Projected and forecasted future growth in terms of number of subscribers developing Area Maps to show details at the county level.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, Teradata and MS Excel.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards inTableau Desktop and published them on toTableauServer, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh onTableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment:Tableau Desktop, Reader, SQL Server, and MS Excel.

Confidential - Memphis, TN

Informatica Developer

Responsibilities

• Used Informatica ETL to load data from flat files, which includes fixed-length as well as delimited files and SQL Server to the Data mart on Oracle database.
• Used reverse engineering in Erwin 4.x to understand the existing data model of the data warehouse.
• Worked with creating Dimensions and Fact tables for the data mart.
• Created Informatica mappings, sessions, workflows, etc., for loading fact and dimension tables for data mart presentation layer.
• Have implemented SCD (Slowly Changing Dimensions) Type I and II for data load.
• Did performance tuning of Informatica components for daily and monthly incremental loading tables.
• Developed Mapplets, reusable transformations, source and target definitions and mappings using Informatica 7.1.
• Developed mapping using parameters and variables.
• Created complex workflows, with multiple sessions, worklets with consecutive or concurrent sessions.
• Used Timer, Event Raise, Event Wait, Decisions, and Email tasks in Informatica Workflow Manager.
• Used Workflow Manager for creating validating, testing and running sequential and concurrent batches.
• Implemented source and target based partitioning for existing workflows in production to improve performance so as to cut back the running time.
• Analyzed workflow, session, event and error logs for trouble shooting Informatica ETL process.
• Worked with Informatica Debugger to debug the mappings in Informatica Designer.
• Involved in creating test plans, test cases to unit test Informatica mappings, sessions and work flows.
• Involved in migrating Informatica ETL application and Database objects through various environments such as Development, Testing, UAT and Production environments.
• Documented and presented the production/support documents for the components developed when handing-over the application to the production support team.

  Environment: Informatica Power Center 8.1, Workflow Manager, Workflow Monitor, TOAD 8.6.1.0, SQL Developer, Flat files, XML, Oracle 10g/9i