SUMMARY

• Seven plus years of experience in the Software Development Life Cycle (SDLC) that includes expertise in the Analysis, Design, Development, Implementation, Modeling, Testing and data Warehousing using the tool Informatica PowerCenter 9.6/9.1/8.6/7.1.
• 3+ years of development experience in Tableau 8.x/9.x.
• Involved in Full Life Cycle Development of Reporting Projects, includes Requirementsgathering/ analysis, Design, Development, Testing and Production rollover.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues with in Tableau Server and Reports.
• Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Established Best Practices for Enterprise Tableau Environment and application intake anddevelopment processes.
• Extensively used PL/SQL to write Store Procedure, Functions, Package, Trigger and MaterializeViewsand involved in DB partitioning for improving performance of SQL queries.
• Extensively worked on SQL and PL/SQLTuning using ExplainPlan, SQLOptimizer and SQLHints.
• Used the Semantic Layer concept to guarantee correct results, improve database performance and improving user understanding and acceptance.
• Experience in Unix shell scripting and Teradata utilities (BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, SQL Assistant)
• Expert in using debugger in the Informatica PowerCenter Designer to test and fix errors in the mappings.
• Strong background in Data Warehousing concepts and implementing Dimensional modeling concepts (Star and Snowflakeschema, SCD’s type 2 and type 3)
• Ability to work collaboratively and understanding of business requirements and system architecture.

TECHNICAL SKILLS

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

Reporting Tools: Tableau Server v7/v8, Tableau Desktop v7/v8, Qlikview 9.

Operating Systems: Windows 8/7Windows XP Professional, Windows NT, UNIX, Linux

Scripting Languages: C, C++, SQL, PL/SQL, HTMLand XML

Databases: Oracle 11g/10g/,SQL Server 2012/2008/2005/2000 DB2, MS Access, Teradata 13R2.

Other Tools: TOAD, PUTTY, SharePoint, SVN and Basecamp.

Data Modeling Tools: Power Designer, Erwin, and ER Studio, MS Visio, MS Project.

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Sr. ETL Developer

Responsibilities:

• Extracted the data from the flat files into staging area and populated onto Data Warehouse.
• Prepared Low Level Design (LLD) documents as per the business requirements.
• Developed Mappings & Workflows as per Business logic, quality and coding standards prescribed for the module.
• Data Quality Analysis to determine cleansing requirements. Responsible for populating the business rules using mappings. Understand the business needs and implement the same into a functional database design.
• Developed number of complex mappings using connected - unconnected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, normalizer, sequence generator, Update Strategy, Transactional Control, SQLT Transformations, mapplets to implement the business logic and load the data incrementally
• Handled slowly changing dimensions of Type1, Type2 to populate current and historical data to dimensions and fact tables in the Data Warehouse.
• Documented Mappings, Transformations and Informatica sessions for further maintenance and support.
• Worked on optimizing the mappings by creating re-usable transformations and Mapplets.
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads.
• Designed and developed efficient Error Handling methods and implemented throughout the mappings.
• Created Power Exchange Registration for CDC on DB2 mainframe tables, created DataMap to extract data from file on mainframe.
• Configured the sessions using workflow manager to have multiple partitions on Source data and to improve performance.
• Integrated procedures and a variety of PL/SQL code into kroon jobs and other ETL processes.
• Created kron jobs to monitor incoming claims to be packaged into zip files for further processing.
• Assisted with production support for tasks such as Processed Batch Analysis (PBA), Diff Count Report (DCR) those are local to the scope of the company’s process.

Environment: Power Center 9.6, Teradata 14, DB2, PL/SQL, SQL, Erwin 7.5,Remedy, ESP, Putty, WinScp

Confidential, Philadelphia, PA

Informatica/Tableau Developer

Responsibilities:

• Responsible to pull the data from XML files, Flat files (Fixed width & Delimited) and COBOL files by using complex transformations like Normalizer, XML Source Qualifier etc.
• Modified existing / developed new complex Informatica Power Center Mappings to extract and pull the data according to the guidelines provided by the business users and populate the data into Target Systems.
• Extracted and transformed data from various sources like Teradata and relational databases (Oracle, SQL Server).
• Involved in generating MLOAD and TPUMP scripts to load the data into Teradata tables.
• Created Mappings using Mapping Designer to load the data from various sources, using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations.
• Developed complex mappings using transformations such as Aggregator, Connected and Unconnected Lookup, Filter, Joiner, Expression, Filter, Sorter, Router, Normalizer, Source Qualifier and Update Strategy.
• Worked extensively to create views using Composite queries and publish them as web link.
• Sourced data using WEB SERVICES transformation.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, mail, command, Worklets, assignment, timer and scheduling of the workflow.
• Worked on Power Center Designer tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Used Debugger within the Mapping Designer to test the data flow between source and target and to troubleshoot the invalid mappings.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Coordinate new data development, which includes the creation of new structure to meet business requirements or streamline existing processes to reduce overhead on the existing warehouse with ETL Development team.
• Assist business users in developing/ executing complex queries/ reports using Analysis studio, Query Studio
• Collaborated with business users and members of the BI team, including business analysts, data warehouse developers, and managers, to design and develop as per requirement.
• Created a proof of concept for the optimal data integration process.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality during POC

