PAVAN JILLA

E-mail: addeal@r.postjobfree.com

Mobile: +65 83081107

EXECUTIVE SUMMARY

More than 10 years of experience, with strong analytical skills and broad range application development experience using Microsoft Technologies(C#, ASP.NET, WCF,MVC and SQL Server and Oracle) and expertise in BizTalk Server integrations.

Expertise in N-Tiered, Object-Oriented and Service Oriented based Architecture, Analysis and Design & Development.

Strong development experience in orchestrations, maps and schemas development, deployment, and configuring BizTalk Server 2006/R2, BizTalk 2010/2013.

Support and maintenance experience in SharePoint Projects

Extensive experience in development of Web applications using C#, ASP.NET, ADO.NET, AJAX, Web Services, WCF, SOAP, REST, Java Script and JQuery.

Experience in IIS, AJAX, JavaScript, XML, CSS, HTML, DHTML and XSLT technologies.

Experience in creating User Controls & Custom Server Controls using ASP.NET and C#.

Experience in Database Design, Database Programming, Normalization and Performance Fine Tuning in SQL Server.

Experienced in writing Database Queries, Stored Procedures, Triggers, Cursors, Functions and Views using T-SQL and PL/SQL in SQL Server 2000/2005/2008, Oracle 10g/11g.

Extensive experience in Extraction, Transformation and Loading of data from multiple sources into Data warehouse using SSIS/DTS/Cubes.

Experience with Source Code Control Systems like Microsoft Visual Source Safe 6.0(VSS) and TFS and SVN.

Reporting with SQL Server Reporting Services (SSRS) and Crystal Reports.

Experience in .NET Framework 1.0/2.0/3.5/4.0,ASP.NET, LINQ, WCF, and knowledge in WPF and Silver light.

Highly dedicated, quick starter, solution driven pattern programmer, Strong in Object Oriented Analysis and Design, Excellent problem solving skills under strict deadlines

Experience in manual testing, unit testing by using NUnit Framework with .NET.

ASP.NET front end Java Script as well

Implemented Data warehousing projects which includes SSIS (ETL) and SSRS and Build Reports using MDX queries.

Having 3 years’ Experience in developing applications using MVC.NET and AgularJS

Having experience in .NET core (Dockers) and Microservices as well.

Having experience in Cloud based application development/hosting on AWS cloud platform.

SKILL SET

.Net Technologies and Related Tools

Microsoft Visual Studio.NET 2008/2010, ASP,VB, Microsoft BizTalk Server 2006 / R2/ 2010/2013, WCF, Silver Light, Microsoft Class Server 2.0, C# .Net, VB.Net, ADO.Net, ASP.Net, .Net Framework 2.0/3.5/4.0, Enterprise Libraries 3.0 / 4.0, MVC.NET,WPF,WebAPI

Web Technologies

ASP.Net, HTML, DHTML, XML, SOAP, AJAX, JavaScript, CSS, Front Page, Share Point 2010

Reporting Tools

Crystal Reports, SQL server reporting services, SSIS and Cubes and ETL Transformation

Databases

SQL Server2008R2/2012, Oracle 10 g/11 g, Ms-Access.

Operating Systems

Windows Family

Application Servers

Microsoft IIS

Version Control

Visual Source Safe, TFS,GIT,SVN

Other

Active PDF, Visual Source Safe, Ms – Office.

EDUCATION QUALIFICATIONS

Master of Computer Science from Osmania University, Hyderabad, India in 2003.

Batchelor of Computer Science from Osmania University, Hyderabad, India in 2001.

Intermediate from Board of Intermediate Education, Hyderabad, India in 1998.

S.S.C. from Secondary School Certificate, Hyderabad, India in 1996

CERTIFICATION

MCP in C#.Net and ASP.Net

MCTS in Microsoft BizTalk Server

PROFESIONAL EXPERIENCE

Company: NTUC Income (Singapore) Mar 2019 – Till Date

Project: Entity and Other systems

Entity is the middleware BizTalk integration based project to integrate FFA, EBAOLI and EBAOGI, SAP and other products within INCOME. FFA and EBAO products integrated with BizTalk using WCF Web service adapters.

This BizTalk application used to sync the policy information for Agents and customers information.

Whenever new agent and new customer created or updated with in entity, the same information will get auto sync to all other systems. MSMQ is the middleware system implemented to place all the orders in the system.

Developed and maintains of other .NET applications also supported.

Responsibilities:

Interacting with client for requirement analysis.

Preparing Design & Configuration Documents and Database Design

Preparing Unit Test Cases and testing.

Development of BizTalk applications using various adapters.

Development of web based applications using .NET applications.

Cloud based services implemented using AWS.

Develop documentation for requirements gathering, design, testing and user guides

Environment: C#.NET (4.5), BizTalk 2013, MSMQ, Web Services, MVC.NET Web based applications, VS2017.

Company: Ascender HCM Pte Ltd (Singapore) Jan 2016 – Feb 2019

Project: Ascender Pay Asia Product

Ascender Payroll Product used to facilitate the payroll process and consists of few other modules including Leave, Payroll and attendance and pay timers for various countries. Customization with respect to client modules.

Responsibilities:

Interacting with client for requirement analysis.

Preparing Design & Configuration Documents and Database Design

Preparing Unit Test Cases and testing.

Created dynamic templates for filling the Application using XML and XSL.

Creating various access based rules.

Develop use cases and facilitate UATs

Cloud based services implemented using AWS.

Develop documentation for requirements gathering, design, testing and user guides

ETL Transformation for Initial data load

Application technology up gradation.

Environment: C#.NET (4.5), ETL Transformation, WebAPI, MVC.NET, SQL server and AngularJS and AWS.

Company: Cambridge Solutions Pte Ltd (Xchanging) (Singapore) Jun 2011 – Jan 2016

Project: COS (Commercial Operating System) & MDS

Client: American eagle Tankers (AET), Singapore

Commercial Operations System (COS) deals with which multiple legacy systems currently in place (Advantage, Dataloy, Excel spreadsheets) will be replaced by the implementation of the Veson IMOS core system.COS will markedly improve the efficiency of AET business by integrating the activities of Chartering, Operations, onboard and Finance across all regions, providing a platform to support to fleet growth over coming years. Ultimately, COS will allow Employees in Chartering and Operations to function as a global integrated commercial team, in line with ‘one AET’ ethos, and assist AET in its mission to become the world’s leading petroleum tanker operator.

AET has multiple systems that are used by different verticals of the business. Each of these systems has specific functionality but few of the business entities such as vessel, Agents, ports, terminals etc are common across the applications. Because of the overlap of business entities between these stand alone applications, there are myriad of problems encountered at AET. To facilitate all the systems, using BizTalk data will be pulled into Master and Transactional databases. From the transactional database data will be pulled to data mart. On top of the data mart, using the Microsoft Share point generated the reports.

Installed and configured the Microsoft BizTalk server 2006 R2/2010.

Involved end to end development of BizTalk orchestrations, maps and schemas.

BizTalk development using File adapters, oracle adapters, SAP adapters, WCF custom oracle/sql adapters, web service Adapters, notification services.

Implemented role based security that demarcates the administrators from the report viewers and grant applicants.

Actively involved in analysis, design, development, and testing.

Developed test strategies, test plans and test cases and performed unit testing to identify and resolve integration, functional and usability issues before deployment.

Managing the project without escalations and delivering the deliverables on time

Managing the team and assign the work packets and track the status progress.

Managing Data transformations using ETL and built many reports using SSIS Cubes.

Environment: Windows 2003 Server, BizTalk Server 2010/2013, C#.NET, IIS, CSS, ASP.NET, ADO.NET, HTML, XML,XSLT,WPF, MS SQL Server 2005/2008 R2 and 2012, Oracle 10g, IIS, Visual Studio .NET 2005/2013, ETL.

Company: Cambridge Solutions Pte Ltd (Xchanging) (Singapore) Jun 2010 – Jun 2011

Project: IORC (Integrated Online Research Compliance System)

Client: National University of Singapore (NUS), Singapore

The iORC application is designed to facilitate moving from current manual process to electronic format. It eases data entry & submits research application for PI & team and facilitates work flow review and approval process of the applications by IRB, IACUC & OSHE offices. The development will automate continues review process and manage and maintain the entire documents electronically by moving out from current manual maintenance.

Responsibilities:

Interacting with client for requirement analysis.

Preparing Design & Configuration Documents and Database Design

Preparing Unit Test Cases and testing.

Created dynamic templates for filling the Application using XML and XSL.

Creating various access based rules.

Develop use cases and facilitate UATs

Develop documentation for requirements gathering, design, testing and user guides

CMS Management System features added

Environment: C#.NET (3.5),Win Forms, ASP.NET, WCF, HTML, XML, XSLT, Oracle 10g, Visual Studio .NET 2013.

Company: Cambridge Solutions Pte Ltd (Xchanging) (Singapore) Jun 2009 – Jun 2010

Project: SATS

Client: SATS, Singapore

The SATS application is designed to facilitate moving from SATS is the leading provider of gateway services and food solutions in the region. An evolution that has been the result of our commitment to delight customers and enable their success. This application enables the user to upload day to day tenders, and upload latest company news. This application is developed using the share point site.

Responsibilities:

Interacting with client for requirement analysis.

Supporting the share point portal

Environment: C#.NET, Sharepoint 2010 and content web parts and web parts, SQL server 2008.

Company: Cambridge Solutions Pte Ltd (Xchanging) (Singapore) Nov 2007 – Jun 2009

Project: CMSS (Custom Payroll for Singapore and Malaysia)

Client: American Eagle Tankers (AET), Singapore

Custom Payroll deals with Crew Payroll management in CMSS for American Eagle Tankers, Singapore and Malaysia.

The development of the Custom Payroll is designed to facilitate ease of data entry to the users who manage the day to day activities of the crew members and their payroll process. The development automates timesheet upload and the payroll process as much possible and the HR SEA user will require verifying the data on an exceptional basis only. It has the following module

Earning Setup.

Deductions Setup

Leave Encashment

Back pay Capture

Upload of Timesheet, Allowance Parameters & Deductions

Payroll process

Payroll Reports per month

Interfaces to Financial General Ledger system and CPF systems.

Responsibilities:

Implemented Page level security and permissions based on the authentication details.

Developed administrative functions such as assigning property viewing permissions and adding system users.

Customized alerts using XML.

I have written code using C# for importing data to EXCEL and MSWORD.

I used Active PDF Tool for converting files dynamically from Doc files to PDF the implementation code is written in C#.

I implemented code for printing Text, Doc and PDF and Image files without user interaction, for images we used MS Visio.

Implemented entity relationship models and design-based work products.

Provided technical support and updates customers and partners in a timely manner and documented technical and programming specifications.

Support Activities:

Attending client calls.

Troubleshooting and fixing the bugs.

Weekly project status update to client and leads.

Database backups and restoration.

Monitoring the scheduled jobs and processes.

Environment: VS.Net 2005, C#.Net, ASP.NET and Win Forms, ADO.NET, HTML, XML, CSS, Active PDF, InfoPath 2003/2007, Excel, Windows XP and Oracle database.

Company: Cambridge Solutions Pte Ltd (Xchanging) (India) Jun 2006 – Nov 2007

Project: Everest Industries Private Limited, India

Client: Everest, India

Description: Everest Industries Limited is looking for E-Business solutions to capture the Order inquiry, Orders, Invoicing, Credits, Inventories and Customers Accounts to make the decisions making easier and faster. The scope definition defines the master data management, order inquiry / order management, customer receipts, stock management of the distribution management process at Everest Industries Limited. An order inquiry / Order will be entered by the Field Personal / Sales Depots on the Centralized Database and will be reviewed by the Zonal Office / Head Office. The approvals will be based on the information relating to Marketing conditions, Freight and Net Realization. There are three types of order acceptance (1) Project/Retail order where the Price required are lowered than the Retail Price Support (2) Billing on Retail Price Support or (3) Export Order .Once order Inquiry is approved Order Entry is generated giving the complete details of Size wise Quantity required and other information to deliver the goods.

Responsibilities:

Implemented Page level security and permissions based on the authentication details.

Developed administrative functions such as assigning property viewing permissions and adding system users.

Sending the SMS and Email alerts.

I have written code using C# for importing data to EXCEL, HTML and PDF format using crystal reports

I used Active PDF Tool for converting files dynamically from Doc files to PDF the implementation code is written in C#.

Used OPENXML for updating bulk data in a single call to database.

Designed and Generated Reports with Crystal Reports

Implemented entity relationship models and design-based work products.

Provided technical support and updates customers and partners in a timely manner and documented technical and programming specifications.

Environment: VS.Net 2003, C#.Net, ASP.NET and Win Forms, ADO.NET, HTML, XML, CSS, crystal reports, Windows XP, SQL server 2005 database and BCP programming.

Contact this candidate