Management Sql Server
Resume:
DIPAK PATEL
******.*********@*****.***
SUMMARY
Microsoft .NET Technology professional with more than 12 years of experience; seeking challenging position on passionate, motivated, productive and technically savvy firm with opportunity for ongoing learning and advancement on producing innovative solutions.
Over 12 years of experience in developing various Web and Client–Server applications using Microsoft Technologies and leading relational database management systems.
Experience estimating software development efforts based upon client functional requirements, technology environment considerations and enterprise usage characteristics.
Strong experience in .NET Framework, ASP.NET MVC, ASP.NET, C#.NET, Entity framework, Web services, WCF, WPF, ADO.NET, Visual Basic 6.0, HTML, CSS, XML, JQuery, JavaScript, COM / DCOM, MS SQL Server, Microsoft development tools, MySQL, Oracle, Bootstrap, AngularJS.
Strong Experience in SDLC including System Study, User Requirements Analysis, Design, Implementation, Testing, Deployment, Support, and Maintenance and has exposure to Agile Methodologies.
Strong Experience in SQL Server, Oracle design and development, Constraints, Indexes, Views, Stored Procedures, Cursors, Triggers, and User Defined Functions. Acquaintance using report generation tools like Crystal Reports, SSRS.
Source Code Control Systems versioning using Visual Source Safe and SVN.
Experienced in software designing with various Architectural Patterns and Design Patterns.
Experienced in leading development teams.
Excellent Communication, organizational and Interpersonal skills.
Experienced in estimation, planning and tracking development activities.
Certification
Microsoft Certified Professional (MCP)
CORE COMPETENCIES & TECHNICAL SKILLS
Languages & Front End
C#, ASP.NET MVC, ASP.NET, VB.NET,VB 6.0, HTML, JQuery, JavaScript, XML, Silverlight, XAML, PL/SQL, CSS, Bootstrap, AngularJS.
Databases
SQL Server, Oracle 9i and 11g, MySQL, MS Access
Tools
MS Visual Studio, Tortoise SVN, Team Foundation Server, Telerik MVC extension, Visio, Crystal Report, SQL Server Reporting Service (SSRS), Code Smith
Middleware
Entity Framework, Web API, WCF, Web Service, LINQ, ADO.NET, Remoting, COM, DCOM / COM+, ADO/OLEDB/ODBC, Win32 API, Active-X Controls
Project Management & Documentation
MS Project, Sandcastle
PROFESSIONAL EXPERIENCE
Tri-Force Consulting Services, Inc. Lansdale, PA September 2012 – Current
Department of US Navy, “BRACBIMS”
Sr. .Net Developer / Lead Developer
Involved in defining and implementing the architecture of the project.
Increased the usability of the system and efficiency along with speed of the different processes by converting from old legacy system to new cutting edge technology like .NET and MVC architecture.
Reduced the timeframe of generating budget book (PDF document with different page format) from 24 hours to 2 hours using the .NET and MVC architecture.
Helped team to get DoD Information Assurance Certification and Accreditation Process (DIACAP) certificate for DoD compliance. DIACAP is the United States Department of Defense (DoD) process to ensure that risk management is applied on information systems (IS).
Designed the system architecture and database to speed up the conversion process.
Implemented the Single Sign On using CAC authentication with other systems based on IBM Congnos data warehouse and reduced helpdesk service time.
Introduced Telerik Controls to the project for better MVC controls like Tree View, Grid Controls.
Involved in designing, testing and deployment.
Leading the team of developers and assisted management in estimation, planning and tracking development team activities.
Environment: ASP.NET MVC 4.0, C#.Net, Visual Studio 2012, Oracle 11g, Telerik MVC controls, JQuery, JavaScript, Entity Framework, SVN
Automated Currency Instruments, West Chester, PA January 2013 – June 2013
“ACI CASH ACCESS Solution”
.Net Consultant
Project Details: ACI's integrated cash access solutions rapidly and efficiently put cash into players' hands and keep them playing. ACI's sleek and state-of - the-art multifunctional equipment provides all standard cash access services- including ticket redemption, ATM, credit card cash advance, check cashing, and bill break- all while preserving floor space, enhancing customer recognition, and improving the player experience.
Responsibilities:
Involved in the Windows form designing, architecture designing.
Involved in Multithreading Remoting base application.
Involved in Testing, Debugging and deployment of client application.
Environment: C#.Net, Remoting, TCP/IP Protocol, Multithreading Kiosk Application, Hardware interaction with RS 232 serial port.
Jetson Specialty Marketing (Kutztown, PA) February 2012 – August 2012
“Job Management and Mail Tracking System”
JSM, PA
.NET Team Lead
Project Details: JSM is a Direct mail marketing company, so this intranet portal help them to maintain their job information, client information and all data that client send them via secure FTP. Maintain Mail.Dat files standard provided by USPS at different stage while data processing, printing and mail sending. Also upload Mail.dat to USPS site for their approval. Create Job, Kits and lots of events/questions based on Kits. Also track the Pallet and tray in the premises via Motorola scanner gun. I developed various management reports using SSRS. Track the each and every mail from submission to USPS to final delivery. Also track the pallets from logistic company. Document management and email sending for each and every updates to related users. Currently working on making scheduling for different stage of production on what date, for which operation (litho, laser, bindery, inserting) will run, row material requirement etc., It has many more features regarding mail industry operations.
Responsibilities:
Study, understand and analyse the project requirement.
Design Database, technical architecture using MVC 3.0 and Entity Framework.
Used MVC 3.0 architecture with repository pattern and C#.NET in development environment.
Used various Telerik MVC controls like MVC grid, Drop down, date picker.
Involved in Testing, Debugging and deployment.
Used windows authentication with LDAP.
Involved in designing, testing and deployment.
Leading the team of developers and assisted management in estimation, planning and tracking development team activities.
Environment: ASP.NET MVC 3.0, C#.Net, Visual Studio 2010, SQLServer 2008 R2, SSRS, Telerik MVC controls, jQuery, JavaScript, Windows Services, IIS 7
“File Sharing Platform”
Client: SmartEBook, NY-Team Lead September 2011 – January 2012
Project Details: File Sharing Platform is a website design to share the files between users. Everybody can register and based on their plan selection they can upload/download and stream the files. We are using cloud file server for storing of all files. User can manage their files. We have developed this website for different mobile browsers too like iOS and Android. Website will come according to the size of Mobile screen.
Responsibilities:
Involved in the database designing, architecture designing and Client Interaction.
Used MVC 3.0 architecture and C#.NET in development environment.
Used SQL Server 2008/R2 in database layer.
Used RackSpace as Cloud file Server.
Involved in Testing, Debugging and deployment of client application.
Leading the team of developers and assisted management in estimation, planning and tracking development team activities.
Tri-Force Consulting Services, Inc. Lansdale, PA October 2008 – September 2011
Department of US Navy, San Diego, CA
“BRACMIS”
Sr. .Net Developer/Technical Lead
Project Details: Base Realignment and Closure Management Information System designed for Department of Navy (DON) authorized personnel to view, add and manage data pertaining to the closure and realignment activity. The system mainly includes the modules regarding Budget estimation for Realign and Closure effort for different recommendations, the program management module include the milestone and disposal methods, utility, housing and job data, as well as supplementary file attached by user.
Responsibilities:
Involved in the database designing, architecture designing and Client Interaction.
Used Data Grid View, Data Sets, Data Views, and Data Adapters to extract data from the database.
Used COM+ component developed in Visual Basic.
Database migration from Oracle 9i to Oracle 11g.
Used ODP.NET for database connectivity with Oracle 9i.
Used iBatis technical architecture for better code management.
Used Ajax Control Toolkit control to provide rich presentation.
Involved in Testing, Debugging and deployment of client application.
Leading the team of developers and assisted management in estimation, planning and tracking development team activities.
Environment: C#.Net, ASP.Net, Java, J2EE, ASP, VB 6.0, COM+, ODP.NET, iBatis, Ajax Toolkit, Oracle 9i, Oracle 11g, MS Excel, Visio, MS Word, MS Power Point, HTML/XML, IIS 6.0, JavaScript, VBScript, MS Access, MS Project.
Shivam Info net Pvt. Ltd, India November 2007 – September 2008
Jet Charter Pool LLC, San Mateo, CA
“Jet Charter Pool”
Sr. Developer
oJet Charter Pool LLC (JCP) is an online networking community portal for business travelers to communicate and share the cost of jet charter.
oDue to inflated oil/gas prices and mandated security polices, travel by air has lost its appeal.
oBy employing services offered by JCP every member of our community will have to opportunity to connect with local professionals, collaborate, plan and share the cost of jet charter.
Dr. Ray Wisniewski Chiropractor, Pittsburgh, PA
“The Nutrition Answer man”
Sr. Developer
oWebsite provides facility to patients to get the consultation from the Doctor and this is free service provided by doctor.
oAlso provide the Reports to the patients and with the help of the admin panel doctor can manage all this from backend.
oDoctor gives answer to the patients, put useful information for the patients.
Environment: .NET Framework 3.0, MS SQL Server 2005 And Visual Studio 2005, HTML/XML, IIS 6.0, JavaScript.
“Customer Relationship Management”
oCustomer relationship management (CRM) is a customer-centric business strategy with the goal of maximizing profitability, revenue, and customer satisfaction.
oTechnologies that support this business purpose include the capture, storage and analysis of customer, vendor, partner, and internal process information.
oFunctions that support this business purpose include sales, marketing, customer service, and calendar activity, task Management, performance management.
Environment: C#.NET, ASP.NET 2.0, Ajax, MS SQL SERVER 2005, Web service, Reporting Service, TAPI (Telephone API), HTML/XML, IIS 6.0, JavaScript.
Gateway Techno labs, India January 2007 – October 2007
Semen System - Sweden
“MEDIAXiMiT”
Developer
oAdvertisement in Taxies, Buses and on the big screen at the pickup stands for taxies and buses for the particular time and particular place; this is the main objective of this module. There are three parts in this module.
oServer application
oClient application runs in the taxi’s computer
oWeb application for the administrative purpose.
oIn this project there are mainly two types of advertise one is continues playing and the second one is the GPS Advertise, which depends on the Longitude and Latitude of the area.
oBilling is depending upon the actual hits, means how many times advertise was shown and then according to that Invoice are generate for the particular advertiser.
oAlso the commission issues to the Taxi Company and sales person depends upon the actual hits.
oWe connect the taxies to the server through the GPRS modem.
oImplemented Web services using .net Framework 2.0 using C# as code behind.
oImplement BITS 1.5.
oImplement Microsoft Application updater block.
oImplement Lead tool for Media conversion.
oImplement Office Web Component for charting purpose.
oImplement Crystal Report for reporting purpose.
oImplement GPS.NET for taking longitude and latitude.
Environment: C#.Net, ASP.NET 2.0, Ajax, COM DLLs, MS SQL SERVER 2005, XML, Crystal Report, Lead Tool for Media Conversion, GPS.NET, BITS 1.5,Microsoft Application updater block, OWC 11, HTML/XML, IIS 6.0, JavaScript.
Sarjen Systems Pvt. Ltd., India May 2005 – Aug 2006
During this period at Sarjen Systems, Successfully handled several software development projects. Information will be provided upon request.
“PharmaNet Application”
Clients: Unichem Labs (Mumbai), Cadila Pharma, Intas Pharma (India).
Project Details: A Desktop based Sales and Distribution Application. PharmaNET is a set of Supply chain management solution, which connects the entire supply chain in order to be able to exercise Strategic Initiative to reach out to all stakeholders and improve efficiency, Inculcate discipline with Standard Operating Procedures and get accurate data to highlight non-compliance, Transparency & Control over geographically distributed supply chain operations, Use existing communication infrastructure for data transfer without compromising data integrity & security, Reduce Lead-time for market data to reach management to get competitive advantage.
Environment : Visual Basic 6.0, MS SQL SERVER 2000, XML, COM DLLs, Crystal Report 8.5, MS Office, and Outlook Express.
Mac core InfoTech Pvt. Ltd., India Feb 2003 – April 2005
During this period at Mac core InfoTech Pvt. Ltd., Successfully handled several software development projects. Information will be provided upon request.
EDUCATION
Bachelor of Engineering in Computer Science.
Contact this candidate