HOW SQL Experience Resume looks like ?

Leave a comment (0) Go to comments

A sample SQL Experience Resume, who has 5 years of experience.
 
Recently, I was being contacted by developer, who wanted to become an DBA and wanted his resume to look like a experience DBA. His current Resume looks likes this and he wanted to transform his current Resume like an Experience SQL DBA Resume. I asked him to refer a sample Experience SQL DBA Resume, which I published sometime back specially for DBA’s.
 
You might also be interested in check how a BI SQL Server Developer Resume looks like too.
 

SQL Experience Resume

Bangalore, India, 560095


E-mail : info@sqlerver-training.com

Curriculum Vitae

Professional Summary

  • 5 years of experience in IT industry, currently working as Technology Analyst.
  • Around 4.7 years of experience in Data warehousing and Business Intelligence.
  • Domain Knowledge of Energy Trading & Risk Management.
  • Worked at client locations in London (UK) & Houston ( US).
  • Strong experience on T-SQL and query optimization, developing ETL strategies.
  • Strong experience with SQL Server 2000/2005, SSIS, SSRS and SSAS
  • Basic understanding of writing and debugging MDX queries.
  • Project Experience on Informatica and Business Objects tools.
  • Good experience and understanding of database design, relational integrity constraints, OLAP, OLTP, Cubes and normalizations.
  • Experience on Service & quality management tools such as Remedy, JIRA, Mercury QC, and ClearQuest.
  • Experience on configuration management tools such as ClearCase and VSS.
  • Experience in creating Jobs, Alerts, SQL Mail Agent, and Scheduled SSIS Packages
  • Good understanding on .NET framework especially in ASP.NET client/Server technology.
    Flexible with work location, travelled globally mostly in UK, US, Europe & India.
  • Excellent communication skills bridging Client Interaction and Team Management.
  • Strong analytical, problem troubleshooting/solving skills, self-starter.
  • Experience at providing organizational trainings especially in BI tools.
  • Exposure to Proposal/Estimation Discussions and SMC model.
  • Certified as MCP and MCTS in SQL Server 2000/2005/2008 and Business Intelligence and .NET 2.0.

Awards/ Certifications/ Achievements

  • Microsoft Certified IT Professional for Microsoft Business Intelligence Developer 2005
  • Microsoft Certified Technology Specialist for Microsoft Business Intelligence – Implementation and Maintenance 2005/2008
  • Microsoft Certified Technology Specialist for Microsoft SQL Server 2005 ( Dec 2007 )
  • Microsoft Certified Technology Specialist for Microsoft® .NET Framework 2.0 – Application Development Foundation (April 2007)
  • MSBI-COE ( Center Of Excellence) anchor for Systems Integration – Business Intelligence Unit at Infosys.
  • Best Project Team award 2010 for EUS unit at Infosys.
  • Best Freshman Award (Jan-June 07) for Systems Integration – Business Intelligence Unit at Infosys.
  • Nominated as a Microsoft Student Champ, by Microsoft, at Manipal Institute of Technology (2006)
  • Topper at Infosys Foundation Training Program with a CGPA of 5.0/5.0 (Jun – Aug 2006) among 1000 professionals.
  • Microsoft Certified Professional for Microsoft SQL Server 2000 (June 2005)

Professional Experience

à        Infosys Technologies Limited, Bangalore ( Jun 06 - Till Date)

Client : British Petroleum ( BP)

Project : Risk Reporting

Houston, TX (2010-2011)

Bangalore, India(2010)

London, UK (2008-2009)

Technology Analyst(TA) (Dec 2008 – till date)

Team Size : 30

BP : 10 (Manager, BAs, Architect, DBA)

Infosys: 20 Onshore/Offshore

Project Overview

BP is one of the largest traders of oil and gas in the world. Integrated Supply and Trading (IST) team combines all Oil, Gas, Power, Chemical and Financial trading activities. Objective is the provide support and development for IST Risk Reporting, NAGP, GTEL MVAR & Oil MVaR applications and also address key weaknesses within the existing system.

Responsibilities

  • Support existing data warehouse reporting platform and applications to ensure operational availability and scalability
  • Work directly with functional analysts and business users in understanding the information needs of the business and developing new data warehouse/BI functionalities or tools to meet these requirements.
  • Assess existing and available data warehousing technologies and methods to ensure our Data warehouse/BI architecture meets the needs of the business unit and enterprise and allows for business growth. Provide recommendations on evolution of the architecture.
  • Research, define and deploy BI improvement opportunities and streamline the business intelligence processes
  • Create detail design, work on development and perform code reviews.
  • Analysis & implementation of better performance strategies.

