Post Job Free

Resume

Sign in

Service Sql Server

Location:
Irving, TX
Posted:
March 29, 2017

Contact this candidate

Resume:

Hema Vijayaragavan

Email: aczj4t@r.postjobfree.com

PROFESSIONAL SUMMARY:

●Around 11 years of IT experience in Design, Development, Testing and Administration spanning all facets of package software and Saas application implementation.

●Over 5 years of experience in the Salesforce.com CRM space that includes Business Analysis, Administration, Configuration, Implementation, Development and Support experience.

●Experienced in Discovery Phase, Scoping Phase, Analysis and Implementation Phase.

●Proficient in Agile Methodology.

●Strong Requirements gathering experience and documentation skills which includes Conducting User Interviews, transforming business requirements into user requirement specification, Functional Requirement Specifications Document (FRD) and Use Case Narratives.

●Implementation experience of Salesforce.com applications like the Sales, Marketing and Service and Support Modules.

●Exposure to Salesforce Lightning.

●Extensively worked in integration using Informatica Cloud, Informatica PowerCenter and Cast Iron Tool.

●Expertise in Service Cloud console with exposure to CTI adapters and mobile application integrations.

●Proficient in Case Management using assignment, escalation, workflow rules and actions.

●Worked on various salesforce.com standard objects like Accounts, Contacts, opportunities, Products, Price books, Cases, Leads, Campaigns, Reports and Dashboards.

●Have in depth Knowledge and understanding of CRM business processes like Forecasting, Campaign Management, Lead Management, Order Management, Account Management, and Case Management.

●Designed Custom Formula Fields, Field Dependencies, Validation Rules, Work Flows, and Approval Processes for automated alerts, field updates, and Email generation according to application requirements.

●Extensive experience of using declarative features like validation rules, workflows, approval process, dynamic approval process, sharing rules automation for satisfying complex business process automations.

●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.

●Expertise in Force.com technology stack: APEX, Visual Force, SOQL, SOSL.

●Experience in building Visual Force Pages, Visual Force Custom Controllers/ Components, Advanced Search Functionality, Reports, Dashboards, Tabs.

●Installed Salesforce Apps, configured and maintained user security permissions in compliance with organizational Needs .

●Created page layouts, search layouts to organize fields, custom links, related lists and other components on a record detail and edit pages.

●Experience integrating SFDC with applications like Microsoft Outlook, ACT, etc.

●Knowledge in developing web-based applications using Java, PHP, XML, CSS, HTML, DHTML, XHTML, JavaScript and AJAX Technology.

●Proficient in developing and implementing Web service integration and using SOAP, REST and BULK API.

●Experience in J2EE architecture, design patterns, objects modeling using various J2EE technologies and frameworks.

●Developed applications by using JSP, JSTL, HTML, Java Scripts, and Ajax.

●Experience in designing, developing and deploying J2EE applications on Apache Tomcat, JBoss etc.

●Good Knowledge of RDBMS, SQL, Microsoft Excel and Access.

●Expert in tasks such as data extraction, transforming and loading using SQL* Loader, Oracle External tables, database links in Oracle and DTS transformations in SQL Server for various file formats.

●Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

●Experience of working with diverse database platforms including Oracle, SQL server, MS Access.

●Involved in requirement gathering from the client location, knowledge transfer and setting expectations on project progress at the client end.

●Excellent communication and inter-personal skills, accustomed to working in both large and small team environments.

●A team player with a strong work ethic, a positive attitude and the ability to make the best use of individual resources.

EDUCATION:

●Masters in Computer Science.

CERTIFICATIONS:

●Salesforce Certified Administrator 201

●Salesforce Certified Advanced Administrator 301

●Salesforce Certified Developer 401

●Service Cloud Certified Consultant

TECHNICAL SKILLS:

SALESFORCE.COM

Salesforce CRM, Salesforce Admin, Service Cloud Console, SSO, Apex Language, VisualForce (Pages, Component & Controllers), Salesforce.com Data Loader, Workflow & Approvals, Reports, Custom Objects, Custom Tabs, Email Services, salesforce offline Edition, Analytic Snapshots, Case Management System, SOQL, SOSL.

SALESFORCE TOOLS AND INTEGRATION TOOL

Cast Iron, Eclipse IDE, Apex Data Loader

PROGRAMMING

LANGUAGES

Java, Apex, SQL, HTML, CSS.

RDBMS

MS Access, Oracle

OPERATING SYSTEMS

