Parthiban Rangaraj

Technology specialist/ Lead

PROFESSIONAL SUMMARY

** ***** ** ********** ********** in architecting, designing complex and high-performance web applications. Proficient in full life cycle system development, analysis, design, development, system integration, unit testing, implementation of application software in Web-based and Client-Server environments.

Expertize in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers using Microsoft SQL Server 2000/2005/2008/2012/2016, using tools like SQL server management studio, Oracle TOAD and DB2.

Experienced in configuring and maintaining the performance of large MS SQL Server database applications

Experienced with SQL Server database design and administration.

Experienced in the Database Designing, Debugging Stored Procedures, SQL Profiler, Query Performance and Optimization.

Experienced in writing and debugging complex SQL Stored Procedures.

Expertise in Data Migration, SSIS (SQL Server Integration Service) Packages and DTS (Data Transformation Service). Experienced in SSRS.

Experienced in design using Object Oriented Programming languages (OOPS) concepts abstraction, encapsulation, inheritance, polymorphism in C#.NET.

Experienced in implementing Asynchronous Processing, Multithreading, and Caching, error handling, exception management, tracing and logging features.

Experienced in ASP.NET Web Forms, ASP.NET MVC, and C #.NET, VB.NET, Web Services, WCF, LINQ, SOAP, RESTful Web Services, MSMQ and SOA.

Extensive expérience in user Interface development using HTML, HMML5, CSS, Java Script, VB Script, JQuery, AJAX, Pages, JSON, Angular JS and Bootstrap.

Excellent troubleshooting and debugging skills.

Experienced in MVC and MVVM design pattern.

Proficient in storing and exchanging data using XML and JSON formats.

Experienced in designing and implementing Single Page Application with Angular.

Experienced in version control with TFS, VSS and Git.

Experienced in developing applications using Design Patterns.

TECHNICAL SKILLS

.NET Technologies

ASP.NET MVC, Web API, LINQ, ADO.NET, Web Services, WCF, Web Forms, Win Forms, SOAP, .Net Framework 2.0/3.0/3.5/4.0/4.5/4.6

Programming

Languages

C#.NET, VB.NET, ASP, C, C++, SQL, T-SQL

Web Technologies

XML, HTML/HTML5, CSS/CSS3, DHTML, XHTML, XAML, CSS, PHP, XSLT, VBScript, JavaScript, AJAX, Angular 6, Node Js, Bootstrap and Classical ASP

Databases

SQL Server 2000 /2008 R2/2012/2014/2016/2022, Oracle 11g/10g/9i,

MS Access, My SQL, PL/SQL, MS Access and IBM DB2.

Reporting tools

Crystal Reports for Dot.NET, SQL Server Reporting Services

(SSRS) and Text Based Reports.

Integration

Technology

SSIS (SQL Server 2005, 2008, 2012, 2014 and 2016), DTS Tools

Methodologies

SDLC, Agile Development, Waterfall Development.

Version Controls

Visual Source Safe, Team Foundation Server (TFS) and GitHub.

Bug Tracking Tool

Test Tracking Pro, BMC Remedy and ITSM

EDUCATION

Master’s in Computer Application (MCA) from Bharathiar University, INDIA.

Bachelor of Commerce (B.com) from Bharathiar University, INDIA.

PROFESSIONAL EXPERIENCE

Client: State of Idaho Dept. of Labor (IDOL), (October 2020 – Present)

Project: Tax and Benefits

Role: Senior Developer/ Dot.NET Lead

Responsibilities:

Analyze, Design, develop and implement systems software using C#.NET, ADO.NET, ASP.NET, MVC using Entity Framework and MS SQL Server.

Involving in the full Life Cycle of the project including Analysis Design, Development, Debugging, Testing and Deployment.

Working as Scrum Developer in AGILE SCRUM environment, regularly attending the Status Meetings, updating status to Scrum Master, involved in Developer meetings, Code Review, Managing Tasks status in Azure Kanban boards and Implementing User Stories. Coordinate with different functionality teams such as Middleware, Selenium Testing, DevOps to setup isolated project environment for development activities.

Responsible for designing user Interface using HTML5, CSS, JavaScript, Typescript (3.3 & above), jQuery, AJAX, JSON, and Dot.Net Server controls.

Responsible for Develop and deliver software applications using C#.Net, ASP.Net MVC, Entity Framework Core, Dot.Net Core 5, WCF, Web API, SQL Server Technology and OpenAPI (Swagger).

Retrieve data from using LINQ Query and Lambda Expressions.

Using Fluent validator to build validation rules to apply the business rules.

Design and develop Applications using MVC design patterns.

Perform optimization of queries using Entity Framework, Index Tuning and SQL Query.

Using Seq logging to centralized log file with superpowers. Intuitive expression-based filtering, combined with free-text and regular expression searches.

Using RabbitMQ publishing and receiving messages for application process. It gives applications a common platform to send and receive messages.

Using Microsoft SQL Server 2017 (T-SQL) to achieve database operations.

Creating technical document, use cases and unit test case scenarios for different functionalities.

Writing unit, integration, automated tests against Service Endpoints Using Open API endpoints (Swagger).

Using GIT-Hub and TFS for the purpose of version Control and source code maintenance needs.

Ensure to give updates to client on the project in the meetings & Using Azure Kanban Board updating the agile scrum status on daily basis.

Using Swagger, creating RESTful APIs expressed using JSON, used to design, build, document and use RESTful web services and it includes automated documentation, code generation, and test-case generation.

Developing code for Tax Dashboard, Employer Accounting, Tax Work, Employer Audit, Reports, External Resources, Administration, System, Document Library, Settings, API Web and services. Notification, API, creating end points in services, Authorize, Status Monitoring, Task Runner, Selenium Test, Helm and Claimant Portal.

Experienced in Azure DevOps to build Continuous Integration/Continuous Deployment (CI/CD) software tools using Jenkins Dockers, and Kubernetes.

Environment: C#.NET, ASP.NET Core MVC, REST, LINQ, Web API, Coded UI, JavaScript, TypeScript, jQuery, AJAX, JSON, Automation, XML, XSL, CSS, HTML, .NET Core, Entity Framework Core, LINQ, Fluent Validation, OpenAPI (Swagger), Seq Logging, Webservices, RabbitMQ, Git, Team Foundation Server (TFS), Selenium, Dockers, Kubernetes, Azure Kannan Boards, Azure DevOps, and Microsoft SQL Server 2022.

Project - iUS 2.0 Tax Modernization: application to provide features that Unemployment Insurance Tax Systems to manage Tax for Unemployed Employees. Tax application used to collect taxes from employer and provide unemployment benefits to unemployed employees. Tax has several modules such as Tax Dashboard, Tax Work, Employer Accounting, Reports, External Resources, Administration, Employer Audit, System, Document Library, Settings, API Web. It includes services such as Tax, Notification, API, Authorize, Status Monitoring, Task Runner, Selenium Test, Helm, Claimant Portal and Employer Audit Services.

Client: United Parcel Service, Timonium, MD (Nov 2017 to Present)

Project: CCM (Change and Configuration Management) and DPS

Role: Senior Associate/ Technology Specialist

Responsibilities:

Developing Stored Procedures, Functions, Triggers and Views using Microsoft SQL Server Programming.

Developing batch jobs to transfer data from central data warehouse to transactions database for legacy applications and reports.

Using ETL (SSIS) to develop jobs for extracting, cleaning, transforming, and loading data into Data Warehouse.

Involved in porting data from legacy systems (DB2) to the staging area (SQL Server) from where the teams can pick up the data for further processing.

Introducing Object Oriented Programming Patterns, Participating application performance analysis and SQL Performance analysis.

Gather and analyze the requirements on daily basis and prepare the development plan.

Analyze, Design, develop and implement systems software using C#.NET, ADO.NET, ASP.NET, MVC and back-end process using MS SQL Server

Developing CCM Dashboard web application using Angular JS to process the end-to-end deployment strategy using multi-tier architecture, C#, Entity Framework 5, ASP.NET MVC.

Developing WCF Web services using SOAP and Restful services to interact the applications.

Monitor and track scheduled build/deployment activities.

Co-ordinate with different functionality teams such as Middleware, DevOps to setup isolated project environment for development activities.

Creating technical document, use cases and unit test case scenarios for different functionalities

Regular meetings with Business Analysts of dependent Systems to discuss and document changes and enhancements in any of the systems

Environment: Microsoft SQL Server 2014, 2016, SSIS, Oracle, DB2, ADO.NET, VB.NET, C#.NET, ASP.NET, WCF REST, LINQ, Web API, Coded UI, MVC, JQuery, Automation, XML, XSL, CSS, HTML, AJAX, XML, CSS, JavaScript, Web Services, Micro Services, Team Foundation Server (TFS), Jenkins,

