TECHNICAL SKILLS:

ETL Tools : Informatica Power Center (8.6.0/7.x),
Business Objects Data Integrator 6.0
Business Intelligence : Crystal Reports XI and XIR2
Databases : Oracle 10g/9i/8i, MS SQL Server, MS Access
Programming Languages : SQL, PL/SQL, T-SQL, UNIX Shell Scripting, XML
Web Design : Dreamweaver, Vignette
Oracle Tools : TOAD ,SQL Navigator, SQL*Loader, SQL*PLUS
Office Tools : MS OFFICE 2000, Word Perfect, Corel draw
Operating Systems : Windows XP/2000/98, Sun Solaris 9.0/8.0, Red Hat Linux 8.0
Networks : Windows NT/2000/Server 2003
Webservices : SOAP UI,Webservice Hub(WSH), Informatica

EDUCATION

• MS in Computer Science
• Bachelor of Technology,

PROFESSIONAL EXPERIENCE

Confidential Columbus,OH August’09 – Till Date
Nationwide Insurance is a fortune 500 company and one of the world’s largest diversified financial services offering a full range of insurance products and financial services for home, car, family and financial security, including Auto and homeowners insurance Retirement plans. Mutual funds, Specialty investmentsHealth insurance. SPIA is Single Premium Immediate Annuity project which is a part of Individual’s Retirement Plan.

Responsibilities:

• Involved in Analysis, Requirements gathering and documenting Functional & Technical specifications.
• Analyzed the requirements and framed the business logic for the ETL process.
• As an active team member, involved in the initial phases of the design and was taken part in the analysis of the product.
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
• Worked with heterogeneous sources from various channels like Oracle, SQL Server, flat files, XML and web logs.
• Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Involved in the creation of oracle Tables, Table Partitions, Materialized views and Indexes and PL/SQL stored procedures, functions, triggers and packages.
• Created folders, Filters, Prompts, and Complex Financial Calculations in Framework Manager and Report Studio.
• Tuned Cube Builds Impromptu Reports and ReportNet Reports and servers for better performance.
• Created Charts, Lists and Crosstabs using Report Studio and adhoc reports using Query Studio.
• Analyze the source data structure and perform the Logical mappings.
• Responsible to tune ETL mappings to optimize load and query Performance
• Wrote UNIX Shell Scripting for Informatica Pre-Session, Post-Session Scripts and also to run the workflows.
• Involved in Performance Tuning of the mappings.
• Worked on ADMINSERVER , which is the product associated with major coding part of the project and help generating some adminserver activities.

Environment: Informatica Power Center 8.5.1/8.6.0 )Designer, Repository Manager, Workflow Manager), Cognos ReportNet 1.1, Cognos Impromptu 7.3, Impromptu Web Reports, Cognos Transformer 7.3, Cognos PowerPlay 7.3, Oracle 9i, Oracle 10g, SQL Server 2005, SOAP UI, TOAD, SQL Developer, UNIX Shell Scripts, Microsoft Visio 2007, Adminserver, UNIX, Windows 2000/NT.

Confidential Columbus,OH May’08 – August’ 09
ETL/Database Developer

iCube is State-of-the-art rule-based policy administration system that contains Nationwide Financial's Portfolio Inovator (PI) annuity product. PI product provides investors peace-of-mind by guaranteeing their investments in an entire portfolio, under volatile market conditions.

Responsibilities:

• Intensively worked on Informatica mappings and workflows which involved WebServices. Used Webservice Source and Targets, Webservice Consumer Transformations as a part of mapping
• Configured different kind of mappings and workflows using different sources and targets like Database, XML and Flatfiles
• Used different kinds of transformations like Expression, Joiner, SQL transofrmation, XML generator, XML parser, Router, Filter, Sequence Generator, Sorter, Union and Stored procedure and developed various mappings.
• Designed Major workflows and used Schedulers in order to kick off the workflows at the scheduled time.
• Worked on WebService Call through Informatica by generating and testing the incoming XML using external Freeware called SOAP UI.
• Used various Tasks like Control, Assignment, Timer, Event-Wait, Event-Raise, Email as a part of Workflow Logic as per the requirements.
• Design and develop Business Objects Data Integrator 6.0 jobs to extract data from various source systems and also involved in the support team and performance tuning.
• Worked on ADMINSERVER , which is the product associated with major coding part of the project and help generating some adminserver activities.
• Wrote Quote Site command(Shell Scripting) as a part of FTP’ing the Files to the mainframe region.
• Developed, designed and automate high level reports using Crystal Reports XI and XIR2 and also supported all the development.
• Developed SQL Views and used them in creating reports using Crystal Reports XI R2.
• Worked on creating PL/SQL Tables, Views, Stored Procedures, Triggers and Functions which are used in generating the Crystal Reports and also in the Informatica Mapping.
• Troubleshooting and Performance Tuning as part of Workflow/Mapping to optimize load and query Performance.
• Analyzed and framed the business logic for the ETL process as per the requirements.
• Worked on FTP as a part of Informatica Workflow.
• Involved in Migration of Informatica workflows/mappings from development region to Test and Production Environments.
• Developed documentations and user manuals for the Informatica mappings.

Environment: Informatica Power Center 8.5.1/8.6.0 )Designer, Repository Manager, Workflow Manager), BO Data Integrator 6.0, Oracle 9i, Oracle 10g, SQL Server 2005, SOAP UI, TOAD, SQL Developer, UNIX Shell Scripts, Crystal Reports XI and XIR2, Microsoft Visio 2007, Adminserver, UNIX, Windows 2000/NT.

Confidential IN
Graduate Assistant. Aug’06 to Jul’07

Responsibilities:

• Wrote SQL queries for the creation and modification of the data.
• Used PL/SQL Triggers for any in-appropriate data feeds by the users.
• Deployed the application on the network and made it access able to all users in the career services.
• Created new stored procedures/triggers and wrote SQL scripts for creating and modifying tables.
• Established Oracle database connection for Visual Basic application using ODBC Drivers based on TCP/IP.
• Implemented the usage of various reporting scripts to resolve conflicts during Replication.
• Documented the Backup Procedures and Replication Environment.
• Performance tuning of Oracle 8i database on Sun SPARC (includes optimization of UNIX kernel, Oracle init.ora, Oracle SGA, I/O balancing and memory tuning.
• Converted very slow and complicated views to tables and implemented database triggers to update them automatically.
• Implemented nightly backup routines, which include database exports, tape backup and copying database files to the development server for precautionary measures.

Environment: Sun SPARC, Oracle 8i Enterprise edition, SQL-Server, MS-Access, SQL, PL/SQL, UNIX Shell Programming, TCP/IP, Win NT 4.0, Win 98,

Lab In-Charge/ Developer Oct’05 to Jul’06

Responsibilities:

• In-charge of Computer lab which includes PL/SQL, Unix and other Database Concepts.
• Experience in Web Development/Design and Maintenance using tool called Vignette.
• Created databases for different applications keeping in view space & performance requirements
• As a Lab Assistant, trained developers/students to optimize PL*SQL Procedures and SQL queries.

Project developed as a “part of course requirement”.
Implementation of a MINI - Multithreaded HTTP Web Server for ORACLE Based applications.

• The HTTP server was designed for embedding into a chip. The mains purpose of this project was to take request from client browsers process them and send the response back to the client’s browser.
• This was developed on 'Linux' platform using 'c' language and socket programming.
• Used multi threading programming techniques in order to cater multiple users’ to simultaneously access WebPages.
• Used ORACLE as the backend connectivity and data storage.
• Wrote SQL and PL/SQL stored procedures in order to create database tables and to store data into tables.
• Used PL/SQL triggers in order to identify any erroneous data entered by the users.
• This project was designed to be platform independent in order to work on multiple operating systems.

Environment: ORACLE 9i, PL/SQL, SQL Server 2000, C-programming, Socket Programming, UNIX, Linux, networking protocols TCP/IP, FTP, Telnet, Load runner, HTML, DHTML.

Confidential, Hyderabad, India Jun’04 to Jul ‘05
Oracle Developer

Responsibilities:

• Responsible for the interaction with the client, collecting attributes, contribution in the analysis, and design and development phases of the system.
• Developed database tables for the products, parts and forms for monitoring goods moving inwards and outwards.
• Responsibilities included design the database and subsequent coding. Coding involved writing stored procedures and Triggers.
• Involved in Database Development Life Cycle including Analysis, Data Modeling, Mapping ER diagrams into tables, normalizing the relations and coding.
• Designed and developed a database system for customer maintenance using Oracle8.0
• Website development, maintenance using different web designing tools like Dreamweaver

Environment: Oracle 8.0, Developer 2000, PL/SQL, SQL*Plus, Dreamweaver, HTML, Windows 98/NT.