.Net Core Sql Server
Resume:
*******.***@*****.***
https://www.linkedin.com/in/geetha-arecallu
Geetha Arecallu
Experience Summary
Microsoft Certified Azure Developer Associate Professional with 13+ years of extensive hands-of experience in Client/Server, Multi-tier and Windows/Web applications development with active involvement in all the phases of software development life cycle (SDLC) such as design, development, deployment and testing.
Experienced in developing the Single Page Applications using Angular 2/4/5/7/8/9/12.
Expertise in web-based services using ASP.NET, VB.NET and C#. NET following MVC architecture.
Experienced in developing the REST API with .Net Core 6.0,5.0,3.1,2.0,1.1. Also developed Web Services using SOAP and XML.
Have hands of experience on working with OOPS concepts, Inheritance, Encapsulation and Polymorphism.
Experienced with N-Hibernate and Entity Framework ORM Technologies.
Also have experience in developing Web Forms and Windows applications.
Experienced in creating databases in MS SQL Server 2005/2008/2008R2/2012/2016, IBM DB2, Oracle, and MS Access.
Extensive experience in working with tables, triggers, views, and stored procedures in T-SQL (MS SQL).
Well experience in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS 2005/2008), DTS, Bulk Insert and Bulk Copy Program utility.
Expert in creating Parameterized Reports, Matrix Reports, and Custom generated reports, Charts, Sub Reports as per Business User requirements Using SSRS and Crystal Reports.
Experienced with Jenkins to build and deploy the .Net and Angular applications.
Excellent in analyzing, problem solving, good communication and multi-tasking analytical thinker with the ability to work on fast paced work Environment.
Experience in Using GitHub Co-Pilot to improve coding pace.
Certifications
Microsoft Certified Professional - .Net Framework 4, Web Application
Microsoft Certified Professional - Querying Microsoft SQL Server 2012.
Microsoft Certified Professional - Azure Developer Associate.
Educational Qualification
Master of Science in Information Technology from Sullivan University – Louisville,
KY Sep 2012
Technical Highlights
Microsoft .NET Technologies
: .Net Core 6.0,5.0,3.1,2.0/1.1, C#.NET, VB.NET, .NET Framework 3.5,4,4.5,4.6, ADO.NET, MVC.
Databases
: SQL Server 2005/2008/2008R2/2012/2016, Oracle 9i, IBM DB2
Web Programming
: TypeScript, JavaScript, jQuery, Angular 12/7/5/4/2, Bootstrap, Html 5
IDEs
: VS 2005/2008/2010/2012/2015/2017/2019
Web Services
: SOAP, WCF, WEB API, REST API
Web Servers
: IIS 5.0/6.0/7.0
Operating Systems
: Windows XP, Windows Server 2003/2008
Source Control
: Team Foundation Server (TFS)), SVN, Git Hub, Vault
Cloud Technologies
AI Technologies
: Azure Devops, Aws Lambda, EC2.
: GitHub Co-Pilot
Work Experience:
Lexis Nexis
Dallas, Tx Apr,2021 – Present
Role : Senior Full Stack Developer
Environment : .Net Core 5.0 & 6.0, Angular 12, TypeScript, HTML, CSS, Azure DevOps,
Sql Server 2016, Jenkins, AWS, Git, GitHub Co-Pilot.
Project: Lexis Advance, Hot Docs, Automated Templates, ICS.
Responsibilities:
As a Senior Developer, I was involved in developing new features and enhancing the existing applications.
Experienced in developing Microservices following a MFE Architecture.
Migrated .Net Core application from 5.0 to 6.0.
Migrated single page web application from Angular 6 to 12.
Implemented Document Reordering in .Net Using Aspose.Word.
Converted Documents to PPT using Aspose.Total.
To maintain data retention policy, created an Api and configured to run of specific schedule using AWS Lambda.
Experienced in building and deploying code using Azure pipeline and Jenkins job.
Tweaked existing Docker files to fix library dependencies for deploying on Linux servers.
Enhanced existing Yaml files in Kubernetes to deploy .Net applications.
Experienced in using Redis Cache for highly scalable and feature-rich caching functionalities.
Involved in monitoring Cloud Watch Logs and EC2 instance to obtain more information on issues.
Optimized .Net applications performance in Kubernetes, by resource allocation and scaling.
Module Federated Angular application to integrate it in App Shell.
Improved the performance of the application by limiting Api calls.
Implemented session management on angular application by using localstorage on the browser.
Created complex store procedures in order to insert and retrieve data from Sql Server.
Refactored the store procedures by adding proper indexes and implementing appropriate joins to retrieve the data faster.
Used CURSORS in Sql in order to process data in batches.
Involved in code development, enhancements, and bug fixes.
Involved in code reviews. Following and suggesting best practices.
Working with peers, and knowledge sharing to peers.
Trained and experienced in using GitHub Co-pilot.
Alameda County (ITD)
Oakland, CA Apr,2017 – Apr, 2021
Role : Senior .Net Developer
Environment : .Net framework 4.5/.Net Core 2.0,1.1, REST API, JavaScript, Angular 9/8/7/5/4/2, JavaScript, SQL Server 2012/2016, SVN, Vault.
Project: Tax Tools, Specials, Accuzip, Aptis
Responsibilities:
Worked as Senior Lead Developer and was involved in database consolidation and application architecture decisions.
SME of the applications handled. Worked as mentor to junior developers.
Developed single page web application using Angular 2. Later migrated them to Angular 5/7/8/9.
Implemented Lazy loading modules to improve performance.
Used Observables to implement asynchronous calls to Rest API.
Developed and Integrated .Net core REST API with both IBM DB2 and SQL Server Database using NHibernate (ORM) and Ole Db Connections.
Developed REST API with both ORM(NHibernate) And Non-ORM Technologies (using IBM DB2 Core dll’s).
Worked on Telerik Controls in the ASP.Net Web form applications, utilized open xml SDK to read and write Excel Documents.
Highly skilled in performance tuning applications and followed SOLID principals.
Developed some complex store procedures to insert, update and delete the data according to the business rules from the legacy Web Forms Applications. Also developed and deployed SSRS Reports.
Designed Table Schema and created tables and required constraints with the help of DBA.
Wrote huge store procedures to retrieve data by joining multiple tables for reporting purpose.
Created some UDF’s to standardize data into specific formats, for reporting purpose.
Implemented Views, based on the requirements.
Wrote Jenkins scripts to deploy the .Net web forms, Rest API and Angular Applications.
Scheduled jobs through D-Series (CA Technologies).
G6 Hospitality
Irving, TX May,2013 – Mar,2017
Role : .Net Developer
Environment : .Net framework 4.5, REST API, MVC, WCF, HTML 5, Java script, Angularjs and Karma, VB Script, SQL Server 2000/2008R2/2012, TFS 2008/2013/2015.
Project : HMS
Responsibilities:
Involved in requirement gathering and preparing Development Requirement Documents.
Was involved in various stages of SDLC like development, deployment and testing.
Developed web application using Angularjs and Bootstrap.
Created Rest Services Using ASP.Net Web API, C# and MVC architecture.
Followed Agile Methodology for the Application Development. Worked with Ralley to track the User Stories and Development Tasks and Defects.
Created DAL using LINQ to SQL and Entity Framework.
Developed some complex store procedures to insert, update and delete the data according to the business rules.
Involved in migration of TFS Server 2008 to TFS Server 2012.
Developed and scheduled some of the SSIS packages to back-up the data to the History Server.
Developed SSIS Packages to migrate data from existing application to new application.
Utilized After Update Triggers to perform certain actions after updating certain records during the data migration.
Developed and Migrated Crystal reports from version 9.0 to XI
Developed various user interactive web pages using HTML, Classic ASP and VB Script.
Used VB.NET and ADO.NET objects for updating and displaying records from database.
Involved in production support of the application, providing bug fixes and delivering the releasing the deliverable packages.
Involved in unit testing and writing test scripts for the codes developed by me, and controlling the code developed by co-workers.
Project : Optimizer
Responsibilities:
Converted the legacy Classic ASP project to ASP.NET following MVC design pattern.
Upgraded the VB script web application with Javascript, HMTL 5 and Jquery.
Created Database Objects – Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
Developed Bulk insert batch for updating the table in SQL through the application.
Involved in migration of VFS Server 2008 to TFS Server 2012.
Involved in production support of the application, providing bug fixes and delivering the releasing the deliverable packages.
Involved in unit testing and writing test scripts for the codes developed by me, and controlling the code developed by co-workers.
YPO
Irving, TX Mar,2013 – May, 2013
Role : .Net Developer
Environment : .Net framework 4.5, REST API, MVC 4.0, WCF, VB Script, HTML 5, Java script, Angularjs and Jasmine, SQL Server 2012, TFS 2010.
Responsibilities:
Involved in requirement gathering and preparing Development Requirement Documents.
Developed mobile applications to enroll users for events organized by YPO, using AngularJs 1.4 framework, REST API.
Used Jasmine to write test cases for the front end.
Created LINQ enabled database layer using API such as LINQ to SQL and Entity Framework.
Created and scheduled SSIS Packages to transform and load from multiple sources to SQL Server 2012.
Followed Agile Methodology for the Application Development.
Involved in production support of the application, providing bug fixes and delivering the releasing the deliverable packages.
DrillingInfo
Austin, TX Nov,2012 – Feb, 2013
Role : Dot Net Programmer
Environment : C#, ASP.NET 3.5, JavaScript, XML, XML Web services, SOAP, SQL Server 2000/2008, GitHub.
Responsibilities:
Involved in requirement analysis, design and development of various modules.
Upgraded the SQL Server from 2008 to 2012 and rebuild indexes on tables to improve the performance of the SQL queries and store procedures.
Implemented core components in C# that handles business logic.
Used ADO.Net to access the database.
Provided WCF services to the contracting companies following SOAP architecture.
Contributed towards the security model in .NET framework for the administration module using verification process, Code Access security, and Role-based security.
Created and updated some complex store procedures to insert, update and delete the data according to the business rules.
Involved in designing SSRS reports over the SQL database for the customers.
JPMC
IRVING, TX Aug, 2011 – Jun, 2012
Role : SQL Server SSIS/SSRS Developer
Environment : VB Script, SQL Server 2008R2, HP Quality Center 10.0, MS Office 2007.
Responsibilities:
Installation and configuration of SQL Server 2008R2.
Involved in requirement gathering and was responsible for giving the timelines.
Created complex T-SQL queries using joins, sub queries, union and intersect statements to pull data from Production Database.
Involved in performance tuning of SQL queries to improve the efficiency of queries.
Created reports using the linked servers and multi valued parameters.
Developed the automated reports using VB Scripting and established connections through VB macros to automatically update the data from database.
Involved in developing daily dashboards and the ad-hoc reports based on the business requirements.
Dashboards has been developed and designed using multiple SQL queries, high level VB script and many more Excel functions like vlookup, countifs and exceptional if loops.
Generated ad-hoc reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
Scheduled reports using the scheduler in SSRS.
Osmania University
Hyderabad, India May 2009 – Sep 2010
Role : Jr. Developer
Client : Research and Training Unit for Navigational Electronics
Environment : C#.Net, SQL Server 2008
Responsibilities:
Involved in requirement gathering and was responsible for giving the timelines.
Implemented the project using C#.Net And SQL Server 2008
Improved the performance by selectively using Output Fragmentation and Data Caching.
Maintained high level security in the application using Session Variables.
Involved in creating T-SQL store procedures, triggers, views, constraint rules and indexes.
Performed code reviews and implemented unit testing.
Contact this candidate