Experience Summary

• 8+ Years of Solid Software development experience of working with design, analysis and development of Internet, intranet applications, Database and client-server applications.
• Expertise in Oracle 8i/9i/10g/11g databases, SQL, PL/SQL and Informatica.
• Strong exposure to all phases of Software development life cycle (SDLC).
• Expertise in data integration, migration, cleansing and conversion from legacy systems using Oracle, SQL, PL/SQL, SQL Server, T-SQL and Informatica.
• Extensively worked on Extract, Transform and Load (ETL) to OLTP, ODS & OLAP systems using SQL, PL/SQL, SQL Server and Informatica power center.
• Extensively worked on SQL, PL/SQL, Stored Procedures, Functions, Packages, DB triggers, Indexes, Materialized views, Query Tuning, constraints, cursors and worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, Varrays, Records, Types, Dynamic SQL and Analytical Functions.
• Experience of Performance Analysis and SQL query tuning, response time reducing, while designing scalable applications from scratch and maintaining existing ones, using EXPLAIN PLAN, Hints, SQL Trace & TKPROF
• Strong ETL and data integration & migration experience in developing ETL mappings(SDE & SILOs) and script using powercenter designer(Source analyzer, Warehouse designer, Mapping Designer , Mapplet designer and transformation developer), Repository manager, Workflow manager and Workflow monitor and PL/SQL.
• Expertise in designing and developing mappings from varied transformation logic using filter, expression, rank, router, aggregator, joiner, lookup, stored procedure and update strategy.
• Robust knowledge in Data warehousing concepts like STAR Schema, Snow Flake Schema, Hierarchal dimensions, FACT Tables and Dimension Tables.
• Experience of working with DBMS_JOB, DBMS_SESSION, DBMS_SQL, UTL_FILE & UTL_SMTP.
• Experience data loading/unloading using SQL* Loader, External tables & Data Pump utilities.
• Robust knowledge of creating reports using RPDs, Answers, Dashboard and Delivers in OBIEE/Siebel Analytics.
• Experience in Logical & Physical Database Design, Development using Erwin & Power Designer.
• Experience in Dos batch programming, UNIX shell scripting and Scheduling using Autosys
• Testing and debugging the project for proper functionality and documenting by modules.
• Certified by Oracle as Oracle Certified Associate & Informatica Certified Developer (1 exam pending) by Informatica.
• Well-organized, efficient, quick learner with excellent ability to plan, organize, prioritize my work and to meet on time the deadlines.
• Energetic self-starter with excellent Investigative, Communicational, Analytical, creative and Organizational skills; Capable of adapting to new work environment and technologies in short term with a proven track record of producing outstanding results for client satisfaction.
• Technical documentation of different lifecycle deliverables and user manuals.

• M.SC (Computer Science).
• PGDCA (Post Graduate Diploma in Computer Applications).
• Bachelor of Commerce (B.Com).

• Oracle Certified Associate (OCA) by Confidential
• Certified in Oracle PL/SQL Fundamentals by Confidential

TECHNICAL HIGHLIGHTS

• Databases: Oracle 8i/9i/10g/11g, MySQL, MS Access 7.0, Sql Server 2000/2005/2008, PL/SQL, SQL
• DB Utilities: Toad, Toad for Data Analyst, Toad for Data modeling, Pl/Sql Developer, SQL* Loader, Oracle SQL Developer, SQL* plus
• ETL Tools: Informatica 7.1/8.6, SSIS, DAC
• Reporting: OBIEE
• Internet-Technologies: XML, XSLT, Java2.0, Servlets2.3, JSP1.2, HTML, JavaScript, JDBC 2.0, Java Beans, CSS, PVCS, VSS, SVN, CVS
• Scheduler: Autosys
• Operating System: Windows XP/2000/NT, UNIX
• Web/App Servers: Tomcat, Jrun, iPlanet, SunOne 7.0
• IDE/ Protocols: Jbuilder7.0, IntelliJ3.1, Eclipse3.0, Jcreator, WSAD
• Others: FTP, SFTP

