PROFESSIONAL SUMMARY

• Highly skilled and experienced software professional, with almost 20years of diverseIT experience in technical leadership, project management, requirement gathering, design, development, technical analysis, testing, implementation and production support of software applications,utilizing various tools and technologies under different operating environments.
• Oracle Certified Professional withover14years of Oracle experience.
• Database development in Oracle 11g/10g/9i/8iandMS SQL Server, with Oracle Developer 10g/9i/6i.
• Strong experience in software development using Oracle SQL, PL/SQL including Packages, Procedures, Functions, Triggers, Views , Oracle Forms, Visual Studio, ASP.NET, VB.NET, UNIX Shell Scripts, Java Script, HTML, Autosys, Hyperion SQR reporting, and Perl programming.
• Supervised and Mentored developers assigning work, monitoring progress, guiding to improve technical skills and business knowledge, conducting yearly performance reviews.
• Managed and executed large critical projects, involving, planning, costing, budgeting, resourcing, setting up deadlines and managing team of developers and BA.
• Led projects with Agile Software Development, to develop flexible and interactive solutions.
• Hands on Experience in all the phases of Software Development Life Cycle SDLC including defining functional specifications, technical analysis, requirement gathering, design, coding, unit testing, user acceptance testing, implementation and post implementation production support.
• Extensively work with on-shore and off-shore consultants, managing and collaborating on daily basis.
• Prepare and build high performing bulk load ETL processesto load data inOracle Data Warehouse using tools such as Oracle SQL Loader and External Tables.
• Maintaining and developing production web site in ASP.NET and VB.NET, using Visual Studio, Java Script and HTML.
• Converted multiple legacy systems to Oracle Applications 11i / Oracle Financials and to Oracle database for an insurance company and a manufacturing company.
• Extensive experience in writing UNIX Shell scripts and Perl scripting for data processing, data manipulation, file handling and job running.
• Involved in Detailed Testing, develop test cases, document test results based on SOX requirements, support SIT and UAT testing, interface with QA teams for deployment into production.
• Diverse Experience working in variety of industries like, Insurance, Finance, Banking, Manufacturing, Consulting, Government, Tax/Revenue, Education etc.
• Strong analytical and problem solving skills, excellent interpersonal and communication skills.

Technical Skills:

RDBMS Databases Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i, MS SQL Server, MS Access

Operating Systems Windows, UNIX, LINUX, Mainframe HP-UX, VAX/VMS , SUN Solaris

Oracle Tools Oracle Developer 10g/9i/6i Forms Reports , SQL Plus, SQL Loader,

TOAD, PL/SQL Developer, Export/Import, Oracle Designer,

Oracle Enterprise Manager OEM , Oracle Workflow Builder

Languages/Applications SQL, PL/SQL, UNIX Shell Scripts, Visual Studio,VB.NET, ASP.NET, JavaScript,HTML, ADO.NET, COBOL, Pro Cobol, JAVA,Perl, AWK, XML,CGI

Oracle Applications Oracle Financials 11i GL, AR, AP , Oracle Applications 11i INV, BOM, OM

Reporting Applications Oracle Reports,Oracle Discoverer, Hyperion SQR Reports

Productivity Tools Microsoft Project,Microsoft Visio, Microsoft Office, SharePoint

Other Tools ActiveState Komodo IDE, EDI, UltraEdit,Knowledge Xpert,PVCS,Quest STAT,

Revision Control System RCS , FormScape, SAS, Autosys, Inovis TrustedLink

PROFESSIONAL EXPERIENCE:

OracleApplication Developer/Tech Lead Actuarial

Confidential

Accomplishments

• Awarded Enterprise IT Movers and Shakers Award by Company CIO.
• Application owner, Tech Lead and SME of Agency Compensation, Agency Dashboard and Data Integrity -key applications within the Actuarial system.
• Work extensively with off-shore and on-shore consultants, leading, guiding and collaborating with them on number of projects.
• Mentorjunior developers with their tasks, providing business and technical assistance and knowledge.
• Performed detailed analysis, developed, tested and implemented Enterprise wide Financial Transformation initiative, performing Data Modelling, using Agile development approach in a timely manner, meeting aggressive deadlines.
• Successfully designed, developed, tested and implemented Data Integrity application, converting from Mainframe COBOL to Oracle and assisted calling applications to call Mid-Tier in a smooth transition.
• Maintaining production Website to make monthly and daily processes easy to run and monitor online.
• Managed large critical projects successfully under budget.
• Working on performance improvement and simplifying the system for easy maintenance.

