Sql Server Service
Resume:
Sumit Rawani
Summary:
Microsoft Certified Technology Specialist with 10+ year’s experience in Design, Architecture, Development, testing and maintenance of Client-Server/Internet/Intranet Systems using Microsoft technologies.
Experience in Software Development Life Cycle (SDLC) .Proficient in different Software development methodologies including Iterative, Prototyping and Agile Scrum Methodologies.
Extensive experience in developing applications using .NET Framework (4.5/4.0/3.5/3.0/2.0/1.1), Visual Studio .NET, C#, ASP, ASP.NET, MVC, VB.NET, AJAX, AngularJS, LINQ, WCF, WPF, Web Services and Win Forms.
Extensively used web development tools such as HTML, Java Script, XML
technologies (XML, XSL, XSLT), AngularJS and AJAX.
Hands on experience in Service Oriented Architecture (SOA) and developing and consuming of WCF (Windows Communication Foundation) services.
Experience in State machine and Sequential workflows to satisfy business requirements using Windows Workflow Foundation (WF).
Implemented Workflow Tracking and Workflow persistence services utilizing Windows Workflow Foundation (WF).
Experience in Database Design (Erwin), Design Patterns (MVC, Singleton, Abstract Factory, Prototype), UML tools (Rational Rose, MS Visio), Object Oriented Programming (OOP), Object Oriented Analysis & Design (OOAD)
Strong experience in design and development of databases like SQL Server 2000/2005/2008/2014, Oracle 9 and MS Access. Hands on experience in writing complex, Stored procedures, Triggers, Functions, Views,
Experience with SQL Packages using SSIS, generated reports using SSRS.
Implemented Unit Testing and Integration testing during the projects
Excellent analytical, problem solving and interpersonal skills. Ability to learn new concepts fast. Consistent team player with excellent communication skills.
TECHNICAL SKILLS
Languages C#, VB.Net, XAML
Databases MS SQL Server 2000/2005/2014, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS).
Operating Systems Windows 2000, Windows NT/XP, Windows 7
Tools/Software Visual Studio 2005/2008/2012/2013, UML, CruiseControl, FxCorp, NUnit
Web Technologies ASP.Net, MVC, AngularJS, Silverlight, SharePoint, Ajax, Windows Workflow Foundation (WF).
Scripting Languages JavaScript
Windows Technologies Windows Presentation Foundation (WPF)
Web Services Web Service, Windows Communication Foundation (WCF)
Data Access Technologies ADO.Net, LINQ, NHibernate.
Application/Web Server Internet Information Server 6(IIS)
Version Control System Visual SourceSafe (VSS), TFS
Protocols HTTP, HTTPS (HTTP+SSL)
Design Patterns
CERTIFICATIONS
Microsoft Certified Professional for .Net Framework 2.0
Microsoft Certified Technology Specialist for .Net Framework 3.5 ASP.Net Application
Microsoft Certified Technology Specialist for .Net Framework 3.5 Windows Communication Foundation (WCF)
EDUCATION
Bachelor of Engineering in Information Technology, Pune University.
ACHIEVEMENTS
Received an award as “Monthly achiever for outstanding contribution to the Firm” at Quinnox Consultancy Services Ltd.
Secured Prizes at Concepts (An National Level Inter-college annual Competition)
EXPERIENCE
4-D Security Solutions Inc, NJ Apr’10 – Till Date
Principal Software Engineer
Project: ReadyMind
ReadyMind is designed to provide preparedness and response tools fr organizations responsible for disasters and mega-eventshandling.
Roles & Responsibilities:
Studied the entire application management process, procedure, identifying areas for improvement, and implemented N-tier Application architecture and process flow.
Studying the existing operational process, defining detailed scope of the Engagement and the service level agreements.
Involved in creating Work Breakdown Structure (WBS)
Managing the Feature (timeline, work distribution, completion tracking and reporting)
Based on SRS document, performed Class and Database design.
Allocated functional & technical work specs to the development team.
Used log4net for error logging.
C# was used as the Code Behind for the applications.
Implemented MVC design pattern for developing the Web Application
Used AngularJS as the development framework to build the application
Made extensive use of promises in AgularJS for application control flow
Created custom directives for re-usable components
Created Windows Services for background processing.
Used Azure Service Bus to send messages between Web Application and Windows Service.
Used AppFabric for caching purpose
Responsible in maintaining the .Net source code Using TFS as a version control system.
Created tables, functions, stored procedures, UDF in the MS SQL Server Database.
Environment: ASP.Net, MVC 4, Angular JS, C#, AppFabric, Azure Service Bus, Log4net, Microsoft Visual Studio 2013, Microsoft SQL Server 2014, TFS.
Project: Wisdom
Wisdom is an open architecture comprehensive multiple source geo-spatial command and control system back-bone spanning the PSIM and C4IS markets.
Roles & Responsibilities:
Studied the entire application management process, procedure, identifying areas for improvement, and implemented N-tier Application architecture and process flow.
Studying the existing operational process, defining detailed scope of the Engagement and the service level agreements.
Involved in creating Work Breakdown Structure (WBS)
Managing the Feature (timeline, work distribution, completion tracking and reporting)
Based on SRS document, performed Class and Database design.
Allocated functional & technical work specs to the development team.
Used NHibernate for the Data Access components.
Used log4net for error logging.
Implemented multithreading and used asynchronous operations extensively.
C# was used as the Code Behind for the applications.
Developed WCF services which had Contract, Services, Host using SOA i.e. Service Oriented Architecture.
Used Windows Communication Foundation (WCF) for creating service components.
Responsible in maintaining the .Net source code Using TFS as a version control system.
Environment: Windows Presentation Framework (WPF), C#, SQL Server, Windows Communication Foundation (WCF), NHibernate, LINQ to Object, Log4net, Microsoft Visual Studio 2010, TFS.
ZSL Inc, NJ Nov’08 – Apr’10
Lead Developer
Bowne, Parsippany NJ
Lead Developer
Project: SolutionWorks
SolutionWorks is an integrated content management and document ordering suite that gives an unprecedented ability to create, manage and deliver multi-channel communications.
Roles & Responsibilities:
Studied the entire application management process, procedure, identifying areas for improvement, and implemented N-tier Application architecture and process flow.
Studying the existing operational process, defining detailed scope of the Engagement and the service level agreements.
Based on SRS document, performed Class and Database design in Visio.
Allocated functional & technical work specs to the development team.
Used Data Access Application Blocks for the Data Access components.
Used log4net for error logging.
Client site validations were handled through JavaScript.
C# was used as the Code Behind for the applications.
Developed WCF services which had Contract, Services, Host using SOA i.e. Service Oriented Architecture.
Used Windows Communication Foundation (WCF) for creating service components.
Created Windows Services for background processing.
Implemented multi-threading in windows service to load dll’s in a multi-threaded environment.
Used Windows Workflow for Date Re-engineering (DRE) module.
Responsible in maintaining the .Net source code Using VSS as a version control system.
Created tables, functions, stored procedures, UDF in the MS SQL Server Database.
Environment: Asp.net 3.5, C#, SQL Server 2008, Windows Communication Foundation (WCF), Windows Workflow Foundation (WF), Windows Service, Multi-threading, LINQ to Object, Data Application Blocks (Enterprise Library 4.1), Log4net, Microsoft Office Visio for Enterprise Architect, Microsoft Visual Studio 2008, Visual SourceSafe (VSS).
Hewlett Packard (HP), New Providence NJ
Lead Developer
Project: Flexi
HPFS (Hewlett Packard Financial Services) is the financial arm of HP and offers a complete array of leasing and financial lifecycle management services in over 40 countries around the world.
Following are the project(s)/modules which I have worked:
Flexi2LHGL-Its up gradation project as currently HPFS feeds Lighthouse (LH) via a Microsoft Access database. (Flexi2LHGL.mdb).The Flexi2LHGL.mdb database is currently located on a single PC and the Flexi2LGHL database is not an IT supported solutions and does not conform to business continuity standards. Create new Interface using Portlet and migrate the existing MS access database to sql server 2008. The current functionality includes where fiscal year-to-date balances are extracted from Flexi into an Access database (Flexi2LHGL). The Flexi2LHGL database contains the necessary mapping tables and submission logic to map HPFS Flexi data elements to HP Lighthouse GL data standards. In addition to mapping HPFS Flexi GL data, the Flexi2LHGL database outputs a file in the correct file layout for submission to the HP TE (interface between legacy systems and LHGL) via the HP service bus (HPSB).
Guard – Centralized security user for granting permissions to users, roles (Collector, Tax analyst, Support Team, Coordinator) and teams.
Roles & Responsibilities:
Studied the entire application management process, procedure, identifying areas for improvement, and implemented N-tier Application architecture and process flow.
Studying the existing operational process, defining detailed scope of the Engagement and the service level agreements.
Based on SRS document, performed Object oriented design in UML.
C#.Net was used as the Code Behind for the applications.
Identified, Defined and Scheduled priorities in consultation with the client.
Used Aqua Logic for creating portlets for user interface.
Create acceptance test cases using Fitnesse.
Generate XML & Excel files for finanace system using Aspose.
Manage bugs and enhancements using HP Quality Center, manage source code in Star Team
Environment: Windows 2003 Server, Microsoft Visual Studio 2008, Asp.net, C#, SQL Server 2008, Star Team, Quality Center, BEA Aqua logic, Plum Tree Portlets, Aspose component, CaliberRM.
Department Of Correction, PA
Team Lead/Developer
Project: Office of Victim Advocate (OVA)
The OVA business process can be broadly classified into the following categories which fall under DOC and PBPP business perspective
OVAMS DOC
Registration of victim
Pre release notifications to registered victims
To keep victims notified
To notify victim and to collect inputs
Various services to registered victims
OVAMS PBPP
Pre parole notifications to registered victims for victim input
Various services to registered victims
Services Tracking
Review of how OVA services for both DOC and PBPP will be tracked and information recorded.
Roles & Responsibilities:
Studied the entire application management process, procedure, identifying areas for improvement, and implemented N-tier Application architecture and process flow.
Studying the existing operational process, defining detailed scope of the Engagement and the service level agreements.
Used Data Access Application Blocks for the Data Access components.
Client site validations were handled through JavaScript.
VB.Net was used as the Code Behind for the applications.
Based on SRS document, performed Object oriented design in UML.
Allocated functional & technical work specs to the development team.
Designed user friendly presentation Layer using ASP.NET/AJAX controls.
Involved in creating reports using SSRS.
Identified, Defined and Scheduled priorities in consultation with the client.
Provided extended security and configuration by using Remoting.
Organized strategy meeting and periodical business meeting.
Established and monitored the processes for Issue Management, Change Management and Quality management.
Created custom components with design patterns and practice guidelines for Dot Net.
Acquired, transferred knowledge and mentored the team.
Environment: ASP.NET 3.5, VB.Net, SQL Server 2005, SSRS, JavaScript, AJAX, Enterprise Library 4.1, Remoting, Visual Studio 2008, Windows Vista.
Novartis, NJ
Project: SalesRxcelerator
This is a web-based application for Pharmaceutical companies and Managed Care Organizations. SalesRxcelerator is mainly designed to provide a single platform to enable the digital aggregation of marketing materials, key ordering processes and feedback communication to help pharmaceutical companies and their field sales organization improve upon the day-to-day performance of providing timely and up-to-date educational and marketing materials, informing healthcare professionals about approved scientific and formulary events for the purpose of driving increases in revenue through increases in prescriptions.
Roles & Responsibilities:
Participated in Business requirement and Functional Specification document analysis meetings.
Involved in Complete SDLC, detailed design, data design, coding, testing and creation of functional and technical documentation.
Studied the entire application management process, procedure, identifying areas for improvement, and implemented solutions.
Involved in Agile/Scrum methodology process.
Implemented Model View Controller (MVC) Patterns and Practices – Data Access Application Blocks to incorporate standard database functionality in the application.
Have been responsible for designing and finalizing the User Interfaces and functional specifications of the system.
Designed and developed Web Forms using C# and created necessary classes in the biz components.
Created C# components to upload feeds (comma separated) to the database.
Designed and implemented reusable user controls developed in ASP.Net 3.5.
Extensively used JavaScript as client side scripting and AJAX and XML in the web forms.
Used Asp.net 3.5 web controls, master pages, user and custom controls in C#.
Used AJAX methodology using JavaScript, XML & C#.
Used ADO.Net for data access, used Data Adapter, Reader, Dataset classes.
Involved in developing various reusable Helper and Utility classes, which were being used across all the modules in the application.
Developed WCF services which had Contract, Services, Host using SOA i.e. Service Oriented Architecture.
Used Windows Communication Foundation (WCF) for creating service components.
Helped to set up development processes, conducted code reviews.
Handled Run Time and Design Time Errors by implementing appropriate Error Handlers in C#.
Worked on Product Planning and Prototyping.
Created tables, functions, stored procedures, UDF in the MS SQL Database.
Generated and designed reports using SQL Server Reporting Services (SSRS).
Environment : ASP.Net 3.5, C#, MVC, WCF, SSRS, NUnit, TDD, XAML, AJAX, SQL Server 2005, Visual Studio 2008, Javascript, HTML, IIS 6.0.
Quinnox Consultancy Services Ltd., India Feb’07 - Oct’08
Team Lead/Lead Developer
Occam,
Project: Occam Zebra
Occam is a data management company. Occam started from cleaning basic document data and now has large number for big clients to whom they provide service. Now Occam is developing a generalized application to provide data management for its clients.
Roles & Responsibilities:
Involved in all the phases of SDLC from Software Requirements Phase to Design, Implementation, testing, debugging and Documentation Detailed understanding of the MVP architecture.
Understanding of XAML, WPF and WCF.
C# was used as the Code Behind for the applications.
Understanding the User Authorization and other Windows features to be integrated in the application
Created and deployed Windows Communication Foundation (WCF) Services.
Consumed Windows Communication Foundation (WCF) Services from web applications.
Responsible in maintaining the .Net source code Using VSS as a version control system.
Developed complex parts of the module.
Was involved in creation of Program specification, Unit Test plans, code reviews.
Developed WCF Service
Created stored procedures, functions and Views in the SQL Server Database.
Involved in deployment and maintenance support for the project at client side.
Was involved in creation of Program specification, Unit Test plans, code reviews.
Environment: .Net Framework 3.0, C#.Net, XAML, Windows Presentation Framework (WPF), Microsoft Management Console (MMC), Powershell, WCF, MS SQL Server 2005, Visual Studio 2005, Visual SourceSafe (VSS), IIS, Windows XP, ADO.Net.
RandStad
Project: HRS
Randstad is the world’s third largest organization that provides recruitment and HR services to its customers. One of their divisions provides HR Services for contract workers (candidates) in universities and fixed term contract workers for companies.
The application focuses on matching a candidate to the student based on student’s academic needs and capturing candidate timesheets monthly basis which would be sent for Payroll and Invoicing.
Roles & Responsibilities:
Involved in all the phases of SDLC from Software Requirements Phase to Design, Implementation, testing, debugging and Documentation.
Understand the client requirement and translate them into technical specification.
Used Data Access Application Blocks for the Data Access components.
C# was used as the Code Behind for the applications.
Developed custom controls.
Developed complex parts of the module.
Developed SSIS packages for creating CSV files for payroll processing system.
Created and deployed Windows Communication Foundation (WCF) Services in ASP.NET.
Consumed Windows Communication Foundation (WCF) Services from web applications.
Responsible in maintaining the .Net source code Using VSS as a version control system.
Lead a team of 3 members to design and develop Student modules which involved in student registration, configuring students pay rates, funding bodies and creating timesheets which were sending for payroll processing.
Was involved in creation of Program specification, Unit Test plans, code reviews.
Created stored procedures, functions and Views in the SQL Server Database.
Client site validations were handled through JavaScript.
Followed Agile (Scrum) methodology.
Created custom components with design patterns and practice guidelines for Dot Net.
Environment: .Net Framework 3.0, Asp.Net, C#.Net, WCF, SSIS, Enterprise Library 3.1, MS SQL Server 2005, Visual Studio 2005, Visual SourceSafe (VSS), Agile, IIS, Windows XP.
ShawTrust
Project: CID (Client Information Database)
Shaw Trust is a UK based NGO providing the employment opportunities for the disables.
The goal of this system is to track the entire process of the employment of the client including the client information, training information, vacancy search suitable for them, maintain employment details, maintaining work history, employer details, etc for the trust.
Roles & Responsibilities:
Involved in all the phases of SDLC from Software Requirements Phase to Design, Implementation, testing, debugging and Documentation.
Understand the client requirement and translate them into technical specification.
Used Data Access Application Blocks for the Data Access components.
C# was used as the Code Behind for the applications.
Developed custom controls.
Developed complex parts of the module.
Developed SSIS packages for creating CSV files for payroll processing system.
Created and deployed Windows Communication Foundation (WCF) Services in ASP.NET.
Consumed Windows Communication Foundation (WCF) Services from web applications.
Responsible in maintaining the .Net source code Using VSS as a version control system.
Lead a team of 3 members to design and develop Student modules which involved in student registration, configuring students pay rates, funding bodies and creating timesheets which were sending for payroll processing.
Was involved in creation of Program specification, Unit Test plans, code reviews.
Created stored procedures, functions and Views in the SQL Server Database.
Client site validations were handled through JavaScript.
Created custom components with design patterns and practice guidelines for Dot Net.
Environment: Asp.Net 2.0, C#.Net, SSIS, Enterprise Library 3.1, MS SQL Server 2005, Visual Studio 2005, Visual SourceSafe (VSS), IIS, Windows XP.
Aditya Birla Group Ltd, India Feb’06 - Jan’07
Programmer
Chase Bank
Project I: Customer Relationship management
This Application was divided into 2 parts:
Agent application which is a user-friendly CRM application in integration with Mosaix (dialer used for outbound calling). The software features include
Automatic call handling and guiding the CSR to execute and sell a product.
Automatic agent transfer from one job to another.
Automated job linking
Callback facility to the verifier
Data management for every call
Generating reports
Verifier Application works in accordance with the Agent Application. The Data captured from the Agent Application is checked to be correct from the Verifier Application and if there is any change then the data is modified and updated in the database. This application provides correct data to the reports and also to the clients.
Roles & Responsibilities:
Involved in technical Documentation for the module.
Involved in database design.
Designed and developed Web pages using HTML, ASP.Net, C# and JavaScript.
Created stored procedures, functions and Views in the SQL Server Database.
Involved in Unit and Integration testing of the Application.
Investigating and Resolving the technical issues or user queries as team member of 24/7 support.
Environment: ASP.Net, VB.Net, ADO.Net, SQL Server 2000, Visual Studio .Net, Visual SourceSafe, IIS, Windows XP.
Client: Birla Sun Life Insurance
Project II: BSLI Tool
This is an intranet web application, which is used to monitor the quality of performance the Agents are adhering to. This application allows the users to give scores and provide comments on the quality of work the agents are putting up by providing services to the customers.
Roles & Responsibilities:
Involved in technical Documentation for the module.
Involved in database design.
Involved in Design, development of database and application using Asp.Net and C#.
Created stored procedures, functions and Views in the SQL Server Database.
Involved in Unit and Integration testing of the Application.
Involved in technical Documentation for the module.
Environment: ASP.Net, C#.Net, ADO.Net, SQL Server 2000, Visual Studio .Net, Visual SourceSafe, IIS, Windows XP.
Co-efficient software, India. August 2005 – Feb 2006
Trainee Developer
Project I: MobileLocate
This is a Web-based system developed finding the current location of the any mobile in the UK. Before locating mobile system take permission for locating them by replaying SMS to mobile locate system once mobile user replaying with ‘YES’ then system can locate his or her mobile and shows the area map where the current location of the mobile is.
Roles & Responsibilities:
Developed module to locate mobile location in map by puling map from multi-map in ASP.
Wrote JavaScript for client side validations.
Created stored procedures, functions and Views in the SQL Server Database.
Involved in Testing.
Environment: ASP, MS SQL Server 2000, HTML, Javascript
Project II: Gaming Database
This Website is a database of all the computer games all over the world. It stores all the information about the game like its genre, type, storyline, controls, creator and each every detail about the game.
Roles & Responsibilities:
Involved in database design
Developed Admin module using ASP with MS SQL Server 2000 as backend.
Wrote JavaScript for client side validations.
Created stored procedures, functions and Views in the SQL Server Database.
Involved in Testing.
Environment: ASP, MS SQL Server 2000, HTML, Javascript
Contact this candidate