SUMMARY:

• About 7years of experience in IT Industry involving Software Analysis, Design, Development, Integration, Maintenance, Reports, coding, bug fixing, creating specifications, maintenanceProduction implementation, testing.
• Developed mappings in Informatica to load the data from various sources into the Data warehouse different transformations like Source Qualifier, JAVA, Expression, Lookup, Aggregate, Update Strategy and Joiner.
• Database / ETL Performance Tuning: Broad Experience in Database Development including effective use of Database objects, SQL Trace, Explain Plan, Different types of Optimizers, Hints, Indexes, Table Partitions, Sub Partitions, Materialized Views, Global Temporary tables, Autonomous Transitions, Bulk Binds, Capabilities of using Oracle Built - in Functions. Performance Tuning of Informatica Mapping and workflow.
• Strong Knowledge in Data warehousing technology with skill set of Informatica Power Center, Informatica Power Exchange
• Advanced Skills in Programming using Oracle PL/SQL via, creating stored procedures, functions, database triggers and packages.
• Very good experience in complete project life cycle including Requirements gathering and Analysis, Database Design, Development, Testing, Implementation and Support.
• Experience in creating and maintaining schemas, table spaces, partitions, indexes, roles and privileges. Enforced and maintained database constraints to ensure integrity of the database.
• Extensive experienceOracle 9i/10g/11g,SQL Developer, PLSQL Developer, Stored Procedures, Database Triggers, Functions, packages under Unix & Windows platforms
• Used SQL Loader for bulk loads, experience in export/import features. Knowledge of fine-tuning of the SQL statements and database performance related issues.
• Extensive experience inStored Procedures, Triggers & Functions, Creating, and Replacing& Modifying database entity models, Object Oriented Concepts candidate with excellent experience in interacting with users, design, development, coding, bug fixing, creating specifications, maintenance, integration, implementation, testing & enhancements.
• Experience in translating business requests into Informatica DQ solutions
• Creating technical design documents for ETL jobs which include detailed specifications for developing mapplets, mappings and workflows.
• Possess strong skills inUnix Scripting, Unix Administration, PL/SQL programming,and Oracle Database Admin.
• Expert level skills inUnix/Linux server/environment buildswith respective to Cost, hardware, performance.
• Well-versed with different stages of Software Development Life Cycle (SDLC).
• Good knowledge ofCrystal Reports
• Extensively used PL/SQL to buildOracle Reports 10gand views for processing data, enforcing referential integrity and needed business rules.
• Expertise in Oracle 10g and migration of Oracle Reports from 4.x/6i/9i to Oracle 10g.
• Quick learner with ability to master new concepts and applications.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle.

SKILLS / TECHNOLOGIES:

Operating Systems: Windows 7/ XP/ NT/95/98/2000, DOS, UNIX, and LINUX

Database: Oracle 11g/10g/9i/8i, MySQL, MS SQL Server 2005, MS Access.

Programming languages: SQL, PL/SQL, UNIX Shell Script, ANSI C, C++, XML, HTML.

Tools & Utilities: Toad, Oracle SQL Developer, PLSQL,SQL, Informatica PowerCenter9.0/8.X/7X, Informatica Power Exchange 8.X

Reporting: Oracle reports 10g/9i/6i, MS Access, Crystal Reports, Actuate Reports.

Others: OOAD Methodology,Data Structures,RDBMS Concepts

PROFESSIONAL EXPERIENCE:

Confidential, Bethpage, NY

Datawarehouse ETL Developer

Responsibilities:

• Worked on Informatica Power Center 9.1.0 tool - Source Analyzer, Data Warehousing designer, Mapping & Mapplet Designer and Transformation Designer. Developed Informatica mappings and also in tuning of mappings for better performance.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Oracle and Informatica PowerCenter.
• Created reusable mapplets and Transformations starting concurrent batch process in server and did backup, recovery and tuning of sessions.
• Developed PL/SQL procedures/packages to kickoff the SQL Loader control files/procedures to load the data into Oracle.
• Extensively worked on Views, Stored Procedures, Triggers and SQL queries and for loading the data (staging) to enhance and maintain the existing functionality.
• Done analysis of Source, Requirements, existing OLTP system and identification of required dimensions and facts from the Database.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Written SQL Scripts and PL/SQL Scripts to extract data from Database and for Testing Purposes.
• Supporting daily loads and work with business users to handle rejected data.
• Developed Interfaces using UNIX Shell Scripts to automate the bulk load & update Processes.
• Stored reformatted data from relational, flat file, XML files using Informatica.
• Worked on various kinds of transformations like Expression, Aggregator, Stored Procedure, Java, Lookup, Filter, Joiner, Rank, Router and Update Strategy.
• Involved in monitoring the workflows and in optimizing the load times.
• Prepared UNIX Shell Scripts and these shell scripts will be scheduled in AUTOSYS for automatic execution at the specific timings.
• Migrated mappings from Development to Testing and from Testing to Production.
• Performed Unit Testing and tuned for better performance.
• Created various Documents such as Source-to-Target Data mapping Document, and Unit Test Cases Document

Confidential, Honolulu, HI

Oracle Pl/SQL/Informatica Developer

Responsibilities:

• Involved in Developing and handling the PL/SQL Packages, Procedures, Functions and Database Triggers.
• Developed stored procedures to extract the data from different sources and load it into data warehouse.
• Designed and developed complex Informatica mappings to dynamically create and load customer data in the target system.
• Integrated Data Quality routines in the Informatica mappings to standardize and cleanse the name, address, and contact information.
• Loaded data files into Oracle E-Business Suite interface using PowerExchange option in Informatica.
• Created reusable mapplets and Transformations starting concurrent batch process in server and did backup, recovery and tuning of sessions.
• Defined Interface parameters in Informatica mappings and sessions to initiate the concurrent programs (Stored Procedures) once the Interface tables are loaded.
• Analyzing the data needs for the customized reports. Mapping the data requirements developing Stored Procedures, Functions and Triggers.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Maintaining daily batch cycle and providing 24 hour production support.
• Supporting legacy systems with backups of all cases to/from parallel systems.
• Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.
• Utilized SQL*Loader to load flat files into database tables.
• Developed automated Korn shell scripts to schedule the load of flat files on daily, weekly and monthly basis.
• Worked with a team which Upgraded Oracle DB 8i to Oracle 10g.
• Used Various Database administrative tools such as Oracle Enterprise Manager, Erwin, Toad DBA Tools, and Data Migration Tools.
• Created Shell scripts to generate oracle reports and send to e-mail.
• ER diagrams are developed using TOAD Data Modeler.
• Involved in creating Cron jobs and Korn Shell scripts for running the daily loads.
• Involved in multi-tasking, creating and maintaining Partitioned Tables and Indexes for better performance of application
• Performed SQL tuning using Explain Plan, Tkprof, Hints and indexes.
• Involved in tuning of SQL queries by using Quest SQL optimizer and manually by Explain plan.
• Involved in handling the changes in compiling scripts according to the database changes.
• Conducted PL/SQL session for co-workers to educate about the latest PL/SQL features, PL/SQL performance tuning.
• Involved in building the reports in Crystal Reports and deployed the same in Business Objects server

Environment: Oracle 11g, Informatica Power Center 9.0,Toad, SQL * Loader, Toad, PL/SQL Developer, SQL*PLUS, UNIX Shell Scripting, Oracle Reports, HTML, and XML, Cognos.

Confidential, Chicago, IL

Oracle PL/SQL Developer

Responsibilities:

• Analyzed and overviewed the database design for better understanding the relations, associations and dependencies within the database.
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Developed complex queries on Data Warehousing and developed PL/SQL procedures to give in nice strategic plans to higher level of management.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements in Oracle data warehousing.
• Used Dynamic SQL programming technique to build and process SQL statements "on the fly" at run time.
• Developed PL/SQL scripts for Data cleansing.
• Developed UNIX shell scripts that help as a scheduler for data load.
• Made timely changes and fixes to all the modules on reported problems from the database administrator.
• Used TOAD, PL/SQL developer tools for faster application development.
• Performed SQL tuning using Explain Plan, Tk-prof, Hints and indexes.
• Wrote shell scripts to automate loading files into database using crontab, error handling and notification.
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Presented several technical presentations on Oracle database operation.
• Developed PL/SQL packages and procedures for the back end processing of the proposed data base design.
• Developed complex Oracle forms providing extensive GUI features (multi-selects drag and drop, graphical charts, automated system alerts and notifications etc.).
• Developed forms Using Tab-canvas, Stacked, Content and Horizontal toolbar canvas.
• Developed reports using complex queries as per client request as a part of production support.
• Generated the reports like list of the vendors, their supply schedule, actual deliveries and Inventory level of raw material.

Environment: Oracle 10g, PL/SQL Developer, SQL* Plus, SQL * Loader, SSIS, TOAD, Oracle Reports, HTML, XML, UNIX Editors and Debuggers.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Responsible for system study & information gathering.
• Development was done using front end as Oracle Developer/2000.
• Involved in creation of Tables using storage parameters and clusters.
• Involved in writing Database procedures, Functions, Packages and Database Triggers.
• Coded many generic routines (as functions), which could be called from other procedures.
• Developed user interface screens, Master detail relations and Report screens. Worked with DBA in making enhancements to physical DB schema.
• Coordinated with DBA in creating and managing table, indexes, table spaces, triggers, db links and privileges.
• Analyzed and designed tables based on small and large database transactions.
• Developed various Reports for the end users as per their requirements and created many reports to suit the given format of the company.

Environment: Oracle 9i/8i, Windows XP, PL/SQL, SQL*PLUS, SQL, C, k-shell, SQL*Loader, PL/SQL Developer Tool.

Confidential

ETL- Informatica Developer

Responsibilities:

• Requirements Analysis
• Prepared Design Documents
• Developed multiple reusable transformations.
• Develop onetime mappings, workflows, shell scripts and onetime executable as part of conversion project.
• Analysis.
• Scheduling the ETL jobs using Autosys.
• Testing and Implementation.

Environment: Informatica Power Center 8.5, Db2, Oracle 10g, UNIX, Windows XP.