SUMMARY:

• Having 13 years and 6 months of I/T experience with expertise in Oracle SQL & PL/SQ L Database Development, Maintenance, System Testing, Implementation and support for Oracle 11g/10g/9i/8i RDBMS and ETL tools.
• Expertise in full Software development life cycle (SDLC) from the analysis, design, coding and implementation with timely deliverable.
• Strong experience in creating complex database objects such as PL/SQL Packages, Procedure, Function, Trigger (DML & Non - DML), Type, Table, Global Temporary Table (GTT) and Views using Quest Toad and SQL*Plus tools.
• Proficient in Performance tuning on Oracle PL/SQL batch Jobs, SQL queries using EXPLAIN PLAN, TKprof, AUTO TRACE and DBMS Profiler/Debug.
• In-depth knowledge of choose various types of Indexes(Local & Global), Constraints and HINTS based on the business rule.
• Expertise in Extraction Transformation Loading (ETL) using SQL*Loader, Oracle External Table and UTL FILE .
• Effectively made use of Advanced SQL and PL/SQL technologies using Collections, Dynamic SQL/REF Cursor, Analytical, REGEXP, Table Partitioning and Materialized Views & Logs (Data Replication in distributed environment).
• Good knowledge on Oracle Data dictionary, Oracle Supplied DBMS, UTL and HTP packages.
• Experience in jobs scheduling using Oracle DBMS JOB, DBMS SCHEDULER and Unix crontab.
• Strong knowledge with Normalization technique, Entity Relationship model, Exception Handling, and Debugging technique, PII data obfuscation techniques and Automations.
• Hand on experience in oracle web development using Mod PLSQL with Apache Tomcat Web server.
• Exposure in Database Administration by creating Schema, Directory, Table space, Roles and Export & Imports.
• Exposure in Personal Insurance, Finance, ERP and Relationship management domains.
• Expertise in Reverse Engineering, Data Analysis, Data Masking, Database Upgrade & Migration (MySQL to Oracle 9i), Data Modeling, gathering business requirements and Release Managements.
• Involved Data replicate from Transaction database (OLTP) to Reporting database using GoldenGate tools.
• Having experience in Oracle Reports 6i, Pentaho an d Jasper Report ing tools includes complex layout design, development and Testing.
• Having 3 years of experienc e in Informatica PowerCenter 8.6.1 by creating workflows, mappings using various Transformation techniques.
• Ex posure in data warehousing concept by creating Attributes, Fact tables and Dimensional modeling using Star and snowflake Schema.
• Good knowledge in Slowly Changing Dimension Types (1/2/3) and workflow performance tunings.
• Experience in Project estimation, Review process, status reports, Metrix, Incident Tracking and On-call Support.
• Well versed in documentation on HLD & LLD, Unit Testing Integration Testing, defect tracking and Implementation Plan.
• Effectively lead teams with Offshore/Onsite model, proactively mentoring the team members and resolving conflicts.
• Excellent communication, interpersonal, and organizational skills.
• Strong Analytical and Problem solving skills

TECHNICAL SKILLS:

RDBMS: Oracle 8i/9i/10g/11g/12c, MS SQL Server, MySQL.

Programming Languages: PL/SQL, Core Java, Pro*C, UNIX Shell and Perl Scripting.

Frontend: Mod PLSQL, Oracle Reports & Form 6i, HTML, Java Script.

Tools: Toad for Oracle, SQL Developer, SQL*Plus

OLAP/ETL: Jasper BI, Informatica Power Center 8.x, Pentaho Report Designer.

Job Scheduler: Autosys Job Scheduler, ESP, Unix Crontab.

Version Control Management: SVN, Visual Source Safe (VSS), PVCS, RTC.

Operating System: Windows Series, UNIX, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Senior Software Developer

RESPONSIBILITIES:

• Gathered business requirements with end users, Analyzing, prepare Estimation, LLD and Functional Documents.
• Technical and Functional guidance to the team members and discuss the development status and documented.
• Have been the development point of contact for all enhancements and maintenance projects.
• Developed various Oracle PL/SQL programming with stored procedures, packages, functions, triggers, views, Tables and Complex SQL scripts.
• Developed ETL workflows using Linux Shell scripts, CronTab to extracts the various sources of historical data.
• Design the Report Layout and creating various Business Intelligences Reports, Dashboard, Cross tab, Adhoc reports using Jasper BI.
• Involved for encrypting the PII data from production to non-prod environment to secure the sensitivity records.
• Created various automated tools to find the production batch job activities, calculating all type period frequencies.
• Provided production support, root cause identification on time during the production job failures.
• Involved Data replicate from Transaction database to Reporting database using GoldenGate tools.
• Proficiently worked with Logical, conceptual and physical data models also created various dimensions for warehousing data process.
• Resolved huge performance issue on complex programming, STATS gathering and create Profiles and maintained histograms plan to avoid causing slowness and Deadlocks.
• Involved all the phases of SDLC and good experience in agile methodologies for application developments.
• Direct and regular communication with Business partner for gathering the requirements and providing the existing app functionality by understanding the code logic ( more than 100 thousand LOC on each channel package).
• Maintained the application objects using SVN and PVCS version controls.
• Maintained Defect tracks, Bug fix, Adhoc Reports, projects and assigned works using JIRA tools.
• Involved for complete Release management for Production and non-prod deployments.
• Involved High Level trouble shoots in database administrator and server configuration issues.
• Involved in preparing and executing the Unit Testing and Integration Testing for all major and minor enhancements.