Environment

Oracle 11g, TOAD, PL/SQL, SQL, Oracle Data Warehouse, JavaScript, HTML, ASP.NET, VB.NET,

COBOL, Linux

Confidential

Accomplishments

• Managed and Supported BACIS applications as SME, where all Check, Wire, Credit Card and ACH transactions for the entire company, worth Billions of Dollars pass through on a yearly basis.
• As Technical Lead and Mentor led production support team, Trained and guided Developers and new consultants. Created,setup and managed a Wiki site for the team,resulting in increased efficiency
• Assisted in Off-Shore Outsourcing initiative, providing in-scope and out-of-scope activities, access to vendors, knowledge transfer trainings and review KT progress of outside vendors, and brought them on board for Production support, Operational activities and QA Testing activities for BACIS.
• Improved efficiency by eliminating root causes, automating monitoring process of daily jobs to substantially reduce production support time by almost 75 .
• Managed large Projects, from estimation, resource planning to code review and implementation.
• Provided ongoing maintenance and handled Production support issues,providing off hours system monitoring to survival critical applications.
• Led Design and Developed, enhanced and implemented highly visible, Survival Critical BACIS Application modules using Oracle Forms/Reports 10g, Stored Procedures, UNIX Shell scripting and Perl Scripting and Created Custom Reports using SQR and PL/SQL, paying attention to details.
• Prepared BACIS system for quarterly and year-end SOX compliance and Audits by creating reports, preparing supporting documents and helping business area. Initiated and improved the SOX Audit process by making documentation electronic instead of printing.

Environment

Oracle 10g/9i, Oracle Developer 10g/9i, TOAD, Unix Shell Script, PL/SQL, Oracle Data Warehouse,

Hyperion SQR Reports,Quest STAT,PerlProgramming, AWK, ActiveState Komodo IDE, Remedy

Confidential

Client:Connecticut Department of Revenue Services DRS

• Supervised, Managed, Mentored and guided number of Accenture and DRS developers, overseeing their work, helping them improve their technical skills and Business knowledge.
• Successfully managed and implemented very large projects of Corporate and Personal Income Taxes, as per Service Level Agreementin a multi-user design environment.
• Architect, Design, Develop, Test, Debug and Implement a large,highly visible Web Enabled, Integrated Tax Administration System ITAS for CT State DRS, a Full Life Cycle Development.
• Extensively worked with Functional Users and conducted Client meetings to gather Requirements and specifications in a Business Analyst role.
• Supported Product Test/SIT and User Acceptance Test,creating test plans, test scripts, performing extensive testing and producing accurate documentations as per project deliverables.

Environment

Oracle 9i, Oracle Developer 9i, PL/SQL Developer,MS SQL Server, Visual Studio, ASP.NET, VB.NET

Programmer Analyst

Confidential

• Performed analysis, evaluation migration of legacy Mainframe system to Oracle Applications 11i.
• Participated in ERP migration project and Converted legacy system data into Oracle using PL/SQL, SQL Loader, ETL tools for multiple locations of the company.
• Provided initial setup and support for Oracle Financials AR, AP, GL and Oracle ERP Applications.
• Developed and Maintained Stored Procedures, Packages, Oracle Forms and Reports to implement, test and support Oracle Applications and Database.
• Administrated Discoverer and created ad-hoc reports as per user requirements.
• Created Oracle workflows as per business rules and requirements.
• Designed Developed, Tested andImplemented new reports and screensin Mainframe COBOL a Full Life Cycle Development, performing multiple roles of Business Analyst, Developer and Tester.
• Led and Managed EDI Projects, implemented EDI solutions and automatedprocess.

Computer Systems Support

Confidential

• Developed applications for time entry process attendance and created reports for payroll for Yale University, using Visual Basic and MS Access database.
• Customized and implemented accounting packages according to clients' requirements with new features and reports.