SUMMARY

• Around 9 Years of Programming experience as an Oracle SQL/PL/SQL/ETL Developer in Analysis, Design, and Implementation of Business Applications in OLTP, Client/Server architecture and data warehouse applications.
• Strong Knowledge on oracle architecture and database design.
• Excellent working and conceptual knowledge of Oracle, PL/SQL, Developing Forms and Reports, C/C++, Java, UNIX and HTML.
• Experience in development of applications using Oracle 11g/10g/9i, SQL, PLSQL, Oracle Forms 10g/9i/6i, Reports 10g/9i/6i.
• Good Knowledge in ERWIN in developing logical and physical models.
• Good Experience in developing PL/SQL Stored Procedures, Functions, Packages, Database Triggers using features like Cursors Ref Cursors, Analytical Functions, Collections, Exception Handling.
• Extensive experience in analysis and design of database, database modelling, ER Diagrams, normalization.
• Tuned SQL queries using Explain Plan and performed refinement of the database design leading to significant improvement in system response time and efficiency.
• Expertise in loading data from legacy systems using SQL*Loader.
• Have in - depth knowledge in Data analysis, Data warehousing and ETL techniques, Business Objects, UNIX Shell Scripting, SQL, PL/SQL scripts.
• Worked with various performance tuning techniques using tools provided by Oracle like
• SQL*TRACE, TKPROF, HINTS, DBMS PROFILER, DBMS STATS etc.
• Used DBMS SCHEDULER to run jobs in parallel to improve time-constrained performance.
• Expert in SQL and Oracle PL/SQL languages.
• Used DBMS PROFILER package, which enables the collection of profiler (performance) data for performance improvement.
• Good understanding of Relational database design and developed various data models using ERWIN and Oracle Designer.
• Created various reports using oracle reports like matrix reports, matrix with group reports, and group above reports using Reports 9i/6i and designed user interfaces with Forms 6i.
• Extensively worked with third party database tools like TOAD & PL/SQL Developer.
• Experience in using oracle long data types like BLOB, CLOB
• Experience with software Development life cycle (SDLC) process performing detailed analysis, collecting requirements, documents requirements, coding and unit testing, integration and system testing.
• Good knowledge on MS-word, Excel, PowerPoint.
• Experience in writing Technical design documents and developing System and unit test documents.
• Ability to be an effective team player and work under severe time constraints.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
• Motivated self-starter with exceptional team building, leadership, and interpersonal skills. Ability to learn new tools, concepts and environments.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, UNIX Shell Scripts, JSP, C, C++, java, HTML, XML.

RDBMS: Oracle 11g/10g/9i, MS-SQL Server 2008/ 2014/2012 , Sybase, DB2 MS Access.:

Oracle Utilities: SQL*Plus, SQL*Loader, SQL developer 10g,11g,11g r2, TOAD 12c/ 11g/10g, Import, Export, Data Pump.

GUI Tools: OracleForms10g,9i,6i and Reports 10g,9i,6i, ERWIN, Team foundation server 12.5:

Servers: Windows server 2008 R2, Windows Server 2012, Enterprise Linux server R5.5

PROFESSIONAL EXPERIENCE

Confidential, Ashburn, VA

PL/SQL Developer / SQL Developer/ Analyst

Responsibilities:

• Developed Oracle PL/SQL Procedures, Functions, and Database Triggers and involved in creating and updating SQL Packages to process data coming from SQL Server 2012.
• Created SSIS packages to process the data and transfer the data from SQL server to Oracle PL/SQL server.
• Created SSAS packages by creating Cubes to report the weekly and monthly activities using SQL Jobs queue.
• Created SSRS packages for reporting purposes.
• Used Microsoft Visual Studio 2015 for code development and version merge.
• Used SQL Server 2012 for developing the backend activities such as procedures, functions, tables, indexes, constraints, jobs etc.
• Used SQL Developer Oracle 11g to create oracle tables, Functions, views, Indexes etc
• Used Microsoft File watcher to process the files on the server once we get the trigger from one server to another and process the data in VPrice and BMA projects.
• Extensively involved in team meetings, development, Production Support and Demos of the Project to higher management and clients.
• Created UNIX shell scripts for FTP batch jobs, creating SQL reports and email notifications.
• Extensively worked on performance tuning in both Oracle and SQL Server 2012 versions. Extensively worked with the Front end Java team to process the backend activities by using some front end objects.
• Extensively worked on Server jobs which run every Sunday to process the data and check the integrity of the data involving both the systems BMA and VPrice.

Environment: Oracle 11.2.0.3.0 - 64 bit Development, Microsoft SQL Server, Oracle reports 9i/10g, Linux Version 11.2.0.3.0. , SQL reporting SSAS, SSRS, SSIS packages, UNIX, Windows Server 2012, Visual Studio 2015.

