SUMMARY:

• Total 12+ years of experience in designing, developing, maintaining and building large business applications
• Over 5 years of working experience using SalesForce.com, CRM Application Platform, Visual Force
• Over 7 years of experience using Informatica, Pentaho ETL tools and Data Visualization tools like Tableau Desktop and Tableau Server
• Experience in CRM business processes like Campaign Management, Lead Management, Account Management, Case Management, Quote and Forecasting
• Expertise in Single point of contact (POC) to business stakeholders on all deliverables and issues
• Experience with Apex Language, Apex Trigger, Apex Scheduler, Batch Apex, Apex class & Web service, Visual Force
• Working experience with Force.com IDE in design and development of Custom Application for Complex Business Processes of various cloud modules
• Experience in Production Support, Incident Management, Troubleshooting, Preventable actions
• Wrote SOQL and SOSL statements within custom controllers, extensions and triggers
• Ability to work in a cross - functional working environment with the Product Owner of CRM and lead developers to develop Agile projects
• Great customer interfacing skills and customer orientation
• Experience in Salesforce lighting version, working on Aura framework and create lighting components
• Used Sales force Lightning Design Systems (SLDS) in order to develop the lightning components
• Integrating Sales force Marketing Cloud with other systems like SQL or APIGEE
• Experience in working in an agile environment utilizing tools such as Jira, Microsoft TFS, and Confluence.
• Solid understanding of relational databases, with expertise in writing SQL statements for data extraction
• Experience in Call Center Product (Premise /Cloud) Analytics, Enterprise Analytics, Salesforce -SFDC

WORK EXPERIENCE:

Confidential, Indianapolis, IN

Salesforce Developer/Admin

Responsibilities:

• Interacted with multiple business team members to gather requirements and documented
• Enabled Sales force connections between partner sales force orgs and the client's org
• Created search layouts to organize fields, custom links, related lists, and other component
• Experience with Apex Language, Apex Trigger, Apex Scheduler, Batch Apex, Apex class & Web service, Visual Force
• Created workflow rules and defined related Tasks, time triggered tasks, email alerts, field updates to implement business logic
• Used Sales force Lightning Design Systems (SLDS) in order to develop the lightning components
• Configured Sales Force Automation (SFA) for Campaign management, Opportunity, Management, Account and Contact Management, Data Quality Management
• Worked on complex workflows and approval processes for automating business logic
• Created various Custom Objects, Tabs, Entity-Relationship data model, validation rules on the objects and tabs, Components and Custom links
• Worked on Salesforce.com Application to Setup activities and customized the apps to match the functional requirements of the organization
• Created different types of reports like summary reports, matrix reports, pie charts dashboards and Report Folders to assist managers to better utilize Sales force as a sales tool.
• Configured various Reports for different user profiles based on the need in organization
• Installed Sales force App Exchange (Knowledge Module) Application, configured and maintained user security permissions

Environment: SalesForce.com CRM Application Platform, Visual Force, Sandbox, Production environment

Confidential, Indianapolis, IN

Salesforce Developer/Admin

Responsibilities:

• Created the detailed requirements document after interacting with the business users
• Designed and implemented various Email templates for Auto-Response to customers
• Identified and created workflow rules and defined related tasks, email alerts and field updates
• Experience in writing triggers, classes, visual force pages, custom object
• Created users, roles, public groups and implemented role hierarchies, sharing rules and record level permissions to manage sharing access
• Experience building segments and deploying dynamic content
• Involved in creating Custom Objects and fields for transactional and contractual information
• Implemented field level security along with page layouts to manage access to specific fields
• Designed User Interfaces for Sales force users as per requirements
• Identified and created pick lists, dependent pick lists, lookups, master detail relationships, validation and formula fields to the custom objects
• Designed Custom tabs, validation rules, Approval Processes and Auto-Response Rules for automating business logic
• Participate in training sessions to the internal business users to use the application
• Identified and created page layouts, search layouts to organize fields, custom links, related lists, and other components on record pages
• Created a sync of contacts, email alerts, events and tasks between Sales force to Outlook and Outlook to Sales force successfully.
• Involved in data loading, data cleansing and maintain the data quality
• Assisted in loading the parameters and creating order through manager workbench