Sun Solaris 8.0, Windows95/98/ XP/2000/vista, UNIX.

DATABASE TOOLS

Oracle 10g/9i/8i, Enterprise Manager, Query Analyzer, SQL Server Profiler, DTS,Business intelligence Studio.

PROFESSIONAL EXPERIENCE:

Synechron Inc. 09/22/2016 – till date

Client: Bank of America

Senior Salesforce Developer / Lead

Responsibiities:

Responsible for the entire integration of backend application with salesforce.

Worked on both REST and SOAP webservices for facilitating real time integration.

Designed and developed triggers, apex webservice classes using future methods for HTTP callouts to external application.

Developed webservice class using XMLStreamWriter class methods for generating XML data.

Designed and developed SOAP webservice class and generated WSDL for exposing to external applications.

Developed test classes including mock classes for 100% coverage of all the triggers and apex classes of integration.

Configured and tested workflow rules and outbound messages for real-time integration based on requirements.

Designed and configured custom fields, custom objects, validations rules and security controls as required for the webservice integration.

Worked on configuration of remote site settings and custom settings.

Support production support team on resolving tickets and issues in production environment.

Environment: Saleforce.com platform, Agile – Rally, Force.com API, GitHub, Reports, Custom Objects, Custom Tabs, Workbench, Visual Force, Salesforce.com Data Loader, Developer Console, Security Controls, HTML, Java Script, BootStrap, Jquery,Sandbox, Change Sets, Eclipse IDE Plug-in.

Synaptic Advisory Partners 03/16/2016 - 09/21/2016

Senior Salesforce Developer

Responsibilities:

Refactoring and optimization of existing code to fix the existing issues in the sequence of operations on real-time .

Modified the existing triggers, apex classes and controller classes to adhere with the best practice.

Designed and developed the Visualforce Pages using apex, JavaScript, JQuery.

Custom objects, validation rules, Page layouts, Custom tabs, components to suit to the needs of the application.

Worked on Lightning experience.

Worked in integration with back-end application using SOAP and REST API.

Proficient in creating record-types, page-layouts and profiles to hide/show visibility to various fields.

Involved in developing visualforce pages, Controller Classes and Extensions based on the requirements.

Implement pick lists, dependent pick lists, lookups, junction objects, master detail relationships, validation and formula fields to the custom objects

Created users, roles, public groups and implemented role hierarchies, sharing rules and record level permissions to provide shared access among different users.

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

Develop test classes and maintain sufficient organizational code coverage.

Designed, developed and deployed apex classes and Apex Triggers for various functional needs in the application using the Eclipse IDE.

Environment: Saleforce.com platform, Agile – workFront, Force.com API,GitHub, Reports, Custom Objects, Custom Tabs, Visual Force,Salesforce.com Data Loader, Security Controls, HTML, Java Script, BootStrap, Jquery,Sandbox, Change Sets, Eclipse IDE Plug-in.

Right Click Systems 10/01/2014 – 03/15/2016

Client: Tmx Finance

Lead Salesforce Developer

Incharge of the complete salesforce development activities for the entire organization after the initial package deployed by Salesforce.com.

Worked extensively in customization of Service Cloud Console by embedding Visualforce pages in custom console components, highlight panel and interaction log .

Worked in integration with back-end application using SOAP and REST API.

Involve in developing visualforce pages, triggers and apex classes based on the requirements.

Create page layouts, search layouts to organize fields, custom links, related lists, and other components on a record detail and edit pages.

Implement pick lists, dependent pick lists, lookups, junction objects, master detail relationships, validation and formula fields to the custom objects, Web to case, Email to case.

Designed, developed and deployed Apex Classes, Controller Classes, Extensions and Apex Triggers for various functional needs in the application using the Eclipse IDE.

Designed, and developed the Custom objects, validation rules, Page layouts, Custom tabs, components, VisualForce Pages to suit to the needs of the application.

Refactoring of code to fix the existing issues in the sequence of operations on real-time.

Work closely with users to understand the issues and fix them.

Develop test classes and maintain sufficient organizational code coverage.

Work closely with informatica and other middleware teams for fixing issues.

Monitoring of informatica jobs to ensure smooth and error-free operations.

Incharge for fixing deployment issues and ensure successful deployment through changesets and Force.com IDE.

