SUMMARY:

• Highly motivated software professional with 15+ yrs of strong experiences in Design, Development, System Test, Production execution and Support of Software Projects in IT Industry.
• Have been involved in all phases of SDLC (requirement analysis, high and detail level design, coding, unit, integration, regression, user acceptance testing and deployment) for projects in Financial ( Confidential, Confidential, ISBS) & Healthcare ( Confidential, CIGNA) domain.
• Extensive exposure in UNIX, PL/SQL, Oracle Pre - compilers and Java in complex environment.
• Exposure in development and maintenance of applications using Actuate 7/8/9 Business intelligence Suites, Oracle 9i/10g, Callidus TrueComp 3.x/5.x.
• Exposure in Application System Maintenance/Administration on UNIX server.
• Involved in cleaning and maintaining migrated data .
• Experienced in Tuning Queries for better performance with large volume of data.
• Experience in using Explain Plan, SQL tuning, collection of statistics and creation of indexes for database access and indexing the required columns.
• Experience with procedures and coding PL/SQL blocks.
• Quick learner with ability to master new concepts and applications.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle.
• Expertise in Oracle AS 10g and migration of Oracle Reports from 4.x/6i/9i to Oracle 10g.
• Experience in utilizing Business Objects.
• Extensively worked with Oracle Utilities like Imports / Exports, SQL * Loader- Worked with very large databases - Extensively used UNIX shell Scripts for automating batch programs.
• Focused and hardworking, able to troubleshoot complex problems. Strong Business and Application Analytical skills.
• Effective team player and a motivating leader with innovative & adaptive communication skills.
• Possess a track record of success in meeting project milestones and developing very good relationship with client and other groups.

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, FL

Lead Oracle Developer

Responsibilities:

• Designed and Developed Global Function Allocation model for POC system using Oracle PL/SQL.
• Involved in data Maintenance and Support which uses Oracle 9i database, SQL, PL/SQL, SQL* Loader, Shell Scripts, Business Objects in windows NT and Unix environment.
• Extensively involved in using PL/SQL to built Oracle Packages, stored procedures, functions, triggers, cursors, Oracle Reports10g and views for processing data and needed business rules.
• Code optimization/Performance Tuning - Involved in performance management of various PL-SQL reports & queries.
• Developing various reports using Oracle Pl/SQL. Also tuned the reports queries to help save redundant database queries and thus save report execution time.
• Working directly with & reporting to Customers to understand the requirements.
• Production support for Allocations Processing system.
• Developed database compare tool to negate manual intervention for database object comparison during data copy to data warehouse/reporting environment. It provides a list and DDLs of Tables, Indexes and Views which are different among the source and target systems, thus saving considerable time.
• Implemented table cleanup script to purge old table data to secure additional tablespace.
• Implemented various process improvements within the team to enhance customer-vendor relationship.
• Used TOAD and Oracle PL/SQL developer as GUI interfaces.

Environment: PL/SQL, UNIX, Oracle 10g database, Autosys, AB Initio and PeopleSoft.

Confidential

Technical Lead

Responsibilities:

• Responsibilities include analyzing, trouble shooting, resolving and documenting reports. Understand existing system business logic, perform enhancement and impact analysis of the applications.
• Documented all the requirements received from business team, optimized for effective solutions.
• Lead a multi-member and multi-functional Callidus Development team involved in development and maintenance of reports in Pl/SQL, Actuate & Callidus TrueComp.
• Design, Development and Enhancements of various types of reports.
• Developed and maintained in-house Data Warehouse environment. The environment was developed using Oracle PL/SQL.
• Development/enhancement of Oracle PL/SQL programs for creating Tables, Views, Sequences, Database triggers, Cursors, Stored Procedures and Functions, Exception Handling and Indexing, Optimization and Tuning of Procedures, SQL Queries to improve performance.
• Creation and execution of implementation plan, deployment of executables to servers.
• Development/enhancement of UNIX shell scripts. Troubleshoot the Production issues.
• Work directly and reporting to Customers to understand their requirements.
• Deployment of the reports with proper security & accessibility.
• Developed and maintained sales incentive reports in actuate.
• Automated sever-volumes process using Information Delivery APIs. The automated process would alert the system administrator as soon as a server volume went off-line. The process saved about 8Hrs of turnaround time in a month.
• Code optimization - Involved in performance management of actuate reports/PL-SQL queries.
• Work closely with upper management and consultants onshore and offshore of various teams in development, maintenance, QA & Testing and production support of compensation system.
• Coordinate with business analyst, business client and various functional teams across the application to gather requirements and provide best solution approach.
• Time & Cost estimation of work/change requests, work allocation to team members (offshore and onshore), track/review progress.
• Developed application upgrades for three Annual Release and multiple Quarterly Release. These development involved compensation application upgrade, report development, oracle stored procedures/Functions development etc.
• Create complex data models and process flow diagrams. Create and maintain high level design (HLD), detailed design (DD), Unit test (UTP) documentations & business-process documentation based on the requirements gathered from business analysts & business user, using industry-standard methodology.
• Actively organize team and business meetings, mentor resources, and participate in resource hiring process.
• Used TOAD to review explain plans, long running operations and assist with performance tuning of queries.

