VIJEE P. NAMBIAR Senior Software Consultant, MCA

Valencia, CA 91354 630-***-**** acrmu4@r.postjobfree.com

Profile

Proactive and resourceful professional with record of success in designing, development and debugging code modules to ensure customer needs and satisfaction remains high with every project.

Technical Lead with strong skills in database development, administration, performance tuning, optimization skills, creation and manipulation of various databases and database objects like tables, views, indexes, stored procedures, triggers etc., Data Import Export Utilities, Backup and Recovery procedures using MS SQL Server, Oracle and Sybase.

Excellent Object Oriented Application Development programming skills. Extensive experience in Object Oriented Analysis Design (OOAD) and multi-tier systems.

Highly knowledgeable SQL/XML programming skills and XQuery.

Excellent exposure to Transact SQL, PL SQL, SQL Plus, SQL Server Management Studio, TOAD.

Development experience in PowerBuilder 12.5 with PFC, for datawindows, windows, menus, application objects, user objects, OLE objects, interfacing DLLs.

Possess experience in all facets of software development lifecycles viz. requirement analysis, architecture, design, development, testing, and post implementation revisions.

Experienced in Waterfall and Agile SDLC methodologies.

Knowledgeable in Core JAVA, java-script, Servlets, JSP, JDBC and ASP.net.

Strong analytical, written and verbal communication and interpersonal skills.

Leading development team and managing critical projects

Technical Skills

RDBMS: SQL Server 2010, Oracle9i, Sybase

Web Technologies: ASP.net, XML, HTML5, CSS, PHP,

GUI: PowerBuilder 12.5, Visual Basic 6.0, Visual Studio 2010, Developer 2000

Languages: C, C++, VC++, C#, JAVA, UNIX Shell Script

Others: UML, Manual Testing, Documentation

Tool and Utilities: XQuery, Share Point, RedGate, MS Visio, MS Project, Office 365, Serena ChangeMan and MS-VSS, Team Foundation Service

Graphics Designing: Macromedia Flash 5, Dreamweaver 3.0, Fireworks 3, Extreme 3D 2.0, Shockwave 7, Adobe Flex

Operating System: DOS, UNIX, Win95, Windows NT XP, Windows 7, Novell

Projects Details

A] Technosoft Corporation, MI, USA

CLIENT: CENTURY NATIONAL INSURANCE, North Hollywood, CA July 2008 - Present

Sr. Software Consultant for Commercial Auto Insurance Policy Administration

Technical Lead for Claims

RESPONSIBILITIES:

Develop, test and tune database code and information

Design and maintain SQL scripts

SQL coding including stored procedures, views and triggers.

Create and optimize diverse SQL queries for reports

Provide technical support and guidance to staff and clients

Requirement gathering of the existing system.

Generate deployment documents and coordinating deployments as lead

Analysis, development and support of different application using PB 12.5 with PFC, SQL Server 2008, .Net

Acquiring full functional knowledge of how the system works

Unit Testing and implementation

Review project plan with team and conduct scrum meetings

Problem Solving for the team and business users and lead production support.

Maintaining technical documentation.

Demonstration of developed application to the end users

CLIENT: CHICAGO TRIBUNE’S LAW BULLETIN, Chicago, IL Aug 2007 - May 2008

Programmer Analyst for Suits, Liens and Judgments

RESPONSIBILITIES:

Key member of team that facilitated releases for multiple projects developed in Java, J2EE, PowerBuilder, WebSphere, Oracle 9i

Detailed analysis of CRs

Validate accuracy of data to ensure database integrity

Perform Unit and Integration testing

Coordinate deployments and documenting it.

Creating and optimizing SQL queries

Designed ad-hoc reports with SQL queries

B] ICICI Infotech Ltd., INDIA

CLIENT: BANK OF PUNJAB, Mumbai, India Jan 2004 – Nov 2004

Team Lead for Money Market Applications

RESPONSIBILITIES:

Developing RBI reports for the bank using T-SQL queries

Development and support of the application using PowerBuilder with PFC and Oracle 8i.

Detailed analysis of user requirements

Preparation of High level Design Specifications

Allocation and Monitoring of the tasks

Technical and Functional Query resolution

Mentoring team members and reviewing their work product

Unit Testing and Integration Testing and coordinating with the QA team for testing the new reports

