Sohina Poddar
actc9m@r.postjobfree.com 626-***-****
**** ******** **.#***, ******, California, USA – 92612
Hands-on: VB.Net, C#, ASP.NET, WINFORMS, LINQ, T-SQL, MVC, CSS, HTML, AJAX, JavaScript, jQuery, XML, Web Services, Architecture and Design Pattern, Flash, Photoshop,XAML,Bootstrap, MVVM,Agile,Scrum
Databases: Oracle PL/SQL, MS SQL Server
Design: UML, MS-Visio
Frameworks: Entity Framework, TFS, WCF,WPF
Committed to Success: Well-researched, Ingenious, Testable, Solid, Properly Layered, and Maintainable code
Team: 6 Years of experience working in project teams, designing solutions and technical/functional support
360 Communicator: Insightful Client-facing and Team-facing Communication and Presentation Skills
Extreme Documenter: Skilled Requirements, Diagrams, Design documents, Test plans, Requirement Traceability
Inventive and Resourceful: Well-researched, Ingenious, Collaborative, and Maintainable Product Solutions
Summary
Have Extensive experience in System Analysis, Application Design, UI Design, Database Design, Development, Testing, Implementation and Support for various application types like - Windows Applications, Web Based Applications, Object Oriented Programming and Stand Alone Applications.
Strong Experience in .NET Framework, C#.NET, VB.Net, ASP.Net, WINFORMS, HTML, JavaScript, CSS, Ajax, Oracle PL/SQL, MS SQL Server related applications.
Having experience in high volume website development and maintenance.
Experienced in working with n-tier architecture and Telerik Rad controls for .Net applications
Have excellent coding skills by meeting the expected coding standards and by Unit testing the code in all possible scenarios for Quality Assurance.
Good team player with excellent communication and presentation skills with strong aptitude towards learning new technologies.
Certified SALESFORCE developer and admin
Professional Experience
Project #
:
Site Management System (SMS)
Duration
:
June 2015 – Till date
Client
:
Mobilitie
Employer
:
Prelude Systems Inc.
Location
:
Irvine, CA, USA
Description
:
SMS is web based application which is used by Mobilitie users for managing different sites and carriers. This web based app is developed from their existing SMS app which was developed in asp.net and now it’s redesign in MVC4. It has many new features which are developed based on User requirements. A whole new module was developed for T-Mobile Equipment Tracking. A responsive web application is developed which can be used in any screen sizes.
Role
:
Sr. Developer
Responsibilities
:
Providing technical help and support to the team
Analysis of requirements and technical design of the solution
Developing MVC4 App using Bootstrap for responsiveness
Used TFS for version control, task assignments, and builds
Environment
:
MVC4,Bootstrap,C#,TFS,SqlServer,Html5,Jquery,Javascript,Ajax, Agile, Scrum Methodology
Project #
:
Pivit - Point of Sale (POS) - Win RT App
Duration
:
Feb 2015 – Jun,2015
Client
:
Technossus LLC
Employer
:
Prelude Systems Inc.
Location
:
Irvine, CA, USA
Description
:
Pivit is a project to track all customer based daily transactions, provide time clocking, management reporting etc. for retail businesses. This project was developed using multiple technologies such as WPF based Win RT app, Angular JS based web app and Xamarin based mobile app for iOS and Android platforms. My work focused on design and development of the Point of Sale (POS) app developed using WPF/XAML on Win RT platform using entity framework and SQL Server 2014 as the backend database. The POS app deals with the daily transactions, customer management and time clock functionality, cash drawer maintenance to name a few. This product is planned to be completed and sold as a service to multiple retail, food & beverage clients.
Role
:
Win-RT App Developer
Responsibilities
:
Analysis, technical design and developing Win RT App using XAML and MVVM for Windows 8.1 tablet .
Work assignment and coordination with offshore team members .
Used TFS for version control, task assignments, and builds and for scrum meetings
Environment
:
.Net 4.5.1, C#, XAML, MVVM, WPF, Web API, TFS, SQL Server 2014, Win RT, Windows 8.1, Agile, Scrum Methodology
Project #
:
Material Tracking Tool Phase 2
Duration
:
Nov 2014 –Feb 2015
Client
:
UB Technology Innovations. Inc (UBTI)
Employer
:
Prelude Systems Inc.
Location
:
Anaheim, CA, USA
Description
:
The Material Tracking Tool is a tool developed within Northrop Grumman Aerospace Systems (NGAS) for the tracking and forecasting of parts and materials across a program. This tool monitors the progress of material acquisition from demand to receipt. The objective of this phase (Phase II)was to launch a web application front end for the established MTT DB, thus eliminating the need for an Excel front end and the limitations that are inherently built into an excel tool.
Role
:
Sr. Developer
Responsibilities
:
Providing technical help and support to the team
Developing List Pages for different user in MVC 4.0
Used Open Xml to download huge amount of data.
Used TFS for version control, task assignments, and builds
Based on user role giving them different permissions in system.
Working on custom framework developed by clients and using it to develop the project
Environment
:
.Net 4.0, Ajax, Jquery, C#, MVC 4.0, TFS, SQL Server 2008, Entity Framework, Trinity .
Project #
:
Employee Portal – Service Request
Duration
:
Jul 2014 – Nov,2014
Client
:
Prelude Systems Inc.
Employer
:
Prelude Systems Inc.
Location
:
Irvine, CA, USA
Description
:
This Project is to design a platform for employees of Prelude Systems to post their queries to management. It also helps management in keeping track of all the requests posted and answering them efficiently. It helps in generating reports based on performance of different departments in organization.
Role
:
Sr. Developer
Responsibilities
:
Providing technical help and support to the team
Doing authentication and authorization in MVC 4.0
Used Entity framework code first approach to communicate with the database objects
Used TFS for version control, task assignments, and builds
Implementing role based navigation menu
Environment
:
.Net 4.0,Ajax, Jquery, C#, MVC 4.0, TFS, SQL Server 2008,Entity Framework
Project #
:
SCE.com Web Chat
Duration
:
Jul 2013 – Jun 2014
Client
:
Southern California Edison
Employer
:
Prelude Systems Inc.
Location
:
Irwindale, CA, USA
Description
:
This project involved designing and implementing Chat functionality on SCE.com website between SCE customers and CCO Chat Specialists. It involves interaction with the current CCO systems, setup of the e-channel services on the Web Servers and creating new pages using AJAX to for the customers to interact with the CSR.
Role
:
Sr. Developer
Responsibilities
:
Study of requirement and existing systems to be collaborated
High level designing of the system and reviewing detailed designs
Development of AJAX based web page to serve as a web chat window for customer
Used LINQ to SQL to connect to SQL Server database and perform operations such as querying and updating
Collaboration with CCO's existing Genesys Labs product suite to enable Call center representative to receive chat requests from customers of SCE.com website
Integration testing, system test and production roll out support
Used TFS for version control, task assignments, and build
Environment
:
.Net 4.0, VS 2010, MVC 3.0, TFS, Ajax, JavaScript, C#, WCF, LINQ, Entity Framework
Project #
:
SCE.com Web Presentment
Duration
:
Apr 2012 – Jun 2013
Client
:
Southern California Edison
Employer
:
Prelude Systems Inc.
Location
:
Irwindale, CA, USA
Description
:
This project involved designing of new web pages in SCE.com website for SmartConnect enabled customers over the internet to provide more information and better reporting of usage, demand and expenses for the customer. It was a high volume website and heavy on content to be displayed from multiple sources such as Oracle, mainframe, Event Notification System, DataPower and Content Management System.
Role
:
Sr. Developer
Responsibilities
:
Study of requirement and existing systems to be enhanced
High level and detailed designing of the system
Development of AJAX based solutions for quicker responses and overall customer experience on the website
Ensuring cross browser compatibility for all new web pages for IE, Chrome and Firefox browsers
Unit testing, system test and production roll out support
Daily status reporting to the clients, defect analysis with system test team and coordination with offshore development team
Environment
:
.Net 3.5, VS 2010, Asp.net, Ajax, C#, JavaScript, MS SQL 2008 R2, Web Services
Project #
:
GRC(General Rate Case) - Phase II
Duration
:
Jun 2011 – Mar 2012
Client
:
Southern California Edison
Employer
:
Prelude Systems Inc.
Location
:
Chennai, India
Description
:
GRC-II was a project that was enhancement to the existing web based application accessible through the SCE intranet that will enhance the O&M and OOR Work Paper preparation processes. General Rate Case (GRC) is a legal case filed by the client (SCE) to the California Public Utility Commission (CPUC). This involves a huge number of Work Paper Reports that facilitates the process of revising and finalizing the rates of electricity charged to the client’s customers as a utility.
The scope of this project was to develop a web based application accessible through the client’s (SCE) intranet that will enhance the Operations & Materials and Other Operating Revenues Work Paper Report preparation and filing processes to CPUC, by generating timely reports with data based on past recorded and future forecasted data. A major chunk of the application users involved Directors, Presidents and Vice Presidents of the client’s organization and the output was to be submitted to the Government Authorities at the State of California, USA as a binding legal document.
Role
:
Sr. Developer
Responsibilities
:
Study of requirement and existing systems to be enhanced
Analysis and detailed designing of the system
Development of new functionalities including introduction of multi role user logins
Introduction of AJAX based solutions for server intensive processes
Development of Bulk insert stored procedure using table type inputs in oracle stored procedures
Developed few Canned Reports using Crystal Reports 11
Responsible for Admin, Activities and Framework modules
Environment
:
.Net 3.5, Asp.net, Ajax, VB.net, C#, JavaScript, Oracle 10g
Project #
:
Web Presentment
Duration
:
Sep 2010 – May 2011
Client
:
Swosti Hotel, Bhubaneswar, Odisha, India
Employer
:
Unitech (Info) Private Ltd.
Location
:
Rourkela, Odisha, India
Description
:
This project was to enhance the existing software infrastructure and provide an internet based web interface for the customers of the client to be able to search for and place reservations for various lodging options available. It also provided plenty of information about the services available, ongoing and future events and any special discounts available. This really opened up the reservation systems to be accessed by potentially a very large customer base and helped improve profits and revenue growth for the client.
Role
:
Sr. Developer, Knowledge Management Expert
Responsibilities
:
Developed the Framework module using .Net 4.0 and n-tier architecture
Developed JavaScript libraries to perform client side functionality and validations
Delivered change requests from scratch including analysis, design, development and testing
Responsible for all knowledge transitions to new team members, training and maintaining business artifacts
Integration with existing systems and system test support
Environment
:
Net 4.0, Asp.Net, C#, MS SQL 2008 R2, JavaScript
Project #
:
Infrastructure Management
Duration
:
Jan 2010 – Aug 2010
Client
:
Swosti Hotel, Bhubaneswar, Odisha, India
Employer
:
Unitech (Info) Private Ltd.
Location
:
Rourkela, Odisha, India
Description
:
This project was developed to replace the manual searching and booking of rooms and records maintenance activities that the client was used to for over last 15 years. Objective was to provide a role based windows application for the various operators to effectively manage day to day lodging operations for Swosti Hotel. This introduced more accuracy, transparency, user friendliness and faster and more effective operations overall. Role based approach helped easily define and maintain the various approved actions available for different user groups.
Role
:
Developer
Responsibilities
:
Created custom control for Data grid and used by the entire team throughout the application
Worked on Requirement Analysis & Prototype Designing
Prepared detail design documentations
Developed database design including tables, views, indexes and stored procedures
Developed Admin and Common modules
Environment
:
.Net 3.5, VS 2008, C#, VB.net, MS SQL 2008 R2, MS Visio 2007
Project #
:
STPI Library Maintenance
Duration
:
Mar 2009 – Dec 2009
Client
:
STPI (Software Technology Parks of India)
Employer
:
Unitech (Info) Private Ltd.
Location
:
Rourkela, Odisha, India
Description
:
The project involved the development of the software solution for Library maintenance at STPI. This helped in keeping track of the inventory of books, subscription of various magazines, members, monthly enrollment fees and also assessing and charging of late fees on any book if required. It also showed alerts to the staff about the upcoming books to be returned and any artifacts that were overdue. At the end of the each business day, a detailed summary sheet, having summary information about the library usage was generated and archived.
Role
:
Developer
Responsibilities
:
Analysis of system requirements and creation of prototype pages
Creation of use cases, class diagrams and sequence diagrams using MS Visio
Prepared detail design documentations
Developed the web application using .Net 3.5 and n-tier architecture
Designed tables, stored procedures, synonyms and views in Oracle database
Used ODP.Net to connect .Net application to Oracle
Developed JavaScript libraries to perform client side validations on the web application
Used Telerik controls like textboxes, grid, dropdowns for enhanced functionality on the web pages
Environment
:
MS Visio 2007, .Net 3.5, VS 2008, Asp.net, C#, JavaScript, Oracle 9i, Rational Rose
Project #
:
New Hire Training
Duration
:
Dec 2008 – Feb 2009
Client
:
Unitech (Info) Private Ltd.
Employer
:
Unitech (Info) Private Ltd.
Location
:
Rourkela, Odisha, India
Description
:
The project involved developing of an online banking system, wherein the account holder could browse through his/her different accounts. The account(s) under a customer could be of different types depending upon various conditions. He/she could also make payments and update personal details through the application. It was developed with VB.Net as the front-end and Oracle as the database.
Role
:
Developer
Responsibilities
:
Analysis of system requirements and design of use cases using MS Visio
Designed and developed windows forms and MDI forms for VB 6.0 based application
Designed tables, stored procedures and views in Oracle 8i database
Development of application logic using event based pattern
Unit & Integration testing and bug fixing
Environment
:
Visio 2007, VB.Net 3.0, Oracle 8i
Education
Bachelor of Technology (Computer Science & Engineering) graduate degree earned with a CGPA of 8.48 from Padmanava College of Engineering, Rourkela, Odisha, India.
Certifications
1
Salesforce Developer Training & Certification
2
Salesforce Admin Training & Certification
3
MCP 070-306: Developing and Implementing Windows Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
4
MCP 070-305: Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
5
Infosys Campus Connect – Aspiring Developer Certification
6
Software Technology Parks of India – Vocational Training