Informatica Developer Resume
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