Sr SAS Developer & Analyst

Vani Kancherlapalli

***************@*******.***

Objective:

• Obtain a challenging Sr. Level position that will leverage my experience in developmental skills.

Professional Summary:

• 8 years of experience in software development and implementations.

• Experience in Oracle 11g, TSQL, Data Analysis, Data Modeling, PL/SQL programming and Query Level tuning.

• Solid experience in design/develop complex SQL queries.

• Experience in writing stored procedures, database triggers, exception handlers, cursors, cursor variables.

• Experience in design and develop customizations of Web Applications, including DBA activities.

• In-depth understanding of technical and functional areas of e-commerce and n-tier apps.

• Sound understanding of application development methodology and software development lifecycle.

• 4+ years of .NET experience, ASP.NET development with ADO.NET

• Excellent written and communication skills.

• Proficiency in problem solving, logical and analytical abilities.

Technical Skills:

Hardware: Personal Computers, Sun Microsystems

Operating Systems: Windows (NT/XP/2000/2003) (Working Knowledge: UNIX)

Languages: VB.Net, ASP.Net, VBScript, JavaScript, C++, COBOL, C, SQL, Pascal, FORTRAN, Transact-SQL , PL SQL, MS SQL

Software: VS 2000-05, ASP.NET 1.x, IIS 6, MS SQL, Dreamweaver, Photoshop, Saleslogix, Turbo C, Pascal, PC Anywhere, FTPPro, Crystal reports, iReport

Database: SQL 2000,SQL 2005, Oracle 10/11g

IDE: Visual Studio 2005, SQL Developer, Query analyzer

Technical Training:

Oracle Development/Tools: (Mar – Sep 2010)

During this training, I have refreshed my Oracle skills like ER Diagrams, PL/SQL, SQL Tuning, creating stored procedures, database triggers, exception handlers, cursors, cursor variables. Along with oracle training, I have taken in-depth training in Data warehousing concepts.

Programming with ADO.Net (June 2007)– New Horizons, NH

Enterprise Web Development using ASP.Net (Mar 2005) – Learning Tree, MA

Experience:

Applications Programmer June 2006 – Feb 2008

Cadec, NH http://www.cadec.com

One of the lead developer of the transportation management system. Primary responsibilities include design the application & database layer for the new enhanced fleet management application. I am also responsible to create custom solutions for existing customers. Most of custom solutions I am solo person that gathers the requirements to design/develop the solution for the customer. During my stay here I acquired very good system analysis /design skills to explain the solution or design to non-technical personals.

Worked on product migration project from SQL2000/2005 to Oracle.

Technical skills:

• Fluent in C# , VB.Net, ASP.NET, ASP

• Working knowledge of Embedded WinCE

• Good understanding of multi-threaded applications

• SQL Server 2005 and T-SQL experience

• Excellent XML experience with DOM and XPath

• Experience with Crystal reports and iReport (open source)

• Build / Deploy code into OBC (on-board computer) along with unit testing

• Oracle Designer, Oracle Discoverer Reporting Tool

• Fluent in PL/SQL Developer, used for PL/SQL development

• Working knowledge of SQL Developer, Toad

Web Developer Dec 2000 – May 2006

Linkage Inc., MA http://www.linkageinc.com

As a senior member of the IT department my job includes web development, data analysis, and data modeling, create and comply with design and development standards, rigorous testing, reliable implementation and on-going support.

Very much familiar with software life cycle from gathering business requirement collection to designing systems, coding, database design, unit testing and integration testing, deploying to production, maintenance, support, and troubleshooting.

Major Responsibilities:

• Create / Design / Integrate applications into Linkage web site using

• ASP.Net, SQL2000, web services

• Integrate with 3rd party software

• As a lead IT (only developer) person recommend technical solution for business problems.

• Support software / platform upgrade.

• Production support / maintenance

360 Assessments: http://assessments.linkageinc.com

Enhanced, maintain, support and troubleshoot application written in ASP and SQL 2000.

Design, develop, maintain, support and troubleshoot an administrator tool used by project manager in-house to maintain application. Contact person for troubleshooting technical issues.

International Web Site: http://www.linkageinternational.com

Integrate website with their credit processing company. Maintain, support, and troubleshoot website. Work on enhancements as per business requirements, which involved design, code, test, and support.

E-Commerce website:

Integrate 3rd party credit card company for main corporate web site which entails all our online orders.

Integration/ Maintenance:

Software includes Content Management system, a mid level application with options like workflows/rules, ClickTracks application to process weblogs and generate website activity reports. .NetCharting used with application developed using VS 2003, ASP.Net, SQL2000. Key person to integrate which most of time involved a sharp learning curve.

Software Engineer Apr 2000 – Nov 2000

marchFIRST, MA http://www.marchfirst.com

Part of a team to develop the web site http://www.PrincessHouse.com Duties include the design and develop an admin tool for data entry that will be fed into the SQL-Server database using COM objects. Developed dynamical web pages using DCOM objects, MTS and ASP (JavaScript for client side validation / VB Script). This website supports both English and Spanish languages. Part of my responsibility includes version management using Visual SourceSafe and deployment. Tools: NT, Visual InterDev 6.0, and Visual Basic for COM, MTS, ASP, SQL-Server and Visual SourceSafe.

Web Developer Feb. 1999 - June 1999

Interactive Media Solutions, Hingham, MA: http://www.imslink.com

Design and develop the e-commerce shops using Intershop 3.0. Developed two shops: Networking Packaging, NICC Inc. Using Sybase database, Cyber Cash, Dynamic creating the templates, html and Java. Created the development environment on NT Server: Installed NT Server, IIS Server, and Intershop 3.0. Expert in administrating IIS Server, NT Server.

Jr. Software Engineer Feb. 1998 - Oct 1998

Maagnum: e-commerce, Cheshire, CT: http://www.maagnum.com

Duties include enhancing and bug fixing existing web pages. Worked on 9 different projects involving user validation, report capability, data validation and schedule process for backup. Designed and developed one e-commerce shop using InterShop. Most of the development is done on InterDev using VBScript, Active Server Pages (ASPs), HTML and IIS. Visit: http://www.maagnum.com for more details.

Academic courses at USA:

Software Engineering (C++) Algorithms & Data Structures (C, Pascal)

Automata & Theory of Computation (C) Computer Organization

Principles of database (Sybase) Computer Networks(C)

Architecture of Database Systems (Sybase, Oracle) Adv. Algorithms and Data Structures (C)

Training:

UMASS Lowell, MA

SQL using Oracle

Education:

Master’s in Computer Applications September 1995 - June 1996

Siddharatha Engineering College, A.P., India. (Discontinued)

Bachelors in Electronics May 1995

Lady AmritBai Daga, Nagpur, India.

Continue Education

UMASS (Lowell/ Boston); UConn

REFERENCE: Available Upon request.

Contact this candidate