SUMMARY

• Used DataStage designer to develop the process for extracting, cleansing, transforming, integrating and loading data into the data mart database
• 4Years of experience with SalesforceCustomization, Security Access, creating profiles,roles, users, page layouts, email services, Scheduling Jobs & Reporting.
• 3 years of experience in ETL using Datastage (Ver.11.3/9.1/8.5/8.1/7.5) client components, Datastage designer, Datastage manager and Datastage director.
• Experience in development, administration, configuration, Implementation, and Support of sales force CRM, and Salesforce applications based onApex Languageand leveragingForce.comPlatform and Apex Unit testing.
• Expertise in support on SalesForce.com Platform and Enterprise Application Data Model Management.
• Experienced in implementation using Apex Language, Classes, Controllers & Triggers, Web Services, Visual Force Pages, Components, Tabs, Custom Objects, Reports, Analytic Snapshots and Dashboards.
• Extensively worked on Administration, Configuration, Implementation and support with Salesforce.com platform.
• Have been working with marketing cloud for the implementation of various modules in the project and integrating with salesforce.
• Experience working with Teradata and Oracle databases.
• Strong knowledge of data warehousing basics and relational database management systems and dimensional modeling (star schema and snowflake schema).
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Oracle, flat files, csv files and xml files.
• Strong inclination for finishing jobs before project deadlines. Flexible and versatile enough to adapt to the changing environments.
• Experience in migrating ETL code to upgraded version.
• Experienced in capturing, analyzing and documenting requirements.
• Capable of handling multi - tasking and multiple projects performing different roles.
• Possess excellent communication, interpersonal skills; has the ability to effectively work both as a team player and as an individual.
• Salesforce Certified Consultant.

TECHNICAL SKILLS

• Sales force automation including Leads, Web to lead, Accounts, Contacts and Opportunities, Visual Force (Pages, Components & Controllers), Cases, SolutionsIdeas, Customer Portal, Customer Self Service portal, Web to Case, E-mail to Case, Campaigns, Leads, Chatter Accounts, CRM, Contacts, Opportunities, ForecastsProducts, Assets, Contracts, Cases, Solutions, Ideas. Field creation, Page Layout creation/editing, Related list, chatters, life cycle implementation, marketing
• cloud customization, Unit testing, Record Types, Field Level and Object level security, role hierarchies, sharing models, Reports, DashboardsFormula Fields & Cross Object Formula Fields, Apex, MS Access Reports, Crystal Reports 14.0, Microstrategy, IBM InfoSphere DataStage 9.1/8.7/8.5IBM WebSphere DataStage 8.0.1, Ascential DataStage/7.5/ 7, Shell scripts (C Shell, K Shell, and Bourne Shell), Perl, Python, AWK, VI, and SED, APIETL tools, Force.com IDE, Workbench. SQL, L2 support.

PROFESSIONAL EXPERIENCE

Confidential, SanJose, CA

Sr. Salesforce Developer/Admin

Responsibilities:

• Business Process review to analyze, organize and prioritize the implementation.
• Planned and implemented salesforce.com app and trained users
• Managed and conducted a business process reengineering project concentrating on the Activities tracking, Service Requests, Business Development and Customer Service functions
• Met with potential users to gather requirements, wrote specifications, developed applications based on those specs, coordinated QA and UAT, facilitated final deployment, and maintained the applications once deployed..
• Designed the application to be created module wise using the schema builder.
• Implemented REST API to retrieve the recent items on the customer portal VF page.
• Designed and developed Database migration scripts and execute migration plan from Siebel to Salesforce.
• Prepared the Visual force pages with the needed UI designs.
• Performing the UI related activities including Page layout configuration.
• Worked on the Web Services for enabling the data to be used outside the domain.
• Made the configurations in the applications time to time as per the requirement gathering.
• Worked extensively on APEX Triggers, APEX Classes, Apex Test Classes, Visualforce pages to fulfill various business requirements.
• Created and deployed various Triggers, Apex classes and Visual force pages as part of the implementation.
• Customized page layouts for Opportunity, Contacts, and Accounts depending upon user profiles and created permission sets where necessary.
• Making the timely data management using the Data Loader tool and thus making the insert, delete, upsert operation on the data.
• Defined lookup and master-detail relationships on the objects and created junction objects to establish connectivity among objects.
• Constructed new sandbox Plan and assembled all the Requirements for Project.
• Deployed Configurations and Code between Salesforce Environments through various deployment tools like Force.com IDE, Snapshot.
• Involved in Working with Standard Salesforce features like Objects, Workflows, Record Types, Page layouts, Workflow Rules, Case Assignment Rules, and Escalation rules, Validation rules, Profiles, Roles, Reports and Dashboards etc.
• Worked on Service Cloud console with exposure to CTI adapters.
• Used SOQL & SOSL with consideration to Governor Limits for data manipulation needs of the application using platform database objects.

Environment: Salesforce.com platform, Apex Language, Visual Force (Pages, Component & Controllers), Data Loader, HTML, Java Script, Workflow & Approvals, Reports, Custom Objects, Custom Tabs, Email Services, Sandbox data loading, Eclipse IDE Plug-in, Windows XP.

Confidential, Timonium, MD

Sr. Salesforce Developer/Admin

Responsibilities

