Data Management Product

Pavan Kumar Mannam

Email: ******.****@*****.*** Mob: 732-***-****

PROFESSIONAL SUMMARY

• A seasoned IT Professional with an extensive experience of around 18 + years of experience in CRM, Business Analysis, Product Management, Project Management, Data Management

& Team Management in Medical devices, Pharmaceuticals, Life Science, Travel & Hospitality, Telecom and Banking Industries

• Managed, collaborated and implemented multiple Salesforce, Veeva, Data Integration and Analytics solutions

• Experienced in gathering requirements, analyzing business processes, gap analysis and translating into CRM solutions

• Experience in implementing CRM solutions using Salesforce, Veeva CRM, Siebel CRM, Informatica Cloud, Informatica, Master Data Management, Sales force alignment and hierarchies, Field Sales reporting.

• Experience in implementing CRM solutions for Fortune 500 clients in the US with an earned reputation for meeting strict deadlines and delivering critical solutions on time, can grasp complex & new technologies very quickly and always keep in touch with emerging trends in technology

• Proficient in Analysis, Design, Managing, Developing, Customizations and implementation of Data and analytical solutions using AWS, Redshift, Postgre, PL/SQL & SQL, Python, Tableau, Qlik, Power BI, Data Modeling, Data Warehousing, Data Integration

• Demonstrative track record of developing and managing high quality processes to implement complex business rules, procedures and data transformations.

• Ability to work independently and simultaneously on multiple projects of moderate to high complexity under compressed timeframes. Proven experience to interface, influence and negotiate and manage expectations with business partners. Additional areas of expertise include:

• Relationship Management

• S/W Design / Quality Assurance

• Team Building / Leadership

• Release Management

• Project Design / Deliverables

• Technology Integration

Pavan Kumar Mannam

Email: ******.****@*****.*** Mob: 732-***-****

EDUCATION DETAILS

Bachelor of Technology in Mechanical Engineering (4 years) passed out in 2003 from JNTU Hyderabad, India

CERTIFICATIONS

• Salesforce Certified Administrator

• Salesforce Certified Business Analyst

TECHNICAL SKILLS

Veeva CRM • Call Plan and Alignments, Call Management, Sample Management, Territory Management, Account Management, Product Management, Approved Email, Multi-Channel, iRep, CLM, Data Loading Salesforce CRM

• Apex, VisualForce, S-Controls, Salesforce.com API,Force.com IDE, Integration, Web services, Apex Data Loader, SOQL, SOSL, Angular JS, JENKINS,

Reporting • Tableau, Qlik, Power BI

Databases:

• Oracle 11g/10g /9i/8i, MS SQL Server 2000/2005,IBM DB2 Programming Languages

• SQL, PL/ SQL, Python, Java, C, C++ &Unix Shell scripting. ETL • Talend, Informatica Cloud, Informatica Power Center Web Technology • Web Services, SOAP, WSDL, XSLT, XSD, XML, JavaScript, C,C++,CSS and HTML

Other Tools: • TOAD, SQL*Loader, SQL Developer, Erwin, FOM, SKURA (SIM). PROFFESIONAL EXPERIENCE

IT Product Owner

J & J Medical Devices (MD), NA Nov 2019 – Present Lighthouse is committed to delivering comprehensive, innovative and tailored solutions that empower our MedTech Commercial business functions to optimize operations, streamline processes, drive growth and customer satisfaction. Ever-evolving ecosystem of commercial effectiveness capabilities: Salesforce CRM, pricing & contracting, case scheduling & ordering, and data & reporting. Provide a robust data network where we can synthesize data into meaningful insights about our customers and the markets MedTech serve with data-driven actionable insights and efficient selling processes and tools that improve the customer experience and enable revenue growth. Who We Support Field Sales Organization, Strategic Customer Group, Internal Business Partners, External Customers Pavan Kumar Mannam

Email: ******.****@*****.*** Mob: 732-***-****

Responsibilities:

• Working with stakeholders to understand and document business requirements and translating them into Salesforce technical requirements and user stories in JIRA

• Leading and managing Salesforce development and testing teams for better collaboration

• Working with development teams to design and document solutions based on business requirements

• Creating user stories along with acceptance criteria to meet business requirements

• Working with testing teams to create, document and write test scripts to perform System integration testing(SIT)

• Providing regular status updates on project health, recommendations and progress to Business stakeholders and other partners

• Documenting Salesforce functional and technical requirements by maintaining confluence pages for future references

• Conducting demos to Business stakeholders along with Development teams to make sure business needs are met

• Working with Business users to create user acceptance testing(UAT) scripts aligning to the Business requirements

• Performing User acceptance testing and dry runs with Business users to meet acceptance criteria

• Conducting workshops with End users and Business stakeholders to understand the future enhancements on Salesforce applications

• Identifying risks and challenges and propose solutions to make sure release timelines are not affected

• Managing communication between stakeholders, Business Users, Leadership and vendor teams

• Performing sanity checks before and after the release for smooth production deployment

• Performing post deployment validations on data migration activities, ensuring data integrity

• Creating and managing reports, dashboards within Salesforce for business teams

• Analysing and extracting data using SQL to build reports for business teams analysis

• Deep understanding of Salesforce Lightning features and functionalities

• Implemented Lightning Web Components to enhance user experience and streamline data input forms, improving user adoption by 30%

• Training and supporting end-users on newly Implemented Lightning components to improve user productivity

• Led cross-functional teams in the successful migration of legacy systems to Salesforce Lightning, reducing operational costs by 30% and improving user adoption by 85% Pavan Kumar Mannam

Email: ******.****@*****.*** Mob: 732-***-****

