Summary

• Worked for CRO Clinical Research Organization .
• Worked on Debug and Review the PL/SQL code.
• Used supplied packages to extend the functionality of PL/SQL programs such as DBMS JOB for scheduling, UTL FILE to read and write from database.
• Knowledge about Oracle RDBMS 10g, 9i, 8i in the strong development.
• Extensive worked on OLTP environment and good understanding of DSS system.
• Exposure of Golden Gate technology in Oracle.
• Extensive experience in Oracle Streams Replication.
• Extensive skills experienced in forms and reports.
• Demonstrated analytical ability to understand the business requirement/process, convert the business specification to technical document, data management, develop and integrate solutions to meet the Clients custom requirements
• Experience of Data Warehouse Architecture and Designing Star Schema, Snow flake Schema, FACT and Dimensional Tables.
• Worked on new feature of Oracle 11g
• Extensive skills experienced in writing PL/SQL Packages, Functions, Procedures Triggers to implement the business logic.
• Directly interact and coordinate with other departments and teams of the company to expand the product features and innovate.
• Expertise in technical documentation, developing technical specifications, user manuals etc
• Experience in full SDLC Dev. using Agile/Rapid Software Development Methodologies, from HLD, DD, Test Plans, Coding then Unit String Testing and providing support in Integration System Testing and Defect Fixing to Production Support
• Expertise in Programming with Oracle 11g/10g, working on Very Large Scale Databases including OLTP, DWH and ETL environments.
• Seasoned and experienced professional with 7 Years of challenging professional experience in the area of PL/SQL and SQL on UNIX platforms from concept to implementation stage in many breakthrough initiatives in the financial services market and healthcare Domain.
• Worked Database links and materialized views.
• Worked extensively on Query Level Performance tuning using Explain Plan, SQL Trace and TKPROF utilities to pin point time consuming SQL's and tuned them by creating indexes and forcing specific execution plans.
• Solid Experience in SQL queries, exception handlers, Cursors, PL/SQL records tables.
• Worked on Global Temporary Tables, Partition Tables.
• Strong work experience with tool like DBArtisan, Toad, PL/SQL Developer, Oracle SQL Developer.
• Good understanding of the Oracle Architecture.
• Worked on latest features of Oracle 10g.
• Ability to understand Functional specifications, Business requirements and technical Design documents.
• Extensively involved in System Analysis, Client-Server Software Architecture, Application Design, Development and Implementation of database systems SDLC .
• Good understanding of SQL tuning parameters.
• Knowledge of Oracle DBA activities.
• Good team player, Self-motivated, quick learner.
• Excellent communication and interpersonal skills.

Technical Skills

Confidential

Professional Experience

Confidential

• Confidential delivers business automation and process solutions that transform how health plans conduct Commercial, Medicare, Medicaid and Accountable Care Organization ACO business. IKa's solutions automate key processes for sales, marketing, regulatory compliance, claims administration, customer service, quality management, and revenue optimization all on an integrated, Web-based platform that's fast and scalable
• Confidential is to assist medical record reviewers and providers in coding diagnoses correctly, and achieving a precisely correct diagnosis is a critical provider function and contributes importantly to appropriate management and treatment decisions. By doing this, this enhances the quality of health care delivery which has the potential to reduce costs significantly.
• Confidential is a system used to provide information for a risk adjusted payment under the Centers for Medicare Medicaid Services Hierarchical Condition Category CMS-HCC payment model. The specific goal of risk adjustment is to pay Medicare Advantage MA and Prescription Drug Plans PDPs accurately and fairly by adjusting payments based on the demographics and health status of enrollees.
• Risk adjustment is an important factor in this process and communicating risk adjustment requirements to providers can help to improve the quality and quantity of data submitted by MA organizations. It also helps the providers understand the importance and impact of accurate coding and documenting medical records properly as well as data validation.

DM/CM Case and Disease Management :