Project Details
Jul' 10 - Till date
Confidential

Description
Confidential project is all about Introducing Model N to replace the existing applications for maintaining Contracts, Chargebacks, Historical sales and Government reporting. All contracts, Chargebacks, Territory, AHA, customer & products master and Historical sales data is to extract from legacy systems and load into the Model N system using various interfaces. Few ongoing interfaces are kept to source the master data from different systems.

• Responsible for Analysis, Requirement gathering, documentation, development and Testing.
• Developed ongoing interfaces to extract Territory & AHA information from Delphi system using Oracle PL/SQL and Pass to Model N via SAP PI middleware.
• Developed Oracle programs to extract Government price lists from CAS systems and pass to Model N in required csv format.
• Responsible for deciding data extraction and conversion strategies from E&Y tool (SQL Server database).
• Responsible for extracting and transform historical sales data from E&Y tool (SQL Server) and pass to Model N in required csv format. Developed SQL Server stored procedure, DTS (Data Transformation Services) package to extract sales transactions into csv files.
• Involved in data verification and validation process by providing various ad-hoc extracts from legacy systems as well as from E&Y for business.
• Handled all database development, Data extraction, Conversions, Verification and validations for multiple projects eq Phoenix, GPSC & Chexs.
• Led the team of four and worked as Single point of contact for all database related development & extraction activities.
• Developed Autosys jobs for scheduling ongoing interfaces.

Environment: - Oracle 9i/10g, SQL Server 2008, SQL, PL/SQL, T-SQL, DTS, SQL* Loader, Oracle SQL Developer, PL/SQL Developer, Autosys, Business Objects, SAP (PI, BW, SD, FI), Model N, EDI, C++, UNIX, SQR, TOAD, FTP.

Jul'10 - Sep'10 GPSC (Hospira India project)
Confidential

Description
The purpose of GPSC project is to load the historical complaints data into corporate data warehouse to provide the reporting. Complaints data is provided by the external vendors in the format specified by Hospira in separate data files eq products, complaints, event reactions, regulatory reporting etc. Oracle package was created to verify the integrity, load the data files into staging tables using Oracle supplied package and after cleansing/verification finally move to data warehouse. Reporting is done using Business Objects.

Role:

• Responsible for Analysis, Requirement gathering, documentation, development and Testing.
• Created oracle Proceudre/package to verify the files integrity and load data files using oracle UTL_File & execute immediate.
• Developed database objects staging tables, Views, Audit triggers sequences and configuration/control tables.
• Developed Package to move complaints data from staging tables to data warehouse.
• Proposed data verification & validation strategies.
• Developed config files load module to define the relationship between existing tables and data files.
• Created Autosys jobs to load config files, complaint files and move data from staging to data warehouse.
• Used advance PL/SQL constructs like external tables, Oracle supplied packages, Associative arrays, records & types.

Environment: - Oracle 10g, SQL, PL/SQL, SQL* Loader, Oracle SQL Developer, PL/SQL Developer, Business object, Trackwise, Autosys.

Nov' 04 - Jul'10 Ceded Reinsurance Accounting System (CRAS)
Confidential

Description
The Purpose of the application is to pull the direct Insurance data from any source (i.e. WPC-E, WPC-C, Jupiter, TRAC-PI etc) to automatically process and calculate ceded Reinsurance. The application pulls data from external sources eq Wpce, Wins & Cybercomp and calculates the Ceded reinsurance based upon the Business rules specified. Once Reinsurance is calculated reports are generated out of CRAS and information is sent to Finance to post against GL accounts. There were 6-8 extracts generated from CRAS which is sent to various teams including Finance. Apart from Regular processing CRAS also includes Conversion to convert the claims & Premium for acquired companies to CRAS based upon the business rules specified for various types of contracts that involve ETL development, Program changes and various report generations prior to finally move data into CRAS.

