Sql Server Manager
Resume:
Vijaya Kumar Balraj
Professional Summary
As a consulting professional, over 13 years I have contributed to the successful delivery of large scale projects across all the phases of SDLC. My expertise is focused on extensive experience with Microsoft’s core solution technologies, from the first release of VB, to current .Net and SQL Server products. This expertise, blended with my business-oriented background, enables me to provide proven leadership in the development, and timely deployment of sizeable e-commerce solutions.
Core Qualifications
Rapid Web Development – Intranet and Internet applications development utilizing ASPX, XML, XSLT, and XSD for content management, data validation, and presentation.
Deep understanding of .NET Framework concepts, including experience with Web and Win Form development with C#.NET, ASP.NET, VB.NET, Entity Framework, WebAPI, (Visual Studio 2010/2008, CAB (Composite UI Application Block), HTML, XHTML, JavaScript, SSIS and SSRS
Experienced in Development of Reusable Components such as Data Access Block, Exception Block
Applying Multithreading techniques for creating high performance applications.
High Availability Database Development– SQL Server the right way, using stored procedures, user-defined functions, triggers, indexed views, and indexing strategy, efficiently and effectively.
Development of SSIS packages, SQL scripts, SQL Agent and AutoSys Jobs for scheduled data transfer and transformation between multiple database platforms or external systems.
Increased the amount of code reuse in the application by utilizing .NET’s true Object-Oriented development methodology.
Solved many complex problems by extensive research during the course of the project.
Have been involved in preparation of Client deliverable documents like High Level Design, Technical Design etc.
Ability to understand business requirements and translate them into technical design.
Ability to implement the Proof of Concept on any new technology and gain the customer confidence.
Ensure Quality throughout the Project as a Configuration controller
Analyzing and choose right open source technologies wherever it fits for the project / product
Involved team building activities Work allocation and team management
Code reviews, Tracked and reported the periodic status to the project manager and Client
Involved process and project management and Involved process related audits
Effective communication skills and strong record of managing onsite and offshore model
Technologies: NET Framework (4.0, 3.5, 2.0, 1.1), C#, Win Forms, ASP.NET, VB.NET ADO.NET, AJAX, Web Service, WCF, MVC, LINQ, JQuery, JSON, OData Source and SharePoint List adapter(Codeplex), VB (COM, COM+), ASP
Databases: MS SQL Server 2000/2005/2008/2012/2014, MS Access, Oracle, MySQL and Teradata
Tools: SSRS, SQL Server Integration Services (SSIS), MS Office 2007/2003, Microsoft Visual Studio.NET (2013,2010,2008,2005 and 2003), Infragistics, Net Advantage, DSOFramer and MS Application Blocks, CAB
Servers: Windows 2003 server, Microsoft SQL Server 6.0- SQL 2005 and SQL 2008
Web Server: IIS
Operating Systems: Windows 2000/ XP, MS DOS.
Web Designing: HTML5, HTML4, XHTML, Java Script, CSS, XML, XAML, XSL
Reporting Tools: SSRS 2005 and Crystal Reports
Version Control System: Visual Source Safe 6.0, TFS
Testing Tools: Manual Testing
Scheduling Tools: AutoSys
EXPERIENCE
#1 Centralized Underwriting – CU web tool
(Client: Wells Fargo-Middle Market Banking-Charlotte NC)
Framework 4.0, ASP.Net, C#, VB.NET, MVC, JQuery, XML, Ajax, TFS, REST and SQL Server 2008/2012/2014, SSIS and SSRS
CU tool is designed to provide mechanism for RCBO and CU offices to transfer Credit View relationships in and out from one office to another. This web based application replaced their current manual process and maintained in a Master Log. This tool automates the process and provides a framework for meeting business users/group compliance and audit requirements.
Role: Sr. Web Application Developer
Responsibilities:
Development and supporting Centralized Underwriting web based application using .Net MVC
Created prototype and production-level object-oriented applications throughout software development lifecycle, including design, modeling, coding, testing, and documentation.
Analyzed business, functional, and technical requirements to make sure project met expectations.
Troubleshoot and resolved bugs in .NET applications to ensure optimal development environment.
Designed Search box (autofill) like custom controls by using web services interact with database to fulfill the auto complete functionality.
Designed user interactive popup's using jQuery and Ajax
Utilized Http requests to authenticate users to access resources based on their role registered in a table.
Designed and developed Business/Data layers using C#, Web Services (XML/SOAP)
Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures
Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS).
Scheduled packages in AutoSys/Integration Services (SQL Agent)
Created SSIS packages using SSIS Designer for export heterogeneous data from ODBC source Teradata, Excel spreadsheets and flat files to SQL server 2008 R2/2012.
Used ETL (SSIS) to extract data from SharePoint server list (OData Source, SharePointListAdapter -Codeplex) to SQL server tables and reconcile data with WDM (business data-Teradata) and upload reconciled data to SharePoint Server
Scheduled all SSIS packages under SQL server agent to import, export and profiling data periodically
Experienced in Azure cloud deployment
Configure SharePoint List to render the SSRS reports
Environment: .NET Framework 2.0/3.5/4.0, C#, VB.NET, ASP.NET, MVC, EF, JQuery, JavaScript, Windows 2008, MS SQL Server 2008 R2/2012/2014, SQL Integration Services(SSIS), SSRS, Business Intelligence Development Studio, Visual Studio 2008/2010/2013 and Teradata
Performs
(Client: Atlanta CDC – Atlanta GA)
Framework 3.5, ASP.Net, C#, MVC, JQuery, WCF, XML, Ajax, TFS and SQL Server 2008, SSRS
The BP2 template below includes all of the data indicators within the two program measures of BP2 implementation guide and the healthcare coalition (HCC) developmental assessment factors also it includes additional data related to exercises, budget, training, Emergency System for Advance Registration of Volunteer Health Professionals (ESAR-VHP), or facilities. This includes HCC name, point of contact information, and member information. This data will be populated from the BP1 EOY template and will be available for modify. It includes all of the HCC program indicators and HCC developmental assessment factors.
Role: Sr. Developer
Responsibilities:
Involved the project from Initiation through the implementation
Involved all wireframe meetings and documenting the business requirement
Prepared the FRs(functional requirement)
Involved creating prototypes and POC (proof of concept).
Database designing and implementing for SQL Server queries, tables, stored procedures, triggers in Connected and Disconnected mode of ADO.NET
Conduct code review and validated the design standards & functionality
I have developed Google search box (autofill) like custom controls by using web services interact with database to fulfill the auto complete functionality.
Designed user interactive popup's using jQuery and Ajax
Automated the process of extract data from excel and populated in production db.
Interacting with QA team and reviewed test cases
System testing, UAT support and Production Support
Prepared SQL server script for System, UAT and production deployment
Prepared production deployment document and backup plan
Developing reports using SSRS.
GlobalCom
(Client: SIRVA, USA Chicago/India)
ASP.Net, C#, MVC, JQuery, WCF, XML, Ajax and SQL Server 2008, VS 2010
A single global view of SIRVA’s moving services information and shipments. Globalcom consists of a set of connected systems, a central engine and repository, and a public facing user interface. The connected systems are linked to Globalcom via a defined set of XML transactions. These transactions are the basis for all shipment communication and will be discussed in detail. All updates into and out of Globalcom occur via these XML transactions.
Role: Project Lead
Responsibilities:
Involved the project from Initiation through the implementation
Coordinate with the onsite customer and offshore development team and supporting the existing product enhancements Coordinate with the onsite customer and offshore development team and supporting the existing product enhancements
Developed web pages using ASP.Net /HTML 5 and Knockout js
Creating Interfaces for WCF services to communicate between DAL and other business components.
Designed and developed Business/Data layers using C#, Entity Framework and Web Services (XML/SOAP), WCF
Database designing and implementing for SQL Server queries, tables, stored procedures, triggers in Connected and Disconnected mode of ADO.NET
Developed windows service components to interact with other applications
Used XML as data transfer mechanism between COM and web pages
Periodic Status report to client manager including the Risks & Mitigation Plan
Managed & Mentor offshore team, helped the team with Design Standards, Coding, & Troubleshooting
Conduct code review and validated the design standards & functionality
Created project plan using MS Project
System testing, UAT support and Production Support
Production deployment and setup creation using MSI
Prepared SQL server script for System, UAT and production deployment
Prepared production deployment document and backup plan
ProMove
(Client: SIRVA, USA – Chicago/India)
C#, winforms, CAB, XML, SSRS, SSIS and SQL Server 2005
ProMove is an operational system for shipment management, freight forwarding, and warehouse/crew/vehicle scheduling and tracking. ProMove’s tracks shipment phase through enquiry, booking, assigning equipment and crew, storage/SIT, and invoicing. It has a built-in interface with Sun financials for sending estimated costs and deferred revenue to Sun. Additionally, a one-way view exists from Sun into PM which shows actual costs in Sun to estimated costs in ProMove. It is a standalone windows forms application which provides user friendly interfaces and work flow related actions. ProMove users access their customized reports over the web which is developed by using MS SSRS tools.
Role: Team Lead
Responsibilities:
Conducted meeting with Business Team & Gathered Requirement
Analyzed the functional requirements and convert into technical specifications
Impact Analysis of the Change Request
Mentor the offshore team in Process, Design & Coding Standards
Managed the team and helped them in resolving the issues faced
Defined WPF application architecture with regards to the presentation layer provided coding standards, demonstrated best practices and approaches to WPF implementation
Creating Interfaces for WCF to communicate between DAL and other business components
Designed and developed Business/Data layers using C#, ADO.Net and Web Services (XML/SOAP), WCF
Developed Listener component using multithreading.
Conduct code review and validated the Process & design standards were followed
Developed User interfaces and service layers
Database designing and implementing for SQL Server queries, tables, stored procedures, triggers in Connected and Disconnected mode of ADO.NET
Developed reports using MS SQL reporting Service (SSRS)
Used XML as data transfer mechanism between components
Reviewed the Unit & Integrations test plans and Test Cases
System testing, UAT support and Production Support
Periodic Status report to client manager including the Risks & Mitigation Plan
Production deployment
Order Capturing
(Client: Hawaiian Telecom - India)
ASP.NET, VB.NET XML, JavaScript, SQL Server 2000
Hawaiian Telecom – Order capture project was developed for capturing the order information which would be entered by the Service representatives.
Hawaiian Telecom is led local phone service; they provide wide spectrum of other services including long distance, high-speed internet, wireless services, and print directory and internet directory services. The current solution being used as part of this project would help HT to have a completely web based process for capture the orders and populated the data to billing servers.
Role: Sr. Software Engineer
Responsibilities:
Requirement gathering analysis and end user meetings.
Converting functional requirements into technical specifications
Developed web pages using ASP.Net or developing components using VB.Net
Developed client side scripting using Java Script
Done code review and involved process related activities
System testing, UAT support and Production Support
Status report to client manager and Project manager
Golfer/Gobra
(Client: SGTS - India)
ASP, PHP, JavaScript, IIS, Oracle
Sony Global Treasury Services (SGTS) SGTS was established and positioned as a shared service center for all the operating companies (Opcos) handling their finance, treasury and banking activities across the entire group, as well as coordinating financial risk management services for the group companies worldwide.
Role: System Engineer / Developer
Responsibilities:
Developed client side script to validate UI controls using Java Script
Responsible taking care of Sev2 and Sev3 level support and bug fixing
Done Unit testing and deployed components in both system test and UAT server
Done code review and involved process related activities
Production Support
The Pulse (Service Catalogue)
(Client: Aviva Life Insurance - India)
ASP, VB, COM, HTML, XML, JavaScript, SQL Server 2000
The NUCS service Catalogue provides a list of services provided by NUCS and any critical information associated with the service, which helps customer and the NUCS business in general. NUCS Online is the individual end user (customer) of NUCS services there is an opportunity to move towards an effective portal into NUCS services which will be bolstered by the provision of a readily available catalogue of NUCS services and any critical information associated with them that the customer may require reference to. System has two types of users namely application users and administrative users.
Role: Developer
Responsibilities:
Developed client side script to validate UI controls using Java Script
Responsible for design and developing web pages and components
Done Unit testing and deployed components in both system test and UAT server
Online Travel Booking Portal
(Client: P2P Travel Pte Limited Singapore - India)
ASP.NET, VB.NET, ADO.NET, Web Services, XML, HTML,
JavaScript, SQL Server 2000
Release 1.0: 6 Months
Release 2.0: 4 Months
P2P is an easy-to-use dynamic portal website which helps travelers to book hotels, flights and tours online. Modules include Hotels, Tours, Booking, Air ticket, Customers and Vendors. The Administration module allows the travel manager or travel agency to define corporate policy that is applied during the booking process, ensuring policy compliance. The GUI was developed using HTML and ASP.
In this portal, registered users can know the status and availability of tickets. Along with this the users can browse through the tariffs of hotels available around the globe. The whole application can be customized by the administrator by using the administrator module. This enables them to post the latest news in travel market and different packages/deals available with them.
Role: Developer
Responsibilities:
Developed client side script to validate UI controls using Java Script
Responsible for design and developing web pages and components
Done Unit testing and deployed components in both system test and UAT server
Involved in production build deployment
involved Bug fixing and integration testing
Developed all reports using Crystal Report
P2P Travel Booking Management Application
(Client: P2P Travel Pte Limited, Singapore - India)
VB.NET, Ado.NET, XML SQL SERVER 7.0
Duration: 7 Months
As a Team member in this Travel Management Solution, this is a customized project, done to a leading Travel Agency in Singapore. This is a network application, which enables the users to make booking entries. This also includes Customer and Vendor Modules; these modules help to maintain the customer and vendor database in an effective manner. There is also a separate module wherein users key in the flight, hotel details and customized tour packages. The export tool in this module, exports the flight rates and hotel rates to the customers. This export list is automatically attached an email and send it to the corresponding customer. This application includes various report generations like Invoice, Receipt and Exchange orders.
Role: Developer
Responsibilities:
design vb forms UI
coding and unit testing
creating installing package using install shield
involved Bug fixing and involved in production build deployment
BizzAnywhere – Online Trading Package
(Client: Profinman Services Pte Limited, Singapore - India)
VISUAL BASIC 6, COM, ActiveX, ASP, SQL SERVER 7.0
Release 1.0: 6 Months
Release 2.0: 4 Months
The Project is a DIY model, which allows its users the independence to set their own web server and database server. After configuring these SME running this application can upload all their product and company information and go online within hours. The web based customers can order from their website and the suppliers can supply their consignment according to SME’s requirements. The project includes the module for its employees to post and fix their appointments, status reports & accounts information through web from any location.
Role: Developer
Responsibilities:
design vb forms, coding and unit testing
creating installing package using install shield
Involved in production build deployment and involved Bug fixing
Defect Tracking System
(Client: Presidency Systems Inc., USA)
Visual Basic 6, ADO, COM, ActiveX, Crystal Report and SQL Server
This client server application is used for Defect Tracking of PSI Groups Singapore. The project is a part of software engineering modules and fits in the Quality Assurance. Once developed projects by the software companies are given to a testing team, the team uses DTS to register all the defects/errors. DTS contains information about the team and users who developed it and alerts the appropriate user. This would help the team in reducing the time taken to resolve a problem by providing the facility to log problems faced and their solutions, in a standard format.
Role: Developer
Responsibilities:
design vb forms, coding and unit testing
creating installing package using install shield
Involved in production build deployment and involved Bug fixing
Growth Science Patients Registry
(Client: Serono Inc., - India)
Visual Basic 6, ADO, COM, Data Report, SQL Server VS6.0
The application is used for entering medical information from patients across their registered hospitals from USA and Europe, and sends them to the APT Server. APT server collects all this medical information and uses them for research. GSPR also maintains its numerous users and registered hospitals across the world.
Role: Developer
Responsibilities:
design vb forms, coding and unit testing
creating installing package using install shield
Involved in production build deployment
involved Bug fixing
Inventory and Workshop Management
(Client: K.M.O.M Sdn Bhd, KL, Malaysia - India)
Visual Basic, COM, ActiveX, SQL Server 2000, Crystal Reports
This project encompasses point-of-sale system. The task is to control and administer their outlets at various places in Malaysia and Singapore. Role included System Study, Time Cost Estimation, Project Schedule and Resource Allocation, Design and Development of Forms, Modules and Reports, Testing & Implementation, knowledge transfer to in-house support team.
Role: Developer
Responsibilities:
design vb forms, coding and unit testing
creating installing package using install shield
Involved in production build deployment
involved Bug fixing
License Manager
(Client: The Outfit, New Zealand - India)
ASP, VBScript, HTML, JavaScript, SQL Server 2000, VS 2003
The main objective of License Manager is to build a web based License Key Management. This web-based component is used to manage the products & customers of The Outfit. The web component creates a CDKey of a product, which will be used by the customers for installing it. It also has a native java tool kit, which will be packed with every product for installation. The user will enter the CDKey, which will be checked against the remote database during the installation. This process helps The Outfit to avoid any malpractices against the products.
Role: Developer/Trainee
Responsibilities:
design ASP web pages and validating user inputs using java script
coding and unit testing
creating installing package using install shield
Involved in production build deployment
involved Bug fixing
Contact this candidate