• The ikaSystems Disease Management-Case Management module is the next-generation solution for data driven
• disease management. ikaDM pulls information out of medical records and places critical clinical metrics
• directly in your hands. Customer-centric collaboration and transparency come alive with Web-based
• workflows and current information delivery, enabling dynamic care plan management.
• The ikaSystems Disease Management ikaDM software engine and rules analysis quickly determine which
• medical management program is best for each member.
• Stable members receive access to educational materials and other self-management tools.
• Member needing additional focus can be assigned to nurse case managers who have access to the
• ikaDM clinical tools: treatment protocols, care plans, tracking tools, and educational materials.
• Stratification is user configurable, and health plans also have the flexibility to add disease and identify
• criteria and parameters for tracking clinical progress. With ikaDM, highly skilled nurses are used only
• where they are most needed the system is an effective, efficient substitute for those whose
• conditions are under control.
• The ikaSystems Case Management ikaCM module is a comprehensive case management solution that
• optimizes resources while ensuring no essential information slips through the cracks. ikaCM employs a multifaceted
• approach to rapidly and accurately identify members. Next, various assessments support patients and
• case managers as they establish care plans and work toward Problems. Comprehensive web-based
• coordination tools include, 3 staged transition of care, scheduling, and personal health record and reporting

Support.

Title: Sr Software Engineer

Responsibilities

• Created users privilege and managed user roles and grants.
• Resolved various optimizing problems to maintain high level of customer satisfaction.
• Managing tables , indexes Tree and Functional , constraints, views sequences, synonyms and stored program units
• Responsible for the development and implementation of hundreds of Interfaces and Data Extracts
• Created SQL Loader Control Files for moving data from Flat Files Fixed Record Length to Staging Area Tables.
• Written complex sql queries for data warehousing.
• Provide Database support and enhancements for Regular DB Product Releases across multiple clients
• Implementing Ika Health Exchange Platform HIX . Leading the implementation and development for the IKA Health Exchange Platform Reports like Call Center, Correspondence, Member Plan change, new member added, EFT Letters from a HIX perspective.
• Exception Data Load Logic, Concept Development and Implementation.
• Manage the DB development team and mentored junior team members in technical and business aspects
• Transforming Clients Legacy System data and Loading years of data into the OLTP DB's using complex SQL Loader routines.
• Work closely with Clients and Business analysts to fully understand business requirements and come up with the design.
• Created Stored Procedures, Functions, and Triggers to maintain various business rules.
• Responsible for Optimizing the Code, performance Improvements and Code standardizations.
• Analyzed the existing Stored Procedures, Functions, Triggers and Cursors. Worked thoroughly on performance issues.
• DBMS Jobs to automate jobs and loading data into the Database using SQL Loader.

Environment: Oracle 11g/10g R2, HP-Unix, Oracle Enterprise Manager, VSS, SQL Loader, SQL Plus, PL/SQL, .Net.

Confidential

• This project is based on CRO Clinical Research Organization Application developed by Kendle International Inc work on studies from early stage to late phase.
• TrialWatch TW is Kendle's Proprietary management information system that standardizes the collection, management, and distribution of project data.
• There are 3 components of the system, TW-PM, TW-RG and TW-CM.
• TW-PM is the Project Management application of TW. You can access high-level study information, milestones, enrollment metrics, study security, and summary information.
• TW-RG is the Regulatory application of TW. You can access information on Sites, Site Personnel, Regulatory Documents, the Contact Log and a specialized report tool called the Tracking Profile.
• TW-CM is the Clinical Monitoring application of TW. You can find primarily subject specific information, and tools for writing monitoring reports. CM also has an offline capability.
• TrialReport is a Web Based Enterprise Reporting System. TrialWatch reports can be accessed by launching TrialReport.

Responsibilities

