PAVAN JILLA
E-mail: **************@*****.***
Mobile: +65 83081107
EXECUTIVE SUMMARY
More than 14 years of experience, with strong analytical skills and broad range application development experience using Microsoft .NET Technologies (C#, ASP.NET, WCF, MVC, .NET CORE and Cloud based applications)
Expertise in N-Tiered, Object-Oriented and Service Oriented based Architecture, Analysis and Design & Development.
Having 14 years of experience in designing and development, project management, technical support for various applications and very strong in .NET Framework 3.0/4.0/5.0, VB.NET, C#. NET, ASP.NET, Microsoft SharePoint, K2 Black Pearl, AJAX, XML Web services, WCF, WPF, Silverlight, LINQ, Entity Framework, MVC, Threading.
Extensive experience in .Net Core 3.0/5.0/6.0 Web based application development based on C#, ASP.NET MVC CORE, CORE entity framework and Micro services.
Used 3rd Party tools like DevExpress for web applications.
Experience in services like Restful services like WCF/WEB API or web services, JWT Token and O Authentication.
Experience in IIS, AJAX, JavaScript, XML, CSS, HTML, DHTML and XSLT technologies.
Experienced in Database - SQL Server 2000/2005/2008/2016/2022, Oracle 10g/11g/19c, Mango DB 4.0/2022(6.0). PL SQL 12/13/14.0
Experience with Source Code Control Systems like Microsoft Visual Source Safe, TFS, SVN and GIT.
Reporting with SQL Server Reporting Services (SSRS) and Crystal Reports.
Experience in manual testing, unit testing by using NUnit Framework with .NET.
Having knowledge and experience with Azure services including Azure SQL, App Services, Azure storage, Azure data factory.
Having knowledge and experience in Cloud environment like Azure, AWS, Dockers and kubernates.
Having experience in CI/CD deployment tools integration like Jenkins, Azure CI/CD deployment.
Having knowledge and experience in front end technologies of ReactJs and Redux, Agular JS, Angular
Having development experience in orchestrations, maps and schemas development, deployment, and configuring BizTalk Server 2010/2013/2016/2020.
Having development and support experience in Microsoft Dynamics 2013, D365(2402/2406/2407).
Adhered to the Agile and waterfall methodologies.
Having knowledge and experience in streaming technologies in MSMQ, Rabbit MQ and Kafka.
Having in-depth knowledge of micro services architecture and implementation.
SKILL SET
.Net Technologies
ASP,VB, WCF, Silver Light, C# .Net, VB.Net, MVC,.NET Frame work 2/3/4/4.8
.NET CORE Technologies
.NET CORE 3.0/3.5/5.0, ASP.NET MVC .NET CORE, .NET CORE Entity Framework, .NET CORE C#
Full Stack Technologies
React Js, Angular JS(2.0), Angular 3.0
Integration Technologies
BizTalk Server- 2010/2013/2016/2020, Restful services, Web Services, WEB API, JWT,WCF, Azure Services
Reporting Tools
Crystal Reports, SQL server reporting services, SSIS and Cubes and ETL Transformation
Databases
SQL Server 2008R2/2012/2016/2017/2022, Oracle 10 g/11 g/19c, PL/SQL 12/13/14, Mango DB 4.0/6.0(2022), Radis cash management DB
Cloud Technologies
Azure, AWS, Dockers and Kubernates, Python
Deployments
Azure CI/CD, Jenkins
Operating Systems
Windows Family, Linux family
Application Servers
Microsoft IIS
Version Control
Visual Source Safe, TFS,GIT,SVN
Power Tools
Power Apps, Power Automate, Power BI
CRM
Microsoft CRM 2013, D365(2402/2406/2407)
Streaming Technologies
MSMQ, Rabbit MQ, Kafka
CMS
ADOBE, Hub Spot
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 .NET
MCTS in Microsoft BizTalk Server
PROFESIONAL EXPERIENCE
The Learning Lab, Singapore Jul 2020 – Till Date
Project: In House applications
In house application web based support and enhancements. Teacher relationship management system used to facilitate the online classes, schedule, TDOWN tracking. Support and enhancements in Tportal, P Portal. TDQM, SRM. Other integrations with CRM, finance system, CMS systems.
Roles and Responsibilities:
Design, Architect and development of on multiple in house .NET based applications.
Interacting with clients for requirement analysis, define scope, technical documentation, effort estimation, impact analysis, integrate applications of CI/CD pipe line deployments using Azure.
Development and enhancement of existing web based applications using ASP.NET MVC CORE,.NET CORE, C#. Entity framework CORE
Integration of applications using Restful services, WEB API’s, JWT, and Azure Apps services with CRM.
Responsible for the design of UI framework using React JS.
Cloud application development .net docker image, deploy to docker and maintain on kubernates.
POC exposure to messaging system using Kafka to maintain online books.
NTUC Income, Singapore Mar 2019 – Jul 2020
Project: Insurance products
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 customer’s 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.
Enhancement and support of various .net applications built on .NET framework and micro services.
Roles and Responsibilities:
Interacting with client for requirement analysis, define the scope, effort estimation, impact analysis, technical design documents, unit test cases, integrate applications of CI/CD deployments.
Development and support the existing BizTalk applications.
Development and support of existing web based applications using VB.NET/C#/MVC.NET/WEB API/Web Services/.NET Core.
Development of front end application (Single Page Application) using ReactJs and Redux
Optimize the performance fine tuning using various technics and monitor the threshold using dynatrace tools.
Ascender HCM Pte LTD, Singapore (Ascender Pay Asia Product) 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. This is product based company as such having 1000+ clients over the world.
Responsibilities:
Lead the team of developers to implement the designed solution, architecture and perform code reviews, developing and adhering to coding standards.
Development and Enhancements of existing web based applications using MVC/ASP.NET/WEB API/AngularJS.
Development of front end application (Single Page Application) using AngularJS. Migration of AngularJS to Angular 3.0
Optimize the performance fine tuning using various technics.
Migration of existing infrastructure to AWS cloud this includes infrastructure setup and application development.
Automate the deployment process aligned with Ci/CD pipeline.
Implemented the penetration testing (security) standards and followed burp suite tool.
Application technology upgrade.
Xchanging Solutions Pte Ltd, Singapore Jan 2015 – Jan 2016
Client: SMBC Bank, Singapore
Project: Banking Project
SMBC banking project to develop master system management, cash payments, trade and loans.
Responsibilities:
Interacting with client for requirement analysis, define the scope, effort estimation, impact analysis.
Preparing technical design documents and database design
Preparing Unit Test Cases.
Development and support of existing web based applications using Win Forms.
Re development of existing win forms to WPF.
Environment: C#.NET (4.5), Win Forms, WPF, SQL server
Xchanging Solutions Pte Ltd, Singapore Jun 2011 – Jan 2015
Client: American eagle Tankers (AET), Singapore
Project: COS (Commercial Operating System) & MDS
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 200 6 R2.
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.
Development of ASP.NET web based applications and SSRS reports.
Integrated BizTalk applications based on Oracle financial system and SAP system as well.
Coordination to other parties including business team, SAP/Oracle functional/technical consultant, vendor products (Veson-IMOS, Port Agent).
Migration of BizTalk applications from 2006 R2 to 2012.
Environment: BizTalk Server 2010/2013, C#.NET (3.5), IIS, CSS, MVC.NET, ASP.NET, ADO.NET, HTML, MS SQL Server 2005/2008 R2 and 2012, Oracle 10g/SAP, IIS, Visual Studio .NET 2005/2013, ETL, SSRS.
Xchanging Solutions Pte Ltd, Singapore Jun 2010 – Jan 2011
Client: National University of Singapore, Singapore
Project: IORC (Integrated Online Research Compliance System)
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), ASP.NET, WCF, HTML, XML, XSLT, Oracle 11
Xchanging Solutions Pte Ltd, Singapore Jun 2009 – Jun 2010
Client: SATS, Singapore
Project: SATS
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.
Xchanging Solutions Pte Ltd, Singapore Nov 2007 – Jun 2009
Client: AET, Singapore
Project: CMSS (Custom payroll for Singapore and Malaysia)
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 ADO.NET, HTML, XML, CSS, Active PDF, InfoPath 2003/2007, Excel, Windows XP and Oracle 9i/10G database.
Xchanging Solutions Pte Ltd, India Dec 2006 – Nov 2007
Client: Everest Industries Private Ltd, India
Project: Order Management System
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, SQL server 2005 database and BCP programming.