We provide IT Staff Augmentation Services!

Sql Resume

Summary

  • A senior IT professional having more than 9 years of experience in the IT industry involving in complete SDLC including architecture, analysis, design, development, Database Design and Development, testing, implementation & maintenance of application software in the Client/Server environments withproduction support.
  • Expertise in Oracle 11g/10g/9i/8, PL/SQL, SQL*Loader, SQL*Plus.
  • Expertise in Database design, writing stored procedures, functions, packages, triggers, cursors, DDL, DML, Database Links, external table and good understanding of RDBMS concepts.
  • Expert in using the data query tools for Oracle like PL/SQL Developer, SQL Developer, WinSql etc.
  • Worked with Oracle Database Administrator for Performance Tuning and maintenance of database, Database security (User & Resources, User Privileges & Roles).
  • Experience in UNIX shell scripting, ETL using Pl/SQL.
  • Knowledge of EXPLAIN PLAN, TKPROF, performance tuning techniques.
  • Extensive experience in using database packages such as DBMS_SQL, UTL_FILE, DMBS_OUTPUT, DBMS_JOB.
  • Working with Build team to schedule jobs on crontab, control-M scheduler.
  • Extensive use of Crystal Reports 8.5/9/11.0 for developing reports in projects.
  • Extensive experience in developing web and client/server applications using ASP, Visual Basic 6.0, JavaScript, VBScript, HTML, CSS.
  • Fair experience on MS-SQL Server 7.0/2000.
  • Expertise in using HP Service Desk Manager to handle tickets opened by users. Also handled Change/Problem/Incident management through this.
  • Awareness of Software quality Processes.
  • Hands on experience in Unit/System/Integration testing of applications. Experienced in using Defect Management tools.
  • Experience in coordinating Functional, Regression, Acceptance, Performance, Stress testing and analysis of User, Business and System Requirements
  • Good qualities to lead a team and participate in teamwork with excellent communication and presentation skills.
  • Good problem solving and analytical skills.

Technical Skills

  • Internet Technology: ASP, HTML, VB Script, JavaScript, CSS
  • Databases: Oracle 8i/9i/10g/11g, MS SQL Server 2000.
  • Languages: Visual Basic 6.0, SQL, PL/SQL, UNIX Shell Scripting
  • Tools: PL/SQL Developer, SQL Developer, Toad, WinSql, Visual Source Safe, Lotus Notes database, IIS, RMS, Microsoft Office Visio, Rational Clear Quest, SVN
  • Reporting Tools: Crystal Reports 8.5/9/11.0
  • Operating Systems: Windows 2000/2003/XP/NT
  • Others: Knowledge of Quality processes, Configuration Management.

Education

Bachelor of Engineering in Electronics.

Professional Experience

  • Project : Claims Intake ODS
  • Client : Confidential, USA
  • Duration : January 2012 to till date
  • Environment : Oracle 11g, PL/SQL
  • Tools : Toad, Informatica, HP Quality Center

The Intake ODS project of the Confidential Claims system is very critical insurance business of Confidential. This system deal with receiving claims from various TPGs and processing the claim at every step to validate the data. The system deals with authenticating the claim data acknowledging back with a remittance towards the claim.

Responsibilities
  • Gathering requirements from business analysts and analyzing the defect assigned.
  • Design PL/SQL scripts to be used with Informatica to create ETLs.
  • Using Informatica/SQL* Loader to load data into source tables.
  • Building SQL scripts to investigate historical data and upstream data process.
  • Building Stored Procedures that will be used in conjunction with Informatica to transform the data from source.
  • Query tuning using EXPLAIN PLAN to provide better efficiency in running application.
  • Deploy mappings in various system test and system integration environments before submitting to client for production deploy.
  • Document defect analysis and code fixes for future reference.
  • Project : CORE
  • Client : Confidential, USA
  • Duration : August 2011 to till December 2011
  • Environment : Oracle 11g, PL/SQL
  • Tools : PL/SQL Developer, Maven, Subversion, JIRA

