Summary

Around 12 years of IT eve production support to various Applications along with server Maintenance projects 24x7.

Skill Profile

Projects Summary

Role : Sr. ETL Informatica Developer

Description

Wyndham Hotel Group offers brands in lodging franchising, vacation ownership, vacation rentals and vacation exchange. It is composed of nearly 7,400 hotels under 15 brands spanning 66 countries in 6 continents.

This project responsibility is to develop an Enterprise DataWarehouse EDW . This responsibility of this project to completely integrate the business to single environment.This data warehouse is used to access easily the detailed data on a single platform and also to facilitate the enterprise-wide data analysis to Reporting within the business environment. This Data Warehouse is build using Informatica Power Center 9.1.0 for extracting data from various sources including flat-files, Oracle-ERP, Teradata and Oracle.

Responsibilities:

• Responsible for Requirement Gathering Analysis and End user Meetings
• Responsible for Business Requirement Documents BRD's and converting Functional Requirements into Technical Specifications
• Responsible for mentoring Developers and Code Review of Mappings developed by other developers
• Extracted data from various heterogeneous sources like Oracle, SQL Server, and Flat Files.
• Responsible for Production Support and Issue Resolutions using Session Logs, and Workflow Logs
• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation, Rank Transformation, and Aggregator Transformation.
• Responsible for best practices like naming conventions, Performance tuning, and Error Handling
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level
• Solid Expertise in using both Connected and Un connected Lookup transformations
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache, and Persistent Cache
• Developed Re usable Transformations, and Re- Usable Mapplets
• Worked with Shortcuts across Shared and Non Shared Folders
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Used Update Strategy DD INSERT, DD DELETE, DD UPDATE, AND DD REJECT to insert, delete, update and reject the items based on the requirement
• Worked with Session Logs, and Workflow Logs for Error handling and Troubleshooting in all environment
• Responsible for Unit Testing and Integration testing of mappings and workflows.

Environment : Informatica Power Center 9.1.0, Windows 7, Oracle Database 10g/11g, DB2, SQL, PL/SQL, SQL Plus, PL/SQL Developer, TOAD, Team Tracker, PVCSVM, UNIX.

Confidential

Role : Sr. ETL Informatica Developer

Description

The Main object of the project to convert the Global HR data in to Workday HR Business application and construct various reports like direct reports, org chart report, compensation report and various employee information reports like paygrade and job profile reports based on hierarchy levels.

Responsibilities:

• Analyze the source systems data and the current reports at the client side to gather the requirements for the Data Warehouse Model.
• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from various sources like Oracle, sql server and Delimited Flat files.
• Converting employee data from all across the globe J J numerous HR systems to load into Workday Cloud application.
• Developed normalized Logical and Physical database models to design OLTP system for the applications
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r7.1
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow manager.
• Profile source data using IDQ tool, understand source system data representation, formats data gaps Created Exception handling process and worked on the best practices and standards for exception handling routines.
• Proficiency in building scorecards and applying metrics and group the dimensions.
• Used Teradata utilities fastload, multiload, tpump to load data
• Contributed and maintained a library of reusable test plans for future projects/enhancements.
• Worked in IDQ complex transformations, used address validator, keygen, match, Parser, merge transformations and exception transformations.
• IDQ is used for data cleansing, Tuning and profiling and Implemented reports, dashboards to display DQ results.
• Informatica Data Quality helps make Data Quality improvement and standardizing on a single platform that provides a centralized set of reusable rules and tools for managing Data Quality across any project
• Worked on identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• ETL architecture and design of data integration from different sources - legacy, relational and 3rd party data from various countries.
• Prepared various mappings to load the data into different stages like Landing, Staging, Work and Core tables.
• Applied slowly changing dimensions like SCD Type 1 and 2 effectively to handle delta Loads.
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping.
• Created various tasks like Session, Command, Timer and Event wait.
• Lead the development team during the development process, this include provide help with the tasks and transfer knowledge of Informatica.
• Automated the Informatica jobs using UNIX shell scripting.
• Coordinated the migrations to QA , UAT and production environments.
• Closely worked with the reporting team to ensure that correct data is presented in the reports.
• Parameterized the mappings and increased the re-usability. created reusable transformations and mapplets for reusability and efficient way of coding
• Defining and implementing the standards, shared components and approaches as per the J J Standards.
• Created post-session and pre-session shell scripts and e-mail-notifications for successful and failure scenarios.

