BIJAL PARIKH

acsfnu@r.postjobfree.com

Professional Summary

Over 7 years of experience in Analysis, Design, Development, Testing, Implementation and Support of IT systems.

Expertise in Oracle 9i/10g/11g/11gR2 and in developing packages, functions, procedures, triggers, clusters, views using SQL and PL/SQL.

Experience in Performance Analysis and SQL query tuning, reducing response time, while designing scalable applications from scratch and maintaining existing ones, using AWR, Explain Plan and OEM. Good knowledge of key Oracle performance-related features, such as Query Optimizer, Execution Plans, Hints, Indexes, Clusters, Partitioning,views.

Strong knowledge in Oracle cursor management and exception handling.

Proficient in data loading/extraction using SQL*Loader and Oracle utilities.

Worked on in design and deployment of Unix Shell Scripts.

Experience in Business Analysis, gathering of business requirements, functional and technical specification writing.

Skilled in gathering user requirements by performing gap analysis and translating them into functional specifications.

Performed various types of testing, such as functional, system, regression and user acceptance testing.

Experience in implementing software development standards, business and IT processes.

Experienced in Training, Documentation and Implementation in a business environment.

Knowledge in performing logical database backup and recovery using Oracle’s EXPORT/IMPORT.

Hard hand in interacting with business analysts and developers to analyze the user requirements, functional specifications and system specifications.

Proficient experience in working on conceptual, physical and logical data models using various Data Modeling tools like Erwin 3.5,4.0,4.1,7.1,7.2, Designer 2000, MS Visio.

Excellent analytical and interpersonal skills, oral and written Communication Skills.

Excellent skills in writing ad-hoc queries.

Education And Certification:

Masters of Computer Application and Information Technology

Bachelors of Computer Application and Information Technology

Business/Technology Skills:

Oracle 11gR2/11g/10g/9i/8i/7x, MS Access, TOAD, Forms 9i, Oracle Reports 9i, Crystal Report, PL/SQL Developer 5.1.3,Crystal Reports, Erwin 4.1.4, SQL, PL/SQL, C, C++, Java, Shell Scripting, Visual Basic 6.0, MS Office Suite, MS Visio, MS Project 2003,ASP.NET,My SQL, PVCS, MS VSS, CVS, SVN, Windows 9x/NT/2000/XP, UNIX IBM AIX 5.2.

Professional Experience

InterDigital, KOP, PA May’14 – July’15

Sr.System Engineer

InterDigital is a tech company focused on developing cutting-edge technologies of the future, long before they’re a reality. In fact, it’s a leading contributor to 4G development, and the engineers began working on it more than 10 years before it hit the market. In this American company worked on different internal projects (applications) like employee PTO application, Oracle financial application etc.

Responsibilities:

Working with oracle financial module; denormalized data and send information to big table in data warehouse through staging table.

Experience to work with Financial Application (in Oracle E-Business Suite) and work on different modules like payables, cost management (purchasing), spreadsheet, general ledger etc.

Implemented different functionality to support business needs for different modules and different data type combinations.

Created and supported existing procedures, functions, packages, collections, triggers, object types to implement complex business functionality.

Extensively worked on writing complex SQL queries (cursors, ref cursors, sub queries, correlated sub queries).

Extensively worked with business users and discuss functionality of the projects and developed it user friendly.

Responsible for the preparing documentation like functional design, Technical design, Unit test plan etc. for the CR and for the assignments.

Prepared entire flow for the financial module process while migrating to Oracle 12i.

Developed multiple reports for IT needs to identify and improve performance.

Participated in code walkthroughs and review sessions with the team.

Effectively documented and archived historical data for future auditing purposes.

Responsible for production support and troubleshooting production issues.

Tools And Technology:

Oracle 12i, TOAD 12.5, SQL*PLUS, SQL*Loader, Discoverer Reports, Microsoft Visio 2013.

Wells Fargo, Charlotte, NC March’12 - October’13

Sr.Oracle Developer

Wells Fargo is the fourth largest bank in the United States, at Wells people empowered to explore, grow, and achieve a full range of development opportunities. Development is a business imperative. Wells Fargo is one of the leading banks. In Wells worked on different project modules like; Support Request, Dialer Processes, Batch Processes, Call tracking Process etc. Got opportunity to work to send real time transactions to update client database thorough different channel input.

Responsibilities:

Created stored procedures, functions, packages, collections, triggers, object types to implement complex business functionality.

Data optimization, scrubbing and manipulation of staged data using PL/SQL packages.

Use of PL/SQL bulk collection and DML (insert/update/delete) methods.

Encapsulated error handling and use of autonomous transaction for logging.

Extensively used PL/SQL features like collections, nested table, Varray and Bulk collect for high performance of stored procedures

Created database objects such as tables, indexes, views, materialized views, triggers, sequences, synonyms, hints, etc.

Extensively worked on writing complex SQL queries (cursors, ref cursors, sub queries, correlated sub queries).

Provided support for multiple business groups (LOBs) and managed SDLC for multiple projects to satisfy business needs.

Extensively worked with business users and discuss functionality of the projects and developed it user friendly.

Participated in code walkthroughs and review sessions with the development team.

Worked with multiple vendors to facilitate integration of systems during merger.

Effectively documented and archived historical data for future auditing purposes.

Responsible for production support and troubleshooting production issues.

Took lead responsibility many times during the development process and guide other team members about the requirements and planning.

Tools And Technology:

Oracle 11g/10g, PL/SQL, SQL*PLUS, SQL*Loader, Clear Case, Subversion, WinSCP, Putty, XML, Erwin, Clear Quest.

