PROFESSIONAL SUMMARY:

• 12 years of experience in system analysis, design, development and maintenance of oracle, PL/SQL, DB2 and AWS applications.
• Worked on database design of large databases, expertise on oracle, DB2 databases and programming. Development of high performance technical solutions to meet teh challenging business demands to teh clients.
• Extensively worked on stored procedures, functions, analytical functions, packages, triggers, external tables, cursors, views, collections, records, exception handling and bulk operations.
• Extensively worked on various SQL and PL/SQL features, improved teh performance of teh applications thru various techniques like tuning, partitioning and got appreciations from teh clients.
• Expertise on partitioning techniques, oracle performance tuning techniques EXPLAIN Plan, profiling and HINTS. Minimized teh applications errors by conducting functional walkthroughs, design preparations, code reviews, unit testing sessions, assisted teh team members to develop User Manuals for customers and built better solutions.
• Experienced on TOAD, SQL Developer, PVCS, DB2 Stored Procedures, Oracle 11g, Oracle 12c, PL/SQL, SQL* Loader and UNIX environment
• Recognized for organizational, technical, problem solving and interpersonal skills. Strong work ethics, dedicated, self - motivated and willingness to take responsibility to achieve employer objectives.
• Good knowledge and understanding on Amazon Web Services(AWS) including S3, IAM, EC2, VPC, ROUTE 53, Cloud Watch, Auto Scaling and Load balancers.
• Working on Lambda functions using Python Boto libraries, S3 lifecycle versioning
• Certified AWS Solutions Architect Associate
• Practicing Agile and Scrum Frameworks at work, Certified Scrum Master
• Good at Python Programming concepts and Jenkins

TECHNICAL SKILLS

Languages/Development Tools: Oracle, PL/SQL, TOAD, SQL Developer, Oxygen, Amazon Web Services, HP Automation Tool, Scrum Framework, Python, SP Builder, SQL *Loader, ETL Concepts, GIT, Jenkins, Gradle, Tomcat, DB2, COBOL, CICS, JCL, Visio and UNIX Commands

Databases: DB2, Oracle 11g, Oracle 12c, VSAM

PROFESSIONAL EXPERIENCE:

Confidential, Tampa FL

Senior Developer

Responsibilities:

• Requirement Specifications Gathering and analyzing teh requirements. Design, develop and modify PL/SQL packages, functions, procedures and database objects. Develop applications using analytical functions, collections, cursors, Ref cursors, dynamic SQL and other database objects.
• Design and script tables, set table relationships, keys and indexes. Create tables, sequences, indexes, constraints and grant privileges. Analyze existing modules impact and identify solutions.
• Analyze, Evaluate & Enhance teh existing modules by providing supports to meet teh business requirement. Performance tune and optimize SQL, Pl/SQL using EXPLAIN and HINTS. Create PL/SQL procedures, functions, triggers and external tables to read data from flat files.
• Prepare Unit test scripts, perform unit test of applications and review of code. Coordinate teh offshore team and conduct meetings wif business users to fulfill their needs
• Use AWS services to store and archive teh data, Check style to maintain standards
• Write Lambda functions to move and retrieve data into S3 and maintaining S3 life cycle policies using Python boto3 and YAML
• Use Devops for CI/CD using Jenkins, Tomcat and GIT
• Checking logs on teh batch servers, copy files from batch servers and load teh using Unix commands
• Support complete life cycle of teh Project starting from BRD review to production support.

Environment:Oracle, PL/SQL, TOAD, HP Automation, Oxygen, Jenkins, GIT, Java, Python, S3, Lambda, YAML, EC2, Auto Scaling, ELB, Glacier and Data Stage.

Confidential, Ohio

Lead Developer

Responsibilities:

• Wrote SQL scripts for creating tables, sequences, indexes and constraints. Worked on performance tuning of SQL, PL/SQL applications. Worked closely wif business units and users to gather requirements.
• Requirement Specifications Gathering and Analyzing teh requirements and design of application. Created and maintained database objects like tables, views, materialized views and database triggers to meet teh business requirements.
• Coordinated wif offshore team. Provided technical guidance to team.
• Used Analytical functions to involve in teh development of custom stored procedures, functions, packages, triggers, SQL and PL/SQL.
• Worked in deadline driven environment wif immediate feature release cycles.
• Involved in code debugging and unit testing.

Environment:Oracle, PL/SQL, SQL Developer, Toad, PVCS, Java and ETL.

Confidential, NJ

Sr. Developer

Responsibilities:

• Requirement Specifications Gathering and analyzing teh requirements. Coded several procedures, functions and packages and scripts for database objects. Used SQL *Loader and created several control files for loading of external flat data. Development of customer reports and forms.
• Worked on DB2 and external stored procedures, created jobs using JCL
• Bug fixing and creating change requests. Worked on enhancements and support. Worked on unit testing and regression testing. Extensively used Cursors, Ref Cursors and Exceptions in developing Packaged Procedures and Functions. Improved performances of various stored procedures.
• Analyzed and Optimized teh SQL statements using ‘Explain plan’. Worked in deadline driven environment wif immediate feature release cycles. Worked on ERWIN to model teh database.

Environment:Oracle, PL/SQL, COBOL, Shell scripting, DB2, Stored Procedures, CICS, SQL Developer, SP Builder, VISIO, Java and ETL.

Confidential, CA

Senior Software Engineer

Responsibilities:

• Used ERWIN to model teh database, applied various constraints on database objects. Worked on creating database objects. Worked on query tuning and analysis. Preparing teh Unit test cases and unit testing.
• Implemented PL/SQL packages, Procedures, Functions, triggers and SQL queries to develop teh backend application. Involved in updating Procedures, Functions, Triggers and Packages based on teh change request.
• Worked on SQL and external stored procedures using COBOL, SQL and JCL
• Participated in UI development using CICS, COBOL, DB2 and JCL.
• Improved performance of application using PL/SQL Packages and built Packages.
• Coded SQL scripts to Create tables, indexes, views, sequence, synonyms and database triggers.

Environment:Oracle, PL/SQL, TOAD, CICS, DB2, Informatica and Java.

Confidential

Software Engineer

Responsibilities:

• Was involved in requirement gathering, developing and testing of teh application. Participated in teh designing of databases and creation of database objects. Worked on Informatica to transform Oracle data and load data to DB2 tables. Preparing teh Unit test plans and executing them properly.
• Worked on SQL and external stored procedures, Debugging and testing using SP Builder.
• Worked on Performance tuning of teh DB2 stored procedures
• Analyzed and Optimized teh SQL statements using ‘Explain plan’. Involved in teh data migration from DB2 to Oracle. Participated in Unit testing.

Environment:DB2, Cobol, CICS, JCL, VSAM, Platinum, Oracle, Informatica and Java.