Environment: Informatica PowerCenter 9.1, Oracle 11g, Unix Shell Scripting, Tableau Desktop 8.3, Tableau server.

Confidential, Minneapolis, MN

Informatica Developer

Responsibilities:

• Created Mappings using Mapping Designer to load the data from various sources, using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Worked on Power Center Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Used Debugger within the Mapping Designer to test the data flow between source and target and to troubleshoot the invalid mappings.
• Worked on SQL tools like TOAD and SQL Developer to run SQL Queries and validate the data.
• Scheduled Informatica Jobs through Autosys scheduling tool.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Developed of key indicators and the appropriate tracking reports with graphical and written summations using summary and Annotations to assist in the quality improvement initiatives.
• Created quick Filters customized Calculations, Conditional formatting for various analytical reports and dashboards.
• Studying the existing system and conducting reviews to provide a unified view of the program.
• Involved in creating Informatica mappings, mapplets, worklets and workflows to populate the data from different sources to warehouse.
• Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
• Use MS Excel, Word, Access, and Power Point to process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information.
• Involved in testing the database using complex SQL scripts and handled the performance issues effectively.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Informatica PowerCenter 9.1, PowerExchange 9.1, Oracle 11g, PL/SQL, Autosys, Toad, Tableau 8.1, UNIX, Windows 7

Confidential

ETL Developer

Responsibilities:

• Extraction, Transformation and Loading of the data using Informatica.
• Designed the target load process based on the requirements documents.
• Enhancing the existing mappings where changes are made to the existing mappings using Informatica Power center.
• Developed various transformations like Source Qualifier, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Created Workflows, Tasks, database connections using Workflow Manager
• Developed complex Informatica mappings and tuned them for better performance.
• Designed and developed online data processing from OLTP to OLAP system using CDC Informatica PowerExchange.
• Worked on DataMap, registration, restart token and recovery of real-time Informatica code.
• Created sessions and batches to move data at specific intervals & on demand using Server Manager
• Responsibilities include creating the sessions and scheduling the sessions
• Recovering the failed Sessions and Batches.
• Involving in extracting the data from Direct Flat files and Indirect Flat files.
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance Understanding the Functional Requirements.
• Responsible for identifying the missed records in different stages from source to target and resolving the issue
• Preparing the documents for test data loading.
• Developed Complex Dashboards, Reports and Cubes using Report Studio.
• Tested ETL code in DEV, SIT & UAT environments to ensure defect free code.
• Activities like preparation of LLD (Low Level Design) Document, ETL (Extract Transform Load) build, plans and conduct ETL unit and development, tests, monitors results and takes corrective action, when necessary.
• Taken care of pre-production activities like Clear Quest tickets, Migration checklist, run plan etc.
• Tracked project status by submitting weekly/Monthly project status report and participated in triage calls.

Environment: Oracle SQL * Plus, TOAD, Informatica PowerCenter 8.1, Informatica PowerExchange 8.1, PL/SQL developer, Oracle SQL, PL/SQL, Oracle10g, SQL Server, DB2 8.0, Sun Solaris, Remedy.

Confidential

ETL Developer

Responsibilities:

• Analyzed Customer requirements and prepared design/mapping documents.
• Worked on Data profiling to validate data related assumptions.
• Prepared unit test cases for the modified existing ETL routines.
• Creating the SQL queries based on source to target mappings for Target tables.
• Prepared the alter scripts to alter the length and data type.
• Created Expression, Lookup, Filter, Router, Aggregator Transformations were implemented to load the data from source to Target using Designer
• Worked on various reports like conditional reports, master-detail reports, reports with prompts and other complex reports
• Developed transformation logic and designed various complex mappings using the designer
• Extensively used SQL to analyze the data.
• Experienced in handling large volumes of data.
• Code developed based on the business requirement
• Develop an ETL mapping as per Business requirement, developing SQL queries to perform audit between source, staging and Target data.
• Created database connections to different data sources in Framework Manager.
• Designed the standard template for creating reports in Report Studio.
• Once components get migrated to production, it is necessary to involve in supporting process
• During the support it is necessary to share the daily status of load run and Incident Management tickets opened in SharePoint to business during daily calls.
• Created Unit Test cases and captured Test log

Environment: Informatica 8.1, AIX, Windows XP, UNIX, Oracle10g, Toad, Putty.