Sql Server .Net
Resume:
SASIDHAR PANTA Mob: **+
ab936r@r.postjobfree.com
SUMMARY
. 8 years of multifaceted Software experience in the planning, designing
and implementing Internet - based distributed applications. Hands on
experience in the development and maintenance of projects related to
Project management (PPM) and Enterprise Domain Handling in with
Microsoft Technologies (VB.Net, C#.Net, ASP.Net, Web services, Sliver
light concepts) and SQL Server, HTML, XSL, JavaScript, XML, CSS,
XHTML, Ajax, PHP, Oracle.
. Advised
. Expertise in developing applications using OOPS concepts and full
Software Development Life Cycle (SDLC) with MVC architecture.
. Good knowledge in implementing advanced concepts like WCF (Windows
Communication Foundation), WPF, WWF, WCS, LINQ to XML and Winforms.
. Expertise in Dot Net Winforms (Windows applications) with C# and
VB.Net in MVC architecture using Oracle 9i and SQL Server data base.
. Expertise in developing Web Services based on Service Oriented
Architecture (SOA) and multi-tier applications.
. Expertise in using Change management, Release management and code
version tool like PVCS for code migrations, versioning and back up.
. Enhanced knowledge on Design patterns and MVC architecture.
. Expertise in Visual Studio 2008/2005/2003, .NET Framework 2.0/1.1/3.5,
C#, Oracle 10g ADO.NET, Web services, SQL Server 2005/2008, AJAX,
Enterprise Library, Web Services and IIS.
. Expertise in developing projects with Java and J2EE with Oracle 9i
data base.
. Expertise in developing projects with ASP.NET, C#, ADO.NET, XML and
Web Services.
. Good Knowledge in C# programming and Object Oriented Programming
concepts.
. Experienced in database programming of Stored Procedures, Triggers and
Cursors using MS SQL Server (T-SQL).
. Good knowledge on client side validation technologies like AJAX,
JavaScript.
. Extensive knowledge of the relational database concepts and Proficient
in the data manipulation using SQL for the retrieval of data using
(inner joins, outer join, group by, order by, cursors etc.).
. Good experience in developing Visual basic Macros in Excel.
. Good expertise in dealing with change management or process control
and dealing with L2 or L3 support activities.
. Good knowledge on preparing UML and class diagrams.
. Designed and implemented Backup and Recovery strategies by taking cold
backup and hot backup.
. Hands on experience in analyzing the business, technical, and
functional requirements to develop the Test plans, Test cases, Test
Scripts and Test strategies, Execution of tests and reporting defects.
. Performed GUI Testing, Performance/Stress/Load Testing, Functionality
Testing, Back-end Testing using SQL, Unit Testing/Integrated Testing,
White Box Testing, Defect Tracking Using Automated Testing Tools QTP.
TECHNICAL
SKILLS:
Web Programming : VB.Net with ASP.Net, Winforms (Windows applications),
XML, HTML, DHTML, Java and Classic ASP
Programming Language: C, C++, Pascal, Visual Basic 6.0 (VBA), JavaScript,
VB Script, Manual and automation Testing.
Database : MS-SQL 2000/2005 and 2008, Proficient in T-SQL, Oracle-PL
SQL, Oracle 9i and Oracle 10g.
Other Technologies : SQL Server Integration services (SSIS),SQL Server
Reporting Services, SQL Server 2005 Analysis Services, IIS
6.0,QTP Automated testing tool, SOA Concepts, WCF Concepts,
.Net Framework 1.1/2.0/3.0/3.5, Excel macros.
PROFESSIONAL
EXPERIENCE:
TOYOTA - Toyota manufacturing Kentucky, Erlanger, KY Sep 2011-Till
Date
Technical Architect and Senior Dot Net developer
Tool: Plan View Project management tool
. Languages: .Net Framework 3.0, SAP BO(Business objects),SSAS-Analysis
services ASP.Net, C#.Net, VB.Net, HTML, XSL, JavaScript, XML, CSS,
XHTML, Ajax, Macros, CSS, WCF (Windows Communication Foundation),
SSIS.
Database: SQL Server 2005/2008, Oracle 9i/10g.
Responsibilities:
. Customize the application as per the Customer requirements on
functional side like adding new request lifecycles, Alternate
structures, Fields from PlanView application front end.
. Training users and working with project managers on gathering
requirements on business intelligence reports.
. Transactional data base customization by adding some objects like
stored procedures, Views to data base and Data mart customization for
reports.
. Involved in some development activities like Resource structure
updates and organization structure customizations from back end.
Example like custom scripts prepared for Bulk User upload and
resources cost details updating from back end.
. Worked in PlanView Administration activities like Upgrading servers
with latest PlanView enterprise versions and training End users and
other technical, functional team members on the impacts of the
upgrades.
. Working in upgrading PlanView versions and maintaining daily jobs
like Progression, Data mart (DM) and ESE (Enterprise scheduling
engine).
. Working in SAP BO (Business objects) reports development.
. SSAS-SQL Server Analysis services cubes refresh.
. Used PVCS for code version tool for code migrations and back up.
. SQL server expertise, queries using complex joins, sub-queries and
aggregations.
UHG - United Health Group, Plymouth, MN Mar 2011- Sep 2011
Sr Techno Functional consultant
Tool: Plan View Project management tool
. Languages: .Net Framework 3.0, ASP.Net, C#.Net, VB.Net, HTML, XSL,
JavaScript, XML, CSS, XHTML, Ajax, Macros, CSS, WCF (Windows
Communication Foundation), WPF and Win forms, SSIS.
Database: SQL Server 2005/2008, Oracle 9i/10g.
Responsibilities:
. Customize the application as per the Customer requirements on
functional side like adding new request lifecycles, Alternate
structures, Fields from PlanView application front end.
. Transactional data base customization by adding some objects like
stored procedures, Views to data base and Data mart customization for
reports.
. Involved in some development activities like Resource structure
updates and organization structure customizations from back end.
Example like custom scripts prepared for Bulk User upload and
resources cost details updating from back end.
. Worked in PlanView Administration activities like Upgrading servers
with latest PlanView enterprise versions and training End users and
other technical, functional team members on the impacts of the
upgrades.
. Extensively involved of the Performance Tuning of Production database
which includes identification of Resource consuming / Problematic SQL.
Also tuning at the database level to ensure Optimal Performance of
Database using Auto trace.
. Used PVCS for code version tool for code migrations and back up.
. SSIS (SQL server Integration services) package is used for DTL
activities.
. Wrote complex SQL queries, Functions, Packages and Stored Procedures.
. Daily Monitoring of alert log files for errors, trace files and archive
log destination files.
UHG - United Health Group, Plymouth, MN Mar 2011- Till
date
Technical consultant/Dot Net Interface Development Lead
Tool: Plan View Project management tool
. Languages: .Net Framework 3.0, ASP.Net, C#.Net, VB.Net, HTML, XSL,
JavaScript, XML, CSS, XHTML, Ajax, Macros, CSS, WCF (Windows
Communication Foundation), WPF and Win forms, SSIS.
Database: SQL Server 2005/2008, Oracle 9i/10g.
Responsibilities:
. Customize the application as per the Customer requirements.
. Studied and analyzed the business requirements, designed entity
relationship diagram using Erwin.
. Design, Development and Support of ASP.Net web applications.
. Transactional data base customization by adding some objects to data
base or Data mart customization for reports.
. Web development experience using ASP.NET with C# on the back-end,
including client-side HTML, XSL, JavaScript, XML, CSS, XHTML, and
Ajax.
. Used MVC architecture for design patterns.
. Used PVCS for code version tool for code migrations and back up.
. Used advanced concepts like WCF (Windows Communication Foundation),
WPF, WWF.
. Used PVCS for code version tool for code migrations and back up.
. SSIS (SQL server Integration services) package is used for DTL
activities.
. Used Excel and VB Macros for data processing and formatted data, for
adding more advantages to the project.
. Troubleshooting of web-based applications developed in HTML.
. SQL server expertise, queries using complex joins, sub-queries and
aggregations.
. Extensively Used XML, HTML, CSS and ASP.NET controls for designing the
User Interface.
. ADO.NET was used to implement the data layer to communicate with
different databases (Oracle).
. Wrote complex SQL queries, Functions, Packages and Stored Procedures.
. Examining the packages/procedures for production Rollouts.
. Daily Monitoring of alert log files for errors, trace files and
archive log destination files.
CITI - Planview, Tampa, FL
Sep 2007- Feb 2011
(EPM-Enterprise Portfolio Management)
Onsite-Technical PV consultant/Dot Net Development Team Lead
Tool: Plan View
. Languages: .Net Framework 3.0, ASP.Net, C#.Net, VB.Net, HTML, XSL,
JavaScript, XML, CSS, XHTML, Ajax, Macros, CSS, WCF (Windows
Communication Foundation), WPF, Hibernate, WWF, WCS, LINQ and Winforms
concepts.
Database: SQL Server 2005/2008, Oracle 9i/10g.
Responsibilities:
. Customize the application as per the Customer requirements.
. Design, Development and Support of ASP.Net web applications.
. Transactional data base customization by adding some objects to data
base or Data mart customization for reports.
. Web development experience using ASP.NET with C# on the back-end,
including client-side HTML, XSL, JavaScript, XML, CSS, XHTML, and
Ajax.
. Used MVC architecture for design patterns.
. Used PVCS for code version tool for code migrations and back up.
. Used advanced concepts like WCF (Windows Communication Foundation),
WPF, WWF, WCS and Winforms for adding more advantages to the project.
. Used PVCS for code version tool for code migrations and back up.
. Used Excel and VB Macros for data processing and formatted data, for
adding more advantages to the project.
. Custom scripts prepared for Bulk User upload and resources cost
details updating from back end.
. Troubleshooting of web-based applications developed in PHP (Object-
oriented Scripting Language) and HTML.
. SQL server expertise, queries using complex joins, sub-queries and
aggregations.
. Used Grid View, Dataset and Data Reader to retrieve, display and
manipulate data.
. Extensively Used XML, HTML, CSS and ASP.NET controls for designing the
User Interface.
. Developed data tables as schemas to create reports and designed Master
pages for the website to get rich look.
. ADO.NET was used to implement the data layer to communicate with
different databases.
. Maintaining or monitoring different planview services like Turbo enter
praise scheduling engine(ESE), project connector, etc and daily jobs
like Data mart ETL, Daily tables, EPM and PPM jobs.
. Extensively worked in the Performance Tuning of Production database,
this includes identification of Resource consuming / Problematic SQL.
Also tuning at the database level to ensure Optimal Performance of
Database using Auto trace.
. Wrote complex SQL queries, Functions, Packages and Stored Procedures.
. Examining the packages/procedures for production Rollouts.
. Daily Monitoring of alert log files for errors, trace files and
archive log destination files.
Satyam Computer services limited, INDIA Mar 2006 -
Aug 2007
Dot Net Developer
Tool: Project Risk management
Languages: VB.Net, ASP.Net, HTML, Java Script.
Database: SQL server 2000
ESupport-Satyam is a division of Satyam and this unit develops and manages
different projects Satyam global.
Corporate Services is a Strategic Support Unit that helps to maximize
the business development efforts of the Business Units. The inventory team
will receive the stock, issue the stock and ensures that the requirements
of other business units and SSUs with regard to consumables & policy items
are met in right time. A request made by a user will be sent to the
concerned person based on the user setup in the hierarchy and also based on
the request type. Once the request is approved it moves to the next step in
the process.
Responsibilities:
. Designed and implemented a front end for the application using Java
that worked the usage of display data from the backend Oracle 9i
. Developing Web Services based on Service Oriented Architecture (SOA)
with HTML, XSL, JavaScript, XML, CSS, XHTML, Ajax.
. Developed an alert system to alert admin team if the system fails
while performing any actions.
. Writing Stored Procedures, Functions and Triggers.
. Developed Client side validations using JavaScript and Validation
Controls
. Installed different versions of Oracle (7.x / 8i /9i) on different
operating systems (Windows) Created and managing the database objects
such as tables, indexes and views.
. Create the users and roles.
. Performing the logical and physical structure of tables, indexes,
modeling, normalization and foreign key constraints.
. Database maintaining including backups, recovery, imports/exports.
. Monitoring the database daily activities.
. Responsible for writing database programming to Store/Retrieve the
information from the database using PLSQL.
SDC Technologies, Bangalore, INDIA
Mar 2005 - Feb 2006
Dot Net Developer
Tool: Inventory management
Languages: VB.Net, ASP.Net, HTML, Java Script.
Database: SQL server 2000
Inventory management unit develops and manages Inventory management that
track and maintain across different locations of Satyam global.
Corporate Services is a Strategic Support Unit that helps to maximize
the business development efforts of the Business Units. The inventory team
will receive the stock, issue the stock and ensures that the requirements
of other business units and SSUs with regard to consumables & policy items
are met in right time. A request made by a user will be sent to the
concerned person based on the user setup in the hierarchy and also based on
the request type. Once the request is approved it moves to the next step in
the process.
Responsibilities:
. Developing Web Services based on Service Oriented Architecture (SOA)
with HTML, JavaScript, XML, CSS, XHTML, Ajax.
. Developed an alert system to alert admin team if the system fails
while performing any actions.
. Writing Stored Procedures, Functions and Triggers.
. Developed Client side validations using JavaScript and Validation
Controls
. Created and managing the database objects such as tables, indexes and
views.
. Create the users and roles.
. Performing the logical and physical structure of tables, indexes,
modeling, normalization and foreign key constraints.
. Database maintaining including backups, recovery, imports/exports.
. Monitoring the database daily activities.
. Responsible for writing database programming to Store/Retrieve the
information from the database using PLSQL.
EDUCATION
. Bachelors of Technology in Computer science (B.Tech), JNTU, India.
Contact this candidate