Sql Server Software Engineer
Resume:
Himanshu Patel
********@*******.***
Lake Worth, FL-33463 Phone: 561-***-**** (C)
OBJECTIVE
To obtain a challenging position utilizing Software Engineering and
management skills involving with databases, servers, and maintenance
services for web development and enterprise management applications.
SUMMARY OF QUALIFICATIONS
Results oriented software developer and team leader with extensive domain
experience in web technologies, e-commerce, customer relationship
management system (CRM), telecom service, management processes, and billing
services. An experienced in developing, integrating and customizing
strategic information with ERP systems for entire life-cycle process. A
self-starter and committed team leader that can prioritize and work on
multiple tasks with minimal supervision. Also, experienced in providing 24
by 7 technical supports and managing other developers.
PROFESSIONAL EXPERIENCE
Citrix Systems, Fort Lauderdale, FL Aug'11
- till date
Senior Software Engineer (Contract)
SQL Server 2012, ASP.net 3.5, VB.net, VB, Macros, XML, SSIS, Scrum
. Obtained customer requirement and created technical system
requirements documents along with high level designed documents and
prepare unit test script.
. Created project plan and assigned the tasks to other developer and
tester.
. Lead the development efforts for complex projects involving multiple
teams
. Trained the other developers with business rules and system
architecture.
. Communicated and provided the project progress brief and status update
to upper management.
. Created stored procedures and custom scripts for various data
manipulation using SQL server 2012 and SSIS.
. Created and supported various VB Macros applications to support
various Sales and Marketing applications to import and manipulate
leads data.
. Supported and maintained various VB and .net applications that
transfer data from Vantive to SAP and other various other web
applications.
. Used SCRUM/Agile Methodology for development and co-ordination among
various teams like Biztalk, SAP, Web, SalesForce and DBA.
PCSecurityShield/Stopzilla, Delray Beach, FL
Sept'07- Aug'11
Team Manager/Senior Software Developer
SQL Server 2005/2008, ASP.net 2.0/3.5, C#, MVC, SEO, e-commerce, Ajax
. Developed and maintained an IT organizational structure that supports
the needs of the business.
. Developed the strategic cost-effective investment of financial
resources in IT systems and resources, including staffing, sourcing
and purchasing.
. Developed various windows application, web sites (PCSecurityShield,
StarReviews), and windows services and enhanced them with new features
and SEO friendly using Asp.net 2.0/3.5 with C# and MVC.
. Converted existing web services to WCF services.
. Maintained and enhanced existing integration of sites with PayPal,
VeriSign, and USA E-pay using their web service API.
. Build affiliate tracking program for marketing and lead conversion
ratio count using pixel using C# and SQL server 2005/2008.
. Managed and mentor developers with their coding using SCRUM/Agile
Methodology.
. Created Language specific user experience of E-commerce platform.
. Created Various Reports functions using ADO.net and Reporting
Services.
. Created data access Layer (dll) using C#.
. Used to for custom confirmation page XSLT.
. Handing day to day issues directly with affiliate marketing companies,
PPC and vendors.
. Integrating orders generated by third party to the system via http
post and xml files.
. Build the email marketing system with Bluehornet that automatically
send email to customer regarding their subscription renewal.
. Configured IIS 6.0 for optimized result and redirecting dead links.
. Ensured site is secure using SSL, hackersafe, IP2Location, and other
tools.
. Created various database Queries, Views, Tables, Stored Procedures,
and Functions.
. Performed Database backup and restore and Database tuning.
. Used Jquery and Ajax to increase the performance of site.
. Used SVN for source code controls for all the sites.
. Build Captcha function for providing extra security to the site.
. Used Visual Build Pro to created automated deployment of site.
Citrix Systems, Fort Lauderdale, FL Aug'06
- Sept'07
Senior Software Engineer (Contract)
SQL Server 2000, ASP.net 1.1, VB.net, VB, Macros, Vantie, XML
. Created stored procedures and custom scripts for various data
manipulation using SQL server 2000.
. Designed VB.net windows commands line application to generate XML file
on demand to push it automatically to Sales Force application.
. Created and supported various VB Macros applications to support
various Sales and Marketing applications to import and manipulate
leads data.
. Supported and maintained various VB and .net applications that
transfer data from Vantive to SAP and other Various other web
applications.
. Supported various custom email programs to generate automatic emails
based on custom email templates and send it to customer and sales
partner based on update on records.
. Optimized the existing stored procedure and programs using SQL Server
2000 Manager.
. Created various Queries, Views, Tables, Stored Procedures, and
Functions.
Bluegreen, Boca Raton, FL
Oct'04 - Aug'06
Software Developer
SQL Server 2000, Crystal Report, ASP.net 1.1, C#, Sharepoint, VB.net,
Reporting Services
. Created stored procedures and packages to manipulate production data
based on business need in the SQL Server 2000.
. Created custom crystal reports for client needs using Reporting
Services and SQL Server 2000.
. Created spooler and sharepoint application designed in .net
environment.
. Created project plan and database schema for the entire SalesLogix
application upgrade.
. Trained other developers on the Bluegreen applications to support,
enhance, and maintain existing applications.
. Analyzed and optimized the existing database and existing crystal
reports.
. Created Lead Realignment application in vb.net
. Created various Queries, Views, Tables, Stored Procedures, and
Functions.
. Performed Database backup and restore and Database tuning.
. Converted existing crystal reports into Reporting Services.
. Ensured that the team complained with Sarbanes Oxley.
Motorola, Plantation, FL
April'04-Oct'04
Software engineer (Contract)
GSM AT commands, Windows CE platform, ASP, Access, Clear case
. Designed and Developed test cases for GSM based Smart phone.
. Developed script for automated test execution.
. By following configuration management standard review, merge and
submit the source scripts and document in clear case.
. Upgraded the various cell phone on the latest load.
. Designed and updated department webpage using ASP.
MyDocOnline (Cybear, Inc.) Boca Raton, FL
May'03-Jan'04
Software Developer/Web Developer (Contract)
VB, ASP, ASP.net 1.0, C#, SQL Server, XML, Crystal Report, MFC, COM,
COM+, HL7
. Designed and Developed Dr. Chart, web product using XML and HL7
messaging system to process physicians' critical information for
health care system in C#, Asp.net and VB.
. Developed Application that exchanges the HL7 formatted data
(electronic records) and parses it in database for physician's review.
. Developed various custom Crystal Reports.
. Created store procedures for efficient use of database resources and
security.
. Converted existing ASP files into ASP.net version.
. Supported to End-to-end analysis of web products including regression
testing.
. Configuration controlled for the exiting code and documents under
source safe.
. Created various Queries, Triggers, Views, Tables, Stored Procedures,
and Functions
SIEMENS Information & Communication Networks(ICN), Boca Raton,FL Jan'01-
Mar'03
Software Integrator
C, C++, Java, ASP, Shell, SQL, PL/SQL, XML, Vitria, Singl.eView, TBS, OSS,
Perl
. Designed, Developed and Configured billing software Singl.eView and
Middle Ware's software using Java, C++, C, CORBA, and XML.
. Performed end to end analysis, testing, and maintenance of SieBOSS OSS
products.
. Built and released production builds using Configuration Management
Tools.
. Provided 24 by 7 Customer Support using Remedy system and troubleshot
problems.
. Participated in Training Sessions and used ISO-9000 for better quality
of Software.
. Developed PERL & Shell scripts to clean log files with connections of
multiple databases.
. Created Queries, Triggers, Views, Procedures, and Functions for
Singl.eView Test Support and Development using SQL and PL/SQL.
. Tested Flow through Activation software for VoIP product.
. Archived the Call detail records and processed call detail records
through billing software.
. Generated orders, and Configured products, gateway events in MetaSolv
application.
. Demonstrated SieBOSS products to the customers to facilitate sales.
SIEMENS ICN, Boca Raton, FL Jan'00-
May'00 & Aug'00-Dec'00
Software Engineer (Internship)
Visual Basic, Java, ASP, HTML, Rational Rose, ClearCase
. Implemented an application using Java to make an existing tool
platform independent.
. Redesigned "Error Log Tool" using mechanism of "Reverse Engineering"
in Visual Basic.
. Worked on configuration control for sources and documents using Clear
Case.
Florida Atlantic University, Boca Raton, FL
May' 00-Aug'00
Web Developer
ASP, HTML, JavaScript, VB Script, and MS Access
. Designed web site for CVSI (Center for VLSI and Systems Integration)
Lab to help students to get information for VLSI and research
materials
SKILLS
SKILL NAME SKILL DESCRIPTION
Programming C#, VB.Net, Visual Basic, JAVA, Visual C++ (MFC), C,
Languages C++, Shell Scripting, Perl Script, Motorola 68000
Assembly, FORTRAN, Lisp
Web Development ASP, ASP.Net, XML, HTML, Web Logic (BEA), JavaScript,
VB Script, Jquery, Ajax, J2EE, Web Services, SOAP,
Sharepoint
Database SQL, Oracle, PL/SQL, Embedded SQL (ProC), MS Access,
Applications Toad
Other Applications Visual Studio, Visual Interdev, Visual Caf,
JBuilder, FrontPage, Rational Rose, ClearCase,
MetaSolv (CRM), Singl.eView (Billing-ERP), Vitria
BusinessWare (EAI), Tuxedo, Flash, Dream Weaver
Operating Systems UNIX, Windows 95/98/NT/2000/XP/2003/Vista
Certification Oracle Certified Professional's first exam (IZ0-001,
Introduction to SQL and PL/SQL)
EDUCATION
. Bachelor of Computer Science at Florida Atlantic University (FAU), Boca
Raton, FL.
. Completed Accounting, Finance, and Marketing credits for Business
Practice at FAU.
Contact this candidate