Post Job Free
Sign in

Sql Server .Net

Location:
Dublin, CA
Posted:
February 06, 2015

Contact this candidate

Resume:

[pic]

Santhosh Bitla

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

Phone: 732-***-****

Professional Summary:

. Over Eight Years of IT experience with Four years experience in the

Salesforce.com(SFDC) CRM Platform both as an Salesforce consultant; and

Three years of experience with Microsoft .Net technologies with expertise

in Software Development Life Cycle (SDLC) including analysis, requirement

engineering, architecture design, development, enhancements, testing,

deployment and maintenance of standalone, Multi-tier, web-based

enterprise applications.

. Strong knowledge of sales, marketing, service and support automation.

. Experience in administration, configuration, Implementation, and

Support of Salesforce(SFDC) CRM, and Salesforce SFA applications based

on Apex Language

. Worked on the designing of custom objects, custom fields, role based

page layouts.

. Experience working with custom Tabs, custom reports, report folders,

report extractions to various formats, Snapshots, Dashboards.

. Design of Visual Force Pages, Apex Classes, Controllers & Triggers,

and various other components as per the client and application

requirements.

. Experience working with Force.com IDE and salesforce.com (SFDC) Sandbox

environments.

. Experience in working with Eclipse IDE with Force.com Plug-in environment

for writing Business logic in Apex Programming Language.

. Used Force.com Web services API for implementing web services in the

application for access to data from different users.

. Worked on junction objects and implemented various advanced fields like

Picklist, Custom Formula Fields, Field Dependencies.

. Experience working with Validation Rules, Work Flows, and Approval

Processes for automated alerts, field updates, and Email generation

according to application requirements.

. Implemented security and sharing rules at object, field, and record level

for different users at different levels of organization. Also created

various profiles and configured the permissions based on the

organizational hierarchy.

. Experience working with Import wizard and Data Loader for inserting,

deleting, exporting bulk records.

. Experience working with Salesforce Explorer tool.

. Experience working with Customer Portal and Sites in Salesforce.com

(SFDC).

. Developed N-Tier Web Applications in .NET 1.1/2.0/3.0 environment using

MS Visual Studio 2003/2005, C#, VB.NET, ASP.NET, ADO.NET, XML, Web

Services, Oracle and SQL Server 2005.

. Experience in client side technologies like AJAX, Java Script 1.2/1.8,

and CSS.

. Experience in HTML, DHTML, Adobe Photoshop, Dreamweaver.

. Extensive experience in creating Stored Procedures and Triggers using T-

SQL (SQL Server 2000/2005) with tools like Query Analyzer.

. Excellent team player, self-motivated, quick learner with good

communication skills and trouble-shooting capabilities.

Technical Skills:

Salesforce Skills Apex Language, Apex Classes/Controllers, Apex Triggers,

SOQL, SOSL, Visual Force Pages/Components, Workflow rules,

Approval Processes, Validation Rules, Formula Fields, Page

layouts, Reports, Dashboards, Analytic Snapshots, Custom

Objects, Force.com Eclipse IDE Plug-in.

Languages Apex, Visual Force, C#, ASP.NET, VB.NET, C, C++, Java

Script, HTML and SQL

Web Design Tools Visual Studio 2008/2005/2003, SQL Query Analyzer, Adobe

Photoshop, Dreamweaver and Adobe Acrobat Pro.

Operating Systems Windows NT / 2000 / XP Pro / Vista/ 7, Windows Server 2000 /

2003 / 2008.

Professional Experience:

Client: Citi Mortgage

Sep 11 - Dec 14

Location: St Louis, MO

Role: Salesforce (SFDC) Consultant

Responsibilities:

. Extensive experience in designing of custom objects, custom fields, Pick

list, role based page layouts, Workflow Alerts and Actions, and Approval

Workflow, Validation Rules, Approval Processes, custom Tabs, custom

reports, report folders, report extractions to various formats, design of

Visual Force Pages according to application requirements.

. Good development experience with Apex Language, Apex Trigger, Apex

Scheduler, Batch Apex, Apex Class & Apex Web Service, Partner WSDL &

