SUMMARY

• Oracle Certified Associate (OCA) with over 10.5 years of experience in the field of multi - tier distributed applications, and client/ server development projects.
• LOMA 281 Insurance Domain Certified professional with experience working in several domains including insurance, health, finance, banking.
• Extensive experience in Oracle 12g/11g/10g/9i/8i database programming using PL/SQL (Stored Procedures, Functions, Packages and Triggers) and built-in Oracle packages and UNIX environment along with good understanding of Oracle Architecture,
• Extensive development experience using Oracle Pl/SQL, UNIX.
• Involved in various projects related to Data Modelling, System/Data Analysis, Design and Development
• Hands on experience in Shell scripting / Perl Scripting.
• Experience in performing DBA activities (Database Design, Performance Tuning, and Import/Export utilities, Creation / Deletion of various database objects).
• Hands on experience in data Normalization and De-Normalization for database design and involved in Conceptual, Logical and efficient Physical data model design for better performance of database applications
• Experience in Optimizing database queries, data manipulation and population using SQL and PL/SQL in Oracle database.
• Working exposure of Oracle data dictionary views, schema object relations, schema privileges, roles and restrictions
• Experience in migrating code to different databases from development database and packaging developed code to deploy on clients/production database.
• In-depth knowledge of schema objects (tables, GT tables, views, materialized views, constraints, indexes, packages, procedures, functions, triggers, synonyms, sequences database links) and bulk collects/inserts, cursors/Ref cursors, analytical functions, dynamic SQL, exception handling.
• Exceptional analytical skills with an ability to transform the needs of business users and stakeholders into functional/technical requirements.
• Lead and worked with teams to examine and solve business problems by accurately analyzing the needs of clients and helping them achieve improved quality and value for their customers.
• Self-starter with both technical expertise and business Savvy to translate corporate needs into detailed solutions.
• Excellent problem-solving ability by identifying the problem, trouble shooting, and identify the root cause, and fixing.
• Ability to adjust in new environments, circumstances, with a drive for results through self-motivation.

TECHNICAL SKILLS

Technical Expertise: Oracle PL/SQL Concepts, Oracle DBA concepts, Oracle Forms & Reports development, Data warehousing concepts, Netezza.

Programming Languages: Oracle PL\SQL, UNIX shell, Perl Scripting

Special Software/Tools Used: MPRO, METASOLV, TOAD, SQL DEVELOPER, PL/SQL DEVELOPER, Oracle Forms 10g, Reports 10g, VSS, SQL* LOADER, PUTTY, WINSCP, SQL PLUS, XML, HTML JAVA SCRIPT, ECLIPSE, ERWIN/Toad Data Modeller, OSO, Control M Job Scheduling tool, BO Reports, Tableau Reports, Agility Workbench for pure data system for analytics, IBM Rational Clear case/ Clear quest, SAS

Operating Systems Used: WINDOWS XP/ 7/ 10, LINUX, and UNIX.

PROFESSIONAL EXPERIENCE

Confidential, DC

Senior Database Developer

Responsibilities:

• Involved in gathering business requirements by having discussions with business users, stakeholders, and Subject Matter Experts (SME’s) and prepared mapping documents for source and target systems.
• Analysis on Mortgage data and insurance data for Fannie-mae loans.
• Design dataflow process and implement them using Korn shell script, SQL scripts, SAS scripts and schedule them using Autosys jobs.
• Write ad-hoc queries based on schema knowledge for various application requirements.
• Deal with complex data models and object relational database mapping.
• Test and troubleshoot-test designs of new system to ensure smooth operations and fix any issues that arise.
• Develop data pull scripts and process from different sources like Netezza, Sybase, sql server, oracle schemas.
• Develop UNIX scripts, SQL*Loader scripts to load data into the staging tables from the flat files.
• Develop process flows using shell scripts, SQL scripts for data validation and transformation.
• Work on creating data migration plans and scripts to complete migration of data according to structural changes of target databases.
• Do deployments to Oracle schemas and Unix Dev/UAT servers whenever necessary.
• Prepare profile ready data for direct use of downstream applications.
• Compare data sets using SAS.
• Work on Netezza schemas to get source data for migration.
• Design and development of ETL procedures.
• Develop and tune SQL/PLSQL code.
• Maintain versioning in clear case and uploading documents in SharePoint.
• Schedule jobs using Autosys.

