SUMMARY

• 7 years of Software industry professional experience in development of object oriented, n - tiered distributed and client/server applications and Web applications.
• Developed and designed the applications based on the n-tier architecture specifications.
• Experience with SDLC process of performing detailed analysis, collecting use cases, documenting requirements and creating design of Object-Oriented applications.
• Ability to interact at all levels in an IT organization to assess, evaluate, recommend a different and robust solution and lead through the development.
• Well proven track for achieving the timelines for deliverable in requirement changing environment.
• Experience working directly with customers to identify their business processes, rules, application user requirements and business process re-engineering.
• Expertise Oracle, SQL, PL/SQL, Oracle Forms, Oracle Reports and UNIX Shell scripting.
• Strong noledge in Oracle 10g/9i/8i database programming using PL/SQL (Stored Procedures, Functions, Triggers, Cursors) and standard Built-in Oracle Packages
• Experienced in working with utilities like SQL*Loader, External Tables, Import, Export to extract and load large volume of data.
• Strong experience with Unix Shell Scripting Worked on Production Support, receiving production calls, troubleshooting the application and resolving bugs.
• Good experience in building Web and Windows applications.
• Good understanding of Object Oriented Programming (OOPS) & Software Design Patterns
• Trouble shooting and problem solving applications with Informatica Debugger. Used debugger to test the data flow and fix the mappings.
• Identified the errors by analyzing the session logs.
• Used various kinds of the transformations to implement simple and complex business logic.
• Transformations used are: Lookup, Router, Expressions, Source Qualifier, Aggregator, Filter, Union, and Sequence Generator Update Strategy.
• Created Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Proficient in translating business requirements into logical data models, creating modularized enterprise applications
• Experience in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing technical design specifications.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
• Ability to work in teams and independently with minimal supervision to meet deadlines.

TECHNICAL SKILLS

RDBMS: Oracle 9i/10g and 8i, SQL Server 2005/2008, MS Access

Languages: C, C++, C#, Xml, SQL, PL/SQL, UNIX Shell Scripting.

ETL Tools: Informatica Power Center 8.0, 7.1.x

Database tool: PL/SQL Developer, Forms, TOAD, Oracle Enterprise Manager, SQL*Loader

Data Modeling: Microsoft Visio 2003, Rational Suite (Requisite pro, Rose, Clear Case)

Reporting Tools: Oracle Reports

Web Technologies: ASP.NET, HTML, Macromedia Dreamweaver, Adobe Photoshop

Environment: s VisualStudio.NET, JAVA, ABPP

Operating System: Windows XP, Windows 95/98/NT/2000/2003 Server, MS-DOS, LINUX

Protocols: TCP/IP, SOAP, FTP,LAN, WAN

PROFESSIONAL EXPERIENCE

Confidential, Washington D.C

Oracle PL/SQL Developer/ Analyst

Responsibilities:

• Understanding of Requirement specification.
• Responsible in data migration and data corrections from old systems to FMSNG.
• Generated reports to the users for Loan and Guarantee System(LGA )
• Created views for RLoans Data (Rescheduled Debt Servicing), APS-Application Processing System
• Involved in creating views for RLOAN Cash Receipt Transaction History for RLOANs being converted to FMSNG.
• Analysis and design for software using industry standard modeling tools.
• Involved in writing and executing Stored Procedures, Functions, and Packages in PL/SQL.
• Designed and Developed Oracle database tables, views, indexes etc.
• Translated business requirements into Technical Design and documentation.
• Created Tables, Synonyms, Sequences, Views, PL/SQL Stored Procedures and Triggers.
• Enforced database integrity using Primary keys and foreign keys.
• Participated in performance tuning using Explain Plan and TKPROF.
• Created and running the shell scripts to run the Processes at time scheduled according to business rules.
• Prepared and scheduled Reports for printing and sent Reports with emails.
• Extensively involved in coding of the triggers, and making use of built in packages.
• Generated Complex Packages, Procedures, Functions and Triggers for Business Logic Using PL/SQL.
• Modified the existing reports to suit the new requirements.
• Used SQL*Loader to download the data into database from the text files.
• Participated in the DBA activities like Creating Users, Granting and Revoking Privileges on database objects and taking backups.
• Provide on call production support for service tickets regarding applications currently in production.
• Troubleshooting applications and resolving bugs/issues.

