Sas Data

SAROJINI

Contact No: +91-770*******

Email: ***********@*****.***

OBJECTIVE

To work in quality environment where I can use my knowledge and skills to my best extent and develop elegant quality software and keep right touch with ever changing trend and technologies in the field.

SUMMARY OF Q.UALIFICATIONS

Total 9.9 years of experience in Banking and Telecommunication domains worked as SAS Administrator, SAS Programmer and SAS ETL developer using Base SAS, Advanced SAS(SAS SQL & SAS MACROS), SAS BI tools(SAS EG, SAS DI(SAS ETL), SAS IMP, SAS IDP, SAS WRS, SAS MC), SAS Viya, SAS VA and Python knowledge.

Coordinate with technical team to determine Client needs, project feasibility and respond to inquiries.

Reviewing the document work and functional requirements and creating business process workflow.

Responsible for gathering Business requirements from Client and analysis on it .

Responsible for loading, validating, documenting, managing, and analyzing data.

Developed SAS programs for extraction, presentation, manipulation, analysis and reporting using SAS EG, Advanced SAS (SAS SQL and SAS Macros).

Experience in HADOOP File system.

Monitoring the production jobs,if failed investigate the logs in order to fix the errors.

Extracted the data from different databases (Oracle, Sybase, TERA data, Hadoop).

Handled huge volumes of data .

Transformed data in various formats (MS Excel, CSV, text files) into SAS datasets.

Performed jobs using transformations like Append, splitter, Sort, SCD Loader, Fact Table Look up, SQL join and data validation etc .

Experience on SAS Viya or CAS platform admin activities and SAS Viya development.

Handled Incidents and Tickets and ADR of Production environment.

Stop and Start of SAS Services as per the Requirement.

Maintain SAS Production environment .

Scheduling the Jobs in crontab and maintain Crontab jobs and LSF Batch jobs.

Monitoring the production jobs,if failed investigate the logs in order to fix the errors.

Monitor SAS Viya environment using SAS Environment manager.

Managing CAS server and Data by CAS table state management, by managing data,formats,by managing access to data and CAS server monitoring.

Maintaining SAS Viya server by monitoring and logging.

Looking into general authorization and troubleshooting the issues.

Managing SAS Viya content by sharing content, promotion, formats.

On daily basis have to submit the Health Checks and Business reports to Clients.

Having Good experience working with UNIX .

Ability to work both as an individual and as part of a team.

PROFESSIONAL SUMMARY

Worked as a Senior software Engineer in “WIPRO Technologies” from Feb 2017to Jan2020

Worked as a Assistant Consultant in “TATA CONSULTANCY SERVICES” from Jun2010 to

Jan2017.

EDUCATIONAL QUALIFICATION

M.Tech From JawaharLal Technological University Hyderabad

ONSITE EXPERIENCE

Had work experience at Onsite “SWEDEN”

Had work experience at Onsite “MALAYSIA”

CERTIFICATIONS

Base SAS Certification

Advanced SAS Certification

SAS ADMIN Certification

ACHIEVEMENTS

Achieved State 2nd rank in M.Tech Entrance

Achieved 1968 EAMCET Rank.

Achieved school and College FIRST .

Two “On The Spot Awards” for the Successful delivering the projects in TCS for Bank of America and American Express projects.

PROFESSIONAL EXPERIENCE

PROJECT #6

Client :Citi BANK

Role :SAS ADMIN & PROGRAMMER

Environment : SAS EG,SAS Viya, Oracle,Python

Citi has around 3,900 offices in 67 countries and territories across Africa, Asia, Oceania, Europe, North America and South America, and around 38 million customers. It was the world's sixth-largest public company. Citi is organized within four business groups: Commercial Banking; Global Banking and Markets (investment banking); Retail Banking and Wealth Management; and Global Private Banking.

Responsibilities:

Responsible for gathering Business requirements from Client and analysis on it .

Responsible for loading, validating, documenting, managing, and analyzing data.

Responsible for assisting with data storage and management issues around both new and ongoing projects within the Division.

Prepare the SAS Program for Adhoc requests.

Responsible for data validation and analysis activities.

Work experience on different Procedure to implement Statistical Analysis.

Automation on SAS Codes to avoid manual work.

Scheduling the Jobs in crontab.

Monitoring the production jobs,if failed investigate the logs in order to fix the errors.

Extracting the data from different source like Hadoop, Oracle.

Applying the performance tuning techniques in Customer Matrix Reports.

Knowledge on Tableau.

PROJECT #5

Client : MALAYSIA MAXIS

Project : MAXIS Project

Team Size : 6

Environment : Advanced SAS, SAS Viya, UNIX.

Role : SAS ADMIN

Project Objective : MAXIS Prepaid and Post Paid Campaign Management system(CMS).

Gathering Business requirements of MAXIS Prepaid and Post Paid Campaign Management system from Client and analysis on it and follow the procedure to implement Change Requests in SAS Production.

Handled Incidents and Tickets and ADR of Production environment.

Stop and Start of SAS Services as per the Requirement.

Maintain SAS Production environment .

Scheduling the Jobs in crontab and maintain Crontab jobs and LSF Batch jobs.

Monitoring the production jobs,if failed investigate the logs in order to fix the errors.

Monitor SAS Viya environment using SAS Environment manager.