• Extensively used Replication improves performance and increase availability of applications.
• Understand the customer requirement, project planning and timeline management.
• Written complex procedure the update conflict handler scripts.
• Setup Bi-directional oracle streams replication.
• Create project and product definition documents such as functional specifications, database layouts, project plan.
• Analyze business processes and application requirements to produce formal analysis and Technical design documents.
• Extensively worked towards optimizing the query to enhance the performance.
• Develop the security model of the project.
• Design schema as per the requirement like, table, indexes, partition table.
• Worked on different application like Trial Watch, Trial Base and Trial Line.
• Developed complex bridges between Trial Watch and Trial Line with the help of PL/SQL.
• Analyzed indexes on regular basis.
• Develop the Design Strategy, Architecture/Database Design, Data Flow Diagrams, Program Flow Charts, Entity Relationship Designs, UML and Sequence Diagrams
• Created Unix Job for scheduling Bridges to migrate data between two databases.
• Developed query for business reports like PM, site level, study level
• Created SQL Packages, stored procedures, functions, triggers and views using PL/SQL/T-SQL
• Performance tuning and optimization of complex SQL queries using database table joins
• Data extraction in oracle and MS SQL Server.
• Created SQL Loader Control Files for moving data from Flat Files Fixed Record Length to Staging Area Tables.
• Analyzed the existing Stored Procedures, Functions, Triggers and Cursors. Worked thoroughly on performance issues.
• Demonstrate the analytical ability to understand the business requirement/process, convert the business specification to technical document, data management, develop and integrate solutions to meet the requirement.
• Resolved various optimizing problems to maintain high level of customer satisfaction.
• Implemented triggers based on the business rules
• Created users privilege and managed user roles and grants.
• DBMS Jobs to automate jobs and loading data into the Database using SQL Loader.

Environment: Oracle 9i/10G R2, HP-Unix, Oracle Enterprise Manager, VSS, SQL Loader, SQL Plus, PL/SQL, .Net, Toad Data Modeler.

Confidential

Pearson Success Maker Enterprise

This project is based on E-Learning Application developed by Pearson Education system Project development and testing environment deployment on internet via Web logic clustering, using web service like apache, has physical load balancer, has an oracle database, which is on Solaris environment. This project functionality is to registration of the student and teacher and courses for the student as per the standard.

Title: Sr. Oracle Developer

Responsibilities:

• Involved in developing SQL Loader scripts for data loading.
• Extensive use of performance tools like AWR, TKPROF and Explain plan for performance monitoring and troubleshooting.
• Wrote Unix Korn Shell scripts for hot backups, SQL Loads, export and import of database
• Expertise in SQL loader and PL/SQL programming for reporting and bug fixes.
• Worked on data warehousing complex queries to generate reports.
• Developed PL/SQL Packages, Functions, Procedures, and Triggers to implement the Business Logic.
• Planning, capacity and timeline management for SMe modules.
• Involved in the optimization of Oracle queries/scripts which resulted in substantial performance improvement for the conversion processes using Oracle Hints, TKProf, Explain plans and Trace sessions.
• Debug the PL/SQL Procedures, functions code with the help of Oracle Packages and third party tools.
• Involved in Schema creation and management.
• Created the Production Readiness checklist for Pre and post-production support
• Rebuilding the index for performance of SQL Queries with the help of INDEX STATS.
• Worked with application team at the time of deployment application on server.
• Managing Partitioned tables and Indexes for efficient and robust access of database objects.
• Extensive on PL/SQL Tables, records and collections as per the business requirement.
• Involved in user creation and user access control.
• Involved in Technical Documentation, Unit test, Integration test and writing test plan.
• Used Shell Scripting to automate and schedule job.
• Involved in Efficient Configuration of Access Policies through Roles and Privileges.
• Wrote test database script to test the development environment before deploy to production.

Environment: Oracle 9i/10G R2, HP-Unix, Linux Red Hat 9, Oracle Enterprise Manager, Win CVS, SQL Loader, SQL Plus, PL/SQL, JAVA, Struts, Web Server, Toad Data Modeler, PL/SQL Developer.

Confidential

Pearson Success Net

