SUMMARY:

• Over 9 years of experience in system analysis, design, development, administration, support using Informatica, Netezza, Oracle, Sql Server, UNIX/Linux, ETL Development, ETL Testing, Data Architecture and Data Modeling.
• Worked extensively using Oracle 11i and 10g involving database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, replication database security, cloning.
• Experience in Design, Development and Implementation of business applications using Informatica Power Center.
• Worked extensively using Informatica Power Center Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Experience in integrating disparate data sources (flat files, XML, CSV) with multiple relational databases.
• Expertise in designing and implementing SCD - slowly changing dimensions types (1, 2 and 3) and CDC - change data capture.
• Good Experience in handling and loading high volumes of data into data warehouse in a given load window.
• Knowledge in design and development of BI reports using Obiee and Tableau.
• Worked with tuning Complex Queries and created Tables, Views, Stored Procedures, Indexes, User Defined Functions and Triggers.
• Proficient in implementing ETL QA procedures and Exposure to all stages of Software Development Life Cycle.
• Expertise in preparing test strategy, test plan, test summary reports, test cases and test scripts for automated and manual testing based on user requirement documents and system requirement documents.
• Experience in performing Functionality testing, System Integration Testing (SIT), Graphical User Interface (GUI) Testing, Integration, Negative testing, User Acceptance (UAT), Stress Testing and Regression testing on several applications as needed to minimize defects.
• Experience with coordinating cross-functional teams, project management and presenting technical ideas to diverse groups.
• Experience in Informatica Code Testing like Informatica (XML'S) Deployment, DDL’s, DML’S and Unix Proc's Deployment.
• Good experience in running informatica jobs through Unix Proc's as per business dates. Prepared Test case’s and Test case’s Execution in different environment's like Informatica level, Database level, Autosys level and Report's level.
• Scheduled the Power center jobs using Autosys and developed various unique testing strategies to validate the data.
• Good experience using Netezza Admin, Oracle and SQL writing and expertise in Netezza and Informatica Performance tuning.
• As a Netezza Admin, responsible for taking Backup & Restores, Host Backups, improving performance and Data & Object migrations within the Appliance.
• Monitoring and Optimize Performance by Zone mapping and making sure rearranging data segments and temp segments for data loads and user queries.
• Responsible for high volume of data loads daily using bulk load process utilizing NZLoader, NZMigrate & Informatica.
• Perform daily and weekly maintenances using NZ Utilities like nz groom, nz genstats, nz health, nz backup & nz restore (Full & Incremental) and Performed events in Netezza level.
• Created and Monitored WLM for Netezza Appliance to manage Work Load for data loads and user query performance by creating and allocating resource to resource groups.
• Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Expert in creating and using Stored Procedures, Views, User Defined Functions.
• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.6.1/9.5.1/9.0.1/8.5 (Source Analyzer, Data Warehouse Designer, Mapping Designer, Mapplet, Transformations, Workflow Manager, Workflow Monitor, Worklets), Informatica Data Analyzer 8.5/8.1,Informatica Power Exchange, Data cleansing, OLAP, ROLAP,MOLAP, Autosys, Control M, Star Schema, Snowflake Schema, OLTP, SQL*Plus, SQL*Loader.

Databases: Netezza N, N, N, Oracle 9i/10g.

Database Tools: NZAdmin, NZBackup, NZRestore, NZLoad Export, Import, Load, Nzevent, Toad, Aginity Workbench, UDX, Stored Procedures, UDF, Triggers, AutoSys.

Reporting tools: Tableau and Obiee.

Programming languages: SQL, PL/SQL, Unix.

Tools: /IDE: Aginity, TOAD, SQL*loader.

Data Migration: NZLoad, Data Migration, Import/Export, db2 load, db2move.

Operating Systems: Windows Server 2008/2007, Windows XP, Unix/Linux.

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Informatica Developer and Tester.

Responsibilities:

• Interacted with the client to understand the business requirements.
• Experience in working with different types of sources like Oracle, Flat Files, XML, DB2 and SQL Server.
• Developed mappings using Power Center Designer using Aggregator, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier, XML Parser, XML Generator, SQL, HTTP, Normalizer, Rank, Sorter, Router and Stored procedure transformations.
• Developed mappings/Reusable Objects/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center 9.5.1/9.0.1.
• Experience in ETL Test case creation and execution of ETL Code.
• Have good experience using ETL code testing creation and execution.
• Handle slowly changing dimensions of Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.
• Involved in trouble-shooting, performance monitoring and tuning to obtain maximum performance while allowing for maintainability and meeting business rules.
• Supporting Change Requests fix pack upgrades, troubleshoot problem tickets and new database implementation and support.
• Optimized query performance by tuning queries using EXPLAIN tools and tuned the monthly reports to generate quicker and appropriate results.
• Developing Concurrent applications and automated scripts to perform Inserts, deletes which occur at same time as reporting & summarization, without having impact upon performance.
• Investigation and resolution of application and data issues in the development and production environments.
• Created clustered Indexes combined with partitioning to allow for quick data access and bring down the application execution time.
• Implemented procedures for daily database monitoring, backup and configuration changes.
• Develop new backup and recovery processes that leverage new techniques and technology.
• Worked on the host, data and schema level backups and restore utilities.
• Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Expert in creating and using Stored Procedures, Views, User Defined Functions.
• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.

Environment: - Informatica (ETL), Netezza, Linux, Bash shell scripting, Aginity Workbench, Autosys scheduler.

Confidential, Erie, PA.

ETL Developer

Responsibilities:

• Experience in working with different types of sources like Oracle, Flat Files, XML, DB2 and SQL Server.
• Developed mappings using PowerCenter Designer using Aggregator, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier, XML Parser, XML Generator, SQL, HTTP, Normalizer, Rank, Sorter, Router and Stored procedure transformations.
• Involved in creating informatica mapping to populate staging tables and data warehouse tables from various sources like flat files db2, Netezza and oracle sources.
• Extracted and loaded data from Netezza using Oracle and Informatica powered change for Netezza.
• Analyzed the source data coming from Oracle, Netezza and flat files. Worked with Data Warehouse team in developing Dimensional Model.
• Involved in all the phases of SDLC from gathering requirements, analysis, design, modeling, development, testing implementation and Documentation.
• Redesigned Informatica mapping to handle multiple updates and deletes.
• Extracted and loaded data from Netezza using ODBC and Informatica power exchange for Netezza.
• Performed establishment and maintenance of databases for assigned projects as per business requirements.
• Implemented procedures for daily database monitoring, backup and configuration changes.
• Assisted in designing and implementation of detailed data warehouse models and mappings.
• Developed queries, backups, and session management and log management records in detailed manner.
• Extensively used Aginity Netezza work bench to perform various DML, DDL etc. operations on Netezza database.
• Reclaiming the space for tables, databases using Netezza groom.

Environment: - Informatica, Netezza, Linux, Bash shell scripting, Aginity Workbench, Autosys scheduler.

Confidential

ETL Developer

Responsibilities:

• Developed mappings using Power Center Designer using Aggregator, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier, XML Parser, XML Generator, SQL, HTTP, Normalizer, Rank, Sorter, Router and Stored procedure transformations.
• Experience in working with different types of sources like Oracle, Flat Files, XML, DB2 and SQL Server.
• Taking backups using Netezza backup utility and Restore the tables using Netezza restore utility.
• Performing migration activity using Netezza Migration utility.
• Hands on experience in UNIX commands and VI tool.
• Created Netezza databases, objects, groups and management.
• Distributing key handling on tables with huge data and created clustered base tables and created materialized views. Generated statistics on tables (Express & full).
• Gathering plan file and running Netezza plan to tune query.
• Migrated tables from one server to another server and migrated data from one server to another server.
• Netezza reclaim calculation and reclaiming the spaces.
• Performance tuning of the Netezza database queries.
• Worked with IBM support for issues disk replacement, patching, and system upgrade.
• Worked as a team member to provide 24x7 on-call production database support.
• Install and upgrade the database server and application tools.
• Control and monitor user access to database; monitor and optimize the performance of database.
• Allocate system storage and plan for future storage requirements for the database system.
• Provide technical resolution to Oracle database related problems.
• Create primary database storage structures and primary objects.
• Create and maintain clone/staging database environment as well as hot standby database.
• Enroll users and maintain system security, ensuring compliance with database license agreements.
• Develop and maintain database standards and conventions and analyzed impact of data change.

Environment: - Informatica (ETL), Netezza, Linux, Bash shell scripting, Aginity Workbench, Autosys scheduler.

Confidential

ETL Developer

Responsibilities:

• Conducting source system analysis and analyzing current EDW system.
• Scheduling the Power center jobs using Autosys and Killing user's session as per their request.
• 24x7 remote support and on call support for Production databases.
• Scheduled maintenance jobs by creating/developing UNIX shell scripts and Oracle scheduler jobs. Ex: Data-pump export, listener log maintenance, Stats Gathering etc.
• Bouncing the database and Listener as per the requests.
• Creation of db links as per users' request and as part of the cloning database.
• Experience in working with different types of sources like Oracle, Flat Files, XML, DB2 and SQL Server.
• Developed mappings using PowerCenter Designer using Aggregator, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier, XML Parser, XML Generator, SQL, HTTP, Normalizer, Rank, Sorter, Router and Stored procedure transformations.
• Historical migration from different servers.
• To load the data from stage to data warehouse and load the data from data warehouses to marts.
• Netezza health check and performance checking run the Informatica jobs through Autosys.
• Creating databases as well as users as per client requirement.
• Taking backups using Netezza backup utility.
• Hands on experience in UNIX commands and VI tool.
• Hands on experience in informatica to deploy xml’s and validating mappings and running jobs.
• Hands on experience in ETL code test case creation and execution.
• Distributing key handling on tables with huge data.
• Creation of the materialized views and managing.
• Generating statistics on tables (Express & full) and Gathering plan file and running Netezza plan to tune query.
• Data migration of whole database from one server to another.
• Netezza reclaim calculation and reclaiming the spaces.
• Designing OBI Reports.

Environment: - Informatica (ETL), Netezza, Linux, Bash shell scripting, Aginity Workbench, Autosys scheduler.

Confidential

Oracle Database Admin

Responsibilities:

• Involved in installation of Oracle on different platforms.
• Backup and recovery of database and maintaining Hot Backups and Cold Backups.
• Cloning of Oracle database of production to non-production database.
• Applying latest releases of the RDBMS patches using Opatch utility on Production and test instance to resolve few technical challenges & issues.
• Upgraded Oracle databases from 10g to 11g.
• Implemented Logical Backups using Export and Import.
• Managed Data files, Parameter files, Control files, Online Redo logs and Archived Logs.
• Managed table spaces, resizing and adding new, monitoring database growth.
• Created users and assigned roles and profiles, maintaining system security through monitoring user access to the database.
• Monitoring Database and Listener availabilities.
• Monitored and diagnosed database performance through monitoring of alert files, trace files.
• Effectively handling day to day DBA tasks like user management and the database management.
• Performed Database Duplication using RMAN.
• Execution of scripts provided by customers/developers.
• Supported customers to manage their operational data ranging from GB to TB in Oracle database, solving of space problem, data loading problem.
• Generating AWR reports.

Environment: WINSQL 9.0, Oracle 11g, Oracle 10g, PL/SQL, MS-Visio, Windows NT.