Technologies:

  • Server : IIS, Analysis Services, Reporting Services, Integration Services,Informatica,BO
  • Programming – SQL,C#, ASP.NET
  • Operating System – Windows Server 2003
  • Configuration Management – IBM Clear Case
  • DBMS: SQL Server, Oracle, MS Access, Excel.
     

Client : Canada Pacific Railways ( CPR )

Project : Automated Inventory Reporting (AIR)

Bangalore, India

Business Intelligence – Technical Specialist(TS) ( Oct 2008 – Dec 2008)

Team Size : 8

CPR : 3 (Manager, CSE, Bas)

Infosys : 5 ( Manager, TS, Developer)

Project Overview

At CPR, Car Management metrics are used across various departments and are published to the Operations Dashboard and 0700 for senior Canadian Pacific management up to and including the President & CEO. The BI Initiative will provide a significant upgrade to the current Car Metrics process. Metrics will be centralized into a Car Management Portal in a supported BI environment. Data will have consistent business rules, hierarchies and standardized metrics and calculations.

Responsibilities

  • Develop technical architecture based on detailed requirements
  • Validate the technical feasibility of business requirements
  • Infrastructure, architecture and environment evaluation
  • Interfaces with Business users and Technical SMEs to clarify requirements, review design, test cases, UAT and deployment
  • Devising the Report delivery mechanisms
  • Ensures deliverables meet Quality standards
  • Training people in new technologies

Technologies:

  • Server : IIS, Analysis Services, Reporting Services, SharePoint Server
  • Programming – C#, ASP.NET
  • Operating System – Windows Server 2003
  • Configuration Management –MS Visual Source Safe
  • DBMS: SQL Server, MS Access, Excel.
     

Client : Underwriter Laboratories (UL)

Project : Datamart Reporting

Bangalore, India

Systems Engineer – Datamart Developer (Aug 06 – Sept 08)

Team Size : 13

Client: 7 (Manager, Bas, Architect, DBA, Dev)

Infosys: 5 offshore, 1 onsite Coordinator/BA

Project Overview

The primary objective of this project to build a robust and intelligent system that will help Business people to strategize based on analysis of conformed Facts and Dimensions. Designing and implementing the ETL processes which involves collection of data from heterogeneous sources like LotusNotes Databases, Oracle, SQL Server 2000/2005. Provide maintenance support for ETL systems. Creation of Datamarts. Incremental processes, LotusNotes Agents, Report Modeling, Creation of business reports, Dashboard reports, and also the maintenance of web reports using MS Reporting services 2005.

Responsibilities

  • Work closely with onsite Business Analysts for requirement gathering, designing the database and creating workflow.
  • Writing LotusNotes agents, ActiveX script for pulling data from LotusNotes db.
  • Designing and Implementing the ETL processes
  • Creation of Canned reports, Cube-Based Reports, Report Models for Ad-Hoc
  • Using Reporting Services Capabilities and 3rd party tools accordingly to build Dashboards.
  • Troubleshooting reports issues, ETL job failures, optimizing query performances.
  • Coordinating with onsite folks and leading and mentoring the offshore team.
  • Travel to various locations to train people in new project specific technologies

Technologies:

Server : IIS, Analysis Services, Reporting Services

Programming – C#, ASP.NET

Operating System – Windows Server 2003

Configuration Management – IBM Visual Source Safe

DBMS: SQL Server, MS Access, Excel, Lotus Notes Database

     

à        i2 Technologies Limited, Bangalore (Project Trainee) (Jan – May 06)

Project : Production Scheduler (PS)

Bangalore, India

Java Developer (Project Trainee)

Team Size : 16

Project Overview

Production Scheduler is designed to provide optimization-based scheduling, shop-floor synchronization, reactive re-scheduling, and complete reporting and analytics. Production Scheduler is a configurable scheduling application that produces detailed schedules for multi-stage manufacturing processes.

Responsibilities

§   Enhancements to the PS client and Server components, and also Customer issue fixes.

Technologies:

  • Server : OS(Optimal Scheduler)
  • Programming – Java, 3rd Party Widgets, Optimal Scheduler Language( i2 Proprietary Language)
  • Operating System – Windows Server 2003
  • Configuration Management – IBM ClearCase
  • DBMS: MS Access
     