The CORE Program - Common Opportunities, Results and Experience - focuses on innovation in processes and technology to reduce cost and complexity, better leverage skill and scale, and enable a better response to market and volume changes. RDH (Reference Data Hub) is a CORE system of record for business configuration and reference data. Additionally, ETL processes are used to consume and format/transform supported data from authoritative business and NON-CORE technology sources and also to distribute this information across the CORE technology systems. This project would be primarily involved in maintaining loan data and gathering information from various business databases.

Responsibilities
  • Co-ordinate with business analysts to design a database architecture that would implement business requirements.
  • Build ETLs using Oracle PL/SQL that would load data into RDH and COD system.
  • Using SQL*Loader, external table to load data into intermediate tables.
  • Using Oracle PL/SQL to transform and load data into database tables.
  • Build releases to deploy scripts using Maven across environments to validate system testing, Integration testing and performance testing of the program.
  • Resolve data issues/defects logged in JIRA tool by QAsdetected in testing phase and maintain accurate data.
  • Performance tuning of queries using output from Explain Plan, TKPROF and using best efficient solution.
  • Define and articulate business rules required for data accuracy and consistency. Identify and resolve data quality issues. Act as the primary contact for the data management process.
  • Create Visio documentation for the project and visual timelines of project interdependencies, and assist in resource planning and scheduling planning.
  • Assist Technology Manager in any issues related to Data Management.
  • Maintain version control by using SVN (Subversion).
  • Working on post-production support by providing solutions and fixes for ETL issues.
  • Project : Learning Management System
  • Client : Confidential, USA
  • Duration : September 2009 to July 2011
  • Environment : Oracle 10g, PL/SQL, Unix Shell Scripting, ASP, HTML, CSS, JavaScript, VBScript
  • Tools : SQL Developer, RMS, Crystal Reports, HP Service Desk Manager, Lotus Notes, ClearQuest

Learning Management System (LMS) is a tool for employees to enroll and launch courses and assessments. This tool also helps user to receive credits through transcripts generated in LMS. This is basically an administrative tool to handle the employee training profile. LMS also has capability to give transcripts to users who take courses other than LMS.

Responsibilities
  • Analysis of functional requirements from business partners.
  • Database design for the system. Involved in defining referential integrity, data fields.
  • Design and develop Report Administration module to generate Reports using Crystal Reports. The back-end logic for the same developed using procedures, functions, packages, cursors.
  • Design and Development of Employee compliance reports using Oracle PL/SQL, Crystal Reports 11.0.
  • Design of communication module between LMS and LCMS using packages, stored procedures, functions, db links, exceptions.
  • Development of Survey Tracker job using UNIX Shell Script, procedures, functions, exceptions, triggers, SQL*Loader.
  • Design and Develop User Synchronization job using UNIX Shell Script, PL/SQL packages, procedures, functions, UTL_File utility.
  • Tuning of queries for better output efficiency based on analysis from TKPROF, EXPLAIN PLAN and other optimization techniques.
  • Working with build team to schedule jobs using CONTROL-M scheduler.
  • Tuning of queries for better output efficiency.
  • Design and development of People Administration, System Administration, Catalog Administration modules using ASP, JavaScript, VBScript, CSS.
  • Enhancement of People Administration module.
  • Prepared test data for testing. Was involved in System Acceptance testing and integration testing.
  • Configuring IIS on application servers and Deployment of application on Development, Simprod environments and later move it to production. Automation of deployment process for production.
  • Maintain and Support 9 windows production web servers to handle user load.
  • Application testing to validate Security Patches, Enterprise server/workstation releases, IIS updates.
  • Active participation in implementation and coordinating with offshore to perform performance and integration testing.
  • Project : Learning Content Management System
  • Client : Confidential, USA
  • Duration : March 2008 to August 2009
  • Environment : Oracle 10g, PL/SQL, Unix Shell Scripting, ASP, HTML, CSS, JavaScript, VBScript
  • Tools : WinSQL, RMS, Crystal Reports, HP Service Desk Manager, Lotus Notes, Rational ClearQuest

