We provide IT Staff Augmentation Services!

Informatica Developer Resume

0/5 (Submit Your Rating)

Milwaukee, IL

SUMMARY

  • 9 years of IT experience in Application Development, Design, Implementation, Customization and Support which includes 5+ years of experience in SalesForce.com CRM Platform as Developer & Administrator.
  • Experience in realizing the business requirements to design on salesforce.com platform by designing the required entities like custom objects, creating the relationships/ junction objects like Master - Child, lookups, Entity Relationship data model, Pages, Classes, Interfaces, Workflows, Visual flows, Approval process & Workflow rules, triggers, Email alerts and business logic .
  • Worked on Page layout creation and page layout assignment based on the profile and assigning different picklist values to the different record types.
  • Development experience on SalesForce.com using Apex Language (Classes, Controllers & Triggers), VisualForce Pages, Custom Tabs, Custom Objects, Custom Fields, Formula Fields, Validation Rules,writing Workflows, S-Controls, Reports, Analytic Snapshots and Dashboards.
  • Hands on working experience in Role Hierarchy, Custom Profiles.
  • Worked in creating Roles, Profiles, queues, public groups and Email Templates.
  • Familiar with AJAX.
  • Experience in querying salesforce.com database using SOQL & SOSL queries using Force.com Explorer.
  • Development experience with, HTML, CSS, JavaScript and JQUERY in Visualforce Pages
  • Experience building Custom Controllers/VF Components.
  • Hands on Experience in implementing Case Management and chatter functionalities.
  • Experience in Developing Applications in Sales cloud and Service cloud environment.
  • Strong experience in developing Applications using Visual Workflow. Hands on experience using Pallette, Resources and Explorer in canvas.
  • Strong experience in developing functionalities using Process Builder, that helps in reducing workflow rules and triggers.
  • Good knowledge on Salesforce Lightning Components.
  • Proficient in Data Migration from Traditional Apps to Salesforce Using Data Loader
  • Proficient in Writing Test Classes with the test coverage of more than 90%.
  • Worked extensively on various salesforce.com standard objects like Accounts, Contacts, opportunities, Products, Price books, Cases, Leads, Campaigns, Reports and Dashboards.
  • Experience in working with Salesforce.com sandbox and production environments.
  • Expertise in creating and deploying components from sandbox to production using change sets and Eclipse.
  • Good Knowledge on Web services ( SOAP/REST APIs ) Integration Concepts.
  • Experience in setting up Connected App and Remote Site settings for establishing third party communications.
  • Good Understanding on different Integration Mechanisms and different types of API’s available.
  • Hands on experience in setting up Single sign-on between two salesforce instances.
  • Implemented various applications in Force.com sites.
  • Configured Web-to-Case and Email-to-Case functionalities.
  • Solid Understanding on Sales cloud and Service cloud.
  • Expertise in analyzing and documenting the workflows and functionality of existing systems, preparing presentation materials to all levels of management.
  • Experience in providing production support, analyzing the cause of abed and fixing it.
  • Excellent analytical, de-bugging skills and documentation skills.
  • Team player with good interpersonal skills, strong understanding of fundamental business processes, excellent Communication and Problem solving skills.
  • Capable of rapidly learning new technologies and processes, and successfully applying them to projects and operations.
  • Responsible for code reviews, and troubleshooting during the project process.
  • Solid understanding of Object Oriented development and design and ability to write clean, well-refactored maintainable code.
  • Hands on Experience in writing BAL and DAO Apex Classes for a controller.

TECHNICAL SKILLS

Sales force Development: Salesforce Configuration, Apex, Visualforce, Triggers, Sales Cloud, Service Cloud, Data Loader, Translation Werkbench, Custom Labels, Article Management, Visual Flows, Process Builder, SOQL/SOSL, HTML, Java Script, CSS, JQuery, OOPS

Tools: /Utilities: Eclipse, Force.com IDE,Force.com Platform, workbench

Web and Graphics: Java Script, HTML, HTML5, CSS, CSS3

DBMS: Microsoft SQL Server 2008, Microsoft Excel, MS Access

Others: Apex Explorer, Data Loader

