PROFESSIONAL SUMMARY:

• 12 Year of IT Experience in Analysis, design, development, Implementation, Testing of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Informatica Powercenter.
• Extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Experience in various types and stages of Software Development Life Cycle ( SDLC) processes including Analysis, Design, Development, Testing and Implementation.
• Extensive experience in Tableau Desktop versions 2020/2019, Tableau Reader and Tableau Server.
• Experience with dimensional modeling using star schema and snowflake models.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server.
• Performed the performance and tuning at source, Target levels using Indexes, Hints and Partitioning in DB2, ORACLE and Informatica.
• Designed and developed various PL/SQL stored procedures to perform various calculations related to fact measures.
• Converted the PL/SQL Procedures to Informatica mappings and at the same time created procedures in the database level for optimum performance of the mappings.
• Independently perform complex troubleshooting, root - cause analysis and solution development.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

SKILL:

Operating Systems: Windows 10 / 7 / XP

Databases: SQL Server 2019/2018/2016 , Oracle 11g/10g/9i, MySQL Workbench, Teradata

DB Tools: MS-Access, SQL Server Integration Services (SSIS), Data Transformation Services (DTS), SQL Server Reporting Services (SSRS)

ETL Tools: Informatica PowerCenter 9.x/10.x, Informatica PowerExchange 9.x

DBW Tools: Tableau Desktop 2020, 2019, Business Objects 4.2, 4.1

Reporting Packages: SQL Server Reporting Services, MS Excel.

Languages: Java, HTML, XML, SQL, PL/SQL, Unix, Shell Scripts

Other Tools / Methodologies: TOAD, Visio, Eclipse, Service Now, Incorta, Agile, Jira, Waterfall

WORK HISTORY:

Senior ETL Developer

Confidential, Richardson, TX

Responsibilities:

• Developed ETL programs using Informatica to implement business requirements
• Created shell scripts to fine tune ETL flow of Informatica workflows as per business discussions
• Performance tuning was done at functional level and map level. Used relational SQL wherever possible to minimize data transfer over network
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections
• Provided support to develop entire warehouse architecture and plan ETL process
• Involved in enhancements and maintenance activities of data warehouse including tuning, modifying of stored procedures for code enhancements
• Effectively worked in Informatica version based environment and used deployment groups to migrate objects
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs
• Designed Data Modeling, Design Specifications and to analyze Dependencies
• Creating indexes on tables to improve performance by eliminating full table scans and views for hiding actual tables and to eliminate complexity of large queries
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE
• Extensively involved in using hints to direct optimizer to choose optimum query execution plan
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler to schedule jobs
• Performed unit testing at various levels of ETL and actively involved in team code reviews
• Identified problems in existing production data and developed one time scripts to correct them
• Fixed invalid mappings and troubleshoot technical problems of database
• Involved in creation of Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations

Senior ETL Developer

Confidential, Dallas, TX

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer
• Develop mappings using needed Transformations in Informatica tool according to technical specifications
• Creation of new Triggers, Packages, Procedures, Functions, Concurrent Programs, Alerts, Request Sets using PL/SQL technologies
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored results using workflow monitor
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing
• Implemented slowly changing dimension methodology for accessing full history of accounts
• Resolving Performance issues related Pl/Sql Packages, Procedures & Functions
• Involved in development of Tableau calculations and applying complex, compound calculations to large, complex data sets
• Created custom Function's Date range, Time functions, array functions, and Conditional formatting functions in Tableau reports

ETL Developer

Confidential, Sunnyvale, CA

Responsibilities:

• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica
• Involved in complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing deleted records in source systems
• Coded Unix Scripts to capture data from different relational systems to flat files to use them as source file for ETL process
• Worked extensively with connected lookup Transformations using dynamic cache
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once
• Worked with complex mappings having average of 15 transformations
• Created PL/SQL scripts based upon adhoc requests from business users
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements
• Converted existing BO reports to tableau dashboards

ETL Developer

Confidential, San Jose, CA

Responsibilities:

• Developed Oracle PL/SQL packages, procedures and functions
• Coded Oracle SQL to create ad-hoc reports on as-needed basis
• Creation of new Triggers, Packages, Procedures, Functions, Concurrent Programs, Alerts, Request Sets using PL/SQL technologies
• Involved in data analysis for source and target systems. Good understanding of Data warehousing concepts, Star schema and Snow-flake schema
• Involved in supporting and maintaining Oracle Import, Export and SQL*Loader jobs
• Involved in supporting and maintaining Unix shell script jobs

Oracle Developer

Confidential, Sunnyvale, CA

Responsibilities:

• Developed Oracle PL/SQL packages, procedures and functions
• Created scripts to create new tables, views, queries for new enhancement in application using TOAD
• Created indexes on tables for faster retrieval of data to enhance database performance
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE
• Extensively involved in using hints to direct optimizer to choose optimum query execution plan

Oracle Developer / IT Analyst

Confidential, San Jose, CA

Responsibilities:

• Preparing Functional Specification Documents (MD70) as per business requirements
• Impact analysis on OTC / QTC areas in Order Management, Receivables for gap and solution as per business requirements
• Involved in cross functional track meeting to identify to analyze gaps in Oracle area on monthly basis changes to system