Barnes and Noble, NY July’11– March’12

Sr.Oracle Developer

Barnes and Noble.com is the largest book retailer in the United States, operating mainly through its Barnes & Noble Booksellers chain of bookstores. Brand of electronic book reader which is based on android was developed by Barnes and Noble. The aim of the project was to Support the daily requirements for oracle data warehouse feeds and to create PL/SQL procedure for daily/weekly/monthly refresh jobs.

Responsibilities:

Created stored procedures, functions, packages, collections, triggers, object types to implement complex business functionality.

Data optimization, scrubbing and manipulation of staged data using PL/SQL packages.

Use of PL/SQL bulk collection and DML (insert/update/delete) methods.

Encapsulated error handling and use of autonomous transaction for logging.

Used UTL_FILE for exporting data and UTL_MAIL to generate E-mails.

Extensively used PL/SQL features like collections, nested table, Varray and Bulk collect for high performance of stored procedures

Provided support for multiple business groups and managed SDLC for multiple projects to satisfy business needs.

Suggested and implemented improvements to legacy systems.

Extensively worked with business users and created reports using Crystal reporting tool for evolving Business needs.

Involved in Extraction, Transformation, Loading data using Informatica.

Developed multiple reports for IT needs to identify and improve performance.

Responsible for SQL tuning using explain plan, tkprof utility, optimizer hints.

Involved in RDBMS design and developed ER-diagrams using Erwin.

Work experience in ODI for batch load processes.

Experience working with huge database size of 5 TB.

Tools And Technology:

Oracle 11gR2/10g, UNIX, SQL, PL/SQL, SQL*PLUS, SQL*Loader, TFS, Subversion, WinMerge, TOAD, XML, Erwin, Informatica, Crystal Report Clear Quest, Oracle Reports.

Infosoft Sollutions,Greensboro,NC July’10–June’11

Sr.Oracle Developer

Infosoft Sollutions delivers comprehensive cost control strategies to payers in the healthcare industry ensuring timely, accurate and fair payments for providers. The project focuses on reducing medical costs by paying claims according to contractual obligations, improving the accuracy of claims payment process and increasing the rate of auto-adjudication.

Responsibilities:

Understanding the Business process/requirement by interacting with business users for successful deployment.

Wrote DDL Scripts to create new database objects like tables, views, sequences, synonyms, and indexes.

Developed SQL Queries to fetch data from different tables using complex joins.

Created PL/SQL Packages, Procedures and Functions for implementing the business processes for claims adjudication.

Gathered Statistics and Analysed Tables and Indexes for Performance tuning.

Tuned performance of existing SQL statements and PL/SQL code by using different methods of performance tuning techniques like Explain Plan and Hints.

Developed Static & Dynamic (REF) Cursors, Records & Exception handlers.

Worked with large tables and created partitions for managing the large tables.

Created audit table to record the Updates and Inserts on the tables by creating database triggers.

Involved in loading data using Oracle SQL*Loader.

Writing small UNIX shell scripts for automating jobs.

Involved in creating data models and object models.

Tools And Technology:

UNIX, Windows XP, Oracle 10g, PL/SQL, Toad 8.5, SQL*Loader, SQL*PLUS

Kraft Foods Inc.,Chicago,IL November’09-June’10

Oracle Developer

Kraft Foods helps organizations simplify logistics and distribution needs and accelerates their time to market. It also supports physical warehouse and inventory storage for multiple retail chains in the Ohio and Illinois region. The project is unique in-house end-to-end supply chain management software complete with order, inventory and shipping management.

Responsibilities:

Understanding and Analysis of the requirement specifications of the client.

Designed and developed PL/SQL functions, stored procedures, cursors, packages, triggers.

Involved in writing complex queries to generate processes as per client request.

Created Sequences to generate unique numeric values.

Tuned complex SQL statements, complex joins co-related sub-queries which were taking too much time to run by using Explain Plan and Hints.

Used TOAD for creating PL/SQL and SQL Scripts to debug and test the code

Responsible for user acceptance test, post production support and train end users for effective usage of the software package.

Managing Knowledge transfer sessions for deployment and support resources.

Maintain current knowledge of data relationships and system interfaces.

Tools And Technology:

UNIX, Windows XP, Oracle 10g, PL/SQL, Toad 9.0, HP Quality Centre, Autosys Job Scheduler

ICICI Bank, Ahmedabad, India July’08 to October’09

Oracle Developer

The core banking solution from ICICI is an integrated solution that automates all aspects of core banking operations across entities, languages and currencies. The solution helps financial institutions to quickly introduce new products and efficiently manage changes in existing products.

Responsibilities

Extensively worked on requirement gathering, analysis, use case designing and testing related to General Banking.

Held regular meetings in the form of JAD sessions with the business sponsors, users, stake holders, system architects, developers, database developers, quality testers during the entire project to assure that the critical as well as the minute details of the project were discussed and issues were resolved beforehand.

Designed, created data entry screens to facilitate the business requirements.

Involved in creating unix shell scripting.

Change Identification for Bank Specific Products and Parameters for the general banking.

Developed user manuals, presentations and training manuals as per project specifications and timelines.

Worked in partnership with project team, functional team leads and functional end-users to identify and document business process improvement opportunities and complete the definition of requirements for system design, implementation & training.

Conducted technical/non-technical presentations to the management and training workshops for the clients.

Tools And Technology:

Oracle 10g, PL/SQL, Toad 9.0, Microsoft Visio, Windows NT 4.0, Erwin 4.1.4

Contact this candidate