Resume

Sign in

Sql Server Sales

Location:
Boston, MA
Posted:
August 10, 2012

Contact this candidate

Resume:

Shashank Shekhar

Contact: +91-773******* E-mail: qoc933@r.postjobfree.com

________________________________________

OBJECTIVE________________________________________

Professional goal includes continuing to grow in leadership and knowledge, excel in innovative technology application, interact and share with team members and colleagues and develop world class solutions to real world challenges.

EXPERIENCE SUMMARY________________________________________

Professional with 1 year of information in IT field. I have worked on multiple technologies which

Include ETL- Informatica, MS SQL Server, Oracle, and Business Objects.

Currently working as Software Developer in ETL- Informatica Technology.

• Working as a Software Developer for Client - Boston Scientific using Business Objects which the client has deployed for its Reports generation purpose using Oracle as well as MS SQL SERVER as Database for the application Workforce Reporting System (WFRS).

Software Skill Sets

ETL Tools Informatica-BI Tools(v 8.6.1), Business Objects

Programming Language SQL

Operating Systems Windows 7, Windows XP

Database Systems Oracle 10g,11g, MS SQL Server 2008

EDUCATION

________________________________________

Degree Year Institute University Class

________________________________________

BE (Info Tech) 2011 N.I.T Patna N.I.T Patna Distinction

PROFESSIONAL EMPLOYMENT

________________________________________

Programmer, Accenture Services India Pvt. Ltd. (Aug 2011 till date)

________________________________________

• Joined Accenture India and have been working with Boston scientific as my first project in the support role.

PROJECT________________________________________

Project : Project : BOSTON SCIENTIFIC- LS

Domain : Life Sciences

Client : BOSTON SCIENTIFIC (BSC)

Description :

The Boston Scientific Corporation (BSC) is a worldwide developer, manufacturer and marketer of medical devices. There are a number of applications developed and supported in order to carry out the functioning of various departments of BSC.

The applications which are developed and supported are

WFRS (Workforce reporting System)

CEO SPM (Sales Performance Metrics)

The application (WFRS) Work Force Reporting Solution was started in year 2009, as a repository of (HR) Human Resources & Staffing related data (like Attrition rate, diversity of employees, Number of employees etc.) so that HR team can pull the required information in a very friendly manner.

Later on Sales data for Europe was added to the database and in year 2010 CEO sales performance dashboards were added to help CEO take critical business decision. Different modules in the application : There are 3 main modules –

• WFRS DB, GSPM DB (MS SQL Server)

• ETL module and

• BOBJ / Dashboard module.

Purpose of the system is to have a high level broad view of the sales force for the entire month

Technology : ETL- Informatica, SQL, PL/SQL

Database : MS SQL Server, Oracle

Platform : Business Objects

Role Profile: Application Maintenance & Software Developer involved in

Creating Technical design documents based on given requirements in the functional design document.

Maintain the Dimension Tables in the target Database (GSPM).

Load the data in all the environments when data is available in WFRS.

Perform Validation and Verification on the data loaded using SQL queries.

Unit Testing, Assembly Testing when a mapping is developed or updated as per functional requirement.

Create Test Cases and Test Scripts in order to perform the Testing of Dashboards.

PERSONAL PARTICULARS________________________________________

Sex : Male

Marital Status : Single

Nationality : Indian

Passport Valid till : 29th August 2020

Date of Birth : 04th May 1989

Languages : English, Hindi

Permanent Residence : A/26, Jagat Amrawati Apts, Behind Officer’s flat, Mahesh nagar,

Bailey road, Patna-800001, Bihar.



Contact this candidate