EXPERIENCE SUMMARY:

• 8 years of experience in software industry in analysis, design, development, testing, deployment, project management and production support of Data Mart, Data Warehouse systems.
• Extensive experience in Informatica Power Center, Oracle PL/SQL and UNIX Shell Scripting.
• Well versed with the SDLC (Software development Life Cycle Process) especially with the Waterfall model and Agile SCRUM method.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelling and design techniques.
• Knowledge in Data Modeling using Star/Snowflake Schema Design, Relational and Dimensional Data Modeling, Fact and Dimensional tables.
• Strong experience in understanding business Scope, Design, Development, Customization and Production Support of Informatica Power Center 9.5.x, Informatica Power Center 8.6.x projects, UNIX, Oracle and SQL Server
• Profound knowledge in complete life cycle development of Data Warehouse: Data Analysis, Design, Development, Implementation and Testing using Data Extraction, Transformation and Loading (ETL).
• Extensive experience in integrating Informatica and other applications over UNIX/Windows platform.
• Developed database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Extensive experience in designing & implementing Cross Product and Coordinating Activities between multiple stakeholders.
• Experienced in Integrating and working with various Databases including ( SQL, Oracle, Flat files)
• Expertise in Data Cleansing, Root cause analysis and necessary Test plans to ensure successful execution of the data load Process.
• Extensive experience in design and creation of ETL mappings and Transformations using Informatica to move data from multiple sources into target using transformations like Source Qualifiers, Expressions, Lookups, Filters, Routers, Joiners etc.
• Extensively created mapplets, common functions, reusable transformations, look - ups for better usability.
• Experience in scheduling of ETL jobs using Autosys, Control-M.
• Extensively used SQL*Loader to load data from external files into tables of an Oracle database
• Ability to work effectively and efficiently in a team and individual environments with excellent interpersonal, technical and communication skills.

TECHNICAL SKILLS:

Data Warehousing: Data Warehousing Concepts

Methodologies: Software Development Life cycle (SDLC),Waterfall and Agile Methodology

ETL: Informatica Power Center 8.x/9.x

Scripting Tools: UNIX Shell Script

Database: Oracle 11g,10g/9i,SQL Server

Software Autosys,Control: M

Version Manager: Visual SourceSafe, CVS, SVN

Tools: Toad, FileZilla, WinSCP, PL/SQL Developer,SQLdeveloper and SSIS

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Informatica Developer

Responsibilities:

• Currently playing Sr.Informatica Developer role in the project where the core development was carried out using the AGILE methodology.
• Involved in Proof of Concept for evaluating Order Processing reports for Western Hemisphere Integrated Supply Chain Management.
• Used Informatica’ s features to implement Type I, II changes in slowly changing dimension tables and also developed complex mappings to facilitate daily, weekly and monthly loading of data.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Created mappings using various Transformations like Source Qualifier, Expression, Filter, Router, Joiner, Stored Procedure, Lookup, Update Strategy and Sequence Generator.
• Modified PL/SQL stored procedures, materialized views, tables for Informatica mappings.
• Created Parameter Files for Daily/Weekly/Monthly and On-Demand workflows and monitor them and provide quick resolution on the issues faced.
• Involved in data analysis and handling the ad-hoc requests by interacting with business analysts, clients and customers and resolve the issues as part of production support.
• Responsible for performing the impact analysis in case of new Change Requests from Business In terms of database change, ETL change and performance tuning.
• Also create Change Requests in case of ETL/database enhancements and coordinate with other teams ensuring that the changes are migrated successfully from Dev to TEST to Production.
• Created Test Case/Test Log documents and SQL queries for Unit and System Testing.
• Wrote UNIX shell Scripts and used PMCMD commands for FTP of files from remote server.
• Implemented sending of Post-Session Email once Serial Number data is loaded.
• Involved in creating DR’s (Discount Requests) for all Xerox Customers to ship products to respective SHIP TO locations.
• Implemented a module which sends the invoices generated across all the Xerox Brazil and Mexico Customers to respective government areas.
• Implemented a major feature in the application to upload the items in bulk mode of PO’s by giving all the required details according to the business template which saved lot of time for the users.
• Helped business team in resolving some of the critical issues in quick turnaround time.
• Interact with the clients on a regular basis to discuss day-to-day requirements, issues and matters.

Confidential

Sr. Informatica Developer

Responsibilities:

