We provide IT Staff Augmentation Services!

Database Analyst Resume

3.00/5 (Submit Your Rating)
Hire Now

SUMMARY

  • 2.5+ years of experience in database development/administration/analysis.
  • Created database design on business requirements, T-SQL stored procedures, functions, views, triggers.
  • Performed database backup/restoration, performance tuning, ETL (Extract, Transform, Load).
  • A self-motivated, organized, responsible, and reliable team player.

EDUCATION

  • MS in Management Information Systems
  • BS in Computer Science
  • Oracle Certified Associate(OCA)-Oracle 9i, Database Administration
  • Microsoft Certified Technology Specialist(MCTS)- SQL Server 2008, Database Development

TECHNICAL SKILLS

  • Databases: Oracle 9i, SQL Server 2008, MySQL 5.0, MS Access 2007, PL/SQL
  • Programming Languages: T-SQL, PL/SQL, CSS, XML, PHP, ASP .Net, C#, Java
  • ETL: Scribe, SSIS, SSRS
  • Methodologies: Software Development Life Cycle, Object Oriented Analysis and Design, MVC, Object Relation Mapping
  • Tools: Visual Studio 2008, MS Project, SPSS Clementine, SAS, MS Visio, Oracle 10g, SQL Server 2008

EXPERIENCE

Database Analyst Intern, Confidential, Chicago, IL Jan 2010 - Present

  • Working on a SQL Server 2005 based database migration/integration project in which customer data has to be migrated from the accounting application (Great Plains) to CRM application (Saleslogix) in batches using Scribe as an ETL(Extract, Transform, Load) Tool.
  • Configured the source and the target adapters using the existing functional requirement document.
  • Currently, developing the DTS (Data Transformation Specification) scripts for data mapping between the source and target.

Web-Database Developer/Administrator, Confidential, Chicago, IL Sept 2008 - Present

  • Developed/maintain various web-based applications using ASP.NET 3.5/C# & SQL Server 2005 that are scalable.
  • Performed database tuning, created T-SQL stored procedures, views, functions, triggers, database alert scripts, schedulers, monitoring scripts and backup procedures on 2 production and 2 development servers.

Database Developer, Confidential, Chicago, IL Aug 2009 - Dec 2009

  • Created business requirement specification along with functional and technical requirements for a product called Fina Mobile.
  • Designed and implemented database schema and interfaces (ODBC) using SQL Server 2008 in collaboration with the programming team.

IT Consulting Service Team Member, Confidential, Chicago, IL Aug 2009- Dec 2009

  • Worked closely with Littelfuse's CIO to devise strategy & policy for the IT department by benchmarking them with peers.
  • Collected industry standard Best Practices.

Assistant Database Administrator, Confidential, India Jun 2007 - April 2008

  • Provided Oracle 9i DBA support to the existing inventory tracking applications.
  • Profiled and tuned servers on a monthly basis to ensure fast queries and reports.

ACADEMIC EXPERIENCE

  • Developed an e-commerce application for selling music and e-books online on SQL Server 2008 and ASP.NET 3.5/C#.
  • Worked on a data-mining project which will facilitate an organization to identify potential donors(Models: CHAID, Neural Networks)

RELATED COURSEWORK

Advanced Database Management System, Business System Analysis and Design, Data Mining for Business, Enterprise Application Infrastructure, IS Project & Program Management

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship