PROFESSIONAL SUMMARY:

Advanced Professional with over 8 years of experience in database design, database development, data analysis, data mining , data migration, data modeling, report generation and package creation in Financial, Educational, Healthcare and Insurance industries with an extensive experience on Oracle RDBMS 9i/10g/11g and SQL Server 2000/2005/2008 as Oracle PL/SQL Developer using different platforms like Solaris, Linux and Windows.

• Experience in Database Development such as Creation of Databases, Tables, Stored Procedures, Triggers, Views and Functions using Oracle 10g/11g and SQL Server 2000/2005/2008.
• Extensive ability on Data modeling tools Erwin and UML.
• Experience in ETL methodologies for supporting Data Migration, Data Exchange, Data Transformation using Informatica Power Center v 9.x/8.x Suite and SQL Loader.
• Hands-on experience with Oracle Forms/Reports 10g/11g, SQL, PL/SQL, Open Interfaces, and APIs.
• Experience in using tools like Index Tuning Wizard, SQL Profiler and Windows Performance Monitor and Oracle Hints for Monitoring and Tuning MS SQL Server/ Oracle queries for Performance Tuning.
• Experienced working on PERL and Korn Shell scripting.
• Extensive knowledge of Oracle Real Application Clusters RAC database and parallel database processing.
• Extensive ability to provide 24/7 production support and resolve critical data related issues promptly.
• Extensively worked with Pentaho ETL Tool to create Positive Pay Files for Banks.
• Effectively handled 24/7 production oncall support.
• Worked on High profile Data migration project from Solaris server to Linux server.
• Worked on Oracle products using Oracle Developer Suite 10g.
• Experienced working with Team Foundation Server,Harvest Workbench, Clearcase, SVN for source control.
• Experienced in IBM Tivoli Workload Scheduler Maestro , CA ESP Workload Automation ESP to schedule, create new batch jobs in development, testing and production environment.
• Experienced leading the projects in Agile Software Development Life Cycle SDLC projects.
• Worked with Microsoft Outlook and IBM Lotus Notes for office email communication.
• Extensively involved in data extraction and loading using DTS from Oracle Database.
• Entensive ability to debug Java, ASP.net and C .net.
• Experienced in developing web and client/server applications using Java, Web Services and ASP.NET

TECHNICAL SKILLS:

PROJECT PROFILE:

1. Private and Public Sector Growth Strategy Development:

Project Description:

Confidential is one of the largest financial and insurance companies in the world. Nationwide offers excellent Retirement Solutions to the customers. This project involves building Financial Private and Public Sector Growth Strategy projects like Investment Solution Builder ISB , Flexible Advantage product, Group Fixed Annuity, Default Annual Enrollment projects. The project has performance tuning and optimization of existing processes. The project also has Retirement Plans Private and Public sector On Call production support 24/7, creating ad-hoc reports, fixing keynote production defects and Migration project from Solaris to Linux.

Roles and Responsibilities:

• Data designed PL/SQL blocks, packages, procedures and functions for the Private sector and Public sector growth Strategy project.
• Extensively worked on DDL statements in complex Keynote database schema.
• Extensively worked on TOAD, SQL Developer and DbVisualizer to develop, test SQL scripts.
• Worked on DcDirect reporting environment 24/7 by being On Call and debugging the issues promptly.
• Worked on ERwin data modeler for physical and logical representation of complex database schema from business requirements and also for creating new table, indexes and constraints scripts in schema.
• Worked on UNIX platform VI, VIM , GVIM, Hummingbird Exceed editors to develop PL/SQL, UNIX shell scripts and SQR scripts.
• Extensive ability to debug, root cause analysis, troubleshoot and performance tune complex PL/SQL issues and Java Coding issues, and the ability to reverse engineer existing PL/SQL code, Java into functional requirements as part of 24/7 support.
• Performed the Unit testing and System testing of the code and prepared System test document.
• Developed Informatica components and Sql loader to generate daily extracts from staging to DW tables.
• Worked on complex COBOL, ProC modules involving transaction logic to process different types of transactions in the daily batch jobs.
• Worked on Business Objects Webi upgrade from 3.0 to 4.1.
• Worked on Database concurrency project for RAC database conversion.
• Worked with XML Schema to load custom columns for Employment Claim Cases.
• Used Maestro Scheduling Tool Tivoli Work scheduler , CA ESP Workload Automation and CICS explorer to schedule daily jobs and monitored them till completion in development and testing and pre-production environment.
• Worked on all phases of Agile/Scrum SDLC with minimal guidance.

2. Enterprise Report Development:

Project Description:

enrollment. The University has their own data-driven reporting website which hosts the academic and financial reports. This position was involved in maintenance of all the student financial databases.This includes generation of new and ad-hoc financial reports

