We provide IT Staff Augmentation Services!

Integration Consultant Resume

Mclean, VA

PROFESSIONAL SUMMARY

  • 7 years of experience in working on various ETL and Confidential projects of different scales and complexities
  • Experience in working on various tools/technologies. These include - Confidential (Sales Cloud, Service Cloud, Marketing Cloud and Communities Cloud), Informatica PowerCenter, Informatica Cloud and Oracle PL/SQL
  • Experience in technical architect role. Has 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 Confidential 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 Confidential ) wif real time requirements
  • Experience in architecting complex Confidential applications - finding IT bottlenecks, participating in user experience review sessions, working wif business partners to craft IT solutions roadmap
  • Excellent experience wif data integration (batch and real time) using various kinds of data sources via SOAP and REST
  • Extensive experience wif Data Migrations, Report and Dashboard design

TECHNICAL SKILLS

CRM: Confidential CRM, Force.com, Sales Cloud, Service Cloud, Marketing Cloud and Communities Cloud.

ETL: Informatica Cloud, Snaplogic, Cloud Services

Database: Oracle, SQL

PROFESSIONAL EXPERIENCE

Confidential, McLean, VA

Integration Consultant

Roles & Responsibilities:

  • Configuring Confidential 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 Confidential for different business requirements
  • Developing new custom functionalities in Global Customer Connect application (SFDC Service Cloud) and integrating the same wif Confidential 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 wif client’s business & IT partners, end users, affiliate partners to gather Business Requirements
  • Designing and architecting data integrations between Confidential 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 Confidential for business users
  • Assisting the client wif planning of future application enhancements and data integrations
  • Project planning and coordination wif offshore team for various project deliveries
  • Optimizing the Informatica maps for faster data loads

Environment: Confidential, Sales Cloud, Informatica Cloud, Oracle APEX Language, Visual Force - Pages, Component & Controllers, Confidential .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

Integration Consultant

Roles & 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 wif 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 wif standard Confidential 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 wif 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: Confidential Sales Cloud and Communities.

Confidential, San Ramon, CA

Confidential Developer

Roles & 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 Confidential .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 Confidential 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 Confidential to establish the connection wif 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 — New York, NY

Informatica PowerCenter Developer

Roles & 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.
  • Created web service classes/methods to be consumed by Oracle Fusion and Tibco.
  • Created Sharing rules for user groups and day to day permission to the users and support issues Sandbox refreshes.
  • Worked as team lead for onsite and offshore developers.
  • Created reports and designed dashboards for the Management team.
  • Architecture design of the Jobs site development and provided support.

Environment: Confidential Sales Cloud, Data.com

Confidential — Merrimack, NH

ETL Developer

Roles & Responsibilities:

  • Technically leading the project from offshore.
  • Gathering Business Requirements and coordinating wif 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 wif 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 noledge documents and guiding the team to do the same.

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

Hire Now