Shanmugam Gopal

Oracle PL/SQL Developer

Visa Status: Green Card

Contact Details:

**** ****** *****,******,**-75038

acaf9d@r.postjobfree.com

Phone: 860-***-****/860-***-****

Summary

● Over 10 years of experience in all phases of SDLC including Requirement Analysis,

Application Design, Development of Multi-tier Applications, Testing, Implementation,

Production Support, Maintenance and Data warehouse projects.

● Over 10 years of work experience in Oracle PL/SQL programming.

● Over 8 years of work experience in in SQL optimization/Performance Tuning.

● Over 4 years of work experience in ETL design,development,development and data

migration projects.

● Strong programming experience in Oracle Forms, Visual Basic, UNIX shell scripting,PERL,

Oracle SQR reports.

● Strong work experience in UNIX, Linux, and Windows environments.

● In-depth knowledge in Data warehouse concepts,Core Java,Object Oriented

Programming concepts, J2EE architecture, RDBMS, Big data – Hadoop/MapReduce

frameworks.

● 4 years of experience in product implementation, including hands-on training to the

users.

● Strong business/domain knowledge in Group Benefits Insurance, Claim Processing,

Annuities, Tax processing.

● Oracle certification in SQL programming

Technical Skills

Operating System / Hardware: Windows 2000 Server, NT, XP, UNIX, Linux

Languages: Java, Perl, Visual Basic, Pl/Sql, Sql

Report Tools: SQR reporting, Actuate Reports, Docucorp Print tool

IDE: Eclipse

Database: RDBMS Oracle, MS SQL Server 2000

Other Support Tools: TOAD, SQL developer, SVN, PVCS

Experience

● Cognizant Technology Solutions Inc., Chennai-India,Hartford-CT(USA) & Irving-TX(USA)

May 2006 – Present (Working from REMOTE)

Sr. Developer/Tech Lead/Project Lead

● Syntel India Ltd., Chennai-India

Jul 2005 – May 2006

Sr. Developer/Analyst

● AIG Systems Solutions Pvt. Ltd., Chennai-India

Feb 2004 – Jul 2005

Developer/Analyst

● Vikram Software Ltd., Chennai-India

May 2000 – Jan 2004

Sr. Developer/Product Implementation Tech Lead

Key Projects - worked

● Corporate Tax Project, Regulation of FICA,FIT,SIT taxes implementation in the

Disability Insurance Claim processing system,Working from REMOTE (Irving,TX)

Client: The Hartford Financial Services – Group Benefits

Period: 08/01/2011 to Till Date (Phase1 and Phase2)

Role: Sr. Developer/Tech Lead

● Involved in the project’s requirement scoping, detailed required

gathering sessions and initial estimate evaluation process

● Worked with onsite client side application Tech leads &

Architects during the design phase, prepared the technical

specification and high level design documents for various

modules

● Involved in the detailed design, prepared the component

detailed design (CDD) documents for various critical modules.

Design and developed all the database related components

●

(i.e. database packages having stored procedures, functions,

common data types)

● Developed the project specific framework for better online &

backend coding standards, program code flow, error handling

process, change control and code migration processes.

● Prepared the unit test (UT) and assembly testing (AT) high

level plan and test strategies

● Prepared the UT/AT test scripts and executed the same for

various key and complex programs/modules

● Design and build PERL and Unix shell scripts for various file

handling and other automation processes

● Design and build the critical code piece which takes care of

moving all the tax files from Unix environment to Mainframe for

soft copy generation and hard copy printing using JCL job

● Design and build table driven logic for the critical CSV files

creation requested by the business

● Tuned and rewrite the SQL queries which took longer

execution time in the BAT and Production environments.

● Provided the requirement, tech spec and detailed design

walkthrough to the entire offshore/onsite development team

● Reviewed and provided sign off for all the build deliverables

such as component detailed design (CDD), code, UT/AT

scripts and test execution logs, code migration list to the next

level environment.

● Involved in the defect root cause analysis and defect fix for the

issues found out during SIT and BAT testing

● Provided the technical support to Test lead, testing team and

QA test environment manager

● Involved in the pre/post production implementation plan and

meetings

● Involved in the components check out process and provided

technical support to the business check out during the

production release time

● Analyzed the post production issues, provided the work around

to the production problem to the business in timely manner

● Worked with project manager to address all the

post production issues within the warranty period, make sure

the business aware of open issues and their permanent fix plan

in advance.

● Trained associates on technology, application knowledge and

best practices followed

● Updated the project lessons learnt document

● Documented all PL/SQL objects created during the project and

user guide for different processes followed

● Simplified Disability Insurance product Development, Hartford-CT, USA

Client: The Hartford Financial Services – Group Benefits

Period: 10/01/2012 to 12/31/2012

Role: Sr. Developer

● Worked with onsite client side application Tech leads &

Architects during the design phase, prepared the technical

specification and high level design documents for few key

modules allocated

● Involved in the detailed design, prepared the component

detailed design (CDD) documents for few key modules

allocated

● Design and build the table driven logic for diary creation and

coverage certification report modules.

● The table driven logic for diary creation was done to avoid

online changes if any new diary type to be setup for a claim in

the future. (leads to less maintenance cost, the implementation

doesn’t need any developer or project team, can be done by

production support specialist itself)

● Worked with client Tech leads, Architects and DBA, analyzed

the data needs, design and finalized the data model for the

table driven approach.

