SUMMARY:

• Over 10 years of IT experience in system analysis, design, coding, implementation, customization, testing and production support of business applications in Client/Server environment.
• Extensive noledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development, Testing and Production.
• Experience in Informatica Designer Tools like Mapping Designer, Source Analyzer, Target Analyzer, Transformation Developer, and Mapplets Designer to do teh ETL process.
• Experience in integration of various data sources wif Multiple Relational Databases like Oracle, Sybase and worked on integrating data from flat files like fixed width and delimited.
• Extensively used teh transformation components like Source Qualifier, Expression, Aggregator, Filter, Router, Sorter, Update Strategy, Lookup, Joiner and Sequence Generator.
• Performance tuning of Informatica mappings and SQL queries.
• Extensive experience in designing and working wif Oracle 8i/9i/10/11g and writing SQL queries and PL/SQL Procedures, Functions, Packages, Database Triggers, Exception Handlers, Cursors, Database Objects using PL/SQL and possess good understanding of oracle data dictionary.
• Experience in physical and logical data modeling using Erwin and TOAD Data Modeler.
• Experience in SQL Plus and TOAD as an interface to databases, to analyze, view and alter data.
• Experience in Actuate ERD Pro 8.0/7.0, Actuate Report Server, API, Actuate Active Portal.
• Extensive experience in Oracle Pro*C precompiler.
• Experience in working wif scheduling tools like Autosys.
• Performed various kinds of testing like Integration, Unit and User Acceptance testing.
• Excellent Interpersonal and Communication skills, coupled wif strong technical and problem solving capabilities.
• Work well independently or as a part of team.

TECHNICAL SKILLS

ETL/ Database Tools: Informatica PowerCenter 9.x, Toad, PL/SQL developer, ERwin, Toad Data Modler.

Programming Languages: PL - SQL, SQL, Shell Scripting, C, Pro*C, Vb 6.0

RDBMS: Oracle, Sybase

Reporting tools: Actuate 7/8, Crystal Reports and Orcale6i report builder

Operating System: Unix, Window 2000/XP

Other Tools: Autosys, ClearCase, HP Quality center, RTC, Github, Rational team concert, HP service manager

PROFESSIONAL EXPERIENCE

Senior developer

Confidential, MA

Responsibilities:

• Developed and enhanced various powercenter mapping to perform ETL operation while loading data from flat file, database to Oracle database.
• Created various PL/SQL objects like packages, procedures, functions, triggers etc to perform business operation.
• Extensively worked on materialized view and SQL queries tuning.
• Developed PL/SQL code for new requirements, enhancements and debugging of procedures, packages and other Oracle objects.
• Performing data analysis, identify data patterns to understand requirement more precisely.
• Working wif business analyst to deep understanding of teh business requirements and analyzing teh various scenarios and use cases.
• Working wif business analysis to understand requirement and created logical/physical data model.
• Working on re-engineering of SDR application’s CFTC module to come up more scalable solution.
• Working closing wif database migration team to migrate database from Solaris to Linux box.
• Coordinating wif various supporting team like Ops, DBA and release management team to deploy code in production environment etc.

Environment: Informatica 9.1.0, PL/SQL, Oracle 11g, Unix, Shell Scripting, ERwin, Toad Data Modeler, HP Quality Center, ClearCase, Rational team concert, Autosys.

Lead developer

Confidential

Responsibilities handling:

• Perform data analysis and identify data patterns, issues and trends.
• Developing a deep understanding of teh business domain, document business requirements and analyzing teh various scenarios and use cases.
• Working closely wif teh system analysts and project managers on multiple tracks.
• Developed PL/SQL code for new requirements, enhancements and debugging of procedures, packages and other Oracle objects.
• Created database objects like tables, views, synonyms, indexes, and sequences.
• Worked wif Power Center -Designer tool to develop mappings to extract and load teh data from flat files, Oracle to Oracle.
• Created various transformations like Source Qualifier, Joiner, Update Strategy, Rank, Expressions, Aggregator and Sequence Generator to load data into targets.
• Created reusable transformations and mapplets to use in multiple mappings.
• Created and ran debug sessions in teh Debugger to monitor and test teh sessions prior to their normal run in teh Workflow Manager.
• Tuned Mappings for optimum performance.
• Generated SQL and PL/SQL scripts to create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, synonyms.
• Wrote SQL queries for data and report validation in TOAD.
• Co-ordination wif different team wifin FIMT (e.g DBA, Release engineering and DB Ops) at both onsite and offshore for any technical issue, deployment, migration, database dumps. Also handing 4 members teams at offshore.
• L3 support and working on long term solution of frequent occurring incidents.
• Creation of UNIX shell scripts and using Autosys to schedule teh triggering of these UNIX shell script jobs.

Environment: Informatica PowerCenter 9.1.0, PL/SQL, Oracle 11g, Unix, Toad, HP Quality Center, RTC, Github, Rational team concert, HP service manager, Autosys.

Lead developer

Confidential, CA

Responsibilities

• Identified technical solutions to solve business requirements and provide technical leadership during enhancements and development.
• Provided analysis and fix for emergency production issues.
• Gatheird business requirements by conducting detailed interviews and one on one meeting wif business users, stakeholders and SME's.
• Extensively used TOAD and PL/SQL Developer for daily development jobs.
• Worked wif Business Systems Analysts and Database Administrators to understand and implement functional and non-functional requirements into teh project.
• Identified issues wif current database and resolved them. Installed and configured relevant components to ensure database access. Diagnosed and resolved database access and performances issues.
• Extensively worked on Actuate ERD Pro 8.0/7.0 report designer tool to develop teh complex repots using PL/SQL and T-SQL stored procedures.
• Worked wif Power Center -Designer tool to develop mappings to extract and load teh data from flat files, Oracle to Oracle.
• Created various transformations like Source Qualifier, Joiner, Update Strategy, Rank, Expressions, Aggregator and Sequence Generator to load data into targets.
• Co-ordination different team like production support, application release team to deploy code in production environment.
• Performed unit testing of Actuate erdpro 7/8 reports, Informatica tasks and also supported QA team for their QA/UAT testing.

Environment: T-SQL, Oracle 10g,PL/SQL, Sybase, Unix, Infromatica PowerCenter 8.x, Actuate e.Report designer professional 7/8, Perforce, Autosys, Rapid SQL

PL/SQL and Pro*C Developer

Confidential

Responsibilities

• Worked as a developer in creating complex Stored Procedures, packages, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Designed and implemented complex Pro*C batches, stored procedures and packages.Implemented constraints on tables.
• Created code packages to deploy teh code in higher environments like QA, UAT and Production.
• Independent unit testing(IUT) and System Integration testing of applications for performance, data Integrity
• Provided production support after teh system was delivered to teh client.
• Created indexes, constraints and rules on database objects.

Environment: Pro*c, PL/SQL, SQL, Oracle 10g, Java, Unix, SQL Developer, Toad.