Programmer Analyst Resume
Elmhurst, IL
SUMMARY:
- A Microsoft Certified Technology Specialist (MCTS) with 7+ years of Extensive experience on Software Development Life Cycle (SDLC) which includes System Analysis, Architectural Design, UI Design, Application Design, Database Design, Development, Testing, documentation and Implementation.
- Developed, Configured and Deployed .NET Framework Applications including Web Forms, Win Forms, Web Services, Security, Cryptography, Windows Services and .Net Remoting.
- Experienced in Application Design with concepts like OOPS, Design Patterns, MVVM, MVC & MVP Architecture, N-Tire Architecture and Application Blocks. Using UML (Visio) concepts like Use Case Designing, Class Designing, and Activity Designing.
- Expertise in T-SQL Programming like SQLDMO: Distributed Management Objects, DTS: Data Transformation Services. Have worked on Business Intelligence tools SSIS Data Import/Export and SSRS.
- Have Hand on experience in multiple databases like MS SQL with also other RDBMS servers like Oracle, MS ACCESS, and MY SQL.
- Solid skills in various technologies C#.NET, VB.NET, ASP.NET, ADO.NET, WCF,WPF,WWF, LINQ, Silver light v2/3,XML, AJAX, Web Services, Windows Services, Crystal Reports, Zed Graph & VB 6.0 to develop different types of solutions like DLL, EXE, COM, User Control, Custom Controls and Wrapper Classes.
- Experience with AJAX Technology and creating high responsive User Interface.
- Experience in writing automated building script using NANT.
- Advanced extensible reporting skills using SQL Server 2005 Reporting Services (SSRS).
- Experience with Test Driven Development using NUNIT 2.2
- Experience with custom rules creation using FxCop.
- Experience with BugZilla an issue tracking System.
- Experience in development of products using Agile methodology.
- Have very good knowledge in Microsoft Expression Blender.
- Experienced in System Analysis by analyzing the client problems and providing the best solution.
- Good team player with excellent communication and presentation skills with strong aptitude towards learning new technologies.
TECHNICAL SKILLS:
Operating Systems
-
Windows 2003 Server / 2000 Server /XP
Frameworks
-
.Net Framework 1.1, 2.0,3.0, 3.5
Programming Languages
-
C#, VB 6.0, C++
Scripting Languages
-
Java Script, JQuery Lib, VB Script
Technologies
-
C#.NET,VB.NET, ASP.NET, ADO.NET, WCF, WPF, WWF, LINQ, Web Services, Windows Services, HTML, DHTML, XHTML, COM, AJAX, XML,XSLT, XPATH, SSIS, SSRS, NUnit,NANT,FXCop, CSS
Concepts
-
OOPS, MVC & MVP Architecture, .Net Application Blocks
Databases
-
MS SQL Server (2000, 2005,2008), Oracle 8i, MS Access, MY SQL
Servers
-
IIS (5.1, 6.0)
IDE / Tools / Utilities
-
Visual Studio .NET (2003, 2005, 2008), SQL Clients (Enterprise Manager, Query Analyzer and SQL Server Management Studio), UML (MS Visio), MS Project Plan, Bugzilla.
Version Control Tools
-
Tortoise CVS, VSS
Third party tools
- DevExpress, Vintasoft, TallComponents and Telerik
EDUCATION:
Master Degree in Computer Application
CERTIFICATION:
Microsoft Certified Technology Specialist, .Net Framework 2.0 Web Applications (MCTS).
- Microsoft .NET Framework 2.0 - Web-based Client Development.
- Microsoft .NET Framework - Application Development Foundation.
PROFESSIONAL EXPERIENCE:
Confidential, Sep 2009 – Present
Confidential,Elmhurst, IL
Programmer Analyst
Confidential,is one of the leading Health Care organizations in Illinois. For employee satisfaction EMH introduced paper less Review application in their existing portal for efficient and faster reviews. EMH Review Application includes 6 additional supporting modules [Remainders, Competency, Goals, Notes, PAF, and EEF] to calculate an employee review. The Employee Pay Rate will be calculated based on the Goals and Achievement done in the prior time period. All the Data will be captured as per JCAHO standard.
Responsibilities:
- Made a requirement study to collect all the features of review application including their old features and new features.
- Categorized the features with respect to the modules and identified all the Task items involved for the completion of the project.
- Designed the Data Model using normalization and de-normalization to accommodate all the features and the old data.
- Designed UI pages with HTML & Java Script.
- Converted VBA codes Review modules to ASP.NET.
- Design and developed Review, PAF, Goals and EEF Modules using ASP.NET.
- Built Data Migration tool to migrate old database to the latest database Using DTS packages.
- Implemented RIA – Rich Internet Access Concepts [AJAX, Users Driven UI].
- Integrated all Modules with live Portal Deployed the solution MSI installation project using VS.
- Provided quick and efficient support for the end users.
- Used COM controls for listing all the available Electronic files for an employee.
- Created Stored Procedure for PAF, EEF modules using T SQL
- Worked on Zed graph chart report viewer.
- Crystal Reports where used to provide ease of printing out the Review, PAF and EEF in JCAHO standard.
- Implemented the project for End user accessibility.
- Deployed the DLL and Server Side Pages with portal application MSI installation project using VS 2005.
- Worked in CVS – Versioning System for proper integration and safety.
- Worked on Production Support and troubleshoot the production issues.
Environment:.Net Framework 2.0, C#.Net, ASP.Net, ADO.Net, AJAX, MS Access, VBA, IIS 5.1, SQL Server 2000,DTS, Crystal Reports, Browser Independent, Visual Studio .Net 2005, MS Word, MS Visio, MS Project, Windows 2003 Server ,VSS
Confidential, May 2008 – Aug 2009 Confidential,Covina, CAProgrammer Analyst
Confidential,is a Medical Records/Claims processing company located in Covina CA. Developed the new Impairment Evaluation Guide Version 5 released by AMA (American Medical Association), CA. Computes the individual body part impairments from user inputs and calculate the part, region and whole person impairment for the patient automatically.
Responsibilities:
- Designed a fully normalized Data Model for the application, using MS SQL Database.
- Designed the application for Use Cases using MS Visio and built the class level design using Visual Studio Class Diagram, which served as a base for development.
- The Application was designed based on OOPS and MVC Architecture for isolation of UI, Business Logic and DAL - Data Access Layer.
- Authored SRS document, Functional Specification document and Test Case document.
- Designed & Developed DHTML driven pages with Java Script libraries like JQuery.
- Wrote coding using ASP.NET with C# .ASPX pages and parsed the XML files using the DOM
- Developed client modules to calculate the AMA Insurance claim.
- RIA implementation using AJAX.
- Used ASP.NET Web Forms, server controls extensively, setting up an inheritance chain of Forms following Object Oriented Programming Principles.
- Developed & Hosted Web Services using SOAP protocol in IIS.
- Created the Auto insurance claim module stored procedures.
- Created SSIS Packages for Data Import/Export.
- Stored the data’s into the XML file
- Used C# to develop Custom User Controls files to use the controls throughout the application for same look and feel and provide code reusability.
- Unit tested all the modules developed using NUnit.
- Designed Project build script for the application using NAnt.
- Designed and implemented formatted reports using Crystal Reports.
- Designed and implemented robust exception handler base classes for providing meaningful information to the user if some error occurs while using the application. It can provide short or details error information based on configuration settings.
- Troubleshooting has been done to make the robust application.
- Deployed the Server side pages with all the DLL’s used MSI installation project using VS 2005.
- Worked on the Production Support.
- Worked on CVS Versioning system for proper integration and safety.
Environment:.Net Framework, 2.0, C#.Net, ASP.Net, ADO.Net, AJAX, XML, DHTML, JQuery 2.0, IIS 6.0, SQL Server 2005, SSIS, Web Services, NUnit, NANT, Crystal Reports, Visual Studio .Net 2005, MS Word, MS Visio, MS Project, Windows 2003 Server, CVS.
Confidential, Aug 2007 – April 2008Confidential,Torrance, CA
Senior Consultant
Confidential, is a leading provider of advanced technology solutions. They are based in Torrance, CA with offices in multiple countries. Over a period of years the client details got duplicated and leaded to a “Data Integrity” problem, because of which the statistic and analysis report became inconsistent. To solve this problem a solution called “Black Box”. This Black Box Application cleanse the customer data which is present in various systems like CRM 2.0 and TSA – ERP, based on predefined & Custom Business Rules specified by the client.
Responsibilities:
- Identified the best possible solution for the data integrity problem.
- Collected all the requirements and the business rules which are required for validation.
- Designed a fully normalized Data Model for the application, using MS SQL Database.
- Designed the application for Use Cases using MS Visio and built the class level design using Visual Studio Class Diagram, which served as a base for development.
- The Application was designed based on OOPS and MVP Architecture for isolation of UI, Business Logic and DAL.
- Implemented Agile methodology and SCRUM framework for rapid development.
- Designed & Developed Forms using WPF using XAMAL Designer.
- Created Windows Communication Foundation Services (WCF) using C# & VS2008 and hosted in IIS to integrate the Business Rules of the application.
- Developed application business logics using WWF Windows Workflow Foundation.
- Developed REST – style interface for invoke the WCF Services with unique URL.
- Implemented Fuzzy Look up using SSIS packages which were required for many Business Rules.
- Implemented User Authentication.
- Implemented Windows Service using C#.Net. This Windows Service also includes Database level Business Logic implementation using LINQ to SQL.
- Extensively worked on queries, stored procedures and triggers in SQL Server 2005.
- Developed Grid View User control (WPF) using Dock Panel.
- Implemented “History and Roll Back” module and “External Application Adapter” module with C#.Net and advanced API Component execution with XML Configuration.
- Developed RIA implementation using MS AJAX Framework with Script Manager and Update Panel.
- Created complex Stored Procedures for Business Rule Management & triggers CRM Database SQL Server 2005.
- Developed SSRS Reporting Services where used to provide Statistics for the Marketing users using expression calculation.
- Writing NUnit tests to ensure quality code and to minimize the likelihood of errors.
- Designed Project build script for the application using NAnt.
- Designed Application Exception handling and logging mechanism.
- Developed Custom rules for FXCop.
- Worked on Production Support and troubleshoot the production issues using Bugzilla.
- Used CVS Versioning system for proper integration and safety.
Environment:.Net Framework 3.5, C#.Net, ADO.Net, WPF -XAMAL, LINQ, WCF Services, MS AJAX, Windows Services, SQL Server 2008, SSIS, SSRS, Visual Studio .Net 2008, XML, NUnit, NANT, FXCop, Bugzilla, MS Word, MS Visio, MS Project, Windows 2003 Server, CVS.
Confidential, Dec 2006 – Jul 2007
Confidential,Diamond Bar, CA
Programmer Analyst
Confidential, is a web based application designed to handle workflow that automates the end-to-end recruitment process of an organization, and to efficiently administrate employee payroll system. These major functionalities are captured in two modules namely EZRE and TIPS.
Responsibilities:
- Designed a fully normalized Data Model for the application, using MS SQL Database diagrams.
- Designed the application for Use Cases using MS Visio and built the class level design using Visual Studio Class Diagram, which served as a base for development. Business Rules of the application can be added or deleted by the administrator of the application.
- The Application was designed based on OOPS and three tire architecture for isolation of UI, Business Logic and DAL - Data Access Layer.
- Created the stored procedures for Candidate and Multiple Company Configuration modules.
- Developed Candidate, RQI Calculator Admin Configuration, Multiple Company Mapping and Time Entry modules.
- Developed User control components for Rich Internet Access using AJAX for user friendly search options in all modules.
- Created Web Services using proxy class with SOAP for Work Flow configuration module.
- Developed and created customized reports using Crystal Reports for Payroll, Invoice and Insurance status modules.
- Designed and Developed user interface using web forms and web controls with script.
- Created configurable XML Release Package batch file for production releases using Visual Studio .Net 2003 - Setup Projects
- Prepared unit test cases from functional requirements.
- Worked on implementation of Multiple Company Mapping module.
- Did Unit Testing, System Testing and Integration Testing of modules in the application.
- Responsible for writing the complex stored procedures using MS SQL Server 2000.
- Fine tuning of existing T-SQL queries and table index optimization to increase database performance.
- Worked on Production Support and Implementation.
Environment:.Net Framework 1.1, C#.Net, VB.Net, Win Forms, ASP.Net, ADO.Net, AJAX, IIS 6.0, Web Service, SQL Server 2000, Crystal Reports, Visual Studio .Net 2003, Browser Independent, MS Word, MS Visio, MS Project, Windows 2003 Server, CVS.
Confidential, March 2006 – July 2006
Confidential,Pondichery, India
Software Engineer
Confidential,pondichery a manufacturing unit for various tweezers and exporting to US and Canada. This system is based on ERP (Enterprise Resource Planning) Solution which tracks the Admin, Master, Sales, Purchase, Inventory, Production and Management Reports.
Responsibilities:
- Worked on the entire life cycle of the development starting from requirement gathering.
- Developed Work order planning, packing list and Invoice(sales, purchase) modules
- Developed the configurable User Control component for search Grid in all the modules with dynamic web controls.
- Developed Configure Users Authentication modules.
- Developed Java Script Dynamic Home Menu User Control component for role authentication.
- Worked in Architecture Design and Development
- Responsible for writing the complex stored procedures using MS SQL Server 2000
- Performing moderate to complex Coding/Programming tasks to specification and in accordance with development standards.
- Developed Crystal Library for converting the reports to PDF, EXCEL and WORD
- Created customized reports ad-hoc report for Invoice modules using Crystal Reports.
- Creating release packages for production releases using Visual Studio .Net 2003 - Setup Projects
- Deployed the setup in windows 2003 server and installed the MSI package of crystal report.
- Designed and developed prototypes at each module level
- Documenting and coding technical artifacts
- Fine tuning of existing SQL queries to increase database performance.
- Deployed the solution MSI installation project using VS.
- Worked on Production Support and Implementation.
Environment:.Net Framework 1.1, VB.Net, ASP.Net, ADO.Net, IIS 5.1, Crystal Reports, Visual Studio .Net 2003, SQL Server 2000, MS Word, MS Visio, MS Project, Windows 2000 Server, VSS
Confidential, Aug 2005 – Feb 2006
Confidential,Chennai, India
Software Engineer
Confidential,is a Data Service organization located in US and India. The Client converts hard copy books of many leading book companies to soft copy [E-Book]. The objective of the XML Editor is providing a HTML based UI editor to edit the XML file data. The hierarchical way of editing is XML provided by the user will get converted into HTML, based on the XSLT provided. This HTML can be edited in a WYSIWYG editor. On saving the changes done in the HTML is mapped back to the original XML.
Responsibilities:
- Member of application Design team to design the application architecture.
- Designed and Developed User authentication and authorization.
- Design and development of Web forms for XSD applied XML editing.
- Implemented Event handling on HTML Tagging page.
- Implemented AJAX for saving XML online.
- Implemented the multithread concept for WYSIWYG editor.
- Production Support.
- Worked in Visual Source Safe – Versioning System for proper integration and safety.
Environment:.Net Framework 1.1, VB.Net, ASP .Net, Visual Studio .Net 2003, IIS, MS Word, MS Visio, MS Project, Windows XP, VSS
Confidential, Nov 2004– Jun 2005
Confidential,Chennai, India
Software Engineer
Confidential,is an Export oriented unit, manufacturing various type of leather sheets, garments and export the same. EOP (Export Order Process) is the application developed to process the orders received from their customers. Based on the order, application could generate the Performa invoice, Customer Contract, Packing list, Buyer Invoice, Customs Invoice, Process declaration, Shippers letter of Instruction, Shipment intimation form and various types of export related documents.
Responsibilities:
- Designed and developed prototypes at each module level
- Developed Packing List, Customs Invoice, Bank and Insurance modules along with Crystal Reports
- Developed automated built system for setup a project.
- Created batch file for automated database backup and restoring in remote machines using DMO concepts.
- Did the Unit Testing, System Testing and Integration Testing of modules in the application
Environment: Visual Basic 6.0, SQL Server, Crystal Reports, Win NT/98 and VSS
Confidential, Feb 2003–Sep 2004
Confidential,Chennai, India
Software Engineer
Confidential,is one of the famous retail shops in Chennai with multiple branches. SMS needs to integrate the branches with the main system. Prelude Retail POS solution is framework addresses every requirement of the retail ecosystem in enterprise, stores and customer management resulting in overall improved business performance.
Responsibilities:
- Member of application Design team to design the application architecture.
- Designed user interface using forms and controls.
- Designed and Created crystal reports for inventory, sales purchase and report modules.
- Worked on Zed graph chart reporting tool.
- Created data conversion tool for converting old data to SQL server.
- Worked on the Production Support.
- Worked on VSS Versioning system for proper integration and safety.
Environment: Visual Basic 6.0, SQL Server, Crystal Reports, Win NT/98 and VSS.