SUDHARSHAN KRISHNAN Cell: 512-***-****
*** ********* ****** ******** ** 13210 Email:******.**@*****.***
PROFESSIONAL EXPERIENCE
School of Information Studies, Syracuse, NY Aug 2008-Mar 2010
Database Analyst/Developer
Event Management Database System
There are various events that are held by the School of Information Studies, Syracuse University throughout the year. The data about
these events are stored in separate databases and is documented in paper forms and reports. The primary purpose of this project is to
develop a common transactional database which integrates all the data in one place, thereby making it easier to make business decisions.
Oracle 10g was utilized for developing this database solution. The whole process is made more streamlined and paperless by creating
electronic forms and reports.
Responsibilities:
Interacted with the client and developed functional requirements documentation
Developed business rules for the application and created a fully normalized database model using Microsoft Visio.
Created and managed primary data base objects such as Tables, Views, Indexes, Sequences, and Synonyms
Created database schema owner and allocated table space for it
Created different kinds of users for the database and allotted specific roles and profiles for each user
Created Procedures, Functions, Triggers and Packages using PL/SQL to meet business requirements.
Used all control structures like IF, CASE, For, While Loops for standard PL/SQL programming.
Trapped Exceptions and Predefined Oracle Server Errors implemented through PL/SQL.
Created PL/SQL Packages for easier application design and improved performance.
Loaded data from flat files and XML files to the tables in Oracle database using SQL*Loader.
Developed electronic forms and reports using Oracle Forms and Oracle Reports features respectively.
Implemented hot backup mechanisms and also query tuning procedures
Cognizant Technology Solutions Pvt. Ltd, Chennai, India Jul 2006-Jul 2008
Programmer Analyst
Online Resume Management System
Online Resume Management project is for the company. The main aim of this project is to maintain a ready to access database of skilled
people in various areas for an easy conduct of the recruitment process. The design of this package is very flexible so that it can be
customized to the needs of any firm in case of necessity. The system contains a registration form. This allows for the registration. On
registering, a registration number is allotted to the concerned person for further reference. Easy search facility is incorporated into the
system to get the persons with the right skill sets.
Responsibilities:
Analysis of the system and design of the database.
Used EXPLAIN PLAN, ANALYZE, HINTS to tune queries for designed and developed a custom database (Tables, Views,
Functions, Procedures, Packages)
Identified different modules and their interdependencies and coding.
Encapsulated PL/SQL procedures and functions in packages to organize application.
Development of design document, coding, Unit testing and Integration Testing.
Have written Stored Procedures in PL/SQL.
Put an Index on tables when necessary.
Created Partition Tables.
Auto Insurance Application
The objective of this project is to develop business rules for a US based auto insurance provider- Certified Collateral Corporation (CCC).
These business rules are developed using business rule management system which allows for flexibility of the application and also
facilitates easy modifications to the business rules by both the business and technical people.
Responsibilities:
Gathered and documented business requirements by communicating clearly with the client
Developed a series of business rules using XSLT with the help of a business rule management system called Java Rules
Created highly flexible templates for embedding these rules using schema definition(XSD)
Devised a sound testing plan for effectively detecting bugs and incomplete logic in business rules, before product delivery, thus
resulting in significant cost savings.
Collaborated with developers, database administrators and project managers for moving the project work into production.
Got a ‘Star Performer Award’ for excellence in documenting requirements, developing project and test plans, interacting with
the customers and delivering high quality work to them before the deadline.
WildLand Security, Syracuse, NY Feb 2009-Apr 2010
Project Analyst
Sensor Project Plan
WildLand security is a startup company which produces sensors for tracking animal poachers in Africa, thereby preventing illegal
poaching activities. These sensors are produced on a very small scale and the company wants to ramp up the production process. An
exhaustive project management plan has been developed in order to facilitate the mass production of these sensors on a very large scale.
Responsibilities:
Organized team meetings with the client for collecting the business and technical requirements
Effectively managed a project team of five members and motivated them to complete their respective parts of the project
management plan
Created a detailed Work Breakdown Structure (WBS) using Microsoft Project that highlights all the tasks, sub tasks and
resource allocations for each work unit
Researched extensively about all the costs involved in producing the sensors and developed a robust budget plan for sensor
production in Excel
Identified a list of possible risks and opportunities that affect the production schedule and developed risk response and
contingency plans.
Designed a robust communication plan for an efficient flow of information between the various stakeholders involved in the
project
TECHNICAL COMPETENCIES
Operating Systems Microsoft Windows XP/VISTA/7, DOS
Languages SQL, PL/SQL,T-SQL,C, HTML,CSS, Python, UML, JavaScript
Databases Oracle 9i/10g,MySQL
Microsoft Office Suite 2007(Word, Access, PowerPoint),Microsoft Project 2007,
Tools
SQL *PLUS, SQL Developer, Microsoft Visio 2007, TOAD 9.0/9.6/9.7
ETL SQL*LOADER, Erwin and IMPORT/EXPORT,SSIS
RELATED COURSES
Data Administration Concepts and Database Management(Data modeling, Normalization, Database Architecture, Database
Development Lifecycle, Basic and Advanced SQL programming, Access database development, ODBC connections, Basics of Database
Administration, SQL Server database development, Data Warehousing concepts)
Advanced Database Management (Oracle 10g features, User Roles and Profiles, Table spaces,SQL*Loader, Import/Export, Utilizing
PL/SQL to create Stored Procedures, Functions and Triggers, Indexing, Oracle Forms and Reports, Hot and Cold backups, SQL Query
Tuning Procedures, Materialized Views, Oracle Data Warehouse Builder, Oracle Discoverer)
EDUCATION
Master of Science in Information Management
Syracuse University, School of Information Studies, Syracuse, NY.
Bachelor of Engineering in Electrical and Electronics (May 2006)
PSG College of Technology, Anna University, India.