Overview

• Overall 7 years of software development experience in Oracle and Java platforms. Proven ability to contribute to new business development efforts and achieve business goals. Executed successfully a number of Datawareshousing projects in insurance and financial domains. Worked in all aspects of SDLC--Requirements, development, testing, implementation and change management. Maintained focus on best practices and standards across all efforts.
• Certified Sun java Programmer and Oracle Certified Associate

Work and Technical Highlights

• Excellent communicator with the ability to communicate effectively along vertical and horizontal planes internally and in client organizations.
• Detail-oriented and able to manage and maintain all facets of complex assignments Solid technical leadership.
• Demonstrate the flexibility to work among diverse corporate environments, industries and technical and non-technical audiences.
• Working with The Hartford Insurance Group for their Data ware house system. Worked with Merrill Lynch on developing a Java-PLSQL based Tool.
• Worked 5 years on offshore onsite engagements.
• Involved in Requirement, Design, Build and testing phases of Project life cycle.
• Substantial database developer experience in creating stored procedures, PL/SQL Packages, Triggers and Functions
• Expert in advanced level SQL development using analytic functions.
• ETL and data integration experience in developing ETL mappings using Informatica Completed Oracle Certified Associate

Technical Proficiencies

• Platforms: Unix, Microsoft NT, Windows
• Languages : PL/SQL, JAVA, SQL,HTML, Visual Basic 6.0
• Databases: Oracle 8i/9i,11g,MS SQL Server 2005/2000, MS Access
• Tools : Toad 10.5, Query Analyser, OWB , Informatica 9.5,Crystal Reports 7.0, , MyEclipse3.0, Visual Studio,LOG4j, CVS Source Control, Workload Control Center for AUTOSYS

Work Experience

The Hartford Insurance

• The Hartford is a Fortune 500 company and one of America's largest investment and insurance companies. This company is a leading provider of life insurance, group and employee benefits, automobile and homeowners insurance and business insurance - as well as investment products, annuities, mutual funds, and college savings plans.
• Working as a Datawareshousing developer for Commercial lines insurance. I am part of program that develops an analytical rating engine tool ARE for Actuarial team. I have done several datawarehouse projects of Commercial Line ETL frameworks, mainly at Pricing and rating assement areas. Involved in the project that handle huge table data.
• Played a role of PL/SQL developer and involved in analysis, design, and build phases of the project.
• Participated in project planning sessions with project managers, business analysts and team
• members to analyse business requirements and outline the proposed solution.
• Created a dataset in datawareshouse from different sources which are incrementally refreshed. Used Informatica 9.5 mappings to read the COBOL files and flat file to database.
• Used Metadata tables, dynamic SQL in PL/SQL packages and triggers to move data from WORK tables to till persistent tables.
• Created new jil files establishing new batch process
• Used Workload Control Center tool to to import and perform and monitor different actions on batch job/boxes
• Developed a PL/SQL tool which utilized partitioned table to for each request in Oracle 11g.
• The users use a GUI webpage to submit the request and interface shell script program will invoke the package.
• Monthly batch job has been set up to do datacopy and maintaining the table partitions. Used Subversion to maintain the code version history.
• Used Quality Centre to track the defects/clarifications at the time of Integration , QA and UAT testing phases

Environment: Oracle 11g, Informatica 9.5, WCC 11.3, Putty, Toad, SQL Plus, QC

confidential

• Integrated Information Repository is data ware house which provide an integrated, consistent and efficient repository to perform reporting and data analysis. It has numerous sources that feed a multitude of transformations and loading processes which in turn are put to a process to load multiple Data marts
• Played a key role in Requirement, analysis, design and build phases for projects in data ware house system.
• Actively involved in discussion with Client partners on requirement and designs Preparation of Technical Impact analysis and design documents for the projects. Worked with Data modellers to finalise the data structures.
• Actively involved in Project discussion with different teams.
• Written triggers, Packages, Stored procedures, Functions, mat views for various projects in Individual annuity space for IM.
• Worked with Toad to do impact analysis and PL/SQL coding.
• Worked in OWB tool for creating mappings for data warehouse that replicate and transform data from source to target.
• Coordinated with DBAs to implement structures and compile the code in different environments. Scheduled jobs in AUTOSYS execute the mapping and procedure for data replications
• Hands on experience in Informatica tool for creating mapping.
• Used Crystal and web ii reports to develop and print out annuity reports.
• Hands on experience on Business Object tool to create universe, objects and reports in Infoview from it.
• Performed Unit and Integrated testing.

Environment: Oracle 9i, Oracle ware house builder OWB ,Informatica 8, Toad 6.3, SQL Plus, Crystal

Report 7.0, BOXIR3.

confidential

• Worked as a PL SQL developer with NasTech Services for one of their client. Project is to create a module for financial services. This project extract data related to contracts from various partner systems and aggregate in data mart for reporting.
• This system is developed in PL/SQL and OWB mappings with batch jobs scheduled in AUTOSYS. Crystal reports are used as the reporting tool to generate reports using Autosys as the scheduling tool.

Key Job Responsibilities:

