Oracle Applications developer/SAP Techno Functional Lead

Name : VVSS Sastry

Mail-Id : **********@*****.***

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

Present Address Location : Hyderabad, Telangana State, India

Skills : Oracle 9i PL/SQL D2k

Oracle EBS Forms Reports IT ERP

Applications designed and development

19 years experience

from Apr’ 2000 to Mar’2019

SAP ECC6, BW3.5/BI7,ABAP Development

Application Design & development as

Techno Functional Lead 13years experience

from Apr’2006 to Mar’2019.

Service Break : From Apr’2019 to till date

Transferred me to North Location,

interested to work in South.

Family Circumustances also lost father.

Earliest date of joining : Immediate

Last Employed Organisation,Role : HSIL ( Hindware ) Limited,Hyderabad

Senior Manager IT

Last Salary Drawn : Rs.1654000

Summary

Overall 25 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

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 MCAFEE Maintenance.

E). Regular System backup through tape drives

F). Hardware management

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

H). Coordination with IT vendors on timely basis.

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

Contact this candidate