• Implemented custom Apex triggers and Lightning components, optimizing sales processes and improving overall productivity

• Led data migration bulk data into Salesforce Lightning, ensuring data accuracy and reducing system downtime during the transition.

IT Lead Business Analyst

J & J Medical Devices (MD), NA Dec 2017 - Oct 2019 J & J MedTech as a leading Medical device company, specialized in orthopedic and surgical products. The primary focus is to support Depuy Synthes, Ethicon and CSS companies representing different sectors within the MedTech. These include Joint Reconstruction, Trauma, CMF, Mitek, Spine, Power Tools, Ethicon and BWI/CSS facilitating seamless data integration and Analytics across these sectors to Data warehouse and Reporting applications to provide comprehensive support to field sales reps through effective data management and reporting.

Responsibilities:

• Partnered with Business Leaders, global Product Line teams, Application Services teams and Vendor teams to understand requirements and for future deliverables

• Managed and prioritized product backlog for business continuity, facilitated sprint planning to increase team productivity and reduction in delivery time

• Managed stakeholders ensuring the goals are met and keep stakeholders informed

• Managed implementation, enforcement,defined and maintained data governance policies to ensure data quality, managing data access controls within the data lake to maintain integrity and security.

• Managed design and implemented multiple data pipelines to ingest data from various sources into the data lake

• Managed data lake storage infrastructure and optimized overall performance

• Managed and handled multiple Data integration Projects with in MedTech

• Integration with ICS systems to pull Contracting, Pricing and Compliance data

• Integration with EUSS systems to pull HCP and HCO data

• Integration with Sales, Orders & Compensation Management systems to pull data to DWH • Integration with Roster Management system to pull customer, Contact, User, Territory, Alignments

• Managed Application Lifecycle Management Activities for Data & Analytics product group Pavan Kumar Mannam

Email: ******.****@*****.*** Mob: 732-***-****

• Managed and Maintained Access Control for MedTech Data Analytics AWS instances using industry best practices

• Managed and led implementing SQL queries, functions and stored procedures

• Managed & led Data Virtualization initiative using next gen tools like Denodo for end users reporting as per business needs & co-ordinating with global teams Veeva/Salesforce CRM Consultant

Janssen Pharmaceuticals, NA Mar 2010 - Nov 2017 iCONNECT is Janssen Pharmaceuticals, North America’s Customer Relationship Management solution as part of the Medical Information Evolution

(MIE) strategy. This solution for Medical Information is built on Salesforce.com’s “cloud computing” suite. iCONNECT puts field-based Sales, field-based Medical staff and Medical Information colleagues on a single, shared platform.

Responsibilities:

• Demonstrated ability to adapt, accommodate and to support critical initiatives while balancing my own workload

• Experienced in agile delivery, project scope, milestones and meet deliverables as per relevant Business, Partners and Leadership stakeholders

• Managed communication with internal and external Partners, Stakeholders and Vendors to implement features and integrations

• Manage the ongoing roadmap un a risk-impact analysis of project resources, contributing to budgeting activities

Application Enhancements:

• Managed design, development and deployment of Apex Classes, Controller Classes and Apex Triggers, Visualforce pages for various functional needs in the application using Force.com IDE - Salesforce.

• Managed and led Application and Data Integration in the planning, implementation and proposing new solutions and technologies

• Extensive experience in creating Custom Objects, Fields, Workflow Alerts, Approval Process, Triggers, Validation Rules, Custom Reports and Dashboards

• Extensive experience in Creating Roles, Profiles, Page Layouts, Security settings and Sharing Models

• Managed Data Quality initiative including integrating different systems with iCONNECT such as EDW, Reporting, SCM, and Commercial Excellence

Pavan Kumar Mannam

Email: ******.****@*****.*** Mob: 732-***-****

• Managed Call Plan, Alignments and User - Territory Management process. Data Integrations:

• Managed the iCONNECT integration using Informatica Cloud for Data migration and Integration activities for internal/external systems with iCONNECT

• Managed Accounts, Cases, Call Plan, Insights, Scheduling, Alerts, Tasks, Alignments, Territory and User - Territory Management Integration process to support iPad solutions

• Led and successfully delivered the following initiatives

• Patient Support Program for Canada and US

• KOL data integration with iCONNECT

• JJEDS – HR Integration

• AMPIL Integrations

• Veeva Suggestions for Canada and US

• Managed Data Integration Projects for JANSSEN PHARMACEUTICALS, EMEA Siebel CRM consultant

British Telecom, UK Mar 2006 - Feb 2010

BRITISH TELECOM is one of the worlds leading providers of communications solutions serving customers in Europe, the Americas and Asia Pacific. Data Integrations is used to migrate data from multiple source systems to Siebel CRM using EIM, SQL and PLSQL. Responsibilities:

• Analyzed the Data integration technical requirements. Interacted with the client effectively for understanding the requirements.

• Designed the Concepts for ongoing interfaces data loading components of the planned Siebel Call Center Platform Solution with different legacy data bases. Analyzed Legacy databases and created mappings for underlying tables.

• Involved in Extraction, Transformation, Loading data concepts, processes and performance tuning.

• Analyzed the ADM (Application data map). Interacted with Designers for clarifications. Pavan Kumar Mannam

Email: ******.****@*****.*** Mob: 732-***-****

• Written Low level and High level design documents according to ADM and sending for peer review, internal review and external review. Developed Code according to Design document.

• Developed Control files, SQL Scripts, PLSQL procedures and packages to load data from flat files, legacy systems into Siebel system.

• Involved in migrating high volume data from multiple legacy source systems to Siebel 7.7 Environment: - Siebel 7.7, Oracle 9i, TOAD, FOM

Contact this candidate