Resume

Sign in

Developer Sql Server

Location:
Secaucus, New Jersey, United States
Posted:
October 27, 2016

Contact this candidate

RAMESH SEERANGAN

***** ***** ***** **. ************, FL 32258 M: 904-***-**** acw9pt@r.postjobfree.com

EXECUTIVE PROFILE

Senior Software Developer / Lead Architect.

Over 20 years of IT experience in software design, analysis, development, consulting and architecture. Focused on building scalable distributed architecture utilizing latest web, mobile and server based technology.

14 years in ASP.NET, C#, VB, .NET MVC, LINQ, WPF, WCF, Ajax development.

3 years in Bootstrap, Angular JS, HTML5, jQuery, Telerik, Silverlight development.

12 years in SQL Server, Oracle, DB2, MySQL database development.

8 years in Business Intelligence (BI) and ETL experience in SSIS, Informatica.

5 years in reports development in SSRS, Crystal Reports, iText.

Over 16 years of experience in software architecture, Object Oriented Analysis, Software Design, Database Design, Development and Performance Tuning.

Domain expertise in Finance, Investment Banking, Private Banking, Wealth Management, Healthcare, Manufacturing, Supply Chain and ERP.

An innovative team player proven to work under tight deadlines, Adaptable to new software technologies, quick learner and also can work efficiently as an individual.

TECHNICAL SKILLS

Operating Systems

Windows, Unix, Linux, Mac

Platforms

ASP.NET, C#, VB, MVC.NET, AngularJS, Bootstrap, jQuery, ADO.NET, Silverlight, WPF, Telerik, Microsoft Enterprise Framework, Entity Framework, SSIS, SSRS, LINQ, WCF, Web API, Crystal Reports, SignalR, iText, SQL Server Reports, Telerik Reports, Bigdata, NoSQL, Ajax, XML, XSLT, JAXB, JAX-WS, Web Services, Java, J2EE, Spring, Struts, Hybernate, Ibatis, PHP, Java Script, Shall Scripts, C, C++, HTML5, CSS5, EDI, PL-SQL, T-SQL

Databases

Oracle, SQL Server, IBM DB2, MySQL, MongoDB

Software Tools

Visual Studio, SQL Management Studio, SQL Profiler, SQL Tuning Advisor, Eclipse, SQL Developer, Rational Rose, Autosys, Oracle APEX, Oracle BI, TOAD, TFS, Volt, XML Spy, Jasper Intelligence BI tool

App Server

IIS, Microsoft Azure, Amazon AWS, Apache, Weblogic, Jboss

Mobile Development

iOS, Android, Xamarin, PhoneGap

Methodologies

Object Oriented Analysis and Design, UML, MVC, MVVM Architecture, Design Patterns, Agile and Waterfall

PROFESSIONAL EXPERIENCE

Independent Consultant Mar ’15 – Till Date

Web based Supply Chain Management System, Electronic Medical Record(EMR)

Interact with clients and gather requirement specification

Functional analysis

System design and architecture using object oriented analysis and design

.NET, C#, VB .NET, Ajax, MVC .NET, Bootstrap, AngularJS, Silverlight, Telerik development

WCF, Web API, Web Services development

SQL Server, Oracle Database development

Mobile application development using Xamarin, PhoneGap

Environment: ASP.NET, C#, VB.NET, .NET MVC, WPF, Silverlight, Telerik, Bootstrap, AngularJS, jQuery, Entity Framework, WCF, TFS, Visual Studio, iText, Crystal Reports, SSIS, SSRS, PL-SQL, T-SQL, NoSQL, Bigdata, SQL Server, Oracle, XML, Web Services, HTML5, MVC

Lead Architect / Sr. Developer Oct ’04 – Mar ’15

Bank of America Jacksonville, FL

Global Wealth & Investment Banking - Information Technology

Functional analysis

System design and architecture using object oriented analysis and design

Prepare Use case, class diagram, sequence diagram

Preparation of High level (HLD) and low level design (LLD) document

.NET, C#, VB .NET, Ajax, Silverlight, Telerik development

WCF, Web API, Web Services development

Real-time event notification development using SignalR

Desktop application development using .NET win forms, WPF, Silverlight and Telerik

Implementation of LINQ for querying, sorting, filtering the complex Objects

Implementation of ASP.NET globalization and localization for handling resources based on thread culture

SQL Performance tuning and create indexes using SQL Profiler and SQL Tuning advisor

Mobile Application development using Xamarin, PhoneGap

Database design and development

Database analysis and data profiling

Java, J2EE, Struts, C++, C development

Web application performance improvement

ETL jobs, PL-SQL and Informatica development

Development of ETL from Excel, Flat File, Oracle, SQL server to data warehouse by using DTS and SSIS packages

Development of workflows and financial packages using Smart Stream

Migrate J2EE application to .NET framework

Unix scripts development

Reports development using SSRS, Jasper Reports, iText, Telerik Reports, Crystal Reports

Review test cases

Setup SIT and UAT environment for application testing

Automate batch jobs using Autosys, Windows Scheduling, Unix scripts

Production move and production support

Lead Off shore and onsite developers

Environment: ASP.NET, C#, VB.NET, .NET MVC, WPF, Silverlight, Telerik, Bootstrap, AngularJS, jQuery, Entity Framework, WCF, Web API, SignalR, TFS, Java, J2EE, JSP, Struts, C++, C, Ajax, Visual Studio, Eclipse, Jasper Reports, Crystal Reports, SSIS, SSRS, PL-SQL, T-SQL, NoSQL, Bigdata, Informatica, Oracle 9i, 10g, XML, Web Services, HTML5, Weblogic, Unix, Linux, MVC, MVVM