ETL Tools: Informatica Power Center 9.x/8.x(Repository Admin console, Power exchange, Repository Manager, Designer, Workflow Manager, workflow Monitor)

Methodologies: Agile and Waterfall

PROFESSIONAL EXPERIENCE

Salesforce Developer

Confidential - Minneapolis, MN

Environment: Saleforce.Com Platform, Force.Com Platform, Apex, Visual Force (Pages, Component & Controllers), Pages, Data Loader, HTML, Java Script,, Workflow and Approvals, Reports, Custom Objects, Custom Tabs, Email Services, Sandbox Data Loading, Eclipse IDE

Responsibilities:

  • Worked in agile environment, as of solving the issues within deadlines.
  • Designed, Developed and Customized - Custom Tabs, Objects, Picklists, Dependent Picklists, lookups, master detail relationships, Record types, workflow flows, validation and formula fields.
  • Designed and deployed, Workflow rules, Email Templates, Reports and Triggers for automating business logic.
  • Worked on process builder for updating a field in all child records based on the value in parent record.
  • Created and modified different page layouts in the application.
  • Worked in Workflow rules and created actions like Email alert, Field Update.
  • Written Apex classes using Standard, Custom and Extension controllers.
  • Written Apex triggers and tuned code so that classes and triggers are within governor limits.
  • Developed User-friendly visual force pages with usage of CSS, Javascript, jquery and Html.
  • Implemented AJAX functionality for better performance.
  • Implemented Batch class and scheduled for sending remainder emails to stakeholders.
  • Created and customized Reports as requested by the business users.
  • Worked with SOQL, SOSL queries to perform DML operations like insert, update, upsert, delete and query data from Salesforce.com.
  • Used Data Loader to Insert, Update, Delete, and bulk Import or Export of data from Salesforce.com Objects. Used it to read, extract, and load data from CSV files.
  • Performed administration tasks like creating/customizing Profiles and Permission Sets.
  • Involved in Creation of Public Groups and assigning users to Public Groups which helped in visibility of reports and list views to specific public group users.
  • Involved in creation of queues and assigned Public groups as members of queues.
  • Written Apex Test classes and to that minimum 75% of the code coverage across the application to move to Production.
  • Deployed application from Sandbox to Production using Eclipse.

Salesforce Developer

Confidential - Harrisburg, PA

Responsibilities:

  • Worked on creating new Visualforce pages.
  • Extensively used the salesforce console API.
  • Created flows using process builder in salesforce.
  • Used Force.com Migration tool to migrate metadata between environments.
  • Created custom buttons using Javascript for standard and custom objects.
  • Developed trigger to create activities for the standard objects Account, Contact, Case and Lead.
  • Worked on Http Callouts.
  • Worked on customizing the person Accounts for specific environments.
  • Created test classes to improve the test coverage to 90%.
  • Followed best practices in developing trigger pattern.
  • Created custom apps and custom Objects.
  • Created new Visualforce pages, Components.
  • Used JIRA for stories and bugs tracking.
  • Worked on creating permission sets to ship with the package.
  • Developed various Visualforce Pages, Apex Triggers to include extra functionality and wrote Apex Classes and Controller to provide functionality to the visual pages.
  • Implemented the requirements on Salesforce.com platform and Force.com IDE Plug-in using Eclipse.
  • Using Force.com explorer to fire SOQL and SOSL queries.
  • Did customization in Console App for support agents.
  • Created Labels to set the predefined values for the client side pagination process.
  • Used Force.com developer toolkit including Apex Classes, Apex Triggers and Visualforce pages to develop custom business logic.
  • Involved in Unit Testing, for the customizations and developments done during the project.

Salesforce Developer

Confidential - Raleigh, NC

Environment: Saleforce.Com Platform, Force.Com Platform, Apex, Visual Force (Pages, Component & Controllers), Pages, Data Loader, HTML, Java Script,, Workflow and Approvals, Reports, Custom Objects, Custom Tabs, Email Services, Sandbox Data Loading, Eclipse IDE

