Summary:

• 8+ Years in IT filed writing data base application-using PL/SQL, which includes analysis, design, development, implementation and maintenance of application software in a client/server environment.
• Solid experience in writing SQL queries and using tools like SQL LOADER, EXPORT and IMPORT for data loading.
• 4+ years experience in writing Unix shell scripts for job scheduling, and wrapper utilities and good knowledge in PERL scripting
• 2+ experience e in using data model tools like SYSBASE POWER DESIGNER, ERWIN
• 3+ Years experience in performance tuning
• Good experience and knowledge in writing AUTOSYS JIL scripts for job scheduling
• Hands on experience in Oracle 11g, 10g, 9i and 8.x.
• Good knowledge in data warehousing concepts like star schema, snow flake schema, fact tables, dimensions tables..Etc.
• Good Knowledge in extracting information from Data warehouse using PLSQL API, SQL data mining functions.
• Good experience in extraction and loading data into oracle tables from other databases like SQL SERVER.
• Involve in Testing (Both Unit and Integration Level) and Implementation.
• Good experience in production support and supporting front-end java applications.
• Good knowledge in Oracle SOA technologies and Oracle Service Bus
• Good team player and Good experience in Software Development Lifecycle and adept in software Coding Standards.

Professional Experience:

PL/SQL and SQL:

• Develop database applications in PLSQL for ODS systems which host the back end applications for client’s from various domains like Finance, Marketing and Technical.
• Develop Complex SQL queries to generate various kinds of reports for sales and services team
• Extensive use of various API’s to call JSP’s from PL/SQL to support client’s Web

Services/Applications.

• Extensive use of External tables and tools like SQL loader to load data into oracle tables from flat files.
• Implement and follow best practices while coding

TUNING:

• Identify Various Performance bottle necks/issues at database level using statistics API’s like AWR, ADDM, OPTIMIZER STATISTICS and suggest necessary steps to improve the performance.
• Extensive Use various application tracing tools and API’s like TKPROF, SQL TRACE, DBMS_PROFILER to perform end to end application tracing

Data Modeling:

• Develop logical and physical data models and data flows using SYBASE POWER DESIGNER for Client’s database applications
• Extensive use of tools like POWER DESIGNER VIEWER to determine the data flows Use of POWER DESIGNER in forward and reverse engineering following corporate naming conventions or standards.

Scripting:

• Develop scripts in UNIX for deployments of database objects in various environments.
• Developed UNIX script to load oracle tables from a file located on the server
• Created JIL scripts in AUTOSYS for job scheduling.
• Created DBMS_SCHEDULER scripts for scheduling jobs in GRID control

Other:

• Extensive use of version control software like Subversion (SVN) for code base maintenance.
• Extensive use of tools like JIRA for issue tracking

Skills Summary:
Oracle Platform and Architecture: Oracle SOA 11g, 10g, 9i and 8i, Oracle Web Center/Portal/ADF
Databases: Oracle DB 8i, 9i, 10g, 11g, SQL Server 7.5, 2000, DB2 v9.7
WAS Platform: Oracle OSB/Web Logic Mediator
Programming Languages: SQL, PL/SQL, C, C++, PRO* C
Web Technologies: HTML, DHTML, XML, XSD, SOAP, WSDL, Web services.
GUI Tools: Forms 3.0/5.0/6i
Performance/Monitoring: OEM GRID, SOA management pack

• Hardware &Operating Systems: Windows NT/2000/2003, IBM AIX/Power System/I, XP series HP-UX 11.11,LINUX, Sun/Solaris, AS/400
• ETL tools: Informatica 8.1,Oracle warehouse builder.
• Data Modeling: Erwin, Power Designer 15.0
• Other Technologies: SQL Loader, TOAD, SQL Navigator, Subversion (SVN)

Project History:
Confidential,IA Aug’ 11 – NOV ‘12
Sr. Oracle Developer/Analyst

Working as a Sr. Oracle developer developing Database Applications for Home Equity Loans to expand the business lines and loans that can be originated within the Current loan fulfillment system. This will support the simultaneous closing process to allow the first mortgage to be processed on current Loan Fulfillment System and the second mortgage (whether identified at origination or as a late add) to be processed on ACAPS (Legacy Loan Fulfillment System). With this capability, we support identifying a second mortgage financed through WF Home Equity on current system capturing minimal data on the second mortgage and sending the data to ACAPS. Other job responsibilities include

• Perform several ETL (Data Migration) activities using SQL and PL/SQL
• Extensive use of PL/SQL to create Stored Procedures, Functions, and Packages for various business requirements given.
• Develop SQL Loader scripts for loading flat files and excel sheets into Oracle Staging area.
• Apply various advanced techniques like COLLECTIONS, DYNAMIC SQL, REF CURSORS, FORALL, BULK COLLECT for better performance of the code
• Apply table partitions for faster access of data and increase performance.
• Tuning SQL scripts for faster execution using Explain Plan, SQL Trace and TKPROF utilities.
• Responsible for creating JIL scripts and running jobs on AUTOSYS
• Responsible for creating UNIX scripts for batch processing.
• Responsible for validating and reconciling the data to the month end reports given by the business.
• Create simple, complex and materialized views for better performance and security
• Develop procedures using Dynamic SQL and built-in packages like UTL_FILE.
• Create XML files using packages like DBMS_XMLGEN
• Use built in packages like DBMS_AQDM and DBMS_AQ for advanced queuing process
• Use PLSQL packages like UTL_HTTP to call web services.
• Work on reverse and forward engineering process to create DDL scripts for implementing data model changes. Used SYSBASE POWER DESIGNER for this purpose
• Call JSP’s from PL/SQL to support the java based loan application system .
• Involve in Testing (Both Unit and Integration Level) and Implementation.
• Responsible for documentation and provided on-site production support.
• Involve in enhancement of existing Data flow diagrams, ER Diagrams.
• Analyzed logic in DATASTAGE and reproduced it in PLSQL
• Collecting user requirements and preparing the specifications for program units.
• Created simple, complex and materialized views for better performance and security.
• Created Test Data for testing procedures and functions.