Enterprise WSDL, Visual Force (Page, Component & Controllers).

. Used Force.com SOAP API Web services and outbound messaging for

implementing web services to integrate External systems.

. Design solutions to improve the customer service using Service Cloud

implementation.

. Improved and automated the Case handling process and implemented

Knowledge.

. Implemented Custom Lead conversion process and worked with Accounts,

Contacts and Opportunities.

. Ability to write complex SOQL, SOSL queries across multiple objects

within the SFDC database

. Good exposure to AppExchange applications. Able to find appropriate

applications, install and customize.

. Experience in creating unit test cases and coordinated change requests to

drive the business requirements during Integration and testing stages and

reviewing the application

. Proficiency in SFDC Administrative tasks like creating Profiles, Roles,

Users, Page Layouts, Email Services, Approvals, Workflows, Reports,

Dashboards, Tasks and Events.

. Extensive experience in data migration and integration using Data Loader.

. In-depth experience in CRM business processes like Lead Management and

Case Management.

. Integrated Salesforce with Eloqua for Email marketing.

. Experienced working with salesforce.com sandbox and production

environments, also with Eclipse IDE.

. Having experience in Sales force API programming.

. Strong communication and inter-personal skills with ability to work well

in a dynamic team environment.

Environment: Salesforce.com, Fore.com IDE, Apex, Data Loader, Import

Wizard, SF Explorer, Apex, Visual Force, Xml, Html, Customer Portal, Sites

etc.

Client: WGBH

Jan 11 - Aug 11

Location: Boston, MA

WGBH is a non profit broad casting organization located in Boston MA.

Role: Salesforce (SFDC) Consultant

Responsibilities:

. Worked primarily on Customer portal and Sites for Applicant Tracking

System (ATS) project.

. Worked on the Custom Objects and their relationships.

. Designed the whole Applicant Tracking system application in SFDC.

. Experience working with relationships (master detail relationships and

lookup relationship).

. Designed and developed the Careers application and uploaded it in to the

WGBH site.

. Developed Visual Force pages for careers application where applicants can

fill out their details and apply for a position.

. Worked on Visual Force pages and Apex controllers and Controller

extensions for developing careers application.

. Worked on Triggers, Validation rules, Work Flow rules etc while

developing careers application.

. Developed visual force pages (Wizard style) for applicants to fill their

information.

. Worked on Approval Process, Reports, Page layouts, Dashboards.

. Experience working with all the three types of Reports (Tabular,

Summarized and Matrix reports).

. Also took part in Administration and configuration.

. Worked on Force.com IDE Plug-in using Eclipse while writing controllers

and for configuration changes.

. Worked on SOQL and SOSL for retrieving records.

. Used SOQL & SOSL with consideration to Governor Limits for data

manipulation needs of the application using platform database objects

. Worked on Force.com IDE tool (eclipse) for writing apex code, refreshing

sandboxes and for deployment.

. Used Data Loader for insert, update, and bulk import or export of data

from Salesforce.com objects. Used it to read, extract, and load data from

comma separated values (CSV) files.

. Worked on sending automated emails.

. Developed test methods to ensure the code coverage is more than 75% in

order to deploy it in to the production.

Environment: Salesforce.com, Fore.com IDE, Data Loader, Import Wizard, SF

Explorer, Apex, Visual Force, Xml, Html, Customer Portal, Sites etc.

Client: WGBH

Aug 10 - Dec 10

Location: Boston, MA

WGBH is a non profit broad casting organization located in Boston MA.

Role: Salesforce Consultant.

Responsibilities:

. Worked on WGBH Events (programs) link on WGBH site.

. Worked on the Custom Objects and Custom fields and their relationships.

. Actively participated, Analyzed and identified all the requirements.

. Designed and developed the Events application as per the requirements

gathered.

. Developed various Visual Force pages which show all the current and

featured events of WGBH.

. Written several Apex Classes and Triggers to implement the logic.

. Developed various Workflow rules and actions to automate the process.

. Built Reports and Dashboards to show the weekly and monthly events in

WGBH organization.

. Worked on Data loader to import all the Event records into the Salesforce