• Participated in Requirement Gathering Sessions & JAD Sessions to understand business needs and converted business requirements into functional / technical specific documentation.
• Played key role in enhancement of business modules using Standard and Custom Objects, Custom Settings, formula logic, WSDL, Custom buttons, Visual force Pages, APEX classes, Triggers, Test Methods involving SOQL Queries.
• Implemented the requirements on Salesforce.com platform using Force.com IDE Plug-in -Eclipse.
• Worked on enhancements to SFDC application as required by business users from time to time-
• Implemented salesforce1 application to make the sales reps to use the application on the go.
• Involving implementations in Service Console of Salesforce.
• Worked on Salesforce implementations from inception to delivery.
• Worked with REST API and other API for the integration of the data.
• Developed Mobile application using the salesforce1 app for the easy use of the application and implemented to work on different systems.
• Worked with chatter for sharing the personal details of the user in the application
• Selected and led execution of a cloud-based inventory management and warehousing solution residing inside of Sales that creates purchases orders, sales orders and invoicing transactions before transferring them to warehouse for fulfillment
• Converted several manual/ traditional processes into Salesforce Applications, which included creating Custom Tabs, Visual Force tabs, Web tabs, Visual Force Pages, Workflow & Approval Processes, scheduling Apex Jobs, maintaining Force.com Sites for Web-to-Case applications.
• Clinical data management and bio-statistical programming support for various phases of clinical studies
• Reviews and makes recommendations for process development and improvement.
• Active involvement in solving day-to-day tickets having deadlines -which involved direct contact with clients/users.
• Involved in running daily reports & setting static and dynamic dashboards for logged in Users.
• Well versed with the process of detailed analysis of business and technical requirements and craving to the solution by customizing various objects of Salesforce and using other Platform based technologies like Visual Force Pages, Java Script & Apex Triggers.
• Designed Visual Force Pages, Apex Classes, Controller Classes and Apex Test Classes for various functional needs in the application and performed Unit Testing.
• Collaborate with company leaders on defining and articulating CRM vision, and building the CRM roadmap
• Familiar in writing Well Designed Project Documentation for future reference.
• Actively managed resolving issues during pre and postproduction both in Sandbox as well as Production using apex unit testing.

Environment: Saleforce.com, Force.com Explorer, Apex Triggers, Visualforce Pages & Apex Controllers, Salesforce.com Data Loader, Eclipse IDE, Workbench, Custom Objects & Custom Tabs, Apex Unit testing.

Confidential Dallas, TX

Salesforce Developer/Admin

Responsibilities:

• Interacted with various business team members to gather and documented the requirements. Implemented the requirements on Salesforce.com platform and Force.com IDE Plug-in using Eclipse.
• Worked on various salesforce.com standard objects like Accounts, Contacts, Leads, Campaigns,
• Coordinated with users to determine requirements and prepared design Documents.
• Performed detailed analysis of technical and business requirements Reports and Opportunities.
• Closely worked with SalesForce.com consultants while implementing the solutions for the requirements.
• Worked on various salesforce.com standard objects like Accounts, Contacts, Leads, Campaigns, Reports and Opportunities.
• Designed, Implemented and deployed the Custom objects, Page layouts, Custom tabs, and Components, to suit to the needs of the application.
• Involved in Salesforce.com application setup activities and customized the apps to match the functional needs of the organization.
• Developed various Custom objects, Tabs, Entity-Relationship data model, validation rules, Components.
• Used Data Loader for insert, update, and bulk import or export of data from Salesforce.com Objects. Used it to read, extract, and load data from comma separated values (CSV) files.
• Defined lookup and master-detail relationships on the objects and created junction objects to establish connectivity among objects.
• Involved in field & page layout customization for the standard objects like Account, Contact, and Leads.
• Involved in creating and customizing Email template and configuring them to the email alert within the workflow rule for a standard/custom object.
• Developed various Custom objects, Tabs, Entity-Relationship data model, validation rules, Components.
• Used Data Loader for insert, update, and bulk import or export of data from Salesforce.com Objects. Used it to read, extract, and load data from comma separated values (CSV) files.

Environment: Saleforce.com platform, Visual Force Pages, Data Loader, Workflow & Approvals, Reports, Custom Objects, Custom Tabs, Email Services, Security Controls, Sandbox data loading, Windows XP.

Confidential

Sr. ETL/SQL Developer

Responsibilities:

• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Created Complex UNIX Shell scripts.
• Involved in requirement gathering with the business users, vendors and the banks (client of our client).
• Used PL/SQL features such as stored procedures, functions, packages and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Responsible for extracting, transforming and loading data Using UTL FILE, SQL LOADER.
• Involved in writing Unix Shell Scripts.

Environment: Oracle 9i/10g, UNIX Shell Scripting, SQL Loader, PL/SQL, TOAD, Windows 2000, UNIX.

Confidential

Jr. ETL Developer

Responsibilities:

• Analyzing the mapping documents, understanding the business requirements.
• Understand the Low Level Design Documents and thereby develop the jobs.
• Data from different source systems was extracted, transformed and loaded into data warehouse tables.
• Responsible for using different types of Stages such as Transformer, Join, Sequential File, Copy, Filter and Aggregator to develop different jobs.
• Developed Parallel and Sequence Jobs.
• Created Shared Containers, Local Containers for DS jobs.
• Used Data Stage Director to schedule, monitor, and run jobs.
• Prepare Unit test cases and execute them.
• Maintain the test cases and test results in Quality Center Tool, Update the defect status as on when required.
• Prepare Unix Scripts and Control M jobs flow.
• Implemented Best practices to optimize the performance.
• Designed ETL Process as per the requirements and documented the Flow using Visio.
• Did Unit testing and tuned for better performance with updates on data ware house tables.
• Provided Post Implementation Support.

Environment: Ascential DataStage 7.5.3, IBM WebSphere, DataStage 8.1v, Oracle 9i, HP Quality Centre, UNIX Shell Scripting, SQL, PL/SQL