Coordinating the User Acceptance Test for each rollout

CLIENT: ICICI SECURITIES, Mumbai, India Jan 2004 – Nov 2004

Team Lead for Derivatives-Interest Rate Swaps

RESPONSIBILITIES:

Analysis of the existing report, which consumed more time for retrieval of data.

Optimization of the reports developed in PowerBuilder, Oracle 8i.

RBI Report Customization according to the requirement

Mentoring team members and reviewing their work product

Documentation of the enhancements

Environment setup at the client side and coordinating the User Acceptance Test for each rollout

CLIENT: COMMERCIAL BANK OF CEYLON, Ceylon, Sri Lanka Jan 2004 – Nov 2004

Team Lead for Forex GAP Analysis and Real Time Gross Settlement

RESPONSIBILITIES:

Detailed analysis of user requirements

Technical and Functional Query resolution

Preparation of detailed design document

Training the team members

Review and Preparation of test cases

Development of the system in PowerBuilder 6.0, Oracle 8i.

Review of the work product of peers

Unit and Integration Testing

Environment setup at the client side

Coordinating the User Acceptance Test for each rollout

C] Company: Infomatics Services Pvt. Ltd. INDIA

CLIENT: MAERSK SEALAND CFS INDIA PVT. LTD, Mumbai, India Jul2000 - Jan2004

Project Leader for Container Freight Station and Out-Standing Freight Report

RESPONSIBILITIES:

Development using PowerBuilder 6.5, SQL SERVER 6.5. Datawindows and User Objects for the round Rent Charges, which was done manually by the users.

Developed an interface with the Customs Office, NSICT Port to exchange files in text format from Maersk CFS through radio link. Assist the Backup Operations scheduled daily and weekly with the help of VNC facility

SQL Server Database configurations, design and Front end design Interface in ASP.Net. Performed complete setup for a development server to perform testing before implementing into the live area.

Handling Runtime User Requests logged in the Helpdesk

CLIENT: BALZERS LTD. [Brazil] Jul2000 - Jan2004

Key member of team for Job Order Processing System

RESPONSIBILITIES:

Created SQL queries for reports for orders placed, Incoming and Outgoing inspection, Working Plan, Batch Inspection, Invoice Bill, Delivery Notes and MIS reports

Created and optimized various stored procedures and triggers for implementing the business rules using Oracle8i

Developed GUI using PowerBuilder 7.0

CLIENT: STANDARD CHARTERED BANK, Mumbai, India Jul2000 - Jan2004

Project Leader for Regulatory Statutory Reporting System

RESPONSIBILITIES:

Assist uploads (daily, weekly, monthly) of data in the form of text files into the Sybase Server that are downloaded from Singapore

Manage version control of application source code files developed using PowerBuilder 6.0

Task monitoring and Allocation of the Software Change Request (SCRs) logged by the user to team members

Detailed analysis of user requirements

Problem Solving for the team and business users countrywide and lead production support.

Assist Unit and Integration Testing Environment setup at client side

Formulated project plans, milestones, and was responsible for creating and maintenance of schedules.

D] Company: Lipi Infosoft Pvt. Ltd. Formerly Lipi Data Systems Ltd. - INDIA

CLIENT: LIPI INFOSOFT PVT. LTD., Mumbai, India Jun 1998 - Jul 2000

Programmer Analyst for Financial Accounting Control System

RESPONSIBILITIES:

Independently worked on the project from inception to completion which included the development of Database using SQL Server 6.5 and GUI using PowerBuilder 6.0.

Developed conceptual designs and modeled current and projected business workflow processes.

Gathered requirements, developed business and functional requirement documentation.

Certification

Certificate In Computing [CIC] from IGNOU, India

Oracle 8i Certified Course from B.A.R.C., India

Trainings

Rational Robot testing tool from ICICI Infotech, India

Effective Communication with the Clients from ICICI Infotech, India

ASP .Net Framework 3.5 using VC# programming and Visual Studio 2008 training provided by Century National Insurance, CA

SQL Server 2008 training provided by Century National Insurance, CA

Education

Bachelor in Science from Mumbai University, India

GNIIT, [Advanced Diploma in Computer Science] Mumbai, India

JAVA Programming, NIIT, Mumbai, India

Masters in Computer Application from IGNOU, India

Contact this candidate