Sr. Programmer Analyst Resume
Cincinnati, OH
PROFESSIONAL SUMMARY
- Over eleven years of experience in Information Technology working on Internet/Intranet and Client/Server applications.
- Extensive experience in ASP.NET, VB.Net, C#, WinForms, Webforms, Web Services, VSS.
- Excellent experience in databases such as Microsoft SQL Server and Oracle.
- Experience in ADO.NET, Visual Basic, ASP, VBScript, JavaScript, ActiveX, HTML, DHTML, XML, XSL, IIS, Visual Interdev with good proficiency in Web-enabled applications.
- Extensive experience of web development in SharePoint.
- Experience in SharePoint Content Management.
- Experience in Object Orient Analysis Design (OOAD) using UML Methodology including Use Case diagrams, Class diagrams, Interaction diagrams, State diagrams and deployment diagrams.
- Involved in all the stages of Software Development Life Cycle (SDLC) including Requirements Analysis and Design, implementation, integration and testing, deployment, user training and support.
- Experience in generating reports using SSRS and Crystal Reports.
- Experience in software development using various Software development methodologies including those confirming to CMMI standards.
- Experience in working in onsite/ offshore model and as a Module lead, Team lead and Tech Lead.
- Experience in Financial sector, Enterprise, Travel, Healthcare and Manufacturing domains.
TECHNICAL SKILLS
- Share Point: WSS, MOSS 2007, Web Parts, Silverlight , InfoPath, Workflow, Share Point Web Services, SharePoint variation, Windows Workflow Foundation, SharePoint Object Model, CAML Query
- .NET Technologies: Microsoft .Net Framework 1.x, 2.0, 3.0, 3.5, 4.0, C#, ASP.NET, VB.NET, ADO.NET, Web Services, Windows Services, .NET Remoting and WCF.
- Languages: C#, VB.Net, C, C++, VISUAL BASIC 6.0, Java, J2EE, JSP, SQL, PL/SQL, Shell Scripting, Action Script, MSXML/ XML, XSL, UML
- Web: ASP, HTML, DHTML, XML, VBScript, JavaScript, AJAX, Atlas
- Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports, Chapdo Spellserver, SQL Server Integration Services (SSIS)
- Application Server: IIS, Apache Tomcat, MS Commerce Server
- Tools and IDE's: Visual Studio.NET, Macromedia Dreamweaver MX, Flash MX, MS VISIO
- APIs: Swing, JDBC, Java Servlets, JSP, RMI, Java Beans, Connection Pooling
- Component: COM, DCOM, COM+, ACTIVE X, DTS, .NET Assemblies, Net Framework, NetSecurity, .NET Remoting, XML Web
- Operating Systems: Windows 2000/ XP, Window Server 2003, 2007, 2010, Linux, UNIX.
- Database: MS SQL Server 2000/ 2005/ 2008 (DBA), Transact SQL, Oracle, Microsoft Access
PROFESSIONAL EXPERIENCE
Confidential, April 2011 - May 2012
Cincinnati, OH
Senior Consultant
Designed, developed and provided support for new and existing applications. Leading development for a complex survey web application using .Net/C# and SQL Sever. Enhanced UI and new AJAX interfaces for Dashboard web application including listings, search engine, and graphical presentation of complex data. Built entire web application from scratch including design, program logic and implimenting all business rules.
- Created .Net/C# and SQL Server Websites and Applications.
- Designed, managed and used SQL server database as back-end for web sites and applications and writing complex store procedure for applications.
- Writing high quality code in ASP.NET, C# for different applications
- Created Graphical Roadmap page by pulling data from SQL Server Database.
- Coordinating application development for multiple projects.
- Assist in troubleshooting software application issues.
- Discussing and understanding business requirements and providing possible solutions.
- Leading development for a complete development of website, which include all the stages of Software Development Life Cycle (SDLC): Requirements Analysis and Design, implementation, integration and testing, deployment, support.
- Designing User Interface using ASP.NET controls, AJAX toolkit.
- Using JavaScript extensively for client side validation as well as user interface (UI).
- Developing and providing reports, which involve complex SQL queries.
- Implementing CSS Style Sheet to achieve uniformity across the application.
- Enhanced functionality of data lifting application using ASP.NET/C#, MS SQL Server and XML.
- Provides assistance and advice to business users in the effective use of applications.
Environment: Visual Studio 2008/2010, ASP.NET, C#, AJAX, Javascript, JQuery, XML, CSS, Web Services, SQL Server, IIS Admin, Windows 7/Windows Sever, SSRS, ASP.NET, Web Forms, CSS
Confidential, March 2008 - April 2011
Versailles, OH
Sr. Programmer Analyst
Designed and developed applications using SharePoint and .Net like web content management, The Hub, iTeam websites in Share Point. Designed and developed program to print bar-code labels using zebra printer. Responsibilities included:
- Responsible to work on software development life cycle - Requirements, Design, Development, testing, implementation and maintenance of Internet and Intranet Website.
- Create SharePoint features and WebParts for MOSS 2007.
- Create SharePoint Solution using .Net 3.5.
- Create SharePoint workflow and workflow custom activities.
- Implement WCM and Publishing Features for website.
- Create SharePoint Web Application and Sites.
- Develop InfoPath forms with Custom Workflows.
- Write CAML query to fetch data from SharePoint List.
- Manage SQL server database for Promotion and product management, and writing complex oracle store procedure for production application.
- Used VB.NET, ASP.Net, SQL Server, Web Services, and a custom single sign-on.
- Writing high quality Code in ASP.NET, VB.Net for production and office application.
- Create and Maintain SSIS packages to extract data from source system(Oracle) to Sql Server.
- Keep tracking and Managing Security on Website.
- Maintain EDI application.
- Maintaining production application using Oracle 9i/10g and Oracle Application v11.5
- Develop routines to create XML configuration file programmatically.
- XPath and XQueries to extract data from XML files
- Using NUnit for unit testing.
- Visual Source Safe for Source Control and version management
- Implemented and documented bar code labeling procedures
Environment: Visual Studio 2008, ASP.NET, VB.Net, ADO.NET, AJAX, XML, CSS, Web Services, WCF, SharePoint 2007 , WSS, SharePoint Worflow, SharePoint Activities, Web Parts, Silverlight , InfoPath, Windows Workflow Foundation, SharePoint Object Model, CAML Query, SQL Server, IIS Admin, NUnit, UML, SOA, OOP, OOAD, Windows XP/Win2k Severs, Crystal Report, Developer Express tools, TFS, VSS, Oracle Application 11.5, SSRS
Confidential, October 2006 - February 2008
New York, NY
Sr. Programmer Analyst
Finance Globalization Initiative
Finance Globalization Initiative (FGI) was a financial application developed to provide data entry for Customers, Traders, Brokers, Rules, Limits, General Ledger into a single global application. It is 3-tier application developed in ASP.NET, C#. The application also provides functionality of creating a recommended configuration and extract files in XML format. It consists of a web-based and a smart client front-end deployed. Responsibilities included:
- Involved in Requirements, Design, Development, testing and implementation of FGI.
- Writing high quality Code in C# & ASP.NET, ADO.Net for the complex part / modules of the Products.
- Code Reviews.
- Created user controls to extend to all the custom modules.
- Designed and developed custom .NET components with Multi-threading and user controls using ASP.NET and C#.
- Roles-based security for viewing content, editing content, and administering the site.
- Developed routines to create XML configuration file programmatically.
- Used C#, ASP.Net, SQL Server, Web Services, and a custom single sign-on.
- Used NUnit for unit testing.
- Used Sharpoint Enterprise.
- Used XPath and XQueries to extract data from XML files.
- Used Visual Source Safe for Source Control and version management.
Environment: ASP.NET, C#, ADO.NET, XML, Sharpoint , Web Services, SQL Server 2005, IIS Admin, VS.NET 2005, Multithreading, Nunit, UML, SOA, OOP, OOAD, WindowsXP/Win2k Severs/Unisys ES7000 Servers, Rational Rose, Crystal Report
Confidential,June 2005 - September 2006
Parsippany, NJ
Sr. Software Engineer
Fareportal Internet Booking Engine
This project has been developed for the client Fareportal Inc., USA to search Air, Car, Hotel & Visa Requirements and make the booking online. The booking engine uses the XML Select2.0 of Galileo GDS and also synchronizes the travelers profile to and from Galileo GDS. Responsibilities included:
- Involved in the Analysis, design and architecture of the overall application Involved in building and using new .NET Assemblies, namespaces and sub namespaces Developed various classes, modules, for e.g. Graduate Guide Instrument and Related Searches using ASP.NET, C#.Net.
- Adopted the various methodologies for Application design such as Abstraction, Encapsulation, Inheritance and Polymorphism Implemented Garbage Collection for optimal performance, efficiency and free up the resources.
- Used ADO.NET technology for transmitting data in XML format between database and user interfaces/web interfaces as part of the required functionality Involved in preparing requirement specifications, design specification and writing the test case documents for the QA team.
- Implemented business logic class library for Data Access Layer through Store procedure and Class structure. Actively participated in GUI design and create dynamic interface with CSS, XML Developed complete middle tier and database tier. Created stored procedures, triggers, jobs etc.
- Actively participated in testing of the application Write test cases, testing scripts Executed operational qualifications and Installation qualifications.
- Extensively Interacted with clients and business teams to provide technical support and measure the scalability, consistency and accuracy of the application. Worked on the Web services client as well as wrote the web service components.
Environment: ASP.NET, C#, ADO.NET, XML, XSL and Java Script, AJAX, Web Services, SOAP, SQL, PL/SQL, SQL Server 2005, VS.NET 2005, UML, SOA, OOP, OOAD.
Confidential,May 2004 - May 2005
Aurora, IN
Lead Application Developer
Involved in development of a B2B web application. It provides business-to-business integration solution for live exchange customers. Live exchange and web methods B2B solutions offers customers' seamless integration to leading B2B market places. PCB is a leading provider of negotiated e-commerce solutions for online auctions, online procurement and e-marketplaces. Negotiated e-commerce involves the buying and selling of goods and services online through flexible transaction models that change over time based on multiple terms such as price, condition of goods, warranty and shipping costs. Responsibilities included:
- Involved in design and development of technical specification documents for the project.
- Developed the user interface in ASP.NET. Code behind was developed in VB.NET.
- Improve the user experience using ATLAS
- All the business logic was written in VB. NET.
- Used XML Web Services to retrieve the relevant information from various sources.
- Involved in development of 3-tier Architecture.
- XML and SOAP was used to exchange the information over the network.
- Developed a robust Data Access Layer in VB.NET, with integration of ADO.NET using connection pooling to maximize the performance.
- Wrote T-SQL stored procedures, which will execute against a database in order to extract the appropriate data for each report.
- Used editable Data Grid controls to display the requested information.
- Created DLLs to implement business logic and to integrate the application.
- Ease of maintenance was assured with consistent use of web.config file.
Environment: ASP.NET, C#, XML, SOAP, T-SQL, ADO.NET, Atlas, JavaScript, WSDL, Oracle 8i / 9i.
Confidential, October 2003 - April 2004
Toledo, Ohio
Dot Net Developer
Shipment Tracking & Inventory System
STIS is a part of Supply Management Chain. The system has been designed in Three Tier architecture. This system is used to track invoices generated by BAAN. The main challenge of the project was to fetch the data from BAAN ERP which has been achieved by creating & scheduling DTS. Invoices get fetched in the STIS on the regular basis. Tracking of the invoice starts after it gets fetched in the STIS. There are 4 types of users; Administrators, SIL Managers, Customers, Normal Users. Reminders and alerts are sent to Defaulter users and their respective Senior Authorities. Responsibilities included:
- Requirement Analysis, Analyzing Business Logic.
- Designing and Developing UI screens in ASP.Net with code-behind in C#.
- Created fully maintainable online administration of the site with dynamic creation of pages, layout, content, roles and security.
- Management of CRs given by client during development phase.
- Roles-based security for viewing content, editing content, and administering the site.
- Responsible for Database design in SQL Server 2000.
Environment: ASP.NET, VB.NET, SQL Server 2000, JavaScript
Confidential, January 2001 - September 2003
UK
Sr. Programmer Analyst
Expresso
This Project has been developed for the Clients Profile, Services and Passive segments which interact with TR32 database, a mid office application of the Travelwire, Denmark and Elgar - a database for Rail and Ticketing system owned by Eurostar, UK. Moreover, Expresso has the capability to send the ticket information in to database and automatically issue the invoice for air and rail segments based on the PNR remarks received from the Galileo GDS and Elgar Rail Web Services. Responsibilities included:
- Involved in the Analysis, design and architecture of the overall application. Independently developed Data structure Design and Done performance optimization using ICallbackEventHandler and AJAX for speed up booking process on the tick of the check box.
- Implement business logic class library for Data Access Layer through Store procedure and Class structure Implemented business logic as .NET Framework assemblies (C#). Involved in the overall design/development of the modules such as User and Admin.
- Involved in designing of GUI with CSS, XML and XSL, development of middle tier and testing of the overall application by write thorough test cases and testing scripts.
- Extensively interacted with clients and business teams to provide technical support and measure the scalability, consistency and accuracy of the application. Worked on the web services client as well as wrote the web service components.
- Involved in resolving the bugs and issues reported by the clients.
Environment: ASP.NET, C#, WinForms, AJAX, XML, Web Services, Chapdo Spellserver, JavaScript and SQL Server 2000.
HMS (Hospital Management System)
Application was developed for small hospitals and doctors. Maintains information regarding patients and their families, doctors, consultants, prescriptions, drugs and medicines, rooms, operations, employees, bills & accounts. It represents all this data in a very unique graphical form. Predefined reports and facility to dynamically generate repots based on user-defined queries. Responsibilities included:
- Responsible for designing and coding of all the parts of the system in ASP.Net, VB.NET.
- Involved in Coding, Unit testing, Integration testing and development of test cases.
- Created user controls to extend to all the custom modules.
- Roles-based security for viewing content, editing content.
- Responsible for Database design in SQL Server 2000. Creating Stored procedures / functions.
- Developed a robust Data Access Layer in C#, with integration of ADO.NET using connection pooling to maximize the performance.
- Used editable Data Grid controls to display the requested information.
- Created DLLs to implement business logic and to integrate the application.
- Ease of maintenance was assured with consistent use of web.config file
Environment: ASP.NET, VB .NET, ADO.NET, MS SQL 2000, Crystal Report, Windows XP
Confidential, September 2001 - December 2001
India
System Analyst & Senior Software Developer
Performed analysis, software development in Visual Basic 6, and MS SQL Server 2000 Database Admin Work; Generated reports as per requirements of management using Crystal Report 9.0. Responsibilities included:
- Analysis of upcoming project work and work allotment to software team.
- Database Management and DBA (Database Administrator).
- Create Reports as per requirement of Management Team using Crystal Report 8.
- Internet Database Management using Microsoft Outlook.
- Database server Management.
- User support.
Confidential, March 2001 - August 2001
India
Software Developer & Analyst
Sales Order Processing Online
Responsibilities included:
- As an application developer I was involved in software development life cycle.
- Review software requirement and analyze it and developed static and dynamic WebPages.
- Responsible for module and application unit test before QA deployment.
- Provided QA support and resolved all QA issues by debugging and reviewing code.
Environment: Oracle8i, JDK1.3, JSP, BEANS, JDBC Connection Pooling using Oracle Driver, which are written in Java, HTML 4.0, JavaScript, and other animation tools also
Confidential, July 1999 to January 2001
India
Software Developer
Software covering all the functions of a School which included GR register, employee register, time table generation, fees collections, year-end process, attendance register, mark sheet generations, exam schedules etc. Responsibilities included:
- User interface design.
- Development and integration of various modules.
- Help file, build setup.
Environment: VB 6.0, ADO, Oracle 8i, Crystal Report, Microsoft Package & Deployment, Windows 2000
EDUCATION
- Masters in Computer Science