Customer Service Sql

Dhirenkumar Patel

abpwj2@r.postjobfree.com 519-***-****

Objective:

Seeking a position as an Oracle Developer with a progressive organization in which high level of developmental & design skills, organizational abilities and strong communication skills can be utilized and enhances them and prove to be a valuable asset to the organization and industry.

Summary:Over five years of experience as an Oracle Developer and having Experience with data loading, testing, developing, designing, managing and maintaining multiple databases running on Oracle Database 9i/10g/11g with ETL and PL/SQL.Proficient in writing Nested/Correlated queries, Stored Procedures, Functions, Triggers and Packages using SQL and PL/SQL.Work closely with various levels of individuals to coordinate and prioritize multiple projects. Estimate, schedule and track projects throughout SDLC.Skilled in developing business plans, requirements specifications, user documentation and source-to-target mappings for Informatica ETL Processes.Expert in SQL query optimization using Explain Plan, Utlbstat/Utlestat, TKPROF reports, gathering statistics and running scripts. In- and experience of working on oracle forms, Crystal Reports, Oracle, SQL, VB 6, Perl with excellent multitasking, troubleshooting and debugging skills.Involved in planning, analysis, design, development and implementation of different project from gathering requirements through completion of projects.Proficient in Oracle logical and physical Databases Design, Implementation and Maintenance and Expert in Creating Database objects such as Tables, Tablespaces, Indexes, trigger, partition and Views.Good team player with team, excellent communication, analytical and presentation skills with strong aptitude towards learning new technologies.Experience in Full software development life cycle (SDLC) of software development from gathering project requirement, design, development, testing to implementation of project.Sound knowledge in Programming such as Unix Shell Scripting, C/C++, VB 6, PL/SQL.Proficient in interpersonal relations, Team Lead skills, Project Management, Communication, Outsourcing Partner Teamwork and Organization.

Education: Master of Science(Computer Science)

University Of Bridgeport, Connecticut, USA

Bachelor of Engineering (Information Technology)

Shivaji University, Maharashtra, INDIA

Certification:OCA (Oracle Certified Associate)

Software/Hardware:

Oracle 11g/10g/9i, RDBMS, OLAP, Linux, Unix, SQL Server, Toad, RMAN, MS Access, ETL Tool (Informatica), Tidal Scheduling Tool, DB Design, LDAP, J2EE, Data Import/Export, Oracle Enterprise Manager, Data Loading, Data Warehouse Builder, MS Office, Erwin, SQL Navigator, Data Pump, Explain Plan, Crystal Repost, TKPROF, SQL Loader, SQL, PL/SQL, Developer 2000, Unix Shell programming, Perl Scripting, C/C++, VB 6, Visio, HTML, XML, Data Warehousing, Oracle Forms and Reports, Windows NT 4.0 and 2000 and 2003, SQL Backtrack.

Experience:

IMS Health, Waltham, MA April 2009 – July 2012

Oracle Developer

Responsibilities:Writing Stored Procedures, Functions, Triggers and Packages using SQL and PL/SQL.Oracle Reports Development, code enhancement and program development or required fixes to production problems using the functional and technical programming standards. Design, Develop, Test, Implement and troubleshoot ETL mappings and workflows in a large Data Warehouse environment.Extensively worked on monitoring Database and network Performance and Tuning bottle-necks, especially for resource intensive transactions using V$ Tables, Data Dictionary views, TKPROF, Explain Plan, Statspack and GUI tools like OEM. Created tables, synonyms, sequences, functions, views, PL/SQL stored procedures and triggers and Enforced database integrity using primary keys and foreign keys. Created various Forms for Entry screens and Reports using Forms and Reports and Developed many reports using Oracle Reports to show audit related information.Design applications to functional and technical programming standards as per requirement. Create, configure, and support various ad hoc reporting tools and reports.Analyze performance of programs, data integrity and quality and take action to correct deficiencies based on consultation with users and client requirement.Responsibilities include handling large amount of data and provide 24x7 production support for PL/SQL and ETL Informatica jobs.Developed Unix Shell scripts to Automate Database operation and Database monitoring.Develop test, qa and implement production ETL scripts that will be used to support the extraction of data from the Data Warehouse to support client deliverables.Responsible for Develop and maintain Scripts on oracle 10g, SQL and PL/SQL and Creating of Perl and UNIX scripts.Responsible for delivering data to different clients based on Data Extract Request from clients based on requirement.Tuned the multiple Databases for Performance and involved in security audit of Databases and servers and for that wrote shell scripts to implement periodic security management on the production Databases.Code, test and troubleshoot programs utilizing the appropriate hardware, database, and programming technology.Implemented Backup and Recovery strategies using Export/Import, RMAN and Online Backups.Responsible for loading of data in data warehouse using SQL Loader, Informatica ETL tool and Tidal Job Scheduling Tool.

