Praveen Somala ********@*****.***
PROFESSIONAL SUMMARY
Highly skilled and result-oriented full stack Application Developer with over 15 years of experience in IT.
Extensive knowledge in all the phases of SDLC - Analysis, Design, Development, Testing &
Implementation of Desktop, Web and N-tier Architecture environments.
Experience in Azure cloud services (PASS & SAAS), webapps, Azure AD, Azure functions
Familiar with Azure data factory, service bus, event hubs, storage, key vault, app configs, Azure SQL
Hands on experience with C#, VB.Net, ASP.Net Web forms, MVC, .NET Core 2.0/3.1/6, EF Core, Angular
2+,Typescript, ADO.NET Entity Framework, XML Web Services, WCF SOAP/RESTful, Web API 2.0,
LINQ-SQL, HTML 5/CSS 3/Bootstrap, AJAX/JavaScript/jQuery, ReactJS
Experience in Java, classic ASP/VBScript, VB 6/COM/DCOM/ActiveX, ADO, ODBC & OLEDB.
Experience with SQL Server 2000/05/08/14/16, Oracle 8/9i/11g, MS Access
Experience working in iterative and incremental methodologies such as AGILE (Scrum, Kanban, LEAN),
Continuous Integration & Continuous Deployment, Azure DevOps
Experience in Reports development with SSRS, Active Reports & Crystal Reports.
Strong knowledge using UML modeling (Use Cases, Class diagrams & Interaction diagrams), MS
Visio 2007, Erwin.
Strong exposure to WPF/XAML, Silverlight, Expression Blend, SharePoint 2007, Ektron CMS400
Experience in Data migration, read data from legacy data store/validate/re-format data and merge
from multiple sources, write data to target DB, manage data errors, provide reports on execution,
provide an audit trail
Good exposure to Testing Methodologies, Web-industry 508 compliance standards and trends
Experience in Unit & System testing, writing Test cases, Bug analysis and fixes, Functional and
Technical documentation, Customer training.
Expert in analysis business needs to construct an effective, efficient and successful methodology utilizing
best practices and proven management experiences.
Good team player with an excellent interpersonal, communication skills and ability to work well with a
diverse team as well as ability to work independently and with minimal supervision.
CERTIFICATIONS
Microsoft Certified: AZ900 - Azure Fundamentals certification
MCTS - .NET Framework Application Development Foundation (Code: 070-536)
MCTS - .NET Framework 2.0 Web based Client Development (Code: 070-528)
Six Sigma White Belt Certified from IBM
MCP - Microsoft Certified Professional in VB.NET and SQL Server 2000
TECHNICAL SUMMARY
Operating Systems : Windows NT 4.0/2003/2000/XP/Windows 7/8, Linux
Languages : T-SQL, PL-SQL, C#, VB.net
Cloud Technologies : Azure, AWS EC2
Databases : MS SQL Server 7.0/2000/2005/2008/2012, Oracle 8/9i, MS Access
MS Technologies : ASP.NET, ADO.NET Entity Framework, Java Script/JQuery, AJAX, JSON,
XML/XSLT/XPath, HTML/HTML 5, VBScript, classic ASP, VB 6.0, IIS 5.0/6.0, SharePoint 2007, BizTalk Server
Web Services : SOAP, WSDL/UDDI, WCF + RESTful and Web API
Technology/Concepts : OOPs, SOAP, AJAX, OLAP, WPF, XAML, LINQ, ActiveX (COM/DCOM)
IDE/Tools : Visual Studio 2003-2013, Crystal Reports 8/9, SSRS, SSIS, Office 2000/03/13,
Putty/WinSCP, FileZilla
Defect Tracking : Bugzilla, Visual Source Safe, TFS, JIRA,
Code Repository : GIT, BitBucket, TFS, SVN
WORK EXPERIENCE
Application Developer Apr ’21 - Till date
Client: Louisiana State Dept. of Transportation
Involved in Analysis/Design, develop, enhancements, refactor, configure
Involved in conversion/upgraded of legacy ASP/.NET applications to .NET Core
Design and Implemented web apps from scratch using .NET Core 6, MVC Razor views, Web API, Dependency injection and Entity Framework Core, Swagger for APIs documentation
Created, implemented the tools along with team that were used to work with Azure DevOps
Migrated image gallery where we stored the generated images and developed Azure pipelines in Azure DevOps to implement the Azure services
Followed Agile methodology with daily scrum meetings, providing user story updates
Using EF Core, LINQ, Lambda expressions to query and retrieve selective based information from the collection objects.
Using JavaScript/jQuery/AJAX calls to retrieve JSON data from controllers with backend RESTful services and display data in partial views (Razor)
Developed POC for other dept. with Angular/React components to measure the performance.
Wrote SQL queries, create/modify stored procedures, views, functions, SQL Jobs in SQL Server 2014
Used Visual Studio 15/19, .NET Core, ASP.NET Webforms/MVC, Web API, C#, VB.NET, SQL, TFS, GIT, HTML 5 (semantic tags), CSS 3/Bootstrap, JavaScript/jQuery, AJAX/JSON/XML, Entity Framework
Application Developer Apr ’20 – Apr’ 21
Fiserv, Aurora, IL
Involved in Design, develop, enhancements, refactor, debugging, configure and code reviews for Customer/Admin web portals, windows services, Restful API’s.
Followed Agile methodology with daily scrum meetings, providing user story updates
Collaborated migrating existing Apps to MS Azure App Services, Functions, APIM within DevOps CI/CD
Created new Azure functions which uses HTTP, azure service bus, cosmos, timer triggers
Developing and hosting REST API using Azure API Management, Swagger and integration with Azure web apps
Upgrading API’s with ASP.NET Core 2.1 and Entity Framework Core
Using Entity Framework, LINQ, Lambda expressions to query and retrieve selective based information from the collection objects.
Using JavaScript/jQuery/AJAX calls to retrieve JSON data from controllers with backend RESTful services and display data in partial views (Razor)
Using Postman/Fiddler to test/troubleshooting, proxy debug for RESTful with Web APIs, Logging exceptions using Log4Net.
Involved in creating Role based security Authorization, caching, session management, Authentication
Performed unit testing that helped to improve system's stability and scalability to identify critical
performance issues during development phase.
Wrote SQL queries, create/modify stored procedures, views, functions, SQL Jobs in SQL Server 2014
Using Swagger for APIs documentation, Jira, TFS for code repository, code versioning.
Used Visual Studio 17, .Net Framework 4.7.2, ASP.NET MVC, Web API 2, C#, DevExpress controls, SQL, TFS, GIT, HTML 5 with semantic tags, CSS 3/Bootstrap, JavaScript/jQuery, AJAX/JSON/XML, Entity Framework
.NET Developer Sep ’17 – Mar ‘20
Client: Canon USA, Itasca, IL
Responsible for Design, develop, implement, document, maintain to enhance build/release, deploy processes in DEV/QA and PROD
Salesforce.com API integration with ASP.net MVC application.
Created SPA dashboard from scratch using ASP.NET Core 2.1 with Angular 2 +Typescript, Dependency injection and Entity Framework Core
Upgrading, Refactored, Architect legacy applications to new version of .NET framework, manage front-end, middle-tier business objects and components
Create/modify stored procedures, UDF’s, OpenXML to read/write to database from XML docs, query performance tuning, create Reports with SSRS
Consumed RESTful services with Web API/ JQuery/Ajax with JSON/XML formats
Perform ETL using SSIS packages, create DataFLow, ControlFlow execute from .NET console app.
Perform REST API testing/troubleshoot using PostMan, debugging HTTP(s) traffic with Fiddler.
Used Bitbucket for code repository and GIT for code versioning, Jenkins for CI/CD
Used Classic ASP, VB script, Telerik Kendo UI, ASP.NET MVC/Web forms, C#, HTML 5 (semantic tags)/CSS 3, JavaScript/JQuery, ADO.Net Entity Framework, LINQ-SQL, RESTful, Web API, JSON/XML, Bootstrap, Visual Studio 2013/15, SQL Server 2014
Senior .NET Developer Dec ’16 – Jun’ 17
Client: WA State Dept. of Patrol (WSP), Olympia, WA
Responsible for re-engineering the complete HRMS application from Java to .NET
Developed RESTful Web API’s, ASP.NET MVC 4, C#, .NET Framework 4.6, EF 6.0, used Async/Await features for asynchronous processing.
Used Repository, Unit of Work and Dependency injection design pattern.
Create/modify SQL stored procedures, UDF’s, Views and Reports with SSRS
Used ASP.NET MVC, C#, HTML 5 (semantic tags)/CSS3, JavaScript, JQuery/Knockout JS, ADO.net Entity Framework, LINQ-SQL, Web API, XML/JSON, Bootstrap, Visual Studio 2015, SQL Server 2014, TFS
Senior .NET Developer Aug ’15 – Nov ‘16
Client: WA Dept. of Licensing (WSDOL), Olympia, WA
http://www.dol.wa.gov/
Responsible for PROD support, bug fixes/troubleshooting, development, enhancements.
Involved writing Stored procedures, UDF’s, Views using SQL Server 2012, scheduling batch jobs
Developed reports using SSRS – URL based and client side, perform ETL using SSIS packages
Close interaction with BA for requirement gatherings, Analysis, Dev. Estimates, Tech. Documentation
Used ASP.NET Web forms/MVC, VB.net, C#, HTML 4/5, CSS2/CSS3, JavaScript/JQuery, ADO.Net Entity Framework, LINQ-SQL, ASP 3.0, WCF SOAP/RESTful services, JSON/XML, TFS 2012, Visual Studio 2013
.NET UI Developer Sep’ 14 – Aug’ 15
Client: WA Dept. of Transportation (WSDOT), Seattle, WA
http://www.wsdot.wa.gov/ferries/
Was part of Phase1 development from May’12- Nov ’12.
Involved 80% as UI developer, extensively worked on cross browser compatibility, mobile versions
Used ASP.NET 4.0, MVC, C#, XML
Create WCF RESTful services, interfaces and consumed asynchronously with AJAX/JQuery/JSON
Used JQuery UI, jQuery Mobile frameworks to make it work on Desktops, Smartphones/tablets
Involved writing Stored procedures, UDF’s, Views using SQL Server 2012 R2, developed reports using SSRS
Used VS 2008/12/13 with .NET Framework 3.5/4.0, CSLA architecture
.NET UI Developer/Lead Jan ’14 – Sep’ 14
Client: Trafinity, Bellevue, WA
Responsible as Dev Lead, involved 90% as UI developer, design mockups and wireframes
Worked from scratch on content-based website which dynamically aggregates thousands of press releases, corporate events, Twitter feeds, blogs, RSS feeds on stocks, Social networks - Facebook, Twitter, LinkedIn, Tumblr, Blogger.
Create Widgets using JQuery UI, jQuery Mobile, Prototypes
Used OAuth security authorization protocol to give access to third party web sites
Used Telerik KendoUI an MVVM (model-view-view-model) framework for two-way data synchronization
Used Knockout.js binding system to support partial views, making it reusable and maintainable.
Used Axure for prototype design, ASP.NET MVC 4, HTML 5 (semantic tags)/CSS 3/Bootstrap, XML, LINQ
Consumed RESTful services asynchronously using and Web API and AJAX/JQuery/JSON on client side
.NET Developer July ’13 – Dec’ 13
Client: Facebook, Seattle, WA
Worked on Atlas Solutions (ATS), configure publishers, advertisers, optimize campaigns, multi-faceted Ads.
WinForms App with Multi-Threading background tasks writing to Excel
Create & Consumed WCF services asynchronously using AJAX/JQuery/JSON request-response
Exposed service with multiple bindings (basic and TCP)
Used HTML5 web storage elements, ExcelAddin using excel object
Wrote Unit Tests classes, Used Git on Linux for Code repository
Software Dev. Engineer Dec ’12 – June’ 13
Client: Microsoft, Redmond, WA
Responsible for UI design and development using ASP.NET MVC 3/4, HTML 5, CSS3, JavaScript
Consumed WCF RESTful asynchronously for SOAP/XML and JSON using AJAX/JQuery
Create Unit Tests classes, used Microsoft Fakes to mock the objects
Hosted application as client on Windows Azure with Web Roles
Interaction with Dev. Lead and PM’s for gathering requirements, Analysis, provide dev. Estimates, Technical Documentation and meeting the deadlines
Senior Software Engineer Sep ’11 - May ‘12
Family Health Centers of San Diego, San Diego, CA
Responsible for handling multiple web applications developed in VS.net 2003/05/10 designed on 3-tier architecture, upgraded apps from Framework 1.1 to 4.0
Developed modules using ASP.Net, C#, HTML, CSS, JavaScript & JQuery, AJAX
Developed apps for hand held (mobile) devices using .NET Compact Framework
Responsible for DB design, wrote Stored procedures, UDF using SQL Server 2008
Extensive use of Telerik RAD controls to maintain GUI uniformity for the web content
Generating reports using Active Reports converting to PDF/Excel format
Good knowledge in applying HIPPA standards and HL7 messages, Electronic Medical Record, EHR
.NET Developer June ’09 - Sep’11
Client: CA State Bureau of Automotive Repair
Involved in Development from scratch developing web pages in ASP.NET 3.5, Visual Studio Team System 2008, C#.net, ADO.NET Entity model, WCF SOAP services
Used CSLA Framework for creating business object in middle tier to extract information from Db
Developed web pages with HTML, CSS, JavaScript/JQuery to maintain GUI uniformity for the web content
Used Telerik RAD controls interactive, AJAX for asynchronous process
Used SASL Simple Authentication and Security Layer framework for authentication and
authorization for data security in Internet protocols
Used Oracle 11g database, used Dream coder to write PL/SQL queries, stored procs, functions
Wrote Tests methods using NUnit as Test Driven Development for the business functions
Used Cruisecontrol.NET for continuous code integration and build source code
Telerik WebUI Studio for Regression Testing & VSTS 2008 Web Test for Performance and Load Test
Used SubVersion for source code, ELMAH to log errors
.NET Developer Sep ’ 08 – May ‘09
Client: Wells Fargo Bank, San Francisco, CA
Production Support, Enhancements and Maintenance of the application for various requirements using .NET Framework 2.0, ASP.NET, C#.net, Oracle 9i, WinForms
Responsible for gathering requirement, analysis, task deliverables, generating reports using Crystal Reports
Wrote stored procedures using Oracle 9i, used TOAD tool for PL/SQL queries
Worked on Financial based applications using .NET Framework 2.0, ASP.NET, C#.net, HTML, CSS, JavaScript, AJAX, ADO.NET Entity Data model framework, SQL Server 2005 and VSS
Developed WinForms with Multi-Threading to zip Excel sheets and upload in FTP server
Used Background Worker control in WinForms to run the tasks behind
Used MSMQ for messaging queues to transmit data between applications with MSMQ methods
Used Telerik RAD controls for rich UI, JavaScript /JQuery
EDUCATION
MCA - Master of Computer Applications ‘2002 from Madurai Kamraj University
BSc - Bachelor of Science in Electronics ‘1998 from Osmania University
Professional Diploma in Technology and Management in Software ‘ 1998 from NIIT