SUMMARY

• Disciplined Information Technology professional with record of success in software design, development, unit testing, integration testing and production support in Healthcare (Insurance), Confidential and Banking industries.
• Adept in healthcare product interchange, Confidential, EDS Confidential implementation project and successfully supported new development in Department of Children Services (DCS), managed care, recipient management, 834’s, HIPPA transactions, Claims,Financial and Reporting and ClearCase modules.
• Thorough understanding of Software Development Life Cycle and Confidential process.
• Well versed in software development in Unix shell scripting, Pro*C, SQL, advanced Oracle PL/SQL programming, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i databases, ClearCase, batch report generation,TOAD,Sql developer, ETL (Informatica) tool and Snowflake/Star Schema databases.
• Developed Batch jobs using Pro*c and UNIX shell scripting
• Documented code in accordance with company policies, company standards and industry best practices
• Effectively wrote complex SQL queries using joins, sub queries and inline views to retrieve data from database.
• Excel in SQL and PL/SQL by writing SQLs, Oracle Stored Procedures, functions, XML parser and packages according to the business requirements.
• Basic knowledge in HTML, JAVA, JSP and Servlet.
• Wrote high performance queries/programs using Collections, Bulk Binds, Objects, Nested tables, REF Cursors.
• .Experience in advanced PL/SQL concepts like Bulk collect, PL/SQL tables and Dynamic SQL for DML operations for better performance.
• Solid command of schema modeling and data model tool specifically Erwin.
• Skillfully use Pro*C for host variables to communicate with database.
• Accomplished in creating Oracle packages, complex triggers or generate indicators and indexes to increase performance issues, troubleshooting and complex SQL queries for joining multiple tables.
• Expert using FTP, TOAD, SQL Navigator, SQL Developer tools.
• Specialize in database optimization through use of various performance tuning techniques.
• Proficient in database and SQL tuning using hints, SQL trace, TKPROF and explain plan.
• Solid aptitude in normalized database design and modeling in logical and physical design of database.
• In depth expertise in data flow diagrams, data dictionary techniques, entity relation modeling and design techniques and database normalization theory.
• Strengths include physical and logical data modeling.
• Able to support dynamic SQL, PL/SQL collections and exception handling.
• Proven track record in version control tools such as VSS and ClearCase.
• Known as an engaged SME in Confidential Project for Department of Children Services (DCS) and managed care subsystems.
• Diligently supported new project choices group.
• Exceptional delivery in handling critical job failures in production environment and in fixing data issues in database.
• Organized approach to preparing a SQL script regarding system change requests (SCR) in a test environment by creating a database link to connect other UAT, PROD environments to get the recipient data and supported four MCC (Managed care contractors) MCO, BHO, PBM and DBM by validating the auto assignment and SYNC logs.
• Ability to coordinate and administer tasks related to smaller projects.
• Broad base of knowledge of general business concepts and user procedures.
• Capable of programming and testing and providing resulting documentation.
• Successfully participate in software test review and analysis, test witnessing and certification of software.

TECHNICAL SKILLS

Operating System: Sun Solaris, Windows NT, Windows 2000/NT, MS DOS, Windows XP

Products/Tools: ClearCase, Toad, iTRACE, Sql - navigator, Filezilla, Confidential -MMIS, Araxis-Merge, ERWIN, TOAD, SQL developer

Languages: Pro*C, SQL, PL/SQL, UNIX, XML, ETL(Informatica)

RDBMS: Oracle 9i, 10g, 11g

Business Domains: Healthcare (Insurance), Banking

Documentation Tools: MS Word, Excel, PPT

Technologies: JAVA, JAVA Scripts, JSP, HTML, Servlets,Powerbuilder

Framework: Struts

PROFESSIONAL EXPERIENCE

Senior PL/SQL developer

Confidential, Nashville, TN

Responsibilities:

• Gathered requirements for the product.
• Performed technical and functional reviews.
• Designed and developed database tables, cursors, procedures, functions and packages to meet business requirements.
• Developed technical system design documentation for new projects and existing code.
• Developed, tested and debugged stored procedures and complex packages using PL/SQL
• Quality assurance
• Wrote complex SQL queries using joins and sub queries to retrieve data from the database.
• Trained the team on domain and technology used
• Code review in PL/SQL procedures, functions and triggers
• Developed high performance queries and PL/SQL codes using Bulk Binds, Objects, Nested tables, REF Cursors etc.
• Performance tuned DB queries
• Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain.
• Utilized SQL*Loader to load flat files into database tables
• Created SQL*Loader scripts to load data into temporary staging tables flat files, using Export, Import
• Developed automated scripts to schedule the load of flat files on daily, weekly and monthly basis.
• Prepared schema statistics, data preparation by import/export from external databases in Dev and Quality control databases
• Created and used DB-Links to connect to other local & QA databases
• Solved implementation problems in PL/SQL and database related issues less than estimated time.
• Developed some PL/SQL scripts for one time fix.
• Handling exception to debug the pl/sql code.
• Modified various existing Pro*C code and Pl/Sql code.
• Conducted work product review meeting with team members for technical system design document.
• Attended team members work product reviews and provided review comments to meet the requirements.
• Created and modified job streams and job scripts.
• Provided schema modeling and used data model tool Erwin.
• Developed ER diagram and data dictionary of existing tables in the production environment.
• Understood and adhered to release management processes to include emergencies.
• Performed post-implementation follow-up.
• Supported testing team to prepare test data and test scenarios.
• Fixed defects in existing programs.
• Conducted batch Jobs and Jill’s scheduling in Autosys.
• Scheduling database tasks by using Autosys.
• Followed testing methodologies after developing the code in project by performing step by step process, unit testing, MOD office, integration testing and UAT.
• Enhanced design of application for better maintainability and software reuse.
• Documented unit test cases, design document, project work book, implementation plans, move sheet and run sheet.
• Supported production on call.

Environment: UNIX, Pro*C, SQL, PL/SQL, Toad, SQL developer,SQL Loader, UNIX Shell Scripting, ClearCase, iTrace, ETL (Informatica)

Confidential

Senior PL/SQL developer

Responsibilities:

• Provided preliminary estimates for system change request and work request.
• Performed requirements and business system design analysis to prepare design document.
• Gathered input and approval of requirements in business system design and requirement document reviews.
• Ensured applications met requirements and were error free.
• Developed technical system design documentation for new projects and existing code.
• Conducted work product review meeting with team members for technical system design document.
• Attended team members work product reviews and provided review comments to meet the requirements.
• Supported C for low level programming and embedded work.
• Checked in and checked out programs from central repositories through ClearCase tool and delivered code for deployment to different test environments.
• Designed and developed all Oracle-related programs in Pro*C.
• Designed and developed various database objects as tables, indexes, views, stored procedures, stored functions, Triggers and packages.
• Modified various existing Pro*C reports and Pl/Sql code.
• Wrote PL/SQL, Pro*c code for enhancements.
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database.
• Developed new code and fixed defects in existing subsystems by creating a DAD (Defect Analysis document) in a Pro*c environment.
• Provided schema modeling and used data model tool Erwin.
• Analyzed and debugged existing application developed in a C and Pro*c on Unix environment.
• Supported network communication protocols specifically FTP and SFTP to transfer files.
• Used public synonyms and read only user accounts and database links for remote database access.
• Handling exception to debug the pl/sql code.
• Scheduling database tasks by using Autosys.
• Created and modified job streams and job scripts.
• Conducted batch Jobs and Jill’s scheduling in Autosys.
• Developed SQL scripts, stored procedures, functions, database triggers and packages.
• Prepared a SQL script in a test environment by creating database link to connect other UAT and PROD environments to get recipient data, then ran a full managed care daily cycle to see that RID got all four MCC (Managed care contractors) MCO, BHO, PBM and DBM or not.
• Created complex triggers or generate indicators, packages and indexes to increase performance and complex SQL queries for joining multiple tables.
• Conducted performance tuning (SQL tuning, PL/SQL tuning).
• Developed ER diagram and data dictionary of existing tables in the production environment.
• Performed programming on Oracle SQL, PL/SQL indexes, bulk collects and bulk variables.
• Supported PL/SQL at the backend and developed various backend applications using PL/SQL and databases queries using SQL.
• Prepared unit testing document.
• Understood and adhered to release management processes to include emergencies.
• Performed post-implementation follow-up.
• Supported offshore and onsite model. Received good customer feedback for timely delivery and fulfilled the expectations.
• Supported testing team to prepare test data and test scenarios.
• Followed testing methodologies after developing the code in project by performing step by step process, unit testing, MOD office, integration testing and UAT.
• Provided periodic maintenance releases of applications including enhancements and defects.
• Enhanced design of application for better maintainability and software reuse.
• Managed workload to deliver quality deliverables that met requirements and timelines.
• Communicated status of assignments to supervisor.
• Notified supervisor of issues that impacted productivity or met expectations.
• Assisted manager in tracking progress, prioritizing work, developed time estimates and work plans and assisted less experienced team members.
• Handled DCS (Department of Children Services) file fix issues in UAT and production.
• Revealed root cause that resolved problems occurring in daily production cycle.
• Fixed defects in existing programs.
• Trained fresher’s and new team members in the team.
• Documented unit test cases, design document, project work book, implementation plans, move sheet and run sheet.
• Supported production on call.