• This project is based on E-Learning Application developed by Pearson Education system
• Project development and testing environment deployment on internet via Web logic clustering,
• Using web service like apache, has physical load balancer, has a oracle database, which is on solaris
• Environment. This project functionality is to registration of the student and teacher and courses for the
• student as per the standard.

Title: Sr Programmer Analyst

Responsibilities:

• Production DBA 7 24 Support in highly paced and dynamic environment.
• Schema Management and control, Synchronization of Production and Test environments.
• Leading member of Performance Tuning Task Force for Proactive Tuning and monitoring of Very large databases Multi Terabyte Databases
• Performed Sybase Replication.
• Extensive use of Data Pump for refreshes of Lower environment from the Production Boxes.
• Involved in setting up of Resource Manager for the Production environment.
• Lead Performance and Tuning Task Force for proactive performance monitoring.
• Extensive use of performance tools like AWR, TKPROF and Explain plan for performance monitoring and troubleshooting.
• Expertise in SQL loader and PL/SQL programming for reporting and bug fixes.
• Worked on data warehousing complex queries to generate reports.
• Generated Excel based reports from .dqy queries for generating Performance and Database Reports.
• Architecting the Alert systems for Database activities.
• Involved in Efficient Configuration of Access Policies through Roles and Privileges.
• Involved in capacity planning and enhancements.
• Coordinated with UNIX group for space reclamation on Server by reorganizing the tablespaces.
• Managing Partitioned tables and Indexes for efficient and robust access of database objects.
• Wrote automated scripts for tracking and validating invalid objects in Database.
• Coordinated with business consumers of data to formulate Backup Schedules.
• Devised and implemented Backup and Recovery policies.
• Worked on Enterprise Manager Control grid clients for Database Target management.
• Worked on Change Management tools like Clear Case and Remedy for controlling,
• Tracking and monitoring Production environment changes.

Environment: Oracle 9i and 10g, OEM, RMAN, Erwin, SQL Loader, SQL Plus, PL/SQL, Windows 2000, Win CVS, UNIX Sun Solaris , Shell Scripts, JAVA, Java Script, TOAD, PL/SQL Developer

Confidentialis designed for tracking bounce cheques details against the bank statement. Various MIS are getting generated through this application as an input to other applications like Finnone and RECON. For e.g. the bounce cheques details are downloaded from Web bounce system and uploaded to Finnone to mark cheque return in individual retail Loan accounts to levy the charges.

Title: Software Consultant

Responsibilities:

• Involved in Installation and customization of Databases 10g 9i for the PLM setup
• Design Evaluation and Analysis of data model implemented for PLM
• Remote monitoring and tuning of Database Processes in the Client environment
• Transformation of Data in Data Mart
• Supported production environment on 7 24 bases for Extraction, Loading and
• Created Stored Procedures, Packages, Functions, database Triggers for the Retirement info module.
• Creation of Batch Provision Utility for PL/SQL packages/procedure calling.
• Creation of database schema, Roles, Tablespaces, Rollback Segments.
• Developed, implemented and unit tested Invoice Order Interface. This involved importing data
• from the legacy system into staging tables using SQL Loader, validating the data using PL/SQL procedure.
• Support multiple applications simultaneously.
• Installation of Oracle software on different platform.
• Developed SQL queries to fetch complex data from different tables in remote databases using
• Joins, database links and Bulk collects. Also wrote complex code for error handling
• Setup UAT database for testing.
• Involved in Schema management, Tablespace Management, User Creation
• Developed Visual Basic code for reporting module and web application using Oracle.
• Developed database triggers required for the Integrity constraints.
• Participated in application planning, design activities by interacting and collecting requirements
• from the end users.
• Assisting team members in troubleshooting.

Environment: Oracle 9i, Java, JSP, Servlet, VB 6, SQL, PL/SQL, UNIX, SQL Loader, TOAD, SQL PLUS, Windows 2000

Confidential

PDC Factories POST DATED CHEQUE

