SUMMARY

• Sr. Software Engineer with over 8 years of experience in analysis, design, development, testing, implementation and maintenance of applications hosted on Oracle PL/SQL.
• Expert in designing and developing the Oracle PL/SQL objects.
• Extensive experience on advanced PL/SQL objects and collections.
• Familiar & Worked on SQL Loader to upload the information into the database tables.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Oracle Certified Associate.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Good knowledge in Database development and proficient in writing database programs in SSIS, SSRS, MS SQL Server 2008/2005, SQL Profiler, MS Access, Oracle 11g/10g/9i.
• Experience in ETL techniques and Analysis and Reporting.
• Excellent communications and presentation skills for effective communications with all levels of management, project team members, stakeholders and users.
• Experience in Data warehouse concepts, ETL, Informatica.
• Experienced in release management (release road mapping and coordination)
• Experience in handling multiple projects and technologies (MFT, Oracle PL/SQL, Kenan etc.)
• Expert in Retail domain.

TECHNICAL SKILLS

Programming Languages: Oracle PL/SQL, SQL, Pro *C

Computer System: Windows XP, UNIX

Special Software: Sterling e - commerce products -Sterling File Gateway and Sterling Integrator for MFT (Managed File Transfer), Control-M, Toad for Oracle, PL/SQL developer, SQL Developer, Putty, WInSCP3, Kenan FX, HTML, VSS, Editplus.

Test Tools: Rational ClearQuest, Quality Center 9.2

Version Control: Rational Clear case, Team Foundation Server

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis

Sr. Software Engineer

Responsibilities:

• Interacting with Business Analysts and Subject Matter Experts to gather the requirements.
• Preparation of server architecture and high level design documents
• Preparing SOW for vendors.
• Co-ordination with 3rd party vendors on requirements, environment setup and providing solution.
• Preparing metrics report and maintaining documents in SharePoint
• Preparing the low level Design Document.
• Code Walkthroughs and Internal Quality Assessment (IQA).
• Construction of Oracle Database objects and testing the modules
• Preparation of Unit Test plan.
• Provisioning various testing like Non-functional and volume to validate the product.
• Coordinating production deployments during Go-live at the Distribution Centre.
• Maintenance of the database interacting with the 3rd party vendor tools.
• Mentoring fellow engineers.

Environment: Oracle 10g PL/SQL, UNIX, Hyper-V cluster, Windows 2008 R2 server

Confidential, Minneapolis

Technical Lead

Responsibilities:

• Interacting with Business Analysts and Subject Matter Experts to gather the requirements.
• Carrying out impact analysis and providing appropriate solutions to Confidential and their vendors.
• Preparation of high level design and low level design documents.
• Design and Develop Services using Sterling e-commerce products.
• Develop database objects and module testing.
• Code Walkthroughs and Internal Quality Assessment (IQA).
• Preparation of Unit Test plans.
• Preparing metrics report and maintaining documents in SharePoint.
• Integration and testing the modules.
• Provide production support and also post-prod maintenance of the database and the application.
• Onsite- offshore communication and client interaction.

Environment: UNIX, Windows XP

Confidential

Technical Lead

Responsibilities:

• Understanding Retek products.
• Understanding Confidential business functionalities.
• Interacting with Business Analysts and Subject Matter Experts to gather the requirements.
• Carrying out impact analysis and providing appropriate solutions to Confidential and their vendors.
• Preparing the low level Design Document.
• Design and Develop Services using Sterling e-commerce products.
• Code Walkthroughs and Internal Quality Assessment (IQA).
• Construction of Oracle Database objects advanced PL/SQL objects and collections and testing the modules.
• Preparation of Unit Test plan.
• Communicating the various changes to the teams which interact with our application.
• Onsite- offshore communication and client interaction.
• Mentoring New Joiners.

Environment: Oracle 10g database, UNIX

Confidential

Developer

Responsibilities:

• Understanding the I2 products
• Installation of I2 products.
• Preparing Approach Documents.
• Work-flow development (includes all the PL/SQL database objects) and Testing
• Communicating the various changes to the teams which interact with our application
• Onsite- offshore communication and client interaction.
• Mentoring New Joiners

Environment: Oracle 9i database, UNIX

Confidential

Business Analyst/Developer/Test Lead

Responsibilities:

• Interacting with Business Analysts and Subject Matter Experts to gather the requirements
• Designing a feasible solution satisfactory to both BBB and their vendors.
• Preparing the low level Design Document.
• Code Walkthroughs and Internal Quality Assessment (IQA).
• Preparation of Unit Test plan.
• Construction and testing the modules.
• Performance Testing and Performance Tuning
• Communicating the various changes to the teams which interact with our application
• Onsite- offshore communication and client interaction.
• Mentoring New Joiners

Environment: Oracle 9i database, Advanced PL/SQL (Collections)

Confidential

Developer

Responsibilities:

• Data configuration for the various modules built
• Designing and developing customized collection and BIF using Database Procedures and Pro* C.
• Gathering requirements and devising the best possible solutions.
• Building up of customized applications that together form the entire billing system.
• Preparing several key financial reports.
• Carrying out an exhaustive Unit test on all the applications built.
• Preparing metrics report and maintaining documents in Rational ClearCase tool.
• Client Interaction.

Environment: Oracle 9i database, PL/SQL, Kenan FX, Java, UNIX, Pro*C, HTML