SUMMARY

• Over 8 years of experience in Oracle Database Administration on Design, Administration, Configuration, and Support for Pre and Post Production OLTP and Data warehousing systems
• Extensive Performance Tuning experience, specializing in Operating system tuning, SQL tuning, Database/Instance tuning
• Experience writing shell scripts to automate the deployment and maintenance of various administrative tasks.
• Efficient in troubleshooting and problem solving applications and Validating,Testing & Debugging Errors with in ETL Transformations with Informatica Debugger.
• Extensive experience in error handling and problem fixing in Informatica.
• Experience with Data Extraction, Transformation and loading from different data sources into a common analytical data model using informatica.
• Efficient in trouble shooting, performance tuning, and optimization of ETL and reporting analysis.
• Well versed with Unix Shell Scripting.
• Worked through all phases of Software Development Life Cycle (SDLC) - Waterfall and Agile (Scrum)
• Experience in using Informatica Debugger to test dataflow and fix mappings.
• Perform Informatica Power Center 9.1.x & higher, Power Exchange admin activities including,Upgrade and migrate PowerCenter 9.1 PowerCenter 9.5.1 to PowerCenter 9.6.1
• Responsible for code migration across Development, Test and Production environment.
• Administer projects, roles, user, and privileges across all three environments.
• Informatica repository and domain backup.
• Wrote Shell Script for Backup of multiple repositories, Delete Relational Connections, Checking the infa service.
• Delete and Export of Objects using shell script
• Removing unwanted files with frequent file system cleanup.
• Folder Validation using the shell scripts.
• Responsible for working with the Off Shore Team for Migration Activities
• Having greater ability to upgrade to new technologies.
• Strong analytical, problem-solving and organizational skills.
• Experience in providing 24x7 production support and maintenance of Database Servers on a rotation basis.
• Experience working with Oracle support on problem determination, troubleshooting, and resolution - SRs, running and submitting, gather scripts and log info, tuning, trace, taking thread and heap dumps.
• Well versed in the various procedures and processes involved in resolving outages and providing production support for multiple projects and working effectively with different groups in multiple environments (Development, QA, Production).
• Highly motivated self-starter with a strong analytical problem solving, having ability to multi-task, work in a team environment, understand and be responsive to customer needs, work under tight deadlines and work independently and be flexible, a good listener and have strong oral and written communication skills.

TECHNICAL SKILLS

Languages: PL/SQL, Unix Shell Script.

ETL: InformaticaPowerCenter 9.x/8.x/7.x

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

Operating Systems: UNIX(Sun - Solaris),Backtrack R3, Windows 7/8/XP/, Linux.

Data Modeling: Erwin, ER StudioDatabase Tools TOAD, SQL *Plus, PL/SQL Developer, SQL Developer.

Reporting Tools: Business Objects

Scheduling Tools: Autosys, Control M

PROFESSIONAL EXPERIENCE

Confidential, Tallahassee, FL

Oracle/INFORMATICA Administrator

Responsibilities:

• Responsible for code migration across Development, Test and Production environment.
• Administer projects, roles, user, and privileges across all three environments.
• Informatica repository and domain backup.
• Wrote Shell Script for Backup of multiple repositories,
• Delete and Export of Objects using shell script
• Removing unwanted files with frequent file system cleanup.
• Wrote Shell Script to DeleteRelational Connections
• Created Shell script for Checking the infa service
• Folder Validation using the shell scripts
• Upgrade and migrate PowerCenter 9.1 PowerCenter 9.5.1 to PowerCenter 9.6.1
• Extracting Domain and Application Service logs Seperately from Admin Console
• Strong Knowledge on Oracle 10g new features like data pump, flashback tables, ASM, ADDM, AWR, etc.
• Extensive experience handling DWH systems with Informatica application.
• Experience in providing 24x7 production support and maintenance of Database Servers on a rotation basis.
• Moved data between database using utilities like Export/Import.
• Created and managed different kinds of Tablespaces, extent and storage parameters.
• Created bash shell scripts on linux environment to manage archivelogs.
• Created new user accounts, profiles, and roles and assigned them to different users.
• Configured listeners on server side and TNS aliases on client side.

Confidential, Sunnyvale, CA

Oracle/INFORMATICA Administrator

Responsibilities:

• Responsible for code migration across Development, Test and Production environment.
• Administer projects, roles, user, and privileges across all three environments.
• Informatica repository and domain backup.
• Wrote Shell Script for Backup of multiple repositories,
• Delete and Export of Objects using shell script
• Removing unwanted files with frequent file system cleanup.
• Wrote Shell Script to Delete Relational Connections. granting privileges,roles,permissions in oracle
• Created Shell script for Checking the infa service
• Folder Validation using the shell scripts
• Monitoring database Performances
• Monitoring backup and scheduling backups
• Working with space issues(tablespace,filesystemisses)
• Extracting Domain and Application Service logs Seperately from Admin Console

Confidential

Informatica Developer

Responsibilities:

• Worked with business requirements analyst to identify and understand source systems.
• Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Filters, Sequence, Router and Update Strategy.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable transformation logic, known as ‘Mapplets’ using Informatica Designer.
• Modified several of the existing mappings and created several new mappings based on the user requirement.
• Used the Debugger in debugging some critical mappings to check the data flow from instance to instance.
• Created various tasks like sessions, worklets, and workflows in the workflow manager to test the mapping during development.
• Involved in Performance tuning of various mappings and sessions to increase the performance.
• Extensively worked on tuning and thereby improving the load time.
• Developed all the mappings according to the design document and mapping specs provided and performed unit testing.
• Used Workflow monitor to see the work flows running and get the session properties and session log.
• Performed unit testing and documented the unit test plan and its results.

Environment: Informatica Power Center 7.1.3, Oracle 9i, PL/SQL, SQL-Server 2008.

Confidential

Informatica Developer

Responsibilities:

• Worked on Informatica Designer Tool’s components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Involved in the development of Informatica mappings and also tuned for better performance. In the Mappings most of the Transformations were used like the Source Qualifier, Expression, Filter, Aggregator, Look Up, Update, and joiner, Sequence Generator, Sorter, Rank and Router.
• Used Unconnected Look Ups with the combination of Update Strategy to implement Type 2 Warehouse.
• Lookup tables were implemented at the staging level for the faster response time of Lookups.
• Extensively used Informatica’s Workflow Manager & Workflow Monitor tools to Load data from MS SQL Server, Oracle OLTP sources into the Target Oracle 9i Data Ware House.
• Applied event wait and even raise objects along with the email objects from error notification information.

Environment: Informatica Power Center 7.1.3, Oracle, PL/SQL, SQL-Server 2008.