SUMMARY:

• 10+ years of experience in Software Design and Development of Retail & Banking applications.
• Proficient in the full life cycle (SDLC) of application development, Architecture, Functional, Technical and Database specifications.
• Proficient in Oracle8i/9i/10g,PL/SQL, analysis, design and development
• Proficient in Agile methodology and having good experience in playing Scrum Master role
• Expertise in writing 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 tools in Oracle like SQLTrace, Explain Plan, different types of optimizer hints, indexes, tables and best practices in SQL and PL/SQL.
• Having strong knowledge in Unix Shell Scripting
• Highly skilled in Netezza nzsql, nzload, nzmigrate
• Having good knowledge in PostgreSQL
• Having good working experience on Data warehouse design and ETL application tool Datastage 11.5
• 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 9.x/10g/11g, Netezza, MySQL, PostgreSQL

Programming Lang.: SQL, PL/SQL, Unix Shell Scripting, Finacle Scripting

ETL Tools: IBM Data stage 8.1, Data stage 8.5

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

Software and Tools: TOAD, Aginity, Atlassian Jira, SVN, Atlassian bitbucket, PL/SQL Developer, PostgreSQL, SQL Loader, SQL Plus, MS Office, pgAdmin4.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago

Architect

Responsibilities:

• Providing technical design for all Confidential initiatives. Also part of Confidential innovation team and exploring new technologies to introduce into Confidential solution.
• Lead a Scrum team in development & delivery of Epic/User Stories
• Lead the whole backend customization track and provided design for the implementation of solution
• 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
• Designed and developed the next generation of Data Warehouse, ODS and Data Marts in dimensional model using NZLOAD, NZSQL and NZMIGRATE utilities for NETEZZA
• Involved in application analysis, design and development activities.
• Involved in writing Packages, stored procedures, functions and cursors using Sql.
• Designed, implemented and tuned interfaces and batch jobs using PL/SQL.
• Created requirement specification, design, technical approach and user manual document.
• Carried out Unit Testing (UT), Integration Testing (IT) and fixing defects.
• Involved in writing data stage jobs for Extract, Transformation and Loading of data.

Environment: /Technology: SQL, PL/SQL, UNIX Shell Scripting, Netezza, Datastage 8.1/9.1/11.5, Oracle 11g, PostgreSQL.

Confidential

Technology Lead

Responsibilities:

• Lead the whole customization track for this implementation.
• 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 Packages, stored procedures, functions and cursors using Sql.
• Designed, implemented and tuned interfaces and batch jobs using PL/SQL.
• Created requirement specification, design, technical approach and user manual document.
• Carried out Unit Testing (UT), Integration Testing (IT) and fixing defects.

Environment: /Technology: Finacle scripting, Finacle MRT, Finacle workflow, SQL, PL/SQL, UNIX Shell Scripting, Oracle 10g.

Confidential

Senior Software Developer

Responsibilities:

• 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 Packages, stored procedures, functions and cursors using Oracle pl/sql.
• Designed, implemented and tuned interfaces and batch jobs using PL/SQL.
• Involved in data replication and high availability design scenarios with Oracle Streams.
• Developed UNIX Shell scripts to automate repetitive database 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: /Technology: Finacle scripting, Finacle MRT, Finacle workflow, SQL, PL/SQL, UNIX Shell Scripting, Oracle 10g.

Confidential

Software Developer

Responsibilities:

• Involved in application analysis, design and development activities.
• Involved in writing Packages, stored procedures, functions and cursors using Sql.
• Created requirement specification, design, technical approach and user manual document.
• Carried out Unit Testing (UT), Integration Testing (IT) and fixing defects.
• ETL jobs design and development as and when required

Environment: /Technology: SQL, PL/SQL, UNIX Shell Scripting, Oracle 9i, Finacle scripting, Finacle MRT.