SUMMARY:

• Microsoft Certified Application Developer (MCAD) with 15+ years IT experience including strong programming, problem solving & analytical skills.
• . NET C onsultant with expertise & exposure to all the stages in SDLC including requirements gathering, software design, development and testing / support using Microsoft Technologies.
• Well versed with solving BIWOMM (But it works on my machine) situations
• Extensive experience with Microsoft. Net Technologies (. NET Framework 4.5/4.0, MS Visual Studio, ADO . NET , C# . NET , Windows Services, LINQ, Web Services/WCF, Enterprise Library), Entity Framework and various relational databases (MS SQL Server, Sybase, DB2, Oracle).
• Experienced handling multiple roles like, Developer, Database Designer, QA analyst & Team Leader
• Worked in both Water Fall and Agile / Scrum methodology.
• Experienced working with customers, vendors and team members
• Strong systems analysis and technical documentation skills (Business rules from old systems becomes headache with constant complaints “It worked in old system like this”). Documenting original system and making sure new system follows old rules while making new system more user acceptable
• Handled offshore teams and onsite aspects like UAT, integration, testing & production support.
• Working knowledge in configuration and version management using Visual Source Safe ( VSS ), Clear - Case , Subversion ( SVN ) and Team Foundation Server ( TFS 2008/2010 )
• Managed extensions for C++, VC++ with COM/DCOM, XML/SOAP, COM+, ATL COM, and Active X Components with VC++.
• Extensively used multiple data sources and running queries across multiple sources (4gl, flat files, EDI)
• Good Knowledge in designing Use-Case diagrams , Class diagrams , Interaction diagrams ( Sequence, Activity and Collaboration diagrams ) using Designer tools like MS Visio .
• Experience in working with Business users to gather requirements.
• Expertise in writing business process documents , Technical specs and Functional documents .
• Experience in communicating with QA team , checking code coverage and supporting with white box testing needs.

TECHNICAL SKILLS:

Languages: C#, C++, VB.NET, JavaScript, VBScript

.Net Technologies: ADO.NET, ASP.Net MVC, .Net Framework 1.1-4.0, WCF, WPF, Web Services, WPF, LINQ, Entity Framework

Web Technologies: XML, HTML, DHTML, XHTML, WSDL, CSS, XSL, XSLT, JavaScriptDatabases MS-SQL Server, Sybase, DB2, MS Access, flat files, Oracle

Other Tools: Visual Studio .NET, MSOffice, Microsoft Visio, Crystal reports, Rational rose, Win runner

Versioning Tools: VSS, SVN, TFS

Operating System: Win, Server, Linux (SUSE, Red hat, Yellow dog), SCO Unix

EXPERIENCE:

Confidential

Software Developer

Responsibilities:

• Documented current system as base design for new system (database design, business rules, and screen layouts). (PHP / MySQL 3rd party system off the shelf).
• Conducted user interviews for offshore team
• Worked with BA to prepare & finalize TDD
• Performed gap analysis for the new database (MS SQL Server)
• Single point of contact for offshore team (business rules questions, disputes over design, user acceptance testing, code migration, code integration, deployment)
• Prepared effort analysis & cost estimates for management
• Developed data migration routines for new system, VBScript
• Automated test cases with Renorex, to save time (UAT automated, rest of QA testing done offsite)
• Designed & developed interface to automate shipment creation saving 80% time (Excel / flat text files data vs manual shipment creation) C#, standalone interface due to security concerns.
• Re-designed partner billing module: online shipment board interfacing with one-time partners (C# windows service, C# standalone interface)
• Updated status reporting, GPS tracking, changes for different reporting needs specific to customer / partner. VBScript reporting engine, reports generated in Excel or CSV.

Environment: C#, VB.NET, WinForms, ASP.NET 4.0, ASP.NET, Window Services, Visual Studio 2015, T-SQL, ADO.NET, XML, JavaScript, JSON, Team Foundation Server 2008.

Confidential, Farmington Hills, MI

System Analyst

Responsibilities:

• Developed a code scanner to build Wireframe Sketcher XML from existing codebase (Cobol)
• Designed database for new system from copy books. Major redesign was needed as the original keys like patient number needed to be changed. ( Cobol design not compatible with 4GL queries)
• Design & developed command line utility to encrypt /decrypt data files using open ssl
• Unix/Linux C++ è Dynamic key based on date, predefined phrase, operation and data file
• Windows C# è Data files are extract for patient information and HIPPA requires encryption
• Assist senior executive of alternatives, PHP, Asp.Net Vs current (COBOL) to choose future system.
• Develop new visual layouts standards, coding standards. (Offshore & local teams had different looks and system didn’t look homogeneous)
• Performed code audits for team members (VB.net, PHP, C#)
• Installed & maintain MS SQL instance for developer and customer data (HIPPA regulations)
• Evaluated automated testing tools like Renorex, Selenium, Eggplant, TestComplete, Sahi etc.
• Collaborate with QA team with
• User acceptance testing, Verify test coverage, define test cases, metrics
• Resolve questions about test results (Business rules, QA/ dev team disputes)
• Developed functions for customer dashboard (Insurance, employer, pending bills, last visit)

Environment: C#, C++ (Sco Unix), VB.NET, WinForms, PHP , Window Services, Visual Studio 2015, MS-SQL, ADO.NET, XML, JavaScript .

Confidential

Team Lead / Developer

Responsibilities:

• Maintained and updated VB.net system for customs.
• Maintained MS access data consolidation system, EDI, Oracle, Sybase and MS-SQL data connected in access, verified and consolidated in MS SQL Server database.
• Automated QA system, using record and play testing tool ( Renorex ) to create and document testing. Original QA system was manual only, 3-5 days for testing.
• Designed and developed reports for customers tracking, vehicle positions, shipment pending, xDock operations.
• Prepared customer data upload for manifesting, customs. MS Access , data verification, conditioning and finally uploading to MSSQL.
• Migrated MS Access reports to Crystal reports .

Environment: VB.NET, WinForms, Window Services, Visual Studio, ADO.NET, XML, MS SQL server , EDI server, Secure FTP, VBScript, MSOffice.

Confidential

Team Lead / Developer

Responsibilities:

• Converted MS access customer management system to VB/MS-SQL.
• Managed 60 warehouse spanned across 6 databases (Different customers, business units)
• Managed WMS system on Motorola handheld systems
• Maintained Zebra barcode reports for multi model shipments (Air, Neva)
• Migrated reports from CBL to Crystal reports .
• Prepared database gap analysis for consolidating data for data warehouse
• Designed & developed hourly data pulls for warehouse, MS access to join data from multiple sources
• On boarded 6 customers coordinating customer data pulls, corporate EDI department (offsite in Germany) and sales team
• Prepared documentation from COBOL applications / data files for business rules, for new system.
• Maintained EDI data pull & push systems for customer data (Getting data for shipment creation & pushing status data back to customers)
• Fixed status email, by reducing outgoing emails from 200 to 8 per shipment. There was no way to test system as status events occur only in live system.
• Maintained website with 20K daily hits, for shipment status reporting.
• Automated manifesting system for compliance, replacing data i/p with XML data. Saving 95% shipment creation time (120 min to 10 min.)
• Maintained Unix based handheld warehouse scanners / computers (Motorola Windows CE)
• Lead web services adoption team for integration with Canada customs.
• Designed XML data pulls from Unix for website status customer dashboard
• Designed/ Managed a status check website with 80000 hits a day

Environment: C#, C++ (Linux), VB.NET, EDI data, WinForms , secure FTP, Window Services, Visual Studio, MS-SQL, Oracle (Head office), MS Access for data integration / reporting, XML, JavaScript, Sc.

Confidential, Mason, OH

Business Analyst

Responsibilities:

• Managed offshore teams with SME interviews, impact analysis and any other questions as arrived
• Prepared cost estimates with development team
• Prepared / finalized change request, impact analysis documents
• Performed gap analysis for the Sybase database changes
• Performed government regulation change impact analysis for each change (E.g. SSN not on file)
• Managed HP service manager with change request approvals, database change approvals, production movement approvals for each change managed (16 changes managed over the period)
• Single point of contact for offshore teams (business rules questions, disputes over design, user acceptance testing, code migration, code integration, deployment)
• Managed an issue list for offshore teams (Excel by date / SME)
• Managed job scheduling for Facets
• Conducted team meeting for status, issues, SME introductions

Environment: Facet, HP Service manager, VB.NET , Sybase, Oracle, MSOffice

Confidential

Developer / QA Team Lead

Responsibilities:

• Automated report preview removing need to switch development environment. Scripting compiling & running preview for multiple compilers from UI (C#, VB, VC++ and CBL)
• Managed code generators , for reporting & XML integration written in VB.net generating CBL
• Developed a module to gather DLL versions information from client computer. Windows, 3’rd party DLLs. Customer communication became issue due to time zones.
• Managed a DLLs for 3’rd party components supported by win 2000/XP/Server and Vista (32/64 bit)
• Managed VB.Net custom control for report design
• Automated testing process to reduce test time from week to 6 hours . Any changes to code based needed to test and 1-week testing time restricted to monthly delivery schedule. Developers issuing intermediate code fixes to customer creating a DLL hell. 6-hour testing time we could put together 1-week release schedule if needed.
• Developed a code scanner for Cobol to VB data migration
• Designed & developed tool to compare report output (RTF/HTML/PDF) with a standard output used in QA automation
• Prepared test coverage documentation
• Managed a team of 3 testers responsible for testing 4 customer facing products
• Prepared & upgraded VB.Net systems for 64-bit server migration (MS SQL don’t work on 32bit due to low memory). 3 rd party components needed to be upgraded; code base needed removed 32-bit windows libraries.
• Resolved application co-existence issues (Canam products and 3’rd party products.)
• Developed windows service for report scheduling, with equation parser (report parameters == $today$ + 5, $yesterday$ etc.)
• Designed a SQL / VB script monitoring solution for 27 production servers (spread across North America). Daily data uploads create massive logs & data file size issues.
• Developed VB scripts to collect system information about jobs, disk space, system DLLs and daily VB processes (40+ servers in production & 15+ intermediate servers).
• Designed & developed scripts to generate summary report emailed to support team daily (40 servers).
• Developed ACT data import to SQL server , ACT was a stop gap solution used by marketing team needed upgrade due to size and speed.
• Designed & executed a test plan for ASP/ PHP websites, leading 3 testers team
• Helped get PCI certification for men’s weight loss sight.

Environment: C++ (Linux), VB.NET, WMI libraries (Windows management interface), Win Forms, secure FTP, Window Services, Visual Studio, MS SQL Server, MS Access, XML, VBScript.