• Worked atconceptual/logical/physical data model level according to requirements.
• Worked as analyst for comparing and selecting reporting tool for the program and also was part of the architecture team which involved validation of the existing WOE (Web Order Entry) architecture and designing the future WOE architecture blueprint.
• Developed the required data warehouse model usingStar schemafor the generalized model.
• Created supply net reports to send to XSN (Xerox Supply Net) main frame systems.
• Created BOM (Bill of Material) items as per business requirements for order processing.
• Developed complex workflowsand used various tasks likeEmail, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Sessionin the workflow manager.
• Worked with heterogeneous source to Extracted data from Oracle database and flat files and loaded to a relational Oracle warehouse.
• Extensively worked on performance tuning at all levels of the Data warehouse. Implemented performance tuning by using lookup caches, gathering stats, dropped indexes and re-created them after loading data to targets and increased the commit interval.
• Implemented SFTP, FTP services to retrieve Flat Files from the external sources, created UNIX shell scripts to connect external servers using SSH, SFTP and FTP process.
• Loaded data from multiple data files during the same load session and also into multiple tables during the same load session.
• Manipulate the data before loading it using SQL *Loader, using SQL functions to increase the performance of processing the data
• Developedshell scriptsfor Daily and weekly Loads and scheduling them usingUnix Cronutility and Control M
• Performed Code and quality reviews on the deliverables to deliver the robust, reusable and defect free solutions with high performance
• Migrated repository objects and scriptsfrom development environment to QA and to production environment

Confidential

Informatica Developer

Responsibilities:

• Analyzing the current application code and developing/modifying the existing Mappings as per the new requirement.
• Designed and developed Informatica Mappings and Sessions based on user requirements and business rules to load data from source flat files and oracle tables to target tables
• Implemented complex mapping such as slowly Changing Dimensions Type 2 using Flag.
• Extensively worked with Aggregator, Sorter, Router, Filter, Join, Expression, Lookup and Update Strategy, Sequence generator transformations.
• Created the Views, Stored procedures and Functions to pull the data from Order Management system and send to Order Processing system
• Created RLOT (Revenue left on Table Reports) which shows all the Revenue left for purchase orders of all Xerox Customers.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, work lets, Assignment, Timer and scheduling of the workflow.
• Developed the PPM reports using stored procedures and shell scripts and send to Xerox USA and Europe Customers through SFTP.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Tuned mappings using Power Center-Designer and used the best practices to provide maximum efficiency and performance.
• Developed Pre and Post SQL scripts to drop and/or create indexes on Target tables to optimize loading query speed.
• Automated the processing of Import Order feed to mainframe system.
• Developing and scheduling the SSIS packages
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Involved in maintenance,bug fixes & request analysis of the existing reports

Confidential

Informatica Developer

Responsibilities:

• Understanding the existing system, business requirements and executing new change requests for enhancing the existing system.
• Preparing ETL specifications for identifying sources, targets and data transformations.
• Extensively Developed Informatica mappings using various transformations like Joiner, Lookup, Source Qualifier, Filter, Rank, Router, Sequence generator, Normalizer, Update Strategy transformations.
• Created Item Balance Report to view available items and quantities of Xerox customers for particular PO.
• Created Invoice and Serial number reports and transfer to mainframe systems on daily basis.
• Exported and Imported mappings between different Informatica folders and also Repositories
• Developing CRON tabs to execute the above Informatica extracts in an orderly manner.
• Make sure that all the daily, monthly data loads are happened and should be available to Business on time.
• Operations support (OPS) monitoring for the Informatica loads in all the production systems.
• Running the failed Daily, Weekly, Monthly DW/RPT reports.
• Providing end-to-end support for all the activities that is being carried out in the OPS monitoring process.
• Hands on experience in creating the Views, Stored procedures and Functions.

Confidential

Informatica Developer

Responsibilities:

• Created new procedures, functions, triggers, packages, and SQL*Loader scripts, and modified existing codes, tables, views, and SQL*Loader scripts
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
• Involved in extracting the data from the Flat Files and Relational databases into staging area
• Developed ETL programs using Informatica to implement the major feature related to maintaining Shipment and Delivery data of the products in Supply chain Management system.
• Developed Orders Status Report (OSR) component using Mappings, stored procedures and Shell scripts which maintains the status and details of all the orders starting from BOOKED to CLOSED.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow
• Involved in setup of Items related to Xerox USA customers
• Performed unit testing for the mappings and system testing to check data consistency with adherence to the data model defined.
• Tuned SQL queries to improve response time and managed the job scheduling using Autosys
• Fixed the invalid mappings and troubleshoot the technical problems of the database
• Monitored performance and changed performance requirements through application of Database tuning and performance optimization techniques

Confidential

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production
• Created new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Developed mappings/sessions for data loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup, Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Write Shell script running workflows in Unix environment.
• Optimizing performance tuning at source, target,mapping and session level
• Tuned SQL queries to improve response time.
• Wrote UNIX shell scripts to run SQL scripts daily.
• Extensively worked in performance tuning of programs and processes.
• Worked closely with DBA for proper backup and recovery plans.
• Monitored performance and changed performance requirements through application of Database tuning and performance optimization techniques