| Candidate Information | | Title | Software Development Sql Server | | Target Location | US-TX-Dallas |
| | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidatePROFESSIONAL EXPERIENCEOver 20 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 PackagesGood 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 GatewaysoBFSI: SAP integration with Sale Tax Filing system, Learning and Employee Central system, Finance ModulesoAccounting: Invoice, Billing, Payments, Individual Tax compiling, PayrolloEnterprise Systems: Secure E-Mail application, Support data content, Employee Central, Learning Management systemsHaving 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 EXPERTISEProgramming 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 XSLTEDI Standards: H7v2, HLv3, CCD, CDA, DICOM, EDIFACT, X12, eb-XML, HIPAAGUI: IntelliJ, Eclipse, Visual Studio, Team Suite, Visual studio CodeDatabase: 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, JMeterApplication Server: WebSphere 8.5, IIS 8.5, ApacheCloud Platform: Azure, AWS, Rackspace and googleIntegration Servers: BizTalk, Axway, MailGate, CA Automic Workload Automation, Boomi,e-Gate, Mirth, CloverleafUI Frameworks : ReactJs, Angular and JQueryUIPROJECT PROFILESCargillRole: Senior Full Stack Developer, Minneapolis, MN, USAPeriod: June 2022 CurrentEnvironment: 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 DogCargill, 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 profilesProcess 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 serviceDeveloped 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 updatesEnhance the configuration and capabilities for the API to able to deploy both in could and data centerMake the API capable of connecting to Postgres or SQL Server based on the environment need to the application deployment model neededUsed 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 deploymentRole: Senior Full Stack Developer, Minneapolis, MN, USAPeriod: Nov 2021 - May 2022Environment: 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 gatewayCargill, 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 requirementsMaintain 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 SMEs, 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, USAPeriod: May 2021- Oct 2021Environment: .Net core 5.2, C#, OCR web capture, React JS, Postgres, Lotus notes, Abby Flexi Capture, Docker, Kubernetes, Data dog, Kong gatewayCargill, 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 processDevelop, 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 needsRole: Senior Full Stack Developer, Minneapolis, MN, USAPeriod: March 2020- April 2021Environment: .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 gatewayCargill, 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 APIs 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 APIs 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, USAPeriod: August 2019- Feb 2020Environment: Spring Boot 2.19, Java 8, AWS Cloud, GitHub, Hadoop Impala, Postgres,h2, JPA, Swagger, OData, drone, Docker, Kubernetes, Data dog, Kong gateway, IBM AnalyticsCargill, 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, USAPeriod: Feb 2019- August 2019Environment: .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 AnalyticsCargill, 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 centralDesign, 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 ADDesign, 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 applicationDeveloping 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 renderingCapitalOneRole : Full Stack Developer, Plano, TX, USAPeriod : May 2018 Jan 2019Environment: .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 PostgresCapitalOne, 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 databaseSupported and developed new chef-based configuration management and Jenkin continuous integration model for AWS EC2 deployment model and security configurationsModified Batch processing Platform to integrate and communicate with AWS S3 buckets and cloud boxes for work flow automation using Automic Work Automation toolWorked with cross platform team to complete new integration models and enhancement for NPI and PHI data encryption and tokenization requirements.Halwes LLCRole : Solution Architect, Plano, TX, USAPeriod : Jan 2018 Apr 2018Environment: .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 members 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 GatheringDiscuss the UI Requirement and member flow requirement to create an application flow and dashboard requirementCreated PWAs based design to support seamless rendering for UI on different device and browsersFinalization 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 updatesDesignoCreate 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 requirementsoDesign core modules to interact with external connected device, payment gateway and legacy application data integration pointsDevelopmentWorked 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 DesignDeveloped REST (Representational state transfer software architectural style) based HTTP CRUD (Create - Post, Retrieve - Get, Update - Put, Delete - Delete) functionality for all configuration-based entity objectsDeveloped and enhanced module for Web based plug-ins for interface with external device for card reader, card scanner, web camera, receipt printer and signature padWorked on system integration with third party API and external data sources to integrated with legacy systemsCreate 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 modelBuild the information architecture and collaborate with stakeholders to create conceptual user interface designs through high fidelity prototypesHPRole : Sr. Software Developer, Plano, TX, USAPeriod : May 2017 Jan 2018Environment: .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, AzureHP 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 GatheringoParticipate in discuss with enterprise architects, support and operational heads for understand the daily operational requirementsoTalking 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.DesignoEnhance or modify existing data base structure to accommodate new support model and customer servicesoData Preparing, data cleansing, master data updates, data uploading and data distributionoTechnical Design SpecificationoDevelopment 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.DevelopmentoRestful web services using .Net, C#, WCF, LinqToSql and SQL Server 2012oStore Procedures and SSIS packages for data migration using SQL Server 2012oDeveloped and enhance versioned based services for supporting legacy and new incoming systems at enterprise level based on the company operational modelsoDeveloped schedule-based task and packages for data integration point of view based on system needsoEnhanced and updated existing windows-based application to deal with new data flow requirements, data values and data entitiesoEnhanced the data Entities to support new database changes as well as incoming and outgoing systems.SYSTEM SOFT TECHNOLOGIESRole : Application Architect, Plano, TX, USAPeriod : February 2014 April 2017Environment: .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 GatheringoAnalyzed CMS specification and gather functional requirements from businessoDiscuss and documented technical specifications after discussing with various stakeholdersoCreated Business stories and story points for developing ACO and Bundle Payment functionalityDesignoLogical Database Model and Physical Database ModeloData Migration PlanoTechnical Design SpecificationoDeveloped design patterns for Front End views, Application level services, Restful Web services and Rule Engine data processing services.DevelopmentoRestful web services using .Net, C#, WCF, LinqToSql and SQL Server 2012oBusiness Rule Engine using C#, Windows Service, Multithreading and Message QueuingoWF engine for processing interface load on given schedule from different source into the application and dispatch the database to different Targets based on user configurationoUI rendering service for dynamic UI creation based on context configuration as well as Validation and CRUD operation services based on Business Entities configurationoWeb 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 formatoFront end using MVVM pattern using jQuery, HTML5, AngularJS 2 and Telerik ControlsoUtilities: Canned reports for Monthly auditing using High chartsoStore Procedures and SSIS packages for data migration using SQL Server 2012oWorked on the data cubes and BI Reporting using SSAS, web services, Sync fusion Pivot Grid and Pivot ClientoWorked on create and configure channels for data integration with EMR and HIE data using HL7v2 and CCD documents using Mirth integrationProject ManagementoEstimation of the development effort and assign of task for individual developersoUsed Version One to create agile project planoCreated tasks for individual stories for each iterationShell Oil CompanyRole : Application Architect from IBM, Houston, TX, USAPeriod : October 2012 January 2014Environment: .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 GatheringoAnalyze legacy system to understand the Tax reporting requirement and auditing requirementsoGathering functional and Technical requirement discuss and finalization of software requirement and toolsoCreated Business stories and story pointsDesignoReviewed Logical Database Model and Physical Database Model design with system architectoDesign and development of Data Migration and Maintains PlansoTechnical Design and Functional Specification DocumentationoDesign patterns for Front End, Restful Web services and Rule EngineDevelopmentoRestful web services using SQL Server 2008 R2, .Net, LinqToSql, C#, WCF and Web API methodsoBusiness Rule Engine using C#, Windows Service, Multithreading and Message QueuingoWF 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 formatoFront end using MVVM pattern using jQuery, HTML5 and Telerik ControlsoUtilities: Canned reports for Monthly auditingoStore Procedures and SSIS packages for data migration using SQL Server 2012Project ManagementoEstimation of the development effort and assign of task for individual developersoUsed Version One to create agile project planoCreated tasks for individual stories for each iterationHumana IncRole : Development Architect, Louisville, KY, USAPeriod : August 2011 Sep 2012Environment: .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.6Humana, Inc. is a leading health insurance company offering health insurance to Military, |
