Developer Sql

SUTAPA DAS

Email: ********@*****.***

Mob: 424-***-****

Summary:

Over 7 years of IT experience in various application phases of Software Development Life Cycle including Designing, Development, Testing and Production Support using SQL, PL/SQL, Java and UNIX.

Experience with multiple RDBMS including Oracle 11g/10g/9i/8i, Microsoft SQL Server 2000/2005/2008 and PL/SQL

Expert level experience on PL/SQL that includes Cursors, Ref-cursors, Procedures, Functions and Packages, Oracle Supplied Packages, Object, Materialized views, Partitioned Tables, Triggers, Synonyms, Sequences and Table Indexing.

Experience in creating cursors, composite data types, collections and exception handling.

Extraction of XML files to load it into database through SQL *loader.

Extensive experience in improving the performance of Query by minimizing the number of context switches between the PL/SQL and SQL engines Using Collections, Bulk Binds.

Expert in Query Optimization, Debugging and Tuning for improving performance of the applications using Explain Plan, SQL Trace and Hints.

Extensive experience in Complex SQL Queries, Dynamic SQL, Analytical function, Oracle Object etc.

Experience in using tools like SQL * Plus, PL/SQL developer, TOAD.

Excellent SQL skills, experience writing complex queries and working with database objects like tables, views, sequences, synonyms.

Experienced in writing UNIX shell scripts for automating the process of data loading & Batch Processing.

Developed and maintained system documents, including technical specifications, data mapping, program logic and flowcharts.

Expert knowledge with Microsoft Excel, Power Point, Word.

Strong communication, interpersonal, analytical skills with proficiency at grasping new concepts quickly and utilizing the same in a productive manner.

Worked on DML, DDL, and TCL operations. Extensive experience in Database query tuning.

Technical Skills:

Databases

11g/ 10g/ 9i/ 8i, MS ACCESS

Languages

SQL, PL/SQL, Java, J2EE

Tools

TOAD, SQL Developer, Oracle Enterprise Manager, SQL*Plus, MS Office

Internet Technologies

HTML

Scripting

Unix shell scripting, Java Script

Operating Systems

UNIX, LINIX, Windows VISTA/XP/2000/98, MS DOS

Professional Experience:

Tata Consultancy Services Apr 2008 – Apr2015

Role: Oracle PL/SQL Developer

Description: In TCS (Tata Consultancy Services) I worked in different projects for different customers like Genworth Financial (CANADA), Caterpillar (USA), GIC (India). I worked in Mortgage insurance, Nonlife insurance, Life insurance and healthcare.

Responsibilities:

My responsibilities were to develop new applications, analysing data, testing, data architecture, issue fixing, and customer coordination. I was worked as an onsite coordinator and coordinate with customers in CANADA for 14 months (June, 2011-Aug, 2012). I also worked as the position of Team Leader and had the responsibilities to take care of overall team work, QA analyst, timely delivery of works, coordinate between team and project manager, error free delivery of work etc.

Project Details:

Genworth Financial Canada Apr2008 – Aug2012

Role: Oracle PL/SQL Developer, Onsite Coordinator (2011-2012 in CANADA)

Description: GE Mortgage Insurance Canada together, with its related affiliates, is the largest private sector mortgage insurance company in the world and the only private sector supplier of mortgage insurance in Canada. The system will support GEC MIC real time and automated mortgage underwriting of high and low ratio mortgage applications and bulk deal transactions in CANADA at two underwriting canters, one in Oakville, and the other in Montreal. In the ongoing phase, the maintenance and support is being provided to the TCS customized and developed "Symphony" application and at the same time the remaining functionality like- audit, negative party, portability, progress advance, worksheet, archival etc. are being developed and delivered to the customer.

Responsibilities:

-Design, develop and implement database systems based on customer requirements.

-Design, develop and implement the frontend system on Java and J2EE.

-Optimize database systems for performance efficiency.

-Prepare design specifications and functional documentations for assigned database projects.

-Develop database tables and dictionaries.

-Ensure data quality and integrity in databases.

-Identify any issues related to database performance and provide corrective measures.

-Create complex functions, scripts, stored procedures and triggers to support application development.

-Participate in database design and architecture to support application development projects.

-Perform data back-up and archival on regular basis.

-Test databases and perform bug fixes.

-Troubleshoot database related issues in a timely fashion.

-Develop security procedures to protect databases from unauthorized usage.

-Evaluate existing database and recommend improvements for performance efficiency.

- Develop best practices for database design and development activities.

- Working on Issues and Tickets.

Environment: Oracle 11g, SQL, PL/SQL, HTML/JavaScript, TOAD, UNIX, Shell Scripting, Java, J2EE.

GIC (India) Sep2012 – Oct 2013

Role: Oracle PL/SQL Developer

Description: This is based on Healthcare system. This is basically a maintenance project.

Responsibilities:

Created and modified complex functions, stored procedures, packages and Triggers by using Oracle PL/SQL based on the business rules.

Used UTL_FILE_PACKAGES for writing DBMS_OUTPUT into the files.

Extensively used Oracle 11g features like RESULT_CACHE, Compound Triggers etc.

Worked on Table partitioning and Index creation to improve the performance of the query.

Developed PL/SQL triggers and master tables for automatic creation of primary keys.

Facilitate timely approval of major milestones, approvals and signoff.

Report the project status and generate milestone reports.

Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

Communicate with developers, database administrators, project managers, Systems analysts and senior management about the issues that impact the project’s success.

Create a risk plan and list all the mitigations.

Present the change requests for approvals.

Facilitate and document the post implementation results in the form of closure reports.

Conduct weekly status meetings.

Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.

Participate in requirements review, application design review and test plan reviews

Coordinate activities with infrastructure, business and QA teams.

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL * Plus, TOAD, Shell Scripts, SQL Plus, SQL Developer, UNIX

Caterpillar(USA) Nov2013 – Apr 2015

Role: PL/SQL Developer

Description:

Caterpillar is a huge non-life insurance company. The main business line of Caterpillar based on marine insurance. The client location is situated in Nashville, USA. The roles and responsibilities that I played in that project is to take care of overall project, coordination of Team, Coordination with customer, working on new ideas to bring new business etc.

Responsibilities:

Proposed Changes to the existing Database as per the requirement.

Drafted a Solution Design Documentation for the proposed changes to the database.

Developing Unix Shell Scripts to Execute the Database Packages and Procedures on daily basis.

Tuned the SQL Queries by Statically Analyzing the Database Tables.

Created Stored Procedures, functions and packages as per changes.

Modified Existing Packages, Procedures, Functions and transformations as per the New Architecture.

Extensively performed Unit Testing with different test cases.

Provided Test Data to QA team for validation.

Created and altered database Objects as per business requirements.

Developed number of reports to provide the Error logs Information for the failed transactions and procedures to handle them.

Responsible for data analysis, engineering, programming, implementation and Support for the product.

Involved in Technical Documentation, Unit test, Integration Test and writing Test plan.

Environment: Oracle 9i/10g, SQL, PL/SQL, JAVA, UNIX, SQL*Plus, Toad, UNIX.

Contact this candidate