Data Sql Server

SANDEEPTHUDI KUMAR

PROFESSIONAL SUMMARY:

• Senior SAS professional with around 6 years of experience in developing software applications for

Pharmaceutical, Financial, Health Care and Insurance sectors.

• Experience working in SAS Business Intelligence (BI) platform with Enterprise Guide 4.1/4.2/4.3 SAS

Web Report Studio 3.1/4.2, SAS Information Map Studio 3.1/4.2, SAS Information Delivery Portal,

SAS Add In for Microsoft Office 2.1/4.2, SAS Stored Processes on 9.2

• Extensive experience supporting different applications like SAS Enterprise Guide, SAS OLAP Cube

Studio, SAS Data Integration Studio, SAS Information Map Studio, SAS Information Delivery Portal

and SAS Web Report Studio.

• Proficient in SAS v8.2/9.1.3/9.2, SAS/BASE, SAS/MACROS, SAS/Connect, PROC SQL, SAS/Access

(Oracle/Teradata) and SAS/ODS.

• Experience in working with SAS on different platforms like UNIX (LINUX, AIX, HP/UX, SOLARIS) and

WINDOWS 9x/2K/NT/XP.

• Extensively worked on various RDBMS like Teradata, Oracle, DB2, SQL Server.

• Extensive working knowledge of Good Clinical Practice (GCP), Good Programming Practice(GPP),

Code Of Federal Regulations(21 CFR part 11) and clinical terminology.

• Experience in Business Evaluation and Analysis.

• Extensive Experience in arranging and participating in meetings with Business Users and suggesting

recommendations for improving system performance.

• Proven skills in data cleansing, data archival, data migration, ad hoc reporting, and coding using SAS

on various environments.

• Involved in all stages of SDLC (Software Development Life Cycle).

• Thorough Knowledge and experience in Microsoft Office tools like MS Access, MS word, MS

PowerPoint, MS Excel.

• Experience in handling software development, enhancements, testing and documentation.

• Excellent communication and interpersonal skills.

• Proven abilities in establishing effective task priorities as a team player with result oriented attitude.

TECHNICAL SKILLS:

• Statistical Software: SAS/BASE, SAS/MACRO, PROC SQL, SAS/Access, SAS/EG, SAS/STAT,

SAS/Access, SAS/CONNECT, SAS/ODS

• Business Intelligence: SAS Management Console, SAS Data Integration Studio, SAS OLAP Cube

Studio, SAS Information Map Studio, SAS Web Report Studio, SAS Information Delivery Portal,

Enterprise Guide and SAS Add In for Microsoft Office

• Database: Teradata, Oracle, DB2, MS SQL Server 2000, MS Access.

• Operating Systems: UNIX, MS Windows (95, 98, 2000, NT, XP), MS DOS, MVS.

• Web Development: ASP, HTML, DHTML, XML, JavaScript.

• Development Tools: MS Office (Word, Excel, Power Point, Access)

• OOD Suites: Microsoft Visio, UML.

EDUCATION:

Bachelors of Pharmacy Hyderabad, India

Jawaharlal Technological University

PROFESSIONAL EXPERIENCE:

Client: CGI, Raleigh Duration: Nov’12– Present

SAS Consultant

Description: The North Carolina Department of Revenue (DOR) contracted with CGI to implement integrated

Tax Information Management System (TIMS). The goal of the engagement is to assist DOR create a

modernize tax administration organization that leverages technology to improve customer service, accelerate

taxpayer compliance, generate additional revenues for state government operation, and meet new challenges.

Responsibilities:

• Actively worked on the development needs of the TIMS Reports.

• Responsible for Jira tickets that were raised by end users and actively resolved the issues.

• Designed and developed code using SAS/EG for various Taxation Reports.

• Carried out data extraction and data manipulation using PROC SQL, PROC SORT, PROC REPORT

to create reports as per the business requirements.

• Imported data using SQL Pass Thru facility to reduce the processing time.

• Developed SAS macros to simplify SAS code and efficiently reduced coding time.

• Used proc report and various procedures to build the desired reports.

• Extensively used SAS ODS to create the customized reports in PDF, Excel.

• Developed complex reports using Proc Report and incorporated ODS destinations with all required

