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.

• 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, Warrenville, IL Sep 12 to Till Date
Compass
Oracle PL/SQL ETL Developer
Confidential build a Customer Service Center (CSC) Platform to accurately and efficiently 
Capture relevant customer, financial, and fleet information that is tailored to meet Confidential\'s objectives such
as i) Create or import HTS routes into the system ii) Create the Master Schedule for which all daily schedules will be based,
iii) Create \'daily schedule\' from the \'master schedule\'; check employee and vehicle calendars to make adjustments to daily assignments. iv)Manage Daily Dispatch to track the progression of a CSC task from start to finish v)Create one-time tasks or recurring tasks vi)Create Charter & Field Trip request from customer in the \'daily schedule\'. vii)Manage employee payroll related information capture and pass-through to Oracle HR system viii)Support Employment Insurance (EI) Processing for Canada ix)Interface with the NEC fleet management system x)Payroll Processing and Interface to Oracle and Billing / Invoicing related processes as well as Provide Operational Reports.

Responsibilities:

• Converted Existing Java API into Oracle API by coding in Oracle PLSQL Packages.
• Prepared URL dynamically and received Zonar data in XML format by using UTL_HTTP.BEGIN REQUEST & UTL_HTTP.GET_RESPONSE.
• Coded Stored Procedures to process XML data stored in CLOB format and used bulk insert to load data with PLSQL collections.
• Coded PLSQL Packages to use UTL_MAIL & UTL_SMTP.
• Coded PLSQL Packages to create materialized views and return materialized views names based on the parameters passed from front end application.
• Coded Oracle Store procedures/packages to create & drop jobs using DBMS_Scheduler.
• Prepared Oracle SQLs using LISTAGG & other Analytic Function for Business User’s ad hoc request.

Environment: Oracle 11G, SQL, PL/SQL, XML, TOAD & SQL Developer.

Confidential, Cleveland, OH Sep 11 to Aug 12
SPI-2 Conversion
Oracle PL/SQL ETL Developer
Confidential is the original, central custom software application that Safeguard uses to run the day-to-day operations of its property management business. The SPI-2 application is the replacement for the Confidential system. Many supporting applications interact with Confidential and will interact with Confidential-2 after the system conversion. The system objective of SPI-2 conversion is to migrate historical as well as day-to-day data of Safeguard into new developed system. The financial data of Safeguard both Client Payments referred as CP and Account Receivables referred as AR along with Client/Vendor/BillTo data are also migrated before the migration of SPI transaction data.

Responsibilities:

• Prepared OWB mapping design document based on requirements.
• Created Oracle Heap tables, External Tables constraints, indexes based on requirements.
• Coded OWB mappings, PL/SQL Packages and Procedures to copy financial data from Safeguard Accounting system to SPI2 newly developed system.
• Coded Mappings with operators such External Tables, Lookup, Deduplicator, Pivot, Pre-Mapping, Post-Mapping.
• Loaded data from flat files into Oracle heap tables thru External tables via OWB mappings and PLSQL packages.
• 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 mappings.
• Worked in Agile Environment.

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

Confidential Los Angeles, CA Apr 11 to Sep 11
Decision Support System
Oracle PL/SQL ETL Developer
The system objective of DSS is to load student’s data across different schools, which are affiliated to Confidential 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.
• Create Materialized views for OBIEE reports as well as modified the existing MVs for performance tuning.

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
Oracle PL/SQL ETL Developer 
The system objective of NA Data Interfaces is to load data from applications such as Confidential 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, Oracle Workflow, RapidSQL (Embarcadero), SQL Developer and Cognos.

Confidential Deerfield, IL Sep 08 to Dec 08
CAPEX & RPM Projects
Oracle PL/SQL Developer 
The system objective of CAPEX (Capital Expenditure) is to analyze the investment cost across different regions of Confidential for every project. This is one among the in-house applications of Confidential 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
Oracle ETL Developer 
Confidential 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. Confidential 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, UNICA, SQL, PL/SQL and UNIX Shell Script.

Confidential Chicago, IL May 06 to Dec 06
Maximis
Oracle PL/SQL Developer
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.
• 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, SQL, PL/SQL and UNIX Shell Script.

Confidential Bannockburn, ILApr 06 to May 06
Advanced Demand Forecasting – Cutover
Oracle PL/SQL Developer
Advanced demand forecasting is a system developed by Confidential internally and is used for identifying and predicting the demands in well advanced for the Confidential’s products. Using this system’s output, Confidential 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 Confidential’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
Oracle Developer
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. Confidential 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, Feb 04 – Jan 05
Migration of Dolphin Release 1.1 to Dolphin Release 1.2
Oracle PL/SQL Lead Developer
BHI is a subsidiary of Confidential, involved in the business of collections. BHS 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 Oct 03 – Feb 04
UBP Migration Street Reference 4.0.8 to Street Reference 6.2.0
Oracle PL/SQL Developer
Confidential present on the Swiss financial market since 30 years and offers both private and institutional asset management. This Project includes the activities necessary for Confidential 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.

EDUCATION:

MCA

BSc Physics