SUMMARY:

• 7 years of experience in Oracle database, SQL, PL/SQL, and SAS technologies involving database design, application development, implementation, quality testing, statistical analysis, and support.
• Involved in database design and data modeling to create ER diagram and database objects
• Experience of complete Software Development lifecycle SDLC process
• Experience in quality testing of data-warehouse objects, using a customized scripts based on in-house methodology.
• Experience in utilizing Bug tracking system JIRA, and co-coordinating with developers/managers and other QA members
• Proficient in writing stored and application procedures, packages, database triggers and functions using PL/SQL
• Experience in maintaining and developing database objects like tables, views, indexes, sequences, synonyms etc
• Experience in utilizing oracle analytical and decoding functions and dealing with multi-terabytes database
• Experience and knowledge of FTP transfer from UNIX to Windows and vice versa
• Developed Interactive User Interfaces using Forms 6i/9i and generated reports using Reports 6i
• Experience in writing Shell Korn, Bash, C and AWK scripts and have utilized crontab functionality
• Fundamental understanding of materialized views, replication, and external tables
• Experience utilizing dynamic SQL dbms sql, Execute Immediate functionality
• Developed SQL Loader control programs to transfer external data into staging tables. Written PL/SQL validation scripts to transfer clean data from staging tables to production tables
• Utilized oracle advance features like Bulk Bind Bulk collect, For all , Ref Cursor, and Index-By Tables.
• Generated Excel Reports using oracle supplied package UTL FILE for data analysis purpose
• Knowledge and experience of Data Analysis, Data Warehousing, and ETL Techniques
• Conceptual understanding of Data marts, OLAP, OLTP, STAR Schema, and Snowflake schema
• Expertise in Oracle 10g/9i/8i database server, forms 6i/9i and reports 6i/9i, and tools like SQL Plus, SQL Developer, TOAD, Data Loader, SQL Loader, and RapidSQL
• Experience and knowledge of Apex 3.0, HTML, CSS, and JavaScript
• Good understanding of data mining concepts, ETL processes, and data modeling concepts such as design of the dataflow, ER Diagrams, Normalization and Denormalization of tables
• Experience and knowledge of SAS statistical software, used SAS/BASE, SAS macros, SAS/GRAPH, SAS/STAT for data and statistical analysis
• Involved in unit testing, functional testing, system testing, data validation, and user acceptance testing
• Experience in tuning complex SQL statements using Explain plan and SQL trace
• Strong Inter-personal, analytical, and problem-solving skills with proven ability to deliver excellent results in competitive environment

Technical skill

Work Experience

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in designing, developing, and testing of PL/SQL stored procedures, packages and triggers.
• Developed complex SQL and PL/SQL queries.
• Created database objects like Tables, views, synonyms, Indexes.
• Used SQL Loader to load data from external system and developed PL/SQL programs to dump the data form staging tables into base tables.
• Extensively wrote SQL Queries Sub queries, correlated sub queries and Join conditions for generating various kinds of reports as per the user requirement.
• Involved in reports designing and developing. Involved in integrated reporting capability.
• Developed the Stored procedures using PL/ SQL Tables and records to generate the output in XML format.
• Involved in the data analysis and data discrepancy reduction for the source and target schemas.
• Scheduled the jobs using crontab in UNIX.
• Using UNIX shell scripting created batch jobs to create Index and Analyze tables once the Imports are done.
• Automating data loading, extraction, report generation using UNIX shell scripting.
• Involved in writing Oracle PL/SQL packages, functions, procedures, Korn Shell scripts that were used for staging, transformation and loading of the data into base tables.
• Provided support for the application database related issues.
• Involved in coding, debugging, and trouble-shooting.
• Involved in Data loading and data migration Used SQL Loader to load data from excel file into staging table and developed PL/SQL program to load data from staging table into base tables.
• Used Erwin for designing Database both logical and physical data modeling.
• TOAD, SQL Developer tools were used to develop programs and executing the queries.
• Developed forms using forms 6i based on business requirements.
• Worked with SQL Query performance issues. Used index logic to obtain the good performance.
• Involved in Installation and configuration of oracle 11g

