Senior Software Consultant Resume
Harrisburg, PA
SUMMARY:
Have around 14 + years of experience in the IT industry as Team Lead / Senior Software Analyst / Developer with exposure to various domains (Government, Manufacturing, Pharmaceutical, HealthCare, eCommerce (B2B, B2C), Finance, Media & Entertainment, Technology Service) and has worked closely with project sponsors, business users and development teams in successfully translating process requirements into specifications and deliverables. I’m dedicated, sincere in my work and won reputation from previous employers & clients.
TECHNICAL STRENGTHS:
- Extensively worked in Windows & Web based applications using .NET Framework 1.0, 1.1, 2.0, 3.0, 3.5, 4.0 and 4.5
- Worked in various development models Agile (SCRUM), Test Driven, Iterative and Waterfall Method life cycles for Client - Server, Multi-Tier, and Event Driven Programming.
- Very strong Business modeling skills using Rational Unified Process, OOAD and UML.
- Managed teams of 7-9 developers as part of the onsite-offshore model. Project initiation, scoping, estimating, and forecasting.
- Depth experience on database design, programming (Stored Procedures, Functions, Triggers, Views using T-SQL, PL/SQL) and performance fine tuning in MS SQL Server and Oracle. Maintained DTS / BCP packages and worked on SSRS and knowledge on SSIS in MS SQL Server.
- Experienced in managing projects using Team Explorer / Team Foundation Server (TFS), Visual SourceSafe, TortoiseCVS version control tools.
- Proven ability to train, support, and lead successful teams of technical employees.
- Excellent problem solving, analytical, interpersonal, written and oral communication skills.
- Familiar knowledge on BizTalk Server 2006 / SharePoint Portal Server 2003.
TECHNICAL SKILLS:
Domain Expertise: Government, Manufacturing, Pharmaceutical, HealthCare, eCommerce (B2B, B2C), Finance, Media & Entertainment, Technology Service
Languages & Technologies: ASP.NET, C#, VB.NET, VB, ASP, VBScript, JavaScript, HTML 5/ DHTML, CSS 3.0, XML/ XSL, DOM, COM+/ Active-X, SOAP-XML Web Services, NUNIT, MVC, AJAX, WCF, WPF, UML, C, C++
DBMS: SQL Server 6.5/ 2000/ / 2012 , T-SQL, Access '97/ 2000, Oracle 9i/ 10g/ 11g PL/SQL, MySQL
Web Servers: IIS 4.0/ 5.0/ 6.0/ 7.0 , MTS 2.0/ Component Services, MS BizTalk Server 2006 R2, MS SharePoint Portal Server 2003
Development Tools: MS Visual Studio .NET 2003/ 2005/ 2008/ 2010/ 2012 , MS Visual InterDev 6.0, Homesite 5.x, Macromedia Dreamweaver 4.0, Adobe Photoshop 9.0, CS3, Crystal Reports 7.0/ 8.0, MS Visio, Rational Unified Process, Rational Rose, Rational Requisite Pro, UltraEdit-32, RAZOR View Engine, XAware Designer 5.4
Version Control Tools: MS Visual Source Safe, Build Professional, MS Team Explorer / Team Foundation Server 2005/ 2008/ 2010/ 2012 , Tortoise CVS, Tortoise SVN
Operating Systems: MS Windows 9x/ NT/ XP/ 2000/ 2003/ 7/ Vista, Linux, Unix, MS DOS
PROFESSIONAL EXPERIENCE:
Confidential, Harrisburg, PA
Senior Software Consultant
Responsibilities:
- Involved in Requirements Collection, Design & Analysis of the Customer Specifications, Development and Customization of the Application. As part of the development team, I too involved in analysis, design, development, testing, and implementation.
- Enhanced the complete new tab (Permit Schedules) in Permit Maintenance Form to display the existing schedules from the database and then add, modify and delete the schedules based on the Permit Number on Confidential Client windows application using C# technologies and incorporated the code using Team Explorer in Team Foundation Server 2012.
- Developed SQL queries to update the tables to generate many Monthly, Semi-Annually & Annually wise reports to use in eDMR web-based application in SQL Server.
- Worked for additional COMP, INSPECT security enhancements on the entire Confidential application to create, modify & finalize the Document Templates in Facility Maintenance & Permits sections.
- Did debugging and bug fixing on the Confidential Client application. Hands on experience in developing, debugging n-tier applications using C#, ADO.NET, SQL Server.
- Used ADO.NET objects such as Data Reader, Dataset and Data Adapter, for consistent access to SQL Server data source.
- Implemented Windows authentication and Custom authentication against SQL Server database using Windows form controls and used WPF for designing UI.
- Designed and developed the WCF Proxy Classes for the eFACTS DB Interfaces using .NET 4.5, VB.NET and Oracle 11g.
- Used Team Explorer in Team Foundation Server 2012 for version controlling and source code sharing and also used MS Build.
- Modified SQL functions & stored procedures for enhancement of Significant Minor in report generation in eDMR application.
- Created/ modified SQL Queries better performance tuning on analyzed existing code for better outcome.
- Performed End-to-End Testing, troubleshooting, debugging, integration testing and performance testing and analyzed the results to justify the validation.
Environment: .Net Framework 4.5, C#, ADO.NET, SQL Server 2012, ASP.NET, MVC 4.0, VB.NET, Oracle 11g, XML, XSLT, Team Foundation Server 2012, IIS 8.0
Confidential, Little Rock, AR
Senior Software Consultant
Responsibilities:
- As part of the development team, I was associated with the full life cycle of the project (analysis, design, development, testing, and implementation) under agile and scrum methodologies.
- Involved in Requirements Collection, Design & Analysis of the Customer Specifications, Development and Customization of the Application.
- Worked extensively on different environments like development, testing, staging and production.
- Hands on experience in developing, debugging n-tier applications using ASP.NET, VB.NET, ADO.NET, SQL Server.
- Used ADO.NET objects such as Data Reader, Dataset and Data Adapter, for consistent access to SQL Server data source.
- Implemented Windows authentication and Custom authentication against SQL Server database using Windows form controls and used WPF for designing UI.
- Extensively Worked in different environments like ARD, ART, ARS, ARP, Migration, FCR, SQR, DOC which was Windows Based applications using VB.NET, ADO.NET and SQL Server.
- Extensively developed and debugged the System (BO) Components for enhancements/ maintenance for Letters, Mail, Registration, Returns, Bankruptcy, Payments, Collections, General Ledger, Reports, Cubes, Taxpayer Access Point (TAP), Work Items, Data Mart, Case, data changes in many tables using GenTax Tools and MS Visual Studio 2010.
- Used Team Explorer in Team Foundation Server 2010 for version Controlling and source code sharing and also used MS Build.
- Created/ modified SQL Queries better performance tuning on analyzed existing code for better outcome.
- Involved in analyzing and preparing Unit Test cases for various scenarios.
- Performed End-to-End Testing, troubleshooting, debugging, integration testing, regression testing and performance testing and analyzed the results to justify validation.
Environment: .Net Framework 3.5/4.0, VB.NET, ADO.NET, ASP.NET, MVC 4.0, XML, XSL, XSLT, SQL Server 2008, Team Foundation Server 2010, IIS 7.5, GenTax tools / GenTax Reporting tools
Confidential, Baton Rouge, LA
Senior Software Consultant
Responsibilities:
- As part of the development team, I was associated with the full life cycle of the project (analysis, design, development, testing, and implementation) under agile and scrum methodologies.
- Involved in Requirements Collection, Design & Analysis of the Customer Specifications, Development and Customization of the Application.
- Worked extensively on different environments like development, testing, staging and production.
- Hands on experience in developing, debugging n-tier applications using ASP.NET, VB.NET, ADO.NET, SQL Server.
- Extensively Worked in different environments like LAD, LAT, LAS, LAP, Migration, FCR, SQR, DOC which was Windows Based applications using VB.NET, ADO.NET and SQL Server.
- Extensively developed and debugged the System (BO) Components for enhancements/ maintenance for Letters, Mail, Registration, Returns, Bankruptcy, Payments, Collections, General Ledger, Reports, Cubes, Taxpayer Access Point (TAP), Work Items, Data Mart, Case, data changes in many tables using GenTax Tools and MS Visual Studio 2010.
- Extensively developed pages and worked on HTML 5, XML Schemas, XML Documents, and XSL Style Sheets for "Tax Express" Web Based module.
- Extensively worked migrating "Sales Tax" Windows Based module which was in VB6, Access 2000 to Web module using ASP.NET, VB.NET and SQL Server
- Used Team Explorer in Team Foundation Server 2010 for version Controlling and source code sharing and also used MS Build.
- Created/ modified stored procedures, triggers, and views in SQL Server 2008 for data manipulation and retrieval using TSQL.
- Performed performance tuning on analyzed existing code for better outcome.
- Involved in analyzing and preparing Unit Test cases for various scenarios.
- Performed End-to-End Testing, troubleshooting, debugging, integration testing, regression testing and performance testing and analyzed the results to justify validation.
Environment: s: .Net Framework 3.5/4.0, VB.NET, ADO.NET, MVC 4.0, ASP.NET, XML, XSL, XSLT, SQL Server 2008, Team Foundation Server 2010, IIS 7.5, LDR-Share Point, GenTax tools / GenTax Reporting tools
Confidential, East Chicago, IN
Senior Software Consultant
Responsibilities :
- Analyzed and worked closely with client management to identify and specify complex business requirement processes and enhanced many new fields in different pages according to the client requirements and design, development of the existing product incorporated the code using Team Explorer in Team Foundation Server 2010.
- Worked on Customized Report Builder, Annual contract negotiations, Individual customer part performance analysis, Customer strategies (mix, volume), Market, customer, and product performance evaluations and trade-offs, Spot billings evaluation, Manufacturing performance evaluation (throughput, yield, flow), Capital project evaluation and Analysis and monitoring of price leakage.
- Worked on Windows Form batch programming using VB.NET and SQL Server for CostReporting, DataLoad, Freight, Slab, USABatch batch modules for CPR-LFR and CPR-Plate applications.
- Developed ASP.NET, VB.NET, JavaScript, jQuery, Ajax, WPF web pages, user interface and Web Service/WCF business logic & functions by using Agile methodologies, implemented HTML 5/ CSS and XML / XSL, DOM in various modules using .NET Framework 4.0.
- Created / modified the stored procedures, functions, triggers & views on SQL Server 2008 according to the functionalities using T-SQL.
- Coding/ Unit testing/ Code Reviews and bug fixing .
Environment: s: .NET 4.0, VB.NET, ASP.NET, WPF, MVC 3.0, JavaScript, jQuery, Ajax, HTML 5, XML/ XSL, MS SQL Server 2008.
Confidential, Iselin, NJ
Senior .NET Consultant
Responsibilities :
- Analyzed and worked closely with client management to identify and specify complex business requirement processes and enhanced many new fields in different pages according to the client requirements and design, development of the existing product incorporated the code using Team Explorer in Team Foundation Server 2008.
- Enhanced on various on HCAP, client eligibility, enrollment, pharmaceutical program, case management, disease management modules and ability to verify income prior to enrollment, Scanning and View scanned documents for each Client (W2’s, Check Stubs, Tax Returns, Scanning, Signature pad, Printing, fax, email, upload functionalities) web and Kiosk modes of the application and in English and Spanish versions o f the application.
- Eligibility screening across multiple programs, Bar-coded Client IDs, Form letters, Client healthcare needs assessment, Tracking Access to Care, Tracking Healthcare Utilization and Medication Tracking by Provider and Client features.
- Worked on various reports to generate/ modify the PDF templates and merge the signature, some fields from the database to update in the PDF report file for the customer related information using Telerik Controls for Dynamic PDF file downloads.
- Developed ASP.NET, C#, JavaScript, JQuery, WPF web pages, user interface and Web Service business logic & functions by using Agile methodologies, implemented HTML/ CSS and XML / XSL, DOM in various modules using .NET Framework 3.5.
- Created / modified the stored procedures, functions & views on SQL Server 2008 according to the functionalities using T-SQL. Worked on the Client Details, Information, demographic reports using SQL Server Report Services ( SSRS ).
- Coding/ Unit testing/ Code Reviews and bug fixing .
Environment: ASP.NET, C#, WPF, JavaScript, jQuery, HTML, XML/ XSL, MS SQL Server 2008.
Confidential, West Chester, PA
Senior Software Consultant
Responsibilities :
- Involved in the existed systems study and analysis for the design, development and customization of enhancements of the existing product incorporated the code using the MS Visual Source Safe Explorer & Microsoft Visual InterDev .
- Enhanced the legacy systems (US Stratus, UK & DE ISS) to an Enterprise Application is consistent with the Confidential architecture plan and deployed to replace current delivery determination applications.
- Developed Classic ASP, VBScript and JavaScript web pages, user interface, business logic & functions by using Event Driven Programming. Compiled the COM+ dynamic link libraries (DLLs) using Visual Basic 6.0 according to the modification of the enhancements of the business logic and implemented HTML, CSS and XML / XSL, DOM in various modules.
- Design, systems analysis, test, debug and performing data conversion of the database structures from MS Access and SQL Server 2000 to SQL Server 2008 and c reated / modified stored procedures, functions, triggers & views of T-SQL for performance tuning and enhancements for user interface.
- Coding/ Unit testing/ Bug fixing / Code Reviews .
Environment: s: VB, ASP, COM+, VBScript, JavaScript, AJAX, XML/ XSL, MS SQL Server 2008.
Confidential, La Vista, NE
Senior .NET Consultant
Responsibilities :
- Involved in the existed systems study and analysis for the design, development and customization. Migrated the product from Classic ASP and COM+ to .NET technologies and incorporated the code using Team Explorer in Team Foundation Server 2008.
- Developed various web pages for US Businesses, International Businesses, Canadian Businesses, UK Businesses, US New Businesses, Employers USA modules by using Agile Methodology.
- Worked on the user interface, business logic & functions by using VB.NET, ASP.NET, JavaScript, JQuery, JSON, AJAX, HTML, CSS, XML / XSL, DOM and UI development using WPF in various search pages. Used LINQ to retrieve the data from Oracle 10g.
- Worked on various downloads of the bulk records and created reporting using Telerik controls for Dynamic PDF file downloads.
- Designed and developed custom integration solutions using SOAP / XML, Web Services .
- Coding/ Unit/ Integration testing/bug fixing/ Code Reviews.
- Analyzed the existed MMDB database (Interactive Query Language) and c reating stored procedures, functions & views of T-SQL for performance tuning and enhancements on Oracle 10g for user interface.
Environment: s: .NET 3.5, ASP.NET, VB.NET, Web Services, WPF, AJAX, JavaScript, Oracle 10g .
Confidential, Fairfax, VA
Senior .NET Consultant
Responsibilities :
- Involved in the existed systems study and analysis for the design, development and customization of enhancements of the existing product, incorporated the code using Team Explorer in Team Foundation Server 2005.
- Involved in the existed systems study and analysis for the design, development and customization of enhancements of the existing product.
- Developed various web pages for MPDPF, MPPF, PlanFinder tools.
- Developed various web pages using ASP.NET, JavaScript, AJAX, HTML, CSS, XML / XSL, DOM and user interface, business logic & functions in VB.NET by using Agile Methodology.
- Worked on parsing the ADT, HL7 messages , HIPAA , CCHIT from ASTM, HL7 and XML file formats of the health related Electronic Medical Record (EMR) information gathered and consulted by clinicians and the aggregate Electronic Health Record (EHR) information that is created and gathered by clinicians and staffs from cumulatively across more than one health care organization for on each individual and stored it in database.
- Analyzed the existed MS SQL Server 2005 stored procedures and created/ modified optimized stored procedures, functions & views for performance tuning and enhancements.
- Coding/ Unit/ Integration & System testing/ Bug fixing/ Code Reviews.
Environment: s: .NET 2.0, ASP.NET, VB.NET, JavaScript, AJAX, XML/ XSL, MS SQL Server 2005.
Confidential, Cambridge, MA
Lead Programmer
Responsibilities :
- Led seven person development onsite/offshore team in product based company, mentored the juniors, direction and technical assistance to the team as well as managing client to solve their most complex business and technical issues. Involved in the existed systems study and analysis for the new system, design and documentation of the metadata repository product as well as support and enhancement of the existing product. Incorporated the code using the version control TortoiseCVS tool.
- Worked on web pages and developing user interface, business logic & functions using Classic ASP , JavaScript, and AJAX, VB Script and Shell scripts for patient informations .
- Developed a complete module (NPI.MD) national provider identifier to each physician, supplier or other provider of health care using ASP.NET 3.0, C#, AJAX , Web Services , JavaScript, JQuery and T-SQL, MS SQL Server 2005 .
- Worked on parsing the ADT, HL7 messages, HIPAA (Health Insurance Portability and Accountability) , CCHIT, Medical billing and insurance from ASTM, HL7, XML, ASCII file formats of the health related Electronic Medical Record (EMR) information gathered and consulted by clinicians and the aggregate Electronic Health Record (EHR) information that is created and gathered by clinicians and staffs from cumulatively across more than one health care organization for on each individual and stored it in database.
- Extensively worked on Eligibility Inquiry / Response (X12N 1), Claims Status Inquiry / Response (X12N 276/277) and Authorizations / Referrals (X12N 278) transaction standards.
- Analyzed the existed MS SQL Server 2000 and migrated to MS SQL Server 2005 and worked on the stored procedures, functions, triggers, views, performance tuning . Maintained DTS packages and created patient lab results reports using SQL Server Report Services ( SSRS ).
- Coding/ Unit/ Integration testing / Code Reviews/ Design Reviews. Worked offshore for design, development, bug fixing and onsite for implementation and configuration model by model and meet the deadlines.
Environment: s: VB, ASP, VBScript, Web Services, AJAX, JavaScript, XML/ XSL, HTML, MS SQL Server 2005.
Confidential
Senior Software Engineer
Responsibilities :
- As a Module Lead, offered technical support and mentoring to less experienced team members.
- Contributed in creating user interface, business logic & functions using C# and ADO.NET in Agile Development Methodology.
- Created stored procedures, functions & views for the application on Oracle 10g.
- Responsible for database managing & tuning for complex systems.
- Developed more than 60 reports using Crystal Reports.
- Used MS Visual Source Safe for code configuration management and used MS Visio for documentation.
- Worked on Unit/ Integration testing and bug fixing.
Environment: s: .NET 2.0, C#, Win Forms, Oracle 10g and Crystal Reports 8.0.