PROFESSIONAL SUMMARY:

• 7 years of experience in working on various ETL and Salesforce projects of different scales and complexities
• Experience in working on various tools/technologies. These include - Salesforce (Sales Cloud, Service Cloud and Marketing Cloud), Informatica PowerCenter, Informatica Cloud and Oracle PL/SQL
• Experience in technical architect role. Have designed and architected SFDC/CRM applications, ETL ecosystem, data warehouses, data integrations, database schemas and reporting solutions
• Development experience on AppExchange Products - Meeting Management, CTI Integration App, E-commerce application.
• Experience on Salesforce Development (Apex Classes, Triggers, Visualforce pages, Custom Objects, Profiles & Roles, Security Settings, Integration etc.)
• Experience in working on Cloud based data integration tools (Informatica Cloud and Salesforce) with real time requirements
• Experience in architecting complex Salesforce applications - finding IT bottlenecks, participating in user experience review sessions, working with business partners to craft IT solutions roadmap
• Excellent experience with data integration (batch and real time) using various kinds of data sources via SOAP and REST
• Extensive experience with Data Migrations, Report and Dashboard design

TECHNICAL SKILLS:

CRM: Salesforce CRM, Force.com, Sales Cloud, Service Cloud, Marketing Cloud

ETL: Informatica Cloud, Snaplogic, Cloud Services

Database: Oracle, SQL

PROFESSIONAL EXPERIENCE:

Confidential, Long Island City, NY

Salesforce Consultant

Responsibilities:

• Configuring Salesforce for various business needs (e.g. profiles, permissions sets, sharing rules, user roles, data security, org refreshes etc.)
• Developing Apex Classes, Triggers, Visualforce pages, Custom Objects/Tabs, Reports & Dashboards in Salesforce for different business requirements
• Developing new custom functionalities in Global Customer Connect application (SFDC Service Cloud) and integrating the same with Salesforce Cloud
• Supporting and Enhancing the Meeting Management application
• SFDC Sandbox management - Creation of new sandbox for testing and refresh of FULL sandboxes from production
• Business Analysis - Interacting with client’s business & IT partners, end users, affiliate partners to gather Business Requirements
• Designing and architecting data integrations between Salesforce and On-Premise and On Cloud applications (batch and real time both)
• Designing and Developing ETL maps in Informatica Cloud for data transfer between various applications
• Creating Reports and Dashboards in Salesforce for business users
• Assisting the client with planning of future application enhancements and data integrations
• Project planning and coordination with offshore team for various project deliveries
• Optimizing the Informatica maps for faster data loads

Environment: Salesforce, Sales Cloud, Informatica Cloud, Oracle APEX Language, Visual Force - Pages, Component & Controllers, Salesforce.com Data Loader, Workflow & Approvals, Reports, Custom Objects, Custom Tabs, Email Services, Security Controls, HTML, JavaScript, Java, Sandbox, Eclipse IDE Plug-in.

Confidential, San Francisco, CA

Salesforce/ Integration Consultant

Responsibilities:

• Leveraged clients existing IT framework/CRM system for better data visibility and system integration.
• Assisted in developing Project Scope, Business Requirements and Functional Requirements with internal team and clients.
• Designed and deployed Custom tabs, Custom Objects, Components, Visualforce Pages, validation rules, Approval Processes and Auto-Response Rules for automating business logic.
• Worked with standard Salesforce objects like Accounts, Contacts, Leads, Cases and Opportunities.
• Created workflow rules and defined related tasks, email alerts, and field updates.
• Implemented pick lists, dependent picklists, lookups, master detail relationships, and Record Types to enforce data quality Setup Marketing Campaigns, Assignment rules, Web-to-Lead and Auto-Response rules.
• Worked with Dynamic Apex to access Objects and Field describe information, execute dynamic SOQL, SOSL and DML queries.
• Add methods that can be called from Visualforce pages to Controller Extensions.
• Facilitated the creation of test scenarios and test scripts.

Environment: Salesforce Sales Cloud

Confidential, New York, NY

Salesforce Developer

Responsibilities:

• Designed Workflow rules, Visualforce pages and using Apex Code created triggers and classes.
• Created Jobs site for Requisition posting and job code display uses VF pages.
• Configured of Salesforce.com application for various modules Accounts, Contacts, Lead and Activity.
• Worked on Web to lead, Web to case, Email to case, Case Assignment rules, Lead Assignment rules and Lead conversion.
• Set up Users, roles, profiles and Security settings.
• Migrated from sandbox to production and force.com IDE.
• Customized records types, tabs, list views, column fields, page layouts and forms.
• Extensively worked on salesforce app design and development
• Generated SOQL queries upon request.
• Created Visual Force Pages, Apex Classes and Visualforce pages that uses the lightning components.
• Created Workflow alerts, and automated email response and used series of Ant Scripts to commit and pull files from GitHub.
• Wrote Test Cases for Classes and Triggers.
• Used the sandbox for Testing and migrated the code to the deployment instance after testing.
• Set up remote site settings using endpoint URLs in client side SFDC using SOAP API.
• Consumed the partner WSDL and Apex WSDL and wrote the Apex code in client side to perform real time SOAP integration between two systems.
• Created a custom label in salesforce to establish the connection with the source system as a part of integration.
• Wrote Mock Test class for the Web services to check for the 75% code coverage.
• Used the wrapper classes in Apex coding extensively.
• Followed the governor limits while writing the Apex code.

Environment: Saleforce.com platform, marketing cloud, Apex Language, Visualforce (Pages, Component & Controllers), Data Loader, HTML, JavaScript, Workflow & Approvals, Reports, GitHub, Jenkins, SOAP, REST, SOSL, WSDL, Custom Objects, Custom Tabs, Email Services, Security Controls, Sandbox data loading, Eclipse IDE Plug-in.

Confidential, Merrimack, NH

ETL Developer

Responsibilities:

• Technically leading the project from offshore.
• Gathering Business Requirements and coordinating with onsite counterpart.
• Creating System Requirement Specifications, High Level and Low Level Design Documents.
• Data Modeling, Designing Database, Designing Application Architecture, Constructing of GTC reporting application, testing, debugging, Implementation and Warranty Support.
• Final review of deliverables from offshore and sharing them with onsite and client.
• Allocation of project tasks to the team members, resolving their technical doubts and queries.
• Weekly Status Reporting to offshore Project Manager and Client’s Business Own.
• Knowledge Management which involved creating of knowledge documents and guiding the team to do the same.

Environment: Informatica Power Center 8.1, Oracle PL/SQL, Cognos, Mainframe, RHEL