Environment: Saleforce.com platform, Communities, Informatica Cloud, Informatica PowerCenter, Agile – TFS, Force.com API, Bulk API, JSON, Workflow & Approvals, Reports, Custom Objects, Custom Tabs, Email Services, Visual Force,Salesforce.com Data Loader, Security Controls, HTML, Java Script, Sandbox, Change Sets, Eclipse IDE Plug-in.

Helios and Matheson IT ltd 10/17/2013 to 12/03/2013

Client :Societe Generale Global Solutions Pvt. Ltd. – India

Lead Salesforce Admin / Developer

Responsibilities:

●Developed various Custom Objects, Tabs, Entity-Relationship data model, validation rules on the objects and tabs, Components and Visualforce Pages.

●Involved in developing visualforce pages, triggers and apex classes based on the requirements.

●Proficient in creating record-types, page-layouts and profiles to hide/show visibility to various fields.

●Implemented the requirements on Salesforce.com platform and Force.com IDE Plug-in using Eclipse.

●Exposure to various latest features of salesforce like Permission Sets to give user-specific permissions, content management, documents and libraries.

●Created page layouts, search layouts to organize fields, custom links, related lists, and other components on a record detail and edit pages.

●Implemented pick lists, dependent pick lists, lookups, junction objects, master detail relationships, validation and formula fields to the custom objects, Web to case, Email to case.

Great-West Life & Annuity Insurance Company, Colorado 11/14/2011 - 12/28/2012

Lead Salesforce Systems Engineer

Great-West is a leading provider of employer-sponsored retirement savings plans and ranked as the nation’s fourth-largest retirement plan record keeper as measured by participant accounts. It offers annuity and life insurance products for individuals and businesses, as well as fund management, investment and advisory services, private-label recordkeeping and administrative services for other providers of defined contribution plans.

Responsibilities:

●Lead a team of 6 developers, provide guidance to the team and involved in designing phase.

●Incharge of the complete salesforce activities for the entire organization after the initital package deployed by Salesforce.com.

●Worked in three different production instances within the organization, involved in various configuration and setup activties and in production support.

●Identified as the Premier Support contact person for the organization, open cases with Salesforce, follow up until the issues are resolved.

●Extensively worked for both person and Company Accounts of the organization

●Involved in developing visualforce pages, triggers and apex classes based on the requirements.

●Proficient in creating record-types, page-layouts and profiles to hide/show visibility to various fields.

●Implemented pick lists, dependent pick lists, lookups, junction objects, master detail relationships, validation rules and formula fields to the custom objects

●Exposure to various latest features of salesforce like Permission Sets to give user-specific permissions, content management, documents and libraries.

●Extensively worked in real-time Web service integration of Salesforce with J2EE web applications.

●Directly interacted with various user groups to understand and gather requirements and conducted demos to show prototypes.

●Implemented Case Management by creating record-types specific to the user groups, assignments rules, escalation rules, case templates,workflow rules and actions, etc.

●Customized events and tasks as per user convenience to schedule meetings, follow-up, sharing calenders with other groups, etc.

●Worked in Single sign-on, SAML settings to enable the user to login to various applications simultaneouly.

●Enabled and configured E-mail Relay feature for the e-mail administration for the entire organization.

●Worked extensively in customization of Service Cloud Console by embedding Visualforce pages in custom console components, highlight panel and interaction log .

●Resolved issues connected to Call Centers, usage of CTI adapters and Mobile applications.

●Deployment using Eclipse IDE and ANT.

●Incharge of the deployment and complete setup in 3 production instances, used Eclipse and changeSet for deploying.

Environment: Saleforce.com platform, ANT, Visual Force (Pages, Component & Controllers), Workflow & Approvals, Reports, Dashboards, Custom Objects, Custom Tabs, Email Administration, SSO, Service Cloud Console, Change Set, Force.com Eclipse, HTML, JavaScript, CSS, Apex Explorer, Apex DataLoader, Cast Iron.

Horizon Technologies Inc. 02/10/2011 to 11/11/2011 Role: Salesforce Developer

Responsibilities :

●Performed detailed analysis of business and technical requirements and designed the solution by customizing various standard objects of Salesforce.com (SFDC) and other platform based technologies like Visualforce, force.com API, and web services.

●Developed various Custom Objects, Tabs, Entity-Relationship data model, validation rules on the objects and tabs, Components and Visualforce Pages.

●Created workflow rules and defined related tasks, time triggered tasks, email alerts, filed updates to implement business logic.

●Designed and developed SFA based Application on force.com platform in salesforce.com environment with Apex programming language at backend and Visual-Force pages as user interface.

