SUMMARY:

• Over 7 years of expertise in the areas of ETL and Client/Server application development, this includes the following:
• Hands - on experience in optimizing, implementing and maintaining IT systems, management procedures and ensure their efficient functioning.
• Analyzing client and systems needs to upgrade the technical competencies, resolving their issues and queries and to ensure prompt services and spread of goodwill.
• Responsible for interacting with business analysts and business users to identify business requirements
• Excellent technical and analytical skills with clear understanding of ETL design and project architecture based on reporting requirements.
• Experience in gathering business requirements and prepare technical documents like Impact analysis doc, TSD and LLD’s.
• Knowledge in application development life cycle (SDLC), including requirements definition, system design, developing and testing/QA and transition to Production.
• Data Modelling: Experience in Data Modeling using data Modelers, Star Schema/Snow flake schema, Fact & Dimension tables, Physical & Logical data modeling.
• Data Analysis: 4 years of strong Business Analysis experience on Data Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Demonstrated expertise utilizing ETL tools, including Informatica v8.6, 9.1, 9.5, PL/SQL package design, and RDBM systems like Oracle.
• Database: 7 years of Database experience on Oracle 11i/10g/ 9i/ 8i/ 8.x/ 7.x, DB2, MS SQL Server 2000/ 7.0/ 6.5 , MS Access 7.0/ 2000, SQL, PL/SQL, SQL*Plus,, TOAD, SQL*Loader, Developer 2000
• Extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center
• Experience in Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, DB2, COBOL files & XML Files
• Experience in performance tuning at sources, mappings and target level
• Experience on SQL query tuning
• Data Cleansing: Experience on Informatica Data Quality for validating and cleansing the data
• Data Management: Dealt with Metadata management (MDM), Transaction data, Control data etc.
• Develop PL/SQL packages, stored procedures, tables, views, and functions; implement best practices to maintain optimal performance.
• Involved in ETL job automation and scheduling and design ingenious strategies for implementing complex business requirements.
• Expertise in scripting languages like UNIX Shell scripting, JavaScript
• Created UNIX Shell scripts for running the jobs on a sequence basis for the source files, source file validation and file watcher job
• Running jobs in test environment through Control-M scheduler
• Providing seamless support for various applications in production environment.
• Resolving issues and providing remedies during the production load based upon priority.
• Implementing critical change requests
• Expertise in .Net Programming, implementing the Three tier Architecture, working on SOA and WCF architectures, designing the UI Interface and the Database Architecture
• Proficient and well versed in Asp.Net Programming.
• Proven track record in imparting significant inputs to the team of service engineers to consistently perform and achieve organizational goals in challenging work environments.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements, ETL design and implementation, unit testing, SIT, UAT, Production migration and support on new and existing applications.
• Awarded with one Quarterly award and two spot awards as an appreciation of my work
• Self-motivated with excellent communication and interpersonal skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.1/8.x/7.x/6.x, Power Mart 6.2/5.1.1/5.0/4.7.2 , Power Exchange 9.1/8.x/7.x, IDQ 9.1.0, Data Analyzer, DataMart, OLAP, OLTP, B2B

Data Modeling: MS Visio, ER Diagrams.

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2000/2005

DB Tools: Oracle SQL Developer, Toad

Operating Systems: Windows 98/2003/2000/ XP/7/NT, UNIX, MS-DOS, Linux AIX.

Scheduling Tools: Control M, Autosys

Languages: SQL, PL/SQL, Shell Scripting, Pearl, HTML, XML, C, C++

Office Suite: MS Word, MS Power Point, MS Excel, MS Access

Editing & Emulator tools: Edit Plus, Putty

Federation tool: Composite 6.2

BI Reporting tools: Cognos Series 8.4/8.1/7.0/6.0 , OBIEE 10.3.1.x, Developer 2000 (Forms 4.5/5.0, Reports 2.5/ 3.0), MS Access, SAP BO XI 3.1, Crystal Reports

Application development: C#.Net, VB.Net

Web technologies: ASP.Net, HTML, Core Java

