Nagu Enagalla

E-Mail Id: ad3i42@r.postjobfree.com

Mobile No: 945-***-****

****, ****** ***** **** ****, Apt-2012, Irving, Texas.

SUMMARY OF EXPERIENCE

Having 9 years of IT experience in Base SAS/MACROS, SAS DI, SAS FM, SAS Forecast Studio, SAS/ACCESS, SAS SQL, LSF and ETL Processing.

Excellent skills in data analytics, data mining, business intelligence, data integration using SAS, Oracle, UNIX technologies with 9 years of experience in IT industry.

Excellent understanding of SAS ETL, SAS BI.

Rich hands-on experience in SAS/Data Integration Studio, SAS BI Tools and SAS

Enterprise Guide.

Excellent understanding of SAS ETL, SAS BI.

Very good understanding of data flow in telecom industry.

Excellent skills in understanding business requirement, designing the requirement, converting functional specs to technical specs, and implementing the requirement using SAS, Oracle, and Solaris technologies.

Strong experience in SAS Base.

Experience with executing projects in agile environments (Kanban and Scrum).

Expertise in SAS 9.4 and SAS 9.3 administration activities.

Expertise in trouble shooting of SAS server installation and configuration issues.

Expertise in SAS/Base and SAS/Macros programming.

Good working experience with SAS LSF (Load Sharing Facility) to automate the ETL Process.

Hands on Experience on SMC in terms of SAS Administration Activities.

Hands on experience on SAS BI tools like SAS IDP SAS FM.

Having good knowledge in Data Warehousing Concepts.

Strong Knowledge in writing SQL queries.

Excellent problem-solving skills.

PROFESSIONAL EXPERIENCE

Worked as a IT Analyst in Tata Consultancy Services Hyderabad from Sep 2018 to Sep 2023.

Worked as a Application Developer in Accenture Mumbai from Jan 2018 to Sep 2018.

Worked as a Sas Developer for Reliance Communications Mumbai from Oct 2014 to Jan 2018.

TECHNICAL SKILLS

SAS Tools: SAS 9.4 and SAS 9.1.3, SAS Base 9.4, SAS Macros, SAS Management Console 9.4 and 9.1, SAS Data Integration Studio 3.4 & 7.1, SAS Web Report Studio, SAS Information Delivery Portal.

SAS 9.4 and SAS 9.1 Clients and Server Administration.

Operating Systems: Unix and Windows

Programming Language: SAS.

EDUCATION

M.sc Computer Science from Osmania University in 2010.

PROJECTS:

Project #1:

Apr 2021 to Sep 2023.

Zakat, Tax and Customs Authority.

•Sasversion:9.4M5

•Operating system: Windows and Unix.

The Zakat, Tax and Customs Authority (ZATCA) (earlier known as GAZT), is the major regulating authority in Saudi Arabia for customs and other taxes. The ZATCA portal facilitates numerous services for taxpayers ranging from registration, filing returns, payment of taxes, as per the business requirements we provide the trend of taxpayers taxes and VAT related data, day to day reports to business through various reporting tools SAS DI and SAS Visual Analytics.

Responsibilities:

Daily monitoring more than 100 flows of DI Jobs.

Loading data or updating/Append tables as per adhoc activity given by management.

Using the DI transformation to load the data accurately such as file -reader, user written,

Extract, append, spilt, SQL-join and data-validation.

Responsible for providing SAS technical support to end users and implementing new SAS technical solutions.

Provide all levels of technical and application support, incident management (Level 1,2,3 and 4) application and data issues.

Deploy jobs, create dependencies in DI Studio, and schedule accordingly via LSF.

Updating patches applying hot fixes & Renewing the SAS licenses on SAS9.4 Servers.

Troubleshooting sas server related issues and co-ordaining with sas vendors over the track for solutions.

Applied Security patches on SAS Servers.

Monitoring server resources and performance along with mount points, CPU usage and logs monitoring.

