Data Project
Resume:
[pic][pic]
HariKiran Katta
SALESFORCE Admin/BSA
**************@*****.***
[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