The Learning Content Management System (LCMS) project implemented enterprise-wide software tool to allow associates to continue to utilize a common platform for both creating on-line course content and receiving on-line training.

Responsibilities
  • Analysis of the functional requirements submitted by Business partners.
  • Creation of technical documents of system flow, system topology for test and production environments.
  • Design and Development of test cases for Unit testing, Integration and system acceptance testing.
  • Development of Search module for Objects/Graphics/content/courses. Using REF cursor, procedures, and exceptions to develop the database logic for the same.
  • Design and develop packages, procedures, functions, triggers, exceptions, REF cursors for creation of user Profile management module, security administration module.
  • Develop course creation module managing metadata and taxonomy details.
  • Involved in design and development of LCMS custom reports using Crystal Reports 11.0, Oracle PL/SQL packages, functions, procedures, exceptions, REF cursors for the requirements forwarded by business partners.
  • Developed LCMS Completions job to create a list of users who have complete courses in past 24 hours and SFTP that file for Survey Tracker job. Generating text files using UTL_FILE, procedures, functions.
  • Performance tuning based on analysis from TKPROF, EXPLAIN PLAN and discuss same with DBA.
  • Development of VB executable to cleanup expired enrollments in database. Also developed log file rename executable to improve application performance.
  • Configuring RMS as change management tool to maintain code versions.
  • Project : L&D Testing and Assessment Software Implementation
  • Client : Confidential, USA
  • Duration : August 2007 to February 2008
  • Environment : Oracle 10g, PL/SQL, ASP, HTML, CSS, JavaScript, VBScript
  • Tools : SQL Developer, RMS, Crystal Reports 11, HP Service Desk Manager, Lotus Notes, ClearQuest

This tool will enable L&D to automate the processes by which we create, publish, deliver, score, store, and report on assessments and assessment data within the company.
This tool is comprised of two main components:

1) A thick client application on the workstations of approximately 20 Corporate L&D associates that allows them to develop web-based assessments.
2) Web-based application internally that allows Developers to publish web-based assessments to the server, Associates to access these web-based assessments and Administrators and training professionals or report on data submitted through assessments

Responsibilities
  • Understanding and analyzing the requirements of the customer technically and functionally.
  • As a senior team member, involved in identifying the business scope, continuous project discussion with end users documenting the requirement specifications, updating the respective design documents. Created System Topology using Microsoft Visio.
  • Involved in Database design, developing database logic for application system using PL/SQL procedures, functions, REF cursors, exceptions, triggers, exceptions.
  • Tuning queries and suggesting the same to the team to produce better efficiency output.
  • Also implemented reporting utility using Crystal Reports 11.0. Using PL/SQL procedures, functions, REF cursors for developing back-end logic.
  • Web page development using ASP, JavaScript, VBScript, CSS, HTML.
  • Actively involved in calculating Business Volume Metrics for Performance testing.
  • Preparation of Test cases and involvement in Unit/Integration/System testing.
  • Defect Management using Lotus Notes as a repository. Scheduling Defect Status meeting and communicating progress and action items to the whole team through different channels.
  • Defect Fixing, Troubleshooting and imparting training on the tool.
  • Acts as a Single Point of Contact for support.
  • Project : EA/GNC/Philibert 2001 CSO Table - Whole life and 5 Year term
  • Client : Confidential, USA
  • Duration : July 2006 to July 2007
  • Environment : Oracle 9i, PL/SQL, ASP, HTML, CSS, JavaScript, VBScript
  • Tools : PL/SQL Developer, RMS, Crystal Reports, HP Service Desk Manager, Lotus Notes, ClearQuest

The insurance industry derives mortality tables based on the experience of a number of insurance companies. Company uses these mortality tables to calculate reserves, cash values, guideline premiums, cost of insurance, etc.

