Experience Summary

• Over 7+ years of experience in the IT industry, involved in analysis, design, development, testing, Implementation & maintenance of databases in Client/Server and Internet/Intranet environments.
• Well versed with Software Development Life Cycle (SDLC)
• Strong development and support knowledge on Oracle, SQL, PL/SQL queries programming and creating objects such as Stored procedures, packages, functions, triggers, tables, and views
• Experience in Oracle database and database structures
• Have good working experience with ETL
• Experience in SQL*loader, UTL_FILE, Import and Export utilities and UNIX Shell scripting.
• Expertise in using tools such as TOAD, PL/SQL Developer, and SQL*Plus.
• Hands on experience in writing, maintaining, testing and debugging code in applicable programming languages.
• Expertise in Optimizing Database performance, Indexing, Materialized View, managing locking scenarios for multiple users.
• Strong writing and documentation skills for the management, development.
• Outstanding problem solving and customer focus skills.
• Excellent interpersonal and communication skills, very good team player, quick learner and capable of working independently.

Technical Skills

Databases

Oracle 8i, 9i, 10g, 11g

Languages

SQL, PL/SQL, Perl, Shell Script, C++

Operating Systems

Windows, Unix, Linux, MAC OS

Application Software

Ms Office (Word, Excel, PowerPoint)

Database Development Tools

Toad, SQL*Loader, SQL*Plus, SQL Developer

Network Technology

GSM, GPRS, CDMA, UMTS, cdma2000, EVDO, HSPA, WiMAX, LTE

Professional Experience

Confidential,Merrimack, NH Jul 2012 - Sep 2012
Title : Oracle PL/SQL Developer
Description: Fidelity Investments is an American multinational financial services corporation. It is one of the largest mutual fund and financial services groups in the world. Fund Facts Generic Extract (FFGE) is the process of dividing the funds into six different universes. The extracts are outbound feeds that are generated daily containing fund facts such as fund price, distributions, returns, assets, and reference data, etc. The FFGE files are generic and can service several customers who can subscribe to these generic files to use for their specific purpose. The project is to incorporate the logic into the FFGE process to use the fund_exceptions table in mias_R2 database for all exception processing instead of the ffge_fund_exception table in ref_R2 database in order to maintain one table for exception processing.

Responsibilities:

• Create estimated schedule for the project after the requirements gathering meeting.
• Analysis and design the technical proposal solution to consolidate the generic extract fund exceptions in a single location for better performance.
• Find out the involved scripts using ffge_fund_exception table including data files, header files and library files.
• Synchronize with other developers for the overlapped scripts.
• Set up clearcase view for checking out scripts and checkout files that need to be edited.
• Generate data files in the FFGE process without doing any changes to the scripts and do the backup.
• Remove the hard-coding for specific funds in order to apply fund exception logic to all the records in the table rather than specific ones.
• Replace the existing variable $hold with new variable $fund_except in the header files and library files called by Perl and SQR scripts.
• Change the SQL statement in the Perl and SQR scripts from ffge_fund_exception table in ref_R2 database into fund_exceptions table in mias_R2 database.
• Edit the subroutines and variables in the Perl and SQR scripts to combine the fund exception logic from two databases into the mias_R2 database.
• Use TOAD and Rapid SQL to remove the fund records in the ffge_fund_exception table in ref_R2 database and insert them into fund_exceptions table in mias_R2 database. Drop the ffge_fund_exception table.
• Unit test the edited scripts and regenerate the data files in the FFGE process.
• Extract data from both the backup data files and regenerated data files using SQL*Loader into Excel spread sheets for comparison.
• Compare newly generated data files with backup data files to check the differences and make sure that the FFGE scripts can achieve the same functionality as the original ones after the changes.
• Corporate with QA team doing full regression test for the FFGE process, and ask the business team to check the functions of system.
• Check in scripts from clearcase view and build the .tar files for installing in the production environment.
• Support the production team to do the install plan view and help them finish installing.

Environment: Oracle 10g, Sybase, SQL, T-SQL, PL/SQL, SQL Loader, UNIX, Perl, SQR, Shell programming, TOAD, Rapid SQL, Clearcase.

