SUMMARY:

• 14+ years of diverse experience implementing software through all phases of SDLC (Software Development Life Cycle) including requirements gathering, analysis, design, development, code reviews, source control management, testing, deployment and maintenance.
• Hands on experience on Master/Slave DB environment to replicate provisioned/static data from Master table to all Slave tables.
• Experienced in RDBMS concepts including Normalization / ER modeling.
• Developed database objects like Procedures, Functions, Packages, Triggers and Materialized views.
• Expertise in Client - Server application development using Oracle 11g/10g/8, PL/SQL, SQL *PLUS
• Hands-on experience creating Tables, Views, Constraints, Indexes, Dynamic SQL, Ref Cursor, Table Partition and Exception handling.
• Used Single-row, Aggregated and Analytical functions as well as Correlated and Nested sub-queries.
• Performed SQL performance tuning techniques such as Query Optimizer, Execution Plan, Index Creation, Explain Plan and HINTS.
• Import/Export data to/from various systems using Datapump and SQL*Loader techniques.
• Experienced with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Created Shell Scripts for invoking SQL scripts and scheduled them using Crontab and Batch job.
• Experienced in Object Oriented Programming using Java, J2EE and JVM technologies.
• Expertise in enterprise application development using J2EE Framework (SPRING, HIBERNATE).
• Worked on Log4J, XML, JDBC, Multithreading, Garbage Collection and Exception.
• Knowledge of Data Structure (hashmap, linkedlist, binary tree, stack, etc.), basic Algorithms, DWH, ETL.
• Expertise in Agile (Scrum) and Waterfall process methodologies.
• Developed and Maintained front-end user interface with back-end database components.
• Worked on small and large scale feature projects from end-to-end and successfully deployed to site.
• Experienced in communicating with end-users, technical teams and senior management to describe features, technical designs and testing strategy.
• Provided maintenance support and involved in continuous enhancements to fix Production Issues.
• Strong analytical and problem-solving skills to understand functional and technical requirements.
• Excellent communication, interpersonal skills and ability to perform individually as well as a part of a team.

TECHNICAL SKILLS:

Programming Languages: Oracle SQL, PL/SQL, MS Access and Java

Databases and App. Server: Oracle 8/10g/11g, JBoss, Weblogic

Development Tools: PL/SQL Developer, TOAD, SQL*Loader, SQL*Plus

Tools: and IDE: Eclipse, NetBeans, JUNIT, ClearCase, SVN, ANT, Maven

Technology/Framework: J2EE, Spring, Hibernate, XML, XSLT, XSD

Defects Control: IBM ClearQuest

Methodologies: Waterfall, Agile/Scrum

Operating Systems: UNIX, LINUX, Windows XP/7

PROFESSIONAL EXPERIENCE:

Confidential, Mount Laurel, NJ

Software Development Specialist

Responsibilities:

