Lavanya Tallapelli

adfx2r@r.postjobfree.com 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