Environment: Data Loader, Workflow & Approvals, Reports, Custom Objects, Custom Tabs, Sandbox, Security Controls, Triggers, Classes, Visual force pages

Confidential, SFO, CA

Salesforce Developer/Admin

Responsibilities:

• Involved in Salesforce.com Application Setup activities and customized the apps to match the functional needs of the organization.
• Implemented Web-to-lead to track and solve leads from the website
• Involved in Salesforce lighting version, worked on Aura framework and create lighting component based on the requirements
• Created different workflow rules and Approvals for various campaign processes
• Designed, and developed the Custom objects, validation rules, Page layouts, Custom tabs, Components, Visual Force Pages to suit to the needs of the application
• Interacted with various business team members to gather and document the requirements
• Developed various Visual force Pages, Apex Triggers to include extra functionality and wrote Apex Classes and Controller to provide functionality to the visual pages
• Worked with the service cloud application and restful API
• Implemented Auto RABIT for higher release velocity and faster Time for automated deployment sand box and production back ups
• Worked on various salesforce.com standard objects like Campaigns, Leads, Accounts, Contacts, Opportunity, Forecast, Cases, Reports and Dashboards
• Developed and configured various Reports for different user profiles based on the need in the organization
• Implemented the requirements on Salesforce.com platform and Force.com IDE Plug-in using Eclipse.
• Participated in the training sessions provided by the Sales force team and support end user.

Environment: Salesforce.com platform Salesforce.com Data Loader, Reports, Workflow & Approvals, Web Services, Sandbox

Confidential, Pleasanton, CA

Salesforce Developer/Admin

Responsibilities:

• Created user Roles and Profiles, security controls and shared settings
• Developed Custom Objects, Custom reports and configured Analytical Snapshots to dump the data into on a regular basis for sales performance and lead generation statics
• Worked on various SFDC standard objects like Accounts, Contacts, Leads, Reports and Dashboards
• Extended standard native Force.com functionality using Visual force, Apex, AJAX and Web services like SOAP & REST
• Responsible for the evaluation of design programs and validating the same
• Customized the Dashboards to the track usage for productivity and performance of business centers and their sales teams
• Delivered project reports using custom objects and standard objects
• Used Data Loader for Data Management in force.com platform
• Implemented field level security, profiles and audit trail setup
• Created workflows for automated lead routing, lead escalation, alerts and custom coaching plans
• Worked with the service cloud application and restful API
• Provided the training to the internal business users to use the application and develop their own custom reports
• Perform administration tasks as needed, managing custom fields, integration and data clean up
• Designed, developed and deployed Custom objects, Components, Visual Force Pages based on the requirements of the application

Environment: SFDC, Force.com, Sharing Rules, Windows server 2003, Web services, Controllers, Workflows, Email Updates

Confidential, Mountain View, CA

ETL & Report Developer

Responsibilities:

• Experience in building ETL pipe lines in Pentaho kettle transformation, to bring data from various sources i.e. spread sheets, flat files, relational data sources
• Creating Ad-hoc reports on demand, Gathering Business requirements for custom reports
• Created views and dashboards that are presentable to internal and external vendors.
• Build advanced chart types and visualizations bar in bar charts- bullet graphs
• Combine data sources by joining multiple tables and using data blending, visualizations techniques
• Assign access privileges to the groups, users to the individual dashboards
• Created dashboards displaying sales, variance of sales between planned and actual values
• Implemented calculations and parameters wherever needed
• Build dashboards using techniques for guided analytics, interactive dashboard design, and visual practices
• Experience in using various transformation like text file input, table input, stream look up, filter, merge join, transformations and jobs in Pentaho

Environment: Tableau 8.2,PantahoKettle(Pantheon), Big Query, Oracle 11g, SQL Server, MySql, Gbuntu( Confidential unix machine)

Confidential, SFO, CA

Salesforce Admin/Developer

Responsibilities:

