Resume

Sign in

Sql Server Design

Location:
Morristown, New Jersey, 07960, United States
Posted:
February 15, 2018

Contact this candidate

RejithKumar Thayappalliveli

ac4hli@r.postjobfree.com

317-***-****

Azure .NET SQL BI Technical Lead Senior Developer PAGE 1 OF 6

Summary:

13+ years of progressive experience in the application design development & maintenance across Microsoft Technology stack with a focus on Microsoft Azure PaaS, .NET framework, C#, VB.NET, ASP.NET MVC, Restful API, Web API, Entity Framework 6, Unity and SQL Server

Experience of implementing enterprise systems based on Microsoft Azure PaaS platform using Microservice Architecture, Azure Storage Queue, Azure Table, Azure BLOB, Worker / Web Role and Azure Redis Cache, Azure Deployment and Monitoring, App Service, Logic Apps, Web Jobs, Server less Azure Functions in an integrated development & test environment involving Azure SDK, Visual Studio and Azure Emulator

Experience in designing and developing Single Page Applications (SPA) using Angular JS, jQuery, HTML5, CSS3, Bootstrap.

Proven expertise in the design and development of middleware components and reusable frameworks using .NET

/ C# and Object Oriented Design patterns and Dependency Injection using Unity Framework

Proven expertise as a Database Developer with MS SQL Server and Oracle RDBMS systems

Proficient in designing and developing Win-Form Applications using C# / VB.NET and Web Applications using ASP.NET MVC and Dependency Injection using Unity Framework

Experience of integrating / migrating legacy data sources with SQL server using SQL Server Integration Services

(SSIS)

Proficient in designing and developing WCF and Web Services using .Net Framework.

Experience in Multithreaded programming using TPL, Tasks, Async Await

Experienced in optimizing complex database queries and authoring large Stored Procedures, Views and Triggers for data centric enterprise business solutions

Experience of conceptualizing and implementing reports and BI solutions using POWER BI, SQL Server Reporting Services (SSRS) and Crystal Reports

Experience of various Source Control / Build Management tools such as Microsoft TFS / VSS, IBM Clear Case, SVN Tortoise, GitHub

Technical Skill:

Languages, Frameworks,

Tools : .NET Framework, C#, ASP. NET MVC, VB. NET, LINQ, Web API Azure SDK, Azure Storage, Azure BLOB, Azure REDIS Cache, Azure Queue, Azure App Services, Logic Apps, Web Jobs, Azure Functions, Storage Explorer HTML, AJAX, JSON, Angular JS, SOUPUI, Fidler, WCF, Web Services, Unity Framework, WinForms, Prism, Entity, Framework, Oracle TOAD, Multiplier, Client Server, OOPS, Design Patterns, VB6, COM, Classic ASP, SSRS, SSIS, Power BI, Crystal Reports Databases : Microsoft SQL Server 2005, 2008, 2012, 2014 Oracle, MS Access, MSDE Development Environments : Microsoft Visual Studio Visual Studio Online (VSO) Version Control : TFS, Visual Source Safe, SVN, IBM Clear Case, GITHUB Web Servers : Internet Information Server (IIS 5.0/6.0/7.0/8.0) Professional Experience:

Client : Allergan Pharma, Madison, NJ

Duration : March 2016 to present

Role : Architect/Technical Lead – Azure & .NET

Project : ODS Admin Suite

Description: Allergan is a unique, global pharmaceutical company and leader in a new industry model – Growth Pharma Through operations in approximately 100 countries The Allergan Global Supply Chain RejithKumar Thayappalliveli

ac4hli@r.postjobfree.com

317-***-****

Azure .NET SQL BI Technical Lead Senior Developer PAGE 2 OF 6

Features 40 manufacturing and distribution facilities around the world Scope of this program is transforming the current version of ODS Admin system to a completely integrated online portal and Job Scheduler App based on Microsoft Azure PaaS, Azure App Service, Logic Apps, SQL Server Database PaaS and .NET MVC with Angular JS. This centralized System provides bi-directional integration services with External application such as Workday SAP using MOVEit Secure file transfer and Dynamic Web API’s creates on the fly, centrally managed from Azure PaaS platform. Provide data feed using Web Api’s to o365 SharePoint portal. Workflow Messaging is managed through Azure Storage Queue. Azure Tables and BLOB used to maintain Audit trial log and store internal files. Sensitive data masking using Dynamic Data Masking (DDM) in Azure SQL Server PaaS with privileged access Web Jobs and Azure Functions used to perform work flows triggering with the help of CRON Expression

Responsibilities:

Solution discussions with business stakeholders and architecture team, Delivery coordination with offshore and client technical team, Requirements analysis, PoC development and estimation, Technical design, Code reviews, build management,

Development and deployment of MVC / Angular JS application on Azure PaaS

Implemented Microservice architecture using autonomous loosely coupled independent services and which can be consumed by authenticated subscribers.

Implementation and development of web jobs and Azure functions which gets triggered using CRON expression and Queue trigger.

Design, development, deployment of Logic Apps by integrating multiple App Services and Web APIs to perform workflows.

Different kinds of file transfer (CSV, XML, Tab delimited, Fixed Length, Pipe etc.) using Move IT with PGP encrypted.

Sprint planning for assigned modules

Requirements discussions with business and IT stakeholders

High level and low level design of modules & components

Enterprise architecture reviews and system design alignment

Development of Use-Case, Workflow, Business flow & ER diagrams

Sprint demos and feedback collection

Code review / peer review

Developed dynamic Web API which gets created on the fly according to the configuration. Implemented loosely coupled architecture using multiple independent components and services Development of Multithreaded programing using TPL, Tasks, async and await.

Design and development of Azure SQL PaaS, Tables, Views, Stored Procedures, Data Masking for sensitive data, Development of Azure Storage (Queue, Blob, Tables) to manage files and track audit trial. AAD Management and registration of Apps for security setup and configure Key. Development of application security using Owin and AAD Design patterns used to build high quality robust applications.

Preparation & review of unit test cases, build / release checklist & build management, Report generation using Power BI

Environment: Visual Studio 2015, C#, ASP.Net MVC and Angular JS, Azure SQL PaaS, Microsoft Azure PaaS, Azure Storage Queue, Azure Table, Azure BLOB, Azure Deployment and Monitoring, Azure App Service, Azure Logic Apps, Web Jobs, Azure Functions, Web API, O365, Entity Framework 6, LINQ, HTML, Bootstrap Client : ADESA, Carmel, IN

Duration : December 2013 to March 2016

Role : Technical Lead– Azure & .NET

Project : AutoVIN Suite

Description: AutoVIN suite caters to car inspection and auction related activities for majority of the Auto brands RejithKumar Thayappalliveli

ac4hli@r.postjobfree.com

317-***-****

Azure .NET SQL BI Technical Lead Senior Developer PAGE 3 OF 6

Globally using an integrated online system Scope of this program is about transforming the current version of AutoVIN system to a completely integrated online portal based on Microsoft Azure PaaS, IBM WebSphere, BMC Control-M, SQL Server and .NET Framework. This centralized system provides bi-directional integration services with leading car manufacture’s marketing systems through WCF and REST based API’s, centrally managed from Azure PaaS platform. Workflow Messaging is managed through Azure Storage Queue. Data transfer between systems is managed through Azure Table and Azure BLOB. Services are hosted using Azure Web / Worker Roles using Unity Framework and Dependency Injection. Data caching is enabled through Azure Redis Cache Responsibilities:

Sprint planning discussions with client business team and project team.

Design and development of MVC apps with Web Role and Worker Role patterns to implement business workflows and functionalities.

Implemented Unity frame work to manage dependency injection and method call using IoC Container to resolve dependency.

Implemented Worker Role to perform asynchronous background process and which integrated to Web Role

Development and implementation of Azure Storage (Queue, Blob, Tables) to manage handshake between Worker

And Web role and track message history using Table storage.

Development of Multithreaded programing using Tasks, async and wait.

Implemented loosely coupled architecture using multiple independent components and services.

Design and development of database Tables, Views, Stored Procedures and data Masking based on Azure SQL

PaaS.

Implementation of Entity framework and complex LINQ query writing. Design patterns used to build high quality robust applications.

Integration and deployment of and Restful APIs, WCF components and Web Services to integrate third party vendors.

Multiple types of file transfer including CSV, XML, Fixed Length,Tab delimited,Pipe etc. to external vendors using Xtrans

Report generation using SSRS.

Support and enhancement of Legacy Applications based on .Net and Classic ASP. Development and support of Oracle database using TOAD to manage legacy application Database performance turning.

Coordination with offshore team and client technical team.

Code reviews, PoC development, estimation, build management and deployment Environment: Visual Studio 2013, Microsoft Azure PaaS, Azure Storage Queue, Azure Table, Azure BLOB, Worker

/ Web Role, Azure Redis Cache, Azure Emulator, UNITY Framework, IBM WebSphere, C#, ASP.Net, MVC, Entity Framework 6, Cruise Control based auto-build generation. LINQ, HTML, IIS 8.0, ORACLE, SQL, TOAD, Windows 2012, IIS 8.0

Client : Walmart, Bentonville, AR

Duration : November 2012 to December 2013

Role : Sr. Systems Analyst

Project : WTMS

Description: WTMS is a transportation application used by Walmart to track and maintain tractors and trailer trips while hauling merchandise from Distribution Center to Stores. Application also manages driver, tractor and trailer profiles and has capability to send/receive messages to tractors in the field. This system provides load, location, backhaul and trip information of Walmart Private Fleet. WTMS is developed using Visual Studio 2010 with PRISM framework and Silverlight to manage composite applications and modularity. App consists of loosely coupled modules that are dynamically discovered and composed at run time. The views are composed in a common shell that acts as the host for all of the app's content. Composites provide services that tie these module-level components together. Modules can offer additional services that relate to the specific functionality RejithKumar Thayappalliveli

ac4hli@r.postjobfree.com

317-***-****

Azure .NET SQL BI Technical Lead Senior Developer PAGE 4 OF 6

of the app. LINQ and Lamda expressions are used to write queries with EDMX. Responsibilities:

Requirements analysis and component design and development Code reviews, build management and deployments.

Sprint meetings, solution discussions with business stakeholders and architecture teams.

Design and development of Silverlight MVVM apps using Prism framework.

Design and development of WCF services and Web Services,

Development of complex query writing using LINQ.

Design patterns used to build high quality robust applications.

Multi-threading using threads pool and call back method for asynchronous call.

Implemented loosely coupled architecture using multiple independent components and services

Development and maintenance of SQL Tables, Views, Stored Procedure and Functions.

Delivery coordination with offshore and client technical teams Environment: Visual Studio 2010 C#, VB.Net, Silverlight 4.0, PRISM Framework, MVVM, SQL Server. IIS 8, Entity Framework 6, Bootstrap. LINQ

Client : Warner Bros, Burbank, CA

Duration : December 2010 to November 2012

Role : Consultant

Project : Easy Budget

Description: Easy Budget is a customized system used by the WBTV estimation and financial administration Departments to track and maintain budgets throughout the entire TV production life cycle This includes budgets for Series and associated episodes, pilots, movies made for television, and presentations. The budgeting application has integration points with SAP, as well as third party accounting packages, PSL and Vista. The application remains a Windows thick client. System is developed as Windows thick client application using Visual Studio 2008 and Backend with SQL Server 2008. Custom workflows and business rules are implemented through modularized middleware components integration. SSRS and Excel are used for management report

Generation LINQ is used to manage database interactions from the application layer. Stored Procedures and Views are used in the database layer. Application performance is optimized trough Query Optimization and Performance Tuning techniques.

Responsibilities:

Technical team leadership and delivery coordination.

Requirements gathering, analysis, solution design, code reviews, project planning, quality documentation and build management

Design and development of .Net Winform Apps using SQL server as backend, Design and development of WCF services and Web Services. Multi-threading using thread pool and call back for asynchronous call

Design and development of SQL database models, Tables, Views, Stored Procedures and functions.

Query optimization as part of performance tuning

Review of Test Cases, Test Result and Pre/Post deployment tracking.

Report development using SSRS.

Environment: Visual Studio 2008 C#, VB.Net, SQL Server 2005, SSRS, SSIS, Crystal Reports, Service Broker Client : University of Oxford, United Kingdom

Duration : August 2010 to December 2010

Role : Sr. Software Engineer

Project : E-Marking

Description: E-Marking is an on-screen marking application that allows exam evaluators to mark candidates Test Papers and examination questions online Hardcopy examination papers are scanned and uploaded to the system and before the online evaluation process is performed using E-Marking system. Application GUI is developed using Windows RejithKumar Thayappalliveli

ac4hli@r.postjobfree.com

317-***-****

Azure .NET SQL BI Technical Lead Senior Developer PAGE 5 OF 6

forms in C# based on Microsoft.NET framework. Business logic and middle-ware components are designed using UML class diagrams and sequence diagrams and implemented through ADO.NET for communication between application and database layers. System uses database objects such as Stored procedures, Views, Cursors, Indexes and Triggers. XML and XSD based data transformation techniques are used for data formatting and rendering. SVN Tortoise is used for Source Control and Build Management.

Responsibilities:

Design and development of application pages and forms using ASP.Net and C# Winform apps Design and development of SQL database models, Tables, Views, Stored Procedures and functions Design and development of WCF services and Web Services.

Query optimization as part of performance tuning Multi-threading used to load data on controls and collections. Environment: Visual Studio 2008, ASP.Net, C#, VB.Net SQL Server 2005 Client : iSmart Business Solution Pvt Ltd, Bangalore, Kochi(Formally known as Soft Systems Ltd) Project : ERP Product and custom SDK development for agriculture industry Duration : April 2004 to August 2010

Role : Team Leader

Description: HARVEST Plus 2.0 is the next generation release of the ERP solution HARVESTS it 1.0 – targeted at Large scale agriculture industry operations System is built on .NET platform with Smart-Client architecture. Application modules are developed using an SDK which is internally developed with active guidance of Microsoft. VB.Net and ADO.Net are used for the presentation and business logic layers. This SDK takes care of key aspects like security, data integrity, data archival and customizability. SQL Server is used as backend and SSRS and Crystal report are used for the Reporting Custom Object Relational Model (ORM) is designed based on UML principles. ADO.NET is for communication between application and database layers. VSA Engine is used for scripting and dynamic creation of assemblies. Custom CRUD tool is used to create Tables, Stored Procedures, Views, Cursors, Indexes and Triggers in SQL Server. Data layer uses XML, XSD for data Transformation. TFS is used for Source Control and build management. Dynamic loading of modules and assemblies use Reflection. Application uses run time configurable business logic. Multi- threading is used for loading of controls and UI. Dot fuscation is used for the build management. .NET localization technique is used to manage multi lingual support. Configurable Forms, Events, Delegates, Regex, Rules etc. are used extensively to provide configurable business transactions. Design Patterns are used to develop middleware components. SSRS, SSIS, Crystal Reports and Cognos BI tools are used for the implementation of dashboards and reports. Responsibilities:

Work with Microsoft consultants and architects to define the solution blue print.

Design and development of custom SDK and Components,

Smart Client technology used to pull libraries and components from server

Web & Winform app pages using .NET Framework.

Multi-threading using threads pool and call back.

Design and development of Remoting

Implementation of Multi language on SDK.

Dynamic generation of forms using decorator patterns

Reflection used to dynamically instantiate instances

Design patterns used to build high quality robust applications and framework.

Development of Extended controls

Run time Library creation using VSA Engine

Design and development of MVC patterns on windows application using custom configurable SDK, Custom Regex, Audit Trial and dynamic CRUD functionalities using custom SDK framework. Design and development of SQL database model, Tables, Views, Stored Procedure, and Functions etc. Custom ORM created to process OR Concepts

Design and development of MSMQ based messaging used to send and receive messages. Development of 32 modules using custom framework.

RejithKumar Thayappalliveli

ac4hli@r.postjobfree.com

317-***-****

Azure .NET SQL BI Technical Lead Senior Developer PAGE 6 OF 6

Environment: Visual Studio 2005, 2008, C#, VB.Net, ASP.Net, SQL Server 2005, 2008, MS Reporting Services Education:

Diploma in Software Development (DNIIT), NIIT, Cochin, India, 2001

Bachelor of Commerce (B.Com), Calicut University, Kerala, India, 2005

Master of Computer Application(MCA), Manipal University of Technology, Manipal, India, 2010



Contact this candidate