Environment: PL/SQL, Java, AIX-UNIX, Oracle 9i database, Actuate 9.0, Callidus-TrueComp

Confidential, Philadelphia, PA

Senior Consultant

Responsibilities:

• Involved in creating Business Requirement Documents, User Requirement Specification, and Functional Requirement Specifications.
• Contributed towards creating Data Flow Diagrams, Use Cases, State Diagrams, Sequence Diagrams, Component Diagrams, Use Case Diagrams & Activity diagrams.
• Did Gap Analysis & Impact analysis by identifying existing technologies, documenting the enhancements to meet the end-state requirements.
• Migrated legacy C++ based Requester APIs to Java based IDAPI environment using SOAP on Solaris environment, resulting in system independence and resource savings.
• Automated all the manual Oracle SQL scripts based reports using Java. Developed UNIX scripts to execute the Java programs and scheduled the UNIX scripts on Tivoli Workload Scheduler. This resulted in saving of 6-8 Hrs of manual intervention every month.
• Developed and deployed driver reports for automating the execution of multiple reports for various customers. This driver report proved to be very useful in a customer reporting environment as it automated the entire report generation process of all the customers who get many reports on a scheduled basis, namely weekly, monthly or quarterly. Suitable privileges for the individual customer folders were also handled to ensure privacy.
• Fine tuned report queries to help save redundant database queries and thus save report execution time.
• Following the Coding Standards for e-Report Designer Professional, XSLT (eSpreadsheet) and Stored Procedure as per the organization standards.
• Development & Modification of Queries and Stored Procedures in Oracle.
• Deployment and scheduling the Objects to the iServer through Management Console.
• Unit & Integration testing.
• Involved in making new releases of the application.
• Responsibilities include analysing, reproducing and fixing the bugs
• Worked as the team leader of offshore team, where the responsibilities include distributing tasks among the team members, knowledge transitioning and assisting them in maintaining the development/delivery standards.
• Prepared documents to conduct User Acceptance Testing.

Environment: SUN SOLARIS, Oracle 9i database, PL/SQL, Java, Actuate-IDAPIs

Confidential

Module Lead

Responsibilities:

• Implemented and provided enhancements such as multiple accounts editor, multistreaming for Inward Clearing process to meet client requirement. This helped save considerable time on the clearing process which is a strictly time bound activity.
• Created and implemented IBGA (Inter Branch Clearing Account) module and related reports. Developed reports and flat file generation programs specific to the client requirements. Created UNIX scripts to automate the flat file dispatch process to various processing centres.
• Involved in designing and implementation of transfer batch for salary, pension and ECS posting to reduce load on existing inward clearing process. The new system provided the customer with more control over the process.

Environment: FNS-BANCS, IBM-AIX, Oracle 9I database, PL/SQL, PRO*C, MF COBOL

Confidential

Senior Developer

Responsibilities:

• Involved in requirement gathering & project Analysis.
• Development, Coding, Testing (integration, functional and performance) and Debugging.
• Provided Banking/Technical support to various branches of the banks.
• Developed & maintained custom reports.
• Testing (integration, functional and performance).
• Deployment at the client site.
• Employee training.

Environment: Pl/SQL, PRO*C, SCO-Unix, Oracle 7 database, Forms 3.0