Summary

Overall ** years of IT ERP Applications designing and development experience with Oracle

PL/SQL. SAP ECC5 End to end Applications implementation ( SD, MM, FICO,PP,QM ) and SAP ECC6 Project Upgrade experience as Techno Functional Lead. 13 years Experience in SAP BW/BI

& ABAP for Applications design development and dashboard insights & MIS. Technical Skills :

ERP : SAP ECC 6.0

Administration : BASIS ( R/3 Installation, BI content Installation, Applying Patches, Client copy, client export, Authorizations in R3 & BW, Table space Management, RDBMS,CCMS )

BW3.5 / BI 7 ( Admin Workbench maintaining / Monitoring) Operating Systems : Linux, AIX5.3, Windows NT 4.0, Windows2008,2012 server Other Languages : ABAP/4, PLSQL AND COBOL

Data Warehousing : SAP BW 3.5, BI 7.0

Reporting Tools : Bex Analyzer, Bex Browser and Business Objects, ABAP Smart Forms, Scripts & ALV’s.

RDBMS : ORACLE 9i, ORACLE DBA AND FOXPRO

GUI : D2K FORMS 6.i, REPORTSs 6i

Training Undertaken :

AIX 5.3 Operating System Corporate Training

SAP Basis Corporate Training

SAP ABAP Corporate Training

Education :

Post Graduate M.Sc in Mathematics from Osmania University 1990-1992 Post Graduate Diploma in Computer Methods & Programming from APPC-CSI 1985-1986 Graduate B.Sc with Mathematics, Statistics & Physics from Nagarjuna University 1981-1984 Additional Information :

Date of Birth : 21-01-1964

Languages Familiar : English, Telugu & Hindi

Martial Status : Married

Address : Hno 4-10-44/1 Gandamguda,Bundlaguda,Hyderabad-500091 Name : V.V.S.S.Sastry

Mail-id : ad4wu1@r.postjobfree.com

Mobile : +91-900*******

Present Address Location : Hyderabad

Skills : Oracle 9i PL/SQL, D2k, Forms & Reports

Applications Design & Development 19

Years experience from Apr’2000 to Mar’19.

SAP ECC6, BW/BI, ABAP Development

Techno Functional Lead for Applications

Design & Development-13 years experience

from Apr’2006 to Mar’2019.

Earliest Date of Joining : Immediate.

Last Worked Organisation,Role : HSIL Limited, Hyderabad- Senior Manager IT Last Salary Drawn : Rs.16,54,000 pa

Work Experience

Applications Designed / Developed:

Period : From Apr’1994 to Mar’2000- 6years

Modules : Warehouse, Stores, SQC, Trading Division Stocks Language : COBOL with WDOS OS

Team Size: 1

Organisation: Hindustan Sanitaryware & Inds.Ltd,Bibinagar Factory

Warehouse Invoicing

Saleable Stock Generation

Central Excise Reports Generation like RG1, RT12 and Modvat reports

Trading division Invoicing

Trading Division Stock Maintainence MIS

Stores Bincard Maintainence reports

Stores Stock Maintainence reports

SQC Resultsheet register Maintainence form provision

Several QC Reports MIS

Masters Maintainence Item / Weight / Machines / Product / Colour/ Quality wise

Price Masters Maintainence

Production Planning Reports

Period : From Apr’2000 to Dec’2005- 5years 9 months Modules : Sales & Warehouse, Inventory, SQC, Trading Division, Payroll Language : Oracle PL/SQL with Win NT Client server Technology Tools : Oracle Forms 6i, Reports 6i and Developer 2000 Team Size: 2

Organisation: Hindustan Sanitaryware & Inds.Ltd,Bibinagar Factory

Masters Maintainence – Item / Quality / Colour / Kilns / Groups / Prices / weights

Sale Order Processing

Delivery Maintainence

Invoicing

SQC Result Sheet Data forms provision for inputting production data Through Touchscreen Application & Manual Entry

Scripts for porting production data for availability in sales orders & billing

Central Excise reports viz. RG1, RT12 abstract generations

Production Planning & controlmaintainence against budgets

Order vs targets

Billing vs targets

Physical stock maintainence

Saleable stock Maintainence

Various Production MIS generation

Various Stock reports MIS generation

Stores Cardex Maintainence

Stores Bincard Maintainence

Stores Various Stock MIS reports

