Post Job Free

Resume

Sign in

Developer Sql Server

Location:
San Francisco, CA
Posted:
January 26, 2015

Contact this candidate

Resume:

S akthivel Thandavarayan

acn0ys@r.postjobfree.com

630-***-****

Career Summa ry

An experienced Cloud Consultant and Saleforce.com Developer with overall experience of 6 years in IT

of which 5 years in the Salesforce.com eco system and cloud software application development and one

year in Database Management. Have experience in Salesforce.com Administration, Development,

B usiness Analysis and Project Management. Designed, developed and implemented several

Salesforce.com projects working with a global team of professionals.

Competencies:

● A nalytical Thinking, Problem Solving, Teamwork, Passionate, Customer Focus, Strategic

T hinking, Oral/Written Communication, and Global Collaboration.

Skills:

● Application Design and Development, AppExchange Eco-system, Release Management,

Salesforce Administration

● Apex, Visualforce, HTML, JavaScript, Web Services, Open Source Technologies, SOQL, SOSL,

AJAX, WSDL, Workflow & Approvals, Validation Rules, Analytics, Case Management, Data

Loader, Workbench, Object Oriented Programming, CSS, MS SQL Server, Google Apps, Social

Media.

Expe rience

● 6+ Years in Information Technology

● 5 Years in Cloud Computing and Salesforce.com: Force.com, Sales Cloud, Service Cloud, App

Exchange, application development, integration and administration.

● 2 Years in Project Management, Agile and Waterfall project management

● 1+ Year in MS SQL server database administration

Knowledge:

● I T and Business Trends

● CRM Trends and User Adoption

● Social Media influence on Businesses and Consumers

Education:

● Bachelor of Engineering, Electronics and communication, India - 2008

Page 1

● Continuing Education with Salesforce.com via Premier Training Program

● Salesforce.com Certified Administrator

● Salesforce.com Certified Developer

● Currently pursuing Advanced Developer Certification

Other

● Salesforce.com Developer User Group - Member,

● Active Participant in developer meetups.

● L argest Salesforce.com Google Plus Community - Founder, Moderator

● Technical guest blogger at gtr.net

● Reviewer of several salesforce t it les

Salesforce CRM: The Definitive Admin Handbook - Second Edition

Force.com Development Blueprints book

Salesforce.com Customization Handbook

● So You Think You Know SalesforceTM - Google + Community Moderator

● Learn Salesforce/ Salesforce Training - Google + Community Founder, Moderator

● So You Think You Know SalesforceTM - L inkedIn group Member

● Actively involved in the salesforce.com and business communities, groups.

Accomplishments

● Successfully implemented several Salesforce.com Development and Administration projects.

● Successfully designed, developed, tested and published the Application RPaaS (Recruiting

P latform as a Service) in the Salesforce AppExchange.

● Provided 24 X 7 on call Production Client Support for MS SQL Server Databases.

P ROFESSIONAL EXPER I ENCE:

Global Tech & Resources I nc. J an-2010

t o P resent

C lient : GTR, Rolling Meadows, I L, USA

Role : Senior Salesforce Developer

Period : Nov-2013 to P resent

R esponsibilities:

Actively involved in Designing and Developing an Application, RPaaS within Force.com platform

and listing it in the Salesforce AppExchange, (https://appexchange.salesforce.com/listingDetail?

listingId=a0N3000000B5LEREA3 ).

I t is developed based on S-Q-I-O (Sourcing-Qualifying-Interviewing-On-Boarding) model.

Participated in the high-level meeting in gathering user requirements and converted the

requirements in to a Solution Design Document (SDD).

Customized the Standard Objects and created new Custom objects as part of designing the

Page 2

Application based on the Solution Design Document.

Developed the application with several Custom Objects, Workflow Rules (including Time-

Dependent), Validation Rules, Apex Triggers to initiate the integration between different third

party applications and Salesforce.com.

Developed several Apex Classes, Controllers, and Visualforce pages, various Reports (summary

reports, matrix reports, pie charts, and graphics) as per the requirements of the application.

Created workflow rules and defined related t asks, email alerts, and f ield updates.

Implemented p ick lists, dependent picklists, lookups, master detail relationships,

validation and formula fields to the custom objects.

Created page layouts, search layouts to organize f ields, custom links, related lists, and other

components on record pages.

Created many Visual force pages for the above S-Q-I-O stages. The visualforce pages get the details

of Candidate Records and see the list of candidates getting sourced, qualified, interviewed and on-

boarded.

Used Force.com, Apex Data Loader for data migration.

