Software Development Sql Server

PROFESSIONAL EXPERIENCE

Over ** years of software development experience in analysis, design, architecture, developing, testing and implementing business applications for various domains using Object Oriented programming concepts.

Good knowledge on the Enterprise integration engines like CA Automation, CI\CD Automation, BizTalk, Boomi, e-Gate, MDM, Mirth and Cloverleaf.

Possesses a solid understanding of Business Process Management, Rule based Processing, Enterprise application design, Business Domain Model definition and UML Design Patterns.

Experience in Database Analysis/Design/Normalization/Manipulation processes using SQL Server, Oracle, Postgres and MySQL. Extensively involved in writing Stored Procedures, Triggers, Functions, Indexes and DTS Packages

Good experience in developing software application using XML, XSLT, WSDL, UDDI, SOAP, Client-side libraries, Enterprise Libraries, Reporting Services, AJAX, JSON, Web Forms, MVC, Windows Services and Web Services, Restful service, Web API and Micro Service.

Involved in developing and design of integration software engines that support different communication protocols like File, TCP/IP, SMTP, SOAP, HTTP and Message Queuing using service oriented architecture.

Hands on experience writing test scripts for testing tools like JMeter, Selenium, QTP, Load Runner and Test Directory.

Worked on Enterprise Application Blocks such as Data Access, Exception Handling, Security and Caching.

Extensive experience in defining the Interface Specification for below systems:

oHealth Care: Hospital Management System integration with EMR systems, Practice Management and Real time Claim adjudication systems, Claim Processing, Population health Management and Quality Analysis, Bundle Payment Flow, Payment Gateways.

oRetail: Self-service check-out System integration with Point of Sale, Payment Gateways

oBFSI: SAP integration with Sale Tax Filing system, Learning and Employee Central system, Finance Modules

oAccounting: Invoice, Billing, Payments, Individual Tax compiling, Payroll

oEnterprise Systems: Secure E-Mail application, Support data content, Employee Central, Learning Management systems

Having good experience in understanding and implementing EDI data standard in healthcare, retails and insurance industry using specification like FIHR, HL7v2, CCD, HL7v3, DICOM, EDIFACT, X12, eb-XML, OPOS, JPOS and ARTS.

Excellent communication skills, strong organization and interpersonal skills and a very good team player, capable of working independently with minimal supervision and perform as part of a team.

PROFESSIONAL / TECHNICAL EXPERTISE

Programming Languages: Advanced Java, PL/SQL, TSQL, C#, VB.NET, ASP.NET, ASP, Visual Basic, Visual C++

Development Frameworks: .net core 6.0/5.0/3.1/2.2, JRE, spring boot, .NET Framework 1.0 to 4.6.2, WCF, Web API, WPF, WF, MVC, MVVM Windows mobile and iOS,

Scripting Languages: JavaScript, jQuery, Signal-R, Knout Out, Angular, React-JS, VBScript, Bootstrap and TCL.

Markup Languages: HTML5, DHTML, XML, XSL and XSLT

EDI Standards: H7v2, HLv3, CCD, CDA, DICOM, EDIFACT, X12, eb-XML, HIPAA

GUI: IntelliJ, Eclipse, Visual Studio, Team Suite, Visual studio Code

Database: SQL Server, Oracle, MySQL and Postgres.

Source Code Control: Visual Source Safe, Team Foundation Server, SVN, GitHub, Nu-Get, Source of Site 4.0, CM Synergy.

Reporting Tools: Crystal Reports, Data reports, MS-SQL Server Reporting Services.

Testing Tools: Load Runner 6.0, QTP 9.0, Selenium, JMeter

Application Server: WebSphere 8.5, IIS 8.5, Apache

Cloud Platform: Azure, AWS, Rackspace and google

Integration Servers: BizTalk, Axway, MailGate, CA Automic Workload Automation, Boomi,

e-Gate, Mirth, Cloverleaf

UI Frameworks : ReactJs, Angular and JQueryUI

PROJECT PROFILES

Cargill

Role: Senior Full Stack Developer, Minneapolis, MN, USA

Period: June 2022 – Current

Environment: Net Core 6.0, Azure AD, AWS Cloud, Data Center, SAP API, SQL Server 2019, Postgres, Open ID Connect, Layer 7, Kong, ReactJS, Vela, Vault, Windows Server 2017, Docker, Kubernetes, Data Dog

