Developer Data
Resume:
Kinjal Desai
Cell: +1-201-***-****
Email:******.*@*******.***
Experience Summary
* ***** ** ********** ** new development and managing the production issues and enhancement new features based on requirements
Proficient in advance features of Oracle 11g for PL/SQL programming
Good understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, FACT& dimensions tables, physical & logical data modeling.
Proficient in navigating through the databases using TOAD, SQL Developer
Worked closely with the Business Analyst, Database and Data warehouse Architects in determining the exact business rules and functionalities required for the delivery of the work articles
Extensive development and administration experience on Oracle 11g/10g/9i, SQL, PL/SQL
Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors, and other database objects.
Experience with Oracle utilities like SQL*Loader, Export/Import and data pump
Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
Experience in all the phases of the project i.e. requirement gathering, analysis, design, development, testing, documentation and implementation of business centric software applications
Experience on shell scripting and Angular, Java script, HTML and Java
Use SCRUM for agile development and participated in team lead solutions, reviewing peer’s code for quality and completeness
Designed and coded application components in an agile environment utilizing a test driven development approach.
Provided programming estimates, identified potential problems and recommended alternative solutions.
Technical Certifications
Certification of Oracle Database 11g: SQL Fundamentals I
Certification of Oracle: Program with PL/SQL (PL/SQL Developer OCA)
Certification of Oracle Database 11g: Advanced PL/SQL (PL/SQL Developer OCP)
Certification of Oracle Database 11g: Oracle Database 11g: Administration I (Database 11g Administrator Certified Associate)
Technical Proficiencies
RDBMS : Oracle 11g/10g/9i, SQL Server
ETL Tools : Informatica PowerCenter 9.x, SSIS
Data Model Tools : Toad data modeler, Erwin, Navicat Database IDEs : Toad 9.x, SQL Developer, SQL Navigator Languages : SQL, PL/SQL, Shell Script, Java script, Visual Basic 6.0, COBOL
, Operating System : UNIX, Windows family
Other Tools : SQL*Loader, PVCS, SVN, MS Office
Professional Experience
Vixxo (Mind World LLC) Hartford, CT/ Baltimore MD
Oracle PL/SQL Developer Dec 2013 – Till Date
Responsibilities:
Involved in gathering and analyzing the requirements and preparing business rules.
Worked extensively in Oracle 11g, XML database
Developed Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules
Worked on Querying and manipulation of the content using XQuery
Developed PL/SQL and DB objects to provide the linking information in the form of XML’s
Tracing, troubleshooting with database performance and tuning issues
Fine-tuned SQL queries and views by passing hints and analyzing them using plan table
Involved in writing java scripts. Wrote Java Script to add the Functionalities to the web pages.
Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
Prepared Technical Design documents and Test cases
Planned the index rebuilding, index analyses and table analyses on periodical basis
Worked in Agile Software Development Methodologies Database : Oracle 11g
Tools : Toad, Git
Language : SQL, PL/SQL
Operating System : UNIX, Windows
EMC (Mind World LLC) South borough, MA
Oracle PL/SQL ETL Developer June 2013 – Dec 2013
Responsibilities:
Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin
Created, configured table spaces resized and added data files to existing table spaces
Created redo log files to accommodate database growth
Tracing, troubleshooting with database performance and tuning issues
Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions
Analyzing and validating database objects
Provided technical assistance to the testing team to understand and setup the testing scenarios and to execute technical intervention test cases
Managed high transaction databases including all database objects, triggers, procedures, user right, and functions
Fine-tuned SQL queries and views by passing hints and analyzing them using plan table
Developed Unix Shell Scripts to Schedule jobs in Crontab
Worked on DBMS Scheduler and Control-M for job scheduling.
Planned the index rebuilding, index analyses and table analyses on periodical basis
Developed Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules
Worked in Agile Software Development Methodologies Database : Oracle 11g
Tools : Toad, SQL Developer, SVN
Language : SQL, PL/SQL, Pearl script
Operating System : UNIX, Windows
Comsort – A Merck Co & Inc. (Mind World LLC) Hunt Valley, MD Oracle PL/SQL / ETL Developer June 2012 – June 2013 Responsibilities:
Analyze business requirements, technical specification, source repositories ETL mapping and process flow
Involved in the Data modelling based on the business requirement
Generated SQL and PL/SQL scripts to install create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms
On-going support, design and development of healthcare based data warehouse, data marts and online analytical applications
Fine-tuned SQL queries and views by passing hints and analyzing them using plan table
Planned the index rebuilding, index analyses and table analyses on periodical basis
Created partitioned tables for tuning a database
Prepared data Migration document for smooth transfer of project from development to testing environment and then to production environment
Developed Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules
Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements
Worked in Agile Software Development Methodologies Database : Oracle 11g
Tools : SQL Navigator 6.5, Navicat 1.0
Language : SQL, PL/SQL
Operating System : Windows
Location : Hunt Valley, MD
Covidien (Mind World LLC) Mansfield, MA
Oracle Developer Jan 2012 – June 2012
Responsibilities:
Maintained and updated database design schema
Created database objects like Tables, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
Performed SQL tuning by using Explain Plan and indexing.
Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities using SSIS packages and PL/SQL
Experience in optimizing performance of various long running queries and stored procedures using SQL Profiler and Database tuning wizard.
Generated SQL and PL/SQL scripts to install create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms
Planned the index rebuilding, index analyses and table analyses on periodical basis
Created partitioned tables for tuning a database
Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment Database : Oracle 10g, 11g, SQL Server 2005
Tools : SSIS
Language : SQL, PL/SQL
Operating System : UNIX
State Bank of India (C-EDGE) Mumbai, India
Oracle PL/SQL Developer Jun 2008 – Aug 2010
Responsibilities:
Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules
Optimized and modified the triggers, functions, procedures, user base data type
Developed Shell scripts and SQL control files to load data through SQL* Loader
Analyzed and computed statistics to improve response time for queries
Extensive experience in Database query tuning, Performance tuning of Reports
Planned the index rebuilding, index analyze and table analyze on periodical basis.
Preparing Unit test cases Sharing business knowledge and technical design/architecture with Build Team
Knowledge sharing with the other team
Databases : Oracle 9i, 10g
Tools : Toad 9.0, Sql Developer
Languages : SQL, PL/SQL, COBOL
Operating Systems : UNIX, Windows
C-EDGE Mumbai, India
Team Member (Developer) Jan 2008 – Jun 2008
Responsibilities:
Responsible for requirements gathering from Clients and implement the back end changes in existing product and in designing the database
Involved in Creation of tables, Portioning tables, Join conditions, correlated sub queries, Nested queries for the business application development.
Creating Stored Program Units in the Functions, Triggers and procedures for implementing complex database intensive business rules.
Wrote various validation queries for System test and UAT teams to validate the batch against business requirements.
Develop and support the system
Responsible for creating High Level Document and Detailed Level Document that highlight the code changes and enhancements for every release.
Managing code releases
Preparing Test cases for various Inputs
Database : Oracle 9i
Tools : SQL Developer
Languages : Visual Studio 2005
Operating System : Windows
Educational Qualification
Master of Computer Application, South Gujarat University, Surat, India. 2008
Bachelor of Computer Application, South Gujarat University, Surat, India. 2005
Contact this candidate