Created Test Methods to provide maximum Code Coverage to the t riggers and other Controller

classes.

Implemented field level security, profiles and audit t rail setup.

Performed Unit, Integration, Regression and User Acceptance Testing.

Prepared User Manual for the RPaaS Application.

Created a managed package and published it in the Salesforce AppExchange.

Performed RPaaS Post Installation Customization to the Customers.

Performing Release Management of RPaaS which is an on-going task.

Client : F usion Risk M anagement

Role : S alesforce Developer

Period : J uly-2014 to Dec -2014

R esponsibilities:

Worked closely with the client in gathering business requirements and their technical

i nfrastructure for Force.com based enterprise application solutions.

Actively involved in all the stages of the project life cycle which include development,

i mplementation and testing of the application.

Integrated Conga Workflow and Conga Conductor add on licenses to reduce Conga Composer

L icenses

Designed Visualforce page UI to implement the solution

Explored various e-Signature tools and tested the integration with Conga and the client

application

Prepared test cases and tested the implemented solution using the test scripts

Client : i Knowledge

Role : S alesforce Developer

Period : M ay-2013 to Oct-2013

Page 3

R esponsibilities:

Worked closely with the client in gathering business requirements and their technical infrastructure

for CRM based enterprise solutions.

Actively involved in all the stages of the project life cycle which include designing, development,

i mplementation, testing, and deployment of the application.

Lead efforts to conduct evaluation, analysis and modeling of key integration processes.

Involved in creating Case management functionality and migrating legacy data into SalesForce.com.

Developed Sharing Rules among all the users in different Roles and Subordinates.

Created Queues to share work to the users in the Queue.

Developed and maintained custom reports.

Developed and customized the self service customer portal with multilingual support.

Performed Unit, Integration, Regression and User Acceptance Testing.

Created Test Cases and coordinated change requests to drive the business requirements during

development and Testing stages.

Provided Training to the end users.

Client : CAE, I nc

Role : S alesforce Developer and Administrator

Period : Sep-2012 to Apr-2013

R esponsibilities:

Create and Customize Custom Objects, Formula Fields, Cross Object Formulas, Roll up summary

f ields, validation rules, dependent picklists, and complex page layouts.

Create complex workflows and Approval processes.

Implemented Data segregation through Record Types and F ield level security.

Developed and maintained validation rules and custom workflow.

Used eclipse Force.com toolkit for creating Apex Classes and Apex Triggers to develop custom logic and

objects.

Audited, uncovered and resolved data integrity issues with legacy systems.

Complete bulk i mports of data using Apex DataLoader.

Developed and maintained custom reports.

Batch reassignment of accounts and opportunities based on organizational changes.

Prepared training materials for business users.

Client : B ridgelux, I nc

Role : S alesforce Developer and Administrator

Period : D ec-2011 to Aug-2012

R esponsibilities:

Actively involved in all the stages of the project life cycle (new implementation) which include

designing, development, implementation, testing, and deployment of the application.

Page 4

Worked on various salesforce.com standard objects like Accounts, Contacts, Cases, Opportunities,

P roducts, Opportunity Line I tems, Leads, Campaigns, Reports and dashboards.

Designed, and deployed the Custom objects, Custom tabs, Entity-Relationship data model, Validation

Rules, Workflow Rules, Page Layouts, Components, Visual force Pages as per the requirements of the

application.

Customized the Page Layouts for Standard Objects like Opportunity, Contacts, and Accounts

depending upon user roles, and groups.

Implemented Data segregation through Record Types and F ield level security.

Used eclipse Force.com toolkit for creating Apex Classes and Apex Triggers to develop custom logic and

objects.

Audited, uncovered and resolved data integrity issues with legacy systems.

Completed bulk i mports of data using Apex Data Loader.

Developed and maintained custom reports.

Batch reassignment of accounts and opportunities based on organizational changes.

Prepared training materials for business users.

Client : Sunergos LLC

Role : S alesforce Developer and Administrator

Period : J un-2011 to Nov-2011

R esponsibilities:

Participated in the client meetings in gathering user requirements, providing technical consulting,

p resenting them design overviews and demos in various stages during the implementation process.

Created and Customized Custom Objects, Formula Fields, Cross Object Formulas, Roll up summary

f ields, validation rules, dependent picklists, and complex page layouts.

Created complex workflows and Approval processes.

Implemented Data segregation through Record Types and F ield level security.

Developed and maintained validation rules and custom workflows.

Used eclipse Force.com toolkit for creating Apex Classes and Apex Triggers to develop custom logic and

objects.

