Sql Data

Harshita Walia

704-***-****

******.**@*****.***

Skype ID: Harshitawalia

Objective

Seeking a position in the field of Quality Analyst/SAS, SQL to utilize my skills, abilities and use them to achieve company’s bottom line and hence find new vistas for personal development too.

Summary

5.8 year of total experience. Presently working with Tech Mahindra as a Sr. Analyst

Education Profile

Completed Graduation (B Tech ) from Amity University

Completed Post Graduation (MCA) From Sikkim Manipal University

Successfully completed GNIIT certification course from NIIT

Technical Proficiency

Languages : SAS, Pl/SQL, SQL, Unix, HTML

Databases : Oracle 9i, 10g, Ms Access

Operating System : Windows XP/Vista/7, UNIX

Tools/IDE’s : Toad, SQL Navigator, Remedy, Merckury VSS

Tools : Qlickview (BI Tool), CSMS, CDR, Documentum, Informatica, Compass, Inform4.5

Servers : Apache tomcat

Certification : SAS,Oracle Database,SQL Expert, Oracle Database 11g, ITSM

Work Experience

Worked with HCL Technologies as a Software Engineer

Currently working with Tech Mahindra as a Sr. Quality Analyst

Company Name :: HCL Tech

Projects Description

Project Name : Merck-MRL IOSM Client : Merck (Merck & Co., Inc. USA

Team Size : 4

Duration : Aug-2009 till Sep 2013

Skill Used : SAS, SQL, UNIX

The project is currently designed to provide support and continuously testing the functionalities of various applications dealing with Clinical data. t also includes solving some of the issues which have to be solved by Clinical Operations group like refreshing the data and monitoring the flow of data from one application to other.

Responsibilities:

Manipulated complex data sets using SQL and related techniques to develop efficient SAS code.

UNIX shell scripting for automating the back-end processes.

Post production supported the project with any upcoming issues with the Oracle database packages and procedures.

Knowledge in modify existing datasets using Set, Sort, and Update, Formats, Functions and conditional statements.

Having good Knowledge on DATASETS, COPY, CONTENTS, PRINT and FORMAT procedures. .

Writing SQL Queries for DML operations on Database objects.

Strong ability to write SQL queries using PROC SQL.

Company Name :: Tech Mahindra

Projects Description

Project Name : Qway

Client : Tech Mahindra

Team Size : 8

Duration : Sep-2013 till date

Skill Used : SAS,SQL

Qway provides a comprehensive range of financial services; personal financial services; commercial banking; corporate, investment banking and markets, private banking and other activities. I was involved in performing complex query in SAS & SQL .I was also involved with the update and maintenance of the Data warehouse and generation of various reports. Data is loaded from database into SAS datasets, and Reports were generated.

Responsibilities:

• Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data

from and into SAS, MS Access and Excel.

• Coded SAS programs to manipulate and produced the custom reports. Developing the reports

in Business Objects using complex SQL queries & materialized views.

• Extracting data from the database using SAS/Access, SAS /SQL procedures and create SAS

datasets.

• Coding SAS programs with the use of SAS/BASE and SAS/Macros for ad hoc jobs.

• Created charts showing performance using SAS/GRAPH.

• Modifying data using SAS/BASE and Macros.

•Validated the data of reports by writing SQL queries in SQL Developer

Achievements

Got the best performer appreciation reward from the HCL technologies.

Certificate of Appreciation for solely handling application Qlickview from MetLife

Contact this candidate