Data Sql Server

TRIDIB SARMA Contact: +91-999******* Email: acqpmx@r.postjobfree.com

SAS / SQL DEVELOPER

SAS/BASE, SAS/MACRO, & SAS/ODS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ACCESS & SAS/CONNECT in Windows Environment

Nearly 8 years of experience in:SAS Coding SAS Programming Report Preparation ETL Data Management Writing SQL Queries Project Coordination VBA Coding Dashboards MIS

CAREER HIGHLIGHTS

Summary of Skills

Achieved process CTQ’s and implemented various Lean ideas for E2C Blend Process

Recognized for commitment to work, for putting in extra hours, in a Commendation for outstanding efforts; accredited as a major contributor in bringing team’s productivity above expectation.

Strong SAS programming background for creating, maintaining existing code, ad hoc reporting and supporting the reporting functions.

Experience in using SAS to read, write, import and export to another data file formats, including delimited files, Microsoft Excel, PDF and MS Access Tables.

Experience in SAS/BASE, SAS/MACRO, and SAS/ODS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ACCESS, and SAS/CONNECT in Windows environment.

Expertise in using various SAS report generating procedures like PROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE and PROC PRINT.

Highly adept at SAS development, SAS Macro, base SAS and ETL; well versed with analysis, solution design and implementation of SAS software code.

Performed data extraction, analysis and published results using SAS ENTERPRISE GUIDE.

Design queries of SQL to extract information from SQL server and make reports from them.

Proficient in developing complex SAS programs, macros for data updates, data cleansing and reporting

Developed new or modified existing SAS programs to load data from the source and create study specific datasets.

AWARDS & ACCOLADES

Bank of America Global Recognition Award in Platinum Category

Bank of America Spirit Recognition Honor for making a commitment to excellence by demonstrating performance that exceeded expectations in the third quarter

~ Knowledge Purview ~

Experienced in:

Base and Advanced SAS, Macros, SQL Queries, Stored Procedures, Views.

Oracle, MS SQL Server 2008, MS Access.

SAS Enterprise Guide Software for reporting and analytical tasks

Making excel based reports

Excel VBA

Data Management like Merging, concatenating, interleaving and moving of SAS Datasets, connecting to Oracle, SQL using SAS, Proc report, Proc tabulate, Proc means etc for report creation.

Writing SQL queries using PROC SQL.

CAREER REVIEW

Deputy Manager ICICI Bank, Mumbai May 2015 – June 2015

Key Deliverables:

Code Preparation: Prepared fresh SAS codes for the various reports which are published on a daily basis to the Global Trade Services Management

Code Editing:Editing the existing SAS Macro Codes which needed some change

Data Generation: Extracted data from SQL Server and prepared reports out of the data

Server Information Feed:Provided information to Finacle server which the Global Trade Services Unit does on a daily basis

Team Developer Bank of America Continuum India, Gurgaon Year 2007 to Apr 2015

Key Deliverables:

SAS Program Development: Developed new or modified existing SAS programs to load data from the source and create study specific datasets

Data Handling: Managed large amounts of data for Data Cleansing, Data Profiling and Data Scrubbing. Utilized SAS Procedures, Macros, and other SAS applications for data extraction, data cleansing, data loading and reporting. Involved in the data analysis, DB creation, applying database constraints and make ready to load onto database

Report Preparation:Created reports in SAS and exported to Excel spreadsheets

Code Design: Designed codes on Toad for Oracle for reporting purpose. Designed queries of SQL to extract information from SQL server and make reports from them.

Variable Customization: Modified the variables to user-defined formats using PROC FORMAT in printing reports

Account Management: Examined cash and check deposits. Handled opening and closing of accounts. Issued Credit Reference, Sponsorship and Immigration Letter on customers.

Issue Resolution:IT Special Point of Contact for the process. Involved in issue reporting, raised tickets, framed problem statements and handled Bridge lines calls for the purpose of issue rectification for the process. Handled Line of Business(B2B) calls on volume reporting and escalations. Prepared Business Continuity Plan (BCP) Special Point of Contact for the process.

Account Information: Ensured the regular requirement of Bank such as Bank Secretary Act and Anti-Money Laundering. Provided information to customers about Bank products; giving account owners their account information on request. Rendered teller, Point of Sale (POS) and online transaction efficiency and quality to customers. Ensured Know your Customer (KYC) and Customer Information Protection (CIP)

EDUCATION & CREDENTIALS

Year - 2005 B.Sc. (Electronics) from Gauhati University, Assam

ITSkills:

Operating Systems:

Windows XP Professional and Windows Vista, Windows 7

Language:

SAS 9.2, Enterprise Guide 4.3, SQL

SAS Tools:

SAS/Base, SAS/Macro, SAS/Stat, SAS/Connect, SAS/ODS, SAS/ACCESS, SAS/ETL, SAS /Graph, SAS, SAS E Guide

Database:

MS-Access, Oracle, SQL Server

Other Technologies:

ARIS, Microsoft Office (Word, Excel, PowerPoint, Outlook), Excel VBA

.

Trainings Attended:

PHS (Performing to Higher Standards), Part I

PHS (Performing to Higher Standards), Part II

Six Sigma, Lean concepts (Basic) training, Bank of America

Credit Card Operations, Bank of America

Advanced MS PowerPoint training, Bank of America

Microsoft Excel 2007 (basic and advanced)

Effective Presentations

PERSONAL DETAILS

Date of Birth: 28thDecember 1984 Languages Known: English, Hindi and Assamese

Address: House No. - 56, 3rdFloor, Near MotiBagh Gurudwara, MotiBagh, New Delhi- 110021

Contact this candidate