We provide IT Staff Augmentation Services!

Sql Developer Resume

Los Angeles, CA

SUMMARY: To become a Leading Software Professional by Continuously Reinventing my Capabilities and growing along with an organization and hence contributing effectively to the Software Industry. Also, willing to be part of innovative team that provides challenges and possibilities to utilize my skills and creativeness.

  • Ten years of experience in Information Technology in the areas of application development and design.
  • Expertise in development of PL/SQL stored procedures, packages, Functions and Triggers.
  • Proficient in SQL, SQL*Plus, SQL*Loader, TOAD Quest and Tuning of SQL Queries using Explain Plan, TKPROF.
  • Experience in working and scripting knowledge of UNIX shell scripts.
  • Experience in Development and Support of both Development and Production Systems.
  • Experience in Multi Currency implementation.
  • Experience in supporting large scale production system.
  • Experience in Enterprise Marketing Management software (UNICA).
  • Proficient in ETL, OWB, Informatica, Crystal Reports, Business Objects, Progress and Oracle Reports.
  • Excellent problem solving, analytical, written and communication skills with ability to work both in team as well as an individual.
  • Interests in learning new technologies.

TECHNICAL:

OS: Sun Solaris 5.6, HP-UX 11.0, Windows NT and 2000 RDBMS: MS Access 2002, Oracle 11G/10G,9i/8i/8.0, Sybase, Progress TOOLS: Reports 6i, SQL*Loader LANGUAGES: PL/SQL, Pro*C, Shell Programming Other: Java Script, HTML, OWB, Informatica, Crystal Reports, Business Objects, Cognos

CERTIFICATION:

  • Oracle Certified Associate in Oracle 9i.
  • Oracle PL/SQL Developer Certified Associate.
  • Brain Bench Certified on Oracle PLSQL Fundamentals.
  • Brain Bench Certified on Oracle PLSQL.
  • Brain Bench Certified on Data warehousing concepts.
  • Brain Bench Certified on Data Modeling concepts.

Confidential, Los Angeles, CA Apr 11 to Till Date Decision Support System Confidential is to load student's data across different schools, which are affiliated to LAUSD for each occurrence/month of each year. Using DSS, each student's academic activities are monitored for their higher education or for college enrollment. Student's grades 1 to XII are populated on weekly and monthly basis from various source systems to DSS based on their occurrences. Responsibilities:

  • Prepared ETL design document based on requirements.
  • Created tables, constraints based on requirements.
  • Coded OWB mappings, PL/SQL Packages and Procedures to post student's data into Staging as well as DSSWH environments.
  • Loaded data into dimension as well as Staging, fact and fact summary tables.
  • Coded Mappings with operators such Lookup, Transformations, Pivot, Unpivot, applied data rules on tables and also used error tables.
  • Involved Unit testing and UAT for the developed codes and then moved the code to production environment.
  • Coded UNIX shell scripts to execute Oracle Custom Packages, Procedures and OWB ETL mappings on weekly/monthly basis.

Environment: Oracle 11G, SQL, PL/SQL, OWB, TOAD, SQL Developer and UNIX.

Confidential, Chicago, IL Aug 09 to Mar 11 NA Data Interfaces & Regulatory Reporting Projects The system objective of NA Data Interfaces is to load data from applications such as Allianz Corporate Data/Global Genius to post into SAP. These interfaces are executed and stored in Repository layer of Staging Area in FB01 format. This is the format in which files are posted to SAP. The interfaces are of Premium/Claim/Cash of Property & Casualty, Aviation & Marine insurance business of AGCS. Regulatory Reporting of AGCS is to fulfill the requirements of Regulatory body of USA & Canada. The existing reports pull the data from Source systems which are in Sybase and outputs are saved in pdf files. The proposed reports are created from NA Staging area which is in Oracle and the reports are created by Cognos and then saved into pdf files. However, NA staging area data are moved to Global Business Information Management (GBIM) layers thru OWB and then Cognos reports are generated for each month and saved as pdf files. Responsibilities:

  • Programmed business logic based on requirements.
  • Coded PL/SQL Packages and Procedures to post data into FB01 format of Reporting layer of Staging Area and also coded balancing module for balancing data between Source & Stage area SAP posted data, which exists in Reporting layer of NA Stage Area.
  • Extract data from NA Stage Area on monthly & adhoc basis as per Business user's request for KPGM audit.
  • Created Oracle tables with Primary Keys/Indexes and Partitions.
  • Analyze Oracle tables at regular intervals or whenever necessary for data population.
  • Coded OWB ETL mappings to move data from Source layer which is NA Staging Area to Application (APL) layers.
  • Responsible for Coding 13 dimension (using SCD 1 & SCD 2) and & 7 fact tables ETL mappings.
  • Responsible for coding balancing procedure to balance the data between SL/STG/DWH/APL layers of GBIM.
  • Coded Manual Adjustments procedure & OWB ETL mappings which are responsible for moving adjustments data from NA Staging area into GBIM layer, which are later considered for Regulatory Reporting on Cognos.
  • Responsible for creating bitmap indexes & table partitions in fact tables of GBIM layers.
  • Created List reports using Reports Studio for Regulatory Reporting.
  • Fixed bugs in the existing NA Stage Area production codes and supported the system 24/7 during daily and month end closeout schedules.

