Post Job Free

Resume

Sign in

Data Project

Location:
Mountain View, CA
Posted:
March 30, 2015

Contact this candidate

Resume:

[pic][pic]

HariKiran Katta

SALESFORCE Admin/BSA

408-***-****

acoyjz@r.postjobfree.com

[pic]

Professional Summary:

. 8 years of IT experience in Business Analysis, System Analysis, Use case

Design, Development, Testing and Administration and system integration

. 5 years of experience as Salesforce Business Analyst and Administrator

in CRM space

. Involved in various stages of Software Development Life Cycle (SDLC)

including analysis, requirement engineering, architecture design,

development, enhancements, testing, deployment, maintenance, portals and

communities of enterprise applications.

. Expertise in Sales cloud, Service cloud and Force.com platforms.

. Certified Saleforce.com Administrator.

. Developed Test Scenarios, Test Cases and Test Data for UAT.

. Developed training material and Conducted End user training

. Experienced in CRM business processes like Forecasting, Campaign

Management, Lead Management and Knowledge Management

. Experience in Salesforce Administration and Creating Roles and Profiles.

. Extensive experience in designing of custom objects, custom fields, role

based page layouts, Workflow Alerts and Actions, and Approval Workflow,

Validation Rules, Approval Processes, custom Tabs, custom reports,

report folders, report extractions to various formats, Snapshots,

Dashboards, and Email generation according to application requirements.

. Experience with data migration and updates through Data Loader in

Salesforce.com.

. Provided direct support to Salesforce users during post-implementation

issues.

. Experience in integration testing with SOAP UI/REST Console/stubs

. Worked with 3rd party tools like eloqua,Exact target, dedupe tools and

docusign

. Experience on Salesforce using Apex Language and Visual Force Pages.

. Excellent communication, analytical, interpersonal, and presentation

skills

. Ability to meet deadlines and handle pressure in coordinating multiple

tasks in a work/project environment.

. Versatile team player with excellent analytical, presentation and inter-

personal skills.

Skill Set:

Salesforce Technologies Salesforce CRM, Apex Language, Apex

Classes/Controllers, Apex Triggers, Visual

Force Pages/Components, Analytic Snapshots,

Case Management Automation, Workflow &

Approvals, Dashboards, Analytic Snapshots,

Custom Objects, SOQL, SOSL, Visual Force Pages

/ Components, S-Controls.

ETL/Integration Tools Ab Initio(GDE 3.1.7.3), Force.com Data Loader,

Connect for Outlook, Force.com Explorer and

Force.com Workbench

Programming and Data Programming: Java, C, C++, HTML, DHTML, XML

Analysis

Databases Microsoft SQL Server 2000/2005/ 2008, MS

Access, Oracle 8i/ 9i/ 10g/ 11g and DB2

Net Networking TCP/IP, Firewalls, Network Programming

Web Services SOAP, REST

Operating Systems Windows NT/2000/XP/Vista/7, Windows Server

2000/2003/2008, Linux, Unix.

Professional Exp rience:

Client: VISA Inc. Foster city, CA

Jan 2014 - Current

Salesforce BSA /Admin

The Corporate Business Systems team provides support for Finance, Revenue,

Human Resources, Customer Relationship Management (CRM) and Corporate Risk

applications for Visa. This includes to automate and improve existing CRM

Sales applications or building new ones; moving all core sales processes

and technology to Salesforce.

Salesforce will be replacing CYBS Siebel as the CRM for Cyber Source Sales

and Marketing activity. However, CYBS Siebel will continue to exist for

Cyber Source Service activity and will require integration with Salesforce

to stay in sync. Additionally, there are existing integrations to/from CYBS

Siebel that will need to be ported to Salesforce

Environment: Salesforce.com platform, Data Loader, Apex Classes,

Controllers, Triggers, Visualforce, Email Services, Security Controls,

Sandbox data loading, Workflow & Approvals, Custom Reports, Dashboards.

Responsibilities:

. Design, build, configuration and documentation of technical components

for the CRM Salesforce Cloud implementation

. Conduct or participate in prototyping sessions with business and IT

resources to ensure clarity of requirements.

. Design conversion including data mapping from CRM On Demand and Siebel to

Salesforce

. Worked with VISA mobility team on Sale mobility to deliver against

business requirements

. Analyze business requirement, identify risks, and collaborate on solution

to meet business needs

. Coordinate with other VISA technical teams to implement: engineering,

database, network, security, QA

. Estimate work effort and staffing needs, develop technical execution

plan, track progress against milestones, and drive results in partnership

with PM, and other team members

. Evaluate 3rd party tools for security, scalability and fit

. Involved in field & page layout customization for the standard objects

like Account, Contact, and Leads.

. Understand, plan, and execute with a strong focus on balancing risks and

