• Having involved myself in raising the family, was also involved in mentoring college students in building their projects using SDLC methodologies.

• Assisting friends in their Research studies and scholar programs.

Projects Description: This project required a Warehouse Management System for one of the leading Retail giants of the USA. The existing Warehouse management system of the retailer was iteratively converted to the IDC logistics application. The different requirements spanned across the logistics businesses from Receiving, Order Processing, Order Filling, Movement of the Pallets in the Distribution Center, Shipping, billing and invoicing and Quality assessments.

Responsibilities:

• Involved in planning phase and in the technical feasibility study.
• Analyzed the requirements and prepared design documents using UML diagrams.
• Gather requirements and prepared functional & technical specification, task/schedule planning, Time estimating, and Project planning, design templates/reviews involved in Complete Project Life Cycle.
• Developed the Application using C# and VB.Net.
• Involved to develop the database schemas using IBM Informix dB on Unix environment.
• Created on user defined controls to extensively use across the User interfaces.
• Used C# and VB.Net Class libraries to create reusable components.
• Developed business objects applying OOPs Concepts using ESQL-C to interface with the User Interface and the backend data.
• Developed SQL scripts, Stored Procedures and views according to the business requirements.
• Involved in the creation and execution of Unit Test Case scripts during the development phase.
• Executed the Code Reviews of the team mates integrating best tools to have less discrepancies.
• Handled a team of 7 developers and coordinated with the onsite team regularly on a daily Agile methodology.
• Worked on sync with the Testing team to fix the Defects and handled the defect tracking system of the development teams.
• Lead the team by running weekly meetings to define, track and measure the action items involved in the system.
• Involved in bridging the team and the Project manager about the statuses of the project and the key milestones of the project.
• Played a key role in knowledge transitioning for the new comers of the project as it ramped up.
• Performed regular audits for the process documents in each and every phase of the development life cycle for requirements phase to UAT phase by the client.

Environment: Visio, C#, VB.Net, VS 2008, Informix and ESQL / C

Project Description

The Major Clients of Lorenzo includes National Health Service (NPfIT) - United Kingdom, North Saxony Telematics Group - German Govt., SingHealth - Govt. of Singapore.

Lorenzo is the core application widely acknowledged as the world’s premier healthcare information management solution. It is designed primarily to meet the administrative and clinical information management of healthcare providers with rich user interface using C# (Win forms) and ASP.NET (Web forms). Patient information is organized in a manner which allows the users to navigate rapidly and easily around the record with minimal effort by manipulating with XML. Lorenzo provides facilities for prescribing, referral, dispensing and clinical pharmacy services. Powerful and flexible chronology-based presentation enables clinicians for easy identification between disease and treatments. The system has been developed using Visual Studio .NET 1.x/2.0, C#, SQL Server 2000/ Oracle, XML in Windows 2000 Server/XP.

Projects Involved:

• Advanced Requests and Results:

This module involves in managing the Requests and Results created for a patient during his visit to a Care provider or a laboratory. The module supports creating request items in a customizable format for any Service Department and managing their textual, numeric or media kind of Results.

• Knowledge Based Clinical Requests:

This module involves in managing the Requests created for a patient during his visit to a Care provider or a laboratory. The module supports creating request items in a customizable format for any Service Department.

• Referral management

This module involves managing the Referrals created for a patient during his visit to a Care provider. The module also supports in recording referrals sent or received in the case of non-Lorenzo Systems. Allows the referrals to be viewed based on the rights to the User. It allows managing the referrals by a Care Provider supporting multiple views for the referrals.

• Multi Campus

Developed for the version, which was the second major release of the product Lorenzo-P1R2. In this version the module involved organizing the data based on its origin. In a HealthCare application the data may be generated from different hospitals across various geographical locations and multi-campus make sure that user is allowed to view the right data.

• Patient Banner

Patient Banner is a panel of information which displays the critical information about the Patient who is being treated by the care provider. Details of the Patient information like Demographics, Encounter Type, Patient History, Alerts and Allergies are displayed. Configuration for the display of the details in any particular order assumed by the care provider was also done as a part of Application Configuration – Patient Banner.

• Patient List

Patient List is one the foremost important functionalities in Lorenzo. In order to gain access to the various features involving Patient Management, the first step of the care activity involves Patient List. Any care provider who treats a patient can use the Patient List similar to a Favorites List in order to gain quick access to the patients. Different types of patient lists like Search Based List and Criteria Based List were developed. Criteria based list is the grouping of patients based on various categories like the Disease, Demographics, Referral, Health Organization, Encounters and Timeline.

• Application Configuration

Application Configuration involves the total customization of the product Lorenzo from the perspective of the Enterprise, Health Organization, User, and Workstation based on the reverse order of hierarchy. Features like loading of the Pages, Menus and Tabs can be configured throughout the product at all four levels. Column Configuration in Customized iSOFT Data Grid Control – the display order of the columns and multi column sorting was done. Interaction of Lorenzo with other iSOFT products or Third party products could also be controlled using Application Configuration. Adding User Preferred Webpages and Scientific/Medical Web pages pertaining to the disease suffered by the patient is also a part of Application configuration.

Role:

• Developed from a trainee to Module Lead role throughout the work experience in the company.
• Involved in the New module development, Issue fixing across the Product, Enhancement modules of the product leading to good understanding of the Service Oriented Architecture of the Product.
• Worked extensively with the business analysts, Other Development teams, Testing teams and Build Deployment teams of the Product.
• Involved in the defects analysis and statistics for the betterment of the projects.

Responsibilities:

• Involved in the complete Software Development Life Cycle (SDLC) for development process and AGILE, SCRUM including Analysis, Design, Implementation, Testing and Maintenance.
• Understanding and analyzing the client’s requirement.
• Prepared Technical design document, Use cases, Test cases and User manuals.
• Defined Use cases from requirements and helped convert them into software specifications.
• Developed Custom Controls and User controls for reusable part of the web pages using C#.NET with ASP.NET.
• Used Java Script extensively for Client Side Validations.
• Used CSS, Java script to develop and implement a user-friendly UI Design for the presentation layer.
• Developed Web Forms, user controls, custom controls for web applications using ASP.NET with C#.NET code behind classes
• Designed the UI using ASP.NET, HTML, DHTML, XSL, JavaScript, CSS and AJAX controls.
• Developed class files and components using C#.
• Created PL/SQL Stored Procedures, Views, Triggers and User Defined Functions for fetching relevant data to UI.
• Created data access components to access PL/SQL database.
• Generated SQL statements to feed in to database.
• Wrote Views, Stored Procedures in SQL Server 2005.
• Communicated and interacted on a regular basis with the Client, on site coordinators and development teams during different stages of the product life cycle.
• Performed Unit testing and System testing and prepared required documents and use cases for testing.
• Good at Bug fixing and Code reviews.
• Worked on troubleshooting issues and documentation.

• Involved in Deployment and Troubleshooting issues in the application.
• Performed unit testing and documenting the respective results.
• Extensive use of ASP.Net Caching, Debugging and tracing
• Implemented Stored Procedures, Triggers, Joins, and Views in SQL at the backend level
• Used customized ADO.Net for server side scripting to communicate with the Database
• Coordinated with the deployment team to deploy the new code in production.

Environment: XML, C#, ASP.Net, VS 2008, SQL Server and Oracle