Confidential,KS Apr 2010 - Jun 2012
Title : Lead Oracle PL/SQL Developer
Description: The U.S. Bank Power Track (US Bank) is the world\'s largest freight payment solutions provider and is an industry leader with an unmatched set of offerings in the market place. Power Track is the system used by Buyers and Sellers to receive and pay invoices and collaboratively manage exceptions as they occur, using internet technology. The DW & BI solution project is for helping US Bank to overcome the shortcomings of the existing system and drive business growth. Scope of the project includes the development of a new data warehouse which contains an operational data store from different source databases, an enterprise warehouse that stores historical transaction level data, development of ETL processes to load historical and current data and development of subject specific data marts that store summary data to feed the reports

Responsibilities:

• Hold training meetings for junior developers to introduce the system and environment of the company.
• Act as lead Oracle PL/SQL developer to guide a group of junior developers to finish projects. Hold projects daily check in meeting to synchronize the process of each project and corporate the developers with each other according to the priority of the projects.
• Do code review for projects after the junior developers hand in the proposal solutions.
• Responsible for analysis, design, development, and testing of the application.
• Developed ER diagrams, physical and logical Data Models.
• Developed PL/SQL Procedures, Functions, Cursors, and Packages using SQL Developer, TOAD and Oracle 10g.
• Developed PL/SQL Views and Materialized Views with fast and incremental Refresh Rates using Oracle TOAD.
• Worked on PL/SQL Implicit, Explicit, REF Cursors and created Triggers for tables using SQL Developer.
• Used TOAD, SQL*Loader utilities to Export and Import Large Volumes of Data in the Excel Sheets into the Tables.
• Created and Modified PL/SQL Triggers, Procedures, Functions, packages and bulk collections using PL/SQL.
• Extensive use of PL/SQL Collections and Records, Partition methods for oracle tables and indexes. Extensively worked on PL/SQL Error/Exception handling, Control structures in PL/SQL.
• Support production DBA in daily or emergency procedures to resolve issues. Participated in Functional Testing and Unit Testing.
• Performed Oracle Performance tuning using SQL Trace and EXPLAIN PLAN.
• Resolved Priority Production Support Issues and Defect Fixes in PL/SQL code.

Environment: Oracle 10g, SQL, PL/SQL, SQL Loader, External Tables, UNIX, Shell programming, TOAD, Forms 9i, Eclipse.

Confidential,Strongsville, OH Oct 2008 - Mar 2010
Position : Oracle PL/SQL Consultant
Job Title : Oracle consultant
Description: Points Management application is designed and developed for managing the points awarded to the National City customers against the banking transactions they do. This service was earlier provided by third party application. The project was to develop an application to manage these points internally and convert the existing data into the new one. The data conversion included conversion of huge tables having millions of records.

Responsibilities:

• Participated in design discussions with the application architects and suggest design changes for improved database performance.
• Back-end application development using Oracle 11g PL/SQL. Develop stored packages, procedures, and functions; create tables, views, constraints, foreign keys and indexes.
• Created conversion scripts, and executing them over very large set of data. The amount of data ranged from 50 million customer accounts to 500 million transaction records. SQL tuning methods such as explain plan, correct Index creation and hints were used to option optimal performance.
• Extensively used of advanced PL/SQL concepts such as collections and bulk processing to achieve best performance. These were used in large data conversion scripts, to process records within a procedure or package before updating them to the database.
• Oracle data warehousing was used to analyze large amounts of data without affecting the production database. Materialized views were used to make a copy of transaction records from the production system daily, this was then used to analyze and generate reports for analysis.
• Used DBMS_SCHEDULER to set batch jobs for processing large amount of data in parallel.
• Some data in the conversion process was provided by third party application in very large files. Used SQL Loader for loading these files in the database.
• Wrote UNIX scripts to automate the conversion process where various conversion processes were put together and called in an order. The process was monitored and it would provide online progress of the process.
• Parallel batch processing was used to drastically reduce processing time for loading millions of bank transaction records. Algorithms were written to split the records in various batches and processing them separately.
• SQL Performance tuning was done using Explain plan, correct Index creation, Analyzing table stats and creating the right data model.
• Used development tools such as Toad and SQL Developer for writing code and executing the queries etc.
• Worked with the version control application Subversion, plugged in using Eclipse.