Bug tracking & Ticketing: JIRA, HP Service center, Remedy

PROFESSIONAL EXPERIENCE:

Confidential, Dublin, CA

Informatica Lead

Responsibilities:

• Modified existing Informatica mappings to handle fixed width files containing UTF8/multibyte characters
• Worked with Informatica Admin to set up changes in Informatica Power center in order to support multibyte or UTF8 characters.
• Worked with Oracle DB admin to change the DB settings in order to support multibyte or UTF8 characters at DB level
• Worked with Unix admin to install UTF8 package
• Developed Unix scripts to handle change fixed width into delimited files format
• Developed Unix Shell scripts to handle file watcher
• Unix script to handle file validation
• Developed Unix Shell scripts to automate the job running system
• Developed scripts to insert metadata, this involved both Unix Shell and PL/SQL
• Worked with Oracle and Unix admin teams for changing admin level settings in order to maintain data quality
• Worked with IDQ 9.1.0 for data cleansing and validation
• Unit testing of the system which involved integration of multiple upstream and downstream systems
• Tested the system in test environment using Control-M
• Active participation in Production migration of the project which involved in integration of multiple systems
• Move the entire code from Informatica 9.1 to 9.5 version
• Generated extracts and interacted with teams from multiple systems in data flow from upstream to downstream systems
• Unit testing of the code in 9.5 version
• Testing the system in SIT and UAT phases
• Involved in production migration of the entire system
• Job monitoring in Production environment.
• Production ticket notifying.
• Perform impact analysis and technical specifications.
• Perform changes to ETL mappings and its corresponding sessions & worklets, workflows.
• End-to-end Unit testing of the ETL loads.
• Implementation and support of the project in SIT, UAT and Production environments
• Provided 24/7 on-call application support in Production

Environment:Informatica 9.5, IDQ 9.1.0, Unix, Toad, Control-M, Oracle 11i.

Confidential, Dublin, CA

Informatica Lead

Responsibilities:

• Preparing TSD, analyzing Functional Specs, Development and maintenance of code.
• Perform impact analysis and technical specifications document.
• Direct interaction with clients to analyze the business requirements
• Developing ETL mappings and its corresponding Sessions, Worklets and Workflows to handle the business requirement.
• Developed IDQ mappings to validate and cleanse the data in source files.
• Developed Composite views to meet the business requirements
• ETL Informatica mappings performance optimization
• Extensively used Informatica debugger to figure out the problems in mappings. Also involved in troubleshooting existing ETL bugs.
• Extensively used Toad for SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Used the PL/SQL Procedures for Informatica mappings for truncating the data in target tables at run time.
• SQL query performance tuning
• Composite views and procedures performance tuning, which involved 15 reporting functions.
• Active participation in managing the Metadata
• End-to-end Unit testing of the ETL loads.
• End-to-end Unit testing of the Composite code
• Integrating the jobs with Scheduling application
• Testing the jobs in test environment through Control-M
• Implementation of the project in SIT, UAT and Production environments
• Interaction with business team to make the system meet the business requirements
• Active participation in production migration of the system
• Implementation and support of the project in SIT, UAT and Production environments
• Provided 24/7 on-call application support Production

Tools/Technology: Informatica 9.1, 9.5, IDQ 9.1.0, Unix, Korn Shell, Toad, Control-M, Oracle 11i, SVN, JIRA, Java.

Confidential, Raleigh, NC

Informatica Developer

Responsibilities:

• Prepare technical design documents like Impact analysis document, TSD
• Prepare low level design documents
• Developed IDQ mappings for validation and cleansing of source data
• Technical design of ETL/Informatica components
• Construction of ETL components and created Workflows
• Assisted ETL Analysts with creation of viable technical designs
• Integrating with scheduling software
• Participated in peer-peer reviews for code quality.
• Developed code to leverage multiple ETL environments for development, testing, and production
• Supporting the production conversion and troubleshooting data-related issues in a timely manner.
• Active participation in production migration of the system
• Implementation and support of the project in SIT, UAT and Production environments