Environment: Oracle 11G, 10G,SQL,PL/SQL,OWB,OracleWorkflow,RapidSQL(Embarcadero), SQL Developer and Cognos.

Confidential,, IL Sep 08 to Dec 08 CAPEX & RPM Projects The system objective of CAPEX (Capital Expenditure) is to analyze the investment cost across different regions of Baxter for every project. This is one among the in-house applications of Baxter to evaluate the investments done in different projects to get cognos reports that will be used for Management decisions or forecasts.

RPM (Rational Portfolio Manager) is an application that stores information about hours logged by employees & contractors for R&D, IT & Admin projects. This data is pulled for Management decisions or forecasts.

Responsibilities:

  • Captured business requirements from Business Analysts.
  • Programmed business logic based on requirements.
  • Coded PL/SQL Procedures and functions to pull data from data warehouse environment into Data mart.
  • Created List, Sub and Cross-Tab reports using Reports Studio.
  • Created standard filters, calculation prompts, and conditions.
  • Provided Oracle back end programming including PL/SQL, Oracle Stored Procedure.
  • Fixed bugs in the existing codes.
  • Loaded data using SQL Loader, Shell Scripts.
  • Automation of existing manual user process using PLSQL.

Environment: Oracle 10G, Cognos, SQL, PL/SQL and UNIX Shell Script.

Confidential, Northbrook, IL Jan 07 to Jun 08 Database Marketing Operations Allstate promotes their insurance products by performing campaigns on bi-weekly and monthly basis. The purpose of these campaigns is to ensure that all their existing customers are aware of their various other insurance products. Allstate customers are encouraged to buy their insurance products by providing attractive discount rates based on their performances. Direct Mail and Email are the modes used for these campaigns.

Responsibilities:

  • Captured business process requirements which are on Campaign management document with the program managers.
  • Converted the requirements by coding into campaign tools such as Campaign Designer (DFM) and UNICA.
  • Executed the campaigns which are already coded on the tools such as DFM and UNICA.
  • Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
  • Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Route transformations for populating target table in efficient manner.
  • Coded PL/SQL Procedures, table Packages and UNIX shell scripts for selecting data from oracle database.
  • Performed quality check to verify whether the data is valid for the respective campaigns.
  • Transferred data from staging table to production table which are then transferred to vendors for printing and email.

Environment: Oracle 9i, 10G, Informatica, SQL, PL/SQL and UNIX Shell Script.

Confidential, Chicago, IL May 06 to Dec 06 Maximis Maximis is Unisys's Investment management and Accounting solution. It is a real-time intranet-enabled application with a database backend. Maximis provides an extensive range of functions and data access within all key investment activities such as Portfolio Analysis, Investment Management,Trade Processing,Cash Processing , Multi-currency accounting, Regulatory reporting and Inquires & reports. It also fully supports domestic and international securities trading of Equity, Fixed Income and Derivative assets.

Responsibilities:

  • Captured business process requirements of entries made to SAP.
  • Studied manual process and automated it by writing store procedures.
  • Prepared Functional Specifications, Technical Specifications and Test Cases.
  • Extensively used Power Center/Mart to design multiple mappings with embedded business logic.
  • Created Mapplet and used them in different Mappings.
  • Coded PL/SQL Procedures, Functions and table Packages.
  • Created and maintained Cognos packages in Framework Manager.
  • Created various Cross tab, List reports using Report Studio according to business requirements.
  • Coded procedure to send email using UTL_SMTP function.
  • Working knowledge of coding store procedure to call Web service from Oracle 9i.

Environment: Oracle 9i, 10G, Informatica, Cognos, SQL, PL/SQL and UNIX Shell Script.

