PROFESSIONAL SUMMARY:

• 7+ years of IT experience in all the software development phases analysis, design, development, testing, implementation & maintenance
• Knowledgeable Oracle developer skilled in data collection, analysis, management
• Advanced knowledgeable professional of SQL, PL/SQL, Eagle Star/Pace, Informatica Power Centre components(Repository manager, Designer, Workflow manager, Workflow monitor), Investment Banking operations, PERL scripting
• Experience of working with Informatica complex mappings using different transformations like Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator
• Effective knowledge of Tables, Indexes, Materialized views, Analytical Functions, Query writing
• Knowledgeable professional of database tuning and performance improvement using Explain plans & HINTs
• Good knowledge of key Oracle Performance related features such as Query optimizer, Execution Plans, Indexes
• Strong experience in Data warehouse concepts and ETL
• Strong knowledge of Investment banking functions like Security services, Portfolio accounting, Derivatives, Capital markets and Risk & Compliance
• Working knowledge for different Insurance clients
• Good knowledge in logical and physical data modelling using normalizing techniques
• Developed complex database objects like Stored procedures, Functions, Packages, Triggers using SQL & PL/SQL
• Excellent analytical & technical skills to understand the business need and develop design model to meet the exact requirement
• Knowledge of Oracle provided packages, Dynamic SQL, Records and PL/SQL tables
• Knowledge of database partitioning, Ref cursors, External tables, Exception handling and Collections
• Strong experience in ETL tools like Eagle STAR/PACE and Informatica Power Centre
• Knowledge PERL scripting for file processing
• Experience of technical documents writing such as Design document, Unit test plans, Play Books
• Good experience in Production migration activities and post migration validation activities
• Experience in VB.net to create reports using Active Reports 3.0
• Carried out peer code review, system & regression testing
• Ability to work on production issues under pressure and deliver timely solution
• Excellent communication skills, analytical skills and good team player

TECHNICAL SKILLS:

Databases: Oracle 10g/11g, MS SQL SERVER 2008 and MS Access

ETL Tools: Eagle STAR/PACE (9/11/12/13/15), Informatica (PowerCenter 9.1.0), Fenergo

Reporting Tools: Active reports 3.0/11 with VB.net

Operating Systems: Windows 2000/2007/2010 & Windows XP

Languages: SQL, PL/SQL, Perl scripts, VB.net

Eagle Utilities:Uploader, Exporter, Message Center, Web Panels, Advanced Reporting, OLAP, DataMart, Eagle Performance, Portal Query, Process Manager, STAR schedulers, SRM/RDC, DVC, Rules Editor, Eagle ML & IWS

Tools: Oracle SQL Developer, Toad, SQL Tools, Remedy, JIRA, GEIRS, Harvest, Service - Now

PROFESSIONAL EXPERIENCE:

Senior Developer

Confidential - Jersey City, NJ

• Developed PL/SQL stored procedures, Functions, Packages to process and upload the data into DB
• Written stored procedures to generate reports out of database
• Worked on performance tuning of long running stored procedures to minimize the cost
• Worked on exception handling for ease of debugging and displaying errors
• Developed complex queries to process the complex ledger data
• Written PERL script for file processing such as splitting file, adding header/ footer, modify file records &delivery format change
• Developed different utilities using Eagle Product to upload & export data
• Directly worked with operations team to understand the problem and develop perfect design model
• Worked directly with business team to carry out UAT
• Developed code fixes & enhancements to include in future code releases and patches
• Responsibility of managing offshore team, worked as onsite co-ordinator
• Supported production migration activities
• Worked on Production issues and bug fixes on real time data
• Performed peer code review and suggested improvements

Developer

Confidential

• Developed stored procedures, functions & packages, PL/SQL scripts for data manipulation
• Developed Perl scripts for file processing
• Developed Informatica power centre components for data manipulation
• Developed advanced reports using VB.net & Active reports
• Worked on conversion of VB6 code to VB.net for creating reports using Active reports 3.0
• Worked Eagle utilities like Uploader, Exporter, Message Center, Web Panels, Advanced Reporting, OLAP, DataMart, Eagle Performance, Portal Query, Process Manager, STAR schedulers, SRM/RDC, DVC and Rules Editor, Eagle ML & IWS
• Performed Backend testing to verify the data integrity by passing SQLQueries
• Worked on technical documentation writing such as design document, test plans, training documents
• Worked on Organizational level documentation such as case studies, product capability documents, status reports
• Involved in different knowledge transition & training sessions for entry level resources
• Carried out peer code review and system testing