Salesforce Digital Marketing
Resume:
Lavanya Tallapelli
*******.*.**********@*****.*** PH : 614-***-****
Sr. Salesforce Technical Architect
Professional summary:
Expert with Salesforce development, Apex and VisualForce. Expert in Sales Cloud, Salesforce Marketing Cloud, Salesforce CPQ, including SQL queries and AMPScript. Have started developing solutions using REST calls to Marketing Cloud from Sales Cloud.
Worked on Salesforce CPQ (Steelbrick),Configurator, Pricing, Guided Selling, Advanced Approvals, Quote Templates
Build CPQ Quoting & Product configuration, pricing for Fortinet. Customer has a large family of product with many dependent components and were adding product at individual SKU level.
Expert in demonstrating the capabilities to build and design solutions across Salesforce platforms
Assisted in execution of process, security and technical needs by configuration of salesforce systems. Conducted collection and analysis of functional, technical and non-functional requirements. Created applications and integrated customized solutions to support business needs. Suggested steps and measures for improvements in software solutions and systems.
Evaluated technical decisions and deliverables for compliance and quality analysis.
Expert in providing solutions, driving and delivering the complex projects
Experience in Open Group Architecture Framework, Data Architecture, Salesforce, CRM, Marketing Cloud, Oracle, Teradata, ETL, BI, Oracle cloud and Data Analytics
Extensive experience in Consulting, Chemical, Insurance, financial, Retail and Bank
Strong analytical and adaptive problem solving skills. Intuitive grasp of technology at both high - and hands-on levels. Performed business analysis for clients and designed effective technology solutions. Particularly effective at building solutions by customizing and integrating off-the-shelf software to avoid costly and time-consuming development.
Expert communicator. Makes technology comprehensible for a non-technical audience in both internal and external communications. Can bridge the gap between technical and non-technical audiences. Experienced with interviewing customers, users and management to perform needs assessments. Expert technical and marketing writer.
Extensive consulting experience as both an independent consultant and as a contractor. Managed projects for clients, developed and maintained relationships with clients and vendors.
Technical Summary
Cloud Technologies
Sales Force (Sales and Marketing cloud), CRM, Salesforce CPQ, Financial Services
Data Warehousing
(ETL, BI Tools)
Informatica Power Center, Data Stage,Cognos, Microstrategy, Tableau Desktop, Tableau Server, and Tableau Reader
Data Modeling
SAS ABM, Erwin, Sybase Power Designer, Star-Schema Modeling, Snowflakes Modeling, FACT & Dimensions
Databases
Teradata, Oracle, SQL Server, DB2
Programming
SQL, SQL Assistant, Transact SQL, PL/SQL, SOSL, SOQL, APEX, AMP, SSJS, Triggers etc
Professional Experience
PwC (PricewaterhouseCoopers) March 2020 to Current
Role : Sr. Salesforce (Sales and Marketing cloud) Technical Architect
Remote
Works directly with clients to lead projects, facilitates business process analysis sessions, develops and delivers key components of technology solution
Functioning as leader within the organization and industry. Examples may include subject matter expert, in Sales Cloud and Marketing cloud, speaker at industry events.
Experience with Data integrations
Designs and implements business technology solutions focused on cloud-based business applications.
Familiar with project management fundamentals and fulfilling the project management role on projects
Perform the most advanced design and development tasks
Partner with project managers to monitor project status and risk areas
Provides presales support as requested
Responsible for Marketing Cloud Connect that combines the digital marketing capabilities of Marketing Cloud with the data management, segmentation, and campaign management tools in Salesforce
Responsible for Salesforce Lightening implementation and core languages (AMP Script, Visualforce, Apex, and SOQL)
Salesforce entities, workflows, configurations, customization and development, and integration development
Provide performance feedback and coaching on a regular basis to each team member in a constructive manner. Write and administer performance reviews
Environment: Agile, Cloud API, Salesforce sales cloud(Lightning), Salesforce CPQ, Data Loader, Salesforce Marketing Cloud ( Email Studio, Automation Studio, Mobile Studio, Journey Builder), Marketing Cloud Connect, data loader, Einstein Analytics, Apex, Amp script and SSJS, Oracle DB
Chemical Abstracts, Columbus OH June 2018 to Feb 2020
Role : Sr. Salesforce Technical Architect / Project Manager
Expert in project work stream delivery, work plan management, analytics, reporting and client interface/presentation, client project delivery management, relationship management, team leadership and agile scrum environment
Expert in Agile environment
Worked extensively with Financial and Sales team to lead their business process improvement technology projects
Experience with Salesforce Financial Services projects related to the milestones for Revenue, Billing and order recognition.
Responsible for implementing and maintaining the Salesforce configuration, schema, custom objects, and workflows across Sales Cloud instance
Responsible for Marketing Cloud Connect that combines the digital marketing capabilities of Marketing Cloud with the data management, segmentation, and campaign management tools in Salesforce
Responsible for Salesforce Security Model
Responsible for Salesforce Lightening implementation and core languages (AMP Script, Visualforce, Apex, and SOQL)
Salesforce entities, workflows, configurations, customization and development, and integration development
Salesforces suite of products across full SDLC
Ownership of the architectural strategy and solution design of client's Salesforce platform
Maximizing the value of Salesforce platform, learning from best practices to enhance and evolve the Salesforce instance with the most current releases from Salesforce
Participate in workforce management; involved in employee scheduling, internal employee rotations/cross-training efforts, and performance management.
Provide performance feedback and coaching on a regular basis to each team member in a constructive manner. Write and administer performance reviews
Recommends and encourages employees to seek innovative improvements to processes in order to improve team performance and effectiveness
Worked effectively with Marketing and sales team for data analytics.
Responsible for people Management, including goal setting and providing performance feedback
Establish and maintain trusted advisor relationships with project stakeholders by providing vision and future product roadmap
Environment: Agile, Oracle, Marketing Cloud API, Financial services, Salesforce Marketing Cloud, Salesforce Cloud Connect, SF CPQ,Salesforce sales cloud, data loader, Einstein Analytics, Business Objects, Tableau Desktop, Salesforce service cloud, Eloqua, Web Services, Change Sets, Chatter, Reports and Dashboards, GitHub, AWS, Oracle PL SQL
Nationwide (Financial, Insurance, Bank),Columbus, OH March 2010 to June 2018
Role: Salesforce Technical Architect
Expert in Mentoring and coaching, supervise, conducting meetings and providing overall direction to the department.
Worked on quantitative techniques and processes used to enhance productivity and business gain. Worked on Data extraction to categorize and to identify the behavioral data, patterns, and techniques based on organizational requirements
Worked with programmers and project managers to create data models for new features
Created and optimized indexes and queries to ensure peak performance at all times
Expert in Scrum Agile environment
Experience with advanced Analytics, worked on measurement, test plans, Market research, segmentations, multiple channels in Nationwide including PCIO, Nationwide Financial, Nationwide Bank.
Excellent at creating class models, sequence diagrams, component models, etc
Responsible for creating Marketing communications, campaign management, segmentations and other development activities of
Worked on Sales force cloud implementation projects, Worked on Data Migration from Teradata to Salesforce Marketing cloud.
Experience with Data architecture and Integrations
Experience with Nationwide advisor’s data (Life, Annuity, Mutual funds etc)
Worked on Tableau reports and Salesforce cloud computing (wholesalers to track the advisor activity).
Environment: Marketing Cloud ( Email Studio, Automation Studio, Mobile Studio, Journey Builder) Agile, Customizations, Workflows, Process Builder, Salesforce Sales Cloud, Salesforce Marketing cloud, Exact Target, Reports and Dashboards, GitHub, Informatica Power center 10, Tableau Desktop, Tableau Public, SAS 9.4, Teradata SQL Assistant V15, Teradata CRM, Exact Target, ARM, Agile environment, DevOps, JIRA tools, MS office/MS Project
Limited Brands Jan 2007 – March 2010
Victoria’s Secret Direct (Columbus, OH)
Informatica/Data Warehouse Consultant
Limited Brands sells lingerie, personal care and beauty products, apparel and accessories through its Victoria's Secret, Pink, Bath & Body Works, C.O. Bigelow, La Senza, White Barn Candle Co. and Henri Bendel brands.
Through Victoria's Secret Catalogue and VictoriasSecret.com, Victoria's Secret Direct makes it possible to customers to experience sophisticated intimate lifestyle of Victoria's Secret 24 hours a day, 7 days a week. Victoria’s Secret Direct reaches more than 390 million customers each year through Victoria's Secret Catalogue
Responsibilities:
Worked on Teradata BTEQ, FastLoads, Mloads and ETL applications environment.
Worked on SQL assistant to retreive sql queries based on the business requirements.
Worked on stock ledger application performance issues in Informatica.
Developed complicated Informatica mappings for stock ledger
Worked on Peregrine for production ticket
Completed PL/SQL Coding related to retail Supply Chain Management systems (Oversold application and Stock Ledger application).
Lead the IT and end user groups business meetings to collect the requirements.
Designed the work flow and developed the code and technical requirements based on the business requirements.
Worked on mainframe to remove and update orphan records and FTPed data from mainframe to run most of the jobs in Informatica. Worked on metadata manager
Actively communicated with the development team to assure they were following technical specifications.
Worked on Peregrine tool to solve most of the production and customer related issues in the form of tickets.
Extensively creating database packages, procedures, functions etc.
Created indexes on Reporting tables and tuned the SQL Queries for better lead times of reports.
Worked on C-shell, K-Shell scripts for batch processing in production and also reporting side
Was on call for entire period of time and use to manage control-M production jobs when failed
Managed Informatica upgrade decision making.
Environment: Informatica power center 8.0/, Informatica repository manager, Power Mart 6, SAS ETL 9.2.1, Oracle 11/10g, DB2, SQL Developer, Toad, Teradata 7.1, Teradata SQL assistant, Teradata Administrator 7.1, ETL works on UNIX, Main frame, XML, HTML
USAA – San Antonio, TX Jun 2006 – Dec 2006
Business Analyst / Data Warehouse Lead
USAA provides products and services dedicated to helping military members and their families reach their financial goals. It also provides insurance and other financial services (P&C, Banking, IMCO, Financial planning services, Alliance Services Company, etc.). Their operations involve multiple software applications that generate transactional data. This data along with data from external agencies form the sources from where data is integrated and BI applications generate reports on marketing functions.
Worked on terminal server installations and fire call id’s set up for offshore projects.
Created database packages, procedures, functions, cursors and triggers using PL/SQL.
Worked on ETL and BI tool comparison matrix and was also involved in USAA COE ‘s tool documentation.
Actively participated in marketing performance requirement meetings and documented BRD’s.
Completed data migration from Oracle to SQL server (meta data using Microstratergy)
Analyzed the specifications and identifying the source data that needs to be moved to the data warehouse.
Worked on developing complex mappings in SAS ETL to load the data from different sources
Responsible for the developing ETL processes/programs with SAS EL to extract data from the client's operational databases, Transform and filter the data, and Load it into Target database using different transformations like Source Qualifier, look up (connected and unconnected), Expressions, Aggregator, Joiner, Sequence Generator, Filter and Router transformations
Environment: Informatica power center 7.0, DB2 Oracle 10g (Staging, Data Warehouse), Toad, SQL developer, SAS, Microstratergy 8.02, XML, HTML, Erwin (Data Modeling), Cognos Power play and frame work manager.
Brown Brothers Harriman - Newport, NJ Nov 2004 – May 2006
ETL Developer/ Analyst /Data Warehouse Admin
BBH is implementing an activity-based costing (ABC) model with the goal of enhancing the profitability of the Firm and has selected SAS Institute Inc.’s Activity-Based Management product as the application’s platform for Project DIER II.
Responsibilities:
Documented and designed the ETL flow according to the cost objects created and model the whole process in two different environments one in ETL phase and other in ABM (Activity Based Management) phase.
Worked on Microsoft SQL Server 2005 SQL, Oracle 10g and DB2 and stored procedures, connections using OLEDB and DBMS for SAS ETL
Created indexes on Reporting tables and tuned the SQL Queries for better lead times of reports.
Created PL/SQL (Oracle 10g) procedures for user friendly interaction with SAS.
Environment: SAS 9.1.3 on HP-Unix, OS/390, DB2, SQL server, Oracle 10g (Staging, Data Warehouse), Toad, XML, HTML, Erwin (Data Modeling), Cognos Impromptu and Power play, PowerPlay Web viewer, PowerPlay web explorer.
Education:
Bachelors of engineering (JNTU), India
Certification:
Salesforce Certified Admin / Platform Developer I
Teradata Certified Professional in Teradata 12 Basics(TE0-121)
Teradata Certified Professional in Teradata SQL(TE0-122)
Oracle Certified Associate.
Contact this candidate