eLIMS

eLIMS is a cloud based, HIPAA-compliant electronic platform that is developed specifically for managing laboratory orders (microbiology and radiation chemistry sections only), result tracking and requesting provider and patient reporting. With an eLIMS account, you will be given access to a client portal. From there you can access your account from anywhere to submit/manage orders and view laboratory results. Clients will be able to submit an order and receive results from/into an EHR/EMR system. eLIMS supports the use of HL7 standards for integration to EHR systems and billing applications to send the results to CDC, Association of Public Health Laboratories, and other public health networks.

Roles & Responsibilities:

• Involved in issue tracking.
• Involved maintenance.

My Contribution: Maintenance, bug fixes.

Omnia

Omnia is a highly efficient and easy-to-use cloud-based LIMS solution. Advanced core features include interfaces to any instrument/device, auto-verification, auto-coding, reflex testing, specimen tracking, role-based access, integrated physician portal for orders and results, auto-faxing and more. In addition, Omnia is easily integrated with your Electronic Medical Records solution, billing, and decision support systems.

Roles & Responsibilities:

• Involve in all the phases of the product development life cycle.
• Communicating with the client to understand the business requirements of these healthcare products.
• Doing option analysis for the best suitable full stack and cloud-native technology stack(AWS) for these software products.
• Implementing CI/CD pipelines for automated continuous delivery to different deployment environments.
• Implementing validations to reduce traffic, and improve efficiency of API and database tiers at all layers of code.
• Responsible for fixing security vulnerability issues at all layers of code and cloud.
• Looking after all Cloud Managed Services(CMS).
• Applying 5 pillars of cloud architecture to all our products from day 1 and their environments.
• Implementing cost optimization techniques on cloud and on-premise infrastructure.
• Mentor engineering teams on best patterns and practices.
• Code for nonfunctional requirements needed in our products.

My Contribution: Presales, Architect, Solution, Design, Analysis, Code, Mentor

• Responsible for cloud cost optimization and performing WAR analysis on AWS cloud infrastructure.
• Application performance tuning, ensuring best practices & coding standards with the team.

Ability & Clarity

CMS introduced new interoperability mandates for health plans that must be implemented by July 1, 2021. These include:

• Patient Access Rule - FHIR for members to share data with apps
• Provider Directory API - FHIR API for a provider directory
• Payer to Payer Data Exchange - Send and receive member data with other plans (Jan 2022)

This product offers Integrated FHIR Platform as a Service which includes

• Data transformation
• Data Harmonization
• FHIR API
• 3rd Party Access management
• Analytics

My Contribution: Presales, Architect, Design, Analysis, Code, Mentor, Solution, Hiring

Technologies: AWS FHIR works, fhirclient - python, Python, Flask, S3, Cognito, API gateway, AWS Glue, Open Search, FHIR - R4

SMART On FHIR

Strata Health’s native Smart on FHIR® application will allow clinicians to initiate, send, review, and complete post-acute referrals and requests electronically—directly from their hospital electronic medical record (EMR), including Epic® and Cerner®. Hospital systems deploying the Strata eReferral platform benefit from:

• Reduced cost and risk of patient transitions.
• Enhanced navigation and decision support.
• Shorter length of stay.
• Improved patient outcomes

My Contribution: Presales, Architect, Design, Analysis, Code, Mentor, Solution, Hiring

Technologies: Reactjs, FHIR-R4, fhirclient, Epic FHIR API, Cerner FHIR API, USCore IG, Material UI, Figma, Rhapsody, Oauth 2.0, OpenId, JEST, Puppeteer, React testing Library, EsLint, Sonarcube, AWS CI/CD - Cloud front, Code Pipeline, Code Build, github, ECS Fargate, ECR, Docker, JIRA, Confluence

LMS

AI based platform to interact with employees of any subscribed organization for their financial well being.

My Contribution: PreSales, Architect, Mentor, Solution, Hiring

