Sql Server Project

[pic]

Name: Surya Tikkani

Email ***********@*****.***

Phone Cell: 774-***-****, Home: 203-***-****

Number of Years of Experience 10 yrs.

in I.T

EXPERIENCE SUMMARY:

About 10 years of professional experience in complete Software Development

Life Cycle (SDLC) with Analysis, Design, Development, Integration,

Implementation, Maintenance, Debugging, Reports, Testing, Production and

Support of Software Applications in client server environment, Object

Orient Technology and Web based applications and Share Point Web and

Portals.

. Currently Working as Sr. Application Developer for HarperCollins

Services, NY., U.S.A

. Worked with Philly Govt, Cartus, CT., U.S.A, and Citibank., Singapore.

. Experience in software Application Development in Internet and

Client/Server environment & GUI (U.S, Singapore, India and Malaysian

clients)

. 6+ years' experience in sr SharePoint Developer and

Architect

. 7+ years' experience in Microsoft .NET Technologies

. 2+ years' experience in Team lead

. Experience in Designing, Development and Implementation of the

SharePoint technologies SharePoint 2013, 2010, MOSS 2007 and WSS 3.0,

PowerShell including Office 365.

. Experience in installing, configuring and developing Microsoft Office

SharePoint Server 2013/2010.

. Expertise in working with SharePoint Solutions, Features, Web Parts,

User Controls, Lists, Document Libraries, Event Handlers, Nintex

Workflows, InfoPath forms and Templates.

. Experience in SharePoint Object Model Programming to write custom web

parts and workflows to accomplish business tasks and Reporting

services.

. Well versed in Using Business Connectivity Services (BCS) and Business

Data Catalog (BDC) developed code for searching data and maintain the

relational databases.

. Technical expertise includes ASP.NET, VB.NET, C#, ASP, AJAX, WCF,

JQuery, Visual Studio 2012/10, MS-SQL Server 2012/08, Oracle 11, DB2

7.x, Crystal Reports, Web Services, MSMQ and new technologies WPF

(Windows Presentation Foundation), WCF (Windows Communication

Foundation) and MVC architecture patterns.

. Design and Development of User Interfaces using AJAX, JQuery, Rest

Api, JavaScript, VBScript.

. Expertise in Technologies using XSL, XSLT, SOAP, UML & XML Schemas

. Creating external data access for Reporting and other sources like SAP

using External Adopters.

. IIS & windows NT Administration using server Console and ADSI

Programming

. Programing Knowledge on Microsoft BizTalk Server 2006 and 2008

. Good in Creating Stored Procedures, Functions, Triggers, Views,

Schemas, Tables, Constraints, Indexes and Views and DTS/SSIS Packages

also in performance tuning by looking at Execution.

. Worked .Net Remoting and Web Services that allows objects to interact

with one another across application domains.

. Have knowledge on Experience on J2EE (JDK, Servlets, JSP, RMI, CORBA,

EJB) Technologies

. Worked on version control systems like Team Foundation Server and

Apache Subversion.

Education Summary

. Master of Science in Computers from Dr.BR Ambedkar University,

Hyderabad (India) (Part time, Distance Learning)

. Bachelor's Degree in Commerce & Computer Science from Osmania

University, Andhra Pradesh, India

. Diploma in Information & Systems Management in Mega Computers

. .Net Smart Clients (Partner ISV Developer) in Comat Training Services

Certifications

. Microsoft Certified Professional in Programming - MCP (Microsoft)

. Microsoft Certified System Engineering - MCSD (Microsoft)

Technical Skill Set

SharePoint Technologies : SharePoint Designer 2013/10/07, Office

365, WSS 3.0, Infopath

.NET Technologies : C#, VB.NET, ASP.NET, Windows Services,

Assemblies, ADO.NET,

.NET emoting, COM

Interop, Web Services, Active Directory,

LDAP

WPF, WCF, MVC, AJAX,

JQuery, Rest API

Workflow Tools : Nintex Workflow.

Programming Tools : MS Visual Studio 2012/2010, SharePoint

Foundation Server 2013/10

Windows SharePoint Services 3.0, MS Office

2013/2010,

Visual Web Developer, Web Matrix, Dream weaver 4.0

Reporting Tools : Crystal Reports 10, R&R Data Reports, Metrics

Reporter.

Web Servers : IIS 6.0/7.0, SharePoint Server, BizTalk Server,

Java Web Server

Internet Technologies : AJAX, JQuery, Java Script, VB Script,