customized formats.

• Extensively created SAS stored process for the reports to publish them in web using Information

Delivery Portal.

• Built Information maps using Information map studio which were utilized Information Delivery Portal.

• Extensively used PROC SQL and SELECT sub queries to generate various reports by connecting

to the Oracle DB.

• Initially created tables and views in Oracle and used a BI/Query model for local users to access the

data tables and reports.

• Communicated with various personnel in the forecasting group and the statistical group for various

requirement gathering and analysis of the data.

• Automated the Monthly, Quarterly and Half yearly Production process using shell scripts and setup

cron jobs to schedule them on the UNIX box.

.

Environment: SAS/BASE, SAS/MACROS, PROC SQL, SAS Enterprise Guide, Information Delivery Portal,

Information Map Studio, MS Excel, UNIX (SOLARIS), Putty, Windows, SAS/Access Oracle

Client: CVS Caremark, IL Duration: Feb’12– Oct’12

SAS Consultant

Description: CVS Caremark is a health care provider with a vast IT structure. This project involved support for

the Hercules development and testing of the same application to accommodate new changes and

requirements.

Responsibilities:

• Actively worked on the development needs of the Hercules stabilization.

• Provided updates to the senior team members on the analysis of different testing cycles.

• Responsible for heat tickets that were raised by end users and actively resolved the issues.

• Proactively provided improvement and optimization ideas on the design on the data warehouse.

• Cleaned existing data and converted them into useful SAS Datasets, merged datasets and created

reports based on Ad hoc requirements.

• Extensively used PROC SQL and SELECT sub queries to generate various reports by connecting to

the Teradata DB.

• Initially created tables and views in Teradata and used a BI/Query model for local users to access the

data tables and reports.

• Communicated with various personnel in the forecasting group and the statistical group for various

requirement gathering and analysis of the data.

• Involved in Documentation, presentation, data reports and model results to the team/manager.

Environment: SAS/BASE, SAS/MACROS, PROC SQL, SAS/STAT, SAS Enterprise Guide, MS Excel, UNIX

(SOLARIS), Windows, Teradata, SQL Server, SAS/Access Oracle, Hercules, Mainframes

Client: Blue Cross and Blue Shield of Florida, FL Duration: Jul ‘11 – Feb’12

SAS Consultant

Description: BCBS is one of the largest health care providers in Florida. This Project involves supporting the

Actuarial and Analytics group with building ETL processes, reports to accommodate their new business needs.

Responsibilities:

• Worked with Business team to analyze and understand the changes involved for the new business

needs.

• Analyzed the oracle data warehouse to design the ETL process and implement the business logic

required using Data Integration Studio.

• Hands on experience working on health care data including revenue, membership, claims and cost of

health care data.

• Built automated process to pull data from Oracle and load the resulting Flat files into Access and SQL

Server.

• Responsible for running of productionalized programs on monthly, quarterly basis.

• Extensively used SQL Pass thro for pulling data from Oracle and SQL Server

• Designed and developed code using SAS/EG.

• Built Cubes using OLAP cube studio which were utilized in Web Report Studio and Information

Delivery Portal.

• Hands on experience in using Enterprise Guide for building Stored Process.

• Automated reports using SAS Add in for Microsoft Office.

• Extensively used Humming bird for FTP purposes.

Environment: SAS/BASE, SAS/MACROS, PROC SQL, SAS/STAT, SAS Enterprise Guide, SAS DI Studio 4.2,

SAS OLAP Cube Studio, Web Report Studio, Information Delivery Portal, Excel, UNIX (SOLARIS), Windows,

Oracle, SQL Server, SAS/Access Oracle, Humming Bird Exceed

Client: PNC Bank, OH Duration: Jan ‘10 – Jun ‘11

SAS BI Developer

Description: PNC Bank provides deposit, lending, cash management and investment services to more than 5

million consumer and small business customers across 16 states in U.S. This Project involves supporting the

Marketing and Sales groups with Data related Adhoc requests, building / maintaining data mart and generating

reports.

Responsibilities:

• Created Global Market View SAS Datamart and designed star schema for efficient querying and

reporting.

• Automated the Monthly, Quarterly and Half yearly Production process using shell scripts and setup