Environment: Oracle 9i, SQL* Loader, SQL*PLUS, TOAD, Ad-hoc, Informatica Power center 6.1, Java, Zulu

Confidential, Pittsburgh, PA

Production Analyst/Oracle PL/SQL Developer

Responsibilities:

• Understanding of Requirement specification.
• Analysis and design for software using industry standard modeling tools.
• Developing the I2 Factory Planner products.
• Worked on Oracle Stored Procedures
• Translated business requirements into Technical Design and documentation.
• Created Tables, Synonyms, Sequences, Views, PL/SQL Stored Procedures and Triggers.
• Enforced database integrity using Primary keys and foreign keys.
• Created PL/SQL functions to facilitate business functions and calculations.
• Implemented best practices suggested by Informatica to simplify deployment Process.
• Created Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Used Mapping parameters, variables and session parameters to dynamically enter values between sessions.
• Trouble shooting and problem solving applications with Informatica Debugger. Used debugger to test the data flow and fix the mappings.
• Involved in the process design documentation of the Data Warehouse Dimensional Upgrades.
• Involved in Unit and System Testing of ETL Code (Mappings and Workflows).
• Provided Production support by monitoring the process/workflows running daily.
• Designed coding specification and documentation.
• Worked on I2 studio, using ABPP tool.
• Knowledge of supply chain management principals.
• Experience in developing/maintaining Web based user interfaces.
• Query Optimization and Performance Tuning the application using Explain Plan.
• Extensively developed PL/SQL Packages with Procedures, Functions, PL/SQL Records and Collections.
• Coordinated with DBA in Creating and Managing tables, indexes, DB Links and User Privileges.
• Involved in Design, Development and Testing
• Provide 24/7 on call production support for service tickets regarding applications currently in production.
• Troubleshooting applications and resolving bugs/issues.

Environment: Oracle 9i, 10g, SQL, PL/SQL, Pro*C, TOAD, HTML, J2EE, Solaris 2.6/2.7, MS Office 97, ABPP, XML, Perl, Unix. Informatica

Confidential, Irving/Fort Worth, TX

Production Analyst/Oracle PL/SQL Developer

Responsibilities:

• Provided the requested data for the Federal Reserve Board Foreclosure Review process as per the guidance from the Federal Reserve Board’s Independent Consultants
• Work with Compliance on the data requests from the different State Agencies and Attorney Generals
• Created the Servicer Data Request Flat Files for the Independent Foreclosure Review Settlement as per the guidance from the Regulators
• Created the Flat Files for the Borrower Outreach as part of the Federal Reserve Board Foreclosure Review process.
• Built the SQL to identify the loans that fall into the different Categories of the Foreclosure Review Settlement as per the guidance from the Federal Reserve Board
• Worked closely with users in understanding the requirements and coordinated between the users and the development team.
• Involved in writing and executing Stored Procedures, Functions, and Packages in PL/SQL.
• Automated the data loading using UNIX shell scripts, SQL*Loader, SQL and PL/SQL.
• Designed and Developed Oracle database tables, views, indexes etc.
• Participated in performance tuning using Explain Plan and TKPROF.
• Created and running the shell scripts to run the Processes at time scheduled according to business rules.Developed new screens and reports using Oracle Forms/Reports 6i and PL/SQL.
• Extensively involved in re-formatting and re-programming the Oracle Forms/Reports in correspond to the updates on the client requirements.
• Prepared and scheduled Reports for printing and sent Reports with emails.
• Extensively involved in coding of the triggers, and making use of built in packages and libraries while developing Forms.
• Generated Complex Packages, Procedures, Functions and Triggers for Business Logic Using PL/SQL.
• Modified the existing reports to suit the new requirements.
• Used SQL*Loader to download the data into database from the text files.
• Participated in the DBA activities like Creating Users, Granting and Revoking Privileges on database objects and taking backups.
• Designed various Mappings using Informatica Power Center 6.1
• Provide 24/7 on call production support for service tickets regarding applications currently in production.
• Troubleshooting applications and resolving bugs/issues.