Jscript, PHP, JSP, HTML, DHTML, XML,

XSL, XST, SOAP, XML

Schemas, Digital Certs, Active Perl 9.0

Distributed Technologies : Web Services, Rest Service, WCF, .NET

Remoting, Queue (MSMQ)

Database : SQL Server 2012/2008 (T-SQL), Oracle 9i/11

(PL/SQL), Teradata,

MS-Access, DB2, MySQL

Office GUI : Visual Basic for Applications (VBA), Macros (Word,

ACCESS, Excel)

Operating Systems : Windows XP/2000/03/08, Vista, NT 4.0/98,

UNIX, MS-DOS

J2EE : JDBC, Servlets, JSP, Swing

Modeling tools : UML, RationalRose, Enterprise Architect, MS

Visio.

Programming Languages : COBOL, C, C++, Pro*C, Java 2.0, Python

Version control Tolls : Microsoft Visual Source Safe 6.0, PVCS

Network monitoring tools : Active watch and APP Matrix

Content Management tools : LMS, HttpFetch

PROFESSIONAL EXPERIENCE:

Organization : HarperCollins News Corporation, (New York, NY)

Position : Sr SharePoint Developer and Architect

Duration : Feb '13 - Till date

Projects: HarperCollins Portals, Billing Reconciliation and Time

Management, Records Management, Document Management, News Gator site,

Setting up Taxonomy fields and FAST Search setup, WCF Service, user profile

synchronization, creation of Organization Subtyps and Properties,

Maintaining HarperCollins websites.

Software: SharePoint Server 2013/10, Office 365, .NET Framework 3.5/4.0,

SharePoint Designer 2010/2013, InfoPath forms, Nintex Workflows, C#,

ASP.NET 3.0/4.5, AJAX, JQuery, HTML, CSS, Java Script, Rest APIs, WCF, MVC

4.0, Windows Server 2008, SQL Server 2008/2012, Power shell.

Description: Developed "HarperCollins" intranet portal with new design,

easy to use navigation and more strategically targeted communications and

services. HarperCollins is powered by Share Point 2010 that improved the

organizational effectiveness in terms of maintaining and managing published

Billing invoices. Various options have been provided in the site for the

content management, enterprise search and facilitating information sharing

across the HarperCollins billing Portal site. The major tasks revolved on

the look and feel and integration with the legacy applications.

Role:

. Involved in HarperCollins Project Planning, Design, Requirements and

Specifications using SharePoint Server 2013.

. Design & Development of SharePoint visual Web Parts Using Visual Studio

2012/2010.

. Written and integrated Rest APIs in Web parts in Site collections

Publishing Templates and Team Site Templates.

. Design Security Model by creating SharePoint Groups and Permission levels

for the site.

. Integrated and developed social site for HarperCollins with third party

plug-ins "Newsgartor" web parts.

. Worked on MVC 4.0 and JQuery and Knowledge on MVC 3.0 and ADO.NET Entity

Model

. WCF services have been used to pull profile information of various

employees in the site.

. Created Master and content pages using SharePoint Designer 2010 to enable

conditional formatting using HTML, JavaScript, CSS.

. Worked on ASP.NET MVC, singleton, Abstract Factory, Factory, Facade

Design patterns

. Worked on moving .net app to Office 365 by creating provider hosted Apps.

. Written PowerShell to automate the process to download prod site to QA on

schedule.

. Created SharePoint Workflows in Visual Studio 2010/2012 and InfoPath

Forms (Task Forms).

. Created dashboards using widgets, KPI and Gantt chart views for the

analysis of various data.

. Formatting and implement consistent look and feel for HarperCollins

SharePoint sites.

. Worked with SharePoint Migration from 2007 to 2010 using Quest Migration

Manager Tool.

. Created Custom data Adapter with third party plug in to pull data from

SAP for analysis.

. Developed Records Management website for HarperCollins to store and alert

critical document info to the various user list using custom workflows.

. Used BCS to retrieve and update data in the database servers.

. Implemented Term Store Management for the managing taxonomies.

. Written various customized .NET Dlls for the Event driven calling

methodologies.

. Customize Out-Of-Box Content Query Web part (CQWP) using XSLT.

. Involved to deploying 3rd party KwizCom's calendar web part in all

environments.

. Used CAML Queries to retrieve information from SharePoint Lists.

. Extensively Involved in Installing, Configuring, Maintaining, Monitoring

and Supporting SharePoint2010 in Development, Testing and Production

environment.

. Used K2 to create and update business workflows for SharePoint.

