Graduate Teaching Assistant Resume

SUMMARY

Over 5 years of experience in Oracle PL/SQL development.
Oracle PL/SQL development skills like creating stored procedures, User defined functions, Triggers, Views and Error handling.
Experience in Life Sciences - Enterprise Management (Revenue Management and Revenue Recognition) and Retail Analysis Application.
Good Knowledge on US Health care domain where me worked for US Pharmaceutical clients like GSK and Covance.
Vast Experience in managing performance and tuning of SQL queries and fixing teh slow running queries in production wif utilities like Explain, Trace, and Stored Outlines.
Experience in using collections, SQL Loader and performance tuning concepts like BULK COLLECT and FORALL.
Experience in monitoring teh production servers and including scheduling of jobs which were responsible for updating statistics, backup of databases and rebuilding/reorganize teh indexes.
Expert in Pivot tables and v-lookups using Microsoft Excel.
Excellent communication & interpersonal skills wif abilities in resolving complex software issues.
Excellent in time and task management skills.
Ability to quickly learn any programming languages based on teh experience.

PROFESSIONAL EXPERIENCE

Confidential

Graduate Teaching Assistant

Responsibilities:

Gave lectures on topics Data modeling, creating a database schema, importing data, creating procedures, functions, triggers, functions.
Reviewed each student work on their assignments and helped them in understanding overall concepts clearly.
Helped professor in setting up questionnaire and presented seminars related to performance tuning concepts BULK COLLECT and FORALL.

Confidential

PL/SQL Developer

Responsibilities:

Worked in Health Care Industry for teh client GSK as a back-end developer.
Responsible for teh production environments and resolving teh issue/bugs.
As a database developer and architect, responsible for creating database objects like tables, triggers based on teh functionality and tuning/optimizing teh database objects and application queries.
As a part of DBA activities monitor teh Production servers and include scheduling of jobs which were responsible for updating statistics, backup of databases and rebuilding/reorganize of indexes.
Actively participated, involved all team in design, designing discussions wif client and lead to perform a detail analysis according to business requirements and provided better approach to teh system.
As a part of code reviewer, gone through teh code and suggest teh client in case of improvement.
Created Views to facilitate easy user interface implementation, and triggers on them facilitating consistent data entry into teh database.
Involved in ETL processes through Pentaho tool where data from client is Extracted from CSV files tan transformed into our business requirement and Loaded into teh database.
Ability to write complex SQL queries for reporting purpose and have good noledge on pivoting of data in Excel.
Worked on teh GST (Goods services and Tax) module for teh Government ofIndia.
Involved in writing procedures, functions, views, materialized views for teh modules of GST based on teh functional documents provided by teh functional team.
Used Oracle PL/SQL Tables, Cursors to process huge volumes of data and used bulk collect for mass update as performance improvement process
Responsible for performance tuning activities in teh project.

TECHNICAL SKILLS

Databases: Oracle 12c, MSSQL 2012

Tools: PL/SQL Developer, Toad, SSMS, Oracle SQL Developer

Technologies/Languages: PL-SQL/ SQL / T-SQL

DBA Skills: Database Backup/Restore, Data file creation, Backup Strategy (Full, Differential and Transactional), Monitoring server logs, Jobs.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship