Project Sql Server

• Babu Subramaniam

• Email Id: *******@*****.***

• Phone: 805-***-****

• Summary

I have 15+ years of experience in design, development and support of mission critical

business applications using formal software engineering and project management

methodologies. Has worked extensively with the onsite – offshore model and managed

large technical teams. Main responsibilities include client expectation management,

understanding of client requirements, develop proposals/solutions, team building,

designing and architecture of applications based on Microsoft's .Net & Java/J2EE.

Current responsibilities include extensive onsite interaction to understand expectations,

requirements, formulate solutions and designing and architecture of the application.

Transition the project to delivery, organization after obtaining the contract signoff.

Provide guidance to onsite and offshore teams.

Specific Expertise

• Over 15 years of IT experience in Application Design & Development,

Architecture, Implementation of Siebel CRM Claim System with various

platforms.

• Ability to analyze business requirements and translate them to software and

database designs to meet the business requirements.

• Extensive experience in implementation of Data Cleanup procedures,

transformations, Scripts, Triggers, Stored Procedures, Cursors, Functions and

execution of test plans for loading the data successfully into the targets.

• Expertise in SQL server DBA/Programmer activities and production support

activities.

• Extensive knowledge in the development of Stored Procedures, Triggers using

Oracle PL/SQL, Oracle 8i/8.0/9i/10g, SQL SERVER 2000/2005, T-SQL.

• Reviews project, mapping documents and identifies project deliverables,

associated specifications and completion criteria.

• Develops work breakdown structures, schedules and other documents necessary to

plan and monitor project completion.

• Provides timely status updates to all project stack holders.

• Monitors quality assurance function to ensure that established performance levels

are maintained.

• Communicating risks in clear business and technical terms provides clear

messaging and solution options at a senior leadership.

• Represent the development teams and communicate effectively with internal and

external organizations.

• Coordinate product release schedules and maintain product roadmaps.

• Project Planning and review of work allocation, Requirement, Analysis & Design,

Development, UNIT Testing, Joint Unit Testing, String Testing, providing project

support and maintenance.

• Collaborate with QA and Product teams to release software in a timely fashion

• Ensures project documents are complete, current, and stored appropriately.

• Keep track of major and minor releases, co-ordinate & plan the release cycle with

business, QA and System administrators.

• Managing overall coding and design standards that are followed by development

team.

• Used Design tools like MS Visio, ERWIN to perform UML modeling.

• Strong in User documentation, project architecture, system specifications, project

planning, interaction with end users, schedule meetings, reviews, follow-ups and

preparation of test modules

• Extensive analysis carried out in Data migration and Implementation.

Managed the following Teams (MS.NET, Java/J2EE, Farmers.com,

•

Help Point Business System, HOP, OLEM, B2B/PINE, FILENET

(CONTENT MANAGEMENT SOFTWARE) and Middleware-SOA) to

integrate the HEART Claim Systems.

Experience on platforms --Windows and UNIX.

•

DTS Designer, DTS Import/Export, DTS Object Model in SQLServer

•

7.0/2000/2005/2008 (ETL).

Expertise in Sql server DBA/Programmer activities and production

•

support activities.

Extensive experience in implementation of Data Cleanup procedures,

•

transformations, Scripts, Triggers, Stored Procedures, Cursors,

Functions and execution of test plans for loading the data successfully into

the targets.

Extensive knowledge in the development of Stored Procedures, Triggers

•

using Oracle PL/SQL, Oracle 8i/8.0/9i/10g, SQL SERVER 2000/2005, T-

SQL.

Comprehensive working knowledge of Client/Server Architecture in

•

COM, COM+ and MSMQ Series.

•

Industry/Domain Focus

Insurance.

Banking (Core Banking Solutions – CBS).

Financial Services.

ERP.

Professional Experience

Cetera Financial Group, Los Angeles, California

Apr 2014 - Till Date

Technical Director / Application Development Manager / Architect

Broker Dealer and Institution Upgrade for SMARTWORKS.

Description

Smartwork web applications support for Broker Dealers and Institutions, It

features like Account opening, trading and portfolio maintenance. This smart

Works features a suite of integrated applications that can access with just one

click, without having to enter any separate user names or passwords.

