Summary

Oracle Developer with 8.8 years in IT industry with experience handling full life cycle of software projects from inception to post-implementation. Successful track record in managing System Development Life Cycle SDLC projects using waterfall and agile methodologies in different verticals such as Banking, Retail.

Profile

• Expertise in identifying and analyzing the business needs of the end users and build a project plan to translates the functional requirements into technical tasks that guide the execution of the project.
• Excellent in client facing role, served as liaison between third party vendors, business owners, end users and technical team. Proven ability in communicating highly technical contents to non-technical people.
• Energetic, result oriented professional possessing strong leadership, analytical, decision making, problem solving and negotiation skills. Proven ability in QA/QC and Process Improvement.
• Energetic, result oriented professional possessing strong leadership, analytical, decision making, problem solving and negotiation skills. Proven ability in QA/QC and Process Improvement.
• 3 years of experience in leading a team.
• Extensive experience in a project environment and working as part of a large multi-skilled project team
• Excellent Technical Communications skills
• Excellent planning and control skills
• Ability to plan, organize, monitor, and control projects using appropriate tools and techniques
• Ability to gathers data, performs analysis, draws conclusions, and presents findings
• Ability to manage, teach and mentor employees
• Involved in all phases of the SDLC Software Development Involved in all phases of the SDLC Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System RDBMS and also have oracle database administration DBA concepts
• Experience in UNIX, Perl Script, Shell Script.
• Experience in SQL Server 2008/2005, SSIS and SSRS.
• Experience in VB.NET,ASP,VB6
• Experience in HTML, XML, Java Script, VB Script.
• Experience in testing using ALM tool.
• Experience with Data Analysis, Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques
• Expertise in Client-Server application development using Oracle 12c/11g/10g/9i, PL/SQL, SQL PLUS, TOAD and SQL LOADER.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write, Exception Handling
• Experience in Data warehouse concepts, ETL.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Created Tables, Views, Constraints, Index B Tree, Bitmap and Function Based .
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Experience in Oracle Dynamic SQL, Records Collections and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Partitioned large Tables using range partition technique.
• Experience with Oracle Supplied Packages such as DBMS SQL,DBMS JOB and UTL FILE.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Experience in SQL performance tuning using Cost-Based Optimization CBO .
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Created Perl Scripts for invoking SQL scripts.
• Experience in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts.
• Experience in design and development of SQL Server Integration Services SSIS packages and using various control flow task and data flow transformation.
• Experience in Data Extraction, Transforming and Loading ETL using SQL Server Integration Services SSIS , DTS.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team and also experienced in leading teams.

Technical Skill Set

Domain Expertise

• Cards and Payment Banking and Financial Services
• Real Estate Retail

Professional Experience

Confidnetial

Role: Senior PL/SQL Developer

Major responsibilities include:

• Coordinating with client for requirement gathering , clarification and providing solutions for several problems
• Handled client's enquiries regarding the project requirements.
• Assured consultative analysis and functional requirements are completed and document deliveries are met.
• Involved in query optimization and performance tuning.
• Involved in analysis, coding and code review of the team members.
• Created Perl Scripts and Autosys job to automate the monthly report generation process.
• Involved in query optimization and performance tuning.
• Involved in Development and Created PL/SQL stored procedures, functions.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

Environment: Technologies: PL/SQL, UNIX, Perl Database Tool: Oracle, TOAD

Confidnetial

Role: Senior PL/SQL Developer / Technical Lead

Major responsibilities include:

• Coordinating with client for requirement gathering , clarification and providing solutions for several problems
• Involved in all phases of the SDLC Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Served as liaison between third party vendors, business owners, end users and technical team. Proven ability in communicating highly technical contents to non-technical people.
• Experience in leading a team.
• Extensive involved in project environment and working as part of a large multi-skilled project team
• Involved in project planning, organizing, monitoring, and controlling projects using appropriate tools and techniques
• Experience in gathering data, performance analysis and providing presentation to the client.
• Experience in managing, teach and mentor team members
• Involved in regular Production support activity.
• Involved in query optimization and performance tuning.
• Involved in Development and Created PL/SQL stored procedures, functions and packages.
• Developed materialized views for data replication in distributed environments.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Experience in writing complex SQL queries involving multiple tables inner and outer joins.

Environment: Technologies: PL/SQL, ETL, Perl Database Tool: Oracle DB 11g, TOAD

Confidnetial

Role: Senior Developer / Technical Lead

Major responsibilities include:

• Participated in analysis, design, coding, testing, implementation and documentation of the development or the change requests.
• Involved in code review.
• Direct co-ordination with client for requirement gathering , clarification and providing solutions for several problems
• Handled status meeting as a Project Lead to provide the status of the work on a weekly basis.
• Managed a team of 5 members.
• Involved in code review for the team members.
• Extensively involved in environment setup at offshore at the time of acquiring a new project from another vendor.
• Involved in knowledge sharing with client and external vendor to understand the process flow of the application.
• Involved in project planning, organizing, monitoring, and controlling projects using appropriate tools and techniques
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages.
• Worked on SQL Loader to load data from flat files obtained from various facilities every day.
• Involved in the continuous enhancements and fixing of production issues.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Involved in maintaining project related quality artifacts, metrics tracking and managing the team.

Environment: Technologies: PL/SQL, Cold Fusion, ASP Database Tool: Oracle DB 11g, TOAD, MS SQL Server 2008