Performing maintenance activity of SAS servers which includes taking backups and restarting SAS services.

Project #2:

Sep 2018 to Mar 2021

•Ericsson IT- SAIDA (Demand Driven Forecasting Tool).

•Sas version: 9.4M5

•Operating system: Windows and Unix.

oSAIDA is a Demand Driven Forecasting Tool which collects stakeholders input, creates baseline forecast, Proposal and decides on a final forecast.

oTools: SAS Data Integrated Studio, SAS management console, SAS EG.

Responsibilities:

Data Sharing from Prod to Stage and Dev Environments.

Working experience on SAS Financial Management studio, Creation of SAS FM templates, Publishing, Export/Import of forms in SAS FM studio.

Hands on experience on SAS DI job deployments/Scheduling and debugging.

Stored procedure reports deployment/scheduling and debugging of reports.

Hands on experience on SAS Management Console

Understanding and debugging all the SAS Application and SAS Web Application logs.

Performing maintenance activity of SAS servers which includes taking backups and restarting SAS services.

Applied licenses on SAS Servers.

Troubleshooting sas server related issues and co-ordaining with sas vendors over the track for solutions.

Monitoring server resources and performance along with mount points, CPU usage and log Monitoring.

Good working experience with SAS LSF(Load Sharing Facility) to automate the ETL process.

Project #3:

Jan 2018 to Sep 2018

Accenture

Client: HDFC Ergo General Insurance.

Project: Data Warehousing & General Insurance.

Roles & Responsibilities:

Working on General Insurance Project with DWH-Team.

Requirement and logic discussion with user and gaining business knowledge from user.

Experience using ETL using SAS DI and SAS MDM.

Converting design documents into technical specification

Monthly generation of Booked Premium Register, Data Validation and Reconciliation.

Understanding Business logic and mappings to develop automated jobs.

Developed ETL jobs by using different transformations in SAS DI Studio.

Involved in developing, creating jobs and testing jobs in SAS DI according to business requirement.

Scheduling and deploying job using Data integration studio and Management console.

Using SAS DI STUDIO transformation (USER WRITTEN CODE) for designing, testing and implementing incremental jobs for smooth and efficient ETL operation.

Automated various report according to business user’s requirements also automated daily manual activities.

Project #4:

Oct 2014 to Jan 2018.

•Reliance Communications

Responsibilities:

Developed ETL jobs by using different transformations in SAS DI Studio.

Enhanced ETL process & tuning ETL jobs to achieve performance optimization.

Created Packages for Jobs and Tables promoted to Test, UAT and Production environments.

Scheduling ETL Jobs by using SAS LSF (Load Sharing Facility).

Experience in deploy jobs, creating dependencies in DI Studio, and schedule accordingly via SAS SMC

Create and manage Metadata objects that define sources, targets and jobs for various trans- formations and consolidate user transformations in process flow via Process Designer in DIS.

Extensive experience in Base SAS, Adv SAS, SAS/SQL, SAS/Macros, SAS/ODS, and SAS EG, SAS DI on Windows and UNIX.

Expertise in using PROC SQL, _NULL_, MERGE, SET and table lookup method to extract data from big datasets to generate adhoc and customize reports as per business requirement.

Good hands-on experience in PROC SQL and SQL PASS THROUGH for writing queries of ETL, joining tables, adhoc analysis, testing and validation of datasets.

Writing SAS MACROS and generalized code for implementing incremental jobs for ad hoc and daily/monthly ETL processing.

Using SAS DI STUDIO transformation (USER WRITTEN CODE) for designing, testing and implementing incremental jobs for smooth and efficient ETL operation.

Experience in Stopping and Starting SAS Services (Meta, Compute & Midtier)

Experience in creating users and groups and providing required roles.

Experience in applying SAS licenses in all SAS Servers.

Using PROC SPDO to manage data in the form of clusters (Dynamic Tables) on SPDS server for efficient operation of ETL process.

Contact this candidate