Home

PIYUSHKUMAR - .NET Architect - 16+ Exp

[email protected]

Location: Euless, Texas, USA

Relocation: YES

Visa: H1B

Piyushkumar Gopalbhai Patel Email: [email protected] Phone: +1 913 828 3021 Summary: Over 16 years of professional IT experience full life cycle development in designing, developing, deploying and implementing Web-based and Client-Server Applications using. Net Framework. My Day-to-Day Responsibilities of a .NET Full Stack Developer with expertise in C, C++, C#, VB.NET, ASP.NET, MVC, Web API, REST-API Services, Windows Azure, DevOps, ADO.NET, Entity Framework,Azure Data Factory(ADF), SSIS, ETL, ELT, jQuery/Angular, .NET Core 3.0+ and SQL SERVER 2022, PostgreSQL, Oracle and PowerShell. Application Development: Design, develop, and maintain web applications using C#, VB.NET, ASP.NET, and .NET Core, ensuring high performance and responsiveness. Implement features and functionalities in accordance with project requirements and specifications.Develop new products and solving practical computing problems. Front-End Development: Create and maintain user interfaces using technologies like HTML, CSS, JavaScript, jQuery, and Angular. Ensure that the web application is visually appealing, user-friendly, and responsive across various devices. Back-End Development: Build and maintain server-side components using ASP.NET, MVC, and Web API, handling business logic and data processing. Implement RESTful APIs using Web API for communication between the front-end and back-end systems. Experience in API design /development from scratch. Database Management/SSIS/SSRS/ETL/ELT/Azure Data Factory: Strong knowledge of SQL Server Integration Services (SSIS) and SQL Server databases. Proficient in writing complex stored procedures, user defined functions, T-SQL scripts and Triggers using SQL SERVER and Oracle 18C. Design and maintain databases, including the use of Oracle, to manage data efficiently and securely. Optimize database queries, manage data models, and ensure data integrity. Experience in designing and developing Databases in SQL Server 2019, PL/SQL and Oracle database, which includes the development of functions, stored procedures, views, and triggers. Extensive experience with Extract Transfer Load (ETL) processes and data migration. Extraction, loading, and transformation (ETL) of data by extracting data from multiple sources, such as CSV, SQL Server database, Oracle database, and Excel files using SSIS. Perform data cleansing between systems Designed and developed SSIS packages to move data from various sources into destination flat files and databases. Experience in designing and developing Reports & ETL solutions using SQL Server SSIS/SSRS/SSAS Expertise in Azure, Azure Data Factory (ADF).Create, edit, and delete data factories and child resources including datasets, linked services, pipelines, triggers, and integration runtimes. Deploy Resource Manager templates. Resource Manager deployment is the deployment method used by Data Factory in the Azure portal.ELT (Extract, Load, Transform)Working on Extract, Load, transform (ELT) is the process of first extracting data from different data sources, then loading it into a target data warehouse. Microservices: Break our existing monolithic applications into more modern microservices. Provide input on our architecture, databases, and APIs.Consult with product managers to define, scope and plan new features. Define best in class standards to aid in guiding microservices based architectural decisions.Unit test and take responsibility for the quality of your own code.Test, evaluate and recommend technologies to improve our overall solutions;Develop and build microservices leveraging Azure Cloud Services;Work with QA to ensure that cohesive, quality, usable solutions are produced. Production Support:Identify, diagnose and find ways to resolve the issue and collaborate with other team members to address the problem.Analyze various metrics and logs to understand the reason for system failure or non-performance. Using different debugging and diagnostic tools find solutions to improve software performance.identify potential improvement areas in the production system and implement suggestions such as code optimization and enhancement of the production infrastructure. Windows Services: Create and maintain Windows Services for background processing tasks, such as scheduled jobs and data synchronization. Version Control: Use version control systems like Git to manage code changes and collaborate with team members effectively. Debugging and Testing: Identify and resolve issues and bugs in the code, performing thorough testing and debugging. Write unit tests to ensure the reliability of code. Performance Optimization: Continuously monitor and optimize the performance of the web application and database to ensure optimal user experience. Security and Compliance: Implement security best practices to protect sensitive data and ensure compliance with industry regulations. Regularly update security measures to stay ahead of potential threats. Documentation: Maintain clear and comprehensive documentation of code, configurations, and processes for future reference and team collaboration. Analyze and solve complex problems: Analyze complex problems and develop solutions using algorithms and data structures using my knowledge of computer science to develop efficient and effective solutions to problems. OOPS: Working on implement OOP concepts include abstraction, encapsulation, inheritance and polymorphism. Maintenance and Support: Provide ongoing maintenance and support for existing applications, addressing user issues and enhancing functionalities as needed. Research and Learning: Stay up-to-date with the latest trends and technologies in the software development field, especially in the .NET ecosystem, to continuously improve skills and knowledge. Project Management: Participate in project planning, task estimation, and progress tracking, ensuring that development tasks align with project goals and deadlines. Troubleshooting: Quickly identify and resolve technical issues, both in development and production environments, to minimize downtime and maintain system reliability. Cloud Computing (Azure): Develop and maintain Web Applications and databases in Azure environment. Perform migration processes to or from Azure environment Design, develop, and maintain automated build, test, and deployment pipelines Monitor and troubleshoot system performance and availability Implement and maintain continuous integration and continuous delivery systems using CI/CD Pipeline. Educational Details: Master of Computer Applications from Bhavnagar University, Gujarat, India, 2006. Bachelor of Science in Computer Science from South Gujarat University, Gujarat, India, 2003. Certifications: Advanced SQL. Angular Creating and Hosting Full Stack Site. SQL Server: Reporting Services. Technical Skills: Languages: C#, Java, C, C++, HTML, Unix Databases: Microsoft SQL Server 2022/2019/2015, Microsoft SQL, MySQL, Oracle, MS Access Reporting Tools: Crystal Reports Web Technologies:.Net Core 7.0/6.0, Angular 14/12/10/7, ASP.Net, C#, VB.NET, ADO.NET, WEB API, Azure, Azure Data Factory, Entity Framework, Typescript 4.0, MVC4, Web Services, REST API, LINQ, ADO.Net, XML, MVC4, ASP, HTML, HTML5, CSS3 and CSS, XSL, Ajax, jQuery, JSON, JavaScript, Node JS Development Tools: Visual Studio.NET 2022/2019, Visual Studio Code 2022, SQL Server Management Studio Visual Studio Code, SSIS, SSRS Version Control / Project Management: Git, TFS, VSS, Basecamp, Azure Boards Web Servers: IIS (Load balanced Web Farm, Application pools) Operating Systems: Windows Server Debugging Tools: Firebug, Visual Studio, Fiddler Security: JWT authentication, OAuth 2.0 Deployment/Integration: Continuous integration and continuous delivery (CI/CD) with Azure DevOps API Platform: Postman, Swagger Software Development Methodologies: Agile, DevOps, Waterfall Design Pattern: Singleton, Factory Procedural Language: PL/SQL Professional Experience: .NET Architect | California Student Aid Commission, Sacramento, CA | Nov 2022 Till Date Responsibilities: Architecture, UI design and coding using Angular 14, TypeScript 4.0, Node, CSS3, HTML5 and .NET Core APIs for creating the web application. Implemented Azure Logic Apps for creating and processing the Express packaging workflows automation. Designed an automated deployment Azure DevOps CI/CD pipelines that reduced deployments time from 1 hour to 10 minutes. Implemented Azure Service Bus to process queued deployable applications, sending emails, planned and break-fix deployments. Working on gathering, documenting, and clarifying software requirements. Translate business requirements and established architectural patterns into detailed designs. Development code experience with Docker and Kubernetes Used Entity Framework Core for migration and database connection. NuGet package development and delivery Manage NuGet package for NET. core It enables developers to create, share, and consume useful NET libraries. Develops enhancements and support services on existing code and understands the customer business process to troubleshoot reported problems. Performs all aspects of the software development lifecycle (SDLC). Implemented CRUD functionality with Entity framework in ASP.NET MVC and implemented sorting, filtering, and paging with Entity framework in MVC. Involved in advanced JavaScript/Ul frameworks like Angular 10, Bootstrap and JQuery. Coded extensively using JavaScript MVC Framework AngularJS to make rich internet web applications for a Single page app. Designed and developed secure .NET web services utilizing Windows Communication Foundation (WCF) to facilitate seamless integration between disparate systems, ensuring data confidentiality and integrity. Implemented RESTful services (Web API) using .NET framework to enable efficient communication and interoperability between web applications, mobile devices, and third-party platforms. Involved in Oracle database management and PL/SQL packages including schema design, performance tuning, and administration tasks. Extensive experience in developing PL/SQL packages, procedures, functions, triggers, and cursors for various business needs. Designed and implemented robust system architectures using .NET framework, ensuring scalability, reliability, and maintainability of enterprise-level applications. Engineered custom solutions utilizing .NET technologies to meet specific business requirements, optimizing performance and resource utilization. Creating complex stored procedures using a linked server, CTE, temp table, SQL joins, ranking functions and dynamic SQL and responsible for performing t-SQL tuning, multi-tasking, and optimizing queries which takes longer time in execution with SQL server. Developed core functionality with C#.NET, ADO.NET. Involved in ASP. NET MVC pattern: Controllers, Actions, View Engine, Entity Framework Model and the Windows Workflow Foundation Developed comprehensive technical architecture documentation outlining system components, interfaces, and interactions based on thorough analysis of business requirements and industry best practices. Developed the Data Access Layer using the ADO.NET and Entity Framework following the code first approach. Performs all aspects of the software development lifecycle (SDLC). Creating complex stored procedures using a linked server, CTE, temp table, SQL joins, ranking functions and dynamic SQL and responsible for performing t-SQL tuning, multi-tasking, and optimizing queries which takes longer time in execution with SQL server. Worked extensively with SSIS to import, export, and transform the data between the linked servers. Resolve development issues that occur during the testing of existing projects. Implemented JWT token-based authentication to secure the ASP.NET core Web API and provide authorization to different users. Implemented modern security authentication managers and protocols such as SAML / OAuth / Certificate Authorization. Develops new features in complex, object-oriented, multi-tier, or Web applications. Translate business requirements and established architectural patterns into detailed designs. Develop and maintain Azure cloud infrastructure, including virtual networks, storage accounts, and virtual machines. Environment: Visual Studio 2022/2019, Angular 12, Typescript 4.0, REST API, ASP. Net Core7 (C#.Net), MVC, WEB API, LINQ, Entity Framework, JavaScript, SQL Server 2019, DevOps, Azure Data Factory and Azure. Senior .NET Developer / SQL - Lead Developer | Roadzen, India | Apr 2016 Nov 2022 Description: Roadzen is building technology infrastructure that powers the global insurance economy. Award-winning AI research producing industry-leading models in telematics, computer vision, language models and generative AI focused on insurance for mobility. Start-up Roadzen, which has emerged as a major global auto insurance technology company powered by artificial intelligence (AI), has been listed on NASDAQ. Its ordinary shares trading on the Nasdaq Global Market under the symbol "RDZN" web: https://www.roadzen.io/ Project #1: StrandD - On Demand Roadside Assistance Responsibilities: Lead above mentioned entire projects assign work item to our team members (6-7 employees). Working on Requirement analysis and divided entire project in number of modules like Signup Module, Login Module, Incident Module. Messaging Module, Operator Module, Vehicle Module, Communication Module, Service Provider Module, Insurance Module, Payment Module etc. Created a use case and design documents as per requirement analysis. Created Database ER diagram based on three components: entities, attributes, and relationships. -Discuss requirement with product development team and create a work item in Basecamp tool according to discussed requirement. Implemented MVC pattern with Angular.JS and jQuery-validation and Extensive use of components registration. Design and develop web application in C#, ASP.Net MVC 3.0, web services and Entity Framework . Create a project and Configure Project structure. Adding a source control GitHub, create a Model, Configure Entity Framework package. Created a DB Context and Configure Entity Framework code. In Application setting configure connection string and secret ex. payment, send grid, API end points, SSL Secrete etc. and register application Db Context to program class file. Create a database using code first approach of entity framework and complete migration of database with SQL Server. Invoked Crystal Reports from VB, C#, and .NET applications using appropriate integration methods, such as Crystal Reports Viewer controls and API calls. Implemented data visualization techniques within Crystal Reports to present insights and analytics effectively to stakeholders. Utilized Crystal Reports features such as parameterized queries, subreports, and dynamic formatting to create interactive and customizable reports. Administered .NET-based systems, overseeing deployment, configuration, and monitoring of applications to ensure uninterrupted service availability. Conducted thorough troubleshooting and root cause analysis to resolve complex issues within .NET applications, minimizing downtime and enhancing user experience. Create a controller class and write a code to perform crud operations and access web API for handles user It retrieves data from the Model and renders view as response. Added Data Annotations to define the rules for the model classes or properties for data validation and display suitable messages to end users. Translated complex business requirements into clear and concise technical specifications, ensuring alignment with organizational objectives and regulatory compliance. Discuss with developers for assignment work as per requirement and assign items to particular developer as per their expertise knowledge. Review code written by developer and optimize the code for increase quality and reduce execution time. Create a number of test cases and test code manually as well as using selenium tool. Reassign the work to respective developer if work item is not exactly work as expected and test cases. Asking developer to complete work in given deadline and help developer to facing any issues in development. Responsible for solving complex code challenge and developer facing coding issues during development. Retest the code properly and mark the work item ready for deployment process and commit the code in git hub. Manage the code using Source code management tool Git. Create a primary branch master where all the production code is stored and create a number of another branch where all the development and stagging environment code is stored. Project #2: My Assist Application Description: Discussed with various clients like HPCL, BPCL and BHARTI AXA. created a separate application My Assist merchant application for HPCL dealers to enable them to sell my Assist plan at their fuel stations. Provides services to access roadside assistance features as per subscription. Project #3: Reliance Anywhere Assist - RSA Description: Create application RSA Sign up for a free account for Reliance policy users and request for assistance in seconds with this easy to use and simple app roadside assistance. Provide service to access Reliance insurer users to access roadside assistance features. We check vehicle insurer policy is expired or not. If its policy is not expired or it renewed, we allow access our roadside assistance functionality to reliance users. I discussed reliance anywhere assist team and manage this project as per requirements. Project #4: xClaim Description: Automated Smart Claims Management- xClaim is an end-to-end claims management platform that enables insurers to fast-track motor claim processing. xClaim's loss assessment and damage estimation tool utilize computer vision to automatically determine the severity of damage and calculate repair costs, helping you minimize claims processing times from weeks to only a few hours. I handle Back- end part and perform service side lead for this project. Responsibilities: Develop Web Applications using Single Page Application Architecture using Angular 10, TypeScript 4.0, CSS3, and HTML5. Performs all aspects of the software development lifecycle (Agile Method). Coding implementation Involve In writing, modifying, and testing code and scripts that allow web applications to function properly. Implement code as per OOPS programming methodology and Design Pattern. Written code for web-service implementation and called WEB-API methods from the front end. Written WEB-API code base to build a cross-platform application (Mobile App and Web Client). Work on SQL SERVER Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user-defined data types and functions for this project. Developed SSIS Packages for migrating data from Staging Area of SQL Server 2015 to SQL Server 2019. Build Restful Web API for front-end application consumes and manipulations. Dedicated to applying principles of Agile management to projects and tasks. Software Maintenance - changing, modifying, and updating software to keep up with customer needs. Championed numerous enhancements to existing web applications, including upgrading the backend from SQL Server 2019 to 2022, converting older visual Studio asp.net application to 2022 and web server upgrades, and creating web services/RESTful Services in C#.Net to meet various business requirements. Software Maintenance - changing, modifying, and updating software to keep up with customer needs. Testing- Conducted end-to-end testing before the application was released to production, troubleshooting for program errors in existing systems. Implemented database standards and naming conventions for the database objects. Worked with developers to tune the SQL queries using SQL Profiler. Performed database consistency checks. Developed Database Backup Scripts and automated this process. Responsible for Solved critical production problems. Testing Web-API using the Postman tool. Implemented modern security authentication managers and protocols such as SAML / OAuth / Certificate Authorization. Deployment of Web and Mobile Applications and Databases to Azure Cloud Production environment. Designed and implemented a monitoring and alerting system using Azure Monitor, resulting in a 30% reduction in downtime. Implemented and maintained Azure Active Directory, improving user management and access control for cloud-based applications and services. Use Azure Key Vault to securely store and manage sensitive information, such as application secrets. Working on Azure Web Application, Mobile Application, and Services deployment process and allocating resources and applying best features of Azure for increased security. Storage all types of unstructured data like audio, video, and images are adaptable with Blob. Perform End-User testing before deploying an application to production to reduce the impact and error in production. Create documents to keep track of various stages of production incidents and for production deployment. Notification of Production Error, Investigation or Analysis of Production Error, Resolution of Production Error Analyze Web application source code to identify the coding issue and communicate with the development team for resolution. Provide 24 7 operational support to all production Environments on holidays and weekends. Coordinate with various teams and raise support tickets for all issues, analyze root causes, and assist in the efficient resolution of all production processes. Created admin tool and company website with ASP. Net Core 7.0 (C#.Net), Angular 10 using Typescript 4.0 to create Directives, Components, Services, Pipes, form validators, and routers for multiple components utilizing Router Guards and Navigation. Involved in PL/SQL programming, including complex queries, joins, subqueries, and optimization techniques for efficient data retrieval and manipulation. Proven track record in optimizing Oracle tools, SQL queries and PL/SQL code for enhanced performance and scalability, utilizing indexing, query tuning, and execution plan analysis. Run Web application code step by step in a debugging tool like Visual Studio, to find the exact point where the developer made a programming mistake and then understand what corrections the developer needs to make in application code and resolve it quickly. Created a log file to track server errors and identify application errors. Migration of database from local to production Azure SQL Server. Debugging code to resolve existing issues for finding the root of a problem in a code base and fixing it. Working on Software Enhancements - modifications or improvements made to the existing software application code and store procedures code to improve the performance of the web application/mobile applications. Working on increasing SQL Server stored procedure performance to reduce the overall execution time of store procedure. Review the web application code to optimize web application performance. Environment: Visual Studio 2022/2019, Angular 10, Azure, Typescript 4.0, ASP. Net Core 7 (C#.Net), MVC, WEB API, LINQ, Entity Framework, WPF, JavaScript, Azure Mobile Web service, jQuery, SQL Server 2019, JSON, XML, Postman, GIT, Azure Blob Storage, Windows Azure, DevOps. Senior .Net Developer | Avacara, Pittsburgh (Offshore from India) | May 2010 Mar 2016 Domain: Health Description: Product: Yogastart Avacara build product Yogastart. It is an early stage one-stop-shop for finding and booking alternative healthcare services including yoga, massage and nutrition. We make it easy for people to find and book alternative healthcare services from providers while enabling these providers to meet new clients and easily promote and sell their services online. Product: Sanaview Created Web Application an early stage one-stop-shop for finding and booking alternative healthcare services including yoga, massage, and nutrition. We make it easy for people to find and book alternative healthcare services from providers while enabling these providers to meet new clients and easily promote and sell their services online. Responsibilities: Prepare Architecture and implementation of the applications in the Azure, on-premises environments. Design Restful API with best practices that conform to specific architectural constraints, like stateless communication and cacheable data. Work with business analysts, technical leads, and developers to overview the solutions and discuss technical challenges. Involved in developing web roles with rich UI using ASP.NET MVC 5, HTML 5, CSS, jQuery, JSON, WEB. Designed dynamic web pages using ASP.NET MVC, HTML5, CSS3, JSON, and Visual Studio. Developed custom tools to automation testing for a data loading. Guided the team to develop web roles using ASP.NET MVC 5, HTML5. Coding implementation Involve In writing, modifying, and testing code and scripts that allow web applications to function properly. Implement code as per OOPS programming methodology and Design Pattern. Written code for web-service implementation and called WEB-API methods from the front end. Written WEB-API code base to build a cross-platform application (Mobile App and Web Client). Work on SQL SERVER Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user-defined data types and functions for this project. Invoked Crystal Reports from VB6, C#, and .NET applications using appropriate integration methods, such as Crystal Reports Viewer controls and API calls. Integrated Crystal Reports seamlessly with VB6, C#, and .NET applications to provide comprehensive reporting functionality within existing software solutions. Implemented robust security measures to protect Protected Health Information (PHI) within the applications. Collaborated with cross-functional teams to ensure the accuracy and security of health data throughout the development lifecycle. Provided technical expertise and support in resolving issues related to healthcare data handling and transformation processes. Documented and maintained detailed records of coding practices and procedures to facilitate auditing and compliance assessments. Implemented data encryption and access control mechanisms to safeguard sensitive healthcare information. Implemented performance tuning techniques, including code optimization and database query optimization, resulting in significant improvements in application responsiveness and throughput. Executed preventative maintenance tasks to proactively identify and mitigate potential system vulnerabilities, ensuring the security and integrity of sensitive data. Collaborated with stakeholders to gather and analyze business requirements, identifying key functionalities and user workflows to inform the design and development process. Build Restful Web API for front-end application consumers and manipulations. Created admin tool and company website with Angular using Typescript to create Directives, Components, Services, Pipes, form validator, and Router for multiple components utilizing Router Guards and Navigation. Dedicated to applying principles of Agile management to projects and tasks. Software Maintenance - changing, modifying, and updating software to keep up with customer needs. Create a Responsive Website Using HTML5, CSS 3 & JavaScript. Building interactive and engaging user interfaces for web applications that can easily be upgraded and scaled to meet new business needs. Implemented complex business logic within Oracle databases, leveraging PL/SQL features such as cursors, stored procedures, packages, triggers and exception handling to optimize performance and maintain data integrity. Coding implementation Involve In writing, modifying, and testing code and scripts that allow web applications to function properly. Implement code as per OOPS programming methodology and Design Pattern. Written code for web-service implementation and called WEB-API methods from the front end. Written WEB-API code base to build a cross-platform application (Mobile App and Web Client). Software Maintenance - changing, modifying, and updating software to keep up with customer needs. Testing- Conducted end-to-end testing before the application was released to production, troubleshooting for program errors in existing systems. Implemented database standards and naming conventions for the database objects. Worked with developers to tune the SQL queries using SQL Profiler. Performed database consistency checks. Backup recovery schedules and backup database scripts. Developed Database Backup Scripts and automated this process. Solved critical production problems. Deployment Project and Database on Azure Server. Testing Web-API using the Postman tool. Deployment of Web and Mobile Applications to Azure Cloud Production environment. Perform End-User testing before deploying an application to production to reduce the impact and error in production. Create documents to keep track of various stages of production incidents and for production deployment. Notification of Production Error, Investigation or Analysis of Production Error, Resolution of Production Error Analyze Web application source code to identify the coding issue and communicate with the development team for resolution. Provide 24 7 operational support to all production Environments on holidays and weekends. Coordinate with various teams and raise support tickets for all issues, analyze root causes, and assist in the efficient resolution of all production processes. Run Web application code step by step in a debugging tool like Visual Studio, to find the exact point where the developer made a programming mistake and then understand what corrections the developer needs to make in application code and resolve it quickly. Created log file to track server errors and identify application errors. Migration of database from local to production Azure SQL Server. Debugging code to resolve existing issues for finding the root of a problem in a code base and fixing it. Working on Software Enhancements - modifications or improvements made to the existing software application code and store procedures code to improve the performance of the web application/mobile applications. Working on increasing SQL Server stored procedure performance to reduce the overall execution time of store procedure. Review the web application code to optimize web application performance. .Net Developer | Metasys, India | Oct 2007 Apr 2010 Responsibilities: Involved in the development of Web Forms and classes using C#. NET that incorporates both N-tier architecture and database connectivity Developed ASP. Net pages using ASP. NET 3.5 web form controls, Controls, HTML server controls in C#. Used Visual Studio. NET 2008 IDE to design the forms and develop and debug the application. Wrote SQL Queries to create tables, stored procedures using SQL server. Implemented version controlling using SVN. Deployed web application on Internet Information Server for production. Enhanced and developed UI functionality using ASP. NET, jQuery, HTML, and XML. Created CSS files to be applied to various web forms on the web pages. Used ADO. NET extensively for retrieving, querying, storage, and data manipulation. Used Page and Data caching concepts to increase the throughput of the ASP. Net pages. Used Ajax toolkit, regular expressions, regular expression validates, user search controls. Created Crystal reports on the web page by accessing the database. Created stored procedures for application data access and manipulation. Involved in writing Transact-SQL Queries, stored procedures, user-defined functions, views, and good understanding of Normalization Database design, and modeling. Collaborated with cross-functional teams to define and refine system requirements, ensuring alignment with business objectives and technical feasibility. Designed and implemented logical and efficient application logic using .NET framework, incorporating business rules and processes to deliver robust and scalable solutions. Designed SQL Scripts, for creating relational database tables with primary-foreign key relations and temporary tables in SQL Server 2008 using T-SQL. Mainly involved in coding the business logic for the entire system based on the requirements in C# and used Design Patterns such as Abstract Factory, Facade & Singleton patterns for writing the business logic based on the requirement by using. Net Framework 3.5, C#, Visual Studio 2008. Maintained enterprise reporting (SSRS Reporting Services) based on specifications and business needs and modified existing reports as needed. Environment: Visual Studio. NET, ASP. Net 3.5, C#, VB.Net ADO. Net, LINQ, XML, SQL Server 2008, SSRS, SSIS, IIS6.0, Windows Server 2003, Web Forms, JavaScript, jQuery, Html and CSS. .Net and SQL Developer | Aim Global, India | Feb 2007 Oct 2007 Responsibilities: The Presentation Layer is implemented in ASP. Net with HTML, Cascading Style Sheets (CSS), and Web Controls. The Web Forms are developed utilizing the C#. Extensively used Ajax Controls to reduce the client server turnaround time, hence enhancing the performance of the application also used JavaScript for client-side validations. Developed the independent WCF (Windows Communication Foundation) services and defined Service Contracts for specific functionality in the project search module. Written LINQ-enabled queries to access the data from the SQL Server database. Used bindings to control the construction of the WCF channel stack at runtime. Used Grid View, Data List, and Repeater controls with Paging and Sorting for displaying various data onto the page. Developed many T-SQL queries to fetch data as per the business requirements with proper tuning techniques. Modified database via Entity Framework code first migrations. Used XML intensively to bind the data to the web controls, data manipulation, and store data and send it as a parameter to the stored procedures Implemented Serialization and Deserialization of objects. Integrated HTML, CSS, and JavaScript into ASP. NET environment. Design responsive and intuitive user interface for the web using XHTML/CSS and both custom AJAX scripts as well as MS AJAX for ASP. NET library. Used AJAX-enabled grid to display the data to display the data fetched and used AJAX Toolkit to develop the controls also developed light-weight rich UI via extensive usage of jQuery. Intensive use of CSS and XHTML to design the look and feel of the web pages. Used Microsoft patterns and practices recommended PRISM framework with features such as regions, modules, event aggregators, and delegate commands in implementing the (MVVM) Model-View-View-Model design pattern to develop a WPF application. Conducted regular reviews of technical architecture documentation to validate adherence to established standards and guidelines, ensuring consistency and accuracy across project. Conducted regular system audits and assessments to evaluate compliance with security standards and identify areas for improvement, implementing necessary remediations. Developed user and custom controls using C#, Visual Studio, and Expression Blend for the WPF application. Developed a stored procedure search and obtained the data reports using facets to narrow down the search using ADO. NET Entity Framework and C#. Used ADO. Net Technology to connect the web forms to data sources such as MS SQL Server and XML files for manipulating data in the database. Worked extensively on web forms and data binding controls like Grid View, Data List and drop-down boxes and Mapping page fields to the database fields. Visual Studio is utilized as the IDE tool for the management of the project and controls as they are developed and deployed. Environment: C#. NET, ASP. NET MVC, VB. Net, Azure, SSRS, SSIS, SQL Server 2005, Web API, WPF, HTML5, IIS, Visual Studio, HTML and CSS, JavaScript, jQuery. Keywords: cprogramm cplusplus csharp continuous integration continuous deployment quality analyst artificial intelligence user interface javascript database information technology microsoft procedural language California