Sql Server Management

Saroj Tripathy

Phone: 214-***-**** E-Mail: ac2ip0@r.postjobfree.com

PROFESSIONAL SUMMARY:

Around 5+ years of experience in Salesforce.com CRM platform using Apex classes/triggers, VisualForce, REST API, SOAP API with substantial experience in Salesforce.com Administration, operational analytics, project management, and quality assurance with emphasis on process improvement. Experience in scope, design, testing, training, deployment and follow up on a multitude of strategic projects within Salesforce.com as the Salesforce.com Developer and Administrator. Other than Salesforce, I have extensive experience in Coldfusion 9.0/8.0/7.0/MX, JavaScript, CSS, SQL Server2005/2008, SOAP, WSDL, DocuSign and PHP.

• 12 Years of experience in development of multi-tiered Client/Server applications along with Internet / Intranet application, with 5+ years of experience in Salesforce CRM as Lead Salesforce Developer.

• Experience in SFDC development using Apex classes and Triggers, Visual Force, Force.com IDE, SOQL, SOSL, REST API, SOAP API, Lightning.

• Proficiency in SFDC Administrative tasks like creating Profiles, Roles, Users, Page Layouts, Email Services, Workflows, Validation rules, Process Builder, Reports, Tasks and actions.

• Experience in data migration using Apex Data Loader.

• Experience in integrating Salesforce with Third Party Service like DocuSign, Amazon Web Service, Marketo etc using SOAP/REST.

• Migrating applications developed in different technologies (like Java, Coldfusion) to Salesforce Platform.

• Good Experience in building both n-tier static and interactive web applications & eBusiness projects using Cold Fusion 9.0/8.0/7, CFMX, HTML, JavaScript, CSS, SQL Server 2005/2008, Oracle 9i and ColdFusion Application Server and PHP.

• Experienced in all steps of System Development Life Cycle (SDLC) of web projects, focusing on requirement specification to product release in E-Commerce, Web Applications and Application development in Coldfusion in coordination with Oracle and MS SQL.

• Possesses strong analytical and technical acumen backed by vast programming and research experience in the areas of application and web development.

• Proven communication skills when working with developers, project managers, subject matter experts, stakeholders, system implementers and application end-users.

• Good experience in Relational Database Management System (RDBMS) Design, Normalization, and Database Management oriented concepts and back end programming using PL/SQL.

• Experience in Data Analysis, Database Design (Physical and Logical databases) utilizing SQL, and Oracle.

• Experience in customized commercial web content development for corporate environments including.

• Experience in Web Services, WDDX, and Fuse box Web Application Standards, CFCs and CFobjects.

• Worked with various domains like Publishing, Logistics etc.

• Works effectively in independent and in cross-functional team environments.

• Flexible and ability to balance multiple projects at one time in a fast-paced environment. CERTIFICATIONS