Responsibilities:

  • Gathered user and functional system requirements via workshops, interviews and workflow storyboards and Working with stakeholders and project teams to prioritize collected requirements.
  • Worked on service cloud app in my project.
  • Developed various Visualforce Pages, Apex Triggers to include extra functionality and wrote Apex Classes and Controller to provide functionality to the visual pages.
  • Implemented the requirements on Salesforce.com platform and Force.com IDE Plug-in using Eclipse.
  • Worked on various AppExchange products according to the needs of the organization.
  • Worked on various Salesforce.com standard objects like Case Management, Accounts, Contacts, Content, Reports and Workspaces.
  • Creating a sync of contacts, email alerts, events and tasks between Salesforce to Outlook and Outlook to Salesforce successfully.
  • Developed Client side pagination process with all the details.
  • Did customization in Console App for support agents..
  • Worked on enabling the CTI functionality in browser in Salesforce.
  • Created Labels to set the predefined values for the client side pagination process.
  • Developed Custom Validations to override the Salesforce default validation rules.
  • Used Force.com developer toolkit including Apex Classes, Apex Triggers and Visualforce pages to develop custom business logic.
  • Complete bulk imports of data using Apex DataLoader.
  • Deployed the code developed in the Dev Sandbox to the Test Sandbox and the Production sandbox.
  • Involved in Unit Testing, for the customizations and developments done during the project.
  • Interacted with testing and the development teams for the development and testing of the code.
  • Resolve the Cases and support the team on urgent bases, implementation and working with real-time troubleshooting.
  • Communicating regularly with the SFDC designated super users to support them in their role and provide information and training on new features and functionality.

Salesforce Developer

Confidential - San Diego, CA

Environment: Saleforce.Com Platform, Force.Com Platform, Apex, Visual Force (Pages, Component & Controllers), Pages, Data Loader, HTML, Java Script,, Workflow and Approvals, Reports, Custom Objects, Custom Tabs, Email Services, Sandbox Data Loading, Eclipse IDE

Responsibilities:

  • Worked with the user group for requirement gathering throughout the planning and implementation.
  • Perform SFDC administration and development activities which include managing roles, profiles, queues, assignment rules, validation rules, workflows, triggers, classes etc.,
  • Involved in day to day support activities to clear the problems involved with Order Processing on the field
  • Worked on defects and enhancements through analysis, design and development using Force.com IDE.
  • Used dynamic Apex, DML, SOSL and SOQL for efficient database operations, maintaining iterations within governor limit.
  • Developed various apex classes, controller classes and apex trigger to fulfill the functional needs of the CRM.
  • Programmed efficient code for exceptions and error handling.
  • Worked on debugging and implementing test methods to ensure proper functionality of code.
  • Implemented ofdata loaderfor loading the data.
  • Enabledchatterfor the organization to effectively communicate with the users in the organization.
  • Designed and deployedcustom tabs,validation rules,approval processesand auto-responsefor automating business logic.
  • Createdworkflow rulesand defined relatedtasks, email alerts,andfield updates.
  • Implementedpick lists, dependent pick lists, lookups, master detail relationships, validation and formula fields to the custom objects.
  • Developed severalcustom reportsanddashboardsto better assist managers and also report folder to provide report accessibility to appropriate personnel.
  • Involved in deployments using Force.com IDE and Change Sets.
  • Involved in planning, design and implementation of Test Strategy at various stages of SFDC implementation.
  • Involved in developing and maintenance of integrations with various systems like SAP etc.

Informatica Developer

Confidential - Milwaukee, IL

Environment: Informatica Power Center 8.6.1/8.1.1, UNIX, Oracle 10g, SQL Server 2005, Flat Files, Rapid SQL, PL/SQL, PeopleSoft, DB2, Informatica Scheduler.