Role:

• As an Oracle/Informatica developer responsible for Analysis, Requirement gathering, documentation, development and Testing.
• Written informatica mappings, workflows for Incremental Jupiter, Single Treaty & Range of Treaty, Cybercomp data loading, Wpce data loading, Flat file data loading and manual booking refresh process using filter, router, aggregator, joiner, lookup, stored procedure, event wait, source qualifier transformation & oracle stored procedure using PL/SQL.
• Responsible for various treaty/fac contract conversions involving processing of huge data sets using PL/SQL & Informatica.
• Responsible for integeration of Cybercomp business into application starting reviewing source system, deciding data acquisition strategy, ETL development, Testing and stored procedure/function changes/creation.
• Designed & Implemented the solution for Reports module to implement the Staging tables
• Created stored procedures/functions, Informatica mappings/workflow to automate the Wpce, Wins & Cybercomp claim & premium processing automatically as soon as data loading is completed and implemented business rules at loading level
• Responsible for Complex Reports & ad hoc query writingused in CRAS application.
• Responsible for query tuning using EXPLAIN PLAN, TKPROF and SQL TRACE utilities.
• Worked on creation of external interfaces involving high volume of data to import and export.
• Responsible for data migration into CRAS coming from third parties. Eq fac/treaty direct data conversion to CRAS.
• Reviewed source systems and proposed data acquisition strategy to align with existing system.
• Written PL/SQL procedures, functions & packages to implement various functionalities in application E.Q. Treaty add/update, Fac contract add/update, Manual loss booking, Manual premium booking etc.
• Extensively used TOAD, Oracle SQL developer & PL/SQL Developer to create database objects E.Q. tables, views, procedures, function and database triggers to meet business requirement.
• Responsible for informatica mapping/workflow migration from version 7.1 to version 8.6 on development side and testing.
• Responsible for implementing database standards (SQL & PL/SQL code) suggested by Data Modeling team.
• Responsible for providing and implementing solutions to Bulk manual booking by doing database design and development.
• Worked on rewriting & changing the existing procedures to increase performance.
• Responsible for working with Business group to advice on Design and work/time estimation.
• Responsible for writing Batch scripting and Shell scripting.
• Created Materialized views to populate & refresh agents added.
• Documented business rules, functional and technical designs and test cases.
• Written DAO for fetching data from database and Involved in writing complex queries using sql.
• Worked on Reports to generate the Reports in web & Excel form Using JSP and third party component Jakarta Poi and written scripts to populate the month end reporting tables using informatica.

Environment: - Informatica 7.1/8.6 , Oracle 9i/10g, PL/SQL, SQL* Loader, Oracle SQL Developer, PL/SQL Developer, XML, iPlanet/Sun One 7, J2EE 1.2, Servlets, JSP ,MVC 2.0 , DAO, PVCS, VSS, Jdbc3.0, Connection Pooling , eBuilder, Kintana, Maximo ,Log4J , Jakarta POI for excel sheet generations.

July' 04 - Oct' 04 Recruitment Management System (LGRMS)
Confidential

Description
Recruitment Management System is build to manage all the recruitment process. The system facilitates recruitment process like generation of requisition by head of department, its approval from owner, creating recruitment plan against this requisition by HR, searching resume and interaction with consultant to fill the vacancies, sending mail to intimate short listed candidates, consultant, scheduling interview etc. There is separate module for consultant, he can see the job requirement and then send resume of candidates whose profile match the job requirement. In this project the brighter side is the implementation of J2EE technologies. Project is based on the MVC architecture. HTML/JSP is used for presentation, Servlet used as controller to capture the posted form data and further process it on server side. DAO is being used for data population and data insertion/updation respectively.

Role