Managing CAS server and Data by CAS table state management, by managing data,formats,by managing access to data and CAS server monitoring.

Maintaining SAS Viya server by monitoring and logging.

Looking into general authorization and troubleshooting the issues.

Managing SAS Viya content by sharing content, promotion, formats.

On daily basis have to submit the Health Checks and Business reports to Clients.

PROJECT #4

Client :AMERICAN EXPRESS BANK

Project :WSMIS

Role : SAS Programmer

Environment : SAS EG, SAS SQL, SAS Macros, UNIX, Sybase,Tera data,Oracle,WIN SCP

Project Objective :World service MIS handles the US Banking data which processed online credit,debit cards, Data of Android Apps, Net, Mobile and Retail banking data. Reports generation on Analysed banking data .

This project mainly aims on to create one central data repository for almost all the departments in American express. So that the gap between the departments would decrease, also there would reports and other high end graphs so the corresponding departments can do real time analysis as well.

Responsibilities:

Transfer the data from TERA DATA to Oracle via SAS using UNIX .

Fetch the data from TERA data and Load to Oracle using Pass-through and ODBC connections .

Work on reducing the CPU time of JOBS and database space saving methods while handling huge volumes of data(50 millions of rows) .

Validate the results TERDATA Vs Oracle source.

Continuous research has been going on complete automation and database space saving techniques .

Advance of this work,Automation of jobs using LSF scheduling .

PROJECT#3:

Client : BANK OF AMERICA

Project :Card IVR-CTI-Desktop Data into ClickFox

Environment : Advanced SAS(SAS SQL, SAS MACROS), UNIX, WINSCP

Role : SAS Programmer

Description: ClickFox (an internal vendor) is an application which provide analytics and behavioral insights into customer interactions and call paths from the Deposits IVR down to the agent's desktop. Currently, the ClickFox application receives Deposits IVR, CTI and Lean desktop data. It aims to provide a complete picture of customer interactions and call paths across CS&S from IVR's down to agent’s Desktop.

Objective: To capture Card IVR (Interactive Voice Response), TSS (Telephone Access Customer Service Superstation), and CLMS (Consolidated Leads Management System) Desktop channel data in the ClickFox analysis tool. This will allow ClickFox the ability to process Card IVR, CTI, and desktop data in addition to Deposits data and provide CS&S with a more complete end-to-end picture of customer interactions and call paths.

Responsibilities:

Develop SAS code to pull data (IVR, TSS and CMO) from BACARDI which generates flat, trigger files and send to Clickfox.

Develop shell scripts and schedules to run the SAS Jobs.

Perform Unit testing in UNIX environment and Prepare test scripts.

Prepare Pre-Installation Documents (Run Books, Production Schedule Readiness Checklist).

Involved in Code migration to Production from Development.

PROJECT #2

Client Name : Star Health & Allied Insurance Company Ltd

Project Name : Aarogyasri

Role : SAS Programmer & SAS ADMIN

Tools : SAS EG, SAS IMP, SAS DI, SAS WRS, SAS IDP, SAS MC

Project Objective : Rajiv Aarogyasri Community Health Insurance Scheme has been formulated by the Government of Andhra Pradesh to bring quality medical care within the reach of the poor people of the State.

To improve access of BPL families to quality medical care for treatment of identified diseases involving hospitalization, surgery and therapies, through an identified network of health care providers.

Responsibilities:

Collecting the Business Requirements(BR) from the Client .

As per Business Requirements design functional Requirements, Test cases.

Develop the Code as per the Standards.

Test it and generate the Report in different formats as per Client needs.

For Web based reports,followed SAS BI tools.

First register the table Using SAS Management Console, prepare Information maps and finally design the report using SAS Web Report Studio as per Requirement .

Follow up Testing and finally Production Implementation after finishing UAT(User acceptance Testing).

PROJECT#1

Project Name : SNFS Configured Capacity (TELECOM)

Client : EMBARQ, USA

Role : SAS Developer

Environment :SAS,SAS DI, UNIX,Oracle.

Business Benefit: Improves accuracy of capital planning.

SNFS Application:

The Strategic Network Forecasting System (SNFS) is a forecasting system that currently contains two applications, Network Demand Forecasting, and DSLAM Monitoring/Forecasting. SNFS is a web-based system and has been developed using SAS software. The system uses statistical algorithms to analyze growth data to develop forecasts that tell the what, when and where of services our customers will demand. It also provides valuable forecast data at the geographical and serving device level.

Project Description:

This project will correct a reporting error that misrepresents capacity values. In our voice environment, the value of “wired capacity” used on SNFS generated reports represents the “vendor capacity” in CODARS. Another CODARS value, “configured capacity”, more accurately defines the needed information because it recognizes that not all useable, and those that meet EMBARQ standards. Including this “configured capacity” value in reports will provide more accurate forecast and facility exhaust information.

Responsibilities:

SNFS application maintains the production activities.

Resolved the RFC tickets regarding application by fixing it and whenever necessary needs to make the changes in application output as per the client requirements.

For data-ware house project - Analyzing the technical documents and designing ETL jobs in SAS DI studio.

Performed jobs using transformations like splitter, SQL join,data validation, Sort, Fact Table Look up and SCD loader etc

Generate reports on Target tables using SAS DI Studio Transformations.

Testing ETL jobs and preparing test scripts.

Contact this candidate