Experience Summary

• Over 9 years of experience in Information Technology.
• Technical Lead with extensive experience in Database design, Database Migration as well as performance optimization skills.
• Specialist in Oracle database and Oracle PL/SQL development.
• Domain experience in Banking Credit Risk Management, Capital Requirement Calculation Fund services Life Insurance Annuities and Claims and ERP.
• Extensive experience in leading database technologies such as Oracle 9i/10g/11g , SQL Server Sybase ASE.
• Expertise in Oracle SQL, Analytical functions, PL/SQL, SQL Loader, UNIX Shell scripting, Performance tuning, Data modeling, Data Analysis and Development DBA Activities.
• Experienced in development of ETL mapping and scripts.
• Strong knowledge in developing PL/SQL objects such as procedures, functions, packages, views, materialized views, DB links triggers.
• Strong knowledge in Table partitioning as well as database design.
• Experience in providing end-end solution for data extraction and loading.
• Extensive experience in Onsite/Offshore model and experience in handling offshore teams.
• Strong knowledge in Oracle file handling utilities such as SQL loader UTL FILE.
• Decent knowledge on Oracle 9i/10g/11g architecture.
• Extensive hands on experience in performance tuning of SQL queries PL/SQL programs.
• Thorough experience on Information Technology domain with key emphasis on Analysis, Design, Development, Unit as well as UAT testing, production deployment and Application Management.
• Sound experience in design, develop maintain data load processes, backup processes and reporting frameworks.
• Oracle certified professional in Oracle 9i advanced PL/SQL.
• Decent knowledge on Crystal Reporting tool.

Technical Skills

Professional Experience

Confidential

Sr. Database Developer

Environment: Oracle 11g, SQL Loader, Unix, Windows XP, Toad, WinSCP, HP Quality Center, Erwin, Microsoft Visio, SQL Developer

Responsibilities:

• Leading database development / analysis activities along with interaction with Axiom Reporting team.
• Creation of back end database procedures and packages based on the technical specifications.
• Interaction with Business Analysts to understand FDS based on Federal requirements and creating technical specifications document.
• Executing the stored packaged procedures and analyzing their output by cross-verifying with reports generated from Axiom reporting tool.
• Analysis of massive and highly complex data sets, performing ad-hoc analysis and data manipulation.
• Extraction, transformation, validation and loading of data from different environment using SQL Loader.
• Creation of Error logging and handling procedures/packages for logging and analysis of errors occurred during program execution.
• Perform unit testing and track the defects in QC.
• Created DB Links, synonyms to communicate with remote database server.
• Implement the new features in Oracle 10g such as REG EXP and REG INSTR in SQLs for data analysis activities.
• Reporting and tracking of issues using HP Quality Center.
• Fine tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Cost based optimization.
• Created SQL-Loader scripts to load legacy data into Oracle staging tables and wrote SQL queries to perform Data Validation and Data Integrity testing.

Confidential

Sr. Database Developer / Migration Lead

Environment: Oracle 11g, SQL Loader, Unix, SQL Developer, Crystal Reports 11, Accela, HP Quality Center, Erwin

Responsibilities:

• Lead Data Migration Activities from 3 different source systems to target system.
• Analysis of the source systems and requirements gathering for data migration.
• Meeting with the business users to understand the functionality of the existing systems and map them to the target system.
• Gap Analysis of the business functionality between existing and to-be system.
• Conducted Data Mapping sessions with the source systems technical SMEs.
• Created Technical Specification Document and Detailed Design document and got it approved from Quality Assurance GARTNER team.
• Configuration of the ACCELA migration tool to map the legacy data type and result type with target data.
• Installed Oracle 11g database for Mock environment.
• Creation and maintenance of User accounts and roles for testing and development team.
• Created data flow diagrams, data mapping from Source to stage and Stage to Target mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.
• Created Test cases and Test scripts for System Integration Testing SIT , User Acceptance Testing UAT and Unit Integration Testing.
• Validated ETL mappings and tuned them for better performance and implemented various Performance and Tuning techniques.
• Developed SQLs using Analytical functions such as Rank Dense Rank .
• Tune or rewrite the time consuming queries using SQL tuning techniques.
• Execution of 3 Mock conversion loads before loading the data using ACCELA conversion tool to migrate to target system.
• Created Oracle scripts for Error logging and Error handling.
• Cold backup of 2 legacy Oracle databases.
• Validation and Verification of the migrated data with the business users and end users.
• Created Error and Count Reports for discussion within the team and senior management.
• Reporting and tracking of issues using HP Quality Center.

Confidential

Senior Database Developer / Analyst

Environment: Oracle 11g, Sybase IQ15, SQL Server, SQL Loader, Unix, Shell Scripting, Autosys, Toad, WinSCP,