cron jobs to schedule them on the UNIX box.

• Experience working with different kinds of data like Dun and Bradstreet and Harte Hanks to do

analysis on customers and identifying new opportunities.

• Analyzed different internal data like Campaign, Opportunity and supported adhoc request from

business.

• Regularly involved in Data preparation, Data manipulations and formatting to support the statisticians

with their models.

• Regularly used SQL Pass thro, libname Statements and PROC SQL to interact with different RDBMS

like Oracle, Teradata.

• Created Stored Processes for the business to generate different adhoc reports based on the

parameters passed.

• Have experience creating information maps which would be utilized by web report studio to generate

static reports.

• Built reports using Web Report Studio and Information Delivery Portal.

• Automated Reports using SAS Add in for Microsoft Office.

• Designed and developed code with SAS/EG to support ad hoc requests.

Environment: SAS 9.2, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/Access (Oracle / Teradata),

SAS/Connect, Stored Process, SAS/Information Map Studio, SAS/Web Report Studio, SAS Add in for MS

Office, SAS/STAT, SAS/EG, Excel, UNIX (HP UX), Windows

Client: Fireman’s Fund Insurance Company, CA Duration: Jul ‘09 – Dec ‘09

SAS Programmer

Description: FFIC provides personal, commercial property and casualty insurance products in the United

States. This Project involves Extraction, Transformation and Loading of data extracts from Mainframe to AIX.

The reports are generated in AIX.

Responsibilities:

• Involved in the design and development of year end and quarterly reports.

• Worked with diverse team of business users to enable accurate communication of requirements.

• Extracted data from flat files, tapes in the mainframe.

• Extracted Claims, Products and member data using Proc SQL Pass through Facility.

• Created daily, monthly and Ad hoc reports for home health care data.

• Performed transformation on the data extracts as required by the business.

• Created Partition Datasets on MVS for SAS, JCL, Proc members.

• Uploaded the transformed sas datasets to AIX where it is used for reporting purposes.

• Created Macros on the AIX to generate reports.

• Analyzed the Trouble tickets in the Production environment and provided solution to the support team.

• Utilized Humming Bird for FTP purposes.

• Extensively used SAS/Connect for remote submitting the data extracts from Mainframe.

Environment: SAS/BASE, SAS/MACROS, SAS/SQL, SAS/Connect, Humming Bird V9.0, Exceed, Excel, IBM

Personal Communications, JCL, Mainframe Procedure, DB2, UNIX (AIX), MVS, Windows

Client: Matrix Labs, India Duration: Jul ‘08 Apr ‘09

SQL/SAS Programmer

Description: Matrix Labs is one of the world’s largest manufacturers and suppliers of active pharmaceutical

ingredients (APIs). Based in Hyderabad, India, It offers more than 150 APIs and intermediates to customers in

more than 80 countries across a wide range of therapeutic categories.

Responsibilities:

• Produced various graphical reports such as Bar Charts, Line Plots, Profiles Chart, Scatter

plots using SAS/GRAPH.

• Worked on Phases I, II & III clinical trials.

• Designed and implemented statistical reporting processes for clinical data (Phase I and II)

analysis.

• Performed Program Documentation on all programs, files and variables for accurate

historical record and for future reference.

• Created and maintained SAS programs to generate derived datasets and required summary

reports.

• Develop SAS programs to generate randomization lists, statistical reports and graphs.

• Worked with presentation and reporting procedures like FORMAT, REPORT, PRINT, SORT,

etc.

• Participated in designing, coding, testing, debugging and documenting SAS Programs and

Macros.

• Used SAS procedures like Transpose, Summary and contents.

• Was involved in validation of tables, listings and datasets using procedures like PROC

COMPARE and PROC FREQ.

• Using SAS statements like DLM, DSD, and COMMA9. TRUNCOVER, MISSOVER to get rid

of erroneous data.

• Performed Data Analysis on the data sets using PROC MEAN, PROC FREQ and PROC

TRANSPOSE.

Environment: SAS /BASE, SAS /MACROS, SAS/CONNECT, SAS/ACCESS, SAS/SQL, SAS/GRAPH, MS

Excel, SQL Server, Windows NT.

References available upon request

Contact this candidate