Confidential, Bannockburn, IL Apr 06 to May 06 Advanced Demand Forecasting - Cutover Advanced demand forecasting is a system developed by Kraft internally and is used for identifying and predicting the demands in well advanced for the Kraft's products. Using this system's output, Kraft is able to supply their products in well advanced to their customers. This system is able to track on which date, how much quantity and what location (Customer warehouse, Customer retail loc) the products were sent. This system is able to predict for all the Kraft's products irrespective of the product types. Cutover is a new system which is to create the existing Production system into a new environment. Also it includes not only creating the database objects such as tables, procedures, packages, functions etc but also includes in creating the data which includes all DFU levels.

Responsibilities:

  • Captured business process requirements for the cutover system.
  • Studied existing system and review.
  • Prepared Functional Specifications and Technical Specifications for the cutover system.
  • Coded PL/SQL Procedures, Functions and Packages for the cutover run using collection types.

Environment: Oracle 9i, SQL, PL/SQL and UNIX Shell Script.

Confidential, Chicago, IL Mar 05 to Mar 06 Domestic Treasury Application Trade Desk is a front office utility that is used by traders to book trades and transactions, and to capture deal information. TradeDesk is developed by Real-Time. InTrader is a Back Office application that processes trades received from TradeDesk, and performs End of Day (EOD) processes. Sungard develops InTrader. After InTrader processes a trade, it generates a sequence number and sends it back to TradeDesk. Intrader also posts payments, mainly to DDAs. A data translation problem exists between TradeDesk and InTrader as different companies have developed them. ABNAMRO has resolved this problem by developing its own interface between InTrader and TradeDesk. This customized Interface facilitates the entry of customers, trades and some security records in InTrader with data taken from the Trade Desk Front Office system.

Responsibilities:

  • Customized reports like Customer credit report, front dated trades, and Customer files.
  • Maintained officer names in Report scheduling interface to receive the outstanding officer reports.
  • Tuned SQL Query for efficient performance in packages, procedures and functions.
  • Designed, developed and registered reports using UNIX crontab facility.
  • Coordinated with different users for the Functional Specifications and final utility of the modules.
  • Coded UNIX shell scripts for the execution of user reports.
  • Involved in Testing and production support activates.

Environment: Oracle 9i, Sybase, Progress and UNIX Shell Script.

Confidential,, GERMANY Feb 04 - Jan 05 Migration of Dolphin Release 1.1 to Dolphin Release 1.2 Confidential is a subsidiary of Deutsche Leasing, involved in the business of collections. Confidential is the service wing of BHI. Sparkasse (Savings Bank) in Germany lend money to the customers for various purposes. The customers have to pay back the money based on the payment agreement, which they have entered with Sparkasse. When the customers do not pay back their money, they are termed as defaulters and their profiles are transferred to BHI, who in turn collect the money from the defaulters/debtors. In order to manage this process of collection, BHI/BHS use a collection product called phinAMV Inkasso, developed by a company called Phinware, which is also in Germany. BHI / BHS processes claims pertaining to around 20 clients, most of them belonging to the Sparkasse group. They use the phinAMV Inkasso product for recovering the dues against the debtors by initiating judicial procedures. The purpose of this project is to migrate the Dolphin release 1.1 to Dolphin release 1.2 by executing migration scripts which was coded in PL/SQL and UNIX shell scripts.

Responsibilities:

  • Captured business process requirements.
  • Loaded data using SQL Loader, Shell Scripts
  • Coded PL/SQL Procedures, Functions and Packages for the migration run using collections types such as Nested tables, Associative arrays and Varrays.
  • Uploaded the conversion data files using Informatica mappings.
  • Coded Oracle Reports for the reconciliation.
  • Tuned SQL Query for efficient performance in packages, procedures and functions.
  • Reviewed enhancements made by peers in the team.
  • Traveled to Germany (Bad Homburg) to involve in SIT Testing and UAT Testing activities.

Environment: Oracle 9i, SQL, Oracle Reports 6i, PL/SQL, ERWIN (Data Model Tool), Informatica, SQL Loader and UNIX Shell Script.

Confidential, LONDON Oct 03 - Feb 04 UBP Migration Street Reference 4.0.8 to Street Reference 6.2.0 UBP present on the Swiss financial market since 30 years and offers both private and institutional asset management. This Project includes the activities necessary for Union Bancaire Privee (UBP) to Upgrade their existing FTI (Financial Technologies International) products to the new StreetEnterprise 6.2 Platform. For UBP, this means upgrading their Assets, Institutions and Prices (AIP) 4.08 application to Street Reference for Securities 6.2. In addition, the FTI data model used by UBP will also need to be upgraded to the equivalent data model version namely StreetModel 6.2.