• Worked as a Technical lead to handle Maintenance project in a fast paced Postpaid/Converged billing system.
• Involved with Business & Project teams to gather feature requirement, analysis, design, development, effort estimate, resource assignment and unit testing.
• Organized daily meetings for project status update.
• Translated feature requirements into technical design document for development.
• Created Unit Test document for testing based on the feature.
• Performed code reviews with team members to improve quality and standard of software such as indentation, comments, naming conventions, etc.
• Experienced in RDBMS concepts which includes designing of Logical (ER-Model) and Physical schema (Tables) using Oracle 11g/10g/8 DB.
• Developed back-end application using Oracle SQL-PL/SQL such as Procedure, Function, Package, Trigger, Materialized view, Constraint, Index, Dynamic SQL, Ref Cursor, Table Partition and Exception handling.
• Created single-row, aggregated, analytical functions along with correlated and nested sub-queries.
• Extensively used bulk collection, dynamic sql, record type, table type and exception handling in PL/SQL procedure and functions for performance improvement.
• Performed SQL performance tuning techniques such as Query Optimizer, Execution Plan, Index Creation, Explain Plan and HINTS.
• Load/Unload flat data files to/from oracle database using SQL*LOADER and DATAPUMP.
• Investigated production issues by reviewing/debugging code and provided workarounds and bug fixes.
• Continuously provided improvements/efficiencies to the software or business processes by utilizing software engineering tools and various innovative techniques, and reusing existing solutions. By means of automation, reduces design complexity, reduces time to response, and simplifies the client/end-user experience.
• Worked on Java based front-end application using Netbeans and resolved all provisioning related issues and bug fixes.
• Worked on Web and Multi-tier enterprise applications based on MVC framework (Spring and JSF) on Windows platforms.
• Worked on Enterprise Web and Multi-tier applications in J2EE Framework using SPRING, WEB SERVICES and HIBERANTE.
• Expertise in software development IDE Netbeans and Eclipse.
• Used Ant and Maven tools for the entire build process.
• Used SVN and ClearCase for version control.
• Maintained all software related defects using IBM ClearQuest tool.
• Ensured consistency and integration with multiple source code repositories for all releases.
• Assisted in development and performance of data access analysis and modeling.
• Developed detailed test plans and test data for system and post-production testing.

Confidential, Mount Laurel, NJ

Sr. Oracle Application Developer

Responsibilities:

• Worked in a Real Time Prepaid billing environment.
• Involved in database development of Core and Feature based modules through all phases of analysis, design, development, code reviews, source control management, unit testing, deployment and maintenance.
• Organized meetings for gathering requirement, update on project status and to verify that technical system specifications meet business requirements.
• Designed Logical (ER-Model) and Physical schema (Tables) using Oracle 10g/8 DB
• Hands on experience on Master/Slave DB environment to replicate provisioned/static data from Master table to all Slave tables.
• Created Materialized View and Materialized View Log to refresh Master/Slave data.
• Created database objects e.g. Procedures, Functions, Packages and Triggers.
• Expertise in Client-Server application development using PL/SQL, SQL *PLUS
• Hands-on experience creating SQL queries, Tables, Views, Constraints and Indexes.
• Involved in data Import/Export and Loading/Unloading using SQL*Loader and DATAPUMP.
• Created and Scheduled Oracle SQL jobs.
• Extensively involved in data modeling to create data models.
• Involved in continuous enhancements and fixing production problems.
• Developed standard and customize patches to fix bugs of billing systems in multi-customer environments.
• Performed code upgrade and fallback in compliance with company's procedures for change control.
• Ensured consistency and integration with multiple source code repositories for all releases.
• Assisted in development and performance of data access analysis and modeling.
• Developed detailed test plans and test data for system and post-production testing.
• Supported user acceptance testing.
• Demonstrated a strong customer-service focus

Confidential

Oracle Application Programmer

Responsibilities:

• Involved in defining system requirements, designing & prototyping, developing, testing, training and Implementation of the DB application.
• Implemented the business rules by writing Oracle PL/SQL Functions and Procedures.
• Worked with users to identify business requirements and integrated them into Oracle Applications.
• Participated in system analysis, data modeling and database designing which included creating tables, views, indexes, synonyms, triggers, procedures and packages.
• Automated modules like Order Entry, Data Entry, Batch Process, Shipment and HR.
• Developed Shell scripting to load/unload the data in regular intervals for reporting purpose.
• Written complex SQLs using joins, sub queries and correlated sub queries.
• Troubleshot production problems and worked effectively with other team members to identify and address problems.
• Provides input into project plans for database projects providing timelines and resources required.
• Responsible for writing PL/SQL stored procedures, packages, triggers and functions
• Tuned the stored procedures and the database for the better performance.
• Created Reports like: Customer Bill Invoice, Customer Transaction listing, Customer wise and Material Stock wise Reports.
• Documented each module for user level and system level maintenance.
• Responsible for writing necessary Unix Scripts.
• Report generation from various data tables for each reporting module using Crystal Report tool.