PROFESSIONAL SUMMARY:

• 9 years of experience in Software Design and Development of banking application.
• Proficient in the full life cycle (SDLC) of application development, Architecture, Functional, Technical and Database specifications.
• Proficient in Oracle8i/9i/10g/11g,PL/SQL, Netezza Mustang and Twinfin and UNIX/Linux analysis, design and development. Extensive knowledge in database architecture, SQL, RDBMS fundamentals and Data Warehouse concepts.
• Expertise in designing and implementing software solutions for business requirements using Packages, Procedure, Functions, Views, Triggers, Cursors using Oracle PL/SQL
• Expert understanding of Oracle relational database concepts, design and DBA tasks.
• Comprehensive knowledge of tuning and performance enhancing the long running queries in Oracle and Netezza using SQLTrace, Explain Plan, Netezza query plan, different types of optimizer hints, indexes, tables and best practices in SQL and PL/SQL.
• Well experienced and posses strong knowledge in Unix Shell Scripting
• Have good working experience on ETL tool Datastage 8.1
• Worked on integrating data from flat files, XML files. Extensively worked in processing XML data in Datastage jobs.
• Experience with working on support application with exceptional debugging skills.
• Good team player and can work individually in both development and maintenance phases.
• Exceptional ability to adapt to latest technologies, innovative and organized aspects.
• Committed team player with good interpersonal skills and ability to handle multiple tasks.
• Experienced in interacting with the client to finalize suitable architecture, man power estimation, mentoring, task allocation and quality initiatives in the organization for best practices.
• Expertise in the review and documentation of high level and low level design documents based on client requirements.
• Having good experience in deriving the effort estimates for development/design phase for the technical requirements.

TECHNICAL PROFICIENCIES:

Databases: Oracle RDBMS 7.3.4/8.x/9.x/10g/11g, Netezza, MySQL.

Programming Lang.: SQL, PL/SQL

ETL Tools: IBM Data stage 8.1

Operating Systems: Unix/Linux, Windows NT/XP/2000, Sun Solaris 8/9

Software and Tools: TOAD, SQL Navigator, SQL Dev, SQL Loader, SQL Plus, MS Office.

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburg, PA

Senior Software Developer/ Oracle PL/SQL

Responsibilities

• Senior Software Developer - Had mentored the whole development team and done first round of review and testing at offshore before delivered the modules
• Interacted with the Business clients, Developers and QA Manager for clear exposure to track down the technical/functional user requirements & Change Requests for development plans.
• Developed highly complex applications using Oracle 11g database as back-end with expertise in design and development of Oracle PL/SQL Packages and Procedures.
• Involved in application analysis, and design activities.
• Used Data stage XML input stage for processing banks hierarchical files.
• Used ETL to effectively integrate heterogeneous data sources and converting raw data into useful information.
• Created and modified severalUNIX shell Scriptsaccording to the changing needs of the project and client requirements. Developed unix shell scripts to call Oracle PL/SQL packages and contributed to standard framework.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Re-designed/Re-factored reporting queries to make use of 11g database new features and to maximize the performance.
• XML Parser is used to give required data to the client.
• Involved in extracting data from different data sources like Netezza, oracle, XML and spreadsheets.
• Involved in designing different stages using complex mappings using XML parsing.
• Involved in full life cycle (SDLC) of application development, Architecture, Functional, Technical and Database specifications
• Tracked the status of project and circulated with the whole team on weekly basis.
• Tracked the defects and get it fixed from developers.

Environment: Oracle PL/SQL, Unix Shell Scripting, SQL Developer, Finacle scripting, Oracle 11g,10g, Data stage 8.1, XML parsing using Data stage 8.1

Confidential, California

Senior Software Developer/ Oracle PL/SQL

Responsibilities

• Senior Software Developer - Leading the whole customization track for this implementation.
• Participated in Requirements, Design and Release Readiness review sessions.
• Work on production issue with top priority
• Worked on timelines to provide fix without any delay.
• Developed ETL processes using native Oracle tools(SQL*LOADER, Oracle PL/SQL, external tables)
• Developed complex analytical queries in Oracle and Netezza SQL and performance tuned as necessary.
• Used netezza nzsql and nzload in day to day activities. Monitor netezza data distribution across SPUs/ S-Blades
• Used Oracle PL/SQL to support the application that extracts and load data into staging database which is a source for netezza load.
• Involved in creatingUNIX shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to makeDatabaseFaster and easier to maintain
• Involved in designing different stages using complex mappings using XML parsing.
• Used Datastage XML output stage to generate an XML file using the data extracted from some tables in database.
• Mentored team about critical module knowledge.
• Monitor calls raised across countries and guide team to work on the solution part
• Check for new process implementation in terms of improving quality
• Documented test metrics and project feedback.

Environment: Oracle PL/SQL, UNIX Shell Scripting, SQL Developer, Finacle scripting, Oracle 10g, Netezza, Data stage 8.1.

Confidential, NY

Software Developer/ Oracle PL/SQL

Responsibilities:

• Developed the whole customization single handedly from end-to-end
• Involved in High level estimation and Project charter preparation
• Analyzed Functional Specification documents and prepared Process flow, Technical Specification design documents and Test cases documents
• Involved in application analysis, design and development activities.
• Involved in writing data stage jobs for Extract, Transformation and Loading of data.
• Involved in writing Packages, stored procedures, functions and cursors using Oracle pl/sql.
• Designed, implementedandtunedinterfaces and batch jobs usingPL/SQL.
• Involved in data replication and high availability design scenarios withOracle Streams.
• DevelopedUNIX Shell scriptsto automate repetitivedatabase processes
• Involved in tuning queries in Oracle SQL and PL/SQL
• Involved in writing UNIX shell scripting.
• Created requirement specification, design, technical approach and user manual document.
• Carried out Unit Testing (UT), Integration Testing (IT) and fixing defects.

Environment: Oracle PL/SQL, UNIX Shell Scripting, SQL Developer, Finacle scripting, Oracle 10g, Datastage 8.1

Confidential

Software Developer

Responsibilities:

• Involved in application analysis, design, and development and enhancement activities.
• Interacted with the Business clients, Developers and QA Manager for clear exposure to track down the technical/functional user requirements & Change Requests for development plans.
• Developed the whole customization single handedly from end-to-end
• Involved in writing stored procedures, functions and cursors using Oracle pl/sql
• Involved in writing UNIX shell scripting.
• Involved in query tuning and DBA activates.
• Created functional, design, technical approach and user manual document.

Environment: Oracle PL/SQL, UNIX Shell Scripting, SQL Developer, Finacle scripting, Oracle 10g.

Confidential

Software Engineer

Responsibilities:

• Involved in tuning sql, pl/sql queries.
• Maintaining various batch jobs as part of end of day activities.
• Created functional, design, technical approach and user manual document.
• Involved in writing Packages, stored procedures, functions and cursors using Oracle pl/sql.
• Involved in writing UNIX shell scripting.
• Prepared weekly status report and Issue Log.

Environment: Oracle PL/SQL, UNIX Shell Scripting, SQL Developer, Finacle scripting, Oracle 10g.