Summary:

• 7 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
• 3 Years' experience in Production Support
• Good experience and knowledge in writing AUTOSYS JIL scripts for job scheduling
• Hands on experience in Oracle 11g, 10g, 9i and 8.x. on Windows and Unix based environments.
• Good experience in creating frame works and reports with Oracle Forms and Reports 11g
• 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 knowledge in Enterprise Data management softwares like Golden Source, Eagle Pace.
• Good experience in extraction and loading data into oracle tables from other databases like SQL SERVER.
• Good experience in Oracle Discoverer and XML Publisher.
• Hands on experience in Oracle reports 11g ,PERL ,Unix scripting
• 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 and Agile Methodology.

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.6, Oracle warehouse builder.
• Data Modeling: Erwin, Power Designer 15.0
• Other Technologies: SQL Loader, TOAD, SQL Navigator, Subversion SVN , COGNOS 8.0

Confidential

Sr. Oracle Developer/Analyst

Working in Asset Management team , Gather and maintain account, position, transaction valuation of securities and other information of various holdings after the trade is made from Enterprise data management systems like Golden Source , vendor feeds and makes it available to downstream consumers as well as to online users. Data is provided through feeds that are pushed to downstream systems by consuming applications and online screens within Golden Source data warehouse. Extract the holdings information from data management systems to feed the into data warehouse for analysis. Other responsibilities include:

• Building and maintaining data marts for various business applications reporting services, accounting systems to obviate load on the centralized data warehouse Vision .
• Extract data from various sources golden source data warehouse to push data into data marts for various accounting and holdings systems and Informatica.
• Create Logical and Physical data models for the data marts.
• Provide data for the Reporting servers by creating REF CURSORS
• Tuning applications using various techniques like Explain Plan , SQL TRACE , TKPROF utilities for better performance and faster access of data
• Create views to generate ad-hoc reports for internal use.
• Create PLSQL programs procedures, packages and other database objects to feed data for reporting systems.
• Create customized frame works and reports as per the business like transactional ,holdings needs using Oracle Forms and Reporting services as per application standards R12-EBS .
• Developed reports in Discoverer 10g and created various business areas, user views, custom folders and joins for reporting.
• Creating jobs and scheduling using DBMS Job scheduler
• Analyze and interpret AWR reports to propose changes to the database objects for better performance.
• Create test data and perform unit testing.
• Extract change data capture CDC of various account portfolios and load fact and dimension tables accordingly.
• Provide production support like monitor jobs, check the log files /error tables for error fixes.
• Validated and reconciled the data to the month end reports given by the business.
• Write plsql code wrapper scripts in Unix shell for deploying in various environments.
• Working in a fast paced agile environment.

ENVIRONMENT: ORACLE 10g/11g , TOAD, SYBASE POWER DESIGNER 15.0, OEM 11g ,Oracle Forms/Reports 11g , SQL DEVELOPER, Golden Source 8.4, CVS -1.11 revision control , Informatica 8.6 ,HP-UX 11.3,WINDOWS XP, Oracle R12-EBS , Discoverer 10g

Confidential

Sr. Oracle Developer/Analyst

• Worked as a Sr. Oracle developer developing Database Applications for Confidential 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
• Performed several ETL Data Migration activities using SQL and PL/SQL
• Extensively used of PL/SQL to create Stored Procedures, Functions, Packages, triggers.. etc for various business requirements given.
• Developed SQL Loader scripts for loading flat files and excel sheets into Oracle Staging area.
• Applied various 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.
• Tuning SQL scripts for faster execution using Explain Plan, SQL Trace and TKPROF utilities.
• Created JIL scripts and running jobs on AUTOSYS
• Created UNIX scripts for batch processing.
• Created CRON job scripts for job scheduling purpose.
• Validated and reconciled the data to the month end reports given by the business.
• Created simple, complex and materialized views for better performance and security
• Developed procedures using Dynamic SQL and built-in packages like UTL FILE.
• Created 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.
• Worked on reverse and forward engineering process to create DDL scripts for implementing data model changes. Used SYSBASE POWER DESIGNER for this purpose
• Managed object privileges and perform data masking on sensitive data for implementing standard security features.
• Managing and tracking service requests through Oracle Install Base.
• Analyzed audit logs and set audit trails to monitor the activity on the databases.
• Call JSP's from PL/SQL to support the java based loan application system .
• Involved in Testing Both Unit and Integration Level and Implementation.
• Involved in documentation and provided on-site production support.
• Involve in enhancement of existing Data flow diagrams, ER Diagrams.
• Created ad hoc reports using oracle reports 6i
• Analyzed logic in DATASTAGE and reproduced it in PLSQL
• Collected user requirements and preparing the specifications for program units.
• Provided on call production support fixing issues occurred during extractions.
• 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, Oracle reports 6i

Confidential

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.
• 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.
• Call Java API's in PLSQL to extract information of change data capture of loan information.
• Managing object privileges and perform data masking on sensitive data for implementing standard security features.
• Developed reports in Discoverer 9i and created various business areas, user views, custom folders.
• Performed Data migrations from DB2 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

Confidential

Database Developer

• Create simple, complex and materialized views for better performance and security.
• Extensively used PERL Scripts to generate error log files.
• Developed and Debugged PL/SQL packages, Procedures and Functions for implementing various
• Responsible for validating data for the reports given by business.
• Developed SQLLOADER scripts to load data from Flat files to registration repository tables
• 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.
• Business applications.
• 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

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.
• 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