SUMMARY

• Over 7.5 years of experience in Information Technology wif a strong background in Data Warehousing, Business Intelligence and ETL process using Informatica PowerCenter 9.x/8.x
• 7+ years of experience in development of ETL process for extracting, transforming and loading data used ETL tool Informatica Power Center 9.x/8.x
• 3 years of extensive experience inTableauDesktop,TableauServer andTableauReader in various versions of Tableau7.x/8.x as a developer and analyst
• Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Good noledge of Data warehouse concepts and principals (Kimball/Inman) - Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization, Fact and Dimensional tables.
• Experience in integration of various data sources wif Multiple Relational Databases like Oracle, SQL Server and Worked on integrating data from flat files like fixed width and delimited.
• Well acquainted wif Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Worked extensively wif complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators, Stored Procedures and Normalizers.
• Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow &Worklet Designer
• Experience in using teh Informatica command line utilities like pmcmd to execute workflows in non-windows environments.
• Extensively used Informatica Repository Manager and Workflow Monitor.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing teh data flow and evaluating transformations.
• Hands on experience in Performance Tuning of sources, targets, transformations and sessions.
• Good experience in documenting teh ETL process flow for better maintenance and analyzing teh process flow.
• Experience wif SQL Plus and TOAD, PL/SQL Developer, Oracle SQL Developer as an interface to databases- to analyze, view and alter data.
• Experience in ETL Error Handling, Performance Tuning and Code Optimization.
• Tableau experience includes Requirements gathering, Documenting specifications, Design, Development, Testing and Production support of Reporting and Analysis projects
• Experience in building views, advance analysis and publish and share teh views
• Experience in creating different visualizations types using Bars, Lines and Pies, Geographic Maps, Scatter plots, Gantts, Bullets, Heat & Tree maps, Highlight tables and Drill Down and Drop down menu option and Parameterized using Tableau
• Experience in building dashboard layouts and formatting, Interactive dashboards using actions
• Experience in blending teh measures on single axis and dual axis
• Experience in creating sets, groups, Hierarchies, aggregation, date conversions, sorting, filtering data, table calculations and calculated fields
• Experience in Mapping, joining and data blendingfrom multiple data sources
• Experience in publishing workbook & data source, data security using user filters, creating new workbooks wif published data source on Tableau Server
• Experience in admin activities includes managing users, groups, permissions, schedules and Extract refreshes tasks
• worked wif various data sources such as Oracle, SQL Server, ODBC, excel and flat file sources
• Knowledge on using Cloud-based Data Sources such as Salesforce.com, Google Analytics and Amazon Redshift
• Team player and self-starter wif good communication skills and ability to work independently and as a part of teh team.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 8.X/9.1/9.6

Business Intelligence Tools: Tableau Desktop 7.x/8.x, Tableau Server 7.x/8.x, Tableau Reader

RDBMS: MS SQL Server 2000/2005/2008/2012, DB2, Oracle 9i, SAP BW

Programming GUI: SQL, PL/SQL, SQL Plus, Java, HTML, C and UNIX Shell

Tools/Utilities: TOAD, Winscp, Putty, SQL developer

Platforms: UNIX, Windows NT/2003/XP/7

PROFESSIONAL EXPERIENCE

Sr Informatica/Tableau Developer

Confidential, Minneapolis, MN

Environment: Informatica 9.1 / 9.6, IDQ, Oracle11gR2, SQL Server, DB2, SAP BW, SQL Developer, Linux, Tableau Desktop 8.1

Responsibilities:

• Involved in requirement, analysis and understanding of business requirements identify teh flow of information and analyzing teh existing systems.
• Analyzed teh source data coming from Oracle, Flat Files, andDB2coordinated wif data warehouse team in developing Dimensional Model.
• Integration of various data sources like Oracle,SQL Server,Fixed Width and DelimitedFlat Files.
• Migrationof New and Changed Informatica objects across teh environments using Folder to Folder and Deployment Group methods.
• Created, updated and maintainedETLtechnical documentation for Production Migration.
• Developed slowly changed dimensions(SCD) Type 2for loading data into Dimensions and Facts.
• Developed workflows wif Worklets, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager.
• Worked on Joiner,Aggregator,Update Strategy, Rank, Router, Lookup, Stored Procedure,Sequence Generator, Filter, Sorter, and Source Qualifier
• Designed and developed dashboards for various organizational metrics using industry standards
• Maintained reports & analysis and worked on enhancements to existing reports or creating new reports based on business needs
• Implemented performance optimizing techniques to improve dashboard performance
• Developed various dashboards, used context filters, sets while dealing wif huge volume of data.
• Developed Interactive dashboard dat displays summary of category management data
• Developed interactive dashboard dat displays top 10 products across each region using filters and rank
• Developed view dat shows summary report of Financial performance
• Developed annual sales performance report to identify peak month sales in each year
• Developed a dashboard dat displays sales from teh promotion, based on teh running total a decision can be made.
• Developed dashboard and published it on tableau server and provided data security using user filter
• Handled Tableau admin activities creating users & groups, granting access, managing extracts

Sr Informatica/Tableau Developer

Confidential, Washington DC

Environment: Informatica 8.6 / 9, IDQ, Oracle, SQL Server, DB2, Tableau 7

Responsibilities:

• Developed and implemented teh coding of Informatica Mapping for teh different stages of ETL.
• Fixed teh invalid mapping's and troubleshoot teh technical problems of teh database.
• Designed and developed interactive Tableau and Excel based dashboards and workbooks
• Gatheird and analyzed data requirements.
• Translated business requirements into appropriate, efficient reports
• Developed Dashboards using calculations, parameters inTableau.
• Developed a Dual Axis Bar Chart wif Multiple Measures, differentiated each axis by color and size.
• Developed heat map, dat immediately draws attention to our best and worst performing segments
• Developed dashboard wif dynamic labels to show up important notification on view
• created a What-If analysis dat will show, what would happen if sales are improved using parameter control
• developed dashboard dat display sales analysis report using Filter action
• Trained on Tableau Desktop/server
• Worked on ETL production support
• Created Informatica mapping documents to outline data flow from sources to targets.
• Extracted teh data from teh flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Modified existing mappings for enhancements of new business requirements
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.

Sr. Informatica Developer

Confidential, Washington, DC

Environment: Informatica 8.6, Oracle, SQL Server, Flat Files

Responsibilities:

• Responsible for developing, support and maintenance for teh ETL (Extract, Transform and Load) processes using Informatica Power Center 8.5.
• Analyzed requirements from teh users and created, reviewed teh specifications for teh ETL
• Prepare detailed technical document and modified teh existing specifications based teh new requirement
• Created mappings, workflows, sessions and analyzed teh Sources, targets, transformed teh data, mapped teh data and loaded teh data into Targets using Informatica
• Transformations like Expression, Router, Joiner, Lookup, Update Strategy, and Sequence Generator are mainly used.
• Used session and workflow logs to debug teh session and analyze teh problem associated wif teh mappings and generic scripts
• Designed Incremental strategy and Reusable Transformations
• Worked on Transformation Developer, Mapping Designer, Mapplets, Sessions and Workflows
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values..
• Developed Complex ETL Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Dynamic Lookup, and Connected and unconnected lookups, Filters, Sequence, Router and Update Strategy
• Identified teh bottlenecks in teh sources, targets, mappings, sessions and resolved teh problems.
• Used different tasks to manage in sessions in workflow designer
• Monitored jobs related to Informatica and UNIX.

Informatica Developer

Confidential

Environment: Informatica 8.6, Oracle, SQL Server, Flat Files, Unix

Responsibilities:

• Understanding teh Business requirements based on Functional specification to design teh ETL methodology in technical specifications.
• Worked on integration of heterogeneous data sources like Oracle, DB2, SQL Server and Flat Files (Fixed & delimited) into Staging Area.
• Worked on Informatica tools -Designer Workflow monitor and Workflow Manager, Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets and Transformation Developer
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• Worked wif Functional team to make sure required data TEMPhas been extracted and loaded and performed teh Unit Testing and fixed teh errors to meet teh requirements.
• Improved session Performance by enabling property incremental aggregation to load incremental data into target table.
• Debugging and validating teh mappings and Involved in Code Review.
• Used various Performance tuning Techniques to improve teh session performance.
• Worked on correcting and reloading rejected files.