Cargill, to accommodate Russian data compliance based recent development in the country, has come up with solution which handles front end capabilities of SAP front end for HR data reading and writing for daily business needs using ReactJS for front end application and capable of connection to backend API which can connect to SAP API to pull master data and transaction data for maintain update data for personal information, job information, payroll and work permit data. Daily updated from the local database will be written to import data templates for each Portlets, which process by Data management team as part of business continuity plan.

Understanding of exist business logic for maintaining of HR related data in SAP for creating, updating and termination of User profiles

Process of the Master data to accommodate transaction data for viewing, editing and updating the data in the front end.

Creating entity object to each portlet object to simulate the SAP import and export object to make Business continues process very easy on daily basis for data sync.

Developed authentication flow to support various roles of data operation, data import and data exports using Open ID connect authentication flow using Azure AD service

Developed various API endpoints using net core 5.0, C#, Swagger, LINQ, Core Entity Framework for accommodate CRUD operation on various portlet for daily HR operations.

Developed various windows and web service for accommodate data sync operation with SAP to load master data updates and produce daily load feed for various Portlets updates

Enhance the configuration and capabilities for the API to able to deploy both in could and data center

Make the API capable of connecting to Postgres or SQL Server based on the environment need to the application deployment model needed

Used CI/CD pipeline for deployment to AWS cloud using Vela, Vault, Captain, x-Ray, Veracode, Docker and Kubernetes and Terraform.

Use IIS, SQL Server, Windows server, and file share for data center deployment

Role: Senior Full Stack Developer, Minneapolis, MN, USA

Period: Nov 2021 - May 2022

Environment: Net core 5.0, Azure AD, AWS Cloud, GitHub, Salesforce API, Postgres, Hadoop, Impala, C#, ASP Net core, Web API, MVC, React JS, Material UI, OpenID Connect, Vela, Vault, Docker, Kubernetes, Data dog, Kong gateway

Cargill, has created a mega project to build it commodity trade platform form exist mono lithic platform to microservice based disturbed system that can be host in cloud infrastructure in AWS and capable of access from inside and outside Cargill using Azure AD authentication dashboard base multiple layers and context-based application access. Microservice are integrated with enterprise level Trading domain model in Cargill Data platform to excess and updated data need to exercise commodity trading needs using Hadoop and Impala. They are also interacting with existing and further ERP system like LYNX, SAP and Salesforce as need to complete the Trading offers and Procurement. The UI framework is built using Mono Repo style build for central of different application using dashboard like application which provide access to multiple application single navigation point using Azure AD authentication and authorization using configurated entitlements. UI Storybook has been built to achieve same look and feel across multiple application and user context.

Understanding of the eco system and landscape of overall solution authentication models for different endpoint with different applications in external and internal to enterprise and deployment to particular region requirements

Maintain database to support the user enrollment flow and error handling and documentation flow of the application for various business user context.

Enhance authentication flow to support user based and client-based flow using OpenID authentication flow for Internal SME’s, Trading Partners and external user for Trading commodities on daily basis.

Developed authentication flow to support user based and client-based flow using OpenID Authentication flow using Azure AD service for Internal Cargill user for support microservice integration ERP application and Hadoop Domain model database using Impala.

Developed various API endpoints using .net core 5.0, C#, Swagger, LINQ, Core Entity Framework, to accommodate Business user to access data for Trading communities on daily transaction and consolidation the procurement of commodities.

Developed various service based ruled base service engines using .net core 5.0, C#, Azure AD, LINQ, Core Entity Framework, Postgres database. Support and maintain the data sync process between Cargill and partner data service for data analytics for Trade platform assessment for Cargill needs. .

Used CI/CD pipeline for deployment to AWS cloud using Vela, Vault, Captain, X-ray, Veracode, Docker and Kubernetes and Terraform.

Role: Senior Full Stack Developer, Minneapolis, MN, USA

Period: May 2021- Oct 2021

Environment: .Net core 5.2, C#, OCR web capture, React JS, Postgres, Lotus notes, Abby Flexi Capture, Docker, Kubernetes, Data dog, Kong gateway

