SUMMARY:

• 10+ years of experience in Application Software Design, Development, Maintenance, Conversion and support, deployment, testing, documentation, implementation, maintenance and support of application software.
• Good understanding of Business practices in the verticals like Insurance, Banking & Financial Services, Telecom and Retail Industry.
• Expertise in database performance, ETL, SQL queries, PL/SQL procedures, packages, functions, cursors, triggers, interfaces and data conversion using PL/SQL, SQL*plus, TOAD, and SQL developer .
• Design and developing new forms, reports (forms 10g, reports 10g for Custom apps)and modifying existing forms based on the requirement
• Experience in ETL process to load the data into Teradata database using (MultiLoad, FastLoad, FastExport, TPump, and BTEQ).
• Expertise in COBOL, CICS, Ezytrieve, JCL & SAS programming.
• Developed API’s for Java application using COBOL.
• Experience in Core Java, JDBC, Servlets, JSP.
• Extensive experience in Data Modeling, Stored Procedures and functions, worked on Databases such as Oracle, SQL Server & DB2.
• Extensive working experience on Mainframe Debugging tools Xpeditor, and INTERTEST and version control tools like CHANGEMAN,ENDEVOR, and PANAVLET.
• Having knowledge on Quality center.
• Used Cognos Query Studio to build reports.
• Participated in Various Disaster Recovery exercises to test the availability of the system.
• Excellent communication, team spirit, hardworking and leadership skill.
• Coordinating the technical team with Business team, Test team, and Support team.
• Efficient in software engineering skills including Use - Case diagrams, UML and Rational Rose, Enterprise Architect.
• Excellent analytical, problem solving, communication skills and a dedicated team player.
• Having good knowledge on Agile Methodologies, and also having hands on experience in Test Driven Development.
• Extensive project experience in Banking, Retail and Insurance Sectors.
• Having working experience on Mainframe Testing, Which includes Functional, Regression testing, End to End testing.

TECHNICAL SKILLS:

Operating systems: Windows 7/XP/NT, UNIX, LINUX

Databases: Oracle 11g, Teradata, DB2, VSAM, IDMS.

Programming languages: SQL, PL/SQL, JAVA 1.6, C, C++, COBOL, JCL, Ezytrieve, SAS, CICS.

Tools: and Utilities: TOAD, SQL Assistant, JDEVELOPER, CA7, ECLIPSE, Change man, PANVLET, XpeditorBMC, File Aid, CHPS/ELIPS, QMF, FMDB2, SPUFI, Debug Tool, REXX, SYNC SORT, ICETOOL, FTP, NDM, TIVOLI OPC, Control M, PCM, Cognos Frame work Manager, Query & Report Studio.

Web Technologies: JavaScript, JSP, HTML, XML