• Programming JDBC connectivity
• Implemented the MVC architecture for the J2EE framework compliant to the Sun Specification (n tier framework).
• Written complex SQL queries to fetch data from various tables.
• Written Intermediate Java Servlet to capture the posted form data and further process it on server side.
• Created and maintained database objects E.Q. tables, views, synonyms and database triggers.
• Used Explain plan and worked on tuning of complex & time taking queries.
• Designing layout and coding front-end using JSP
• JavaScript and HTML for client side scripting.
• Worked on creating constraints E.Q. Primary key, foreign key, and Check constraint to implement business rules.
• Involved in designing tables and their properties.
• Performed unit testing
• Used request/response objects to capture the data coming from client forms.
• Worked on Recruitment module that includes all the operation of HR.

Environment: Java2.0, Servlet, JSP, JDBC, Oracle 8i, Apache Tomcat, Java Script, HTML, Java Beans, CSS, Netscape Communicator and Internet Explorer 4.x browsers
Database: Oracle 8i

May' 04 -July '04 Training Management System (LGTMS)
Confidential

Description
Training Management System is build to automate the process of Training of employees in all Branches at various levels in different programs. The project facilitates managing various trainings for their employees at different levels. LGTMS comprised of various modules some of them are Admin, Product, AC training, HR training, CS modules. MVC architecture is been implemented within the project where HTML/JSP/CSS are used at the view part, Servlets are used as controller, and DAO are used for data population and data insertion/updation respectively. XML files are been used for various configurations within the project

Role

• Programming JDBC connectivity
• Written SQL Queries for Generating Reports.
• Created and maintained database objects e.q. tables, views, synonyms and database triggers.
• Developed Dao for the Module having Complex SQL Statement.
• Worked on creating constraints e.q. Primary key, Foreign key, Check constraint to implement business rules.
• Developed JSP to Implement the Functionality.
• Involved in designing tables and their properties.
• JavaScript and HTML for client side scripting
• Used Tomcat as Web Server for deployment.
• Written complex SQL queries to fetch data from various tables.
• Performed unit testing.
• Developed Server-Side Java Servlets to capture the posted form data/ Session object and further process it on the server side.

Environment: Java2.0, Servlets, JSP, JDBC, Oracle 8i, Apache Tomcat, Java Script, HTML, IntelliJ Idea, Java Beans, CSS, Netscape Communicator and Internet Explorer 4.x browsers
Database: Oracle 8i

Description
This is an online site needed by CETMA for greater Coordination amongst its members. The members are Who's who of industry like Samsung, Electrolux etc. CETMA needed this site for development of business among its members as well to develop consumer electronic business. It also helps people in setting manufacturing unit by providing online as well as offline help this site has facility to download & Upload the research papers and publications.

Role

• Programming JDBC connectivity
• Written Intermediate Java Servlet to capture the posted form data and further process it on server side.
• Designing layout and coding front-end using JSP
• Worked on Event Module and Members Module.
• Written complex SQL queries to fetch data from various tables.
• JavaScript and HTML for client side scripting
• Performed unit testing.

Environment: Java2.0, Servlets, JSP, JDBC, HTML, JavaScript, Java Beans, Apache Tomcat, My Sql, Netscape Communicator and Internet Explorer 4.x browsers
Database: My Sql

OCT 2003 - MAR 2004 Educo Quiz
Confidential

Description
Educo Quiz is an online Learning program. Our current project is based on the MVC architecture, Servlets is used as controller. JSP, HTML, Flash and JavaScript is used at the front end in the Presentation layer. DAOs are used for modeling the data in the Model layer. One other component i.e Processors are been used for doing the business logic and responsible for returning the next URL for the view part to the Servlets. Oracle is used as database. All the data transfer between flash and JSP is done via XML Documents. This quiz is compatible to all standard browsers. In this project the brighter side is the implementation of J2EE technologies. I worked on Masters, Operation and Reports Module. In Masters Module, we developed different Master form for the creation of Question Master Work was to Insert, Update, Delete and to group the questions. In Reports Module, we need to generate different reports based on the configuration of the quiz.