Cargill, For modernization effort for retail delivery process want to automate various validation process including end product label to avoid recalls and transportation. In order to achieve that required for label scan using web capture and reading of product and customer data on the each label using back end OCR reader and validating data feed from product specification data to Postgres database.

Understanding of the enterprise network infrastructure and landscape of overall solution to decide on the workflow for web scan and integrating back to OCR process application.

Establish and define process for data feed from product specification and validation process for different kind of labels and product standards and customer needs.

Design and develop database to support product specification information and user authentication and data validation process

Develop, assess the technical feasibility of various OCR model for web capturing and OCR templating, processing and synchronous response back to web application.

Access and quantify where various license need for Web capture and OCR processing needs

Role: Senior Full Stack Developer, Minneapolis, MN, USA

Period: March 2020- April 2021

Environment: .Net core 5.0, Azure AD,OKTA Access Management, AWS Cloud, GitHub, Salesforce API, Dell Boomi, Postgres, Hadoop, impala, C#, ASP Net core, Web API, MVC, Bootstrap, JQuery, CSS3, OpenID Connect, drone, Docker, Kubernetes, Data dog, Kong gateway

Cargill, In partnership with other Agriculture supply chain has established Partner external solution where farmer can be login to single location to border view of overall profitability as well as gain access to recommendation on commodities to hedge their risks. To build risk management strategy each partner in the Grainbridge solution need to supply their Locations, Cash bids, Contracts, Settlements and Customer Account and authorization details for Cargill customer for opt-in and opt-in of the partner solution. Based on the existing relationship Cargill will feed data continuously to partner company for data analysis for risk management. Data feed is done using Message based integration services, which will intern will use custom developed API’s which maintain the user account and authorization information by interacting with Salesforce API and Grainbridge Application for customer Opt-in/Opt-Out process integration. Customer API’s have endpoint for Message based integration service handling of process load and Error handling while feeding the data to Grainbridge. Custom development also support Admin website for support team to handle user enrollment, account management, and integration handling processing for troubleshooting. Apart from data service for analysis, the partner application also provide document service for customer to see their existing contract and settlements.

Understanding of the eco system and landscape of overall solution to decide on the workflow and authentication models for different endpoint with different applications in external and internal to enterprise.

Design and develop database to support the user enrollment flow and error handling and documentation flow of the application.

Developing authentication flow to support user based and client-based flow using OpenID authentication flow using OKTA service for external user and client application from partner user portal application.

Developed authentication flow to support user based and client-based flow using OpenID Authentication flow using Azure AD service for Internal Cargill user for support admin portal and client application for integration purpose.

Developed various API endpoints using .net core 5.0, C#, Swagger, Okta, LINQ, Core Entity Framework, to accommodate external partner users to opt-in/opt-out process from there portal application and maintain the data in Postgres database and also sync with Salesforce application changes for user accounts and contact information.

Developed various API endpoints using .net core 5.0, C#, Swagger, Azure AD, LINQ, Core Entity Framework, Postgres database to log. Support and maintain the data sync process between Cargill and partner data service for data analytics for risk management assessment for Cargill customers.

Developed various API endpoints to integrated and support user request for existing or new document for contracts and settlements by integrating with enterprise data using Hadoop and impala and by calling enterprise document service. This endpoint has been developed using OKTA, C#, .net core 5.0, swagger, LINQ, HADOOP, Impala ODBC connection.

Developed Admin application using .net core 5.0, asp.net, C#, bootstrap, jQuery, data table and moment.js, Identity Management, Razor and LINQ.

Used CI/CD pipeline for deployment to AWS cloud using Drona, Captain, X-ray, Veracode and Valet, Docker and Kubernetes and Terraform.

Role: Senior Full Stack Developer, Minneapolis, MN, USA

Period: August 2019- Feb 2020

Environment: Spring Boot 2.19, Java 8, AWS Cloud, GitHub, Hadoop Impala, Postgres,h2, JPA, Swagger, OData, drone, Docker, Kubernetes, Data dog, Kong gateway, IBM Analytics

Cargill, Human resource IT, want to enhance and update the employee API to streamline the Global IT billing by moving data to Hadoop platform and securing the employee profile API by enabling OAuth and SSO Token based source of client application.

Understand existing employee API and different client application needs.

Migrating the existing spring boot version from 1.5 to 2.19 and enhance the code to support different enterprise level tracking and monitoring modules to support cloud deployment.