. Worked as a SharePoint site administrator giving permissions to users and

monitoring health monitor checkups of the site and taking backups every

week.

. Used Webservices to extract data from the SharePoint portal.

. Worked on Web Content Management features to bring all the site into one

Managed Metadata Service Application for Search.

. Capable to successfully manage time, projects, and multiple priorities.

Provide root cause determination for enterprise-wide issues, and able to

work well under pressure and time constraints. Also able to adjust to a

constantly changing, fast paced environment.

Organization : Philadelphia Govt (Philadelphia, PA)

Position : Senior Technical Developer

Duration : June '12 - Feb '13

Project: Content Management, Workflow Authorizations, Customer surveys,

MySite and Wikki sites, Records Management and Document Management.

Software: MOSS 2007, WSS 3.0, SharePoint Designer 2007, C#, ASP.NET 3.5,

ADO.NET, XML, CAML, XSLT SQL Server 2008, AJAX.

Description: The project is developed for Philly Govt informational data to

move to SharePoint Collaboration web sites and giving custom web site pages

and web part to upload and update the content on the site. Provided with

various options in the Share Point site to view and manage the customer

data.

Role:

. Involved in Philly Govt Project Planning, Requirements and

Specifications.

. Developed various Custom List Definitions using Content Types and Custom

Fields.

. Written .NET Service in C# to execute Batch (BAT) file to back up the

SharePoint Sites.

. Used CAML Queries to retrieve information from SharePoint Lists.

. Worked with BizTalk team for creating native adapters, Orchestrations.

. Used Share Point object model to retrieve, change, insert items in a

list, files in a document Library and Custom Lists

. Developed Event Receivers for various Custom Lists.

. Developed BDC Web Parts to Integrate with SAP System.

. Developed various Web user control pages for SharePoint Web Parts.

. Design & Development of SharePoint Web Parts Using Visual Studio 2008.

. Installed Microsoft Office SharePoint Server 2007 on Windows Vista

Environment.

Organization : Cartus Moving and Services Inc, (Danbury, CT)

Position : Senior Developer

Duration : March '07 - March '12

Project: Cartus Quality Control and Management, Customer surveys, UPS

Shipping.

Software: MOSS 2007, WSS 3.0, SharePoint Designer 2007, C#, ASP.NET 3.5,

ADO.NET, XML, CAML, XSLT SQL Server 2005, AJAX.

Description: The project CQCM is developed for Cartus Quality control team

to maintain and manage their regular customer feedbacks and customer moving

information on the SharePoint web site. Quality team can upload document

information and can be used for excel services for their ETL reports.

Customer moving service information can be shared across the portal sites.

Provided with various options in the Share Point site to view and manage

the customer data.

Role:

. Involved in Cartus Project Planning, Requirements and Specifications.

. Developed various Custom List Definitions using Content Types and Custom

Fields.

. Written .NET Service in C# to execute Batch (BAT) file to back up the

SharePoint Sites.

. Created & Configured Content Types using Out Of the Box

. Assigned permission levels using SharePoint Out of the Box.

. Created Custom Lists and Library using SharePoint Out of the Box and

giving various levels permissions.

. Developed Solution Deployment Packages (WSP) and deployed into the Share

Point

Organization : Wilmington trust BANK (Wilmington, DE)

Position : Technical Developer

Duration : July '05 - Feb '07

Project I: PAS (Planers Analysis System) site

Software: MOSS 2007, WSS 3.0, Share Point Designer 2007, C#, ASP.NET 3.5,

ADO.NET, XML, CAML, XAML, XSLT, Active Directory, SQL Server 2005.

Description: project has been developed for the Bank fund planners and

managers to upload and update distributed hedge Funds and Fixed Income

Funds information and documents to the one area. Every fund planner have

individual portal site to upload and maintain day to day investment

documents and viewing the investment transaction results in the site in

grid form.

Role:

. Involved in Requirement gatherings from various departments for the

project.

. Developed SharePoint designer workflows for Calendar Lists.

. Created different views using filtering and grouping of SharePoint

Lists.

. Pull data from the SQL Server and show analysis in the dashboard.

. Designed & Developed Custom Web Parts for various requirements on the

Project Sites.

. Developed Share Point Workflows with Visual Studio 2005 and InfoPath

Forms (Task Forms).

. Installed and Configured SharePoint Server 2007 Development

Environment.

. Customized Sites using SharePoint Designer 2007 and extensively used

Data View web parts to present the data.