Responsibilities:

  • Loaded data using SQL Loader, Shell Scripts.
  • Coded PL/SQL Procedures and Packages for the migration run.
  • Coded PLSQL Packages for the reconciliation.
  • Tuned SQL Query for efficient performance in packages, procedures and functions.

Environment: Oracle 9i, PL/SQL, SQL Loader and UNIX Shell Script.

Confidential, BELGIUM Oct 01 - Sep 03 Orbit Brokerage System The ORBIT Brokerage System will form the core product processor for the Belgium Brokerage business. The general purpose is to prepare a front-end and back-end platform which allows linking to any broker solution. The application will therefore be conceived to support multiple channels viz. POS (through Financial Centers & Business Partners) and CitiPhones and a range of investment products - equities, warrants and fixed income instruments. The modules developed in Orbit Brokerage system are IPO (Initial Public Offer) and Batch Interface. The functionality of IPO is to allocate the customers who apply for IPO based on the set up rule maintained. A separate charging price matrix had been developed to handle not only the IPO but also the Buy, Sell, transfer in, transfer out, order execution operations of Orbit Belgium Brokerage System. The Batch interface is EOD (End Of day) module, which uses to send the transactions, no of holdings of customers, details of scrip and Financial transactions of brokerage customers from Orbit Brokerage System to Host System (AS400). All the above details will be transferred to Host System By flat file thru NDM (Network Data Mover) machine.

Responsibilities:

  • Captured business process requirements for IPO Allotment process.
  • Captured business process requirements for Batch Interface.
  • Coded PL/SQL Procedures, Functions and Packages for batch processing of the applications and IPO allotment process using UTL file operations and for charging and multicurrency calculations.
  • Coded Pro*c programs for IPO allotment and batch process.
  • Prepared Unit test cases and execution.
  • Involved in Testing and production support activities.

Environment: Oracle 9i, SQL, PL/SQL, Pro*C and UNIX Shell Script.

Confidential, INDIA Jun 01 - Sep 01 Group Exposure This system is to Capture Grouping of Accounts across cities and having a cap for their exposure helps in minimizing the Risk and Identifying the Customer across cities either as Borrower / co-borrower or Guarantors and capping their exposure minimizes the Risk for the Bank and also helps in tracking the frauds.

Responsibilities:

  • Coded PL/SQL Procedures and Packages for Group capturing accounts using bulk operations such as bulk collect etc.
  • Coded Pro*c programs for calling PLSQL procedures and Packages.
  • Prepared Unit test cases and execution.
  • Involved in Testing and production support activities.

Environment: Oracle, SQL, PL/SQL, Pro*C and UNIX Shell Script.

Advice Generations Advice Generation Module deals with the Letter Generation for all the necessary Customer Communications for activities like Booking, Reopening, Auto Renewal, Auto Enhancement, Auto Reduction and Closure.

Responsibilities:

  • Coded PL/SQL Procedures and Packages for Advice Generations,(i.e.) the output of the these procedures and packages will
  • be in the letter formats which are then printed and couriered to customers.
  • Coded Pro*c programs for calling PLSQL procedures and Packages.
  • Prepared Unit test cases and execution.
  • Involved in Testing and production support activities.

Environment: Oracle, SQL, PL/SQL, Pro*C and UNIX Shell Script.

Confidential Dec 00 - May 01 Brokerage for Registrar & Transfer This System calculates brokerage for the brokers who bring customers to Birla Mutual Funds. Brokerage is calculated Monthly wise, Yearly wise, Amount wise and Application wise using Oracle and Pro*C.

Responsibilities:

  • Coded Pro*c programs for calculating brokerage amount for the brokers.
  • Prepared Unit test cases and execution.
  • Involved in Testing and production support activities.
  • Traveled to Mumbai for implementation.

Environment: Oracle, SQL, Pro*C and UNIX Shell Script.

Confidential, INDIA Oct 98 - Nov 00 Charging Price Matrix for Equity Advance System This is a flexible system solution with an attempt to charge Stock Power Customers of CITIBANK based on several layers of parameterization like the Line Utilization Percentage, Share Sales, Delinquency etc., for transactions with the NSDL, using Oracle Pro*C and PL/SQL.

