Uploaded File
add photo
Sumanth
sumanthkatta@gmail.com
813-300-3863
5317 Martin Lane
Tampa, FL 33617
Systems Analyst/Technical Officer
18 years experience W2
0
Recommendations
Average rating
83
Profile views
Summary

  • Over 9 years of experience in Web Development, client-server-tier Enterprise technologies such as Java EE, .Net.  Worked on all phases of Software Development Life Cycle.
  • Proficient in developing Multi-Tier Enterprise applications using Java EE Standards, JSP, JDBC, Servlets, JavaBeans, Struts, JSF, Spring, ASP, VB.NET, XML, PL/SQL and JavaScript
  • Expert level experience in relational database design, implementation, performance tuning and Security of Oracle, SQL Server. Proficient in RDBMS such as DB2, MS Access.
  • Extensively used various development tools like Eclipse, IBM Rational Application Developer, and Visual Studio.NET
  • Excellent analytical, written, group communication, interpersonal and team building skills supported by good Project management skills.

Experience
Systems Analyst/Technical Officer
Banking/Financial
Dec 2007 - present
  • Serve as a primary liaison between business and development teams- Participate in design reviews and provide input to the design recommendations and information/data flow for distributed financial applications.
  • Detail technical design documents, translate business and functional requirements into programmed application modules
  • Develop/enhance software applications/modules for financial applications including web and thick client standalone applications, some of which handled more than million transactions a day. Major Applications include
    • Customer Service Platform
    • Settlement Claims Tracking
    • Front End Balancing
    • Cardholder Portal
  • Manage technical staff - onshore and offshore and coordinated development activities with cross functional teams
  • Configure continuous integration, build automation and deployment process for distributed applications using TortoiseSVN, CruiseControl, Ant, and subversion.
  • Identify application defects and assist team members troubleshoot/resolve code-related issues.

                                                                       

Java BEA WebLogic Eclipse JSP JavaScript Visual Studio Swing Solaris Java Servlet PL/SQL EJB XML Oracle BaSH J2EE Ant SVN Continuous Integration System Analysis
Remove Skill
Research Analyst
Education
Nov 2004 - Dec 2007

Hillsborough choice is a pupil placement, tracking, and school capacity management system for the 8th largest school district in the US with over 200,000 students. Hillsborough choice consists of two applications, Enterprise System and Student Application Management System (SAMS).  SAMS allowed parents to login to a secure environment, retrieve student information, look up transportation options, school choices, make appropriate choice selections, and respond to choice offers. Applications receive from SAMS are processed and stored along with student demographic information retrieved from CA/Datacom on Mainframe Z/OS v1.4 into SQL Server database. Administrators and choice staff use the Enterprise System to manage student applications and assist SAMS users. The web applications are designed using MVC Design pattern and developed in IBM Rational Applications Developer 6.0 using JSP, Servlets, Java Beans, JDBC, JNDI deployed on IBM WebSphere 6.0.  The students were later placed used a points based random lottery Client/Server GUI system built using Visual Studio.NET 2003.

Responsibilities:

  • Worked on all phases of software development life cycle including Requirement Analysis and Specification, Design, Development, Integration and System Testing, and Implementation.
  • Involved in the design and implementation of database in MS SQL Server 2000.
  • Involved in creation Several DTS packages, stored procedures and creation and scheduling jobs.
  • Involved in design and development of the web application in Java using JSF, JSP, Servlets, and JavaBeans.
  • Involved in creation of windows GUI Components in Visual Basic .NET.
  • Analyzed, Designed and Developed components for business logic.
  • Involved in design and implementation of database interaction using JDBC and JNDI for Data Sources: CA/Datacom, and DB2.
  • Involved in unit testing and deploying onto production using IBM WebSphere 6.0 on Linux server.
  • Involved creation of address dictionary from the district GIS map and storing the spatial data in MS SQL Server 2000 for easy retrieval of information such as with school boundaries, Regions, Zones.

Environment:  JSF, JSP, Servlets, Java Beans, JDBC, JNDI, AJAX, JavaScript, VB.NET, PL/SQL, XML, CA/Datacom, DB2, Windows 2003, Suse Linux Enterprise Server 9.0, AIX 5.2,  IBM WebSphere 6.0, IBM Rational Application Developer 6.0/7.0, Visual Studio.NET 2003, MapInfo Professional 8.0.

SQL Stored Procedure Linux Java SQL Server
Remove Skill
Applications Developer/Webmaster
Education
Nov 2002 - Nov 2004

Project: School Locator and District School Transportation

School Locator and District School Transportation modules are web based tools of an application built to help parents of school district children locate their attendance area school based on residential address and identify transportation options for various schools with their attendance area boundary. 

Responsibilities:

  • Involved in design and development of web interface using ASP.
  • Involved in designed and Development of components for business logic.
  • Involved in design and implementation of database in MS SQL Server 2000.
  • Involved in design and implementation of database interaction using ODBC.
  • Involved in unit testing and deploying onto application server.