• Worked on various salesforce.com standard objects like Campaigns, Leads, Accounts, Contacts, Opportunity, Forecast, Cases, Reports and Dashboards
• Developed various Visual force Pages, Apex Triggers to include extra functionality and Apex Classes and Controller to provide functionality to the visual pages
• Implemented Auto RABIT for higher release velocity and faster Time for automated deployment sand box and production back ups
• Involved in Salesforce.com Application Setup activities and customized the apps to match the functional needs of the organization
• Interacted with various business team members to gather and document the requirements
• Implemented the requirements on Salesforce.com platform and Force.com IDE Plug-in using Eclipse.
• Designed, and developed the Custom objects, validation rules, Page layouts, Custom tabs, Components, Visual Force Pages to suit to the needs of the application
• Developed and configured various Reports for different user profiles based on the need in the organization
• Implemented Web-to-lead to track and solve leads from the website
• Created different workflow rules and Approvals for various campaign processes
• Participated in the training sessions provided by the Sales force team and support end user.

Environment: Salesforce.com platform Salesforce.com Data Loader, Reports, Workflow & Approvals, Web Services, Sandbox

Confidential, Mountain View, CA

ETL & Report Developer

Responsibilities:

• Interacted with business Clients and gathered requirements based on business process.
• Developed reports and dashboards using Tableau as front-end to data
• Involved in tableau migration and scheduling
• Experience in building hierarchies, attributes and measures
• Automate monitoring and server job processes
• Build complex calculations in Tableau
• Manage tableau users, groups, and integration with active directory
• Experience in taking back ups and restoration of Tableau repository
• Involved in troubleshooting the load failure cases, including database problems
• Involved in Production Deployment and Support
• Familiar with Installation, configuration, patching and upgrading of Tableau tool across the environments

Environment: Informatica, Tableau, Oracle 11g, SQLServer, DB2, SQL, Flat Files, Teradata

Confidential, Whippany, NJ

ETL & Report Developer

Responsibilities:

• Involved in the Design, Development, Testing, Analysis, Requirements gathering
• Interacted with business community and gathered requirements
• Created Informatica mappings for initial load and daily updates
• Extracted the data from different sources like Flat files, Oracle and transformed the data based on the business rules and loaded in to target database
• Created Dynamic parameter files and changed Session parameters, mapping parameters, and variables at run time
• Designed reusable transformations and shortcuts to share different mappings
• Responsible for determining the Performance bottlenecks and fixing the bottlenecks
• Responsible for Unit Testing and Integration testing of mappings and workflows
• Involved in troubleshooting the load failure cases, including database problems
• Involved in Production Deployment and Support

Environment: - Informatica 9.0.1/8.6,IDQ, Oracle 11g,Sybase, Teradata, SQL, PL/SQL, UNIX

Confidential, Denver, CO

ETL & Report Developer

Responsibilities:

• Interacted with business community and gathered
• Developed a standard ETL framework to enable the reusability of similar logic across the board
• Developed mappings to extract data from SQL Server, Oracle 11g, Teradata, Flat files and load into Data Mart
• Troubleshooting database, workflows, mappings, source, and target to find out the bottlenecks and improved the performance
• Involved in Production Deployment and solved various Production issues
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, Workflows and database tuning
• Written shell scripts in UNIX to execute the workflow
• Cleansed the source data, extracted and transformed data with business rules, and built Applets using Informatica Designer
• Extensively used PL/SQL for creating Packages, Procedures and Functions
• Written shell scripts to run the workflows and automated them through maestro job scheduler
• Developed Slowly Changing Dimension for Type 2
• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, work lets and workflows
• Involved in generating reports using Business Objects

Environment: - Informatica Power Center 8.6/8.5,Power Exchange B2B, Oracle 11g, MySql, PL/SQL, Confidential AIX, UNIX Shell Scripts, BO, Erwin

Confidential, Dublin

ETL & Report Developer

Responsibilities:

• Developed mappings to extract data from SQL Server, Oracle, Teradata, Flat files, XML files and load into Data warehouse
• Interacted with business community and gathered requirements based on changing needs
• Incorporated identified factors into Informatica mappings to build Data Warehouse
• Involved in troubleshooting the load failure cases, including database problems
• Involved in Production Deployment and Support
• Written Queries, procedures, created Indexes, primary keys and data bases testing
• Defects were tracked, reviewed and analysed
• Worked with Reporting team to Generate reports using Business Objects
• Identified sources, targets, mappings and sessions and tuned them to improve performance

Environment: - Informatica Power Center 8.1, Oracle 9i, Teradata, PL/SQL, SQL Server 2000, UNIX Shell Scripts, Business Objects, Erwin