Environment: Oracle 11g, PL/SQL, SQL Loader, Explain Plan, Performance Tuning, Toad, Unix.

Confidential,Chicago, IL Dec 2006 – Sep 2008
Title: Oracle Database Developer
Description: Developed and maintain database for online stocks. Retrieve data from New York stock exchange as CVS files and convert it into Oracle database. Help users to print daily and specific automated reports.

Responsibilities

• Responsible for Stocks online application, email alerts modules requirements gathering, preparing Functional and Technical specification documents
• Coordinated specifications signoffs with end users
• Designed and created logical data models, schema objects, validation code and performance-tuning strategies using various types of Indexes
• Wrote PL/SQL Stored Procedures, Functions and Packages to enforce business rules
• Utilized partitions to fine-tune SQL data retrieval and load
• Wrote complex queries to do analysis work and generate reports to validate the results produced.
• Fix the proposed solution using PL/SQL stored procedures and functions.
• Built complex queries using SQL and wrote stored procedures using PL/SQL.
• Performance tuning of Oracle Databases and User applications.
• Wrote stored procedures for user requests Performed Capacity planning, Forecasting, Database design analysis and design.
• Wrote Shell scripts, PLSQL queries,
• Helped QA team do performance testing
• Developed PL/SQL stored procedures to automate many manual processes.
• Designed and developed data loading processes using PL/SQL and UNIX Shell scripts.

Environment: Oracle 9i/10g, PL/SQL, TOAD, Unix Shell Scripts, Reports 6i, Java

Confidential, Feb 2005 – Nov 2006
Title : ETL/Oracle SQL Developer
Description: China Mobile Sales Marketing Management has made the strategic decision to migrate there Company calls centers into a single system ‘offer management system’ (OMS). The previous OMS system was not able to handle the additional number of users and the increased number of transactions with its current hardware and software configuration. To allow for the increase in user base and transaction load we migrated the current OMS Sql-Server based system into a more robust Oracle based system environment.

Responsibilities:

• Developing new Packages using SQL Navigator and then store them in Microsoft visual source safe.
• Creating or modifying Packages, Procedures and functions using SQL Navigator application tool and then launching the applications from a report console or at the URL line.
• Developed primary database objects such as tables, Indexes and views to implement required functionality
• Involved in requirement analysis, design, implementation, testing and deployment of the system
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Tables, Granting and Revoking privileges, Creating Roles, Creating Primary and Foreign Constraints, Unique constraints, check constraints, Indexes, Analytic functions, Hints, Partitions, Cursors etc., and Views in Development and Production environment in PL/SQL
• Used source gear vault for storing all the source codes. Designed and developed the data conversion strategy.
• Developed packages, procedures, triggers and views to bridge the gaps between the old and new application.
• Experience in creation of ETL mappings and transformations usingInformatica
  InformationPower Center (8.x) development including error handling and validation routines.
• Developed back-end PL/SQL packages, building UNIX shell scripts for data migration & Batch Processing.
• Used Oracle JDeveloper to support JAVA code used in the modules
• Executed the test cases and test scripts to ensure applications were performing according to requirements.
• Prepared test plan, test cases and requirement trace matrix.
• Developed reports using Reports 9i and invoked Triggers, etc.
• Configured and deployed Forms and Reports to the Forms 6i and Reports Server.
• Involved in design, development and testing of Forms and Reports.
• Migrated data between stage and application schemas. Wrote SQL*LOADER control CTL files for data loading.
• Worked on SQLPLUS and SQLLDR calls from shell scripts.
• Executed PL/SQL scripts on server using Shell and Perl scripts.

Environment: Oracle 10g/9i, PL/SQL, Informatica 8.x, Unix Shell Scripting, Java, JDeveloper, SQL*PLUS, SQL Server, Microsoft Visual Source Safe 6.0, Linux

Education:

• Bachelors of Engineering Confidential,University of China in Jun 2004.