Environment: ASP, Microsoft IIS, MS SQL Server 2000.

Project: GeoElections WebTools©

GeoElections WebTools© provides the elections office for counties in US (widely used in Florida) with the power to offer their voters the ability to access elections data through interactive maps on the World Wide Web. The application allowed the web user to search their address and locate it on map along with their voting precinct information. Interactive map layers included: Precincts, School Board Districts, County Commission Districts, City Council Districts, Fire Districts, Water Districts, Special Taxing Districts, State House or Assembly Districts, State Senate Districts, Federal Congressional Districts.

Responsibilities:

  • Involved in system analysis and design process.
  • Involved in design and implementation of database using MySQL 4.1.
  • Involved in development of web interface in HTML/DHTML, JavaScript and PHP.
  • Involved in installing and configuring Apache web server.
  • Involved in deploying the application on the web server.
  • Involved in developing a tool that uses batch processing to build web files and deploy the application on the web server.
  • Involved in developing a tool that allows users to configure application specific parameters.

Environment: HTML/DHTML, JavaScript, PHP, MySQL 4.1, Apache 2.0.53, Adobe SVG, Windows 2003, DreamWeaver MX.

Project: GeoChoiceSQL®

GeoChoice® is a solution designed for Magnet or Traditional programs, implemented as a controlled, zoned or open plan, offering centralized control with access for information inquiry and application submittal across the web.  The system was developed using MapInfo Professional and SQL Server GeoChoice in order to accomplish the ease-of-use offered by Geographic Information Systems (GIS) to existing school management systems leveraging both the office and World Wide Web. It is a Multi-user application with three levels of access and progressive functionality.

Responsibilities:

  • Involved in system analysis and design process.
  • Involved in designing and implementing a relational database in MS SQL Server 2000.
  • Involved in development of the web interface using asp that requires users login and make school choice selections.
  • Involved in development of the windows GUI Interface of the application to interact with SQL Server using ADO.NET.
  • Involved in developing tools to import and export data, create stored procedures, and triggers.
  • Involved in unit testing and integration.
  • Involved in creating an installable package using InstallShield.

Environment: ASP, VB.NET, ADO.NET, MS SQL Server 2000, IIS.

Project: GeoCensusIQ©

GeoCensusIQ© is a tool that provides the user with an easy-to-use means to link demographic data from the US Bureau of the Census with various levels of geography also derived from the US Bureau of the Census. The application is a windows GUI interface that retrieves data from SQL Server, creates portable MS Access databases and generates maps with demographic data geocoded on the map.

Responsibilities:

  • Involved in design and development of the windows GUI Interface in VB.net.
  • Interact with SQL Server to process and retrieve demographic US census data based on the user criteria by creating DTS package and export data to MS Access database using the GUI Interface.

Environment: VB.Net, MapInfo professional 7.5, MS Access, SQL Server 2000, Windows server 2003

Project: Company’s corporate Website design, web server and email server setup

  • Solely Responsible in creating corporate website using HTML/DTHML, JavaScript and PHP.
  • Responsible for all the day-to-day operations of the websites including site content, search engine, database maintenance, site tracking and statistics, etc
  • Solely Responsible in setting up and maintaining email server using Microsoft Exchange Server 2003.
  • Solely Responsible in setting up Name Server, Active Directory and creating the Forward Lookup Zone and Resource Records.

Environment: HTML/DHTML, JavaScript, PHP, Microsoft IIS, Windows Server 2003, Microsoft Exchange Server 2003, Dreamweaver

ADO.NET Apache HTML IIS JavaScript MySQL PHP SQL SQL Server Stored Procedure Triggers Adobe Dreamweaver Project Management Microsoft Exchange MS Active Directory Windows Server System Analysis Windows
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Master's in Management Information Systems
University of South Florida, 2000 - 2002
Bachelor's in Engineering
Hyderabad India, 1996 - 2000
Skills
System Analysis
2021
15
Continuous Integration
2021
12
Java
2021
12
SVN
2021
12
Ant
2021
11
JavaScript
2021
11
BaSH
2021
9
BEA WebLogic
2021
9
Eclipse
2021
9
EJB
2021
9
J2EE
2021
9
Java Servlet
2021
9
JSP
2021
9
Oracle
2021
9
PL/SQL
2021
9
Solaris
2021
9
Swing
2021
9
Visual Studio
2021
9
XML
2021
9
SQL
2007
5
SQL Server
2007
5
Stored Procedure
2007
5
Linux
2007
3
ADO.NET
2004
2
Adobe Dreamweaver
2004
2
Apache
2004
2
HTML
2004
2
IIS
2004
2
Microsoft Exchange
2004
2
MS Active Directory
2004
2
MySQL
2004
2
PHP
2004
2
Project Management
2004
2
Triggers
2004
2
Windows
2004
2
Windows Server
2004
2
Microsoft Excel
0
1