Database Intern Resume Peoria, IL - Hire IT People

SUMMARY

Enthusiastic software developer, with over 6+ years of IT experience in JAVA and data warehousing
Excellent educational background with 4.0/4.0 GPA in Masters in computer Science from Bradley University, Peoria IL
Extensive work experience in developing application using Struts, Spring MVC framework, JSP, Hibernate, Jquery, HTML5 and Javascript
Expert in SQL with strong hold in databases such as Oracle, MySQL and Microsoft SQL server
Experience in data warehousing using various ETL tools such SSIS, Informatica and reporting tools like business objects and SSRS
Hands on experience with complete software development life cycle and exposure to proven software engineering methodologies.
Ability to Communicate and interact effectively with business users/customers.
Have excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels and work as a part of a team as well as independently.

TECHNICAL SKILLS

Operating Systems: Windows 2000/XP/NT, UNIX

Languages: JAVA, C, C++, Lotus Notes

Databases: Oracle, MS SQL Server 2005.

ETL/Reporting Tools: SSIS, Informatica, Data Integrator, Business Objects

Trainings received: Abinitio, Data Integrator, Lotus Notes (v5.0.11), Lotus Script and Formula Language

PROFESSIONAL EXPERIENCE

Confidential, Peoria, IL

Responsibilities:

Working closely with users for requirement gathering and analysis of various sub - modules of the system
Implemented Strut MVC framework and developed various action, form, service, and helper classes for user interaction and database handling
Developed Web-page using JSP
Implemented persistence layer using Hibernate.
Written lot of complex SQL queries
Used lot of new functionalities like Modal window, Jtable, Overlay and validation functionalities using JQuery and java script
Developed unit test cases using junit.

Environment: Java developer - Java, Struts, Hibernate, JSP, Jquery, Javascript and SQL

Confidential, Peoria, IL

Database Intern

Responsibilities:

Developed software to read data (backend for one User data entering tool) from XML files and loading into MS SQL Server tables

Environment: MS SQL Server 2005, XML

Confidential

Team Lead

Responsibilities:

Migrated Oracle data warehouse to MS SQL Server 2005 and rigorous tested for data validation.
Developed ETL source-target SSIS packages to populate existing data warehouse with data of property (insurance purchased by Confidential ’s customers) and executive product group
Tested the incremental levels for timely records on periodic sale forecast for continuous business growth
Led a group of 8 team members to implement understanding of business

Environment: SSIS, MS SQL Server 2005, Data Integrator

Confidential

Team member

Responsibilities:

Generated and corrected reports in Business Objects as per clients’ requirements

Environment: Business: Objects XI R2

Confidential

Team Lead

Responsibilities:

Environment: Informatica 7.1, Business Objects XI R2, Oracle 9i

Confidential

Team Member

Responsibilities:

Designed, developed and maintained Lotus Notes applications for food products and employee details
Achieved order-to-delivery goals set on three priority levels by providing 24 hrs. 7 days a week support

Environment: Lotus Notes 5.0/6.0