SUMMARY

• 5+ years of IT experience in Business Requirements Analysis, Application Design, Database design, Data Modeling, Development, Database Marketing, Testing, Implementation, SQL Performance Tuning, Data warehousing ETL process and Client/Server applications for Retail, and Healthcare Industries.
• Has vast experience in design, development, productionize and maintenance of datamarts such as campaign and reporting datamarts.
• Possesses expert skills in the development of applications utilizing Oracle tools including Oracle PL/SQL, SQL Plus, SQL Loader, and experience with PL/SQL back - end programming - Database Packages, Stored Procedures, Functions and Management of Schema Objects
• Extensively worked on Informatica PowerCenter. Have used the Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Extensive experience in developing stored procedures, functions, triggers and packages using tools SQL*PLUS, TOAD, PL/SQL Developer.
• Expertise in Unix shell scripting and automated task scheduling using crontab, autosys and in-house scheduling tools JCS and FRMS scheduler.
• Experience in analyzing business rules and coordinating in application design and database design
• Experience in full End to End Project Development from HLD, LLD, Test Plans, Coding then Unit Testing and providing support in Integration and System Testing and Defect Fixing using SDLC
• Experience in working with Agile methodology
• Experience in performance and tuning (PL/SQL) using Explain Plan and TkProf
• Extensive experience in development tools SQL *PLUS, Toad, SQL*LOADER and PL/SQL developer.
• Strong Programming and debugging skills in PL/SQL, SQL, Dynamic SQL, C, Pro*C and Unix Shell Scripting
• Extensive experience in Enterprise Data warehousing. Design of Extraction, Transformation & Load (ETL) environment.
• Extensive experience on OLTP and OLAP systems.
• Extensively worked on Code migration from Development, Systest and Production.
• Demonstrate the analytical ability to understand the business requirement/process, convert the business specification to technical document, data management, develop and integrate solutions to meet the requirement.
• Strong in Designing, Development (coding), Testing, Implementation and Documentation as per Industry standards.
• Possesses the ability to work autonomously as well as Team management experience.
• Strong business analysis skills to fine business problem, process, management.
• Excellent communication, inter personal, presentation, strong analytical and trouble shooting skills

TECHNICAL SKILLS

Tools: TOAD, SQL *Plus, SQL *Loader, SQL Developer, PL/SQL Developer, Erwin, Informatica, Business Objects, Ultra edit, CVS, TFS

RDBMS: Oracle 12c/11g/10g/9i/8i, DB2, SQL Server

Languages: PL/SQL, SQL, Unix Shell Scripting, XML, HTML, Perl Scripting and PRO*C.

OS: UNIX (Sun Solaris, AIX), Linux and Windows NT/2000/XP.

PROFESSIONAL EXPERIENCE

Confidential

Database Developer

Responsibilities:

• Involved in preparing Database Design, High level and low level documents.
• Developed back end interfaces using PL/SQL stored procedures, functions, packages, triggers, collections and Unix shell scripts.
• Automated the daily tasks using Oracle backend procedures, Unix shell scripts.
• Involved in ETL design to convert different file formats into predefined format and automated this process for different file formats.
• Improved performance of reporting mart and some ODS processes.
• Migrated data from Flat Files to Oracle database using SQL*Loader and External tables. Wrote Oracle PL/SQL programs for backend processing.
• Supported Loyalty platform which built in .NET framework. Writing SQL queries which are embedded into .NET to fetch data from database and manipulate data in database.
• Created Perl scripts to convert the XML files into flat files
• Experience on creating/tracking the change requests and issues using TFS.
• Worked on developing ETL process to load the files into database and auditing the incoming data based on the business rules
• Developed warehouse/mart processes using PL/SQL and Unix shell scripts
• Worked with Client and Internal SME’s to understand the business requirements and transferring those to technical documents.
• On-call support on rotation basis.
• Wrote SQL scripts to generate data for campaigns and to verify the counts with functional team.
• Implemented Oracle Table functions and With Clause queries in PL/SQL scripts which have written for ETL process.
• Responsible for SQL tuning and optimization using Analyze, Explain plan
• Created source to target mappings for data marts using Informatica
• Created PL/SQL Procedures using Native Dynamic SQL and Cursor Variables. Used Cursor Variables to pass query results sets between PL/SQL programs
• Wrote Unix Shell Scripts to extract and transfer (ftp) files to other systems.
• Scheduled Unix jobs through Crontab.
• Responsible for performing code reviews.
• Testing of all the deliverables done with User support
• Client interaction through meetings & presentations
• System Support - Assisted Client for User Acceptance Test for new releases