- Salesforce 401 Certified Developer (http://certification.salesforce.com/certification-detail- print?conId=003G000002Ay2PYIAZ)

- Salesforce 201 Certified Admin

TECHNICAL SKILLS

Force.com : Salesforce CRM, Apex Custom Controllers, Apex triggers, Apex classes, Apex web services, Visual force Pages, Eclipse, Force.com IDE, Apex Data Loader, SOQL, SOSL, Analytical snapshots, Workflows and Approvals, Case management Automation, Sandbox testing. SalesforceTools : Eclipse, Force.com Eclipse IDE Plug-in, Force.com Explorer, Force.com Data Loader, Force.com Platform.

Other Development Technologies : ColdFusion 9.0/8.0/7/6.1/5, PHP, JavaScript, VB Script, Action Script, HTML, DHTML, XML, XHTML and CSS.

Languages : APEX, CFMX, PHP, COBOL, PL/SQL, Basic, C Framework : MVC, FUSEBOX 2.0/3.0, COLDSPRING, MODEL GLUE. GUI/Development Tools : Eclipse, Macromedia Dreamweaver, HomeSite, Photoshop. Source Control tools : Subversion, CVS

Relational Databases : Microsoft SQL Server, Oracle 10g/9i/8i, and MS Access. Servers : ColdFusion Application Server 4.5/5.0, IIS 5.0 Reports : Crystal Reports and Actuate.

Operating Systems : Windows 98/2000/XP/2003, Linux. Office XP/2003 : MS Excel, MS PowerPoint, MS Word. EDUCATION DETAILS:

Completed Master of Computer Application in 2002 from Orissa University of Agriculture and Technology, India PROFESSIONAL EXPERIENCE

Intrax Inc, San Francisco, CA Jan ’13 - Present

Lead Salesforce Developer

Project: AuPaircare and Ayusa

Intrax provides children, students, young adults, families, and organizations with dynamic cross-cultural opportunities which inspire personal growth, mutual respect, and cultural understanding. Whatever your stage in life, Intrax has a program that is right for you. Out of several programs, Intrax deals with

- AuPairCare (Live-in Childcare)

- Ayusa (High School Exchange)

- Proworld (Volunteer Abroad)

- Intrax English (Intern Study Work)

AuPairCare

AuPairCare is the premier au pair agency providing live-in childcare to American host families. Intrax AuPairCare Program connected more than 50,000 au pairs with American families across the U.S. Through Salesforce platform and websites like https://intrax.force.com/aupaircare and https://intrax.force.com/apcfield, Intrax provides

- Host Families to Submit their Applications

- Host Families sign-in to the System

- Host Family and AuPair to Sign their agreements

- Host Families Search Au Pair and see their details

- Set-up Interview with Au Pair

- Connect to the Au Pair

- Host Family Selects Au Pair

- Host Family Cancel Au Pair contract

- Host family uploads their necessary contract documents

- Partners register Interested Au Pair into system

- Invoicing

Ayusa

Ayusa Global Youth Exchange has been a leader in providing a wide range of life-changing cultural exchange experiences. Ayusa today maintains a proud legacy of offering high-quality programs for high school students. Through Salesforce Platform and website like http://intraxinc.force.com/intraxappengine, Intrax provides

- Partners register Interested Students (less than 18 years) into system

- Host Families resisters to the System

- Host Families Search Students (less than 18 years) and see their details

- Set-up Interview with Students (less than 18 years)

- Connect to the Students (less than 18 years)

- Host Family Selects Students (less than 18 years)

- Host Family Cancel Students (less than 18 years) contract

- Host family uploads upload their necessary contract documents Responsibilities:

• Involved in requirement gathering from users.

• Design Requirement documents and functional document for the development team.

• Writing Apex Classes/Triggers and Visualforce Pages/Components to accomplish the requirements.

• Set up Marketing Campaigns, Campaign Hierarchies, Lead Queries, Assignment rules, Web-to-Lead and Auto-Response rules.

• Configured the Case Management Process.

• Debug Apex scripts using Debug Logs and System Log Console to catch Exceptions and execute Governors and Limits.

• Deployed Apex using Force.com IDE, Force.com Migration Tool and Web Services API.

• Implemented Classes, Interfaces, Keywords and Annotations.

• Integrated Apex with External services by making callouts that used SOAP and WSDL.

• Worked with Apex Scheduler to invoke Apex classes at regular intervals.

• Worked with Dynamic Apex to access sObjects and Field describe information, execute dynamic SOQL, SOSL and DML queries.

• Add methods that can be called from Visualforce pages to Controller Extensions.

• Created Custom Controllers to make external web service callouts, validate and insert data.

• Created Custom Visualforce components and attributes to override the look and feel of standard Visualforce components.

• Created Visualforce pages that could be rendered as PDF's, build dashboard components and define email templates.

• Created Visualforce pages which identified a region to be updated to enforce partial page refreshes and display the status of Ajax requests to display different values depending on whether it is in progress or completed.

• Implemented Visualforce pages with public-facing websites by using Force.com Sites.

• Specify timers that send Ajax update requests to Force.com according to a specified time interval.

• Used Visualforce in development mode to change the behavior and appearance of Visualforce components.

• Used Visualforce Templates and Placeholders to encapsulate page elements to be reused across several Visualforce pages.

• Used Organization security, Network-based security and Session security to implement platform security.

• Used Picklists, Dependent Picklists, Record Types to enforce data quality.

• Used Tab permissions, Record Type permissions and Field Level Security to implement Component-based security.

• Used Tabular, Summary and Matrix reports to create Standard reports and Custom reports.

• Designed and modified Approval processes and created Approval steps which used email alerts and field updates.

• Worked with Approval processes that used Email Approvals and Parallel Approval steps

• Used Process Visualizer to study Approval steps.

• Created Dashboards and Dashboard Components and implemented multiple levels of Dashboards and scheduled Dashboard refresh.

• Created Many-to-Many relationships and created Junction objects to implement Roll-up Summary fields to aggregate data from child records on the parent.

• Designed Validation Rules along with Roll-Up Summary Fields to maintain data quantity and data consistency.

• Implemented relationship fields for proper data loading. Environment: Salesforce.com platform, Apex Classes, Apex Triggers, VisualForce, VF Component, SOQL, SOSL, REST API, SOAP API, Workflow Rules and Approvals, Process Builder, Reports, Custom Objects, Tabs, Email Services, JavaScript, Eclipse IDE Plug-in, Data Loader. CEVA Logistics, Miami, FL Jan ’10 – Dec ’12

Senior Software Developer

Project: Warehouse Management Application

Warehouse Management Application is composed of four components - Infonet, Loginet, FilePro and eActuate. All the four components are tightly integrated and dependent on each other and manage the entire lifecycle of Receiving, Managing Inventory, Packing/Assembling, Releasing, and Reporting. Infonet is the intranet used by the Miami station to service internal customer and administration of the system. Loginet is the extranet used by the Miami station to service the customers and perform P.O. Management. FilePro is the WMS system used by the Miami station to manage the warehouse and invoice customers. eActuate is the reporting interface to generate different kind of predefined reports for customers. Infonet and Loginet applications run on ColdFusion where as FilePro runs on UNIX environment. Responsibilities:

• Gathering knowledge of the existing Warehouse Management Application.

• Requirement understanding from CEVA technical and business team.

• Used HTML, JavaScript, JQuery, Ajax and CSS to create attractive, user-friendly interface.

• Optimize the queries of the existing pages of LOGINET application.

• Designed and implemented various web pages using CFML and ColdFusion Components.

• Developed packages, functions, and Stored-Procedures.

• Rewriting the Store Procedures to fetch the data from FILEPRO and upload it into SQL Server.

• Involved in loading the data using import and export on the SQL Server.

• Managing ColdFusion Administrator, FTP, and other related Web server functions

• Used ColdFusion reports for integrating with websites, also for analyzing data.

• Generation of Reports in PDF and Excel formats.

• Developed the User Defined Functions (UDF).

• Fixing all existing COLDFUSION and FILEPRO issues in existing application.

• Used SVN as version control tool to perform checking-out and checking-in of codes from the repository.

• Work prioritization, planning and assignation for onsite engineers.

• Creating Installation package for Warehouse Management application.

• Work in L2 production support team for the system to provide quick resolution for production issues.

• Gather test data and facilitate development testing.

• Facilitate User Acceptance Testing in business working hours. Environment: ColdFusion 9.0/8.0, Fuse Box 5, XML, UNIX, e-Actuate, HTML, JQuery, ColdFusion Reports, Adobe Fireworks CS3, Adobe Photoshop cs3, JavaScript, Dreamweaver, SVN, SQL 2005. Pearson Publishing, New Jersey Jan ‘09 – Dec ‘10

Sr. ColdFusion Developer

Project: Content Management System

Content Management Application is mainly used for creating the new sites. The main features of this application are

• Create new site.

• Add category to the site.

• Change the CSS for the site.

• Change the left / right/top / bottom image of any site built through the CMS.

• Add any featured link.

• Add Pages/ Sub pages to the site the site built by CMS.

• Deploy site from one server to another.

Responsibilities:

• Responsible for Requirement Gathering, Designing, Providing Solution, Development and Delivery of customer requirements.

• Responsible for Reviewing the Coldfusion Code written by team members.

• Test Case Preparation.

• Understanding the client requirements and preparation of design documents (Solution Specifications).

• Work on customers daily maintenance requests.

• Preparation of Project Status Report and presenting it to Customer weekly.

• As a Configuration Controller, responsible for Configuration Management.

• Preparation of Quality Documentation

• Packaging and Delivery

Environment: Salesforce.com, Apex Classes, Apex Triggers, Salesforce Admin, ColdFusion 8.0, Adobe Dreamweaver MX, Flex 3.0, Crystal Reports 10, Business Objects, HTML, SQL Server 2005, JavaScript, Web Services, and Subversion.

Pearson Publishing, New Jersey Oct ‘08 – Jan ‘09

Sr. ColdFusion Developer

Project: RFS Online

RFS Online application is used to request a new enhancement (service), RFS Online is used extensively. This is a multi level approval process for any request that is logged into the PVCS Tracker. The user describes a change request in detail. The user should specify the potential Application Impacts benefits of the enhancement/change. This change request is then routed to the next level approvers who may approve, decline or cancel. The Technical Manger is responsible for giving the Cost estimates for the request. Depending on the cost estimates the next level approver

(Business Manger, Chief Investigation Officer, Chief Technical Officer or Chief Finance Officer) can approve or decline the change request.

Responsibilities:

• Responsible for Requirement Gathering, Designing, Providing Solution, Development and Delivery of customer requirements.

• Responsible for Reviewing the Coldfusion Code written by team members.

• Test Case Preparation.

• Understanding the client requirements and preparation of design documents (Solution Specifications).

• Work on customers daily maintenance requests.

• Preparation of Project Status Report and presenting it to Customer weekly.

• As a Configuration Controller, responsible for Configuration Management.

• Preparation of Quality Documentation

• Packaging and Delivery

• Write database connecting code and SQL queries to communicate with SQL database to access the user details and update the database with the new user requirements.

• Developed web interface components using Java Script.

• Designed UI using Flex.

• Set up Client environments and created connections in ColdFusion Admin Server.

• Programmed on advanced features such as Quick search, advanced search methodology to list all properties based on criteria.

• Using Model Glue framework assembled pre-written code assets that helps the developer in writing an application

• Created dynamic database driven enterprise-level web sites using cold fusion 7.0

• Set up Client environments and created connections in ColdFusion Admin Server.

• Developed several ColdFusion pages and Smarty templates consisting of various modules, include files, text boxes, gifs and text.

• Used Secured LDAP server for GDOT authentication.

• Responsible for maintenance of database on server. Backup & Restore of database

• Involved in manual testing at different stages of the project

• Demonstrating current functionality and to elicit suggestions from users for necessary improvements to existing functionality before production implementation proceeds.

• Involved in preparation of technical documentation.

• Involved in regular meetings with clients for changes in respective departments' contents on the website. Environment: ColdFusion 7.0, XML, Oracle 10g, Toad, Smarty Templates, Illustrator HTML, XHTML, CSS, JavaScript, Adobe Dreamweaver 3.0, Documentum, Flex 2.0, Web Services, Windows 2000/XP. Pearson Publishing, New Jersey Mar ‘06 – Oct ‘08

Sr. ColdFusion Developer

Project: Pearson Premium Store

The Pearson Premium Online Store is the Online Store for the employees and can receive gifts or awards with company logos. It is a marketing and branding strategy for the organization promotion. The vendors have the Pearson Logs and the products have them embossed. These embossed items are used in conferences and exhibitions too.

Responsibilities:

• Responsible for Requirement Gathering, Designing, Providing Solution, Development and Delivery of customer requirements.

• Responsible for Reviewing the Coldfusion Code written by team members.

• Test Case Preparation.

• Understanding the client requirements and preparation of design documents (Solution Specifications).

• Work on customers daily maintenance requests.

• Preparation of Project Status Report and presenting it to Customer weekly.

• As a Configuration Controller, responsible for Configuration Management.

• Preparation of Quality Documentation

• Packaging and Delivery

• Write database connecting code and SQL queries to communicate with SQL database to access the user details and update the database with the new user requirements.

• Developed web interface components using Java Script.

• Set up Client environments and created connections in ColdFusion Admin Server.

• Created dynamic database driven enterprise-level web sites using cold fusion 7.0

• Developed several ColdFusion pages and Smarty templates consisting of various modules, include files, text boxes, gifs and text.

• Responsible for maintenance of database on server. Backup & Restore of database

• Involved in manual testing at different stages of the project

• Demonstrating current functionality and to elicit suggestions from users for necessary improvements to existing functionality before production implementation proceeds.

• Involved in preparation of technical documentation.

• Involved in regular meetings with clients for changes in respective departments' contents on the website. Environment: ColdFusion 7.0, XML, SQL Server 2005, Illustrator HTML, XHTML, CSS, JavaScript, Adobe Dreamweaver 3.0, Documentum, Web Services, Windows 2000/XP. Pinnacle Auto Warranty, CT Oct’04 - Feb’ 06

ColdFusion Developer,

Projects: Pinnacle Auto Warranty

Pinnacle Warranty has been entrusted by one the nations largest extended warranty companies due to the high priority we place on customer care, security of your personal information with the most comprehensive privacy policy, as well as from our long history of providing secure online transactions with a goal of 100% customer satisfaction.

Responsibilities:

• Design and development of the pages.

• Developed the DHTML code using JavaScript functions for special fading effects and strobe effects in dynamic menus and Third party web components.

• Developed dynamic database driven enterprise-level web sites application using Data Modeling.

• Developed key functions such as customers login details, contact information, security and payment integrations using Coldfusion

• Used Dream weaver as HTML editor, IIS for Web Hosting and MS Access database.

• SQL Server was the database with ODBC connection.

• Used SQL tuning for high performance of database.

• Tested applications for cross-browser issues and Involved in preparation of technical documentation & Search engine optimization.

Environment: Macromedia ColdFusion MX version 6.1, Adobe Photoshop 6.0, DHTML, CSS, JavaScript, Fuse Box, Eclipse, XML, SQL SERVER 2000, MS office 2000, Windows NT. Jiffy InfoTech, Delhi Jul ‘02 to Sep ‘04

Web Developer

Project: www.jurytest.net

JuryTest Networks helps lawyers and litigation managers make better decisions in trying, mediating and settling legal disputes.

JuryTest delivers fast, convenient and affordable mock-trial feedback to your desktop within 24 hours, permitting you to learn how jurors will respond to your case. Responsibilities:

• Involved in database programming. Writing stored procedures and Pl/SQL scripts.

• Implemented Java scripts to validate the beneficiary/dependents forms.

• Developed the User Defined Functions(UDF’s)

• Designed UI using Flex.

• Developed customized web application for client using ColdFusion, SQL, HTML, CSS.

• Involved in Database design and development. Involved in SQL scripting. (Stored Procedures and Triggers)

• Rewrote the stored procedures for increased stability and performance; redesigned tables and views for the same performance gains.

• Involved in the system integration and testing.

• Created and updated user documentation for each of the application.

• Job involved regular interactions with the clients for requirement gathering, and customization of the application according to different user requirements.

• Giving presentations describing the technical flow of the application at the client side. Environment: Coldfusion 5.0, DreamWeaver, SQL Server 2000, JavaScript, CVS, VB 6.0, windows

Contact this candidate