Presented a session on the importance for the table driven

●

logic for the current diary process in the claims system,

demonstrated how easily an enhancement or changes can be

done in future with no additional changes to the system, how

this approach will lower the maintenance cost to the overall

project team.

Design and built a completely different approach in coverage

●

certification report program (SQR report), made the SQR code

layer as thin and moved all the processing logic to the

database packages. With that, brought the better performance,

avoid the complex coding way of SQR report, built the modular

based reusable stored procedures, functions helping easier

code maintenance and future maintenance cost.

With the help of the Pl/Sql tables (collections) and few Meta

●

data control tables, effectively processed and parsed the data

needed by the coverage certification report SQR program.

Prepared the UT/AT test scripts and did test execution.

●

● Provided the technical support to Test lead, testing team and

QA test environment manager

● Involved in the defect root cause analysis and defect fix for the

issues found out during SIT test

● Prepared the detailed documentation for the code changes

done in the project

● Managed Service model for Group Benefits Claim Processing System Service

Enhancements/Production support, Hartford-CT, USA

Client: The Hartford Financial Services – Group Benefits

Period: 01/12/2009 to 07/31/2011

Role: Sr. Developer/Production support analyst

● Involved in the various production support activities, make sure

all the high or critical issues addressed as per SLA

Monitor the problem tickets queue, prioritize and assign them

●

to the production support offshore team.

Closely worked with client side application owner, provided the

●

plan or defect fix strategies for all the open issues.

Closely monitored the production issue’s pattern, advised the

●

team to do root cause analysis for the repetitive issues,

suggested and implemented the permanent fix to avoid the

similar production issue tickets in the future.

Analyzed the long running SQL queries in the production, did

●

SQL tuning for improved performance.

Wrote various complex SQL queries for the ad hoc reports

●

requested by the business

Part of onsite on call support team, make sure the critical

●

production issues addressed on 24 X 7 basis.

Primary point of contact for the entire enhancement works,

●

worked with business analysts and did business requirement

walk through to the offshore development team.

● Reviewed and provided sign off for all the build deliverables

such as component detailed design (CDD), code, UT/AT

scripts and test execution logs, code migration to the next level

environment.

Design and developed many database and batch side

●

components. Prepared the unit test scripts and did test

execution.

Provided the technical support to Client BA,Business test user

●

and Test lead

Individually analyzed and understood the complex rules

●

involved in state tax calculation for each states, design and

build a table driven approach for state tax implementation

whenever new calculation change comes for any state.

Presented a session on the importance for the table driven

●

logic for the current state tax calculation process in the claims

system, demonstrated how easily an enhancement or changes

can be done in future with no additional changes to the system,

how this approach will lower the maintenance cost to the overall

project team and business IT.

Worked with release coordinator for the production release,

●

involved in the pre/post implementation meetings.

● Analyzed the pre production issues, provided the work around

to the production problem in timely manner

Acted as primary point of contact for any non prod issues.

●

Conducted many technical or application or domain related

●

sessions to offshore

Development and testing team

● Knowledge Transition,Implementation,Service Enhancements and Application

Development for Producer-Agent-License Information Management System (PrIME),

-Chennai – India

Client: The Hartford Financial Services – Investments

Period: 10/01/2007 to 12/31/2008

Role: Tech Lead/Project Lead

● Involved in the onsite knowledge transition from the previous

vendor, one of two senior members involved in the knowledge

transition phase for the new project ("Prime") at onsite.

● Project setup at offshore after successful completion of the

onsite KT program.

● Took the complete responsibility of the entire project

deliverables starting from the requirement phase to post

implementation phase.(Requirement analysis, Estimation,

Project planning, Execution and Control,etc)

● Handled all the Software Quality Assurance Group activities for

the project and reported the metrics to the next level

supervisor.

● Developed and setup the benchmark for coding standards and

involved in the design/reviews/sign off of all deliverables in

each phase of software development cycle.

● Conducted and organized many technical/business sessions

for the offshore team members.

● Primary contact from offshore, make sure onsite offshore

coordination happens in the right and smoothly manner.

● Acted as SME, mentored and trained the new comers to the

project in the areas of application knowledge, application code

inventory and knowledge, domain knowledge and technical

skills needs.

● Design and developed many automation scripts using SQL

loader, dbms_utl package.

● Involved in the SQL performance tuning

● Product Enhancement,DW reports and Policy pages report development for

Navisys,an Annuity policy administration tool Management System, Chennai – India

and Woodland Hills – CA,USA

Client: AIG Sun America Life

Period: 02/01/2004 to 07/15/2005

Role: Developer

● Design and develop various complex reports using Actuate

reports tool.

● Design and develop various complex reports using Docucorp

print tool.

● Design and develop various key Pl/Sql stored procedures and

functions.

● Developed various complex SQL queries involving Analytic

functions, inline views

● Involved in the SQL tuning activities, tuned & rewritten many

complex query ran in data warehouse environment for better

performance.

● Involved in data migration activities, written many complex

pl/sql based stored procedures, functions involving bulk

collections, bulk insert/update, advanced use of Pl/sql tables,

object based casting, etc.

● Prepared the UT/AT test scripts and executed the same for

various key and complex programs/modules

● Conducted and organized many technical sessions on Oracle

– SQL and PL/SQL for the team members.

Education

● Bachelor of Engineering, Industrial Engineering, College of Engineering Guindy, Anna

University, India

Contact this candidate