ENVIRONMENT: ORACLE (10g/11g), TOAD, SYBASE POWER DESIGNER 15.0, OEM (11g)
SQL DEVELOPER, AUTOSYS, Apache Subversion SVN 1.6, DATA STAGE 7.5
7.5,HP-UX 11.3,WINDOWS XP

Confidential,Addison, IL Dec ‘10 - Jun ‘11
Sr. Database Analyst

Responsible for developing Database Application for order management and order tracking. This system allows users to run complex reports and data feeds off the high volume Data warehouse that gets populated on hourly basis. Also responsible for database applications tuning to improve the performance of the applications implemented. Other responsibilities include

• Developed/Scheduled Scripts to extract the data from legacy databases which include SQL Server and Oracle 9i using DB Links.
• Responsible for validating and reconciling the data to the month end reports given by the business.
• Extensively used SQL Loader for loading flat files and excel sheets into Oracle Staging area.
• Responsible for creating/modifying tables and views and granting privileges on the schema objects as per the business and technical requirements.
• Developed several SQL Scripts for reconciling the transactional data.
• Applied several Joins and Filters on various tables and views to analyze and validate data.
• Applied Optimization techniques for fine tuning SQL queries.
• Tuning SQL scripts for faster execution using Explain Plan, SQL Trace and TKPROF utilities.
• Developed and Debugged PL/SQL packages, Procedures and Functions for implementing various Business rules.
• Used advanced techniques like COLLECTIONS, DYNAMIC SQL, REF CURSORS, FORALL, BULK COLLECT for better performance of the code
• Applied table partitions for faster access of data and increase performance.
• Embedded various Data Transformation/Mapping rules using PL/SQL.
• Performed several ETL (Data Migration) activities using SQL and PL/SQL.
• Use data model tools like Sybase power designer to implements DDL changes to the model
• Extensively used PERL Scripts to generate Control files and BDC error log files.
• Performed Data extractions from legacy systems (Pro* C) and load into oracle systems.
• Performed Data migrations from DB2,SQL SERVER to Oracle database
• Reconciled the data in all the systems. Generated pre load and post load reconciliation reports using PL/SQL.
• Documented ETL Procedures and core functional areas for future Re-Use

ENVIRONMENT: ORACLE (9i/10g), TOAD, TOAD DATA MODELLER, WINDOWS XP
SQL DEVELOPER, COGNOS 8.0,HP-UX 11.3,DB2, MS SQL SERVER 10.5

Confidential,Database Developer May ’09- Oct ‘10

Responsible for developing Database Applications for Device management purposes (for registration) which helps the users for better visibility of data which is used for generating various reports and analysis. Other responsibilities include

• Developed SQLLOADER scripts to load data from Flat files to registration repository tables
• Responsible for validating data for the reports given by business.
• Developed and Debugged PL/SQL packages, Procedures and Functions for implementing various

Business applications.

• Extensively used PERL Scripts to generate error log files.
• Create simple, complex and materialized views for better performance and security.
• Performed several ETL (Data Migration) activities using SQL and PL/SQL.
• Created Test Data for testing procedures and functions.
• Responsible for creating UNIX scripts for batch processing.

ENVIRONMENT: ORACLE (9i), TOAD, SQL DEVELOPER, HP-UX 10.0,WINDOWS XP

Confidential,India. Aug ’04- May’07
Oracle Developer
Project involved redesign the existing database and develop new programs and edit the existing programs. Involved in ISTAR (Issue system tracking and resolution). This is an internal database used by analysts to track customer impacting incidents in a single repository. Other responsibilities include :

• Developed Procedures & Functions to check validity & integrity of data.
• Create views to extract data from base tables & publish the data to the end users.
• Used Built-in Packages provided by oracle for debugging.
• Reviewing / Testing Procedures & Functions developed by the team members.
• Creating SQL Scripts to monitor the discrepancy database and resolve the discrepancies.
• Developed/Modified Shell scripts to regulate batch jobs.
• Creating test data and load it into database to verify the functionality of procedure & functions.
• Migrated the data from external files into Database tables using SQL *Loader.
• Extensively involved in performance and tuning of all SQL and PL/SQL code.
• Wrote Procedures, Functions and SQL Loader scripts.
• Developed Database objects like Views, Materialized Views, Indexes, Sequences, and Synonyms.
• Involved in Designing and development of Enquiry & Application submission modules
• Using oracle Forms and generated custom reports.
• Created Database Triggers to populate tables for Reference data and Exposure data.
• Created PL/SQL Packages for easier application design and improved Performance

ENVIRONMENT: ORACLE (9i), TOAD, SQL DEVELOPER, HP-UX 11.3,WINDOWS XP

Education: B E in Instrumentation and Control Engineering
M.S Electrical and Computer Engineering