Developing Single sign on pattern for application to authenticate the user form AWS cloud platform using domain credentials using OpenID Connect design pattern and using Access token to authentication restful API behind Kong gateway.

Communicate and discussing with existing application to align API capabilities and data requirement as per enterprise requirements.

Discuss, align and created a deployment pattern for hosting application in AWS cloud, which is managed by Kubernetes and hosted in Docker container using CI/CD mechanism.

Role: Senior Full Stack Developer, Minneapolis, MN, USA

Period: Feb 2019- August 2019

Environment: .Net core 2.2, Azure AD, AWS Cloud, GitHub, SAP API, Postgres, Mango DB, c#, ASP Net core, Web API, MVC, Bootstrap, jQuery, CSS3, React JS, OpenID Connect, drone, Docker, Kubernetes, Data dog, Kong gateway, IBM Analytics

Cargill, Digital Learning Experience initiate was to enable employee worldwide to access their learning platform tool both inside and outside the corporate network and outside from different mobile devices. For achieving that goal, they want to create a centralize ECO system which manage and track the user learning progress, habits and aggregate different course across multiple learning like SAP Employee Central, LMS, Degreed, Intrepid, LinkedIn. Based on the user role and access able pull different compliance, recommended and subscribed course, navigate in and out third party system using SSO with Azure AD.

Understand different Learning management system and business use for employee training and compliance needs.

Understand the API capabilities of different LMS system and user profile data from employee central

Design, Develop and integrate new enterprise level gateway application which can host in AWS cloud and can be access anywhere from any device using single sign on integration with Azure AD

Design, Develop and deploy Web API restful service, which can aggregate, communicate and map data from all the learning management system using XAPI, OData and authentication data to pull data from vendor-based systems-based user credentials and permissions.

Developing and enhancing various UI design layout created by UX design team for web application

Developing Single sign on pattern for application to authenticate the user form AWS cloud platform using domain credentials using OpenID Connect design pattern and using Access token to authentication restful API behind Kong gateway.

Communicate and discussing with various application vendor to align API capabilities and data requirement as per enterprise requirements.

Discuss, align and created a deployment pattern for hosting application in AWS cloud, which is managed by Kubernetes and hosted in Docker container using CI/CD mechanism.

Worked on the PWDs UI design to support multiple browsers, languages, and device support for UI rendering

CapitalOne

Role : Full Stack Developer, Plano, TX, USA

Period : May 2018 – Jan 2019

Environment: .Net 4.5, ASP.Net, C#, MVC 5, Angular 5, Web API Restful Web service, GitHub, Chef, Jenkins, AWS Cloud, EC2, S3, ELB, IAM, Splunk, Route 53, Automic Workload Automation, Batch Processing, SSIS Package, SQL Server 2012 and Postgres

CapitalOne, want to migrate there existing enterprise wide auto loan servicing platform and batch processing applications from datacenter to AWS cloud environments.

Enhanced and upgraded existing asp.net application to integrated with new enterprise wise restful json web service instead of soap-based xml web service.

Changed the soap base xml web service to interact with cloud-based database instead of on premises database

Supported and developed new chef-based configuration management and Jenkin continuous integration model for AWS EC2 deployment model and security configurations

Modified Batch processing Platform to integrate and communicate with AWS S3 buckets and cloud boxes for work flow automation using Automic Work Automation tool

Worked with cross platform team to complete new integration models and enhancement for NPI and PHI data encryption and tokenization requirements.

Halwes LLC

Role : Solution Architect, Plano, TX, USA

Period : Jan 2018 – Apr 2018

Environment: .Net 4.5, ASP.Net, C#, MVC5, Web API Restful Web service, Entity Framework 6, Bootstrap, JQuery, CSS3, AngularJS 4, Kendo UI, SQL, Visual Studio, Windows Server, GitHub, Card Printer, Card reader, Web Cam, Signature Card, Scanner, Printer.

Halwes LLC, want to develop quick solution for managing member’s registration, check-in, payment, wait management and service fee collection and office user management. They also required reports for End of day, Monthly and Usage report for different clinical and service business they own.

Requirement Gathering

Discuss the UI Requirement and member flow requirement to create an application flow and dashboard requirement

