Sql Server .Net
Resume:
Shraddha Mahadik
SUMMARY
. Seven years of experience in Client /Server, Web and Windows
Applications using Microsoft Technologies and .NET framework.
. Strong in the complete Software Development Life Cycle (SDLC)
including requirements definition, design, programming / testing and
implementation of major systems.
. Strong experience in Object Oriented Programming (OOP).
. Experience in gathering customer requirements and functional
requirements and converting them to technical requirements.
. Expertise in Web-Development technologies like HTML, ASP.NET, XML,
AJAX, Web Services, JavaScript, JavaScript Libraries, JSON.
. Strong in ASP.NET with C#, VB.NET and .NET Framework 3.5/2.0/1.x.
. Good hands on experience working with ASMX & WCF Web Services, WSDL,
SOAP, JavaScript and jQuery.
. Extensively used WCF as a communication with User Interface and
Business logic layer.
. Excellent skills in developing code for the database applications to
interact with the databases, using ADO.NET.
. Strong in front-end GUI development using ASP.NET, ASP, HTML, CSS.
. Experience in creating business components, Custom controls and Web
Services etc.
. Experienced in developing middle tier services as per requirement as
Web Services (WSDL) and WCF.
. Strong experience in writing SQL's, Stored Procedures, Triggers,
Functions and Views on SQL Server 2000/2005/2008 and Oracle 11g.
. Good knowledge in Relational Database Management Systems and
Experience in T-SQL programming.
. Worked on Query Optimization.
. Expertise in development using SQL Server 2000/2005/2008 with
technologies T-SQL, SSRS, SSIS
. Experience in modifying ETL packages - SSIS.
. Extensive experience in handling Internet Information Server (IIS).
. Good experience with Microsoft Visual Source Safe (VSS) and Team
Foundation Server (TFS).
. Good Experience on 3 Tiers - Architecture.
. Expertise in working on platforms like Windows NT 4.0, Windows 9X,
Windows 2000/2003, Windows XP.
. Committed to continual performance development in workplace, thus
adding value to the organization.
. Excellent Team Spirit, Communication, Interpersonal skills and Self-
motivated to implement next-generation paradigms.
. Experience in working with an Off-shore development team.
. Ability to adapt quickly to new technologies.
TECHNICAL SKILLS
. Technology : .Net Framework 1.1/2.0.3.0,3.5
. Web Technologies : ASP.NET, HTML, AJAX, Web-Services, WCF,
JQuery, MVC
. Programming Languages : C#, VB.Net, SQL, XML
. Scripting Language : CSS, JavaScript, JSON.
. RDBMS : MS SQL Server-2008/2005/2000, Oracle 11g.
. Reporting Tools : SSRS
. ETL Tool : SSIS
. Operating Systems : Windows 95/98/NT/XP/7
. Development Tools : Visual Studio 2010/2008/2005/2003.
. Design Tools : MS Office
. Application Server : IIS 5.1/6.0/7.0
. Version Control : VSS, TFS
. Unit Testing and Coding Analysis : Manual Testing
EDUCATION
. Masters of Computer Management
. Bachelor of Computer Science
PROFESSIONAL EXPERIENCE
UPS Paramus NJ May
2013 - Till Date
Senior Software Developer
Projects: ESP (Enterprise Sales Planning and Performance)
Brief Description:
Enterprise Planning & Performance initiative is to develop Enterprise Sales
Planning, Reporting and Compensation processes and systems that support an
integrated sales force. Enterprise sales and planning (ESP) is a complete
application for planning, sales & performance. User can use this system to
plan for the next month, quarter and year and also can track the sales on
the monthly, quarterly and yearly basis. Corporate users use this
application for compensation of their sales resources.
Responsibilities:
. Developed Windows application using VB.Net with Oracle backend.
. Responsible to create and modify pakages in Oracle.
. Created and modified Stored Procedures, Triggers and Queries for
automating various interface tasks.
. Created scripts to generalize the script execution and processes.
. Optimized the process to improve performance, which reduced lines of
code, and prepared
comments for specific business logic.
. Used FarPoint Spread control with sorting, filtering functionalities.
. Worked on excel export using Farpoint spread.
. Completely involved in maintenance, module testing, unit testing and
documentation.
. Prepared design documents with unit test cases.
. Responsible for maintaining, Debugging and resolving the issues in the
application.
. Have Used PVCS version manager as source control to keep versioning of
Source Code, Database Objects.
Environment: Microsoft Visual Studio 2012, .Net Framework 4.0, VB.Net,
Oracle 11g.
KPMG LLP, Montvale NJ Feb 2013 -
May 2013
Senior Software Developer
Projects: eAudIT - eDashboard
Brief Description:
KPMG LLP is an audit, tax and advisory firm. eAudIT is an application for
audit process in KPMG. It provides an electronic workflow environment.
Workflows offer industry-leading audit design flexibility. Electronic
workflow contains rules and regulations from many different countries
around the world. eAudit is a desktop as well as online application. e-
Dashboard is the reporting application under eAudIT. It provides single
view reporting over engagements for clients.
Responsibilities:
. Carried out Windows application development using C#, .Net with SQL
Server database as a backend.
. Responsible for understand Business Requirement Specification and
implement business rules.
. Designed and developed screens for User Interface & Interaction.
. Developed User controls using C# and Telarik Controls.
. Extensively used data binding controls.
. Worked with Excel and Power Point export through .Net.
. Effectively used ADO.NET components such as Data Set, Data Adapter,
Data Reader.
. Created web services and soap which was used in ASP.Net application.
. Proxies are generated for the MT Web Services to achieve dynamic URL
based connectivity.
. Designed and developed web forms, custom controls and web services
using ASP.Net, C# using third party controls.
. Created and modified Stored Procedures, Triggers and Queries for
automating various interface tasks using T-SQL.
. Designed and Developed (SSIS) for importing transactions from various
feeds like MS-Excel and text files.
. Created and published reports using SQL server reporting services
(SSRS).
. Created and consumed WCF web service to add/update the orders data
from/to database
. Developed ETL packages in SSIS to integrate excel data.
. Completely involved in maintenance, module testing, unit testing and
documentation.
. Responsible for maintaining, Debugging and resolving the issues in the
application.
. Have Used TFS 2010 as source control to keep versioning of Source
Code, Merging changes with team members, Storing comments as per the
changes stored in the TFS.
Environment: Microsoft Visual Studio 2010, .Net Framework 4.0, C#, ASP.NET,
ADO.NET, Web servies, MS SQL Server 2005/2008, SSIS, SSRS, TFS, Microsoft
Windows 7.
General Motors, Detroit MI Aug
2011 - Jan 2013
Senior Software Developer
Projects: Opportunity Management
Brief Description:
General Motors is one of biggest automotive industry account in IBM. This
project was built for the Opportunity Management Team of General Motors
Account. Opportunity management enables sales teams to work together to
close deals faster by providing a single place for updating deal
information, tracking opportunity milestones, and recording all opportunity-
related interactions. View opportunities in lists or within detailed
opportunity records with all associated critical information.
Responsibilities:
. Responsible for the complete SDLC of the application from requirement
gathering to deployment
. Designed and implemented Web application using ASP.Net and C#.
. Developed User controls for reusable part of the Web Pages using C#
with ASP.NET.
. Designed and developed screens for User Interface & Interaction also
developed various Search Screens.
. Extensively used web forms and data binding controls like data list
and drop down boxes and Mapping page fields to the database fields.
. Developed dynamic report builder for given entities.
. Worked with jQuery to enhance UI and on AJAZ with Jquery and JSON.
. Used JQuery Library 1.7.1 for developing client side and server side
requirements.
. Build User control for increasing efficiency & minimum coding.
. Effectively used ASP.NET AJAX Toolkit controls like Script Manager,
Update Panel, Modal Popup and AutoComplete Extender within some
existing Web Pages.
. Effectively used ADO.NET components such as Data Set, Data Adapter,
Data Reader as when needed to implement the custom built DAL.
. Developed Data Access Layer as a WCF Service.
. Created web services that write/read XML file data and save the xml
data into the database.
. Created and modified Stored Procedures, Triggers and Queries for
automating various interface tasks using T-SQL.
. Developed Business & management reports in SSRS.
. Developed ETL packages in SSIS to integrate excel data in one of the
sub application.
. Developed utilities as windows application in vb.Net and SQL Server.
. Worked on ASP.Net MVC for one of application.
. Created Controllers and Views in ASP.Net MVC.
. Completely involved in maintenance, module testing, unit testing and
documentation.
. Responsible for maintaining, Debugging and resolving the issues in the
application.
Environment: Microsoft Visual Studio 2008, .Net Framework 3.5, ASP.NET 3.5,
C#, ADO.NET, WCF, Web services, Jquery, MS SQL Server 2005/2008, ASP.Net
MVC, IIS 6.0, Microsoft Windows XP.
General Motors, Detroit MI Apr
2011 - Jul 2011
Senior Software Developer
Projects: Infoweb
Brief Description:
Infoweb project was built for the US HR employees of General Motors Account
to serve general HR related requests / queries of US employees. Infoweb
serves as centralize online repository for US employees to search HR
policies and guidelines and broadcast new or amended policies. Infoweb
serves many online forms to make a request like change in direct deposit,
location change, and international/domestic transfer etc. Infoweb push
approved requests to PeopleSoft database.
Responsibilities:
. Designed and implemented Web application using ASP.Net and C#.
. Developed User controls for reusable part of the Web Pages using C#
with ASP.NET.
. Effectively used ASP.NET AJAX Toolkit controls like Script Manager,
Update Panel, Modal Popup and AutoComplete Extender within some
existing Web Pages.
. Effectively used ADO.NET components such as Data Set, Data Adapter,
Data Reader as when needed to implement the custom built DAL.
. Wrote WCF Service for interoperability.
. Build SSRS reports and used report viewer control to show reports in
ASP.NET pages.
. Created Subscriptions in SSRS to send reports to email group.
. Build SSIS packages to generate XML files on file server for
PeopleSoft.
. Created Controllers and Views in ASP.Net MVC.
Environment: Microsoft Visual Studio 2008, ASP.NET 3.5, C#, ADO.NET, WCF,
MS SQL Server 2008, SSRS, SSIS, IIS 6.0, Microsoft Windows XP.
Fujitsu, Sunnyvale, CA
Oct 2010 - Mar 2011
Senior Software Developer
Projects: WhizibleSEM Customization
Brief Description:
Fujitsu is a leading Japanese information and communication technology
(ICT) company offering a full range of technology products, solutions and
services. This Customization project is to integrate issues from all issue
tracking systems available at client into Fujitsu WhizibleSEM9.0 issue base
module for SLA management.
Responsibilities:
. Responsible for discussing with business users, Analyzing/finalizing
requirement, converting into document for approval.
. Developed modules of the application in C#, ASP.NET.
. ADO.NET objects are used to create the data access layer that fetches
data from database to UI.
. Used JavaScript to hide and show page content and client side
validations.
. Effectively worked on JSON for AJAX request.
. Used XML data reader to integration of XML files into database.
. Developed utilities as windows application in vb.Net and SQL Server.
. Created and deployed Windows Communication Foundation (WCF) services
in ASP.NET.
. Worked on WCF service in Business Access Layer.
. Extensively used stored procedures and created error log reports.
. Responsible for maintaining versions of source code using VSS.
. Worked on code review, code optimization and review coding standard
defined by company, unit testing
. Responsible for documenting and providing the help system for the new
users.
. Creating Patches for release team (QA Team), Confirmation on Test
environment.
Environment: Visual Studio 2008, C#, ASP.NET, WCF, SQL Server 2008, VSS.
ICICI Bank Ltd, India
Nov 2009 - Sep 2010
Senior Software Developer
Projects: Initiative Support 4.0
Brief Description:
ICICI Bank Limited is an Indian diversified financial services company,
offers a wide range of banking products and financial services to corporate
and retail customers through a variety of delivery channels and through its
specialized subsidiaries in the areas of investment banking, life and non-
life insurance, venture capital and asset management.
Whizible Initiative is a web-based system that ensures that ideas and
initiatives are properly captured, evaluated and tracked. It provides a
platform for standardization, stage-gate approval workflow and conversion
of approved initiatives into projects. Whizible Initiatives adopts the
Stage-Gate Methodology and facilitates multiple and extensive reviews of
any project. Initiative Support 4.0 is a maintenance project to support
Initiative Product of compulink for ICICI Bank.
Responsibilities:
. Actively participated in the maintenance phases.
. Handling the support activities like communicating with client,
understanding the issues, doing the impact analysis, effort estimation
and solving the issues.
. Responsible for production support /bug fixing & Release.
. Developed optimized stored procedures for retrieving required data.
. Extensively used JavaScript for UI related changes.
. Used VSS for project tracking and Source Control purpose.
. Creating Patches for release team (QA Team), Confirmation on Test and
Production Environment.
Environment: Visual Studio.NET 2005, ASP.NET 2.0, C#.NET, ADO.NET, IIS 6.0,
SQL server 2005, JavaScript.
Projects: Initiative Customization 4.0
Brief Description:
It provides a platform for standardization, stage-gate approval workflow
and conversion of approved initiatives into projects. Whizible Initiatives
adopts the Stage-Gate Methodology and facilitates multiple and extensive
reviews of any project. This customization project included TAT
Functionality, Define Rules, Integration with WhizibleSEM project.
Responsibilities:
. Actively participated in the design, implementation, deployment,
configuration, and maintenance phases.
. Followed an n-tiered approach to make the application development
flexible and extensible.
. Responsible for writing Client-side and Server-side scripting.
. Resolved browser compatibility and version compatibility problems.
. Developed reusable custom data-access layer using ADO.NET.
. Wrote stored procedures, views and database functions for data
extraction.
. Built some stored procedures in optimized way which are needed for the
reports.
. Designed and developed screens for User Interface & Interaction also
developed various Search Screens for different strategies.
. Extensively used web forms and data binding controls like data list
and drop down boxes and Mapping page fields to the database fields.
. Used ADO.NET as data-access middleware for retrieving data and
updating records in database.
. Created Windows Service to data integration from one application to
another application.
. Implemented source control using VSS.
. Unit-tested during the whole code development process and participated
actively in the integration testing.
. Closely work with QA team.
Environment: Visual Studio .NET 2005, .NET Framework 2.0, C#, ASP.NET,
ADO.NET, IIS 6.0, VSS, SQL Server 2005
Compulink Systems Ltd, India
Dec 2006 - Oct 2009
Software Developer
Projects: WhizibleSEM
Brief Description:
Compulink Systems Ltd is a product and service based organization having
worldwide 200 customers. WhizibleSem is one of the prestigious products of
COMPULINK. It manages every step of project management, including project
creation, task distribution, team coordination, pricing, and fulfillment.
WhizibleSem product released with many service packs with different
functionality addition like:
WhizibleSEM 7.0: In this version Helpdesk module was developed. Helpdesk
module track the requests logged by customers. It has the facility of
Service Level Agreement (SLA) functionality.
WhizibleSEM 7.1: It was being introduced with new feature of Resource
Demand Management.
Scope of this module is- Capturing opportunities and staffing plan,
definition project team structure and Reports.
WhizibleSEM 8.0: This service pack was enhancing usability of current
features of Project module and Helpdesk module. Introduced new features
like Gadgets, project alerts, and enhancement in resource management.
WhizibleSEM 9.0: Scope of this service pack was enhancing usability of
current features of Helpdesk module and Resource Management.
Responsibilities:
Participated in analyzing, designing, development and deployment of service
packs on production.
. Managed team to deliver the service pack functionality.
. Code review of team resources.
. Developed the web application using VB.NET, ASP.NET, ADO.NET, and SQL
Server.
. Designed and developed front end screens with proper validations.
. Involved in system design and for creating database Schemas.
. Involved in writing SQL Stored Procedures and Views for data fetching
and manipulation.
. Writing Triggers to maintain audit trails on data.
. Optimized SQL Server objects to improve application performance.
. Used ADO.NET objects for database communication.
. Interact with the database using Data Adapter, Data Set, Data Table
and Data Reader.
. Designed CSS for uniform look of the web pages.
. Written JavaScript for client side validations.
. Used JavaScript to hide and show page contents.
. Responsible for resolving browser compatibility and version
compatibility problems.
. Used AJAX for partial post back and improve performance to get data.
. Used XML for read data out of system.
. Generated reports using report tool.
. Creating Patches for release team (QA Team), Confirmation on Test and
Production Environment.
. Responsible for documenting and providing the help system for the new
users.
. Involved in extensive testing and debugging of all the modules coded.
Environment: Microsoft Visual Studio 2003, VB.Net, C#, IIS, MS SQL Server
2000/2005, HTML, JavaScript, VSS..
Compulink Systems Ltd, India
Jan 2006 - Nov 2006
Software Developer
Projects: Service Execution Management (WhizibleSEM SP8)
Brief Description:
Compulink Systems Ltd is a product and service based organization having
worldwide 200 customers. WhizibleSem is one of the prestigious products of
COMPULINK. It manages every step of project management, including project
creation, task distribution, team coordination, pricing, and fulfillment.
Responsibilities:
. Designed and developed screens for User Interface & Interaction using
ASP.Net controls.
. Effective use of HTML/CSS to create pages.
. Used JavaScript for client side validations.
. Designed and created database Schemas.
. Used ADO.NET objects for database communication.
. Wrote stored procedures, views and user defined functions for data
extraction and manipulations.
. Report creation using compulink specific report builder tool.
. Responsible for documenting and providing the help system for the new
users.
. Worked on extensive testing and debugging of all the modules coded.
Environment: Microsoft Visual Studio 2003, VB.Net, IIS, MS SQL Server 2000,
HTML, JavaScript, VSS.
Contact this candidate