CHARAN KANWAL SODHI. LinkedIn
20 EVANSVIEW MANOR NW | CALGARY, AB T3P0J7 |-|-
Talented and detail-oriented Software Engineer with 10+ years of experience
SUMMARY OF QUALIFICATIONS
Charan is a seasoned and accomplished professional with 10 years of rich and varied experience in all phases of Software Development Life Cycle. He specializes in building solutions using CSOM, SOM and Client Side Scripting (JavaScript, JQuery, SPServices) for SharePoint 2013, 2010, 2007 and CRM 2013, CRM 2011.
Charan has expertise in building and maintaining large scale SharePoint Farms from ground up. He has successfully completed SharePoint Migrations from SharePoint 2010 and SharePoint 2013, data migrations from file systems/network shares to SharePoint Intranet and RBS stores.
He is highly skilled in data integration and synchronization between SharePoint and external data sources using SSIS and custom solutions.
He has expertise in developing custom solutions for Microsoft Dynamics CRM. He has developed numerous custom workflow assemblies, custom plugins and has experience in customizing CRM forms using client side scripting.
Charan is a Microsoft Certified Professional and a Certified Technology Specialist. He is highly skilled in development and architecture of SharePoint 2010, 2013 out-of-the-box and custom solutions. He has successfully built numerous SharePoint solutions which include:
- Web parts
- Event receivers
- Custom workflows
- Timer jobs
- JavaScript solutions
- Web services
- PowerShell solutions
Along with strong technical skills he is capable of quickly learning and adapting to new concepts and technologies.
TECHNICAL SKILLS
Languages:
C#, SQL, Java Script , XML, HTML, UML, PowerBuilder
Databases:
MS SQL Server 2005, 2008, 2012, MS Access, ORACLE 9i, 10g
Operating Systems:
Windows NT/XP/7/8, Windows Server 2003, 2008, 2012, UNIX
.NET Framework:
2.0, 3.0, 3.5, 4.0, WPF, WCF, ASP.NET, WSS, AJAX tool kit, Enterprise Library, Web Services
BI Tools
MS SSRS, MS SSIS
Sybase:
PowerBuilder 9, 12 (Migration Projects)
Commercial Software:
SharePoint 2010, SharePoint 2013, SharePoint 2007 (MOSS), MS Dynamics CRM 2011, 2013, CRM Online, SharePoint Designer 2010, 2013, MS Office
Methodologies:
OOP, OOAD, SDLC (Waterfall), Agile
Tools and Components:
Visual Studio up to 2013, TFS, TOAD, VSS, Serena VM, Chart FX, ILOG Gantt Charts, FXCop, NUnit, IBM MQs, Winmerge, Infragistics, EASendMail SMTP and Service, EAGetmail, List Nanny, CKEditor, Core FTP, JQuery, CRM Rest Kit, Simego, Wakanda, ECMAScript, SPServices, CRM 2011 Custom Workflow Assemblies, Data Tables JQuery Library, Kerberos, OData, Data integration
Web Servers:
IIS 6.0, IIS 7.0
PROFESSIONAL EXPERIENCE
Freelance SharePoint/CRM Consultant June 2014 - Present
Project: Multiple Clients
•Responsible for architecture and governance of large scale SharePoint Farms.
•Responsible for Development and Support of SharePoint 2013, 2010 projects.
•Expertise in SharePoint 2010 and 2013 migrations and ADFS configuration.
•Expertise in setting up Remote Blob Storage on SharePoint 2010, 2013.
•Expertise in building solutions using CSOM, SOM, JavaScript and JQuery.
•Expertise in integrating SharePoint with external systems.
•Expertise in building CRM customizations – custom workflow assemblies, custom plugins.
• Expertise in customizing CRM on-premises and CRM online forms using JQuery, JavaScript.
•CRM integration with SharePoint and external data sources.
Eteligent Solutions Inc. Calgary, AB
SharePoint ConsultantApr 2013 - Present
Project: Multiple Clients
Working as a SharePoint Systems Developer for various Oil and Gas clients to fulfill their SharePoint 2010, 2013, 2007 development, customization and branding requirements
Responsible for creating Organizational Intranets using SharePoint 2010 and 2013
Responsible for architecture and developing SharePoint solutions using technologies such as C#, JavaScript, JQuery, CSS, XSLT, REST, Web Services
Responsible for designing SharePoint security schemes and implementing them across environments.
Responsible for installation, configuration and setup of SharePoint 2010 and 2013 systems (Single and Multi-Server Installs).
Responsible for designing different Business Intelligence reports (SSRS), SSIS packages and their deployment.
Responsible for integration and implementation of SharePoint with MS Dynamics CRM.
Responsible for development and customization(JavaScript & JQuery) for MS Dynamics CRM 2011, 2013
Responsible for writing Custom Workflow Assemblies for MS Dynamics CRM 2011
Responsible for integrating external data with CRM 2011 and 2013 online, SharePoint 2013 online (Office 365) using JQuery, Dot NET Web Services and SharePoint Timer Jobs
Responsible for creating complex SharePoint workflows and InfoPath forms
Responsible for upgrading SharePoint 2010 to SharePoint 2013
Environment: C#, ASP.NET, SharePoint 2010, 2013, SP Designer, InfoPath Designer, JavaScript, JQuery, CSS, MS SSRS, SSIS, XSLT, MS SQL Server, MS CRM, Visual Studio 2012, 2013, 2010, Win Server 2008, 2012, TFS, OData, Wakanda, Aptana Studio, CRM Rest Kit, ECMAScript, SP Services Library, CRM 2011 Custom Workflow Assemblies, Data Tables JQuery Library, Kerberos, SharePoint 2010, 2013 Rest API, Simego Data Synchronization Studio
Canadian Pacific Railway, Calgary, AB
Senior Software Developer Feb 2012 – Mar 2013
Project: Shipment Suite & Crew Operations
Worked as a subject matter expert, system analyst and lead developer, supporting over 20 applications ensuring organization wide operational sustainability and maintenance.
Lead a team of 7 developers, assigned work, reviewed code, documents and coordinated with the client to gather requirements for enhancements and issues in current applications.
Coded and developed feature enhancements and implementation of final deployable.
Mentored and coordinated with the team for project delivery and implementation.
Ensured on time and high quality delivery of project implementations and other deliverables.
Implemented application fixes to reduce incident count (reduced 60% in 10 months) and increased overall efficiency.
Environment: C#, ASP.NET (MVC), SharePoint 2007, JavaScript, MS SSRS, XML, PowerBuilder, MS SQL Server, Oracle, IBM MQ Client, SAP BO, UNIX, Win 2000, VS 2008, PVCS, TFS
Lead Developer Jan 2011 – Feb 2012
Project: Gold on Green, Technology Upgrade
Developed and deployed a .Net web service removing dependency on MQ client to transfer data securely over a multi-tier application model.
Developed a SharePoint web part create a dashboard to display the stats of incoming claims, claims submitted, claims pending and other such facts.
Successfully migrated 2 Gold level and 1 bronze level, applications from PowerBuilder 9 to 12.
Mentored a team of 5 members for project execution, development, and testing and release management.
Trained junior resources on Sybase PowerBuilder technology and migration strategies.
Responsible for Configuration Management, ensuring high quality project deliverables and maintaining source control.
Responsible for creating SAD for the migrated applications listing current architectural changes.
Performed an additional role of Knowledge Management Prime for the project.
Environment: C#, ASP.NET, SharePoint 2007, JavaScript, XML, Sybase PowerBuilder, Oracle, IBM MQ Client, UNIX, Win 2000, Visual Studio 2008, PVCS
Software Developer Mar 2010 – Dec 2010
Project: Integrated Train Management
Developed Smart-Client application (MVVM design pattern, Click once deployment) used by Locomotive Managers with over 500 users, for efficient train management and locomotive planning.
Participated in requirement elicitation, estimation, build, code review and testing of different modules of the application.
Worked as Configuration Controller for maintaining all configurable items, project deliverables and source control using Microsoft Team Foundation Server (TFS) and VSS.
Organized project meetings, outlining specific development tasks, priorities, milestones, and reasonable timetables for build, testing and delivering complete application.
Maintained and updated SAD and application support documents as part of the deliverables.
Conducted configuration management audits to ensure high quality project deliverables.
Environment: C#, WPF, WCF, ASP.NET, SmartClient, ClickOnce, NUnit, XML, JavaScript, Oracle, IBM MQs, Win 2000, Team Foundation Server, Visual Studio 2008
Software Developer Jul 2009 to Feb 2010
Project: Yard Planner 2.0 / 2.5
Developed Smart-Client application being used across Canada by over 1000 employees of Canadian Pacific for Yard planning and management.
Participated in requirement elicitation, detailed design, build and testing of various application modules.
Executed test driven development with zero-defect and on time delivery of various modules.
Worked on MS SSRS to generate yard specific data reports.
Wrote technical documents such as System Appreciation Document and Impact Analysis using MS Visio and Class diagrams.
Mentored and guided junior developers through various application development phases of the project.
Environment: C#, ASP.NET, NUnit, JavaScript, XML, Oracle, Chart FX, ILOG Gantt Charts, Infragistics, IBM MQs, Win 2000, VS 2008, Virtual Source Safe, PVCS
Infosys Limited, Bangalore, IN
Software Developer Jan 2009 to Jul 2009
Project: Foundation Program Team Portal
Worked in a team of 4 members on the development of a SharePoint 2007 collaboration portal.
Responsible for requirement gathering, detailed design, build and testing.
Responsible for developing web-parts and integration of out of the box features with SharePoint.
Responsible for creating SharePoint master pages, site collections and Wiki for knowledge management.
Responsible for writing stored procedures, triggers and complex queries.
Developed Automated Examination Management web-part to enable trainers and batch owners at Infosys Learning center to manage and schedule various course tests.
Created optimized interactive web forms using JavaScript and Ajax Control Toolkit.
Wrote technical documents for the web-part such as User Manual, Test Case documents and System Appreciation document.
Environment: SharePoint 2007 (MOSS), C#, ASP.NET, Ajax Control Tool Kit, HTML, JavaScript, XML, MS SQL Server, Oracle, Win 2000, VS 2008, Virtual Source Safe
Organization: S Naidu International, Mumbai, IN
Software ConsultantFeb 2006 to Dec 2008
Project: Newsletter Broadcast and Tracking System
Developed multiple modules using Microsoft .Net Web Services, Windows Services and utility tools, third party components such as EASendMail SMTP component and Service, EAGetmail POP3 Service, ListNanny and CKEditor.
Designed and developed a Newsletter broadcast application to send marketing emails with the capability of sending 30K emails per hour. The application was developed using MVC pattern and had features such as statistical reporting of bounced, read and failed emails using SSRS.
Created optimized interactive web forms using AJAX control toolkit, JavaScript and JQuery.
Designed and developed complete database architecture for the Newsletter broadcast system.
Wrote a windows service to track bounced emails from a mailing list and clear them from database.
Developed multiple bulk export tools from and to database and excel, csv, flat files.
Developed rich content reporting tools using Crystal Reports.
Wrote technical documents and user manuals.
Environment: C#, ASP.NET (MVC), Ajax Control Tool Kit, JavaScript, HTML/CSS , JQuery, XML, MS SQL Server, MS SSRS, EASendMail SMTP component and Service, EAGetmail POP3 Service, ListNanny, CKEditor, Win 2000, Virtual Source Safe, Core FTP, Visual Studio 2008
Accomplishments
Best Software Engineer Award from Unit Head and Delivery Manager at Infosys.
Expression of gratitude certificate from Canadian Pacific Railway for project contributions to on time, on budget and on specifications delivery.
Infosys Excellence Award, for the execution and delivery of the Yard Planner project.
Traction award and multiple appreciations from Canadian Pacific Railway for improvements in application availability through incident reductions and for 100% SLA adherence.
Education
Master of Computer Applications
Bachelor of Computer Applications
Advanced Diploma in Web Development (NIIT)
Certifications
Microsoft Specialist (HTML5, JavaScript and CSS3)
Microsoft Certified Professional (.Net 3.5 Windows Applications)
Cisco Certified Network Associate
Publications
Presented a paper at an International Conference on advanced computing & communication technologies held at Asia Pacific Institute of Information Technology, New Delhi on the “Role of Information Communication Technology in distance learning”. Co Author Prof. Vishal Goyal, Dept. of Computer Science and Natural Language Processing Systems.
References available upon request