Environment: Informatica Power Center 9.1.0, Data Quality IDQ 9.1, Power Exchange 8.1.2, Oracle11g, DB2, Erwin 7.1, SQL, UNIX Shell Script, SQL Server, Windows 7.

Confidential

Role : Sr. ETL Informatica Developer

Description

United Parcel Service, Inc. typically referred to by the acronym UPS, is a package delivery company. Headquartered in Sandy Springs, Georgia, United States, UPS delivers more than 15 million packages a day to 6.1 million customers in more than 220 countries and territories around the world.

Built a central Database where data comes from different sources like Oracle Applications, SQL server and flat files. Actively involved as an Analyst for preparing design documents and interacted with the data modelers to understand the data model and design the ETL logic.

Responsibilities

• Created mappings to load identified master records into Central Repository for DW load process.
• Prototyped Dimension Model ETL process by matching the business requirements and core technical requirements from reporting team.
• Load operational data from Oracle, SQL Server, flat files, Excel Worksheets into various data marts like AP and GL.
• Worked as part of the architect team to develop complete star schema Snow Flake for the Phase I of the Data Warehouse.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Worked on implementation of ETL Dimension prototype with complex mappings mapplets making reporting smoother and effective.
• Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Created complex mappings for Data Marts with fact less facts.
• Tested performance for ETL mappings hitting with worst data scenarios and making necessary changes to harmonize with daily DW time frame.
• Created mappings for updating Date DIM on daily and yearly basics for Market days, Business days for calendar and financial year.
• Assumed responsibility for deploying code to test, stage production and smoother turnaround with issues across environments.
• Suggested changes in ETL development process which improved productivity and ability to hit the target plans with less overhead
• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements.
• Created materialized views normal views where business requirements needed.
• Tuned the SQL queries and complex procedures to improve performance. Used EXPLAIN PLAN and Toad/SQL Navigator for tuning the queries.
• Design complex mappings involving constraint based loading, target load order.
• Use debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations and Create mapplets that provides reusability in mappings.
• Debugged existing code for business logic issues.
• Worked on Unix environment and shell scripting for creating Batch Jobs using UNIX KORN, AWK UNIX Shell Scripts.
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.

Environment :Informatica Power Center 8.6.1 Hot fix 12, Windows 7, Oracle Database 10g/11g, DB2, Oracle Forms 6i/10g, Oracle Reports 6i/10g, SQL, PL/SQL, SQL Plus, SQL Loader, PL/SQL Developer, TOAD, Team Tracker, PVCSVM, UNIX.

Confidential

Role : ETL Informatica Developer

Description

• Confidential is the world leader in the manufacture, distribution and service of electronic test tools and software.A wholly owned subsidiary of Danaher Corporation NYSE:DHR , Fluke is a multi-national corporation headquartered in Everett, Confidential. Manufacturing centers are located in the USA, the UK and The Netherlands. Sales and service subsidiaries are located in Europe, North America, South America Asia and Australia.
• Informatica ETL tool connects to flat files, databases: Oracle, SQL Server, Teradata for various source systems via data distribution environment DDE and target systems.

Responsibilities

• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow manager.
• Designed and developed the data transformations for source system data extraction data staging, movement and aggregation information and analytics delivery and data quality handling, system testing, performance tuning.
• Designed Informatica mappings by translating the business requirements.
• Developed mappings for Sales, Orders and Orders Received metrics.
• Studied Session Log files to correct errors in mappings and sessions.
• Wrote pre session and post session scripts in mappings.
• Performed data manipulation using basic functions and Informatica Transformation.
• Performed unit testing for the mappings using SQL scripts.
• Wrote SQL overrides in source Qualifier according to business requirements.
• Developed PL/SQL procedures as per requirement and called them in transformations.
• Configured and ran the Debugger from within the Mapping Designer to troubleshoot predefined mapping.
• Worked extensively on Informatica transformations like Source Qualifier, Expression, Filter, Router, Aggregator, Lookup, Update Strategy, etc.
• Wrote Stored Procedures for customized transformation.
• Involved in creation of Mapplets, Worklets, Reusable transformations, shared folder, and shortcuts as per the requirements.
• Used various techniques to identify the Performance bottleneck of Informatica Jobs and tuned them as per Informatica given Standards.
• Used the Explain Plan, Hints, Analyze commands, statistics, and indexes for better performance of SQL queries.
• Created and altered tables and views based on the new version and functionality.
• Created modified stored procedures used for legacy applications.
• Tuning of the queries by creating the Indexes, Hints on the required Columns for reducing the cost of the query and improves the performance of the reports.
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger Wizard.
• Experience in Error handling and debugging coding issues and troubleshoot production problems
• Verify the Unit test plan, codeandIG of other consultants.
• Preparation of technical specification from functional specification.

Environment :Informatica Power Center8.1.6, SQL Server 2005,Windows 2000/XP, HP-Unix 11.0, Oracle 11g/10g/9i,Teradata, SQL, PL/SQL, UNIX Shell script, Toad, SQL Loader.

Confidential

Role : ETL Informatica Developer/ Analyst

Enterprise Data Warehouse is a consolidated Data warehouse of ERP, Non ERP Legacy Systems to consolidate all of the Motorola Orders, Shipment, and Inventory Revenue related information. Producing near real time information to Motorola decision makers for Corporate Finance. The near real-time date is produced with the multi layered architecture processing for every 4hrs.Different subject areas like Revenue,Shipments,Inventory,Orders,Supply,Demand, Customer,Geography,Calender,ExchangRates, Supplier/Vendor Market have been integrated.

Responsibilities:

• Using the Informatica Data Transformation technologies B2B Data Transformation , Data Exchange platform to parse, map, serialize and split data in unstructured, semi-structured and complex XML formats
• Develops Informatica data transformation designs.
• Works with Data Integration developers to develop Data Integration Workflows and load processes.
• Ensures adherence to proprietary and open data format standards for all developed components
• Performs data analysis for source and target data
• Performance tuning by optimizing the sources targets mappings and sessions.
• Created various batch Scripts for scheduling various data cleansing scripts and loading process.
• Extensively worked on Mapping Variables, Mapping Parameters and Session Parameters.
• Provides technical documentation of transformation components.
• Supports the development and design of the internal data integration framework.
• Participates in design and development reviews.
• Analyze the source systems data and the current reports at the client side to gather the requirements for the Data Warehouse Data Model
• Study the relation at the source systems
• Worked as part of the architect team to develop complete star schema Snow Flake for the Phase I of the Data Warehouse
• Create the naming standards for the DW team.
• Worked on developing all the mapping needed to load the staging area of the DW
• Lead the development team during the development process, this include provide help with the tasks and transfer knowledge of Informatica
• Developed mappings/workflows to load both dimensions/facts and lookup tables for Cognoes
• Perform QA and Code review for my code and other developers code

Environment: Informatica Power Center 8.1, Oracle 10g,Microsoft Office 2007 Mainframes, SQL, UNIX Shell Script, Cogon's.

Confidential

Role : ETL Informatica Developer

Description

Logitech is the world leader for designs personal peripherals to help people enjoy a better experience with the digital world. Which started in 1981 with mice, which new at the time provided a more intuitive way of interacting with a personal computer Which became the worldwide leader in computer mice, and have reinvented the mouse in dozens of ways to match the evolving needs of PC and laptop users