• Played a key role in Requirement analysis, development and maintenance of IM System. Preparation of Software Requirement Specification for the projects
• Written Packages, Stored procedures, Functions for various projects in Individual annuity space for IM.
• Worked for database maintance and management using PL/SQL. Expertise in database TRIGGERS to perform specific operations Created user defined EXCEPTIONS as per project requirements.
• Expertise in JOIN to query multiple tables.
• Used analytical functions such as RANK, DENSE RANK, to reduce complexity and improve SQL performance fro new project and existing system.
• Performed bulk operations using Collections, BULK COLLECT and FORALL Scheduled jobs in AUTOSYS.
• Worked in OWB for creating mappings for data warehouse. Used Crystal reports to develop and print out annuity reports. Performed Unit and Integrated testing.

Environment: Oracle 9i, Oracle ware house builder OWB , Toad 6.3, Crystal Report 7.0

confidential

SQL developer

• Merrill Lynch's Global Markets Investment Banking GMI is one of the world's leading providers of institutional sales and trading, investment banking advisory and capital raising services to corporations, governments and institutions worldwide.
• CORTEX is an automated regression tool developed to test business functionalities for various middle and back office systems for an investment bank in the UK. Cortex builds test data, executes test cases, stores the test results and generates test report details.
• Web Cortex application provides the simplified and the easy to use GUI for the users to create their
• scripts for automating the functional and regression testing the application. It is designed to handle both the GUI and NON-GUI based applications..

Key Job Responsibilities:

• Had Regular interaction with clients and prepared Requirement Analysis Document Had developed reusable components in java.
• Played an important role in all java developments involved in project.
• Worked with invocation of automated tools like STAF and STAX from the application. Extensively used reflection package to make runtime invocation of various classes.
• Developed java classes and defined the various configuration files for automating the test process.
• Used SAX Parser to parse xml file in java class.
• Used JDBC connectivity to connect with databases.
• Written SQL queries on SQL Server and Oracle databases.
• Created stored procedures on Oracle database which are invoked from java classes. Created database links to use objects in another database.
• Worked in Visual Basic 6 for Reporting components Performed Unit Testing and integration testing.
• Participated in Code review and bug fixes. Used Log4j for logging.
• Maintained version control for changed/released sources using Visual Source Safe VSS .

Environment: Eclipse 3.1, Query Analyser, Toad 6, Visual Studio, Visual Source Safe VSS Windows NT, SQLServer2000,Oracle 9i database

confidential

• Worked as a software consultant for various customers in Java, and oracle technologies.
• Some of the key projects are,
• Web based application for nation's largest healthcare strategic alliance enterprises. I was involved in
• developing a web based application, Operations Advisor Productivity. It enables healthcare organization
• to maximize employee productivity and performance, reduce labour costs, and align labour decisions
• with strategic objectives. It does this by providing managers with critical information for optimizing the
• number of worked hours and the cost of those hours, organization to balance productivity, cost, and quality.

Key Job Responsibilities:

• Developed the application using web work framework.
• Developed Action classes for web pages to implement the business logic in core Java. Used Hibernate for OR mapping with database.
• Wrote hibernate query HQL and used hibernate criteria to access database.
• Created stored procedure and functions which were invoked in java application
• Created simple to complex queries involving JOINS and sub queries on multiple tables. Used MyEclipse3.0 as IDE to implement the module.
• Deployed Jsp, action classes on Tomcat server. Used Log4j for error logging .
• Utilized subversion as a version control system and for code management.

Environment: Windows XP, JDK 1.4, HTML, JSP, Webwork Framework, webwork tags libraries, display tags, Hibernate 3, MyEclipse3.0,Tomcat , Oracle 9i, toad, LOG4,Subversion

Deposit module conversion project is a replacement of an existing system into Java technologies for one of the regional banks in NJ. The replacement system performs all banking transactions, create new account, and perform batch work that is used by bank's customer service representatives.

My responsibilities were developing pages for deposit module of the application.

Key Job Responsibilities:

• Developed action classes in Strut framework.
• Created a set of user defined functions which are used in business SQL queries Implemented DML statements to modify database tables through java classes. Used DAO to access Oracle database
• Used Web Sphere Studio Application Developer as IDE

Environment: J2SDK 1.4, J2EE 1.3 Java, JSP, XML, JDBC, Servlets and JSP , Struts, SQL, JDBC, oracle 9i Web sphere Studio Application Developer, Web sphere application server 5.1, Windows XP

confidential

Software Engineer

GJ Infotech is a leading software company that develops application projects, for school and supermarket accounting system. This is a Client Server application for super market. Applications developed in Visual Basic 6.0, with MS access and SQL server.

Key Job Responsibilities:

• I have been working in a team designing and developing Client Server application for super
• market. This application perform The applications developed in Visual Basic 6.0, with MS
• access and SQL servers as database
• Participated in system development, analysis, testing, and implementation. Responsibility for the testing and debugging of programs
• Direct responsibility to update, repair, modify and expand existing programs and applications Modified and upgraded database systems to suit company requirements

Environment: Windows XP, Visual Basic 6, MS Access, Sql server.