Environment: Oracle 10/11g, Rapid SQL, Edit Plus, WinScp, SQL Plus, SQL, PL/SQL, UNIX HP , Shell Bash Script, AWK, SQL Loader, Windows XP, LINUX

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in designing, developing, and testing of PL/SQL stored procedures, packages and triggers.
• Developed complex SQL and PL/SQL queries.
• Created database objects like Tables, views, synonyms, Indexes.
• Used SQL Loader to load data from external system and developed PL/SQL programs to dump the data form staging tables into base tables.
• Extensively wrote SQL Queries Sub queries, correlated sub queries and Join conditions for generating various kinds of reports as per the user requirement.
• Designed star schema using dimensional modeling and created fact tables and dimensional tables. Used Erwin for Logical and Physical database Modeling.
• Installation and configuration of Informatica Power Mart
• Used Informatica Designer Power Mart to create complex Mappings
• Created mappings using various Transformations like Source Qualifier, aggregator, expression, filter, joiner, lookup, update strategy, sequence generator and prepared Documentation for the Mappings
• Developer several Informatica mappings that transfers data from source the Data Mart.
• Created Source definitions, Source Tables, Target definitions and Target Tables.
• Used Informatica Server Manager to create sessions/ batches to run with the logic embedded in the mappings.
• Tuning Informatica session parameters for performance and running them.
• Prepared documentation of Informatica ETL implementation.
• Involved in reports designing and developing. Involved in integrated reporting capability.
• Developed various reports using oracle reports builder 6i and upgrades the existing reports .
• Developed the Stored procedures using PL/ SQL Tables and records to generate the output in XML format.
• Involved in the data analysis and data discrepancy reduction for the source and target schemas.
• Scheduled the jobs using crontab in UNIX.
• Using UNIX shell scripting created batch jobs to create Index and Analyze tables once the Imports are done.
• Automating data loading, extraction, report generation using UNIX shell scripting.
• Involved in writing Oracle PL/SQL packages, functions, procedures, Korn Shell scripts that were used for staging, transformation and loading of the data into base tables.
• Provided support for the application database related issues.
• Involved in coding, debugging, and trouble-shooting.
• Involved in Data loading and data migration Used SQL Loader to load data from excel file into staging table and developed PL/SQL program to load data from staging table into base tables.
• Used Erwin for designing Database both logical and physical data modeling.
• TOAD, SQL Developer tools were used to develop programs and executing the queries.
• Developed forms using forms 6i based on business requirements.
• Worked with SQL Query performance issues. Used index logic to obtain the good performance.
• Involved in the monitoring of database performance in Enterprise Manger console.
• Implemented server side rest full Webservices for external vendors to access our applications.
• Involved in Installation and configuration of oracle 11g

Environment: Oracle 10/11g, Rapid SQL, Edit Plus, Perforce, WinScp, SQL Plus, SQL, PL/SQL, UNIX HP , Shell Bash Script, AWK, SQL Loader, Windows XP, LINUX, SharePoint, Erwin, Informatica Power Center 9.1

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Monitoring existing SQL code and performance tuning and monitoring if necessary.
• Extensively involved in new systems development with Oracle 9i.
• Supported direct mail campaign strategies. Provided segmented data to end-users.
• Interact with business analysts to develop modeling techniques and re-structuring strategies.
• Involved in Unit Testing of each module.
• Created Forms and Reports using Forms 9i and Reports 9i respectively.
• Designed the Entity-Relationship model and normalized database.
• Documentation of all modules for user level and system level maintenance.
• Designed and developed a custom database Tables, Views, Functions, Procedures, Packages
• Read data from flat files to oracle tables using SQL loader.
• Prepared the detailed design document, test cases and use cases for business requirements
• Extraction, Transformation and Load was performed using Informatica Power Center to build the data warehouse.
• Extensively used the Enterprise Resource Planning modules ERP .
• Involved in large and complex data conversion and data modelling project from the existing system to the new system which did help End-Users
• Loaded data into warehouse using PL/SQL Scripts, ETL tools, SQL Loader.
• Used high system securities such as unique passwords, vpn etc.
• Measuring and reporting response rates using Excel, PL/SQL scripts.
• Involved in the production support and solved the tickets that are raised by the end users.
• Developed Unix Shell scripts to automate repetitive database processes
• Automated FTP TCP/IP process
• Written add-in and macros for Business Objects reports.