●Created test scenarios on Sandbox environment, created packages and moved it between Sandboxes and Production environments to place final implementations..

●Used salesforce Automation (SFA) for Territory Management and Opportunity Management.

●Implemented the requirements on Salesforce.com platform and Force.com IDE Plug-in using Eclipse.

●Developed Apex Classes and Apex Triggers for various functional needs in the application.

●Created various Scheduled and Batch apex jobs based on the business requirements.

●Used SOQL & SOSL for data manipulation needs of the application using platform database objects.

●Created profiles and implemented Object and field level security to hide critical information on the profile users.

●Created users, roles, public groups and implemented role hierarchies, sharing rules and record level permissions to provide shared access among different users.

●Created automations of emails to Opportunity owners based on business requirements.

●Resolved major issues in previously exisiting integrations betweeen SAP and Salesforce in the Cast Iron environment.

●Created orchestrations for bi-directional integration of Salesforce and SAP using Cast Iron tool.

Environment: Saleforce.com platform, Apex Language, Visualforce (Pages, Component & Controllers), Pages, Data Loader, HTML, Java Script, Workflow & Approvals, Reports, Custom Objects, Custom Tabs, Email Services, Cast Iron, Security Controls, Eclipse IDE Plug-in, Windows XP.

Cubix Solutions Pvt Ltd. 06/03/2002 to 04/10/2009

Responsibilities as Salesforce Developer:

●Involved in Salesforce.com Application Setup activities and customized the applications to match the functional needs of the organization in enterprise edition.

●Interacted with various business team members to gather and document the requirements.

●Implemented the requirements on Salesforce.com platform and Force.com IDE Plug-in using Eclipse.

●Worked on various salesforce.com standard objects like Campaigns, Leads, Accounts, Contacts, Opportunity, Forecast, Cases, Reports and Dashboards.

●Implemented Web-to-lead to track and solve leads from the website.

●Created different workflow rules and Approvals for various campaign processes.

●Designed, and developed the Custom objects, validation rules, Page layouts, Custom tabs, components, VisualForce Pages to suit to the needs of the application.

●Designed, developed and deployed Apex Classes, Controller Classes and Apex Triggers, packages for various functional needs in the application.

●Integrated with PeopleSoft FT at the back end with Salesforce as User Interface and it is a bi-directional integration using Informatica on demand.

●Perform detailed analysis of business and technical requirements and developed the Apex classes using other Platform based technologies like VisualForce, Force.com IDE.

●Developed and configured various Reports for different user profiles based on the need in the organization.

●Participated in the training sessions provided by the Salesforce team and support end users.

●Used the sandbox for testing and migrated the code to the deployment instance after testing.

Responsibilities as Java Developer:

●Involved in all the phases of SDLC including Requirements collection, Design and Analysis of the customer specifications, Development and Customization of the application.

●Worked with the 3-Tier Architecture which includes the presentation layer, business logic layer and the database.

●The application is based on the MVC-II Architecture using Apache Struts framework.

●Involved in understanding the business processes and defining the requirements.

●Designing the system and documenting Use Cases, Class diagrams, Sequence diagrams.

●Designed and developed User Interface Screens using HTML, DHTML and JSP.

●Used JUnit to write repeatable tests (regression testing), mainly for unit testing.

●Used Singleton, Service Locator, DAO, Business Delegate, factory design pattern for services.

●Eclipse used as Java IDE tool for creating Action Classes and XML files.

●Develop the User Interface Screens for presentation Web logic using JSP, HTML, and CSS.

●Involved with Postgre SQL Database Design and Development.

●Managed Source Code in CVS environment.

●Created several complex stored procedures and triggers using SQL Server 2005 to retrieve data.

●Involved in writing T-SQL programming for implanting stored procedures and functions for different tasks.

●Analyzed the requirements and finely tuned the stored procedures to improve the performance.

●Documented the SQL Server Integration Service Standards to be followed.

Environment: Saleforce.com platform, S-Controls, Visual Force (Pages, Component & controllers),Pages,Informatica, HTML, Java Script, Workflow & Approvals, Reports, Custom Objects, Custom Tabs, Email Services, Sandbox data loading, Eclipse IDE Plug-in, Windows XP.

Java, MVC, EJB, JDBC, Servlets, JSP, JBuilder IDE, HTML, XML, JavaScript, BEA WebLogic, Oracle, Internet Explorer, MS SQL Server 2005, T-SQL, and Windows 2003 .



Contact this candidate