Environment:

Oracle 11g/10g, SQL server, Unix, DB Design, SQL, PL/SQL, ETL Tool(Informatica), Data Warehouse Builder, Data Loading, SQL Loader, FTP, Flat File, Tidal Scheduling Tool, Erwin, Oracle Forms & reports, Explain Plan, Data Pump, Data Warehousing, Perl Scripting, Shell Scripting, Data Import/Export, RMAN, Erwin, HTML, XML, Visio, Toad, SQL Backtrack.

Dharmik InfoTech, Ahmadabad, India May 2004 – July 2006

Oracle Developer

Responsibilities:Responsible for Oracle 9i/10g logical and physical Databases Design, Implementation and Maintenance on UNIX and windows.Developed solutions, PL/SQL Procedures, Scripts dealing with schemas such as Tables, Indexes, Partitions, Views, Triggers, for daily production and performance.Created Database objects such as Tables, Tablespaces, Indexes and Views and Estimated Table sizes, Tablespaces and Identifying integrity constraints for Tables.Responsible for Full Database Defragmentation carrying out Technical Design of the system using Dataflow Diagrams, Entity-Relationship Diagrams and PERT Chart. Provided report generation solution to the clients using Crystal Reports for the business requirements and designed reports using Crystal Reports as per company standards.Created different types of reports such as master/detail, cross tab and chart for easy-to-use benefit information system by using Crystal ReportsProvide support for problem resolution of existing applications and internal requests as well understand business problems and communicate to the teams about technical designs and functionality.Responsible for analysis of current programs including performance, diagnosis and troubleshooting of problematic programs, and designing solutions to problematic programming.Responsible for Integrity and Concurrency of Data and Designing Database and Performed Testing, Debugging and Documentation.Implemented Database design and changes using Toad and Wrote technical Documents and Specifications.Identified the row chaining, row migration and de-fragmentation of the Tablespaces.

Environment:

ORACLE 9i, OLAP, Unix, Windows, MS Access, ODBC, SQL*Plus, SQL, PL/SQL, SQL Navigator, Crystal Report, LDAP, Toad, Developer 2000, J2EE, Import-Export, C/C++, VB 6, Shell scripting, Perl scripting, HTML, XML, Oracle Forms 6.

Academic Projects:Banking Management System:-

The system allows the customer to perform all the operation dealing with bank like open account, taking loan, withdraw money, Depositing, report of individual customer etc.

Customer Service Help Desk(CSHD):-

This application was developed in real time Environment. The System helps businesses and organizations to track and service their Customers, manage Service Requests, publish Knowledge and Solutions. Also, using Customer Self-Service portal, customers can browse the knowledge base, raise requests, and participate in forums. It is fully web-based system.

Related Courses:

Database Management Systems Advanced Database Design

Operating Systems Database Design

UNIX System Programming Java Programming

Analysis of Algorithms Object-Oriented Programming

Software Engineering Local Area Network

Computer Networks

Contact this candidate