SUMMARY

• 8 years in IT with 7 years’ experience in Data warehouses using POWER CENTER as an ETL tool and 3 years in Informatica Data Quality (IDQ) and TABLEAU dashboard.
• Experience in designing and implementing ETL environments using INFORMATICA POWER CENTER 9.X/8.x/ 7.x/6.x
• Experience in Relational Databases (RDBMS), Data Modeling Design and build the Data Warehouse, Data marts using Star Schema and Snow Flake Schema for faster and effective Querying.
• Implemented Ralph Kimball methodology in designing Enterprise DWH systems.
• Experience in the Data Analysis, Profiling and cleansing using Informatica developer (IDQ) tools.
• Extensive experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files, Excel, XML, DB2 UDB, Oracle, SQL Server, and Teradata.
• Have strong experience on TABLEAU installation and configuration and Designing Dashboard.
• TABLEAU experience in creating views aggregates, formatting, sorting, grouping and using filters to do calculations alongside using parameters.
• Extensively worked on Informatica power center tools: Designer, Workflow Manager, and Workflow Monitor & Repository Manager.
• Extensively worked on Informatica Designer Components: Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Worked on error handling and problem solving in Informatica.
• Extensively worked with Informatica Developer IDQ in cleaning and formatting customer master data.
• Extensively worked with Client's for Requirements gathering.
• Experience in migration of code from different Environment: Dev to UAT/QA for testing.
• Exposure in preparation of Technical Design document, Test cases, Unit testing, System testing, and Integration testing.
• Hands on experience with Complex mappings from varied transformation logics: Connected & Unconnected Lookups, Router, Aggregator, Joiner, Update Strategy, Re - Usable transformations among others.
• Experience in Capturing Incremental data (CDC) from source systems.
• Involved in full life cycle development of Data Warehousing.
• Worked Extensively with Slowly Changing Dimensions Type1, Type2 and Type3.
• Experience in Installation, Configuration of Informatica Power Center/Power Mart Client, Server.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5/9.1/8.6.1/8.5/8.1/7. x/6.x

Data Quality: Informatica Developer IDQ.

Data modeling tools: Erwin 7.x/ 4.2/3.x, Microsoft Visio

RDBMS: Oracle 11g/10g/9i/8i, IBM-DB2, MSSQL Server Teradata V2R6, TD10, TD13 versions, MS Access's

Web Tools: HTML, DHTML, XML.

Other tools & Utilities: SQL* Plus, TOAD, Auto Sys

Languages: SQL, TSQL, C, C++

Scripting languages: UNIX Shell Scripting.

Operating systems: Windows 2000/2003/NT/XP, UNIX, LINUX

BI Tools: Tableau 8.1, 8.2

PROFESSIONAL EXPERIENCE

Confidential, Columbus OH

Sr. Tableau Developer

Responsibilities:

• Worked closely with business power users to create reports/dashboards using tableau desktop.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Developed data modeling standards. Helped define the metadata creation and ETL strategies.
• Performed profiling using Informatica Analyst and Informatica Developer.
• Used Informatica Data Quality Tool (Developer) to scrub, standardize and match customer Address against the reference table.
• Used different IDQ transformations in the Developer and created mapping to meet business rules.
• Redesigned some of the existing mappings in the system to meet new functionality.
• Optimized performance by tuning mappings and session level.
• Used different Data profiling techniques for better Data analysis. I.e. Colum profiling and filter options for better Data over view and identifying data anomalies.
• Developed Informatica SCD Type1, 2 and 3 mappings.
• Involved in performance tuning of mappings and sessions to optimize performance.
• Used different Transformation logics to cleanse source data of inconsistence before loading to staging area.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command and Decision task.
• Created and scheduled sessions, jobs based on demand, run on time and run only once using Workflow Manager.
• Created parameter files to Dev, Test and Prod environments.
• By using Autosys, created the job which runs a Perl script, the script in turn runs the ' PMCMD ' command to run a workflow.
• Involved in various testing activities like database testing, unit testing, system testing, performance testing and was also responsible for maintaining of testing metrics, defect tracking.
• Assisted in installation and configuration of Tableau.

Confidential, Hartford CT

Tableau Developer

Responsibilities:

• Used Informatica Data Quality for profiling and identifying anomalies.
• Used different transformations in IDQ i.e. Address Doctor, Pacer, standardizer, labeler, merger, case converter while working with source systems.
• Designed and Developed and implemented Data load and Data validation process.
• Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.
• Migrated IDQ Mapplet to Informatica power center Repository for rest of the Dev team.
• Extracted data from multiple sources like Oracle RDBMS, XML files and flat files to load data into data warehouse built on Oracle.
• Created and Configured Workflows, Workletst and Sessions to load the data to target warehouse tables using Informatica Workflow Manager.
• Designed ETL strategy to load data from source systems to Target Data Base.
• Developed workflow and modified existing once to meet new business rules.
• Championed the use of data modeling standards across the projects. Helped define the ETL and metadata repository creation strategies.
• Hands on Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Used SQL developer and TOAD to run SQL queries and validate the data in warehouse and data mart.
• Strong in UNIX Shell scripting. Developed UNIX scripts using PMCMD utility and scheduled ETL.
• Identified and debugged the errors before deploying and worked on migration of the maps and workflows from development to testing, testing to QA and from QA to production.
• Worked with a team to implement Tableau for better reporting visual optimizations from old systems.
• Created incremental refreshes for data sources on Tableau server.
• Coordinated database middleware issues with DBA's, system performance with System Architects.
• Involved in license management SLA's with Tableau support.
• Generated high detail oriented views using multiple measures, Individual Axis, Dual Axis and Custom Geo-coding.
• Develop and maintain dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
• Creation of workbooks and dashboards those are accessible on different environments like any browser or tablet. Developed dashboards for calendar year and fiscal year.
• Extensively involved in doing user acceptance testing (UAT).
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Created Stories using Tableau as part of report presentations to Business.
• Involved in dashboard and worksheet development alongside managing sites in the server environment and other Admin responsibilities such as scheduling the extraction user Access management and security monitoring.

Confidential, Portland OR

Tableau Developer

Responsibilities:

• Extensively used Informatica Power Center 8.1 working with source definitions, target definitions, mappings, Mapplet, transformations, re-usable transformations etc.
• Involved in design and development of mappings and stored procedures in an optimized manner.
• Implemented partitioning and bulk loads for loading large volume of data and better performance and less time performance.
• Involved in loading the data from Source Tables to ODS (Operational Data Store) Tables using Transformation and Cleansing techniques using Informatica.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Based on the requirements, used various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner, Stored procedure transformations in the mapping.
• Implemented weekly error tracking and correction process using Informatica.
• Involved in performance tuning of mappings, transformations and (workflow) sessions to optimize session performance.
• Developed Informatica SCD type-I, II and III mappings.
• Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, Mapplet and others.
• Creating Test cases and detailed documentation for Unit Test, System and Integration Test to check the data quality.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• Responsible for generating dashboards in Tableau Server using different data sources including Hadoop, Excel, Oracle and Microsoft SQL Server.
• Distributed Tableau reports using Packaged Workbooks, PDF to authorized user community.
• Responsible for performance optimization by writing SQL overrides.
• Improved performance of tableau dashboards and maintained high level of data integrity.

Confidential

Informatica Developer

Responsibilities:

• Extensively used Informatica Power Center 8.6.1 working with source definitions, target definitions, mappings, Mapplet, and different transformations.
• Created source-to-target mappings, storage capacity planning, developing ETL processes using the Oracle Data Integrator 10g.
• Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.
• Implemented partitioning in session level and bulk loads for loading large volume of data.
• Involved in loading the data from Source Tables to ODS (Operational Data Store) Tables using Transformation and Cleansing Logic using Informatica.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Based on the requirements, used various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, xml, Lookup, Aggregator, Joiner, Stored procedure transformations in the mapping.
• Developed Informatica SCD type-I and Type-II mappings.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• Created Stored Procedures, Packages in PL/SQL with Oracle in order to create, update several tables like Order processing Information table and Audit Log tables.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX SHELL PERL scripts to automate the process
• Created UNIX Shell scripts and called as pre session and post session commands.
• Creating Test cases and detailed documentation for Unit Test, System, Integration Test and UAT to check the data quality.

Confidential, AR

Informatica Developer

Responsibilities:

• Identified the flow of information, analyzing the existing systems, evaluating alternatives and choosing the "most appropriate" alternative
• Developed mappings to extract data from Oracle, Flat files and load into Data Warehouse using the Mapping Designer
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target
• Understood the Business point of view to implement coding using Informatica Power Center designer
• All the jobs are integrated using complex Mappings including Mapplet and Workflows using Informatica Power Center designer and workflow manager.
• Migrate historical data, which is one time and built migration process for ongoing data loads using Informatica power center designer
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse
• Involved in versioning the whole process and retiring the old records using the built-in DD UPDATE, DD DELETE and DD INSERT
• Developed standards and procedures for transformation of data as it moves from source systems to the Data Warehouse
• Extensively used "PMCMD" commands on command prompt and executed UNIX Shell scripts to automate workflows and to populate parameter files
• Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and the target Data
• Identified sources, targets, mappings and sessions and tuned them to improve performance
• Written Triggers, Stored Procedures for Complex mappings, Used Debugger in troubleshooting the existing mappings
• Created and scheduled sessions, jobs based on demand, run on time and run only once using Workflow Manage
• Involved in various testing activities like database testing, unit testing, system testing, performance testing and was also responsible for maintaining of testing metrics, defect tracking.

Confidential, CA

ETL Developer

Responsibilities:

• Involved in gathering and reviewing business requirements. Involved in designing the specifications Design Documents, Data modeling and design of data warehouse.
• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
• Created the repository manager, users, user groups and their access profiles.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Created connected and unconnected Lookup transformations to look up the data from the source and target tables.
• Modeling and populating the business rules using mappings into the Repository for Metadata management.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), and Informatica and ETL package design, and RDBMS systems like SQL Server, Oracle.
• Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2).
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplet' using Informatica Designer.
• Involved in the development of Informatica mappings and also performed tuning for better performance.
• Extensively worked on tuning (Both Database and Informatica side) and thereby improving the load time.
• Setting up sessions to schedule the loads at required frequency using Power Center, Workflow manager, PMCMD and also using scheduling tools
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Automated the entire processes using UNIX shell scripts.
• Conduct status meetings with project managers, escalate issues when necessary, conducts meetings for issues resolution.