Confidential, Seattle, WA

PL/SQL Developer / T-SQL Developer

Responsibilities:

• Customizing Microsoft’s Team Foundation Server files according to the company’s requirements.
• Customizing and generating multiple TFS reports to serve company needs.
• Testing multiple content controls that are created and incorporated into TFS work item types.
• Closely working with software developers to gather information about the application.
• Involved in daily stand-up meetings and weekly sprint meetings to discuss workflow and project specifications.
• Actively participated in weekly sprint meetings and daily standup meetings as part of agile methodology.
• Extensively worked in modification of UNIX shell scripts for scheduling cron jobs as per new design.
• Involved in writing database packages/procedures/functions & implementing conversion of the client’s billing system from one database structure to a new one with different functionality and database layout.
• Converted the billing system into a staging schema and from there using copy utility of Oracle moved to PROD database. Used PL/SQL extensively for this.
• Created/maintained snapshots, DBLinks for reporting servers.
• Used SQL Loader to load bulk data to tables.
• Used trello for tasks tracking and assignments for 3-week sprints.
• Extensively worked on bulk SQL scripts modification and testing on test servers.
• Involved in Database re-design and DB objects modification.
• Extensively worked on T-SQL scripts in conversion to Oracle scripts.
• Extensively created SQL Procedures, Functions, Types, Views, Indexes, and Constraints etc.

Environment: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64 bit Production, PL/SQL Release 11.2.0.3.0 - Production, "CORE 11.2.0.3.0 Production",TNS for Linux: Version 11.2.0.3.0 - Production, Trello, Microsoft Visual studio 2015 version 14.0 solution explorer, UNIX, web tools, windows server 2008R2, TOAD v.11.5.

Confidential, Camp hill, PA

PL/SQL Lead Developer

Responsibilities:

• Designed and developed Oracle PL/SQL Procedures, Functions, and Database Triggers and involved in creating and updating SQL Packages to meet business requirements.
• Conducting Daily scrum meetings and setting a deadline for the tasks and tracking the status.
• Conversion of some Stored Procedures, Views, functions, Tables to PL/SQL.
• Generated SQL and PL/SQL scripts to install create and drop database objects Including Tables, Views, Primary Keys, Indexes, Constraints, Sequences and Synonyms.
• Fixed data cloning issues by creating PL/SQL blocks.
• Extensively worked with the production support team for maintaining monthly and daily data runs by creating data scrubs.
• Extensively worked in the Decision Support team for immediate assistance when the project is in Production.
• Worked on PL/SQL program units to include DML, DDL statements using Dynamic SQL.
• Used Explain plan, TKPROF to gather the statistics along with an analysis command for performance tuning.
• Extensively worked on Explain Plans and various hints for Performance tuning.
• Created index function based and Normal indexes on the tables for faster retrieval of the data to enhance database performance.
• Wrote packages to fetch complex data from different tables using joins, sub queries and database links.
• Created procedures for retro enrollments and automated the script when needed.
• Extensively worked on JIRA bug tracker for production fixes for client needs.
• Extensively worked with finance team and infra team for monthly and daily EDI Runs and analyzed data as per their need in SOA database.
• Work extensively on insurance Industry standards 834-enrolment and 820-payment.

Environment: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64 bit Production, PL/SQL Release 11.2.0.3.0 - Production, "CORE 11.2.0.3.0 Production",TNS for Linux: Version 11.2.0.3.0 - Production, NLSRTL Version 11.2.0.3.0 - Production, JIRA bug tracker, TOAD v.11.5, Jira version v5.0.2#725-sha1:5735107

Confidential, Minneapolis, MN

PL/SQL Developer

Responsibilities:

• Designed and developed Oracle PL/SQL Procedures, Functions, and Database Triggers and involved in creating and updating SQL Packages to meet business requirements.
• Conversion of some Stored Procedures, Views, functions, Tables from T-SQL to PL/SQL.
• Generated SQL and PL/SQL scripts to install create and drop database objects including Tables, Views, Primary Keys, Indexes, Constraints, Sequences and Synonyms.
• Extensively worked with Data stage, Production Team for migrating data from SQL Server to Oracle Exadata box.
• Loaded data into oracle database from flat files using SQL*Loader.
• Worked on PL/SQL program units to include DML, DDL statements using Dynamic SQL.
• Used Explain plan, TKPROF to gather the statistics along with an analysis command for performance tuning.
• Extensively used Oracle reports to run week end reports.
• Extensively worked on Explain Plans and various hints for Performance tuning.

Environment: Oracle 11.2.0.3.0 - 64 bit Development, Microsoft SQL Server 2008 R2 (SP 2) - 10.50.4000.0 (X64), Oracle reports 9i/10g, Linux Version 11.2.0.3.0.