Environment: Oracle 9i, SQL* Loader, SQL*PLUS, TOAD, Erwin, Informatica Power center 6.1

Confidential

Data Analyst/Programmer

Responsibilities:

• Understanding of Requirement specification.
• Customization & functionality development on NE TOOLS using ArcGIS, C# language.
• Developed application programming in C#.Net using GIS Interface.
• Worked on Oracle Stored Procedures
• Translated business requirements into Technical Design and documentation.
• Created Tables, Synonyms, Sequences, Views, PL/SQL Stored Procedures and Triggers.
• Enforced database integrity using Primary keys and foreign keys.
• Created PL/SQL functions to facilitate business functions and calculations.
• Designed coding specification and documentation.
• Wrote complex SQL queries, generated views for the administrative department.
• Performance tuning of database queries using TKPROF, Explain plan and SQL trace.
• Used packages like DBMS JOBS to schedule running of certain stored procedures.
• Created Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Used Mapping parameters, variables and session parameters to dynamically enter values between sessions.
• Trouble shooting and problem solving applications with Informatica Debugger. Used debugger to test the data flow and fix the mappings.
• Identified the errors by analyzing the session logs.
• Managed and resolved design issues during development.
• Developed documentation to support the business and the IT support team.
• Assisting other developers for the application performance tuning using TKPROF.
• Optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views, and using Optimizer Hints.
• Designed and generated reports using Oracle Reports.
• Wrote queries involving multiple-joins to generate user reports.
• Wrote both Implicit and Explicit Cursors to capture rows within a PL/SQL block, and applied business rules on them.
• Extensively used Cursors and Ref Cursors in order to generate various reports.
• Involved in Testing and implementation.
• Attending Scrum stand-ups and sprint planning sessions
• Involved in Design, Development and Testing

Environment: Oracle 9i, SQL, PL/SQL, Pro*C, TOAD, SQL*PLUS, HTML, J2EE, Solaris 2.6/2.7, MS Office 97, Erwin

Confidential

Assistant Software Engineer

Responsibilities:

• Involved through the SDLC of the project.
• Interacted with users, gatheird the Business Requirements, prepared Technical Design and System Testing specifications.
• Worked in both Transactional and Reporting databases.
• Written UNIX and PL/SQL scripts for testing and validation.
• Created database objects like tables, views, Sequences, Directories, Synonyms, stored procedures, function, and packages, Cursor, Ref Cursor and Triggers.
• Written queries on various snapshots and materialized views for remote instances.
• Coordinate with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Generated DDL scripts for creation of new database objects like tables, views, sequences, synonyms, indexes, roles and granting privileges.
• Responsible for maintaining and updating Coding Standards and Documentation Templates.
• Extensively developed PL/SQL Packages with Procedures, Functions, PL/SQL Records and Collections.
• Coordinated with DBA in Creating and Managing tables, indexes, DB Links and User Privileges.
• Proposed and coded enhancements on an Oracle PL/SQL and Unix Korn Shell based Data Conversion and Batch Processing.
• Built GUI using Oracle Forms 6i for data maintenance and validation.
• Developed various business reports, dynamic ad-hoc reports and Product forecasting reports using Oracle Reports 6i.
• Query Optimization and Performance Tuning the application using Explain Plan.
• Created UNIX Shell scripts for Overnight batch processing which includes flat file generation, XML Files and PDF Report output.
• Extensively used SQL Scripts for developing reports.

Environment: Oracle 10g (SQL, PL/SQL), PL/SQL developer, Oracle Developer Suite, Forms6i/10g, Reports 6i/10g,TOAD 7.4,PVCS, UNIX, VSS, .NET