*

Venkata Subramaya (Sarma) Malladi

(Cell- 1-506-***-****)

Email: acq654@r.postjobfree.com

PERSONALSTRENGTHS

A highly experienced Information Technology (IT) professional who has demonstrated the ability to lead diverse cross-functional teams to new levels of success in a variety of extremely competitive and fast-paced IT projects Proven ability to successfully analyze critical business requirements, identify deficiencies and potential opportunities, and develop innovative and cost-effective IT solutions for various types of customers. TECHNICAL STRENGTHS

Strengths

Years of Work

Full Cycle Project Management and Leadership

More than 12

Full Cycle Project Management and Leadership

Development and maintenance of online and batch systems on a variety of platforms. Databases, and front-end tools More than 15

Implementation of web and client-server applications using Microsoft technologies such as ASP, VB.NET, ADO.NET and C#.

More than 10

AngularJS More than 1

Software systems integration

More than 10

Scripting Languages- VB Script and Java Script More than 10

Sound knowledge of Databases(MS SQL (2005, 2008

R2,2012),Teradata(15.0) and DB2 on AS400 -- Stored Procedures, Views, Triggers, Joins like database objects in MS SQL (2005, 2008 R2,2012), and ADO.NET components such as Data Grids, Data Sets, and Repeater Controls

More than 15

Design, implementation, and utilization of Crystal Reports (Crystal 8, 9 and BUSINESS OBJECTS (Crystal Reports XI release 2)) More than 14

SQL server Reporting and Integration Services.

More than 10

Dash Boards Pivot table creation in Excel

More than 13

Good exposure to BI reporting MicroStrategy 9.4 & SQL programming.

More than 2

ERP – Macola Support and development/support of Surrounding applications

More than 12

PROFESSIONAL EXPERIENCE

Day and Ross Transportation Group of McCain Foods Limited (2014 April to to-date) Support Supervisor:

Applications

i) Pricing and Costing

Developed Interface from PAC application to provide Details for Management

It is developed in vb.net, C# and VB Script

ii) Enterprise Order Management System.

It is Web-based application developed in house. Developed in ASP.net, C# and Java Script.

I am supporting this application and fixing bugs as and when found by business. iii) MicroStrategy.

Leading a team of 4 persons – 2 from India 2 from Ukrain.

Conducted business meeting to analyze the requirements and designed the reports for development.

iv) Dealer Profile: Developed a Web-App using Asp.net C# and Java Script. This application has two parts –

Original Manufacturer’s dealer details and

Dealer Contract Details.

2

McCain Foods Limited, NB, Canada (1999 July – 2014 March) Technical Lead/Senior Developer and Analyst

Projects:

1. SAP to 3PL (3RD Party Logistics)

When McCain moved from Macola ERP to SAP ERP for order management, the format in which Macola was submitting the shipping details was different from the format received from SAP. Hence had to write an interface

The interface is developed in VB.net and C# and VB Script. 2. Other Interfaces Developed in VB.net, c# and Java Script/VB script

Product Information Management (PIR/PC) – Interface Schedule to run everyday at 7 :00 am

Data migration from MACOLA ERP to SAP ERP.Migration from Crystal XI upgrade to SAP Crystal reports for Enterprise (4.0)

Warehouse Management System to Macola(ERP) - Interface and UI

Product Information Repository to

i) 1Sync Data pool for Continental Europe.

ii) GS1 Data pool for Australia and Europe

iii) Product Catalog

PRMS (On AS400 to PIM(PIR/PC ) Interface

Incident Management for Non Conformance/Reject system i) Developed client server interface to extract data from Magic (now BMC software - Remedy) on the basis of requirements’ documents provided. Wrote rules and conditions for NCR incident. ii) This system is mainly used to record problems related to raw material received from the vendor and human workflow management.

FRM-PIR/PC interface

3. MACOL (ERP) EDI Management and Integration:

o Exact EDI application is used for extracting Data from Macola and creating EDI 850/940/945 documents. Also used for Inserting/Updating Order details into Macola when EDI 850/940/945 documents are received.

o Bizlink AS2 communication is used for transmitting the data from source and to destination. 4. Macola (ERP) Upgrade to 7.7.3

I. For 7 regions - Japan, Taiwan, India, MII, China, Colombia and McCain Fertilizer. II. Modified and/or re-developed all 16 surrounding interfaces. III. Moved more than 160 Crystal reports, locally run in Colombia to Crystal Enterprise server in Global Technology Center.

5. Product Information Management (PIM) - Upgrade from SQL2000 version to SQL2005, SQL2008 AND SQL2012.

6. Japan Sales - Order Management System

Developed way back in 2001 in Visual Basic.

i) Crystal reports on Crystal 9.0.

ii) Scripts for all the stored procedures required for this application and reports. 7. Grower Management system

i) Application Layout, Database design, and report layout for Grower management system

(GMS), a data collection and reporting application concerned with field and storage management aspects of McCain agricultural business. 8. McCain Employee Photo-Identity-Card System

9. Management reports (SQL SSIS,SSRS and SSIS):

i) DTS and SSIS packages

ii) Matrix/Table reports on SSRS for management from the SQL databases iii) Pivot reports on Excel are generated.

10. Crystal Reports for :

i) Formula Management System:

ii) Crystal XI Migration:

iii) Potato Contracting and Receiving (PC&R)

3

11. Support :

Sales Data Warehouse on Oracle Sales Analyzer.

Macola for for India, Canada, UK, CEU Australia/Newzealand.

Transport Management System.

All the surrounding applications for Macola.

Prepared Test scripts and unit tested the application start-to-finish. 12. Conducted a number of training sessions to train employees responsible for implementing this system at all McCain Food Plants, including ones located internationally. Details of the each of the projects worked on and references will be provided as and when asked for.

EDUCATION & PROFESSIONAL DEVELOPMENT

Bachelor of Commerce from Osmania University, India

Post-graduate Diploma in Computer Applications

Certificate courses

ITIL

Project Management Methodologies

Microsoft SQL 2005. Microsoft SQL 2008.

MicroStategy

Teradata

Contact this candidate