Porting of data from one module to another provisions

SQC Various MIS reports

Trading Division Sales order / Delivery & Billing

Trading Division Stocks maintainence

Trading Division various reports

Payroll Workers Attendance maintainence

Payroll Masters Maintenance

Payroll wages register

Payroll PF / ESI Statuatory reports

Project Lakshya

Below are the activities exclusively handled from SAP installation phase till date. BASIS Administrative Activities:

Period : From Jan’2006 to Mar’2006- 3 months

Language : Oracle PL/SQL

Tools : Oracle 8i

Team Size: 1

Organisation: HSIL Limited, Secunderabad

Installed R/3 and BW and EP systems (Dev, Qar, Prd ).

Creating and maintaining Roles for users in R/3 and BW.

Maintained reporting authorizations in BW.

Check ABAP dumps.

Monitoring and maintaining RFC destinations.

Monitoring and Maintaining of Scripts in AIX for fetching Touchscreen data and Qlikview data.

Coordinating with ABAPERS with regard to new ABAP Developments and performance activities.

ABAP Development Activities:

Period : From Apr’2006 to Oct’2011- 5years 7 months Language : Oracle PL/SQL

Tools : Oracle 9i,ABAP4, BW3.5

Modules : Sales & Distribution, Material Management, FICO, PP,QM ( reports devt ) Team Size: 3

Organisation: HSIL Limited, Secunderabad

Smartforms

Scripts

ALVs

BAPI

BW3.5 / BI7 Development Activities:

Period : From Oct’2011 to Mar’2019- 7years 5 months Language : Oracle PL/SQL

Tools : Oracle 9i, SAP BI 7

Modules : Sales & Distribution, Material Management, FICO, PP,QM Team Size: 2

Organisation: HSIL Limited, Hyderabad

Created & Monitored Infocubes, ODS Objects, Infosources, Info Objects,Info Packages and scheduling the Data into datatargets.

Created Heirarichys manually as per the requirement.

Worked with PSA in monitoring the data transfer from source system to BW.

Created Generic data sources on SAP R3 based on tables and views inorder to upload the data into BW.

Generated Datasources using the DB connect inorder to Upload the data into BW from oracle DB tables.

Monitored Statistical setup for LO cockpit and used V3 update for delta load management.

Loading data into ODS before loading data into infocube.

Involved in performance issues like creation of aggregates, Partitioning, indexing and compressing the infocube .

Used data update mechanisms for uploading the data to BW from R/3 in specific intervals.

Involved in execution and monitoring of Process chains.

Involved in data validation with datatargets against PSA.

Specific purpose reports development.

Strong knowledge in Data Modelling in development and Maintainence of objects.

Strong knowledge in Admin workbench activities

Worked on Activating and extending business content As per user requirements.

Worked with extractors including LO cockpit, Generic, Oracle DB & flat file.

Strong knowledge in creating BEX Queiries, Workbooks & utilizing WAD.

Expertise in Performance issues of Data Loading, Query Execution.

Strong knowledge in User Administration, Authorisations and Profiles.

Practical experience in Data Source enhancements,Routine

Well versed with Transportation of objects from Development to Quality & Production system.

Knowledge of Open Hub feature to export data from SAP BW to external systems.

Monitored data loads from R/3 source systems.

Mobile porting dashboard applications generation.

Performed day to day activities like Attribute change Run, Aggregation, Maintaining Proccess chain, handling lock Problems, identifying missed SIDs to load data successfully

Problems, identifying missed SIDs to load data successfully

BW House keeping like PSA & change log deletions.

Performed roll up data from infocubes to aggregates Involved in solving tickets regarding extractions, Performance issues and also load failures. Other Technologies Handled at Managerial Level

NETWORK

Maintaining and monitoring of all HSIL Location network connections. Sonic Wall (Firewall):

This is the Fire wall device used at HSIL. The public IP mapping for Lotus mail and Webmail servers and also all remote locations(leased lines) are done in this firewall. Other IT Activities:

A). Domain creation and maintenance.

B). Maintain the user profiles.

C). Maintain the user antivirus rights, privileges and passwords D). MCAFEE maintenance.

E). Regular System backup through tape drives

F). Hardware management

G). Commercial activities like procurement of new systems and related spares as and when required.

H). Coordination with IT vendors on timely basis.

I). Maintenance of IT records as per the IT audit recommendations.

Contact this candidate