More than seven years of IT Experience as Oracle Developer for System Analysis, Designing, Testing Development & Support of Oracle 8i, 9i, 10g & 11g in Production, Staging, Development environments.
Experience in logistics, health and telecom domain.
Expert in creating SQL Queries, packages, function, stored procedure, cursors, and triggers.
Created database objects like views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer and Toad.
Proficient in advance features of Oracle 11g for PL/SQL programming like Using Bulk Bind, Ref. Cursors, Varrays, Nested tables .
Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, TKPROF, Explain Plan, DBMS_PROFILER.
Strong knowledge in Oracle utilities like SQL*Loader, Export/Import and Data Pump.
Extensively used package like DBMS_STATS, UTL_FILE,DBMS_SCHEDULER and UTL_MAIL.
Hands on experience with Crontab in UNIX environment for scheduling routine tasks.
Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.
Extensively used Cubes & Rollups for making cross tabular reports.
Strong knowledge of Star Schema, Snow Flake Schema, Dimension and Fact table.
Expertise in handling errors using Exceptions.
Experience in Portioning the large size tables.
Experience in working high transacted OLTP systems.
Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.
Strong interpersonal and communication skills in dealing with customers.
SKILL & TECH MATRIX
LINUX, Sun Solaris 5.10/5.9, HP-UX 11i 3/11i 2, IBM AIX 5.2/5.3, Windows 7/XP
SQL, PL/SQL, UNIX shell Scripting
Oracle 11g/10g/9i, MS SQL Server 2008/2005,
SQL*PLUS, TOAD 9.6/9.5, SQL Developer, Erwin 8,VI Editor, SVN
SQL Loader, Export/Import, Data pump, Explain Plan
System Testing, Functional Testing, Unit Testing, System Integration Testing (SIT), User Acceptance
Other Tools & Web Application
Testing (UAT), Test Plan, Test Scripts and Test Cases
HTML 5, XML 1.1, UML 2.3, Filezilla 0.9.40, SFTP 6, WinSCP 5.1,
Automation Job/Batch Scheduling Tools
Project Management Tools
Autosys 11.3, Cron Jobs
PM Tools: MS Project 2013,
Rally methodologies: SDLC & AGILE
Modeling Tools: MS Visio 2010, MS Office 2010
ARI Logistics, Birmingham, AL May’ 15 to current.
Oracle PL/SQL Developer
Description: In ARI Logistics our project was Customer care Service Representation Application, basically our company act as a intermediate between garage and clients, we track all the information about transportation vehicle and if there are any breakdowns we intimate to clients through our CSR service, for this service we have created the internal application to collect all the information.
Worked to load OLTP data into the Staging Area and Data Warehouse using transformation.
Made structural changes to database objects using Oracle tools like SQL*Plus and TOAD.
Wrote complex SQL queries, Sub queries and nested loops for faster data retrievals.
Extensively used cursors, sequences, indexes in the procedures according to the requirement.
Involved in Performance Tuning for the SQL, PL/SQL scripts.
Extensive Knowledge and working of Bulk Collect and Bulk Binding for data retrieval.
Used various Shell Scripts and Scheduled jobs on Crontab in UNIX environment on a routine basis.
Modify and made tables for the loading of data from different sources using SQL*loader.
Used exception methods with pragma exception_init to associate customized exception names.
Handled XML Files for data loading purposes.
Used UTL_file package for automated ETL processes.
Used APEX to develop end to end Web Application Development.
Organized and managed routine jobs using packages like DBMS_SCHEDULER to schedule tasks.
Involved in the designing of databases architecture and developed the ER Diagrams with ERWIN.
Created B-tree, Bitmap indexes, Partition table for enhancing the performance.
Used Hints and Generate Statistics command to enhance the performance.
Environment: UNIX, Oracle, PL/SQL, SQL*PLUS, SQL Developer, Toad, IBM AIX, IBM RUP, HPQC, WinCVS, WinSCP, APEX, Data Stage.
IMS Health, Collegeville, PA March’ 14 to April’ 15.
Oracle PL/SQL Developer
Controlled Substance Rating
Description: This System handled patient data to send alert to different stake holders to prevent misuse of the medical prescription throughout US, across all pharmacy outlet, prescriber, service providers, warehouse storages to catch hold of any illegal practices at different level of security. Helped in the maintenance and automation of the daily and monthly refresh, populated the data mart for the system to generate SAS/Micro Strategy reports on top of the main SRW warehouse.
Involved in System Analysis, Design, Coding, Data Conversion, Development and Implementation.
Modified and created tables, synonyms, sequences, views, stored procedures and triggers.
Ensured conformance to code standards and documentation requirements.
Fixed performance issues and bugs with packages and stored procedures using DBMS_PROFILER.
Performed Unit Testing and ensured all the exceptions are handled according to the business logic.
Scrutinize performance of long running scripts Using AWR reports, Explain Plan, SQL Trace, TKPROF.
Loaded flat file using SQL*LOADER into database.
Used TOAD for querying and debugging application.
Written Cursors and REF Cursors for transaction processing.
Implemented database triggers based on the business rules and requirements.
Wrote PL/SQL Wrapper for maintaining data & code security.
Environment: UNIX, Informatica 9.3.0, Oracle 11g, SQL*Plus, Sun Solaris 10, Oracle Forms and Reports, HTML, MS Visio, Data Stage.
Reliance Industries Ltd. Gujarat, India July’ 12–Feb’ 14
Project: ERP System for Engineering Services Department
Description: Our team developed ERP system for the department. The primary aim of the project is to develop, purchase, inventory and quality control modules under ERP system. The project was to group data in the financial department to generate reports for different categories
Developed Web based User Interface using ASP.NET, C#.
Implementing Web applications using ASP and setting up an ODBC data source and used ADO and ADO.NET as data access technology.
Developed Custom Controls for Windows Forms and generating Reports.
Used XML extensively for data transfer across the components.
Created Tables, Indexes, Views, Rules and Synonyms.
Generated various types of reports by using reports builder
Generated specific reports using crystal reports
ENVIRONMENT:Oracle9i, ASP 3.0, Java Script, VBScript, C#, ASP.NET 2.0, ADO.NET 2.0, Visual
Studio.NET, PL/SQL, Windows 2000/XP, IIS
BhartiAirtel, Chennai,India Feb’ 09–June’ 12
Position: SQL Developer
Description: Bharti Airtel Ltd is one of Asia's leading telecommunications service providers. The Company is India's largest integrated telecom company in terms of customer base and offers Mobile Services. And our project is to write the SQL queries for their requirements.
Created Database objects - Tables, Views, and Functions and developed Procedures for implementing application functionality at the database side for performance improvement
Extensively used joins and sub queries to simplify complex queries involving multiple tables.
Created complex T-SQL Queries, Stored Procedures and Functions to support efficient data storage and manipulation.
Have a very Good Experience with all the Control Flow and Data Flow tasks in SSIS for ETL
Created reports and performed all Administrative activities. Also Installed and maintained SQL Server Reporting Services (SSRS) 2005
Extensively used SQL Server Reporting Services to generate various types of reports
Created ad-hoc reports for business users using SSRS using report builder
Managed reports using Report Manager after deploying the reports to the report server
Scheduled jobs for backup, and created alerts for error reporting
Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
Documented all processes involved in maintaining the database for future reference
SQL Server 2005 SSIS, SSRS, VBScript, T-SQL.