Environment: Oracle 9i, Forms 9i, Reports 9i, Informatica 7.1, UNIX, PL/SQL, SQL PLUS, SQL, TOAD, C, SQL Loader, Erwin, Business Objects

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Studied user requirements and functional specifications.
• Converted User Requirements into formal Functional specification and Interfacing with client.
• Designed, Partitioned, Developed and Maintained the database.

• Worked to define the project implementation strategies.
• Developed Entity Relationship diagrams/Dimensional Diagrams for business requirements using ERWIN.
• Designed and developed Oracle Forms Reports using Forms10g and Reports 10g. Including Forms based on stored procedures.
• Developed ETL's for Data Extraction, Data Mapping and data Conversion using SQL, PL/SQL and various shell scripts in Data stage.
• Involved in writing Oracle PL/SQL functions, procedures and packages in Oracle RAC environment.
• Written Bash Shell scripts that were used for staging, transformation and loading of the data into base tables.
• Used CRONJOB for job scheduling on UNIX as well as tools like Autosys to run regular day to day administration scripts and setting up batch scripts.
• Developed the stored procedures using PL/SQL Tables and records to generate the output in XML format and pull data from Web services and from XML format and parse it and load it into tables.
• Enhancing the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
• Used Bulk processing for performance enhancement.
• Created UNIX shell scripts using SQL Loader, SQL Plus and PL/SQL programs that run as nightly interfaces.
• Worked on generating EDI for STA, ASN segments and few custom based invoices belonged to Invoice, Status and Entry and Generic EDI for most of the customers for the EMS application.
• Written shell scripts and executed them as Cron jobs on UNIX.
• Was responsible for development and testing of conversion programs for importing data from text files into Oracle database utilizing SQL Loader.
• Developed Webservices using .Net technology

Environment: Oracle 10g/11g, PL/SQL, SQL Plus, Erwin 7.3,SQL Navigator, XML ,Shell Scripting, SQL Loader, Shell Scripting, SQL developer, Data stage, Reports 10g/6i,CSS, DBMS JOB,UTL FILE,UNIX,

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Created the database Objects such as Tables, Views, Indexes, constraints .
• Involved in Development, Testing and Maintenance of the System
• Developed the forms for the application and developed Procedures and functions at application level.
• Created the Stored Procedures, functions and Packages using PL/SQL.
• Oracle PL/SQL functions, procedures, Korn Shell scripts were used for staging, transformation and loading of the data into base tables
• Performed data loading using Data Loader to the data into staging tables.
• Created PL/SQL procedures in order to dump the data from staging tables to base tables
• Scheduled the jobs using crontab ,in UNIX.
• Database backup and recovery using Export/ Import, Hot or Cold backups or through RMAN
• Monitoring alert logs resolving problems, if any
• Writing database backup scripts.
• Restoring and Recovering Database while crashes.
• ISBS Installation, Setup, up gradation by installing patches
• Conduction of training programs for bank 's DBA
• Responsible for developing reports as per Customers order using reports
• Involved in developing front end screens using forms 6i and generated reports using reports 6i.
• Created Editors, Created List of Values and Record Groups in Oracle Forms 6i.
• Developed Customer transaction upload module to load data into database from flat file with business validation Package, Procedures Triggers are used .
• Worked closely with quality assurance and development teams to clarify and understand the functionality to resolve issues and provide feedback in terms of the test matrices and to nail down the bugs.
• Involved during User Acceptance Testing of the application.

Environment: Oracle11g, Forms 6i, Reports 6i, TOAD, Data Loader, AUTOSYS ,SQL Plus, PL/SQL, Windows NT server, UNIX.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in development and testing of oracle back-end objects like database triggers, stored procedures.
• Loading data through SQL Loader and UTL FILE.
• Assisting in day-to-day System Administration activities like CRON scheduling jobs
• Contributed to tuning the SQL queries, datamarts, create database objects and optimally set storage parameters for tables and indexes.
• Extensively used the .NET framework
• Developed the server pages with the Visual Basic and later updated to ASP.

• Involved in writing java scripts, struts etc
• Loaded data into warehouse using PL/SQL Scripts, ETL tools.

• Testing and maintenance of various application modules
• Support from offshore for implementation.

Environment: Oracle 8i, C/C , Java, VB, ASP, UNIX Shell Scripts, SQL, PL/SQL.