value. Identify risks proactively and develop mitigations.

. Involved in the Data Transformation and Data Cleansing activities while

transferring the data to the external systems

. Working with internal staff, and system integrators manage the delivery

of required solution components to ensure quality and timeliness of work

. Communicate effectively and proactively with IT stakeholders and

articulate ideas and recommendations clearly.

Client: Ingram Micro Inc., Irvine, CA.

Feb 2013 - Dec 2013

Salesforce Admin/BSA

Ingram Micro Inc. is the world's largest wholesale technology distributor

and global leader supply-chain, mobile device lifecycle services and

logistics solutions. The company implemented cloud-based CRM system to

improve their partner communication and visibility for support and product

management.

Environment: Salesforce.com platform, Data Loader, Apex Classes,

Controllers, Triggers, Visual force, Workflow & Approvals, Custom Reports,

Dashboards.

Responsibilities:

. Perform detailed analysis of business and technical requirements and

designed the solution by customizing various standard objects of

Salesforce.com (SFDC).

. Involved in identifying, planning and implementing new Salesforce.com

features and functions (new screens, workflow, force.com objects,

reports, apex code) in response to business needs.

. Involved in creation of custom fields, field dependencies, tabs,

applications, home page components.

. Developed various Batch Apex classes and scheduled those using Apex

Schedulable classes on hourly basis.

. Developed and configured various Custom Reports and Report Folders 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.

. Created and used Email templates in HTML and Visual force and controlled

the content in these templates using Components and controller class.

. Created reports and dashboards.

. Integrated the Web Services for extracting the data from external

systems.

. Created the SIT test plans and involved in SIT testing and coordinated

for UAT testing.

. Involved in Unit Testing, for the customizations and developments done

during the project.

. Involved in documentation review cycles for the project and assign review

tasks to the project team. Follow-up with reviews to see them through to

completion.

. Communicated project status and escalate issues to management. Provide

feedback for improving Technical Publications procedures, standards, and

methodologies

Client: Frost National Bank, San Antonio, TX

June 2012 - Jan 2013

Salesforce Admin/BSA

Frost National Bank is a financial service provider. It provides a full

range of commercial and consumer banking products, investment and brokerage

services, insurance products and investment banking services. This project

was based on implementing Salesforce CRM Enterprise Edition for their sales

team for better customer management. Integrated with their Salesforce.com

in organization to allow their customer's to submit enquiries and register

complaints without requiring users to log in with a username and password.

This project mainly focused to provide better way of migrating customer's

enquiries to the respective queues and implemented web to case in a more

efficient way.

Environment: Saleforce.com platform, JavaScript, Apex, Visual force,

Force.com IDE, SOQL, Email Services Triggers, HTML, CSS, Apex Data Loader,

Eclipse.

Responsibilities:

. Involved in salesforce.com setup activities and customized the apps to

match the functional needs of the organization.

. Developed and Customized User interface in salesforce.com using Visual

force, Apex controllers and Force.com IDE.

. Designed and developed the web-based UI using JavaScript, HTML and DHTML.

. Designed and developed Visual force pages and controllers for

distribution enhancement.

. Built apex classes implementing SOQL statements within Eclipse to manage

interaction with the database.

. Involved in migrating data from Oracle to Salesforce.com.

. Developed web services using Salesforce.com Web services API to provide

data for third party clients.

. Created and deployed several Reports using salesforce.com platform.

. Created Visual force email templates and also automated Email Process to

send installation instructions to new and existing customers.

. Used CSS in HTML code to better manage look and feel of web pages.

. Experience with Integrated Development Environments such as Eclipse.

. Created summary reports, matrix reports, pie charts and Dashboards to

assist the business team.

. Worked intensely on custom objects, triggers and workflows.

. Designed and build custom applications using Force.com and

Visualforce.com.

. Used Apex Explorer for viewing salesforce.com data

Client: Motorola Solutions Inc., Schaumburg, IL.

Nov 2011 - June 2012

Salesforce Admin/BSA

Electronic communications pioneer Motorola, Inc. is a leading designer and

manufacturer of cellular phones, cordless phones, two-way radios, pagers,

cable modems, broadband set-top boxes, and other communications products

and systems. This Project was based on migrating all the data from one

instance to another instance. The goal of migration is to analyze and

access the level of effort required to migrate users and data onto a

unified salesforce.com platform. It mainly focused on building a framework

for global and regional programs, providing a centralized foundation for

acceleration of productivity enhancements and also to drive operational

efficiencies.

Environment: Saleforce.com platform, Apex Language, Visual Force (Pages,

Component & Controllers), Pages, Data Loader, HTML, Workflow & Approvals,

Reports, Custom Objects, Custom Tabs, Email Services, Security Controls,