Responsibilities:

  • Coded PL/SQL Procedures and Packages for charging calculations based upon the various tasks of customers such as New, Auto Renewal, Reduction and closure.
  • Coded Pro*c programs for calling PLSQL procedures and Packages.
  • Prepared Unit test cases and execution.
  • Involved in Testing and production support activities.

Environment: Oracle, Pro*C, PL/SQL and UNIX Shell Script.

Market Rate Input on Daily Basis This is a system that tracks the value of the Volatile Financial Securities that are pledged by the customers with CITIBANK, for availing an Overdraft Line Facility as part of the Stock Power Equity Advance System. The Fluctuating value of the volatile Financial Securities is monitored on a Daily Basis using an Oracle, Pro*C and PL/SQL and necessary financials like that of the Portfolio Value, Eligible Line, etc., are impacted with.

Responsibilities:

  • Loaded data by using SQL Loader, Shell Scripts.
  • Coded PL/SQL Procedures for reading the data from the temporary tables and then inserting into scrip master tables.
  • Coded Pro*c programs for calling PLSQL procedures.
  • Prepared Unit test cases and execution.
  • Involved in Testing and production support activities.

Environment: Oracle, Pro*C, SQLLOADER, PL/SQL and UNIX Shell Script.

Y2K Compatibility This project involved fixing the globally impacted millennium bug. Over 250 programs and tables in the Stock Power EQUITY ADVANCE SYSTEM of CITIBANK N.A. (India Operations) were reviewed and necessary changes were incorporated in the application for the 4-digit date compatibility, followed by Extensive System Integrated Testing and Implementation.

Responsibilities:

  • Involved in modifying the existing production program to incorporate the 4-digit date compatibility in Pro*c programs.
  • Involved in modifying the existing production program to incorporate the 4-digit date compatibility in PLSQL procedures and packages.
  • Involved in production support activities.

Environment: Oracle, PL/SQL, Pro *C and UNIX Shell Script.

Internet Banking Designed and developed a System is to provide Customer information on the Net. The existing system was converted into a Web Based System with the required enhancements adequate security to the customer. This System takes in various inputs from the customer like the CIN (Customer Identification Number) or the Account Number and passes these details to the backend through the CGI (Common Gateway Interface) which acts as a Middleware. Details like Holding, Over Draft Simulation etc., for customers are then displayed on the Net after proper validations.

Responsibilities:

  • Coded programs in PLSQL for showing the holdings and over draft simulation for the customer from the database.
  • Coded programs in C and CGI to support the web based architecture.
  • Coded HTML and java scripts to include the AAFA application on the internet system.
  • Prepared Unit test cases and execution.
  • Involved in Testing and production support activities.

Environment: Oracle, PL/SQL, C, CGI, HTML, Java Scripts and UNIX Shell Script.

Relationship Query Designed and developed a System to provide Customer's demat information to the users .The information is Captured from NSDL Server by downloading it.And once again the customer's information is uploaded into Equity Advance System during the EOD period. The Information about the customer from NSDL Server are Holdings, Transactions and personal details. Apart from these information users are able to view the status of physical scripts that has been sent for Dematerialization.

Responsibilities:

  • Loaded data using SQL Loader and Shell Scripts from the flat file into temporary table.
  • Coded Pro*c programs to move the records from the temporary table to master table.
  • Prepared Unit test cases and execution.
  • Involved in Testing and production support activities.

Environment: Oracle, Pro*C and SQL Loader and UNIX Shell Script.

NSDL [National Securities Depository Limited] Operations NSDL is the first depository set up in India by IDBI [Industries Development Bank of India], UTI [Unit Trust of India] and NSE [National Stock Exchange]. The concept of electronic trading (Dematerialization) is a new concept in India. With SEBI mandating compulsory Demat trading for scripts of Blue Chip companies, Citibank decided to completely dematerialize its Equity Advance Portfolio. Client being a Depository Participant the challenge was to integrate the stand-alone system of NSDL with Citibank's existing and well established systems with minimum impact on customers.

Responsibilities:

  • Loaded data using SQL Loader and Shell Scripts from the flat file into temporary table.
  • Coded Pro*c programs to move the records from the temporary table to master table.
  • Coded Pro*c programs to generate the data in a report format from the database.
  • Prepared Unit test cases and execution.
  • Involved in Testing and production support activities.

Environment: Oracle, Pro*C, SQL *Loader, and UNIX Shell Script.

EDUCATION: MCA BSc Physics

Hire Now