Responsibilities

• Worked with Business Analysis team in gathering the requirements and created Functional and ETL specification documents.
• Analyzed the Business Requirement Documents BRD and laid out the steps for the data extraction, business logic implementation loading into targets.
• Involved in gathering information for various scenario for Change Data Capture.
• Worked with DBA to set up the DEV and QA environment and various users and roles
• Extensively worked with Informatica Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Workflow Manager, and Workflow Monitor to develop various complex mappings, mapplets, reusable transformations, session tasks and Workflows.
• Performed extraction, transformation and loading of data from different sources like Flat Files, DB2 in accordance with requirements and specifications. Performed extraction of data from mainframe/Cobol/vsam file sources and oracle table sources
• Used workflow monitor to monitor the jobs, reviewed session/workflow logs that were generated for each session to resolve issues, used Informatica debugger to identify issues in mapping execution.
• Used Workflow manager to create and configure workflow and session task to load data. Used Informatica workflow monitor to create, monitor workflow in case of process failures.
• Creating tasks, sessions, events, timers etc in the workflow manager and monitoring them in the workflow monitor.
• Worked with PMCMD to interact with Informatica Server from command mode and execute the Shell scripts.
• Involved in system testing, performance and System Integration testing stages of the project.

Environment: Informatica Power Center 7.1.2,Power Exchange 7.1.2, DB2 8.2, Oracle10g, SQL, UNIX Shell Script, SQL Server, Windows2000/NT.

Confidential

Role : Oracle PL/SQL Developer

Description

Essiloris the world's leading provider of eyeglass lenses our number one priority has always been you, and customer. So which've been busy improving the way people see the world for over 150 years, At Essilor, which are intensely dedicated to research and innovation. So which strive to create the most beautiful, comfortable and durable corrective lens designs in the world. With their tradition of excellence and technological advancement in the optical field and with a passionate management staff of experienced professionals, Essilor is truly the work of geniuses.

Responsibilities

• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Provided Production support for various batch processes and also created the schedule for newly incorporated batch programs and processes.
• Wrote DDL, DML scripts for Schema, Table space and Cluster creation and alteration.
• Involved in full life cycle of the system developing.
• Refreshed Test environment with Production database image using full database Clone.
• Created and modified SQL Plus, PLSQL and SQL Loader scripts for data conversions.
• Analyzed the existing method for data repository refresh and then developed a new package with tuned queries to improve the performance and reduce the time taken for the refresh.
• Created tables, indexes and constraints.
• Created Triggers, Stored procedures for implementing the business logic.
• Administered of all SQL server database objects,logins, users and permissionsin each registered server.
• Managed Database files, transaction log and estimated space requirements.
• Maintained databases, tuned queries and administered users using Query Analyzer.
• Managed ongoing activities like importing and exporting, backup and recovery.
• Involved in testing, bug fixing and documentation for the project
• Analyzed the business requirements, carried out process mapping and gap analysis.
• Reviewed and analyzed the process and made independent recommendations to the Project Team Design.
• Worked collectively with other business areas including, planning, and finance to ensure that manufacturing function fully integrates with other business process.
• Worked on Performance Tuning of different SQL and PL/SQL queries for reducing the cost of the query and effective utilization of Cost based Optimization and explain plan.
• Support to production environment for Order Management.
• Created report for duplicate receiving receipts.Created a methodology to archive the old closed Pos and deletes the finally closed Pos.
• Preparation of Test Scripts for Testing Business Processes and the enhancements/fixes

Environment : Windows 2000/XP, HP-Unix 11.0, Oracle 10g/9i, SQL, PL/SQL, D2K Forms Reports , UNIX Shell script, Toad, SQL Loader .

Confidential

Role : Oracle PL/SQL Developer

Description

