ANUP BHAGWAT

**** ********* ******., ***. #*

Cincinnati OH 45220

Email: jy4t3t@r.postjobfree.com

Mobile: 216 – 544 – 0910

OBJECTIVE:

Seeking an opportunity in data analysis and database management that leverages my graduate education and technical skills. Willing to relocate as required.

SUMMARY OF QUALIFICATIONS:

• Around 2 years of experience in Information Technology.

• About 2 years of experience in MS SQL Server, Oracle 10g/9i.

• Designed, developed and implemented SSIS (SQL Server Integration Services) packages / DTS (Data Transformation Services) packages.

• Experience in creation of drill down analysis reports using SSRS (SQL Server Reporting Services).

• Involved in DBA activities like creating users, assigning user credentials etc.

• Extensively generated applications in MS Access using VBA (Visual Basic for Applications).

• Assisted data modelers in data modeling, designing and implementing databases.

• Experience in ETL using SSIS Packages/DTS packages and SSAS (SQL Server Analysis Services).

• Experience in working in Star and Snowflake Schema model.

• Versatile team player with excellent analytical, presentation and inter-personal skills.

• Masters Degree in Information Systems from University of Cincinnati with a CGPA of 3.82.

• Bachelors Degree in Computer Engineering from University of Pune, India (in the top 10% all over Pune, India).

TECHNICAL EXPERTISE:

BI/ ETL Tools: SQL Server 2005/2008 SSIS packages

Data Modeling Tool: ERWin 4.0

Databases: MS SQL Server 2005/2008, Oracle 10g/9i, MS Access

ERP: SAP R3 (FI, MM, PP, SD, QM)

Languages: SQL, PL/SQL, VBA, C, C++, Java

Office Suites: MS Access, MS Visio, MS Word, MS Excel

Web Tools: ASP .Net, HTML, XML

Operating Systems: Microsoft 95/98/2000/XP/NT, UNIX, Linux

Miscellaneous: Active Directory, Novell NetWare, Batch Scripting, Dreamweaver

PROFESSIONAL EXPERIENCE:

GIW Industries, Inc., Augusta – GA

July 2009 – March 2010

Database Management / Production Support

GIW Industries manufactures slurry pumps and systems for high wear applications. It produces wear resistant parts for severe duties including minerals mining, oil sands, dredging and flue gas desulphurization.

Roles and Responsibilities:

• Worked extensively on SQL Server 2005/2008, MS Access.

• Created new applications/data marts for the Marketing Dept., Project Management team, Sales and Services etc.

• Developed an Access-SQL system for the Marketing Department to handle costing/pricing of pumps and creation of custom pumps - improving efficiency by 80%.

• Responsible for improving the structure of the SQL Server 2005 database for the ‘Sales Marketing and Response Team’.

• Designed SSIS packages for handling quotations and orders, thus reducing maintenance time by 50-60%.

• Created drill down analysis reports using SQL Server Reporting Services.

• Assisted and was involved in data modeling for different data marts for individual departments.

• Extensively worked in the star schema and snowflake schema.

University of Cincinnati – Office of Admissions, Cincinnati - OH

January 2009 – June 2009

Systems Administrator

The Office of Admissions is responsible for the handling and processing of all the undergraduate and graduate applications in the University of Cincinnati.

Roles and Responsibilities:

• Handled campus wide database for user access rights.

• Manage and troubleshoot network, audio-visual equipment and install computer systems for the college.

• Improved payroll database access time by over 50% by developing batch scripts.

• Resolving issues arising in the Active Directory and Novell NetWare directory structures.

Calsoft Pvt. Ltd., Pune - India

July 2007 – June 2008

Database Developer

Calsoft is a leading provider of software product development services to technology companies developing solutions for the storage, networking, databases, virtualization and related markets.

Roles and Responsibilities:

• Worked extensively in the SQL Server 2005 environment.

• Assisted and was involved in all stages of the Software Development Life Cycle for the development of database applications.

• Involved in the regular maintenance of internal databases by creating new stored procedures, triggers and functions and creating new SSIS packages for improved efficiency.

• Helped in data analysis by generating relevant reports and queries.

ACADEMIC PROJECTS:

University of Cincinnati, Cincinnati – OH

September 2008 – Present

• Database Application Development:

- Designed and developed an end-to-end database application for a goods shipping company.

- Performed requirements gathering and created entity relationship models.

- Created and normalized relational database tables.

- Developed queries, triggers, views, procedures, assertions and functions using SQL, PL/SQL.

• Business Process Modeling and Design:

- Modeled and designed a business workflow process using the Business Process Modeling Notation (BPMN) for the management of the order to cash cycle of a Third Party Logistics (3PL) transport company.

- Developed data flow diagrams and sequence diagrams.

• Project Analysis, Citigroup, Inc.:

- Conducted analysis of an ongoing IT project - Application Retirement Management at Citigroup Inc., Cincinnati.

- Provided recommendations to the management on process-streamlining, cost-cutting and long term benefits.

University of Pune, Pune, India

September 2007 – June 2008

• Internet Small Computer System Interface (iSCSI) Enhancement:

- Collaboration between University of New Hampshire, NH and Calsoft Pvt. Ltd., India.

- Enhanced the functionality of the open source iSCSI protocol by adding 4 new features.

- Improved remote user access time by 70-80%.

- Achieved Concepts '08 and Finepro '08 awards for Best Project at national level.

EDUCATION:

Master of Science in Information Systems, University of Cincinnati, Cincinnati – OH

Expected June 2010

CGPA: 3.82 / 4.0

Relevant Coursework: Data Modeling & Database Design, Advanced Database Management, Business Intelligence &Data Warehousing, Systems Analysis and Design, Process Integration with ERP, Project Management, Web Systems & Services

Bachelor of Engineering in Computer Science, University of Pune, Pune – India

June 2004 – June 2008

First Class with Distinction (72% aggregate – in the top 10% in Pune)

Contact this candidate