Tools/Technology: Informatica 9.1, Unix, Korn Shell, Toad, Composite6.2, Autosys, Oracle 11i, SVN, Remedy, Java.

Confidential, Columbus, OH

Informatica Developer

Responsibilities:

• Gather the business requirements by interacting with the business team
• Preparing Technical Specifications document, analyzing Functional Specs
• Prepared Low Level design documents
• Developed IDQ mappings for validation and cleansing of source data
• Developing ETL mappings and its corresponding Sessions, Worklets and Workflows.
• Developed Composite views
• Modified existing Unix scripts to handle the new files
• End-to-end Unit testing of the ETL loads and Composite views.
• Implementation of the project in SIT, UAT and Production environments
• Testing the system through Control-M
• Application support in SIT, UAT and Production phases of the project
• Integrating with scheduling software
• Participated in peer-peer reviews for code quality.
• Active participation in migrating the system into production with minimum errors

Tools/Technology: Informatica 9.1, Unix, Korn Shell, Toad, Composite6.2, Control-M, Oracle 11i, Remedy, SVN, Java

Confidential, Columbus, OH

Informatica Developer

Responsibilities:

• Gather the business requirements by interacting with the business team
• Preparing Technical Specifications document, analyzing Functional Specs
• Prepared Low Level design documents
• Developed IDQ mappings for validation and cleansing of source data
• Developing ETL mappings and its corresponding Sessions, Worklets and Workflows.
• Developed Composite views
• Developed Unix shell scripts to handle the FTP process from source system to target system
• Developed Unix Shell scripts to handle File watcher job
• Developed Unix Shell scripts to run the jobs in an order as per the Metadata setup
• End-to-end Unit testing of the ETL loads and Composite views.
• Implementation of the project in SIT, UAT and Production environments
• Testing the system through Control-M
• Application support in SIT, UAT and Production phases of the project
• Integrating with scheduling software
• Participated in peer-peer reviews for code quality.
• Active participation in migrating the system into production with minimum errors

Tools/Technology: Informatica 9.1, Unix, Korn Shell, IDQ 8.6.1, Toad, Composite6.2, Control-M, Oracle 11i, SVN, JIRA, Java

Confidential 

Informatica Developer

Responsibilities:

• Preparing Technical Specs, analyzing Functional Specs, Development and maintenance of code.
• Developing complex ETL mappings and its corresponding Sessions, Worklets and Workflows.
• Informatica Mappings performance optimization
• Manage the Metadata for different types of source files coming in
• SQL query tuning for better performance
• Developed Stored Procedures
• Developed Unix Shell Scripts to run the series of jobs in an order as defined in the Metadata
• Developed Unix Shell scripts to handle the file validation
• Developed Unix and Pearl Scripts to handle the files coming through emails, this includes extracting the attachments from email, unzipping and moving the files into a source folder automatically
• Intensive end-to-end testing of the loads and extracts generated
• Intensive end-to-end testing of Data warehouse/Data Mart load.
• Implementation of the project in SIT, UAT and Production environments which involved testing at the depth for maintain the data quality
• Interacted with the business team at all levels of testing phases to confirm on meeting the business requirements and data quality
• Integrating with scheduling software
• Participated in peer-peer reviews for code quality.
• Active participation in migrating the code into production environment with no issues, this includes migration of more than 400 Informatica, Oracle and Unix objects
• Project enhancements: Created reusable components mentioned below:
• A UNIX script which automatically validates the XML files of mappings and workflows for coding standards
• A UNIX script which changes the format of any file into a standard format and this will be used as source to a reusable mapping
• Reusable mappings which contains the logic of all files in the project, so that when a new file comes in there is no need to develop a new mapping, we just need to upload the file to UNIX thereby the script changes the file’s format and the mapping loads the file.
• User-defined functions
• A UNIX script for insertion of metadata into database tables with the help of Stored Procedure.

Tools/Technology: Informatica v8.6, Informatica 9.0, UNIX, Pearl, Toad, Control-M, Java, Oracle 11i.