Environment: Oracle 12c/11g, SQL*PLUS, SQL, PL/SQL, SQL*Loader, Linux, TOAD, PL/SQL Developer, Informatica, XML, HTML, Unix korn Shell, TFS, Business Objects

Confidential, Fairfield, CT

PL/SQL Developer

Responsibilities:

• Involved in preparing Database Design, High level and low level documents.
• Developed back end interfaces using PL/SQL stored procedures, functions, packages, triggers, collections, object types and K-shell scripts.
• Involved in ETL design to convert different file formats into pre defined XML format and automated this process for different file formats.
• Improved performance of reporting mart and some ODS processes
• Worked with DBA in making enhancements to physical DB schema. Also coordinated with DBA in creating and managing table, indexes, partitions, triggers, db links and privileges.
• Implemented new process to alert team before the First logic BO directories expiration
• Improved the performance of existing phone and email merge purge process
• Automated unica flowchart files QC
• Migrated data from Flat Files to Oracle database using SQL*Loader and External tables. Wrote Oracle PL/SQL programs for backend processing.
• Implemented Oracle Table functions and With Clause queries in PL/SQL scripts which have written for ETL process.
• Implemented Oracle Regular Expression functions REGEXP SUBSTR, REGEXP REPLACE, REGEXP INSTR and REGEXP LIKE to parse and extract the strings in PL/SQL procedures.
• Responsible for SQL tuning and optimization using Analyze, Explain plan
• Implemented external tables for loading data into database.
• Created PL/SQL Procedures using Native Dynamic SQL and Cursor Variables. Used Cursor Variables to pass query results sets between PL/SQL programs
• Wrote Unix Shell Scripts to send (ftp) files to other systems.
• Wrote perl scripts to convert the data in oracle table into XML format
• Responsible for performing code reviews.
• Testing of all the deliverables done with User support
• System Support - Assisted Client for User Acceptance Test for new releases

Environment: Oracle 11g/10g, SQL*PLUS, SQL, PL/SQL, SQL*Loader, UNIX (AIX 5.3), PL/SQL Developer, XML, HTML, First Logic, Windows NT, Unix korn Shell, Perl

Confidential, San Francisco, CA

Associate

Responsibilities:

• Involved in preparing Database Design, High level and low level documents.
• Requirements gathering for the Interface and program development through meetings with functional team and business users.
• Developed back end interfaces using PL/SQL stored procedures, functions, packages, triggers, collections, object types and K-shell scripts.
• Utilized PL/SQL developer tool in developing all back end database interfaces.
• Worked with DBA in making enhancements to physical DB schema. Also coordinated with DBA in creating and managing table, indexes, partitions, triggers, db links and privileges.
• Migrated data from Flat Files to Oracle database using SQL*Loader. Wrote Oracle PL/SQL programs for backend processing.
• Wrote Procedures with bulk collection & bulk binding concepts for better performance.
• Wrote PL/SQL backend procedures for ETL process to load data into Enrollment Datamart from various source systems like Mainframes, SQL Server and Oracle.
• Wrote scripts using UTL FILE built-in package to prepare and ftp reports to different systems, if there are any errors while loading data into Datamart from various sources.
• Used the Oracle built in package DBMS SCHEDULER to schedule the PL/SQL procedures.
• Created/Modified the PL/SQL scripts to send Email notifications to customers for various events like Enrollment notification, ID Card Notification, Registration reminders, etc.
• Responsible for SQL tuning and optimization using Analyze, Explain plan, TKPROF Utility.
• Implemented external tables for loading data into database.
• Created PL/SQL Procedures using Native Dynamic SQL and Cursor Variables. Used Cursor Variables to pass query results sets between PL/SQL programs and Client application (.Net).
• Wrote Unix Shell Scripts to send (ftp) files to other systems.
• Scheduled Unix jobs through Crontab.
• Responsible for performing code reviews.
• Testing of all the deliverables done with User support
• Client interaction through meetings & presentations
• System Support - Assisted Client for User Acceptance Test for new releases

Environment: Oracle 10g/9i, SQL*PLUS, SQL, PL/SQL, SQL*Loader, UNIX (AIX 5.3), PL/SQL Developer Tool, TOAD, SVN, Windows NT, Unix korn Shell

Confidential

Oracle Developer

Responsibilities:

• Designed and developed programs to load the data from flat files into Oracle database using SQL*Loader.
• Involved in enhancements, support.
• Developed PL/SQL Procedures, Packages, Triggers
• Used Triggers in Customizing Error conditions.
• PL/SQL coding at the database level for the new objects.
• Creating SQL scripts to extract the data from the operational database into simple flat text files using sql*loader
• Involved in bug fixing.
• Developed help manuals for clients.
• Documentation and creation of test cases.
• Testing of all the deliverables done with User support