Roles and Responsibilities:

• Built appropriate stored procedures in SQL Server Management Studio and Oracle database queries which provide report content to implement technical design specifications.
• Developed and modified technical designs for requested reports, working from functional designs provided by Administrative Application Systems AAS business analysts.
• Implemented technical design specifications through entries in tables using SQL Server Management Studio which created and configured report pages for a data-driven reporting website.
• Extensively worked with Dynamic SQL stored procedures to generate the reports in data driven website.
• Followed Office of Information Technology OIT development methodologies and practices.
• Provided Oracle database object suggestions to improve performance for poorly performing queries.
• Developed modules using PERL shell scripts on Oracle database to implement batch processes for late running financial reports.
• Worked extensively with Oracle Reports 10g for the generation of new student financial reports.
• Extensively worked with Oracle HINTS, Materialized Views, FORALL and adding Indexes to tune the report queries.
• Experienced working with TOAD 9.1 with the Execution Plan and Optimization techniques to increase the performance of the reports
• Developed , exercised and documented test plans to ensure developed code meets specifications.
• Experienced working with reporting queries in Data/table- driven reporting website.
• Submitted the status report every week to explain the progress of the project.
• Worked closely with the performance team to help enhance the performance of report queries

3. Data Analysis at Regulated Legal Claim Cases.

Project Description:

and Security Claim Cases. Some of the Regulated clients include Bear Stearns Fund Family, Putnam Outreach, Janus Capital, Merrill Lynch Investments and Prudential Fund Family. This position deals with Claim Forms Processing which involves Data Processing of Claim Forms submitted by Clients, primarily in manipulation and processing of Regulated Claim cases.

Roles and Responsibilities:

• Loaded data to different staging databases of the company like Name and Address Staging NAS , Custom Staging, Transaction Staging, ISIS1, ISIS2 using the complex dynamic SQL statements.
• Did lot of manual transformations on Excel Files, Text Files using UltraEdit-32 for Intake into Staging.
• Wrote Oracle scripts to insert, update the data from one staging table to another staging table.
• Extensively worked on writing PL/SQL queries to join the tables from different databases and retrieve the information.
• Experienced in working with DTS packages using DTS Designer.
• Worked using Oracle Warehouse Builder 10g to load the data from Source to different staging databases.
• Head of the Reporting Team comprising of 5 members to generate and deploy the reports for the Clients using Oracle Forms.
• Extensively worked on UNIX operating system and client server environment to process the claims submitted by Claimants.
• Hands on Experience on Oracle Reports 10g with generating reports for the payroll and time entry in the company.
• Generated Ad-hoc Reports using report builder for the Employment claim cases.
• Used Parameterized reports for generating reports involving City, State and Zip fields.
• Used ETL Tool Pentaho BI Enterprise Edition to create Positive Pay Files PPF s for sending to different Banks.
• Wrote some complex scripts to pull Distribution Files from different staging tables to send the checks to respective persons.
• Did lot of work on Parsing the data and wrote some complex queries to achieve that.
• Worked with Stored Procedures and Functions for data processing.

4. HealthCare Insurance Benefit Program:

Project Description:-

Confidential is a unique national managed health care company that offers comprehensive services to customers across the country in all 50 states and also District of Columbia and Confidential. Serving the group health, workers compensation and state public program markets, and our core competency is managing total health care insurance costs while educating and empowering consumers. Involved in developing the backend for the Health Insurance customers.

Roles and Responsibilities:-

• Developed complex T-SQL code for the application conversions.
• Created Stored Procedures, Triggers, Views and Functions for the Application.
• Extensively worked on Terabyte databases for the health program.
• Transferring the data from SQL server 2000 to SQL Server 2005 using SSIS.
• Created SSIS packages to gather data from various sources.
• Wrote the Letter Extract Functions and Stored Procedures in SQL Server 2005.
• Wrote the stored procedure to call the Functions.
• Migrated data from legacy Database in SQL 2000 to SQL server 2005.
• Developed complex stored procedure using T-SQL to generate Ad-hoc reports using Business objects and SSRS.
• Worked on Extracting, Transformation, Loading ETL tools for loading the data.
• Performed data transfer and database transfer for server relocation using DTS.
• Worked with DBA to set-up the security roles for developers and end-users.
• Extensive testing on the Performance of the Stored Procedures.
• Created Triggers to enforce data and referential integrity.
• Developed ER diagrams and mapped the data into objects to modify the database and created alerts for error reporting.
• Utilized various VB.Net validation controls for data entry validation on the front end and achieved user interface.
• Merged data into a single server environment to have better control, consistency and security of data using SQL Integration Services SSIS .