Confidential

Senior Database Developer

Responsibilities:

• Involved in gathering business requirements by having discussions with business users, stakeholders, and Subject Matter Experts (SME’s).
• Actively participated in analyzing the requirements and preparing the design documents.
• Analysed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions
• Developed a Conceptual model using Erwin/Toad Data Modeller based on requirements analysis
• Developed normalized Logical and Physical database models.
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models
• Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation
• Responsible for defining the naming standards for all data objects.
• Worked on creating data migration plans and scripts.
• Involved in performance monitoring and tuning of the database.
• Provide development and production support related to database.
• Implemented and maintained database security (creates and maintains users, roles and Assign privileges.
• Created Indexes and Monitored Performance. Data loading using SQL Loader (from Text files to Database)

Confidential

Senior Oracle Developer and Module Leader

Responsibilities:

• Involved in gathering business requirements by having discussions with business users, stakeholders, and Subject Matter Experts (SME’s).
• Actively participated in analysing the requirements and preparing the design documents.
• Performed the tuning of policy history database to resolve the performance issues.
• Participated in Extraction, Transformation and Loading (ETL) tasks Using PLSQL for sending data to other interfaces.
• Involved in loading bulk data into tables using collections.
• Developed Unix Shell Scripts and Perl Scripts and SQL*Loader Scripts.
• Actively involved in the creation of all database objects like tables, procedures, functions, views and many more as per design.
• Extensively worked in tuning the queries and applying hints for faster and better performance of the SQL queries.
• Developed the SQL*Loader scripts to load data into the staging tables from the flat files.
• Participated in preparing functional document, user document, process flow diagram and flow chart.
• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Involved in loading of data with SQL Loader and to base table with interface programs.
• Created logical and physical database objects - tables, indexes, referential integrity constraints, and Triggers as per development needs.
• Involved in tuning of applications to improve the performance so that batch cycles does not miss SLA.
• Scheduled jobs for both windows and Linux servers using Control M.
• Conducted training sessions for new users.
• Involved in the maintenance of database in sync.
• Used Version Control system SVN for versioning of jobs and scripts.
• Involved in Design and implementation of oracle 11g Data Guard both physical/logical Standby databases for high availability and disaster recovery.
• Worked with database export & import scripts to backup database structures and automation procedures.

Confidential

Senior Oracle Developer

Responsibilities:

• Actively involved in conducting/ attending business requirement meetings with business users and Subject Matter Experts (SME’s).
• Converted the business requirements into various design documents.
• Designed and implemented new database structure as per new requirements and enhancements.
• Involved in development of the SQL Scripts, Stored Procedures, Functions, Database Triggers and Packages using SQL and PL/SQL as per the change documents requirements to incorporate the changes.
• Developed various DDL and DML SQL scripts as per business needs.
• Analysed data, designed and developed Oracle forms 10g queries, layout, report triggers, parameter form, data models etc.
• Performed ETL operations using PLSQL for loading bulk data with/ without transformations into staging tables.
• Involved in the development of shell scripts for regular day to day tasks.
• Involved in the data analysis and data discrepancy reduction for the source and target schemas.
• Created database triggers to flip flags and perform several business validations.
• Worked on Unix Shell scripts and Perl Scripts and used SQL*Loader to load data from external system and developed PL/SQL programs to dump the data form staging tables into base tables.
• Developed Scripts to cleanse source data, ETL process data with business rules, and built re-usable Mappings.
• Peformed Import/export of database schemas, tables.
• Scheduled jobs using control M
• Involved in the Maintainenance of several databases in sync .