PROFESSIONAL SUMMARY:

• Having 10+ years of IT experience in Full Life Cycle Development including Planning, Analysis, Design, Implementation and Maintenance.
• Excellent understanding of Entity Relationship Diagrams (ERDs) and the translation of business requirements into them.
• Extensive experience in developing applications using Oracle database and strong Designing and Coding Experience in Oracle PL/SQL & SQL .
• Experience in creation of various Database objects like Tables, Procedures, View, Triggers, Indexes, Packages, and Types.
• Good knowledge in writing complex queries to read data from the database and Entity relation model.
• Expertise in Performance Tuning of SQL queries & Views using Explain Plan, SQL Trace on Oracle 11g/10g databases.
• Experience in data extraction, Transformation and loading (ETL) of data from various sources like Oracle, SQL Server and different file formats utilizing oracle Utility tools SQL *Loader, Import and Export.
• Having functional knowledge in various business functions ranging from Legal systems, Insurance and Customer systems.
• Having experience in Data profiling, Data governance activities for a very confidential data for a Hi - Tech customer.
• Experience in performing data migration and ETL activities in Oracle using SQL, PL/SQL coding, Knowledge in Informatica tool for ETL activity
• Good Experience in Debugging, monitoring, troubleshooting issues, during the test phases.
• In-depth knowledge of SQL for data analysis, data profiling, data cleansing.
• Expertise in loading data from legacy systems using SQL*Loader, UTL FILE.
• Proficient in documentation and providing Technical Support to end-users.
• Good Knowledge in code merging and maintenance using SVN.
• Extensive knowledge in using Oracle Specified Packages.
• Good Knowledge in Unix crontab and Autosys for scheduling the jobs.
• Experienced in Production Support activities which include organizing new development releases, interacting with different support teams and effectively communicate to clients on the statuses in case of any production issues, analyze and resolve the production issues.
• Experienced with Offshore/onshore business models for development activities
• Knowledge with Other Database such as SQL Server (2012,2008).
• Actively participated in code walkthroughs and code reviews.
• Experience in working Agile Software Methodology which helps the businesses responds to unpredictability.
• Knowledge in Reporting Tools such as Cognos and Business Objects
• The ability to adapt and learn new technologies and proficient in learning them quickly.
• An enthusiastic and project-oriented team player with solid communication and leadership skills, self-driven and the ability to solve critical problems and interested in providing creative solutions for challenging requirements.

TECHNICAL SKILLS:

Database: Oracle (12c)/11g/10g/9i/8i, SQL Server 2008/2005

Programming Languages: SQL, PL/SQL

ETL Tools: Informatica

Scheduling Tools: Autosys, Crontab

BI Reporting Tools: Cognos, Business Objects

Scripting Languages: UNIX Shell Script

Operating System: Mac OS, Window, AIX

Tools: SQL Developer

WORK EXPERIENCE:

Confidential, Sunnyvale, CA

Sr. Database Developer/Analyst

Responsibilities:

• As a Developer, my roles and responsibilities are gathering and analyzing the business requirements.
• Actively interacted with project managers & team members to discuss timely deliverables, project status & Documented technical specs from functional specs in reporting point of view .
• Involved in Requirement Gathering and analysis, development, Integration and User Acceptance Testing, primary and secondary support phases of the project.
• Developed design documents, ER diagrams by analyzing the requirements and worked to define the project implementation strategies.
• Developed database objects like tables, views, indexes, and sequences.
• Involved in Designing and Partitioning of the tables in the database along with DBA as part of performance tuning.
• Involved in writing PL/SQL Packages, Functions, Pipeline Functions, Stored Procedures and DB Triggers to implement complex business functionalities.
• Understood complex performance issues and worked with DBA’s to suggest valuable ways to fix the problem.
• Involved in loading of the data from different data sources like CSV, XML, FLAT files etc., to oracle database using SQL Loader.
• Data optimization, scrubbing and manipulation of staged data using PL/SQL packages.
• Enhancing the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
• Used PL/SQL Built-in Packages DBMS STANDARD, DBMS OUTPUT, and UTL File etc.
• Wrote SQL Scripts for reports and creating views for reports.
• Have worked on many cron-based scripts, which generate reports based on business logic and sends email to users having the data in form of HTML Tables/ Excel Attachments/ Txt Documents.
• Documented every phase like Technical specifications, source to target mappings, data and release notes.
• Used CRONJOB for job scheduling on UNIX as well as tools like Autosys to run regular day-to-day administration scripts and setting up batch scripts.
• Performed Unit /QA testing and bug fixing.

Environment:: Oracle 10g, 11g, SQL, PL/SQL, UNIX Shell Script, SQL*Loader

Confidential

Oracle DB Developer

• Involved in the analysis, design, and development and testing phases of Software Development Life Cycle (SDLC).
• Gathered the requirements from the data analysts and architects and performed technical analysis to reach a viable solution.
• Created and managed primary data base objects such as Tables, Views, Indexes Sequences and Synonyms.
• Built complex queries using SQL and wrote stored procedures &packages using PL/SQL.
• Wrote PL/SQL Stored Procedures, Functions, and Packages to implement Business Rules.
• Designed and developed PL/SQL functions/ stored procedures/ cursors/ triggers/ packages.
• Designed database structures for effective data extraction, validation, run detail notification and error logging.
• Developed PL/SQL ETL scripts to transfer data across the schemas and databases.
• Unit testing on PL/SQL Packages and procedure, functions according to business requirement.
• Managed and resolved design issues during deployment.
• Involved in tuning and optimization of SQL statements.
• Involved in writing test scripts, unit testing, system testing and documentation.
• Documented every phase like Technical specifications, source to target mappings, data and release notes.
• Worked with production support team in resolving production issues.
• Assisted in testing and deployment of the application.
• Supported code deployment from lower to higher environment.

Environment: ORACLE 9i, SQL*Plus, PL/SQL, SQL*Loader, TOAD, SQL Developer.

Confidential

DB Developer

• Analysis and gathering of new business requirements from the business resources.
• Transformed Business requirements to functional and technical specifications.
• Created Packages, Procedures, functions, tables, Primary keys and foreign keys in Oracle 9i using Toad for Oracle.
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms.
• Worked with DBAs to tune long running queries and to analyze query execution plan.
• Worked with Collections to reduce overhead involved with cursor looping. Bulk fetched the data from SQL engine into collection.
• Automated repetitive processes by writing DBMS JOB scripts.
• Provided daily support for multi-task development, and worked on DEV/QA testing and interacting job between DEV/ QA/ PROD environment. Work with QA team to debug/fix issues.
• Resolved Priority Production Support Issues and Defect Fixes.

Environment: Oracle 9i, SQL, PL/SQL, Windows XP, TOAD, SQL Developer, SQL Plus.