Client: United Parcel Service, Timonium, MD (Dec 2015 to Nov 2017)

Project: AMS (Address Management Systems)

Role: Senior Developer

Responsibilities:

Developing Stored Procedures, Functions, Triggers and Views using Microsoft SQL Server Programming.

Developing batch jobs to transfer data from central data warehouse to transactions database for legacy applications and reports.

Using ETL (SSIS) to develop jobs for extracting, cleaning, transforming, and loading data into Data Warehouse.

Introducing Object Oriented Programming Patterns, Participating application performance analysis and SQL Performance analysis.

Analyze, Design, develop and implement systems software using C#.NET, ADO.NET, ASP.NET, MVC and back-end process using MS SQL Server.

Responsible for developing solutions (C#, ASP.NET and VS 2015, Node, Bootstrap, Data binding) for signed off BRDs and lead the overall development from the team.

Developing WCF Web services using SOAP and Restful services to interact the applications.

Responsible for reviewing existing database model, ER Diagrams, and Database design.

Responsible for creating views, functions, triggers and Stored Procedures for whole development efforts, and also responsible for creating batch programs, PowerShell scripts to deploy QA/Production Test/Production environments.

Responsible for XML based Web services between UPS Billing System and Address Management Systems.

Responsible for Code Reviews, Best practices, and creating Standard procedures for the development efforts, to avoid performance issues.

Responsible for creating Technical Specifications documents, Technical approach documents, and User training materials, Release documentation, Release Scripts, FRDs, and other product related documentation.

Responsible for code refactoring, version control of Code, and documentation.

Responsible for mentoring client’ employees and other train the trainer programs.

Environment: Microsoft SQL Server 2014, 2016, SSIS, Oracle, DB2, ADO.NET, VB.NET, C#.NET, ASP.NET, WCF REST, LINQ, Web API, Coded UI, MVC, JQuery, Automation, XML, XSL, CSS, HTML, AJAX, XML, CSS, JavaScript, Web Services, Micro Services, Team Foundation Server (TFS), Jenkins,

Client: 3M St. Paul MN USA (July -2013 to Nov 2015)

Project: WMS (Warehouse Management Systems)

Role: Senior Developer

Responsibilities:

Responsible for developing Warehouse Management System major enhancements and upgrades.

Responsible for leading the efforts for complete Offshore and Onsite team and support the development process.

Lead the efforts for Business Requirement Analysis, user meetings, interviews with SMEs and other product owners.

Responsible for creating high level technical documentation along with the architecture group and create technical documentation for development approach and addressing business requirements challenges.

Responsible for conception of innovation approach, POCs to deliver the executable code to QA/Production Test and Production environments.

Responsible to mentor the client’s employees and new team members and bring them up to speed to meet the project goals.

Responsible to coordinate efforts among worldwide development teams within the organization.

Coordinating with the clients in terms of technical support, production support and Release Level Development (RLD).

Analyze and fix issues related to performance like memory leak and garbage collector, improving the performance of the stored procedure. Improve the database standards (Table format, Clustered index, Non-clustered Index, temp tables, long procedures, dirty read, order of execution and so)

Development of the Order flow from Warehouse entry to exit (Status from ASGN to RLSD).

Involved in High level and Low-level design and implement Code re-factors changes. Communicate the changes with interface team and involve the changes required which is going to impact from other interfaces.

Interacting with the end users and gathering the feedbacks

Providing value adds to custom applications.

Supporting the team to resolving the issues in terms of technical and functional by discussing with business leads

Involved in developing batch jobs to transfer data from central data warehouse to transactions database for legacy loans and reports.

Monitor and fix security related issues across applications.

Interaction with client team to understand business requirements and develop the System design and involved in technical discussions, design reviews.

Environment: Microsoft SQL Server 2012, SSIS, Oracle, ADO.NET, VB.NET, C#.NET, ASP.NET, WCF REST, LINQ, Web API, Coded UI, MVC, JQuery, Automation, XML, XSL, CSS, HTML, AJAX, XML, CSS, JavaScript, Web Services, BMC Remedy, ITSM and IBM Rational Clear quest.

Client: 3M St. Paul MN USA. (Jun 2010 to Jul 2013)

Project: 3M – ExAM (Exception Analysis Manager) and 3M – ALEXAPLT.

Role: Dot.NET Developer/Associate.

Responsibilities:

Involved in Business Requirements gathering, planning, design and coding in C#.NET.

Responsible for development efforts to meet with business requirements.

Responsible for creating Development plans and estimations for the client.

Responsible for creating technical documentation on business requirement analysis and design efforts.

Responsible to work with offshore team and onsite team for coordination of development efforts and delivery.

Responsible for POC development and innovative approaches to meet business requirements.

Creation of Development project plan and estimation.

Gathering the requirements on daily basis and Weekly basis and prepare the development plan.

Coordinating with the clients in terms of technical support, production support and Release Level Development (RLD).

Providing value adds to custom applications.

Owning End to end responsibility for Development and delivery.

Supporting the team to resolving the issues in terms of technical and functional by discussing with business leads

Involved in High level and Low-level design and implement Code re-factors changes.

Interaction with client team to understand business requirements and develop the System design and involved in technical discussions, design reviews.

Involved in developing batch jobs to transfer data from central data warehouse to transactions database for legacy loans and reports.

Conducting code reviews for correctness and quality of code.

Technical analysis with Business Analyst to shape the Functional Specifications.

Environment: ADO.NET, C#.NET, Classical ASP, ASP.NET, WCF, MVC, Java Script, AJAX, XML and web services. Oracle 9i, Oracle 10g, Microsoft SQL Server 2008, SQL Server 2012, SSIS Packages, DTS Packages, DB2 Database, TFS, SAP Reports, BMC Remedy, ITSM and IBM Rational Clear quest.

Client: Acer – UK. (Feb -2008 to May 2010)

Project: CSS (Customer Support Service) & ASP (Authorized Services Provider).

Role: Dot.NET Developer

Responsibilities:

Complete responsible for Middle East Region Acer’s Customer Service System Application development efforts.

Responsible for collaborating applications and data among Acer third party vendors, call centers, Authorized Services Providers, Repair Centers, Revenue Departments, Logistics and Shipping agencies.

Responsible for individual developments as well as to support team’s overall development.

Responsible to work with multi nation-based teams to develop solutions to meet the Acer’s customer requests.

Responsible for working with SMEs, Database Developers, Other Reporting Teams to analyze and refine the date from multiple sources.

Responsible for prototype development for Innovative approaches, and adhoc on demand solutions.

Responsible for setting best practices, and code review procedures, version control systems, mentoring.

Responsible for creating batch jobs to transfer data from central data warehouse to transactions database for legacy applications and reports.

Responsible to create SSIS packages to import and export with multiple database interface.

Using ETL (SSIS) to develop jobs for extracting, cleaning, transforming, and loading data into Data Warehouse.

Environment: ASP, Microsoft SQL Server 2005, 2008, DTS Packages, SSIS Packages, DB2 Database, TFS, Crystal reports, Microsoft Visio, IBM MQ Server, cTree Database, BMC Remedy, Test Tracking Pro, IBM Rational Clear Quest.

Client: Lakshmi Machine Works Private Limited, India. (Jun 2006 –Jan 2008)

Project: ISupplier, eSpares and SMS Portal.

Role: Dot.NET Developer

Responsibilities:

Developed Activity Diagrams, Page Flow Diagram, detailed sequence diagrams and preliminary class diagrams for the system in UML using Rational Rose

Introduced Dashboard process in the applications, Asynchronous call to improve the application performance, improving the stored procedures performance.

Involved in the Technical Requirement meetings to analyze and identify System Records, Middleware flows.

Work Extensively in Application support process. Creates and maintain the documentation in Wikis or SharePoint for future reference.

Actively involved in requirements gathering and High-level. Participated in technical discussions, design reviews with Architects.

Understand the requirement, design, and guide the team to implement it.

Responsible for Gathering the requirements on bi-Weekly and provide the estimation for deadlines.

Prepared Unit test Case Documents, involved in application support issues and identifying risks and assumptions and monitoring process.

Interaction with client team to understand business requirements and develop the System design and involved in technical discussions, design reviews.

Creation of Development project plan and estimation.

Involved in QA testing of the Business components and Use Cases.

Environment: ASP, ADO.NET, C#.NET, SQL Server 2005, DTS, SSIS Packages, HTML, Java Script, CSS, Web Services, IIS Server, XML, AJAX, Oracle 9i and Oracle Forms.

* : adsvaz@r.postjobfree.com

' : 570-***-****

Contact this candidate