Testing Tools: Quality Center.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Create packages functions and procedures required for fronte nd application.
• Create triggers to perform actions from database.
• Write advance SQL queries using Analytic functions like RANK, LISTAGG, LAG, LEAD etc.
• Performed performance tuning of package, procedure and function queries using optimization techniques.
• Performed Unit test, System integration test to make sure the deliverable are inline with business requirement
• Responsible for handling production support tickets and defect fixing.
• Designed and coding using oracle products SQL/PLSQL, FORMS 11g and REPORTS 11g and performed unit as well as integration testing of the new requirements.
• Loaded large XML files (5 GB) into oracle database using PL/SQL.
• Import/Export data from production regions to development environments.
• Debug PL/SQL stored procedures using TOAD.
• Develop ER diagrams using TOAD database designer.
• Closely worked with JAVA developers, to provide the required data from the database as per requirements.
• Designed and Modified Database tables, Keys, Indexes, Triggers, Oracle Packages, Procedures and Functions.
• Conversion of all Oracle reports (IPAL,SRC (SPRING, FALL & SUMMER),SOQ,OFR,
• Design all the reports from scratch as same as RDF reports.
• Tweak and tune the converted queries if required for performance optimization.

Environment: Oracle 11g, PL/SQL, XML, TOAD, Pentaho & JDEVELOPER.

Senior Database Analyst

Confidential, Dallas

Responsibilities:

• Gather functional requirements from users and convert them into Technical design documents and get sign-off from Business Analysts & DBA.
• Business problem area analysis and gap identification.
• Participated in designed the application for VSAM to ORACLE Migration.
• Created database packages, procedures, functions, triggers, views, materialized views using Oracle.
• Analyzing performance of database objects and suggesting DBA for Indexes, schema gathering, partitioning, explain Plan.
• Used SQL* Loader and export/import mechanism for data migration for bulk upload.
• Converted COBOL programs to PL/SQL packages & stored procedures to convert the application from mainframe to oracle.
• Created sequences on the database for generating primary key.
• Implemented PL/SQL to perform application security and batch job scheduling.
• Written Unix shell scripts for data files handling, FTP and executing the SQL*Loader.
• Develop code, testing, reviewing changes to online and batch programs.
• Code Walk-thru of programs for defects.
• Participated in conversion meetings and defect calls.
• Prepare Unit Test Plans and Perform Unit Testing, SIT/UAT Support
• Performed thorough Unit testing, System Testing and User Acceptance Testing in development environment for the result of error free and smooth migration process and provided quality work for functional users.
• Developed new screens using CICS.
• Used Eztrieve & SAS extensively to generate daily, weekly and Monthly reports.
• Created new JCL’s & PROCS for executing COBOL & Eztrieves.
• Ensuring code Walk through & Inspection are carried out as per standards.
• Used Change man & Endeavor for version control.
• Extracted data from various sources like Oracle, VSAM, DB2 and loaded into Teradata database warehouse.
• Coordinating with other development teams, Test team, support team and other End users.
• Performed unit testing of the database after migration from oracle 9i to 10g

Environment: Oracle 11g, PL/SQL, TOAD, DB2, Reports 10G, Teradata, COBOL, CICS, JCL, Ezytrieve, VSAM, Change man, BMC, Xpeditor, XML, FILE- AID, Quality Center, FTP, NDM, Query Studio, BTEQ, FastLoad, MultiLoad, TPump.

Senior Developer

Confidential, Jacksonville

Responsibilities:

• Understand functional and technical design documents and come up with a plan to develop parts of the application and Involved in various phases of Software Development Life Cycle (SDLC).
• LaSalle Bank Transition and US Trust Changes.
• Used Oracle Database and TOAD for queries execution and also involved in writing SQL scripts, PL/SQL code for procedures and functions.
• Used SQL* Loader to upload the bulk data from formatted text /XML files into Oracle tables.
• Created scripts to create new tables, views, queries for new enhancements.
• Created triggers, stored procedures, functions & cursors in PL/SQL.
• Used %TYPE and %ROWTYPE for anchoring the variables to the database data types.
• Development and maintenance of plsql libraries, menu modules, build and use alerts, visual attributes and object libraries.
• Actively involved with DBA for deployment of objects to production environment.
• Coordinating with other development teams, Test team, support team and other End users.
• Coded complex programs in COBOL/DB2 for building the application.
• Used Eztrieve extensively to generate daily, weekly and Monthly reports.
• Converted the weekly & Monthly reports to Reports 6I.
• Used Change man for version control and SharePoint for work Tasks.
• Participated in Various testing Pipelines and Disaster Recovery exercises.
• Used HP Quality Center tool to log & track defects.

Environment: Oracle, PL/SQL, Forms 6I, Reports 6I, TOAD, SQL LOADER, COBOL, CICS, JCL, Ezytrieve, VSAM, REXX,DB2, IDMS, Change man, PANVLET, BMC, QMF, Xpeditor, XML, FM DB2, Eclipse IDE, Quality Center, FTP, NDM.

Confidential, New Jersey

Programmer Analyst

Responsibilities:

• Coding and testing of enhancements.
• Created ISPF edit macros to reduce development and edit time.
• Developed new screens using CICS.
• Coded complex programs in COBOL/DB2 for building the application.
• Created JCL’s & STORED PROCS for executing COBOL & Eztrieves.
• Used SAS & Eztrieve extensively to generate daily, weekly and Monthly reports.
• Build reports in SAS & Eztrieve.
• Used Change man for version control..
• Used REXX extensively to build tools to reduce the development time.
• Creation and execution of Test Scripts & Test cases
• Defect Tracking and Analysis.

Environment: COBOL, JCL, Ezytrieve, CICS, IMS, File Aid, CHANGEMAN, XPEDITOR, REXX, SAS, QMF,SPUFI, BMC,MS - VSS.