à        Angel Movies Enterprises, Mumbai ( As a freelance ) ( May – June 2004)

Development of www.angelmoviesenterprise.org

Manipal, India

Web Developer

Team Size : 1

Project Overview

Angel Movies Enterprises is a professional & experienced production house (Domestic & International Market) in the following areas.

  • Feature-Films (Dhoop, U Bomsi N Me)
  • TV Software, Animations, Telefilms (Saturday Suspense etc…).

Responsibilities

§   Designing of complete website.

Technologies:

§   HTML, JavaScript, Flash, Dreamweaver.

     

Technical Skills

Languages : C#, C, C++, JAVA, T-SQL
Business Intelligence : SSIS, BIDS, SSAS, SSRS
Operating Systems : Windows 2003, XP, MS-DOS
Framework Experience : Microsoft .NET, J2EE
Web Technology : HTML, XML, Jscript, VBScript, ASP, ASP.NET, JSP, WebServices, Basic PHP
DBMS : SQL Server 2000/2005, ORACLE, MS Access, MySQL, LotusNotes databases
Configuration Management : Rational ClearCase, Visual SourceSafe
Service & Quality Management : JIRA, Remedy, ClearQuest, Mercury QC
Applications & IDE : Visual Studio.NET, Business Intelligence Development Studio, Visual Studio6.0, intelliJ IDEA, Eclipse, MS Office, Dreamweaver, LotusNotes Designer
Web Server : IIS, Tomcat

Training at Organization

  • Microsoft SQL Server 2005 by Synergetics-India at Infosys.
  • Microsoft ASP.NET 2.0 and its new features by Synergetics-India at Infosys.
  • Microsoft Certified Course on Programming and designing Database using MS SQL Server 2000 at NIIT, Bangalore (May 2005).
  • Advanced Migration from Business Objects 5.x\6.x to XI R2 at Infosys, By Business Objects.
  • Completed Infosys J2EE Foundation Training Program at Mysore, India.

Academic Details

Manipal Institute of Technology (MIT)

http://www.manipal.edu/manipalsite/Users/manipalhome.aspx

Bachelor of Engineering in Computer Science & Engineering

September 2002 – May 2006

Cumulative GPA: 3.6/4.0

Manipal, India

  • Graduated with High Distinction; among top 10 students of the batch.
  • Selected as a Microsoft Student Champ, by Microsoft, for the Microsoft Student Community at MIT.
  • Organized workshops, seminars and gave presentation on Microsoft Technologies.
  • Active participant in College sport’s events, Member of the college Hockey and Athletics Team, cross country runner, participated in football, cricket and indoor games.
  • Alumni of CSI (Computer Society of India), MAFIA (Music and Fine arts) clubs

Apeejay School

http://www.apeejay.edu/saket/home.htm

All India Senior Secondary Certificate Examination (Standard XII)

April 2002

Percentage: 75.8

New Delhi, India

  • First class with distinction; Top scorer in Computer Science subject
  • Active participant in Inter-school sports meets.
  • Member of School Volleyball, Football, Badminton & Athletics team.

Vidya Niketan – Birla Public School

http://www.bpspilani.com/

All India Secondary School Examination (Standard X)

April 2000

Percentage: 83

Pilani, Rajasthan India

§   First class with high distinction.

§   Member of School Hockey, Football, Cricket teams.

§   Member of Official School Band group, performed during Annual Events.

§   High Scorer at Indian Public School Conference General Knowledge Exams

Extracurricular activities

  • Participated in the Companies Cultural, Music Events and Workshops.
  • Organized trainings in Business Intelligence Domain for SI unit at Infosys Technologies ltd.
  • Active Member of Nascent Education and Society (Independent NGO), where I managed and organized local events in Bangalore, India. Latest event being “Clean Bangalore Drive”, where we installed Trash Cans (Dust bins) at various important & troubled crossings in the city.

Hobbies & Interests

  • Watching DVDs from classics to the latest, ive games, learning new technologies ( recently bumped into JQuery) or searching for the latest bestsellers in the bookstores.
  • Traveling is one of the things I really enjoy. Traveled extensively in India, UK , Europe, and US exploring places from aspects of rural/urban divide.

Last updated: 25 – Jan- 2012

SQL Experience Resume

EOF - HOW SQL Experience Resume looks like ?, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.