Sandbox data loading, Eclipse IDE Plug-in, Windows XP

Responsibilities:

. Business Process review to analyze, organize and prioritize the

implementation.

. Planned and implemented salesforce.com 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.

. Created different types of Custom Reports for standard objects as well as

custom objects

. Configured Role based Authorization on Object/Field Level.

. created rule based automated workflows

. Providing ongoing salesforce.com maintenance and administration services

including periodic data cleansing, custom objects, workflow

. Maintained data cleanliness and accuracy by adding custom validation

rules, custom formulas, reports and dashboards

. Created Executive Team dashboards; these dashboards consisted of current

month sales, forecast, and activity, YTD sales, YTD open forecast-

Marketing effectiveness by campaign, forecasted sales by campaign

Client: Advanced Energy Industries, Fort Collins, CO

Jan 2010 - Nov 2011

Salesforce BSA

Advanced Energy Inc. is a leading based company in delivering reliable

Inverters, Products, Robust Operations, Maintenance Services that allow

customers to secure more solar projects and grow their business. This

company is a trusted partner to solar project developers, financiers,

beneficiaries around the globe. This Project mainly dealt with supporting

the existing Salesforce Application together with Integration of Salesforce

with SAP using the middleware Process Integration (PI).The goal of the

integration is to sync SFDC with SAP

Environment: Saleforce.com platform, JavaScript, Apex, Visual force,

Force.com IDE, SOQL, Email Services Triggers, HTML, CSS, Apex Data Loader,

Eclipse

Responsibilities:

. Involved in salesforce.com setup activities and customized the apps to

match the functional needs of the organization.

. Developed and Customized User interface in salesforce.com using Visual

force, Apex controllers and Force.com IDE.

. Designed and developed the web-based UI using JavaScript, HTML and DHTML.

. Designed and developed Visual force pages and controllers for

distribution enhancement.

. Built apex classes implementing SOQL statements within Eclipse to manage

interaction with the database.

. Involved in migrating data from Oracle to Salesforce.com.

. Developed web services using Salesforce.com Web services API to provide

data for third party clients.

. Created and deployed several Reports using salesforce.com platform.

. Created Visual force email templates and also automated Email Process to

send installation instructions to new and existing customers.

. Used CSS in HTML code to better manage look and feel of web pages.

. Experience with Integrated Development Environments such as Eclipse.

. Created summary reports, matrix reports, pie charts and Dashboards to

assist the business team.

. Worked intensely on custom objects, triggers and workflows.

. Designed and build custom applications using Force.com and

Visualforce.com.

. Used Apex Explorer for viewing salesforce.com data

Client: Citi Bank

Jan 2007 - Dec 2009

Ab initio developer

Purpose of the project is to reduce Franchise Risk is Basel II

implementation to meet the guidelines provided by Basel Committee on

Banking Supervision. As part of the Basel II implementation in this project

we are receiving various types of custom and transaction files, from these,

based on history data of Country and regional account level data, Basel

parameters are calculated and submitted to GCBC (Global Consumer Basel

Consolidator) server for reporting purpose. This project is migration as

well as development project, some part of the code was already developed in

SAS and now client wants to migration this SAS code to Ab initio along with

new development of some modules, for automation and performance improvement

purpose.

Environment: Ab-Initio 3.0, 1.14 GDE with Co>Op 3.0, Co>Op 2.14, JCL,, IBM

DB2,Clear Quest, Clear Case,autosys

Responsibilities:

. Responsible for creating Ab-Initio graphs for click stream analysis of

data gathered by running web campaigns.

. Implemented Ab-Initio configuration and well-tuned setting up environment

for Production and development environment

. Responsible to create different Generic Graphs using the Ab-Initio

components

. Implemented Data Parallelism through graphs, which deals with data,

divided into segments and operates on each segment simultaneously through

the Ab-Initio partition components to segment data

. Implemented a 16 way multifile system that is composed of individual

files on different nodes that are partitioned and stored in distributed

directories (using Multidirectories).

. Responsible for designing Parallel Partition (CPU bound) Ab-Initio Graph

for high volume data warehouse for 24-month warehouse

. Database Query Optimization and I/O tuning techniques have been used for

performance

. Responsible to configure the db configuration file to connect to the ODS

and DSS to Load the data.

. Converted user defined functions of business process into Ab-Initio user

defined functions.

. Responsible for deducing and consolidating customer records from various

sources to create master customer list.

. Prepared and implemented data verification and testing methods for the

Data Warehouse as well as to design and implement data staging methods

and stress testing of ETL routines to make sure that they don't break on

heavy loads.

. Performed the ongoing delivery, migrating client mini-data warehouses or

functional data-marts from Oracle environment to Teradata.

. Enhance existing Queries to run faster and more efficiently.



Contact this candidate