This system was developed for a leading producer and supplier of Fertilizers and Pesticides along with other chemicals. The system consists of five modules namely, Purchases, Production, Sales, Inventory, and Administration. The tasks involved working on two modules namely, Inventory control and Sales management. Inventory module deals with Products Profile, Invoice put up and processing, Stock Updates, Products delivery and dispatch, Bills Processing etc. Sales module deals with Customer Information, Transportation Details, Sales Orders, Price lists, Invoice cum Delivery Challan, and Sales Returns etc.

Responsibilities

• Performed Requirement Analysis, System Design, Coding, Testing and Implementation.
• Developed Masters Transactions forms using Forms 6i various Reports through Reports 6i.Developed required code using PL/SQL.
• Created several adhoc customized Report queries using Discoverer 6i.
• Performed Unit Testing, coordinated UAT Implemented the Application.
• Maintained the Application the Systems.
• Actively involved in providing training to End-Users.
• Analyzed queries using SQL Trace facility and Explain Plan utility to obtain the execution process. Optimized the queries by modifying the data access methods, Index strategies, Join types and operations and providing hints
• Created Batch Jobs and UNIX Scripts to automate the process.
• Wrote PL/SQL programs to read from files, upload data, and mass updates/inserts of data based on certain business policies.
• Modified existing codes and developed oracle Reports, PL/SQL packages to perform Certain Specialized functions / enhancement on oracle Application.
• Involved in XML parsing and loading XML files into the database.
• Involved in using of new features of Oracle 11g like Analytical functions, Flash back Query, regular expressions etc.,
• Involved in the restructuring and fine tuning of the existing SQL Queries according to the new requirement using TKPROF, AWR.
• Responsible for performing Code Reviews.
• Used UTL FILE package for writing DBMS OUTPUT messages to file.
• Used an in house defect tracking tool and Clear Case for defect tracking.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.
• Worked on Unix environment and shell scripting for creating Batch Jobs using UNIX KORN, AWK UNIX Shell Scripts and API's Using PEARL Scripts.
• Involved in providing 24/7 database production support and troubleshooting data quality and integrity issues.
• Involved in SQL Tuning by creation of Indexes, Rebuilding Indexes, and Clusters etc.
• Also performed System Network Administrators role during my period in this firm.

Environment: Windows 2000, Oracle 8i, SQL, PL/SQL,D2K Forms Reports ,TOAD, SQL Loader, Import and Export.

Confidential

Role : Software Engineer

Description

The project involves automating all operations like stock management of gas cylinders, maintaining the details of number of cylinders each customer posses, Defects in cylinders of the present stock, and cost maintenance. All the automated Operations are efficiently implemented.

Responsibilities

• Developed Packages to validate raw data from Flat Files and insert into tables.
• Involved in the data transfer creating tables from various tables, coding using PL/SQL, Stored Procedures and Packages.
• Customized the Reports in Cross Tab Layout and Tabular Layout Formats.
• Designed and Developed scripts for uploading data from flat files and XML files into database, performing business validations on the data using PL/SQL Procedures.
• Created triggers and PL/SQL procedures and responsible for SQL tuning and security.
• Involved in Unit Testing, Functionality testing and coordinated the UAT. Also debugged the application with at most accuracy and in least time.
• Created Forms through Oracle form Builder templates as for Form design using Visual attributes, Property Classes, Alerts, Messages, Object groups and Tool bars.
• Contribution as an effective team member in the design and development of sales and purchase information system.
• System of the company using WinNT and Oracle 8i for the company. Subsystems included physical creating billing, sales of the company, Maintaining customer care and service order, billing, processing etc.
• Responsibilities include implementation of security of data according to client's requirements by creating views.
• Generation of trigger for data integrity.
• Design and development of forms and reports.
• Unit test case preparation and testing.
• Coding of stored procedures forReports 6i.

Environment: Oracle 8.0, SQL, PL/SQL, TOAD,Developer 2000 Forms 4.5 and Reports 2.5 and Windows98.