SUMMARY

• A competent professional with 10 years of experience in the design, development and implementation phases of Software Development Life Cycle (SDLC).
• Experience with Data flow diagrams, Data Dictionary, Database Normalization theory techniques, Entity relation modelling and Design techniques.
• Expertise in backend development using SQL, PL/SQL (Oracle 12c/ 11g/10g/9i/8i), SQL * PLUS, TOAD, PL/SQL Developer and SQL Developer.
• Expertise in backend development using SQL, T - SQL (SQL Server 2012/2014 ).
• Expertise in backend development using MySQL (5.X).
• Created Tables, Views, Constraints and Index (B Tree, Bitmap and Function Based).
• Developed Materialized Views for data replication in distributed environments.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers in PL/SQL.
• Expertise in Ref Cursor, Records, PL/SQL Tables, Dynamic SQL, Collections and Exception handlin g.
• Effectively made use of Table Functions, Analytical functions and Query Re-Write.
• Worked extensively on Global Temporary Tables. Experience in working with Oracle Partitioning Techniques.
• Experience in SQL Performance Tuning using Cost-Based Optimization (CBO), Explain Plan and HINTS.
• Good Hands on experience of key Oracle performance related features such as Query Optimizer and Execution Plans. Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB, and UTL FILE.
• Experience in working with Oracle SQL * Loader and External Tables to load data from flat files to oracle source tables.
• Worked on Banking and Insurance Domains.
• Extensively worked on Informatica ETL Tool.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Extensive experience in Database Administration (Managed User profile, Configure Database backups, Monitor database performance, Master-slave configuration) .
• Expertise in dimension modelling including Star Schemas and Snowflake Schemas.
• Expertise on various Data Modeling tools viz., Erwin Data Modular 7X, ER Studio Data Architect. 8X.
• Mentoring new members and training them with domain knowledge and technologies.
• Flexible and versatile to adapt to new environment and technologies.
• Strong communication, interpersonal, learning and organizing skills matched with the ability to manage the stress and time effectively.

TECHNICAL SKILLS

RDBMS: Oracle10g,11g,12c(SQL,PL/SQL),MySQL(5.X) & Teradata(13,14)

Operating Systems: Windows, Red Hat linux and Hdfs

Languages : Java

Middleware Tools: Dell Boomi Atom Sphere

GUI: Toad for MySQL, Toad for Oracle, SQL Developer, Sql assistant, Erwin, ER Studio

ETL Tools: Informatica Power Center 9.X

Reporting Tools: SAP Crystal Reports

Version control tools: TFS,SVN,Sharepoint

PROFESSIONAL EXPERIENCE

Confidential

Sr. Database Developer

Responsibilities:

• Involved in requirements walk through to identify the scope and feasibility
• Worked with Application team and architect to build data model .
• Controlled Application users based on the roles.
• Created various PL/SQL objects like Stored Procedures, Functions, packages and triggers As per business requirements .
• Involved in identifying and fixing of bugs and data issues.
• Worked on data loading in to custom tables and interface tables and validated custom data through PL/SQL custom packages.
• Developed custom interface programs that occurred daily, weekly and monthly that updates data using PL/SQL, SQL loader, and export and import utilities.
• Coordinate with the offshore team to get the requests done.
• Extensively used Bulk collect, Bulk Binds temp tables and external tables for DML operations.
• Worked on fixing defects and improving performance for existing data base objects by using PLSQL, where performance has increased.
• Worked on Development and Customizing of multiple oracle forms and reports based on Business requirements, involving requirement gathering designing, developing and deploying .
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Used Oracle’s Explain Plan method to analyze the execution and improved the performance of SQL Statements by tuning them and reducing the cost.

Confidential

Technical Lead

Responsibilities:

• Involved in requirements walk through to identify the scope and feasibility
• Worked with ETL team and architect to build data model for staging area.
• Created various PL/SQL objects like Stored Procedures, Functions, packages and triggers As per business requirements
• Involved in identifying and fixing of bugs and data issues.
• Worked on data loading in to custom tables and interface tables and validated custom data through PL/SQL custom packages.
• Developed custom interface programs that occurred daily, weekly and monthly that updates data using PL/SQL, SQL loader, and export and import utilities.
• Coordinate with the onshore team to get the requests done.
• Extensively used Bulk collect, Bulk Binds temp tables and external tables for DML operations.
• Participated in Data Quality meetings with DW Team, where the data integrity issues were discussed and resolved.
• Worked on fixing defects and improving performance for existing data base objects by using PLSQL, where performance has increased.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Used Oracle’s Explain Plan method to analyze the execution and improved the performance of SQL Statements by tuning them and reducing the cost.

Confidential

Sr. Database Devloper

Responsibilities:

• Involved in requirement gathering for multiple data base object developments.
• Created various PL/SQL objects like Stored Procedures, Functions, packages and triggers As per business requirements
• Involved in identifying and fixing of bugs and data issues.
• Worked on data loading in to custom tables and interface tables and validated custom data through PL/SQL custom packages.
• Developed custom interface programs that occurred daily, weekly and monthly that updates data using PL/SQL, SQL loader, and export and import utilities.
• Extensively used Bulk collect, Bulk Binds temp tables and external tables for DML operations.
• Participated in Data Quality meetings with DW Team, where the data integrity issues were discussed and resolved.
• Worked on fixing defects and improving performance for existing data base objects by using PLSQL, where performance has increased.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Developed and new reports and customized existing Reports as per client requirements.
• Used Oracle’s Explain Plan method to analyze the execution and improved the performance of SQL Statements by tuning them and reducing the cost.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
• Performed functional testing for the procedures and packages.
• Developed and customized Discoverer reports for custom applications based on user requirements
• Code review on peer developed code and prepared document for the same