Responsibilities
  • Analysis of requirements from business partners.
  • Development of Insurance Quote module for various states of USA using ASP, HTML, JavaScript, VBScript, CSS.
  • Using procedures, functions, packages, exceptions as back-end logic to generate module.
  • Development of VB Dlls to calculate the Life Rate Quotes.
  • Unit/System testing the application to achieve the business requirements.
  • Involved in troubleshooting the defects reported by end user.
  • Integration testing of the application.
  • Project : MetLife Mexico Integrated Environment Support
  • Client : Confidential, Mexico
  • Duration : August 2004 to November 2004
  • Environment : Visual Basic 6.0, MS-SQL Server 2000, Windows 2000
  • Tools : VSS

Confidential is the biggest contributor of business of MetLife International. Currently MLM caters to Group Life and Individual Life Business. The Reinsurance application is used to calculate the premiums to be paid to the Reinsurance companies for Individual Life and Group Life policies.

Responsibilities
  • Interaction with the client for Knowledge Transition.
  • Creation of Understanding Document, Technical Document and Functional Document.
  • Analyzing the requirements and develop the change requests sent by the client.
  • Unit testing of the Change requests.
  • Project : Confidential Chile Enhancements and Webservice.
  • Client : Confidential, Chile
  • Duration : October 2004 to June 2006
  • Environment : ASP, CSS, Java script, HTML, Oracle 8, Power Builder 9.0
  • Tools : VSS

Confidential has an affiliate in Confidential and retirement savings market since 2001.
The objective of this project is to handle the maintenance and enhancement activities for the various applications for Confidential, Chile. The project started by acquiring deep functional and technical information about the overall business and corresponding systems in MetLife.
The business requirement was to add a new functionality in the existing MetLife Portal.

Responsibilities
  • Creation of Functional and Technical Specifications.
  • Analyzing the Requirements and creation of Test cases.
  • Design prototype to get signoff from vendor based on the requirements
  • Development of the Secretary and agent module.
  • Unit Testing of the Portal.
  • Project : Confidential Chile NON CP Support
  • Type : Maintenance/Enhancement.
  • Client : Confidential Chile
  • Duration : July 2005 - September 2005 (Part Time)
  • Role : Configuration Manager

Confidential has an affiliate in the Chilean Insurance and retirement savings market since 2001.
The responsibilities included in controlling the source code versions in the VSS and giving access rights to the team members. The role also involved into restoration of the weekly backup and its verification.

  • Project : Asset Management System.
  • Duration : January 2004 - July 2004
  • Environment : ASP, MS SQL Server 2000, JavaScript, VBScript, Windows 2000
  • Tools : VSS, Crystal Reports 8.5

Asset Management System was developed to keep a track of all the assets with the company at its various location and branches. This system gives details about the condition, location, usage etc. about a particular asset.

  • Project : Confidential.
  • Duration : January 2004 - March 2004
  • Environment : ASP, MS SQL Server 2000, JavaScript, VBScript, Windows 2000
  • Tools : VSS, Crystal Reports 8.5

Confidential is a web application provided for the customers to buy wide range of bridal and solitaire jewellery like rings, earrings.

Responsibilities:
  • Analyzing the Requirements and designing the project.
  • Development of the transaction modules.
  • Designing of the efficient database.
  • Unit testing and System testing of the application.
  • Project : Diamondstar Networking System
  • Duration : May 2002- December 2003
  • Environment : ASP, MS SQL Server 2000, JavaScript, VBScript, Windows 2000
  • Tools : VSS, Crystal Reports 8.5

Diamondstar Networking System is a comprehensive Business-to-Business portal for trading diamonds online. This portal facilitates registered users to search for diamonds according to credit limits and buy diamonds according to their size, shape, clarity etc.

  • Project : Confidential.
  • Duration : May 2002 - December 2002
  • Environment : Visual Basic, MS SQL Server 2000
  • Tools : Crystal Reports 8.5

Confidential is a business accounting system basically catering to the transaction of diamond accounting and export activities. This system features the basic accounting module with the generation of the relevant documents and activities related to report.

Responsibilities
  • Development of the master forms for the export and import modules.
  • Generating the reports relating to accounting, sales, and purchase modules.
  • Testing of the application.

Hire Now