Software Developer\ SQL Developer

PRANAV DHRUV

**** * ******* *****, ***#*** Long Beach, CA 90815

Cell No: 714-***-**** E-Mail: ***********@*****.***

CAREER OBJECTIVE

Seeking a job as Software \ Database Developer where I can apply my technical skills to assists the organization in achieving its goals.

SUMMARY

1) 3+ years of industry experience in Software Development and Database programming.

2) 2 years of experience in design, development and implementation of Client/Server and Web Applications in JDBC, JSP and Servlets.

3) Good working knowledge of VB.NET, Infragistics Windows form control and C#.NET using Visual Studio 2005.

4) Good knowledge in client side scripting JavaScript, AJAX, HTML/DHTML and experience with CSS and Infragistics.

5) Expert in writing SQL queries, Stored Procedures, Functions, Indexing and Triggers.

6) Good working knowledge of backup and recovery process in MS SQL 2005.

7) Extensive skill in data transformations and data loading.

8) Proficient experience in Jasper Reports, Crystal Reports, MS Access reporting services.

9) Engaged in direct client interactions and business decision making.

10) Experience in providing technical support to clients and end users.

TECHNICAL SKILLS

 Operating System: - Windows 98, XP, 2000, 2003, Vista, Windows 7

 MS.NET Technologies: - VB.NET 2005, C# 2005, VBA, ASP.NET

 Programming Languages: - J2SE, JSP, Servlets, J2ME, C, C++

 Web Development: - HTML, DHTML, Javascript, CSS, XML, AJAX

 Database: - Microsoft SQL Server 2000/2005/2008, Oracle 9i, MS Access 2003/2007

 IDE/ Software Tools: - Visual Studio.NET 2005, Infragistics, NetBeans, Toad, Crystal Report, MS Office, MS Visio, Tortoise SVN.

 Web Servers: - IIS 6.0, Tomcat 4.1, Web Sphere

WORK EXPERIENCE

1) IT Intern, Bumble Bee Foods, LLC. (www.bumblebee.com) (June 2008-Present)

Responsibilities:

1) Developed GUI using VB.NET 2005.

2) Designed logical and physical database in MS SQL 2005.

3) Used Wingrid and Winchart control from Infragistics.

4) Developed various reports and charts within the application. All reports are downloadable to excel format.

5) Performed Unit and Integration testing for both the applications.

6) Good working knowledge of installing and configuring MS SQL 2005\2008 server.

7) Wrote complex SQL queries, Views, Indexing and Stored procedures.

8) Created maintenance job and send SQL Email alerts to the Database administrator.

9) Develop monthly fish supplier report by retrieving data from MS SQL 2005, MS Access 2003, SAP and MS Excel.

10) Maintain sound backup and recovery policies and procedures for MS SQL 2005 server.

11) Maintain documentation on installing various applications.

12) Provide technical support to end user and log them in iHelp system with solutions.

 Great Attendance System: Designed and developed an application/Database for HR to supervise the leave of each employee.

Technology used: VB.NET 2005 and Microsoft SQL Server 2005.

 QC Incident Tracking: Designed and developed application/Database for the QC department to track and report various QC incidents.

Technology used: VB.NET 2005, Crystal Report and Microsoft SQL Server 2005, .NET Controls for rich windows forms by Infragistics.

 iDashBoards: Developed various charts and reports using idashboards. Used both Excel and MS SQL Server 2005 as data source for idashboards.

 MS SQL Server 2000 to 2005 Migration: Successfully implemented migration of MS SQL 2000 to MS SQL 2005 server.

 I.T. Administration: Developed MS SQL 2005 database backup and recovery process, Troubleshoot\ Maintenance of Laptops, Desktop machine and Printer. Install various software’s and Windows XP \ Windows 7 on end user machine. Provide support for various other applications deployed by different vendors.

 FWi Digital Signage: Deployed the Signage player and Content manager for test environment. Created new template for Bumble Bee. Working on various content that need to be displayed on the digital signage.

2) Graduate Assistant, Dept. of Finance, CSULB: (Jan 2008-May 2008)

Responsibilities:

1) Developed GUI using VB.NET 2005.

2) Developed PL/SQL blocks in MS SQL 2005.

3) Used multi threading for buying and selling various stocks.

4) Wrote different class and function to automate various business processes like fetching real time quotes, forecasting future quotes.

5) Performed Unit and Integration testing on each module.

 Algorithmic Trading using Real Time Exchange Data: Developed Algorithmic Trading simulation to assist traders to strategize stock market transactions.

Technology used: VB.NET 2005 and Microsoft SQL Server 2005.

3) Software Developer and Team Leader, Cyber Managers Pvt. Ltd. (July 2005-June 2007)

Responsibilities:

1) Handled team of 4 developers.

2) Consulted with Clients to define system requirements.

3) Designed and Developed workflow based web applications (using business logic in Servlets, UI design in JSP).

4) Performed client side validation using JavaScript.

5) Cascading Style Sheets (CSS) were used to attain uniformity through all web pages.

6) Wrote code to authentication user with LDAP server.

7) Designed Database and wrote complex SQL queries, views, stored procedures.

8) Wrote batch files to send auto reminder emails daily to all users as per their role in the system.

9) Deployed application at client end and performed User Acceptance Testing.

10) Deployed application on web server like Tomcat, Websphere and Pramati.

11) Designed and provided training session for end users.

12) Used Tortoise SVN for version control.

13) Provided technical\functional support for various products.

 e-Ncompass- 360° FEEDBACK SYSTEM: Assists an employee to get feedback from various stakeholders. Various PDF reports were generated based on the feedback received.

Technology used: JSP, Servlets, Microsoft SQL Server 2000, Tomcat 4.1, Pramati Server.

 e-Nhancer- PERFORMANCE APPRASIAL SYSTEM: Help employees to plan and monitor their goals, also to do performance reviews. Various Web/PDF reports were generated.

Technology used: JSP, Servlets, Oracle 9i, Microsoft SQL Server 2000, Websphere.

 Sodhani Securities (Database Migration): Migration of Oracle 9i Database to MS SQL 2000. Successfully implemented migration of relational schemas, procedure, views, triggers and data.

EDUCATIONAL QUALIFICATIONS

 M.S., Computer Science (GPA: 3.45/4.0) Aug 2007 – May 2010

California State University Long Beach, California.

 B.E., Information Technology Aug 2002 - Mar 2006

Pune University, India.

ACADEMIC COURSES

Web Programming & Accessibility, Advanced Operating Systems, Database Architecture, Advanced Software Engineering, Software Test & Verification, Software Architecture, Discrete Structure & Computer Science Application, Distributed Computer System and Intro to Computer Security.

Contact this candidate