HP Quality Center, Erwin, Microsoft Visio

Responsibilities:

• Technical Lead for the onshore as well as offshore team of size 4.
• Participated in the Analysis sessions, gather requirements and convert those requirements in to data models.
• Developed plans, strategies and standards for data within the enterprise module.
• Understood the end-to-end scope of work and participated in design architectural solutions.
• Ensured that the database base is secured and updated
• Partnered with other teams database management team, designers and users to provide best solutions by maintaining the best standards of practice.
• Provided solution for end-end data loading, retention, Cleanup and analytics in the database.
• Mentor the team in Oracle 11g, Sybase ASE SQL Server databases.
• Develop PL/SQL procedures, functions, packages, views, and triggers for complex reporting environment.
• Provide solution for automation of data loads.
• Modification of Unix Shell Scripts and Autosys Scheduler Jobs.
• Created indexes on tables to improve the performance by eliminating the full table scans and views for hiding actual tables and to eliminate the complexity of the large queries.
• Fine tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Cost based optimization.
• Tracing, troubleshooting with database performance and tuning issues.
• Improve the performance of problematic modules by implementing performance tuning techniques in the database.
• Perform code review as well as design review and provide code approval for production implementation.
• Perform unit testing and track the defects in QC.
• Used HP Quality Center for logging and tracking of issues/tickets.
• Debugging of .NET code with .NET application developer.

Confidential

Senior Database Developer

Environment: Oracle 10g, PL/SQL Developer, SQL Loader, Unix, Windows XP, Erwin, VSS

Responsibilities:

• Lead the Application development AD team and delegate tasks to the members of the team and get it done in stipulated time.
• Prepared Technical Functional documents such as High level design document, Detailed Design document Approach document.
• Created new objects in database such as Tables, triggers, jobs, synonyms and views using Oracle Stored procedures, functions packages and Oracle jobs.
• Developed crystal report templates for new reports.
• Worked on UNIX shell scripts for inbound file loading and email triggers.
• Created partitions on the history tables. Transform the data from individual systems to a common accessible server.
• Develop new procedures and packages for new report requests and automate them.
• Automation of all data load processes.
• Export/Import of oracle databases.
• Analyzing and validating database objects.
• Manage privileges on tables and other objects for outside schema users.
• Analyzed and modified existing procedures for the claims adjustment process.
• Create control files and load data from flat files to tables using SQL Loader.
• Generate trace files with the help of DBA's and identify the problematic SQLs.
• Perform unit testing and track the defects in QC.
• Created DB Links, synonyms to communicate with remote database server.

Confidential

Oracle Developer

Environment: Oracle 10g, PL/SQL Developer, SQL Loader, IFS Report Builder, Crystal Reports 9, Centura Buidler, Erwin, VSS

Responsibilities:

• Plan, participate and prepare documents for Data Migration using Oracle 10g PL/SQL and Reports Development using Crystal Reports 9.
• Provide training to the IT department on technical aspects regarding Data Migration.
• Coordination with back office for new customization and patch releases.
• Tracking and reporting of daily and weekly activities and status reports.
• Making Technical specifications for customizations and testing customizations after development
• Collection of data from client for Data Migration.
• Interacted with the Client, Functional and Domain Experts for Data Validation and Checks.
• Development of SQL Queries, Functions, PL/SQL Methods and Exception Handlers.
• Development of New Reports and handling of change requests for existing Reports using Crystal Reports 9 and IFS Report Builder.
• Client Specific Report Customization Using IFS Report Builder.
• Migration report preparation.
• Load the data from flat files using SQL Loader.
• Create procedures using UTL FILE package to create files from tables as well as load files in to tables.

Confidential

Oracle Developer

Environment: Oracle 10g, PL/SQL Developer, SQL Loader, IFS Report Builder, Crystal Reports 9, Erwin, VSS

Responsibilities:

• Rewritten the stored procedures, packages and functions in Oracle PL/SQL in WIndows platform.
• Eliminated deadlocks in report generation process DBR .
• Creating Oracle jobs Using Oracle 10G DBMS SCHEDULER to automate the report generation process.
• Tune the time consuming SQL queries.
• Defined and implemented performance tuning techniques using Oracle hints, creating indexes and collecting statistics.
• Generate trace files with the help of DBA's and identify the problematic SQLs.
• Perform unit testing and track the defects in QC.
• Involved in Designing, Testing and Coding of New Reports using Crystal Reports 9.
• Discussion with the core users and end users for requirements freezing.
• Create control files and load data from flat files to tables using SQL Loader.
• Client Specific Report Customization Using IFS Report Builder and Oracle Reports 6i.
• Provide training to the IT department on Crystal Reporting tool.
• Plan, participate and prepare documents for Data Migration using Oracle 10g PL/SQL and Reports Development using Crystal Reports 9.