Audited, uncovered and resolved data integrity issues with legacy systems.

Performed bulk i mports of data using Apex DataLoader.

Developed and maintained custom reports.

Batch reassignment of accounts and opportunities based on organizational changes.

Performed Unit, Integration, Regression and User Acceptance Testing.

Client : T he Chicago L ighthouse

Role : S alesforce Developer and Administrator

Period : J an-2011 to May-2011

R esponsibilities:

Page 5

Performed the roles of Salesforce.com Developer/Administrator.

Overall responsible of implementing their NPSP applications on Force.com p latform.

Installed and customized the NPSP package and additional customizations in their Salesforce org.

Participated in the client meetings in gathering user requirements, providing technical consulting,

p resenting them design overviews and demos in various stages during the implementation process.

Involved in creating data models and high level system designs, implementation, test plan, test cases

during the entire software life cycle.

Data migration between organizations using external/internal data loading tool.

Created design and user guide documents for the applications implemented.

Provided necessary t raining to their junior developers and end users.

Participate, demonstrate, exchange knowledge on quarterly meetings to discuss about new software

releases and tools.

C lient : Stonehouse Building Products

Role : S alesforce Administrator and Developer

Period : J ul-2010 to Dec-2010

R esponsibilities:

Worked as enhancement team member and performed the roles of Salesforce.com

Developer/Adminitrator.

Interacted with various business user groups for gathering the requirements for salesforce.com CRM

i mplementation.

Involved in Salesforce.com Application Setup activities and customized the apps to meet the functional

needs of the organization.

Implemented the requirements on Salesforce.com platform and Force.com IDE P lug-in using Eclipse.

Worked with various salesforce.com Standard objects like Accounts, Contacts, Leads, Campaigns,

Reports, and Dashboards and performed several customizations on these components as per the user

requirements.

Developed various Custom Objects, Tabs, Components and Visual Force Pages.

Developed Apex Classes, Controller Classes and Apex Triggers for various functional needs in the

application.

Maintained user roles, security, profiles, and workflow rules wherever necessary.

Designed their community to meet their brand and website look and feel. Content and navigation

structure was highly customizable.

Interacted with the Salesforce.com premium technical support team as and when required.

Client : S VM, LP

Role : S alesforce Administrator

Period : J an-2010 to Jun-2010

R esponsibilities:

Created and Customized Custom Objects, Custom Fields, Cross Object Formulas, Roll up summary

Page 6

f ields, validation rules, dependent picklists, and complex page layouts.

Created complex Workflows and Approval processes.

Implemented Data segregation through Record Types and F ield level security.

Developed and maintained validation rules and custom workflow.

Created Invoice Template to automate printing and mapping of the fields in the invoice

Completed bulk i mports of data using Apex Dataloader.

Developed and maintained custom reports.

Audited, uncovered and resolved data integrity issues with legacy systems.

Worked on the salesforce communities and Partner portals to give access to external users.

Prepared training materials for business users.

dB P rofessionals ( India) Pvt. Ltd. J un–2008

– D ec-2009

Client : Ashley Fu rnitu re, Arcadia, WI, USA

Role : SQL Server DBA

Period : Jun-2008 to Dec-2009

Ashley Furniture (Ashley) is one of the leading furniture manufacturing companies in the USA. They

p roduce a wide range of quality furniture that is marketed worldwide. They have their own

manufacturing, assembling and distribution facilities throughout the USA. Their home stores and

corporate stores are located in various locations in the USA.

As a SQL Server DBA, I was looking after the entire maintenance services for their SQL Server

databases.

Responsibilities:

Installing SQL Server 2005 and updating it with the latest service packs.

Migration from SQL Server 2000 to SQL Server 2005.

Exporting and Importing of databases using Export/Import tools.

Creating databases, tables, views, Pivot Tables, indexes and constraints on large databases.

Creating and modifying clustered Indexes and non-clustered Indexes on all the required tables and

i ncreasing the performance.

Planning Backup/Restore Strategy and automating it.

Performing database mirroring.

Implementing Linked Server between Order Placement databases to admin database for cross

database t ransactions.

Troubleshooting of different conflicts between two servers in Replication.

Setting up the Schedule jobs, alerts and notifications.

Creating users and logins with appropriate roles, dropping and locking the logins, monitoring the user

accounts, creation of Groups, Granting the Privileges to Users and Groups.

Running DBCC consistency checks, rebuild indexes, and update statistics for databases on regular

basis.

Page 7

Identifying and t roubleshooting and diagnosing database problems.

Configuring the Log shipping and created the Standby server.

Page 8



Contact this candidate