Responsibilities

Managing the Overall project and maintains the deliverables on time from

offshore.

Managing the Overall Technical Functionality, Architecture and

application design & development.

Smartwork Portal developed based on Internet and Intranet applications.

SiteMinder Web Agents work with the Policy Server to authenticate and

authorize users for access to Web server resources using federation

Tokens.

SunGard’s solutions for risk management help you work across multiple asset

classes, trading and clearing platforms to better understand your

exposure, improve the visibility and understanding of risk across the

enterprise, and comply with regulations globally.

SunGard’s solutions provide pre- and post-trade risk management;

integrated, enterprise-wide market, liquidity, credit and operational risk

management; asset liability management; and trade surveillance.

Coded In C#, ASP.Net, xml, Ado.Net, Sql server 2008 and Web services.

Excellent Experience in writing Data Access Layers using ADO.net entity

Frame Work and LINQ to SQL.

Integrated BING REST API for vendor and agents.

Added support single sign on support by integrating the REST service with

Active Directory Federation Services 2.0. Coded a customs claims adapter

that mapped users authenticated via Windows Live and Active Directory

with their claims system.

Responsible for the SQL Server 2008 backend of the REST web service,

including database schema design, stored procedures, replication, and

performance tuning.

Web Application Development, Site Designing and site implementation

Activities.

Unit Testing in NUnit2.0, Integration Testing, Stress Testing etc.

Developed Components & Dynamic link libraries.

Maintenance of existing system and provide advanced level support.

Standards for complete lifecycle of projects in all applications and sites.

Working as a Subject Matter Expert, Programmer Analyst, able to Analysis,

Design, Coding, Testing & Implementing the application

Manages day-to-day operational aspects of a project and scope.

Manages client expectations throughout the life cycle of the project.

Reviews deliverables prepared by team before passing to client.

Effectively applies methodologies (Waterfall and Agile Scrum) and enforces

project standards.

Prepares for engagement reviews and quality assurance procedures.

Minimizes exposure and risk on project.

Windows Workflow Foundation is used to create applications that execute an

ordered business process.

Actively manages project issues to resolution.

Ensures project documents are complete, current, and stored appropriately.

Application Support and Release Support.

Pilot Site(s) Testing.

Deployment and Backup process.

Environment: Win 2000/2003/2012, Azure, IIS, WAS, .Net Framework 2.0/3.5,

Java, J2EE, JQuery, ASP, ASP.Net, MVC, WCF, WPF, C#, SIEBEL 8.0, HTML,

DHTML, XML, XSLT, Jscript, entity Frame Work, AngularJS, HTML5, CSS3,

JSON, FILENET, COM+, SAML, LDAP, Site minder, Active Directory, Test

Director, Harvest version control management, ALSB, OSB, Data Power,

GENTRAN, MS Project & Visio.

Farmers Insurance Group, Los Angeles, California

Jan 2010 - Apr 2014

Technical / Delivery Manager / Architect

CRN Redesign (HEART) – For Farmers Insurance Group.

Responsibilities

Managing the Overall Technical Functionality, Architecture and

application design & development.

Managing the Overall project and maintains the deliverables on time from offshore.

Conducted the code reviews and configuration reviews very often to validate the

functionality and performance impact.

Participated in a fully scalable WPF based client/server brokerage application using

C#, WCF, Entity Framework and SQL Server.

Coding the presentation layer using WPF and silver light and service layer using

Windows Communication foundation technology.

Unit Testing in NUnit2.0, Integration Testing, Stress Testing etc.

Maintenance of existing system and provide advanced level support.

SiteMinder Web Agents work with the Policy Server to authenticate and authorize

users for access to Web server resources using federation Tokens.

Working as a Subject Matter Expert, Programmer Analyst, able to Analysis, Design,

Coding, Testing & Implementing the application

Installing, configuring and maintaining DataPower appliances XS-40 and XI-50 as

XML security gateways and XML Integrators.

Worked on several EAI projects and used different ESB and SOA tools to develop

projects.

Highly experience in providing solutions in Service Oriented Architecture (SOA)

using IBM DataPower devices.

Seven years of professional experience in middleware technologies IBM DataPower,

WMB (WBIMB), and WebSphere MQ, WebSphere Application Server.