Created PWAs based design to support seamless rendering for UI on different device and browsers

Finalization of external devices like card reader, camera, Driving License scanner, signature pad, receipt printer and document scanner.

Interaction with payment gateway provider and existing application vendor to create interfaces for member management and payment module updates

Design

oCreate application platform to support interaction with multiple device and multiple entity requirement based on the application module configuration and work flow rules configuration from the front end.

oDesign database model to support multiple office locations, users and data flow requirements

oDesign core modules to interact with external connected device, payment gateway and legacy application data integration points

Development

Worked on single page application (SPA) that reduce round tripping, and enhance User Experience (UX) using Kendo UI, JSON, AJAX, JavaScript, jQuery, JQuery mobile, Bootstrap CSS Framework, AngularJS 4, CSS3, HTML5, Mobile First, Responsive Web Design

Developed REST (Representational state transfer software architectural style) based HTTP CRUD (Create - Post, Retrieve - Get, Update - Put, Delete - Delete) functionality for all configuration-based entity objects

Developed and enhanced module for Web based plug-ins for interface with external device for card reader, card scanner, web camera, receipt printer and signature pad

Worked on system integration with third party API and external data sources to integrated with legacy systems

Create Business Data Model classes and use Entity Framework Fluent API to create DB Context to Add, Update, Get and Delete the transactions from the database created based on the business data model

Build the information architecture and collaborate with stakeholders to create conceptual user interface designs through high fidelity prototypes

HP

Role : Sr. Software Developer, Plano, TX, USA

Period : May 2017 – Jan 2018

Environment: .Net 4.5, ASP.Net, C#, MVC 5, Entity Framework 6, WCF and Web API Restful Web service and Microservice, PL/T-SQL, SQL Server 2012, IIS 8.5, Visual Studio 2015, Windows 2012 Server, TFS, LinqToSql, Azure

HP Inc, has acquired the Samsung printers. As part of merge of two entities, Integration of enterprise systems and service for continue of sales and service of existing Samsung printers and customer through HP operation is important activity. For that purpose evaluating existing system of two entities is important. Finding a data integration point and preparing the data for data upload and data flow between systems is important task.

Requirement Gathering

oParticipate in discuss with enterprise architects, support and operational heads for understand the daily operational requirements

oTalking to technical team about the data source and data point for that system to be operational.

oCreating solution documentation and data service requirement to share with different team for implementation planning and preparing the data for merge and service integration.

Design

oEnhance or modify existing data base structure to accommodate new support model and customer services

oData Preparing, data cleansing, master data updates, data uploading and data distribution

oTechnical Design Specification

oDevelopment of new or enhancement of data service, versioning of the data points and services.

oProposing solution for constraints created due to globalization, environment, application, and master data during the merging and operation of the systems.

Development

oRestful web services using .Net, C#, WCF, LinqToSql and SQL Server 2012

oStore Procedures and SSIS packages for data migration using SQL Server 2012

oDeveloped and enhance versioned based services for supporting legacy and new incoming systems at enterprise level based on the company operational models

oDeveloped schedule-based task and packages for data integration point of view based on system needs

oEnhanced and updated existing windows-based application to deal with new data flow requirements, data values and data entities

oEnhanced the data Entities to support new database changes as well as incoming and outgoing systems.

SYSTEM SOFT TECHNOLOGIES

Role : Application Architect, Plano, TX, USA

Period : February 2014 – April 2017

Environment: .Net 4.5, ASP.Net, C#, MVC 5, WCF and Web API Restful Web service and Microservice, Azure cloud Services, Html 5, jQuery, CSS3, Bootstrap 3, AngularJS 2, PL/T-SQL, SQL Server 2012, IIS 7.5/8.0, Ajax, Visual Studio 2013, Windows 2012 Server, Telerik Kendo UI, Sync fusion, High Charts, TFS, LinqToSql.

System soft technologies is developing an Enterprise solution that will leverage its business application into consolidated solution. As part of current solution it requires changing the existing department standalone and independent system Enterprise and cloud based solution supporting portable user interface and capable of support dynamic configuration business model and work flow engine for changing enterprise and legal need from immigration and business development and implementation need of IT consulting company needs.

Requirement Gathering

oAnalyzed CMS specification and gather functional requirements from business

oDiscuss and documented technical specifications after discussing with various stakeholders