Role

• Drawn flow charts to depict the functionality of the system.
• Designed and Coded HTML and JSP pages using Front Page.
• Written complex SQL queries to fetch data from various tables.
• Developed Server-Side Servlets and JSP to capture the posted form data/ Session object and further process it on the server side.
• Used request/response objects to capture the data coming from client forms.
• Used Type-4 (Thin Client) JDBC drivers to access data from Oracle database.
• Written JAVA classes to generate questions in XML format from the database.
• Written SQL Queries for generating reports.
• Done form Validations using JavaScript.
• Programming JDBC connectivity
• Performed unit testing

Environment: Java2.0, Servlets, JSP, JDBC, Flash 5.0, XML, Oracle 8.i, Jrun3.1, Java Script. CSS, Netscape Communicator and Internet Explorer 4.x browsers

MAY 2003 - OCT 2003 Material Accounting System
Confidential

Description
The Material Accounts System is the generalized system, which consists of many numbers of branches among different cities in different roots. This system consists of Transaction Module, Accounts Receivable Module and Stock Module. Transaction Module consists of taking orders, fulfilling the orders and maintaining the pending orders. Accounts Receivable Module consists of sending Accounts Receivable Orders and calculating total pending amounts. Stock Module consists of daily consumption details, automatic order generation for stock when it reached the reorder level. MVC architecture has been used for the flow of the project where servlets has been used as controller, JSP and html for the view part and DAO has been used in the modeling layer.

Role

• Responsible to program transaction module, Accounts Receivable Module.
• Created java classes for Order form for Transaction Module.
• Involved in the designing of tables.
• Have done form validations using JavaScript
• Coded Registration Page and authentication module.
• Developed Server-Side Java Servlets and JSP to capture the posted form data/ Session object and further process it on the server side
• Done form validations using JavaScript.

Environment: Java2.0, Servlets, JSP, JDBC, Flash 5.0, Oracle 8.i, Jrun3.1, Java Script, CSS, Netscape Communicator and Internet Explorer 4.x browsers

DEC 2002 - APR 2003 Library Management System
Confidential

Project Description:
The project is based on MVC architecture. The project has various modules like Student module, Books issue, Books received, acquisition module, admin module, reports etc. The project is fully based on MVC architecture. JSP, HTML, JavaScript are used as view part. Servlet is used as controller and Dao are used as model for database interaction like insertion, updation, and deletion operations. I worked on Student Registeration, Admin Module, Reports and acquisition module. Mysql is used as database.

Role

• Designed and coded HTML and JSP pages and done form validations using client side javascript.
• Involved in creation of Tables and views.
• Worked on Student Registeration, Admin module and generate various reports.
• Developed DAO for the modules having complex sql statements.
• Written sql queries for generating reports.

Environment: Java2.0, Servlet, JSP, JDBC, Tomcat, Mysql, Java Script, CSS, Netscape Communicator and Internet Explorer 4.x browsers

JUN 2002 - NOV 2002 Inventory Management System
Confidential

Project Description:
This software is developed for managing the inventory of export house. The System facilitates managing the stock level. The project is basically for an export house that deals in manufacturing and trading of bathmats, cushion covers and other handloom products.It includes managing the yarn used in manufacturing and other various activities like sending and receiving the yarn after dying process. Issue of dyed yarn and reciving the manufactured bathmats are maintained in the system. The project build using Java, JSP, and jdbc and client side javascript was used as validation. Mysql is used as database.

Role

• Involved in Creation of tables and constraints.
• Developed JSP and HTML used as Screens.
• Written DAO for interacting with database.
• Written sql queries for reports.
• Done form validation using javascripts.

Environment: Java, JSP, JDBC, Servlet, javascript, Mysql, CSS, tomcat, Internet Explorer 4.x browsers