SQL Server Administration and SQL Queries, Stored procedures and triggers

Analyze performance of SQL Queries

Created role based dashboards, pages, reports with various views i.e. table, pivot,

charts, narrator, column selector etc. and various report prompts.

Developed and debugged Dashboards/ reports visibility with respect to user's

responsibility and web groups in an integrated environment.

Conducted meetings with Project Managers, Business Users and Business Analysts

during testing and deployment stage of the application development lifecycle.

Manages day-to-day operational aspects of a project and scope.

Manages client expectations throughout the life cycle of the project.

Excellent Experience in writing Data Access Layers using ADO.net entity Frame

Work and LINQ to SQL.

Reviews deliverables prepared by team before passing to client.

Effectively applies methodologies (Waterfall and Agile Scrum) and enforces project

standards.

Prepares for engagement reviews and quality assurance procedures.

Minimizes exposure on project using risk management software.

Actively manages project issues to resolution.

Ensures project documents are complete, current, and stored appropriately.

Environment: Win 2000/2003/2012, Azure, IIS, WAS, .Net Framework 2.0/3.5, Java,

J2EE, JQuery, ASP, ASP.Net, MVC, WCF, WPF, C#, SIEBEL 8.0, HTML, DHTML,

XML, XSLT, Jscript, Node.js, HTML5, CSS3, JSON, FILENET, COM+, SAML, LDAP,

Prolaw, Site minder, Active Directory, Test Director, Harvest version control

management, PEGA, MS Dynamics, ALSB, OSB, Data Power, GENTRAN, MS Project

& Visio, iOS, Android (iClaim and iFarmers Apps).

Farmers Insurance Group, Los Angeles, California

Sep 2007- Dec 2009

Project Manager (Offshore) / Architect

First Notice of Loss (FNOL) Project – For Farmers Insurance Group.

Responsibilities

Managing the Overall Technical Functionality, Architecture and

application design & development.

Working as a Programmer Analyst, able to Analysis, Design, Coding, Testing &

Implementing the application.

Managing the Overall project and maintains the deliverables on time from onsite and

offshore.

Managing the Overall Technical Functionality and application design.

Coding with C#, ASP.Net, xml, Ado. Net, SQL server 2000/2005 and Web services.

Write SQL Queries and analyze performance of SQL queries

Write Server scripts for data import

Maintenance of existing system and provide advanced level support.

Standards for complete lifecycle of projects in all applications and sites.

Environment: Win 2000/2003/2012, Azure, IIS, WAS, .Net Framework 2.0/3.5, Java,

J2EE, AJAX, JQuery, UI development, data analytics, data import, Prolaw, HTML5,

CSS3, ASP, ASP.Net, MVC, WCF, C#, SIEBEL 8.0, HTML, DHTML, XML, XSLT,

Jscript, JSON, FILENET, COM+, SAML, LDAP, Site minder, Active Directory, Biztalk,

Test Director, Harvest version control management, PEGA, MS Dynamics, ALSB, OSB,

Data Power, GENTRAN, MS Project & Visio.

Farmers Insurance Group, Los Angeles, California

August 2006- Sep 2007

Project Leader

Multi Car Project – For Farmers Insurance Policy Holders.

Responsibilities

Working as a Programmer Analyst, able to Analysis, Design, Coding, Testing &

Implementing the application.

Web Application Development, Site Designing and site implementation Activities.

Unit Testing in NUnit2.0, Integration Testing, Stress Testing etc.

Developed Components & Dynamic link libraries.

Maintenance of existing system and provide advanced level support.

Standards for complete lifecycle of projects in all applications and sites.

Environment: Win 2000/2003, IIS, .Net Framework, ASP, ASP.Net, C#, AJAX, JQuery,

UI development, data analytics, data import, SIEBEL, HTML, DHTML, XML, XSLT,

COM+, Test Director, Harvest version control management.

Farmers Insurance Group, Los Angeles, California

Nov 2005- July 2006

Project Leader

View my Claim – Customers - (www.Farmers.com)

Responsibilities

Working as a Programmer Analyst, able to Analysis, Design, Coding, Testing &

Implementing the application.

Couples of Components & Dynamic link library conversions, done from VB to C#.