form their earlier database.

. Experience working with SOQL & SOSL with consideration of Governor

Limits.

. Used Force.com IDE for developing and deploying the code.

. Code Migration from one environment to other.

. Documented all the components, processes and test cases.

. Supported the Project after go -Live, fixed all the bugs and re-deployed

to PRD.

Environment: Salesforce.com, Fore.com IDE, Data Loader, SF Explorer, Apex,

Visual Force, Xml, Html, Sites etc.

Client: DHL (Dalsey, Hillblom and Lynn)

Aug 08 - Jul 10

Project: DHL Web Shipping International

Role: .NET Developer

Responsibilities:

. Interacted with business users for requirements and developed the Use

Cases & mockups for the approval for implementation.

. Developed necessary modeling diagrams like Class and Sequence Diagrams

using Unified Modeling Language (UML).

. Developed user interface using web forms, ADO.NET, ASP.NET, VB.NET and

HTML.

. Built various user controls as reusable components using C# and VB.NET,

and incorporated them in application.

. Designed application architecture leveraging .NET Framework and utilizing

Microsoft Practices and implemented Object Oriented Analysis and Design

(OOAD) methodologies using UML design Patterns.

. Involved in the development of Business Objects Layer, Data Access layer

and Presentation Layer using C#, VB.NET, and ASP.NET as development

language.

. Designed database layer to connect, retrieve and to manipulate database

information through ADO.NET, with transactions and stored procedures.

. Extensively worked on Photoshop, Dreamweaver, and client side

technologies like Java Script, CSS, and AJAX.

. Designed database (Tables, Views, Transactions, Stored Procedures, and

Triggers) in T-SQL and retrieved data using ADO.NET and LINQ to SQL from

MS-SQL Server 2005.

. Created components for interaction between the database layer and

business layer and also between business layer and the presentation

layer.

. Supporting the applications for issues in all the release cycles and in

production.

. Coordinating and exchanging views and ideas with various team members and

client during the development process.

Environment: .NET Framework 2.0, MS Visual Studio 2003, MS SQL Server 2000,

ASP.NET, ADO.NET, C#, VB, MS Access, T-SQL, AJAX, Web Services, HTML,

XML, CSS, DHTML, Adobe Photoshop and Dreamweaver.

Client: DHL (Dalsey, Hillblom and Lynn)

Aug 06 - Jul 08

Project: DHL Import Express Automation

Role: .NET Developer

Responsibilities:

. In addition to the application development, I have involved with

requirements gathering, specifications authoring, task prioritizing,

training authoring, and manual writing.

. Designed application architecture leveraging .NET Framework and utilized

Microsoft Practices and Object Oriented Design Patterns.

. Built on a custom framework using C#, Web Services, .NET Remoting,

ASP.NET, Microsoft Access, and MS SQL Server 2000.

. Used ADO.NET to connect to MS Access and SQL Server Database to retrieve

and update data.

. Designed and developed custom .NET components and user controls using

ASP.NET and C#.

. Migrated several controls from (MS Visual Basic 6.0) VB 6.0 to C# and

VB.NET.

. Built an application with ASP.NET, using a complex back-end involving SQL

Server, XML, and File maker databases.

. Developed Graphical User Interface (GUI) for content entry. Implemented

multi-tier workflow, and an automated reminder system.

. Involved in developing web-based software using HTML, XHTML, XML, XSLT,

JavaScript and the .NET framework.

. Implemented role based security and customizable workflows based on a

user's role.

. Designed and developed the SQL Server database schema.

. Generated automated test scripts and documentation.

. Performed the unit testing, multi-lingual testing, regression testing and

integration testing for a part of the system.

Environment: .NET Framework 1.1, ASP.NET 1.0, VB 2003/7.1, C# 1.1, Visual

Studio .NET 2003, Microsoft SQL Server 2000, MS Access, CSS, HTML, XHTML,

XML, XSLT, XPATH, JavaScript, VB Script, Web Services, SOAP, Web Pages, IIS

6.0, Test cases, Unit testing.

Education:

Bachelors degree in Electronics and Instrumentation from JNTU.



Contact this candidate