• POC with the above tech stack & Design
• Quick on boarding the team to new technology.
• KT to a new team.

Technologies: telnyx, angular-11, node, xstate, postgreSQL, json rules engine

360 SYNC

A platform to sync files between different file storage providers ex: SharePoint, drop box, Bluebeam, Bim360 We can even schedule the sync process.

My Contribution: Design, Analysis, Code, Mentor, Solution, Hiring

• Quick on boarding the team to new technology stack Electron, Electron Forge
• Added share point modern authentication feature using azure active directory services
• Bim360 bugs, changed the integration methodology so that not only admins, members also can access the project

Technologies: Electron, React, Share point windows SDK, GraphQL, Apollo, Base web, Windows Forms, .net 4.7, NodeJS, Electron forge, TypeScript, Yarn, GitHub.

Ambulatory EMR

It is re-platforming EncounterPro, a legacy power builder App. A platform which will help health care providers in primary care. Has Scheduling, Task management and workflow. Idea behind this product is to automate the human workflow of providers or doctors. A UI flow change for the product which we developed in EMR app. Users will get notifications on their dashboard where the user or user group need to act on a workflow step.

My Contribution: Presales, Architect, Design, Analysis, Code, Mentor, Solution, Hiring

Technologies: Xstate, Json rules engine, .net core rest API, NodeJS, express, HASURA GraphQL engine, PostgreSQL (AWS aurora), Angular 10, AWS Cloud, AWS Cognito. AWS code build, deploy, pipeline. Docker. AWS fargate. AWS certificate manager. AWS autoscaling, AWS load balancing. AWS EFS. AWS Route53. AWS cloud watch logs. AWS CloudFront, AWS SQS, S3. AWS lambda. AWS code commit. SourceTree, Kubernetes.

COVID Drive

A platform which will help the laboratories to register patients for covid test, make payment online, download reports, consult with providers online. Provides a subset of Telehealth features Text Chat, Video chat, voice mail and voice chat. Have document scan and OCR features too. Employers can enroll their employees to get COVID test done.

My Contribution: Presales, Architect, Design, Analysis, Code, Mentor, Solution, Hiring

• Many highlights. A good design and architecture in a very short span of time, went live in 6 weeks.
• We are still adding many new functionalities to it.

Technologies: .net core rest API, PostgreSQL (AWS aurora), Angular 9, Nodejs Socket API, Socket.io (load balanced), Twilio Voice mail with encryption, Twilio SMS, Twilio Voice with voice mail, Twilio Video Call with recording, Stripe Payments, tiny URL implementation, IVR payments using Twilio voice, PCI compliance. Sync fusion angular controls. Docker. Twain. Barcode printing to (NETUM Label Maker - Bluetooth Thermal Label Printer Portable Barcode Printer) via android app.

AWS Cloud: VPC, EC2, Elastic Cache (Redis), SNS, Pinpoint, Textract, Connect (Call center), SES, PostgreSQL (Aurora), Kinesis video streams with WebRTC, DynamoDB, Cognito, Code pipeline, Lambda, API gateway, Fargate, Certificate Manager, autoscaling, load balancing, Cloud front.

Tools: Gitlab, SourceTree

VARADA

A platform which will help to get surveys done by the contestants of US elections on any campaign. Contestants can register, introduce survey workers, and office staff. It has real-time geo location tracking via android app.

My Contribution: Presales, Architect, Design, Analysis, Code, Mentor, Solution, Hiring

Technologies: Ionic Capacitor, Spring boot, PostgreSQL, Angular 9, AWS Cognito, Google charts, Angular Google Maps, Nodejs Socket, Socket.io (load balanced), AWS Elasticache (Redis), Elastic Beanstalk, Braintree Payments Gateway, Maven, QueryDSL, AWS CloudWatch logs, slf4j, Visual Studio Code, Android, IOS

Sunny Day fund (sunnydayfund.com)

