Sql Server Sales
VEERA ANIL KUMAR ARADADA
E-Mail: acw2f8@r.postjobfree.com
Visa Status: Visit Visa (Valid Till 7th Jan 2017)
Seeking senior level assignments in Software Design & Development with an organisation of repute
PROFILE SUMMARY
Over 8 years of experience in Software Development, Project Execution and Client Relationship Management
Experienced handling the completed Software Development Life Cycle functions for the development of software products, from inception, requirement specifications, planning, designing, implementation, configuration management, documentation and closure with cross-cultural teams
Gained exposure in domains like Health, Logistics, Education and Bank
Skilled in mapping the requirements, custom designing solutions and troubleshooting for complex software problems
Well versed with technologies such as C#.Net 4.5, VB.NET, ASP.NET, ADO.NET with .Net frameworks 4.5,WCF,WPF, XML and SQL Server 2008 R2, SQL Server 2012
ORGANISATIONAL EXPERIENCE
Mar’16 - Aug’16 Eco Villages, Hyderabad, India as FreeLancer
Sep’14 - Sep’15 CEDARS J.A.I.H, Dubai as Sr.Software Engineer
Nov’11 - Sep’14 BACK OFFICE FZ LLC, Dubai as Software Engineer
Nov’08 - Nov’11 Softgen Solutions, Hyderabad, India as Software Engineer
Jun’07 - Nov’08 Hind Info Way Pvt. Ltd., Visakhapatnam, India as Developer
KEY RESULT AREAS
Project Execution
Executing projects involving scoping, design & architecture, addressing all the important issues & defining best practices for project support and documentation
Collaborating with Project Managers and Technology Architects to provision estimates, develop overall implementation solution plan, etc. and serving as a lead for implementing, installation, customization and integration efforts
Software Development
Creating optimum technical solution in the context of the customer's environment, requirements and financial resources for designing & developing web based applications, interacting with the client & system engineering team for requirements gathering & scoping and handling architecture and designing the solution for the product
Managing process setup & development and undertaking code review, debugging and troubleshooting the application
Contributing regularly to provide creative solutions for complex problems
Extending post go-live and application maintenance support to the client
IT SKILLS
Microsoft Technologies: ASP.NET 4.5, VB.NET, C#.NET, ADO.NET, WCF, WPF, AJAX
Programming Languages: C# T- SQL
Development Tools: VisualStudio.NET 2003, 2005, 2008, 2012
RDMS: SQL Server R2, 2012
Scripting Languages JavaScript, JQuery
Operating Systems: Windows XP/7/ 8
Application Servers: IIS
Version Control: Visual SourceSafe
EDUCATION
B.Tech. (Information Technology) from Jawaharlal Nehru Technological University, A.P, India in 2006
PERSONAL DETAILS
Date of Birth : 2nd February 1982
Address : D.No: 10-285/1,Ravindra Raju Nagar, Amalapuram, E.G. Dist.,A.P,India.
Languages Known : English, Hindi and Telugu
Location Preference : UAE
ANNEXURE
Cedars Document Management System
Client: Cedars J.A.I.H, Dubai, UAE
Environment: C# .Net, Asp. Net 4.5, JQuery
Database: SQL Server 2008
Team Size: 2
Designation: Module Lead
Description: It was designed to create and manage electronic medical documents in PDF format and secure them, also to streamline workflows. This system boasted document scanning, indexing, archiving, accessing, retrieving, and document capabilities.
Responsibilities:
Involving in all phases of software development life-cycle (requirements, design, development, testing, release, support); communicating with different departments for daily updates, reviews & demos; involving in user training programs
Designing and implementing business layer using C#.NET to implement business logic
Interfacing uniformity throughout the application
Writing stored procedures and SQL statements for accessing data from SQL Server 2008
CliniCare-Cedars Hospital Management System (CHMS)
Client: Cedars J.A.I.H, Dubai, UAE
Environment: VB 6, XML
Database: SQL Server 2008
Team Size: 3
Designation: Team Member
Description: CHMS was an integrated, comprehensive software application system designed and developed in-house to address all the major functional areas of Cedars Jebel Ali International Hospital. This system was complete end to end business solutions ERP designed as per DHA guide line. It provided the benefits of streamlining of operations, enhanced administration and control, improved response, cost control and other benefits.
Responsibilities:
Writing stored procedures to access data from SQL Server2008
Managing Bug Fixing
Nokia Sapphire Incentive Program
Client: Nokia (UAE & KSA)
Environment: ASP.Net using C# .Net 3.5, Ajax, WCF, JavaScript
Database: SQL Server 2008 R2
Team Size: 2
Designation: Module Lead
Description: Nokia Sapphire Incentive Campaign is for Nokia mobile phone dealers. The same comprises of three phases i.e. Registration Phase, Verification Phase and Payout Phase. In the registration phase the dealers/sales person would register IMEI numbers of Nokia mobile phones sold by them. Each participant would register the IMEI numbers of the mobile phone. This can be done either by logging into the website or by sending an SMS with IMEI number. While registering the validity of the IMEI number is verified by consuming web services provide by Nokia. In the verification phase, the veracity of the IMEI numbers is checked for and all the invalid IMEI numbers are rejected by Nokia Field Force. In the payout phase, the target slabs of each dealer are verified on a weekly basis and payment is done only for dealers whose targets have been reached. All the invalid sales of the dealers would be blocked. The payment would be done through Prepaid & gift cards powered by MAJID AL FUTTAIM
Responsibilities:
Led all phases of software development life-cycle
Organised end user training programs
Involved in:
oDesigning and implementing Business Layer using ASP.NET to implement business logic
oDeveloping Cascading Style Sheets (CSS) for User Interface uniformity throughout the application
oWriting stored procedures and SQL statements to access data from SQL Server 2008
Customer Relationship Management (CRM)
Client: BackOffice
Environment: ASP.NET using C# .Net 3.5, AJAX, JavaScript
Database: SQL Server 2008 R2
Designation: Module Lead
Team Size: 2
Description: The project focused on creating a system, CRM Process, centralized data collection which has details of sales leads, customers and sales manager’s activities utilized to develop a team sales environment. This System Maintains Order List which is used by a sales representatives. The main functionality of this system involves, wherein a sales manager who collects information of customers and Fix the appointment with them for meeting to deal an order. If the customer is willing to take that order then automatically a lead was created as the confirmation sent to close the order. In Addition to manage authorization 3 roles are specified to access this application. Admin can view each and every data and is the one who grants the permission to authorized users and data entry operators. Each and every sales person acts as a user and has permission to view both self and customers orders list. Data Entry operator inserts and modifies the collected data into his system.
Responsibilities:
Worked on:
oAJAX Control tool kit and AJAX libraries for providing light weight AJAX requests
oJava Script and .NET Validation Controls for Client side Validation
Developed Cascading Style Sheets (CSS) for User Interface uniformity throughout the application
Post Dated Checks (PDC)
Client: NIB, City Bank, HDFC, Damac
Environment: Vb.net 3.5, XML
Database: SQL server 2008 R2
Designation: Module Lead
Team Size: 3
Description: The project focused on developing a system mainly targeting at storing, indexing, archiving and presenting document/file/paper as scanned image. This entails ability to restrict access to certain document or group of documents to only authorized users at different levels which provide a comprehensive solution for indexing, storing, and retrieving document images in a secured environment. The main functionality of this system is to make the user to capture the images which are displayed on the Top Half and Entry Field on the Bottom Half on the screen to complete his task and then processed to committed list. Imaging has been retooled from top to bottom which is much easier to use. This helps to eliminate the entire physical archive by capturing the images of the documents and ensures that the current document viewed by the user gets locked under him automatically and is hidden to others. Admin checks the task of committed list .If any correction is traced out then that file will be backed to the authorized user to rectify. After completion, the images were mixed irrespective of project /file etc and were generated as reports in a specific folder to save as corresponding files.
Responsibilities:
Handled the maintenance and production support
Engaged in delivering basic training of end-user personnel during the implementation
Utilised Datasets, Data readers objects in ADO.net to pull the data from database
Management Information Systems (MIS)
Client: Noor Islamic Bank
Environment: C# .Net 3.5, XML
Database: SQL server 2008 R2
Designation: Module Lead
Team Size: 2
Description: The project aimed at developing an E-Statement Generation System, designed in Windows Based Application, an E-Statement which is an electronic statement delivery system that is an alternative to receiving a traditional paper statement. The use would receive the same information as a paper statement but with the convenience of electronic delivery. This service allows user to view monthly statements of accounts, Credit Cards and Locality notices electronically. The e-statement contains both HTML & PDF information. The PDF Statement is protected with password. HTML statement/e-Statement Email body is configured in HTML format based on the type of the user. E-Statement Email is sent through Default SMTP Virtual Server in Windows OS.
Responsibilities:
Carried out the development, bug fixing, maintenance and production support functions
Took steps for enhancing the application time to time based on business requirements
Carried out the design of the database and modifications on the existing database based on the requirements
Freight Delivery System (FDS)
Client: OHL (OZBURN- HESSEYLOGISTICS), Memphis
Environment: C#.NET 3.5, WCF
Database: MS-SQL Server 2008 R2
Designation: Team Member
Team Size: 10
Description: The project dealt with Ozburn-Hessey Logistics, which is a leading provider of global supply chain management solutions including transportation, warehousing and distribution, customs brokerage, freight forwarding and import and export consulting services. FDS handles all the operations right from the shipment notice till the goods have been delivered. Core features includes Terminals Tracking, Shippers Tracking, Allocation setup, Carriers Tracking, Consignees Tracking, Route Creation, Zones, Zip Ranges, Owner/operators, Driver categories. Creating bills of lading, Creating manifest for all the bills of lading, calculation of estimated costs. Tracking of the shipment status right from shipment notice till the goods have been delivered. Delivery confirmation, Process driver pay, Process invoices.
Responsibilities:
Engaged in implementing OOPS concepts and developed the application and Designed Business components and Data Access Layer using C#
Utilised:
oTelerik controls for great user interface experience
oVisual Source Safe 6.0 for source version control on a shared team environment
oData Bound Controls like Data Grid, Data Table, Data Reader, Data View and Dataset
Led design and development of various abstract classes, interfaces, classes to construct the business logic using C#, ADO.Net
Prepared various reports using Crystal Reports
Accountable for creating complex stored procedures using temporary tables and loops using SQL. Implemented Triggers and parameterized functions
Electronic Event Reporting System (EERS)
Client: St.Jude’s Children Research Hospital (SJCRH), USA
Environment: ASP.Net using VB.Net 3.5, JavaScript
Database: MS-SQL Server 2008 R2
Designation: Team Member
Team Size: 2
Description: EERS was a Health Domain Software, an enterprise system to automate and reliably manage incident event information which established a uniform process to capture event data and to centralize data for reporting and analysis.
Responsibilities:
Developed front end using ASP.Net web application & AJAX and code behind files using VB.Net
Involved in development of UI (User Interface) pages using the HTML, master pages & ASP.NET
Performed client-side validation using JavaScript
Created Cascading style sheets (CSS) to attain uniformity through all pages
Wrote stored procedures,UDF’s and SQL statements to access data from SQL Server 2008
Thoroughly tested various modules and fixed the bugs
Excelicare
Client: Axsys Health Tech Ltd. Healthcare domains (GCS, CWT, Mediscan, LRK, Oxford Gum Interface, NaSH, OCLM), UK
Environment: ASP.Net using C#.Net 3.5, WCF, JQuery, XML
Database: MS-SQL Server 2005
Designation: Team Member
Team Size: 5
Description: Excelicare was a powerful toolset-based application that allowed the creation of highly tailored clinical systems to reflect the complex working patterns of clinicians. Specifically designed as a clinical process modeling tool' Excelicare, by capturing information at each patient event and by using clinical algorithms, enables clinical care pathways to be defined ensuring that correct treatment protocols are followed.
Responsibilities:
Worked on localization concept for multilingual web pages in ASP.NET
Involved in designing &developing Web Forms (UI) using HTML, CSS, HTML Controls, Server Controls & Data Controls
Implemented client side validation using JavaScript as well as a set of validation server controls
Wrote stored procedures, UDF’s and SQL statements to access data from SQL Server 2005
Referring Physicians Office (RPO)
Client: St.Jude’s Children Research Hospital (SJCRH), USA
Environment: ASP.Net using C#.Net 2.0, JavaScript
Database: MS-SQL Server 2005
Designation: Team Member
Team Size: 3
Description: Referring Physicians Office was a project aimed gathering the caller information to the client’s hospital. It recorded information of the caller and the patients along with the previous doctor’s profile, if any. RPO acts as one stop solution for the physician to understand the history of the patients. RPO provided the benefits of maintaining patient record, making it immediately available to the appropriate people throughout the organization.
Responsibilities:
Enhanced the application time to time based on business requirements
Developed code for data access routines in ADO.NET, which involved data manipulation with data reader, data adapter, arrays, transaction processing and exception handling
Modified the database and written stored procedures to handle the data from different tables in the database and for fast retrieval of data
School Automation
Client: Little Angels English Medium Schools, India
Environment: C# .Net 2.0
Database: MS-SQL Server 2005
Designation: Team Member
Team Size: 8
Description: This application was developed to automate the manual process of the school for maintaining student and employee database. This project also included attendance, library management, hostel, transport, payroll, and time table and inventory modules. Key features of this application were tracking sales and marketing activities and Providing Stock Information.
Responsibilities:
Involved in development, generating reports using crystal reports and DB design
Involved in unit testing in various modules, fixed the bugs and integration testing
Contact this candidate