Preparing unit Test cases.

Developed Components & Dynamic link libraries.

Standards for complete lifecycle of projects in all applications and sites.

Environment: Win NT/2000, .Net Framework, ASP, ASP. Net, Biztalk, C#, SIEBEL,

HTML, DHTML, XML, XSLT, COM+, Test Director, Harvest version control

management.

FriedStore, Brooklyn, New York

July 2005- Oct 2005

Project Leader

Friedstore online shopping- (www.FriedStore.com)

Responsibilities

Work includes development of Online Catalog viewing and Shopping cart

implementation for M.Fried Store

Currently working as a Tech Leader and which include designing analysis, prepare

development plans based on

Software Development Life Cycle (SDLC).

Developed Shopping Cart and implemented the features like catalog generation,

check in & check out Process, Credit card authorization, tax calculations etc.

Interacting with clients and assignment of work, development with managing the

project team.

Installations and Administration of SQL Server and Database design, estimate size for

table space, tables and indexes.

Creating Indexes, Tables & Maintain Schema setting Storage clause for Table spaces,

Tables, and Index & Rollback Segments.

Played an active role in testing the programs and Debugging.

Environment Win NT/2000, .Net,Framework Production: ASP, Asp.Net, NUnit2.0, C#,

HTML, DHTML, XML, Crystal Reports Backend Sql Server 2000/2005.

Keane India Ltd, India

April 2005- July 2005

Senior Software Engineer

Project Name: VB 6.0 to .Net Migration Project

Tata Consultancy Services, India.

May-2002 to April-2005

Senior Software Engineer

Project Name: Quartz - Core Banking Solution

Tata Consultancy Services, India.

Jan-2002 to April-2002

Software Engineer

Project Name: Usage of tools in Software Maintenance, (NSC)- CA

Elmaq Software Pvt Limited, India

Feb-2001 to Dec-2001

Project Name: ERP - Multi Agro Kemcana Prima – MAKP

Elmaq Software Pvt Limited, India

March-2000 to Jan-2001

Software Engineer

Project Name: ERP - Putra Bhima - PB

CERTIFICATION

Brain bench certified in C#, Asp.Net, .Net Framework & MS SQL Server

Administration.

Microsoft Certified Application Developer - Transcript ID=708715f

Obj104

Obj103

Obj102

Obj101

Obj100

TECHNICAL SKILLS

Languages: Proficiency in c#, Asp.net, COBOL, Pascal, C, VB.NET, VB

5.0/6.0,SQL and PL/SQL.

Web Skills: ASP.NET, MVC, ASP 4.0, IIS 5.1/6.0, HTML/DHTML, Java,

VBScript, JavaScript, XML, CSS, XSL, Jscript, JQuery, WFC DTD, XML

Schema Definition, WSDL, SOAP, JSON, J2EE, HTML5, Bootstrap, Node.js,

Dynamics, PEGA.

Distributed Technologies: Active-X,COM/DCOM, Remoting, Mqseries, Rest

&Web Services

Relational Databases: MS Access 2000, SQL Server 2000/2005, SQL server

DTS, ETL and Oracle 8.0/9i

Microsoft Enterprise Servers: BizTalk Server 2004/2006.

Operating Systems: Windows NT/2000/XP, DOS, UNIX, Linux, Azure,

Windows Server 2003 and 2012.

DB Concepts: ADO.NET, ADO, RDO, DAO and ODBC.

CASE Technologies: Rational Rose and UML.

DB Designing Tools: ERWIN 4.0 and VISIO 2000/2006.

Reporting Tools: Crystal Reports 8.0/11.0 and Brio Reports.

Version Control Tools: Visual Source Safe and Harvest Control.

Server Monitoring Tools: Wireshark and Tivoli.

Middleware: ALSB, OSB, sFTP, FTP, DATAPOWER and GENTRAN.

Mobile Technology: iOS, Android (iClaim and iFarmers Apps).

PM Tools

: MS Project & Internal Project Tracker.

Educational Qualification

Bachelor of Business Administration from Madras University.

Master of Computer Application from Sri Chandrasekharendra Saraswathi Viswa

MahaVidyalaya.

Diploma in Client-Server Technology from SSI.

Contact this candidate