Environment: UNIX, Pro*C, SQL, PL/SQL, Toad, UNIX Shell Scripting, ClearCase, iTrace, ETL (Informatica), SQL developer,SQL Loader

Delivery Senior Software Engineer

Confidential

Responsibilities:

• Supported financial and Sql reporting.
• Performed system design, development and unit testing of subproject in financial.
• Ran financial cycle manually to generate RA report according to business requirement.
• Provided system design, development, unit testing and integration testing of member subproject in recipient management.
• Modified technical specification to meet correct business requirement.
• Supported testing team in proper business logic and code flow.
• Identified test cases which were not correct which saved time and kept the testing process in right direction.
• Scheduling database tasks by using Autosys.
• Coded, tested, debugged, implemented and documented programs. Assisted in modifying company products and/or customer/internal systems to meet client and/or end-user needs.
• Assisted in researching and analyzing existing systems and program requirements. Performed data analysis to support internal and external project needs.
• Wrote specifications for programs.
• Designed programs for projects or enhancements to existing programs.
• Assisted in resolving basic production support problems. Applied current technologies such as hardware and software and packaged applications to support delivery of technical solutions.
• Assisted in completing unit testing by preparing test data, running tests and evaluating results. Participated in developing screen tests and debugging problems. Developed test plans to verify logic of new or modified programs.
• Participated in quality assurance activities such as peer reviews.
• Created appropriate documentation in work assignments such as program code and technical documentation.
• Performed UNIX shell scripting to automate procedure execution from UNIX box.
• Used Perl Scripts for scheduling jobs and managing critical paths.
• Created PL/SQL stored procedures and functions and embedded them in packages.
• Conducted performance tuning using hints and explain plan.
• Provided data modeling using ERWIN.
• Used autonomous transaction pragma in the framework procedures to log status when error occurred.
• Handling exception to debug the pl/sql code.

Environment: UNIX, Pro*C, SQL, PL/SQL, Toad, UNIX Shell Scripting

PL/SQL developer

Confidential

Responsibilities:

• Performed software design and development in PRO*C and Oracle (PL/SQL).
• Conducting peer code reviews.
• Prepared and executed unit test cases.
• Conducted status reporting.
• Fixed bugs.
• Implemented plan and provided production support.

Environment: UNIX, Pro*C, SQL, PL/SQL, Toad