. Developed various types of Workflows using State Machine and

Sequential Workflows.

. Backup and Restored the Content Databases from Production to Dev

Environment.

. Developed Custom Site Definition for the Final Site.

. Design and Development of SharePoint Web Parts Using Visual Studio

2005.

Project II: QIAS (Quality Investment And Analysis System)

Software: VS 2005, ASP.NET, C#, Web Forms, Win Forms, XML, XSL, Web

Services

ADO.NET, SQL Server 2005, SQL Reports, .NET Data Access

Framework Library

Microsoft BizTalk Server

Description: "QIAS" was developed for providing an option to the "Planners"

team in the organization to analyze and view market investments and Fund

distributions details. "Planners" can check the productivity of investments

and if required these can be updated or moved into different market areas

on the fly by using web forms in the application. The application sends

message streams to the main portal in order to update these details in

their database like Teradata and DB2 and will be updated back to the main

application with the actual details and updates into SQL server database.

Created web ports for the banks SharePoint site.

The application divided into Investments and Analysis

. Getting detailed Analysis of the investments of various markets.

. Moving Investments to a deferent markets with the proper Joint securities

Role:

. Developing & Coding, design and business logic implementation of the

entire project.

. Application heavily utilizes ADO.net (DataSet, DataReader) for data

retrieval information and used DataGrid and DataList controls for Data

manipulation in the Database.

. Involved in database design and structures, Stored Procedures, views,

scripts in to the SQL.

. Used XML complaints in order to keep production updates with minimal

impacts.

. details and Transaction entries in the SQL server and DB2 databases.

. Created web services with Data Access Layers and Cashing for the faster

data access.

. Worked with BizTalk team for creating native adapters, Orchestrations.

. Written Multilevel Query language in the script blocks in order to

process the data in QIAS Database. Used Stored Procedures, Views with

clustered and non clustered indexes.

. Did automated Import Process from Office applications (MS Access) to the

main master database tables using .net Technology ADO.NET Jet data Reader

sets.

. Involved in creating "SQL Business Objects" to Estimate Data Relation

and Performance. Created SQL Reports like Master detail, Cross tab and

Chart reports and executing those reports using ASP.NET Web Forms.

. Exception Handling, maintaining Log files and applications Logs for the

system.

. Involved in unit testing and integration testing of various modules.

. Used Visual SourceSafe to keep track of version control.

Organization : Citi BANK, Singapore

Position : Developer

Duration : Feb '03 - Jun '05

CAS (Chargeback Analysis System)

Software: ASP.NET, VB.NET, Web Forms, Win Forms and SQL Server

Description: "Chargeback Analysis System" is the project implemented for

charging aginst Live applications running under multiple production

servers for different countries. The Software calculates Client

transactions per minute and total number of pool connections and CPU Load

and estimates the charges. Application has been utilized by 70+ countries

in the world.

The application divides transactions as Cards and Banks.

. Upon completion of User ATM Card or Credit Card Transactions the

detailed summery will be stored in SQL server through stored

procedures and functions.

. Bank Transactions like Check deposits, Check transfers etc will be

stored by user forms using Win forms and Web forms.

Organization : Aculearn Systems (p) Ltd, Singapore

Position : Senior Programmer cum Team Leader

Duration : March '01 - Jan '03

Project I: Internet Data Conferencing application with data security

Duration: Nov 02 to Jan 03

Software: C++, VB6, ASP, VB, XML, SQL Server, Windows and UNIX

Description: Developed data conferencing application for the Internet. This

is a powerful combination of Internet and client server technology. The

application is multi tier with business logic. Created generic COM+

components deployed on the Internet to communicate with different users in

secured manner with fewer resources. The data flow is overcome complex

firewalls and proxies using "http tunneling" methodology to the end user.

Project II: Portable Studio Station & Content replication Manager

Duration: Mar 01 to Feb 02

Software: ASP, VB5, VBA, XML, Oracle, Windows

Description: PSS is developed for capturing Audio/Video content. The

Captured content is formatted in various forms that can be viewed through

Web or Client/Server environments. CRM objective is to distribute steaming

media and related html files to IIS and WMS near to the desktops.

Organization : Esteem Infosys Software (P) Ltd. INDIA

Position : Senior Programmer

Duration : Jan'98 to Feb'01

Project I: Electronic Order Processing System

Software: VB, Active X, Oracle and Windows

Project II: Online Shopping SSP, NEWYORK, USA

Software: ASP, VB, XML, Oracle and Windows.

Contact this candidate