ENVIRONMENT: Oracle 12C, SQL, PL/SQL, SQL*Loader, UNIX Shell Script, Jasper Reports, SVN, PVCS, JIRA, Toad, SQL*Plus.

Confidential

Technical Lead

RESPONSIBILITIES:

• Interacted with the Business Analysts in understanding the business requirements for the project.
• Gathered requirements from the users and analyzed their business needs and created SRS documents.
• Developed various Oracle PL/SQL stored procedures, packages, functions, triggers & other advanced technologies.
• Worked on LIST, HASH Table Partitioning, STATS Gathering, Table Analysis and various Oracle Indexes.
• Building Complex Oracle stored procedure with major business process.
• Created GLOBAL TEMPORARY TABLES to handing multilevel data staging operation.
• Created the automated error handling process using DBMS ERRLOG package.
• Created TYPES, Collection and PL/SQL Tables for major batch process.
• Efficiently working with Perl Scripting program for Extraction, Loading and file management.
• Extensively worked on Oracle Query Optimization, performances tuning using EXPLAIN PLAN, DBMS PROFILER and re-engineering the existing process with highly efficient and robust.
• Implemented various Oracle 11g features and created various Oracle Packages with new utilities.
• Provide support, root cause identification for any Production issue during the warranty period after post implementation, Conduct walk through meeting and guiding I/T support.
• Proficiently worked with Logical, conceptual and physical data models also created various dimensions for warehousing data process.
• Developed various Complex ETL jobs using Informatica PowerCenter and designed workflows, mapping using various transformation and invoked SCD types as well.
• Frequently working with database administrator to perform DDL, database configuration setup as required.
• Involved in all phases of SDLC and good experience in agile methodologies for application developments.
• Involved in Unit Testing and Integration Testing for all major and minor enhancements.
• Involved for code release management on non-prod and production environment.

ENVIRONMENT: Oracle 12c, PL/SQL, UNIX Shell Scripts, SQL*Loader, Informatica Power Center, ESP, Java, Toad, SVN, Windows7.

Confidential

Project Lead

RESPONSIBILITIES:

• Project Lead for the team of five members in offshore.
• Gathering a Business requirements, understanding and prepared the design document and converting HLD to LLD, Effort Estimation calculation and Resource allocation phase.
• Involved in the transition from another vendor and educating the team members.
• Analyzing and enhanced the new PL/SQL program such as creating tables, packages, procedures, functions and triggers. Dedicatedly worked in Oracle Partitioning.
• Developed various user interfaces using mod pl/sql (HTP Packages).
• Created many job for Extraction transformation loading using SQL and UNIX shell scripting and Informatica.
• Performing query tuning in existing SQL and PL/SQL for better performance.
• Automation of various manual activities using UNIX shell script.
• Designed the data model and applied the various new enhancements.
• Data mapping from source system data to target system with SCD dimension and start and snowflake schema.
• Data profiling to assess compatibility to the business rules, define rules to handle exceptions
• Involved in production release activities.
• Involved in peer code review and performed release management activities.
• Efficiently worked on Database migration from Oracle 9i to Oracle 11g database.
• Performed integration and functional test.

ENVIRONMENT: Oracle9i/11g, PL/SQL, Informatica PowerCenter, Oracle Reports, UNIX shell script, Mod PLSQL, PVCS, SVN.

Confidential

Team Lead

RESPONSIBILITIES:

• Team Lead for a team of four members in offshore for technical support and project deliverable.
• Understanding the BRD and prepared technical specifications, test plans and test cases.
• Created various functions, procedures and packages, Trigger, collections using PL/SQL program.
• Developed various Reports, Batch process on HR and Payroll, Sales, purchase, Invoice, material management, Financial and reconciliation reports and statements.
• Created Automated utility to prepare DMLscripts to implement code changes from Development environment to production environment(off-site) on various client systems independently on live environment.
• Involved for database migration from Oracle 9i to Oracle 11g version.
• Hand-on experience in DBA activities for Database Upgrade, imp & exp schema, multilingual setup, Tablespace maintenance and minor troubleshooting.
• Gained knowledge on Pentaho training and educated the team members .
• Developed various reports, Report Analysis, Chart using Pentaho BI Reporting tool as per business requirements.
• Creat ed Design Document, Unit Test Case, Defect Tracker, . Requirement Traceability Matrix .
• Provided Development, supporting, maintenance, Requirement gathering and Work allocation.

ENVIRONMENT: Oracle9i/10g, PL/SQL, Core Java, Pentaho 4.5, SQL*Loader, Windows 2000/XP, Bugzilla, PVCS.

Confidential

Programmer

RESPONSIBILITIES:

• Involved for Requirement gathering, Project coordination, Development, Maintenance and Support.
• Primary responsible for HRMS and Payroll system for enhancement, supports and Performance tunings.
• Developed various Database functions, procedures, Triggers and packages using Oracle PL/SQL.
• Directly worked with stakeholders for problem solving and guiding the application needs.
• Performed the data migration from Oracle to MySQL.
• Efficiently work ed on Application Performance issue using Explain Plan and tkprof.
• Involved on development in Oracle Forms to clone the un-editable existing products.
• Performed on Data analysis, Unit & system testing and project release.