If interested in this candidate, please email us at rupa@simplion.com
*******************************************************************************
Summary
· Over 9 years of experience in Analysis, Design, Development, Implementation of Business Applications using the Oracle relational databases management system on various platforms.
· Performed system analysis and design, reverse engineered systems and created new applications.
· Worked on Data Modeling both Physical & Logical using ERwin.
· Proven ability to plan, coordinate and implement full life Cycle software development and maintenance projects.
· Implementation of large and complex Oracle character & GUI based Client/Server applications and also web based applications.
· Experience in development of applications in Oracle 10g/9i/8x/7x databases, worked on MS-SQL Server.
· Strong experience in SQL and PL/SQL performance tuning and worked on database tuning.
· Strong skills in Oracle are PL/SQL, SQL, & Pro*C back end programming like stored packages, functions, procedures, database triggers and wrote shell and perl scripts.
· Strong experience in Oracle Forms 9i/6i/4.5, Reports 9i/6i/2.5.
· Worked with Database Administration for Backup & Recovery, Creating database Schemas like tables and Indexes.
· Migrated the data from Legacy system to Oracle Database.
· Experience working with front end teams which use Java, JSP, Servlets, HTML, JavaScript,
Certifications:
Oracle Certified Professional (OCP)
Education:
MS Master of Computer Science, India
BS Bachelor of Computer Science, India
Technical Skills:
Operating System: IBM AIX 5.2, Sun Solaris, HP-UX, Windows 9x/2000/NT, DOS.
Databases: Oracle 10g/9i/8x/7x, MS-SQL Server, DB2, Access
Languages: PL/SQL, SQL, Pro*C, C/C++, Perl, Java, JSP, HTML, Unix Shell and Perl scripting (K/B/C), XML
Data Modeling: ERwin
Tools: Developer 2000/6i/9i, Forms 9i/6i/4.5, Reports 2.5/6i, TOAD, SQL*Plus, SQL*Loader, Explain Plan, Import/Export.
Experience:
Wells Fargo Bank, San Francisco CA July 2005 till date
Project: I3 Project
Sr. Analyst/Programmer
I3 Project is all about an integration of various financial organizations’ functionalities and businesses with whom Wells Fargo bank consults with.
This product is developed by a vendor, and thoroughly customized in-house.
Wells Fargo bank has customers who are one of the best in the businesses and, individuals in the United States, dealing in millions and billions of dollars. Wells Fargo advises these elite customers to work with the dedicated Wells Fargo consultants, to come up with a sophisticated plan on how best a customer can place is financial assets on various savings and earning options such as stocks, saving accounts, fixed deposits and bonds and so on.
Right now, all this information is so discrete that the Wells Fargo consultants/agents finding it bit harder to collect all the data and build up an intelligence to serve those Hi-Profile and elite customers better and faster.
I3 project is a serious attempt to make Wells Fargo financial consultants’/agents’ life easy.
Responsibilities:
· Involved in analyzing, modeling and designing various sub-modules involved in the I3 project involving data files loading, batch processes and data validation aspects,
· Involved in integration and porting of I3 product (a product delivered by a vendor), including performance and added research on enhancing production support.
· Worked on creating K-shell and Perl scripts and Cron jobs to automatically run the stored procedures.
· Generated Triggers for data integrity, Created views to resolve complex queries.
· Worked on improving performance of SQL statements, queries involved in the reports, Supported Java application front ends with JSP, J2EE and Websphere application server.
· Worked on creating interfaces between other systems and I3 system using Pro*C.
· Worked on Pro*C and C++ to create complex reports.
· Tuning of SQL Scripts for generating XML Reports.
· Tuned SQL queries and resolve performance issues.
· Used SQL*Loader to load data from other systems into Oracle database.
· Wrote PL/SQL procedure, functions, Triggers to maintain data integrity.
· Assisted the DBA while designing and creating database schemas and also performed regular Database Administration tasks.
· Created SQL statements for extracting data from XML database columns (Blob) to produce reports.
· Created and modified Oracle Schema objects like Tables, Indexes, Roles/ Privileges..
· Designed, Developed and documented the new reports and customized existing reports
Environment: Oracle 10G/9i, SQL, PL/SQL, Perl, XML, IBM AIX Unix and Win NT Shell and Perl scripts, Pro*C/C++, Oracle tools – SQL*loader, import, export Java, J2EE, Websphere Application Server, TOAD 8.5,.
SBC, San Ramon CA April 2004 – June 2005
Project: SWOT and RFS systems
Sr. Programmer/Analyst
Customer can order SBC-Yahoo DSL online. SWOT (Single Web Ordering Tool) application receives the customer orders and RFS (Request Fulfillment Service) is a order processing application.
SWOT talks to various mainframe and mid-range system downstream, for phone line qualification, customer validation, address verification, getting available order due dates etc.
It stores the customer data, various types DSL orders, list of SBC telephones in 13 states.
RFS processes the order by sending the batch files of orders to mainframe B2B system and receiving back the processed batch files.
Responsibilities:
· Involved in Business Analysis, High level design and Detail design
· Involved in Logical and Physical data modeling used ERWIN tool.
· Created and modified Oracle Schema objects like Tables, Indexes, Roles/ Privileges..
· Worked on creating interfaces between other systems and RFS system using PL/SQL procedures and Pro*C and created load programs to load data from flat files with necessary business validations, using Pro*C.
· Worked on creating shell and perl scripts and Cron jobs to automatically run the stored procedures.
· Configured and deployed Forms and Reports to the Forms 6i and Reports Server, involved in creating Forms Libraries and Forms templates.
· Created SQL statements for extracting data from XML database columns (Blob) to produce reports.
· Worked on improving performance of SQL statements, queries involved in the reports, Mainframe DB2 to Oracle data transfer) loading into temporary tables and cleaning/correcting data using PL/SQL and transferring to respective production tables.
· Generated Triggers for data integrity, Created views to resolve complex queries.
· Used SQL*Loader to load data from Other systems into Oracle database.
· Wrote PL/SQL procedure, functions, Triggers to maintain data integrity.
· Tuning of SQL Scripts for generating XML Reports.
· Assisted the DBA while designing and creating database schemas and also performed regular Database Administration tasks.
· Fine tune SQL queries and resolve performance issues.
· Supported Java application front ends with JSP, J2EE and Websphere application server.
· Designed, Developed and documented the new reports and customized existing reports
· Installation and set-up of Forms 6i Server.
Environment: Oracle 9i/8i, PL/SQL, SQL, XML, Shell and Perl scripts, Erwin, Reports 6i, Pro*C, Forms 6i, Java, J2EE, XML, Websphere Application Server, TOAD 7.6, UNIX and Win NT.
Warner Brothers Inc, Burbank CA Feb 2003 – Mar 2004
(Warner Brothers Home Videos)
Project: RIM System
Sr. Programmer/Analyst
RIM- Retailer Inventory Management is a vender managed system of Warner Brothers (WB) Home Videos. WB video has retailers like Wal-Mart and other top retailers throughout US, uses this system to do the replenishment of DVDs and VHS of the WB movies. The system has a web based front end and data is migrated using XML.
Responsibilities:
· Performed Business Analysis, High level design and Detail design
· Building Enterprise wide Conceptual, Logical and Physical data modeling using the ERWIN.
· Configured and deployed Forms and Reports to the Forms 6i and Reports Server.
· Installation and set-up of Oracle 9i/8i database.
· Created and modified Oracle Schema objects like Tables, Indexes.
· Involved in process of normalization. Developed Entity relational Diagrams (ERD).
· Involved in SQL & PL/SQL programming for stored procedures.
· Involved in migration of data from legacy system (Mainframe) to Oracle database.
· Worked on improving performance of SQL statements, queries involved in the reports, created or dropped indexes, partitioned tables to improve overall performance of RIM system.
· Worked on creating interfaces between other WB systems and RIM system using PL/SQL procs and Pro*C and created load programs to load data from flat files with necessary business validations, using Pro*C.
· Migrating/Converting the data from previous DOS based systems. (SQL Loader, Excel to MS access to Oracle data transfer) loading into temporary tables and cleaning/correcting data using PL/SQL and transferring to respective production tables.
· Generated Triggers for data integrity, Created views to resolve complex queries.
· Designed/ created Oracle database objects, Roles/ Privileges and schemas.
· Used SQL*Loader to load data from DB2 UDB into Oracle database.
· Wrote PL/SQL procedure, functions, Triggers to maintain data integrity.
· Involved in assisting front-end development in JSP to create user reports fetching data from RIM system.
· Worked on creating batch programs using Pro*C, Perl and C-Shell also developed Oracle jobs.
· Developed Oracle JOBS for executing the Stored Packages.
· Tuning of SQL Scripts for generating XML Reports.
· Assisted the DBA while designing and creating database schemas and also performed regular Database Administration tasks like Backup & Recovery.
· Fine tune SQL queries and resolve performance issues.
· Converted old application from Forms 4.5 to Forms 6i to make them web enabled.
· Web enabled Oracle reports using Reports 6i and put it on the Intranet for the managers also converted reports in EXCEL format.
Environment: Oracle 9i/8i, PL/SQL, DB2 UDB, SQL, Erwin, Stored Procedures, Reports 6i, MS Office, Forms 6i, HTML, Java, JSP, XML, SQL Navigator, TOAD , UNIX and Win NT.
Sun Microsystems Inc., Milpitas, CA Mar 2001 - Feb 2003
SunBURST and SunAware Data warehouse Systems
Sr. Oracle Developer
SunAware is a Decision Support System It is a data warehouse, stores Sales, Marketing information used by Sun’s Managers for reporting. The system has distributed database environment with database servers. Data is replicated using Shareplex utility and batch jobs are managed automatically using Autosys on Sun Solaris.
Responsibilities:
· Interacted with the Users and performed business analysis, High level design and detail design
· Involved in creating schemas for SunBURST system on Oracle 8i server, extracting information from the parent SunAware system and ERP system, which send data as ETL extracts to SunBURST.
· Worked on backend, created packages and stored procedures using PL/SQL to load summary or aggregate tables involving data of the magnitude up to 5 to 10 terabytes.
· Designed Logical and Physical database layouts using Erwin.
· Configured and deployed forms and reports to the Forms 6i.
· Designed, Developed and documented the new reports and Customizing Existing reports.
Installation and set-up of Oracle 8i database.
· Created front-end GUI design for application using Forms 6i.
· Converted old application from Forms 4.5 to Forms 6i to make them web enabled.
· Web enabled Oracle reports using Reports 6i and put it on the Intranet for the managers
· Created and modified Oracle Schema objects like Tables, Indexes.
· Involved in process of normalization. Developed Entity relational Diagrams.
· Involved in SQL & PL/SQL programming for stored procedures, system development,
· Developed, tested and implemented both Visual interface as well as the database of the whole application.
· Generated Triggers for data integrity, Created views to resolve complex queries and also create computational modules in C++ and Pro*C.
· Worked on creating batch programs using Pro*C, Perl and C-Shell for Autosys jobs.
· Worked on creating interfaces between legacy systems and SunBurst system using Pro*C and created load programs to load data from flat files with necessary business validations, using Pro*C.
· Assisted the DBA while designing and creating database schemas. Used SQL*Loader to load data into Oracle database.
· Wrote PL/SQL procedure, functions, Triggers to maintain data integrity.
· Involved in DBA activities such as creating and managing schemas: tables, indexes, snapshots, rollback segments, roles, links etc.
· Worked on Shareplex to transfer data between source Db2 UDB, MS ACCESS and target Oracle servers.
· Involved in assisting front-end development in JSP to create user reports fetching data from the data warehouse.
· Created reports for managers using MS EXCEL with graphs.
Environment: Oracle 8i/9i, Unix Shell scripts, Reports 6i, Forms 6i, PL/SQL,DB2 UDB,MS ACCESS,SQL, Erwin, Autosys, JSP, Java, JDeveloper and UNIX and Win NT.
Wells Fargo Bank, San Francisco, CA Feb 2000 - Feb 2001
Online Business Banking and MIS
Programmer/Analyst
This system is developed and modified for various bank businesses like checking, savings account management, mortgage and other loans management, credit card accounts management and billing. Also it deals with online customer support like providing online banking, online email responses and checking/saving account management.
Responsibilities:
· Worked on maintenance of the existing MIS systems, modified schemas and stored procedures and triggers.
· Maintain two production databases and one development database.
· Provide ORACLE database support to Java/Perl programmers.
· Wrote ORACLE database triggers and stored procedures/packages in PL/SQL to implement business rules at the database level
· Migration of oracle database from 8.0 to 8i, Testing and documentation
· Wrote SQL/ Loader scripts to load data from a comma-delimited file into Oracle database.
· Created runtime tables and used dynamic SQL to insert into and fetch data from runtime created table.
· Designed & developed various interface programs for billing systems using PL/SQL Stored procedures.
· Involved in Data conversion from flat files to Oracle by using SQL Loader and Unix scripts.
· Created batch programs and complicated reports using Unix Pro*C and Shell scripts
· Worked on backend, created stored packages, triggers and procedures using PL/SQL.
· Created Java Stored Procedures, worked on JDBC, Oracle user defined types.
· Involved in front end designing & developing using Dev/2000 and created forms and reports.
· Involved in creating test plans and specifications, user documentation for the online banking system.
· Involved in writing low level program specifications.
Environment: Oracle 8.x/7.x, PL/SQL, SQL, Crystal reports, Windows NT 4.0, SQL*Loader, HTML, shell scripts, Solaris and HP-Unix.
Radian International Environment, Houston, TX Feb 1999 - Dec 1999
Health and Safety System
This is a medical system for the Intranet use; allows you to set up and record the result of medical exams, accidents and other activities that track the health and safety of the employees.
Responsibilities:
· Involved in designing the front end, created libraries and form templates using Forms 4.5.
· Involved in converting old Forms 3.0 forms on Unix terminals to GUI Forms 4.5 adding GUI features
· Created and modified Oracle stored procedures and database triggers using PL/SQL
· Created batch programs using Shell scripts and Pro*C to load data from flat files and create flat files to download data from database
· Created various HTML pages by converting Oracle Reports to Web pages using JSP.
· Involved in maintenance of the system, worked on resolving bugs created by users.
Environment: Oracle 7.3, PL/SQL, Devloper/2000 Forms 4.5, Reports 2.5 Sun Solaris 2.6, Windows NT
Kale Consultants Ltd, Pune, India Mar 1996 - Jan 1999
Clients: Continental Airlines, US, Air New Zealand, NZ
APEX- Automated Pro-ration Expert, Inward Billing System
Programmer/Analyst
APEX is a Pro-ration Engine. Pro-ration is the distribution of Air Ticket Revenue to respective regional sectors worldwide.
Responsibilities:
· Involved in creating interface, using Pro*C, between APEX, on Sun Solaris, and native system, which was on DB2/Mainframe.
· Created batch programs which load the air ticket data for Pro-ration from flat files (which are sent by other revenue accounting system) into the APEX database, with all necessary validations.
· Modified above Pro*C batch programs and interface to make portable to Continental Airlines environment later on.
· Worked on Shell scripting to automate the process of batch program executions on Sun Solaris system.
· Created database packages, stored procedures, functions and database triggers using PL/SQL.
· Created complex reports for Inward Billing System using Pro*C on Solaris system, later created batch programs using Shell scripts to automate time driven reports to be run in a batch.
· Developed front-end modules using Developer/2000 Forms 4.5 modified and added features in the Forms libraries.
· Involved in creating complex Forms involving multiple opened form windows
· Performance Tuning: Tuned and modified the SQL statements to avoid frequent calls to the database avoiding bottleneck of network.
· Involved in the testing phase, created test plans, did cross testing of modules, pro*c report programs, Forms created by other team members, among the team members.
· Involved in creating user documentation of the product, helped documentation team in order to specify the important business aspects to be mentioned in the user documentation.
Environment: Sun Solaris, K-Shell, Oracle 7.3, PL/SQL, Pro*C/C++, Developer 2000
*******************************************************************************
If interested in this candidate, please email us at rupa@simplion.com
This is in and around the bay area.
|