A platform which can help employers and employees can contribute to savings for any planned financial goals. Has integration with (https://synapsefi.com) to do Account transfers. ACH accounts. Web hooks, Node jobs.

My Contribution: Analysis, Code, Mentor, Solution, Maintenance

Technologies: Angular 7, NodeJS REST API, PostgreSQL, Strapi framework.

AWS Cloud: VPN, EC2, Elastic Cache (Redis), code pipeline, Certificate manager, autoscaling, load balancing, CloudWatch logs, EFS, Cloud front, S3, Route 53, Secrets Manager, Aurora (PostgreSQL), Amplify, Workspaces, Work mail

Tools: Bitbucket. Source Tree, JIRA.

DICOM Image Processing

A platform which can help to view and review a DICOM image of an anonymized patient. Multiple providers can be invited and participate in a screen sharing session.

My Contribution: Presales, Architect, Design, Analysis, Code, Mentor, Solution, Hiring

Technologies: Survey.js, .net core, PostgreSQL, CornerStone.js, DICOM.net, Angular 7

Telehealth (tiny.piadvanta.com/MYNA/index.html)

A mobile app (Android, IOS) to facilitate telehealth, RPM (Remote Patient Monitoring), Pharmacogenomics.

My Contribution: Presales, Architect, Design, Analysis, Code, Mentor, Solution, Hiring

Technologies: Flutter, Dart, Bluetooth Enabled devices, WebRTC in Dart, kinesis video streams with WebRTC. Socket.io

EMR

Health care platform with ability to schedule, track, encounter, and US Insurance billing of patients. It has telehealth, RPM (Remote Patient Monitoring), Pharmacogenomics.

My Contribution: So many, a big list Starting from NFR to a matured product went live.

• Tablet Application for the providers
• Patient Portal
• Appointment Scheduling
• Provider Schedules Management.
• Facility Management
• Business Process Management
• Individualized Treatment Plans for Mental Health and AOD.
• Medication Administration
• E-prescribing (eRX), DoseSpot
• Full Integration with Lab System.
• Audit Logs
• Extensive Reporting
• Clinical Decision Support
• Document Management
• Insurance Eligibility Verification
• In-built Form Editor
• Standard Scales & Screeners for MH and AOD.
• Telemedicine
• Role & Resource-based Authorization
• Health Information Exchange
• Accessibility Centered Design - WCAG 2.0 Compliant
• HIPAA Compliant
• Data Migration Services
• ISO 12207 Compliant
• Presales, Architect, Design, Analysis, Code, Mentor, Solution, Hiring

Technologies: .net core rest API, PostgreSQL (AWS aurora), Angular 7,10, Entity Framework core, Angular Material, Sync fusion angular controls, Nodejs Socket API, Socket.io (load balanced), WebRTC, Co-Turn, Stripe Payments, Docker, Seri log, MongoDB, Dynamic web twain. ETL using SSIS.

AWS Cloud: VPN, EC2, Elastic Cache (Redis), Connect (Call center), kinesis video streams with WebRTC, Lambda, API gateway, Cognito, code pipeline, ECS, ECR, Fargate, Certificate manager, autoscaling, load balancing, CloudWatch logs, EFS, Cloud front, S3, Route 53, Secrets Manager, Aurora, light sail (word press), SES. Work mail, Amplify, AWS SSO, AWS managed Microsoft Active directory.

Tools: GitLab. Source Tree.

Rules Engine

A tool to validate US health insurance claim requests before sending them to trizetto. Project helped to onboard this client.

My Contribution: Option Analysis, Drools Engine Setup

Technologies: jBPM, Drools, Wild Fly, Java

Migration to AWS cloud

A suite of applications for nursing services. Migrating to AWS cloud and new tech stack.

My Contribution: Analysis, Design, Code, Mentoring, Solution

• UI Enhancements
• Migrate database (Oracle, SQL) from local to AWS using migration services

Technologies: AWS Migration Services, Oracle, SQL Server to AWS RDS, Aurora, ASP, ASP.net web sites to SPA with Angular 5 and .net core Rest API

Capacity Management System

This is a suite of applications to support hospital workflows. It includes various resource management activities including patients, beds & staff, auditing, reporting.

Total Team Size (Including QA & DEV): 40+

My Contribution: Analysis, Design, Code, Mentoring, Solution

• UI Enhancements
• Gave solution to on premise Component’s communication with SAAS version of APP
• Migrated to claims based security framework
• Enhanced CTI 32 based IVR flows and maintenance, created application to debug and host IVR at console to expedite the development process, to avoid dependency on HMP boards.
• Part in migration to Bitbucket and Jenkins, comfortable with groovy scripting in pipelines.
• Addressed the common navigation issues of hybrid apps/ SaaS model app with cross domain local storage with on premise app
• Critical Bug fixes, support items, Hot fixes
• Critical R&D items
• Migrated flash, silver light to HTML5
• Fake ADFS/Identity server for local development
• Hyper v solution for old HP QC
• Jasmine tests

Technologies: A hybrid application with ASP.NET Web Forms, MVC, Web API, MVVM, Silver light, Angular, Cross Domain Local Storage, Responsive UI, bootstrap, HTML5, CSS3, JQuery, Ajax, Single Page Apps (SPA) Approach, SQL Server 2016, Entity Framework, Mongo, CQRS, Autofac, Spring.net for DI & IOC, Surround, Bitbucket-SourceTree, GIT, CCNET, NANT, later moved to BITBucket-JENKINS, Octopus, Install shield for CI CD, Citrix, Azure cloud, CTI-32 based IVR, Rabbit MQ, Mass Transit, Windows workflow, custom workflows, Cloud Hosting, Ionic Framework, Silver light, Jasmin, phantom, NUnit, Karma, npm, node, Nuget, Micro services architecture, JIRA, Slack, X-Lite for IVR dialing, WCF, Web Services, Web API, REST, SOAP, Windows services, Self-Hosting WCF services, Redis cache, Azure Access Control service, Identity server for mocking ACS locally, Cross Domain Local Storage, Road map to SAAS model, Multi tenancy

Secure Base Porting

This is an internal application to support information management. It includes scheduling, auditing, reporting, and transportation. BPO will use this product for logistic operations. Current development activity is to upgrade platforms to new technologies to support devices.

Total Team Size (Including QA & DEV): 30+

My Contribution: Bug fixes in various modules, I have migrated a few crystal reports to a new platform, Implemented deployable candidate using Bamboo and NAnt

Technologies: Mobilize.net Web map, Responsive UI compatible with devices, bootstrap, HTML5 and CSS3, JQuery, Typescript, Single Page Apps (SPA) Approach, SQL Server 2012, UNITY for interceptors, Injections & IOC, ASP.NET MVC web Application, SAP crystal Reports, SVN, Bamboo, NANT for CI CD, Kendo UI for MVVM

HRWAR (HR Web App Re Platform)

A suite of supporting applications to people soft and SAP systems, which will get the feed from and feed back to upstream systems (SAP), involves integration within these set of HR applications. Current development activity is to upgrade the platform to new technologies to support devices and changing the integration with upstream systems from people soft to SAP.

Total Team Size (Including QA & DEV): 30+

My Tenure: JUNE-2014 to PRESENT

My Contribution: Solution Architecture for Server-side framework and components like reporting/Auditing/Exports/Business Rules/Validators, Application Architecture, Back End or Server-side Application Framework, Web API / REST Services, RestAngular.js, Integration with existing core systems for authentication / Authorization, HR Core, SSIS based integration and SSIS based Jobs, Best and simple Solution for SSIS packages. This is a migration of Old Oracle SQR based Jobs which were complex in design, SSRS Local Reports (This is an excellent solution Architecture) and Hand on Development of very nice drill down reports, Angular based UI development and Integration with Web API where as my contribution in integration and troubleshooting with UI issues, SQL based JOBS, Database migration from Oracle to SQL server (initial data loading and integration), LINQ based DAL & BAL, All sorts of POC (BizTalk, SSIS, SSRS, IOC tools, Memory profilers, Performance tuning, optimizations), Entity Framework Best practices, Decision making on technology and tools, Best solution for centralized auditing and performance tuning while loading for UI. Many innovations for various kinds of requirements. An excellent Solution Architecture, Many cost-effective solutions considering deployment restrictions in this tenure. Great working experience.

Tasks:

• Complete server-side framework.
• Decision making on Technology and tools for the above said framework.
• POCs
• SSIS integration. Initial data loading and re Platforming the old Oracle SQR based jobs.
• SSRS Reports
• UI Integration via rest angular.
• Back end nightly jobs to feed from upstream systems, data analysis, alerts, auto approvals and nightly jobs.

Technologies: Responsive UI compatible with devices, bootstrap, HTML5 and CSS3, JQuery, TokenManager.js for SSO, Angular.js based JavaScript UI framework, Single Page Apps (SPA) Approach, SSIS for integration with upstream systems and other applications of the suit, SQL Server 2012, Entity Framework based DAL. Database first, UNITY and Autofac for Injection & IOC. Microsoft OWIN for Web API & SSO Authentication and Authorization, ASP.NET MVC web Application, SSRS Local Reports, SVN

Bulk Movements Capture

A consolidated web-based application, managing stock inventory and movement transactions.

Total Team Size (Including QA & DEV): 30

My Tenure: JUL-2013 to June-2014

My Contribution: Solution Design, Develop and maintenance, Deployment, Preparing environments, Initially on Delivery Management, Understanding product, infrastructure and existing framework quickly, Interaction with product management team, Solution designing, gathering requirements and translate to a system, Mentoring team members, Resolve technical issues, Recruitment, Training, Code review, Visited Client place (Adelaide) and later supported my team from client place. Different work experience to work at a client's place, Best and fast problem solution approaches, troubleshooting in our very high workload phases.

Tasks:

• Initially into bug fixes and getting ramp up with framework
• Rendering extension for css
• Feature implementation
• Formula builder UI for creating and evaluating mathematical expressions to use in business rules. Includes a JavaScript based mathematical lexical analyzer. Evaluation is based on Reverse Postfix Notation.
• Introduced Telerik Date Time widgets.
• Pagination based on LINQ and Fluent nHibernate to improve performance
• TFS Merging.
• Introduced AJAX driven editable grids.
• Drop down check list jQuery based & DevExpress.
• Efficient usage of Injecting Controllers based on URL.
• Excellent debugging skills on issues.
• Data Design for features.
• Customizations required for DevExpress MVC extensions at both JavaScript level and razor syntax level.
• Effectively used Ajax framework in conjunction with DevExpress controls.
• TFS Merging.
• Best utilized JQuery features in day-to-day activities.
• Added handlers for nServiceBus into the framework.
• Added workflows and workflow activities to be invoked by nServiceBus handlers.
• Handled issues of workflow with IE.
• Custom validators.
• Excellent usage of JQuery (JavaScript) API. Really good.
• SSRS reports.
• Supported SignalR with injected simulators/data providers for real time data.

Technologies: WCF services as BAL & DAL, ORM (Fluent nHibernate, AutoMapper) based DAL with SQL Server Data Store with Repository pattern and LINQ, BAL with converters, mappers, and validators. All are Injectable, Castle Windsor to support Dependency Injection of controllers, Converters, Mappers, Validator, and providers, Interceptors for auditing, logging, sequential workflow triggering, Custom impersonation service, AzMan as authorization store, Custom Model binders to support validations, KnockOut.js for MVVM, Telerik/Kendo UI and DevExpress MVC extensions with custom binding, NServiceBus for Request queue processing, Nunit for unit tests, TFS Gated Check-ins, TFS for Source Control, SSRS reports, XSLT and XML based templates, SignalR for real time data push into web forms, JQuery Widgets and AJAX, NServiceBus, Windows Workflow Foundation for series of back end Activities, WPF based workflow editor, Pagination with LINQ and Fluent nHibernate, Custom Viewfinders (Views, Partial Views), Action resolvers, HTML MVC extensions for views to render view model, View model Annotations, state management, LESS for web UI theming.

MDM System

It was a client specific implementation of the Master Data Management product.

Total Team Size (Including QA & DEV): 9

Tenure: MAR-2013 to 14-Jun-2013

My Contribution: Design, Develop and maintenance

Tasks:

• Identifying problem solutions for client implementation.
• Identify need of data flow BR’s
• Decide on tradeoffs
• Coding Business rules for data flows
• Designing Human workflows (windows workflow)
• Code for custom web service API
• Custom UI to work smoothly on existing framework
• MVVM with Knockout.js
• JSON data transfer and JQuery Pages
• ASP.Net web methods

Technologies: Designing Data Model, Set business rules while data flow, Integration with client systems, Jobs and their profiles to integrate with and put in sync of external systems, Writing Web Service API, which is not available in existing frameworks, Design Human Workflows for data flow, Creating mappings for existing formatters to import data from external systems, Cloud environment (windows Azure)

Commercial Auto Insurance

Products for commercial auto insurance sales to get a quote and policy service to maintain policy.

Total Team Size (Including QA & DEV): 26

Our Client Implementation Team Size: 9

Tenure: JAN-2012 to FEB-2013

My Contribution: Mentoring team for all technical support, Design, development and maintenance, UI Development with MVP pattern and ASP.NET, DB Design, SSRS Reports Design and Develop, Automation jobs for letters through SSRS reports, MVP with web client application blocks, Good experience with maintenance projects, 3-Enhancement, 2-maintenance, and 1-platform upgradation releases, Handled performance tuning for WCF services and SQL DB, SSIS and SSRS, Did responsive coding and designs at SQL, HTML, ASP.NET web forms, WCF and for WEB pages and SSRS reports, App scans for security and performance loopholes, Good XSLT debugging.

Tasks:

• Design and Implementing Web UI according to spec.
• Printed US postal letter generation framework for policy letters and other documents using SSRS 2008 R2, SSIS and WCF as mediator. Many other projects started integrating this component. Got rewards from clients.
• New data store design for recurring payment methods.
• SSRS report templates for US postal letters, summary reports.
• SSIS package-based SQL agent job for automation of letters.
• Designed Eligibility, in Eligibility framework based on criteria of vehicles, which is reusable and plugged in to existing framework.
• Worked on complex UI widgets and integrated them with UI.
• Solved issues related to IIS7 migration
• XSLT changes in mappers of BizTalk
• SSL communications in BizTalk WCF send ports.
• Best utilized the existing MVP framework components for SSRS based Letter automation.
• Handled 3 releases of enhancements, 2 releases of maintenance and production support.
• Added 2 new framework components for new features.
• Handled cross browser issues.
• Handled platform upgradation to Windows Server 2008 R2 (IIS7), BizTalk Server 2010.
• Used SSO DB as configuration store for BizTalk Apps.
• JQuery UI widgets and custom UI controls on special requirements.
• MVVM with knockout.js in new overlay UI.
• Knockout MVC (JavaScript) to hit the facade layer for data exchange.
• JSON data interchange.
• Optimized ASP.NET rendering for GRIDS or Tables.
• Handled performance tuning at WCF, SQL, BizTalk, SSIS and SSRS component layers.
• Handled SQL deadlock issues.

Technologies: Web UI development with ASP.NET and JavaScript and JQuery using MVP pattern, BizTalk Based middle tier to communicate with external systems where it needs XSLT translation, SSRS 2008 R2 for Reports and SSIS 2005 for agent jobs of achieving automation and archiving, PCI compliance design for payment processing and storing secure information, SSRS Server reports, SSL Communication with external systems via BizTalk, Integration with Global portal, Web apps development for devices (tabets, mobiles) using knockout.js and KnockoutMVC (kmvc) and node.js (not much on this), Using history.js for mobile MVC apps to access browser history data, Used HTML 5 and knockout.js for Mobile web app ASP.NET MVC screens, In JQUERY pages, data exchange via JSON calls to REST and WCF web API for mobile web apps, Deployments with MSBuild and BTS Task, XSLT mapping at pipeline components, Less on Orchestrations more on pipeline components and WCF adapters.

HCP

Suite of products for Event Logistics (Web UI for Event Management).

Total Team Size (Including QA & DEV): 70+

Our Client Implementation Team Size: 6

Tenure: SEP-2011 to DEC-2011

My Contribution: R&D, UI Development with MVC pattern, DB Design, Troubleshooting Production Environment.

Tasks:

• Design and Implementing UI according to spec.
• Worked on client specific approval process with windows workflow.
• DB design for the above specified client specific approval process.
• HTML Report generation using XSLT

Technologies: Web UI development with Asp.NET and JavaScript and JQuery, Using MVC pattern, Worked with Windows Workflow to achieve approval process, Achieving Dependency Injection and IOC using Unity Application Blocks, Has separate implementations for each client achieved via DI.

ASCENDIS - COMMON MODULES

Suite of Financial products (BPM, Web UI for BPM, Back end processing jobs).

Team Size: 45

Tenure: Feb-2007 to AUG-2011

My Contribution: R&D, UI design & Development, DB Design, SQL Scripting, Troubleshooting with Production Environment, BizTalk Application Development, Design & Code Framework Components, Patterns & Practices

Tasks:

• Design and Implementing initial UI according to spec.
• Dynamic UI generation based on DB saved XML configuration with JavaScript validations and a lot more in one framework component. This completely removed the complex database-based Business rule maintenance. Got the best design award for this component.
• BizTalk application to trigger on Data events.
• Handled IBM MQ communication with BizTalk MQ adapter. I have used the IBM MQ library to send port pipeline components.
• Best approaches to handle large volumes of flat files.
• Developed Custom BizTalk Pipeline components with very good optimizations.
• SSIS packages to parse data in flat files and move to staging DB and then apply rules and move records to Live DB.
• Custom SSIS script task to invoke child packages and validating records.
• Custom Logging (used dtsEvents) approach to invoke SSIS packages from a web service call. Most innovative approach. Completely avoided custom SSIS logging component and added more value to the framework component in performance perspective in our multi-client runtime.
• Handled 32 bit/64-bit complications while executing SSIS packages.
• Handled caching issues with executing the same SSIS package for different parallel jobs for different clients with different flat file feeds.
• Worked on SSRS reports in local and server mode.
• Used SSRS web service API to execute and get report streams from SSRS server.
• Developed a dynamic master page with third party (Telerik) controls. This is reusable across other product teams.
• Developed a scheduler (SQL based) for BizTalk triggering. Got a value add award from a client.
• Implemented SQL paging to avoid delay in rendering ASP GridView. Optimized way of rendering HTML for responsive web pages.
• Implemented SQL logic to generate a flat file from XML columns.
• Integrated with PDF generation tools.
• Worked on JQuery Themes.
• Provided cross hair functionality in SSRS web report to facilitate record tracking. This is not out of the box available in SSRS reports. This is the great challenge we have faced from the mainframe team as this is available in their desktop app, where the similar functionality we provided in SSRS report with drill down SSRS report. This was the feature blocking us from client approval. Most innovative solution I have given.
• Handled cross site scripting issues.
• Handled Security issues like SQL Injection, Cross Site Scripting, and Encryption.
• Worked with nested master pages and themes.
• Extensive JavaScript usage with ASP.NET applications
• Well versed implementation of ASP.NET web applications to reduced web traffic with Ajax, JSON and JavaScript
• Third party ASP.NET controls from Telerik.
• Worked with performance counters of T SQL programming.
• Handled best ADO.NET approaches for distributed transaction handling and used enterprise application blocks.
• Handled performance tuning and deadlock issues.
• Worked with IIS7, http and net.tcp bindings
• Deployments with TFS continuous integration.
• Well versed with TFS versioning approaches.
• Well versed with .NET versioning and side by side execution.
• Handled maintenance of ASP/VBScript Application and fixed the issues related to IIS 7 deployment.

Technologies: Web UI development with Asp.NET and JavaScript and JQuery Themes, Integration solutions with BizTalk, WCF, SSRS and SSIS, As part of the Common Modules team, setting coding standards for better readability, performance, reusability, maintainability to other application teams, Provides integration platform and framework for Application teams, Prepare Deployment scripts with TFS integration, Provide components which are common across all co products, Provides abstraction to external systems, Common UI standards with JQuery, App scans for security and performance loopholes, .NET Application Embedding and Integration with ASP/VBScript, JSP/JavaScript Web Applications, where clients will come with their authentication layer and need to share authentication, Cross domain communication, Our BPO will use this product.

BR.NET

A web-based banking Solutions Product for medium scale banks including microfinance modules. This has 4 layered, multi-tiered architecture with a very fine optimized Ajax based Service Oriented Architecture web framework. It has full support for localization. Currently it is Supporting 3 Different Data Servers in Data Tier using data application blocks, Supports both centralized as well as Distributed Deployments, Supports all available kinds of ASP.NET security approaches, IIS6, ASP.NET 2.0, SQL Server 2005, Ajax, Web services, Best practices for security, scalability, and maintenance, Automated code generators for DAL, BAL layers, service contracts and service proxies.

Team Size: 45

Tenure: Mar-2006 to Feb-2007

My Contribution: R & D, Web form Development, Custom Control Development, Got very good opportunity to work framework components, Design & Code Framework Components, SQL Scripts

Tasks:

• JavaScript Custom Dialogs.
• Dynamic generation of web form Controls using classical method and XML / XSLT and Custom client-side validation.
• Custom controls in JavaScript (EX: Checked List Box)
• Web Service Security
• Localisations (Ex : Chinese, French etc).
• A TWAIN Library Compatible Scanning Control Which brings the Images from Attached Imaging Devices (Ex: Webcam and Image Scanner). Got very good recognition at my early stages of my career with a good hike in package. One of the best in my career.
• It is web deployment, integrating with .NET Framework Security (CAS Policy).
• Ajax and JSON based Uploading and bringing the Images Stored in Database.
• Simple Image editing feature provided with watermarking.
• First time working with SSL Communication.
• Part of Deployment Tool.
• Web form Development.
• Started learning and implementing Coding Standards, best Patterns & practices.

mediMan

This is HEALTH CARE, ERM Solution for Hospitals. This is 4 layered, 2 tier architecture. This is for large scale Hospitals, for their process Automation and ERP.

It developed with the tool to reduce the re-engineering burden. Windows based tool that improves productivity as support for above mentioned Framework for a healthcare project. This tool has the basic goal to reduce the re-engineering burden on developers, reusing the existing Framework for new projects. It has a back end independent framework. It contains fully customized windows controls to reduce validation burden. (Ex: Formatted date controls which all follows golden rules of UI, Auto complete drop-down lists, combo boxes, especially Data Grid) Fully automated data grid binding and In Row Editing which all reduce form changes. Common event handler master form architecture. This is also to reduce Development Burdon for common event handling like F1 – help, Save, F2-Look UP. But UI users can finish the transaction with a few keystrokes. No physical Existence of form designer files. All information regarding form will be dynamically loaded into the master form like SAP. Event handlers also will be added dynamically.

Team Size: 18

Tenure: Jan-2005 to Aug-2005 (Curriculum project and then First job)

My Contribution: Windows Form Development, validation, unit testing, verifying deployment environment.