Confidential is a centralized application for storing, managing and banking the PDC instruments Administration and Security of users. Storing all the Master Details Location, Bank, Bank Branch, Product, and Clearing Centers etc. PDC Dual Data Entry, Discrepancy Resolution and Vaulting of PDCs.Request Date change module. Authorization of Shadow Batch.Retrieval of PDCs for banking/returns and generation of pay-in-slips.PDC Banking.PDC Swap, Foreclosure, Cancellation and Hold management.

Title: Software Consultant

Responsibilities:

• Creation of database schema, Roles, Table spaces, Rollback Segments.
• Gathering business requirements from client.
• Written the Unix Script to the run the multiples control files written in SQL Loader.
• Creation of database Objects.
• Developed web application using Oracle.
• Automated routine DBA tasks of database monitoring thru shell / SQL scripts Responsible for proactive management.
• Architecting the Alert systems for Database activities.
• Involved in Efficient Configuration of Access Policies through Roles and Privileges.
• Involved in capacity planning and enhancements.
• Coordinated with UNIX group for space reclamation on Server by reorganizing the tablespaces.
• Managing Partitioned tables and Indexes for efficient and robust access of database objects.
• Wrote automated scripts for tracking and validating invalid objects in Database.
• Coordinated with business consumers of data to formulate Backup Schedules.
• Devised and implemented Backup and Recovery policies.
• Worked on Enterprise Manager Control grid clients for Database Target management.
• Worked on Change Management tools like Clear Case and Remedy for controlling,
• Tracking and monitoring Production environment changes
• Used shell scripts for DBA operations
• Meet the client and understand the requirement and timeline for the each module.
• Worked on reporting with the help Visual Basic.
• Worked on index monitoring and rebuild.
• Worked on Setting Integrity Constraints.
• Involved in code reviews of other team members.
• Wrote PL/SQL procedures for reporting.
• Monitoring database using Oracle Enterprise Manager or TOAD Tables paces, Data files, Jobs, Users, sessions, Processes .

Environment: Oracle 8i and 9i, Java, JSP, Servlet, VB 6, SQL, PL/SQL, UNIX, SQL Loader, TOAD, SQL PLUS, Windows NT, Windows 2000/XP.

Confidential

NAT Network Analysis Tool .

Confidential is product of BKP-Consultants that is based on GSM and CDMA technologies. NAT is Network Analysis Tool that works on the OMCs of the MSC for the telecom vendors. like Tata, Tele Services and Hutch, NAT is used by the telecom vendors for generating various report that helps for the network analysis and managerial decisions.

Title: Software Engineer

Responsibilities:

• Creating workflows and Workflow Process.
• Involved in code reviews of other team members.
• Worked on Setting Integrity Constraints.
• Worked on index monitoring and rebuild.
• Worked on reporting with the help Visual Basic.
• Meet the client and understand the requirement and timeline for the each module.
• Used shell scripts for DBA operations.
• Tracking and monitoring Production environment changes.
• Coordinated with business consumers of data to formulate Backup Schedules.
• Wrote automated scripts for tracking and validating invalid objects in Database.
• Managing Partitioned tables and Indexes for efficient and robust access of database objects.
• Involved in Efficient Configuration of Access Policies through Roles and Privileges.
• Architecting the Alert systems for Database activities.
• Experience in developing web application using ORACLE.
• Automated routine DBA tasks of database monitoring thru shell / SQL scripts Responsible for proactive management.
• Creation of database Objects.
• Written the Unix Script to the run the multiples control files written in SQL Loader.
• Gathering business requirements from client.
• Developed complex queries for reports.
• Creation of database schema, Roles, Table spaces, Rollback Segments.
• Wrote PL/SQL procedures for reporting.
• Monitoring database using Oracle Enterprise Manager or TOAD Tables paces, Data files, Jobs, Users, sessions, Processes .

Environment: Oracle 8i and 9i, Oracle forms and reports, XML, VB 6, SQL, PL/SQL, UNIX, SQL Loader, TOAD, SQL PLUS, Windows NT, Windows 2000/XP.