Responsibilities:

  • Created Source definitions from Flat Files, Sybase, SQL server, DB2, Imported/Created Target definitions and created Reusable Transformations, Mapplets in Shared folder.
  • Designed Source to Target mappings from primarily Flat files and Sybase using Informatica Power Center.
  • Involved in design, development and implementation of ETL process in power center.
  • Responsible for managing, scheduling and monitoring the workflow sessions.
  • Developed Transformation Logic to cleanse the source data of inconsistencies before loading the data into staging area which is the source for stage loading.
  • Created complex Informatica mappings, reusable objects of Mapplets depending on client requirements.
  • Used Informatica Data Transformation and Data Exchange to integrate data safely with the internal systems.
  • Responsible for performance tuning for several ETL mappings, Data mappings, Mapplets, workflow session executions.
  • Used Data Analyzer to track and tune data flow performance, enrich and speed integration
  • Extensively worked on Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregator, Filter, Sequence Generator, Union, XML, etc.
  • Involved in conceptual, logical and physical data modeling and used star schema in designing the data warehouse.
  • Involved in developing an Informatica web service mapping.
  • Responsible for Error handling, bug fixing, Session monitoring, log analysis.
  • Worked on Power Mart client tools viz. Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developers.
  • Wrote a number of stored procedures to validate the complex mappings and automated the validation process.
  • Used UNIX Shell Scripts for automating Batches and Sessions.
  • Generate scripts for Data Migration and Data Validations as specified in the technical design
  • Used Workflow Manager to schedule and run batches, sessions, as well as to check session logs and other session related activities.
  • Involved in unit testing entire process flow.
  • Installation and Configuration of ETL tool Informatica for creating Data ware housing.
  • Written SQL Scripts and PL/SQL Scripts to extract data from Databases.

Informatica Developer

Confidential - NY

Environment: Informatica Power Center 8.6.1/8.1.1, Oracle 10g, BO, TOAD 10.1 for Oracle,DB2, Flat Files, SQL, Windows 2000, Informatica Scheduler.

Responsibilities:

  • Design, Development and Documentation of the ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems.
  • Worked on Informatica 8.6.1 client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Workflow Manager and Workflow Monitor, power center admin console.
  • Involved in design and development of complex ETL mappings.
  • Implemented partitioning and bulk loads for loading large volume of data.
  • Partitioning of data using Round Robin, Pass through, Event based to improve performance.
  • Based on the requirements, used various transformations like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner and Sequence Generator in the mapping.
  • Identified bugs in existing mappings/workflows by analyzing the data flow and evaluating transformations.
  • Performance tuning by session partitions, dynamic cache memory, and index cache.
  • Developed Informatica SCD Type-II mappings. Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, Mapplets and others.
  • Implemented update strategies, incremental loads, Data capture and Incremental Aggregation.
  • Created Stored Procedures AND MATERIALIZED VIEWS in PL/SQL.
  • Created UNIX Shell scripts to automate the process.
  • Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
  • For better performance, created pipeline partitions, SQL Override in source qualifier.
  • Involved in scheduling the workflows through informatica Job scheduler using UNIX scripts. Developed wrapper scripts to run informatica jobs through UNIX.
  • Played a key role in all the testing phases and responsible for production support as well.
  • Involved in defect closing track.

Informatica Developer

Confidential

Environment: ETL-Informatica 8.6-Power Center, Oracle9i, DB2, Flat files, SQL, UNIX scripting, Dollar Universe, Kintana Packages.

Responsibilities:

  • Analyzed various Schemas for Implementation and Modeled the Data Warehousing Data marts using Star Schema.
  • Created mappings using the Transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy, NORMALIZER etc.
  • Extracted data form flat files and oracle database, applied business logic to load them in the central oracle database.
  • Involved in logical and physical data modeling.
  • Created models using ERWIN tool.
  • Involved in Teradata reusable scripts for better performance.
  • Created and Monitored Sessions and Batches using Server Manager.
  • Successfully moved the Sessions and Batches from the development to production environment.
  • Generated completion messages and status reports using Workflow manager.
  • Created workflows and worklets for designed mappings.
  • Developed mappings and loaded data on to the relational database. Worked on Dimension as well as Fact tables.
  • Developed Informatica SCD type-I, Type-III mappings.
  • Created Control table for Audit information.
  • Involved in 24/7 support in monitoring the jobs and make sure that issues are closed in SLA period time
  • Worked on Remedy tool for support tickets.
  • Worked on Kintana package which will deploy code in any environment using pvcs label which will have entire code and table structures and parameter files.
  • Developed some reusable scripts at Informatica level to make job functioning smoother

We'd love your feedback!