Karthikreddy M.

SAS Data Analyst/Business Analyst /MIS Reporting with 9 years of experience

Chennai , India

Experience: 9 Years

Karthikreddy

Chennai , India

SAS Data Analyst/Business Analyst /MIS Reporting with 9 years of experience

34560 USD / Year

Immediate: Available

9 Years

Now you can Instantly Chat with Karthikreddy!

Chat Now

About Me

Hands on experience in SAS BI tools like SAS/DI, SAS/EG, SAS/OLAP Studio, SAS/WRS, SAS/IMS, SAS/IDP,SAS VA.

Experience with SASBASE components including Base SAS, Macros and SQL

Data Extraction, Cleaning, Validation, Analysis and R...nts including Base SAS, Macros and SQL

Data Extraction, Cleaning, Validation, Analysis and Reporting with SAS

Understanding Business process, making documentation and apply with appropriate SAS tools

Well experienced in Data manipulation with statements Retain, Sum, Set and Merge

Hands on experience in data manipulation with Reports Sort, Transpose, Datasets, Append and SQL

Experience in Analysis and Reporting with Reports Means, Freq and etc…

Expertise through PROC SQL in Joins, Operators, Views and Index

Expertise in Macro Programming for iterative SAS code Execution and Macro Variable processing

Experienced in generating RTF, PDF, Excel and HTML formatted files using SAS/ODS and _NULL_ Technique for ad-hoc reports

Developing data ware house to create and manage metadata objects with ETL process

Expertise in SAS DI transformation like SCD type2&1,Look up, SQL join, Extract, Table Loader,

Transpose, user written, Read & write, Set operators and split etc.

Designing OLAP cubes for multidimensional structures of summarized data

Deploying and Scheduling jobs by using SAS Management Console

Creating stored processes using SAS EG to create various Reports for online client queries and provide an effective method for change control management and deploying in IDP portal

Publishing Reports in Web Report Studio and Information delivery portal

Creating libraries, users, groups and assigning permissions using SAS Management Console

Strong collaboration and team building skills with proficiency in grasping new technical concepts

Widely interacted with client for gathering requirements and I have good people skills

Self-directed employee with excellent problem solving, analytical and management skills

Skills

Others

Positions

Software Architect

Portfolio Projects

MIS Reporting (Securities )

Company

MIS Reporting (Securities )

Description

AS a SAS Programmer, I am working with HDFC Bank, It Is one of the largest financial institutions spanning all over the world, it provides personal banking, investing services, small business, and commercial banking. HDFC Securities is the largest equity house in the country providing end-to-end solutions (including web-based services) Here we upload data from database everyday into oracle server, I need to extract data from oracle server and have to generate reports(like product wise turnover and revenue, team wise revenue, Market share reports to shown to SEBI) using various SAS Products for decision making purpose. The main objective of project is to involve on Share marketing Analysis as well as support for customer campaigns and also involved to create MIS reports and deliver those reports to business users for review of their business.

Show More Show Less

Skills

Statistical Analysis Software - SAS SAS Macros

Tools

SAS BASE SAS MACRO

ADF (Automated Data Flow)

Company

ADF (Automated Data Flow)

Description

The MIS requirements of the Bank are met from the existing systems such as Core Banking System (CBS), HRMS, CRM, CMS etc. But there is no separate single Data Source in the form of Central Data Repository (CDR). Reserve Bank of India (RBI) has published an approach paper on ADF from Banks to RBI, wherein they have outlined a framework for putting in place a Central Data Repository with different layers of Data Acquisition, Data Integration and Storage from which Statutory Returns / Reports would be automatically generated without any manual intervention.

Show More Show Less

Skills

SAS Enterprise Guide SAS Data Integration SAS Stored process SAS IDP SAS Management console

Tools

Sas enterprise guide SAS data integration studio SAS MACRO SAS IDP SAS SMC

DATA ANALYTICS

Company

DATA ANALYTICS

Role

Project Manager (Team Lead)

Description

As a senior technical lead, I am working for the client of Indian Bank. It is one of the largest financial institutions spanning all over the India. We need to develop 40 analytical models like spend analysis, customer segmentation, web analytics, ATM& Branch cash optimization etc. Here we need to analyze the historical data of the bank and develop the models. By using these models banks can know about their customers and can offer right products. At the same time they can optimize their cash flow at ATM and branch level. By using these models banks can improve their business.

Show More Show Less

Skills

SAS VA SAS Data Integration SAS Enterprise Guide SQL

Tools

SAS data integration studio Sas enterprise guide SAS MACRO SAS SQL SAS VA