Lead System Analyst - Consultant Apr ’04 – Oct’ 04

Citi Bank Jacksonville, FL

Citi Cards Online Application

Analysis and Technical design

Implementation using Java, Jsp and Servlets

Developed secure socket programs using Java

Database design

Developed PL-SQL Procedures

Developed Unix shell scripts

Environment: Java, J2EE, Servlets, JSP, Struts, C++, C, Oracle, Websphere, XML, XSL, JMS, Solaris, WSAD, Rational Rose, Rational Clear Case and PL-SQL

Team Lead / Architect / J2EE Developer / Database Administrator Jun ’01 – Apr ‘04

FlagshipMD Jacksonville, FL

HIPAA compliant healthcare billing and management system that submits claims, track payments and provides full service practice management for physician’s offices and billing companies

Team Lead for onsite and offshore development

Gathering and generation of requirement specification

Analysis

Developed use cases and activity diagrams using UML Methodology

Designed class and sequence diagrams using Rational Rose

Designed front-end

Developed Enterprise and Web modules using EJB, Servlets, JSP, XML and PL-SQL.

Developed reports module in PDF format using XML and XSL- FOP

Oracle database installation, database administration on Linux/Windows

Websphere installation and administration on Linux/Windows. Deployed EJB

Oracle Application Server installation, administration and porting from Websphere to Oracle Application Server

Linux installation and configuration of Telnet, FTP and CVS

Designed testing plan

Implemented HIPAA transactions including 837,835,270 and 271

Developed HL7 interfaces

Developed EDI modules for claims transaction and payment process

Environment: Java, J2EE, Servlets, JSP, STRUTS, Oracle, Websphere, Oracle 9i AS, XML, XSL, JMS, Linux, Oracle Application Server, UML, Rational Rose, Java Script, ANT, TOAD, Erwin, PL-SQL and HIPAA

Team Lead / Developer / Database Administrator Oct ‘00 – May ‘01

Project Management System Jacksonville, FL

Web-based Project Management System with online Task Manager, Project Status Monitor, Issue Tracker, Calendar and Bug-tracker

Team Lead for onsite and offshore development

Analyzed functional requirements to determine feasibility and produce design specifications

Developed use cases and activity diagrams using UML Methodology

Designed class and sequence diagrams using Rational Rose

Designed front-end

Developed Web modules using Servlets, JSP, XML and PL-SQL

Oracle database installation, database administration on Linux/Windows

Environment: Java, J2EE, Servlets, JSP, Oracle, Tomcat, XML, XSL, Linux, UML, Rational Rose, Java Script, Toad, Apache, Visual Source Safe and Flash

Team Lead / Developer Jun ‘00 – Sep ‘00

e-Med Soft Jacksonville, FL

Verification of physician’s credentials using centralized database administered by a nationally certified Independent Provider Association.

Designed and developed front end using Java-swing

Developed Servlets and JSP

Developed stored procedures using PL –SQL.

Environment: Java, Servlets, JSP, Swing, Oracle, SQL, Apache, Tomcat and Linux

Developer Oct ‘99 – Jun ‘00

Nextel Communications Reston, VA

Billing System.

Designed class and sequence diagrams using Rational Rose

Developed EJB, Servlets and JSP

Deployed application in Weblogic

Environment: Java, EJB, Servlets, JSP, C++, C, Weblogic, Solaris, SQL and PVCS

Developer Jul ‘99 – Oct’ 99

Invino Corporation Cambridge, MA

Grapevine Messenger, an interpersonal instant messaging package that enables the communication of text, pictures files, URLs, ActiveX objects and other elements between users and group of users

Designed and developed front end using Java-swing

Managed, monitored and integrated tasks assigned to the offshore team

Environment: Java, Swing, C++, C, MVC Design, Rational Rose, UML and Visual Source Safe.

Developer Jan ‘99 – Jul ‘99

Ernst & Young Cleveland, OH

Online real time auditing application to help E&Y auditors provide clients with auditing services

Designed class and sequence diagram

Designed front-end

Designed controllers using MVC Model

Developed Servlets and EJB

Developed front end using Java swing

Environment: Java Swing, EJB, Rational Rose, Weblogic, Oracle and UML

Developer Oct ‘98 – Jan ‘99

Sun Micro Systems Santa Clara, CA

JCK for Servlet 2.1 API implementation

Developed a test suite for specified Servlet implementation and conformance to test for Servlet syntax, semantics and expected behavior for an exhaustive list of Servlet API. It compares the real output with the expected output

Review test cases of Servlet 2.0 API

Prepare test plans and written test cases for the javax.servlet.http package

Environment: Solaris, Servlets and JCK (Java Compatibility Kit) and SCCs

Developer

SIP Tech - Chennai, India Aug ‘98 – Oct ‘98

Uthra Systems - Chennai, India Feb ’94 – Aug ‘98

Environment: C, C++, Cobol, Servlets, HTML, SQL Server, JDBC, Solaris and Java Web Server

EDUCATION

Bachelor of Electrical and Electronics Engineering (BS)

CERTIFICATIONS

Oracle Certified Database Administrator (OCP)

TRAINING

ASP .NET, C#, Visual Studio, WPF, WCF

RDBMS, Database Development, SQL Server SQL Tuning

ETL, SSIS, Informatica

Java, J2EE



Contact this candidate