oCreated Business stories and story points for developing ACO and Bundle Payment functionality

Design

oLogical Database Model and Physical Database Model

oData Migration Plan

oTechnical Design Specification

oDeveloped design patterns for Front End views, Application level services, Restful Web services and Rule Engine data processing services.

Development

oRestful web services using .Net, C#, WCF, LinqToSql and SQL Server 2012

oBusiness Rule Engine using C#, Windows Service, Multithreading and Message Queuing

oWF engine for processing interface load on given schedule from different source into the application and dispatch the database to different Targets based on user configuration

oUI rendering service for dynamic UI creation based on context configuration as well as Validation and CRUD operation services based on Business Entities configuration

oWeb application which can be used by business team to define dynamic Data definition and Model configuration for storing data from different source system and different format

oFront end using MVVM pattern using jQuery, HTML5, AngularJS 2 and Telerik Controls

oUtilities: Canned reports for Monthly auditing using High charts

oStore Procedures and SSIS packages for data migration using SQL Server 2012

oWorked on the data cubes and BI Reporting using SSAS, web services, Sync fusion Pivot Grid and Pivot Client

oWorked on create and configure channels for data integration with EMR and HIE data using HL7v2 and CCD documents using Mirth integration

Project Management

oEstimation of the development effort and assign of task for individual developers

oUsed Version One to create agile project plan

oCreated tasks for individual stories for each iteration

Shell Oil Company

Role : Application Architect from IBM, Houston, TX, USA

Period : October 2012 – January 2014

Environment: .Net 4.0, ASP.Net, C#, MVC 4.0, WCF and Web API Restful Web service, Html 5, jQuery, Bootstrap 2, PL/T-SQL, SQL Server 2008, IIS 7.0, Ajax, Visual Studio 2010, Kendo UI, TFS, LinqToSql,

Shell is a leading oil and energy producer in United States which has downstream and upstream business for producing and selling the Oil and Gas across the Globe. Shell has globally upgraded their downstream business SAP R3 implementations to Global SAP (GSAP). To report the daily transactions to various Tax Authorities, Shell wanted to create a Global application (USTIL – US Tax Integration Layer) which Transform, Translate and process Transaction to file the all the Volume/Value Taxes on a given schedules.

Requirement Gathering

oAnalyze legacy system to understand the Tax reporting requirement and auditing requirements

oGathering functional and Technical requirement discuss and finalization of software requirement and tools

oCreated Business stories and story points

Design

oReviewed Logical Database Model and Physical Database Model design with system architect

oDesign and development of Data Migration and Maintains Plans

oTechnical Design and Functional Specification Documentation

oDesign patterns for Front End, Restful Web services and Rule Engine

Development

oRestful web services using SQL Server 2008 R2, .Net, LinqToSql, C#, WCF and Web API methods

oBusiness Rule Engine using C#, Windows Service, Multithreading and Message Queuing

oWF engine for processing interface load on given schedule from different SAP implementation and prepare data for monthly tax reporting to County, State and Federal Authorities and integrated the data with Tax filling system.

oFront end using MVC pattern using jQuery, HTML5 and Telerik Controls and consuming restful web service.

oUser authentication and authorization model for accessing web application and accessing Tax database their role.

oWeb application which can be used by business team to define dynamic Data definition and Model configuration for storing data from different source system and different format

oFront end using MVVM pattern using jQuery, HTML5 and Telerik Controls

oUtilities: Canned reports for Monthly auditing

oStore Procedures and SSIS packages for data migration using SQL Server 2012

Project Management

oEstimation of the development effort and assign of task for individual developers

oUsed Version One to create agile project plan

oCreated tasks for individual stories for each iteration

Humana Inc

Role : Development Architect, Louisville, KY, USA

Period : August 2011 – Sep 2012

Environment: .Net 4.0, ASP.Net, C#, MVC 3.0, WCF, WPF, Java Script, PL/T-SQL, SQL Server 2008, Java 6.0, EJB, JBoss 6.0, Apache 2.0, Data Power, XML, SMPT, XSLT, IIS 6.0, jQuery, HTML 5, CSS3, signal-R, Ajax, visual studio 2010, Eclipse 3.6

Humana, Inc. is a leading health insurance company offering health insurance to Military,

Contact this candidate