SHIVA PRASAD KONGARI

MS DYNAMICS CRM SR.CONSULTANT

S K I L L S E D U C A T I O N

D365, MS Dynamics CRM

****/****/**** (Online &

On-Prem)

Power BI, Power Apps, SSIS &

SSRS

Visual Studio (2015/2017),

SSDT (2015), XRM Tool Box,

SDK (D365/2015/2015)

MS SQL Server 2008/2014, MS

Access 2003/2007

C#.Net, Java Script, Web Api’s,

JSON, XML, HTML

Siebel 8.x/7.x

GIT, TFS

.

Master in Computer Application (MCA)

Year of completion: 2009

SDES, Jawaharlal Nehru Technological

University,

Hyderabad, Telangana, India.

Percentage: 84%

Bachelor in Science (Maths,Stats,Computers)

Year of completion: 2006

Nizam College, Osmania

University,

Hyderabad, Telangana, India.

Percentage: 87%

Intermediate Education

Year of completion: 2003

Sri Pratibha Jr. College,

Ongole, Andhra Pradesh, India.

Percentage: 89%

Secondary Education

Year of completion: 2001

Sri Santosh Vidyanekthan School,

Pochampally, Telangana, India.

Percentage: 79%

adcipx@r.postjobfree.com Bangalore, Karnataka +91-888******* P R O F E S S I O N A L E X P E R I E N C E

adcipx@r.postjobfree.com Bangalore, Karnataka +91-888******* 1. ACO Technology Centre,

Bangalore Mar 2017 – Present

Project 1: ACO CRM Global

Duration: Mar 2017 – Present

Software / Special Tools: MS Dynamics CRM 2016/D365 On-premises, XRM Tool box, MS Dynamics Development Tool Kit (SDK 2015/D365), Plugin Registration Tool, C#, SSIS, Java Script, SQL

CRM@ACO supports processes in sales and marketing.

CRM covers the daily work of the sales agents. It is used to follow the upcoming and expected sales opportunities (called “Objects”) and to turn this opportunities into ACO revenue.

CRM@ACO used by Marketing departments to identify relevant customers for marketing campaigns and follow the activities necessary for these campaigns use CRM.

CRM@ACO includes a template that extends the standard product “Microsoft Dynamics CRM” by ACO specific business needs. This includes supporting business process flow and aligned data structures.

Responsibilities:

• Worked as a Sr. Technical Consultant in the team for designing and developing the Advanced customizations in CRM using technologies like C# .Net, JavaScript

• Handling individually all the custom complex customizations. (Plugins, Custom Workflow, Integration SSIS).

• Involved in writing code in C# and maintain the code for enhancement of software

• Handling Level 3 Issues related to core technical issue in CRM.

• Used Git for maintaining version

• We used SCRUM methodology in this project. Creating sprint of two weeks and following the target.

Key Deliverable’s:

Communication History

This is external HTML application integrated with CRM on major entities (Accounts, Contacts and Opportunities) to display the activities of that record in Iframe. Iframe section Layout has divided into two frames. Left with List View Layout and Right with detailed form Layout.

Key Advantages: User no need to go to activities to see Detailed Information Can see on the Same Record.

CRM One21- Template

CRM One21 is Template created for ACO World those who are willing to use CRM as sales application should use this template.

Key Advantages: Since ACO Company working on individual Cost Centre and each cost center using different formats of CRM, Goal is to use this template as unified CRM application. This may easy to build Umbrella CRM on top these templates. P R O F E S S I O N A L E X P E R I E N C E

adcipx@r.postjobfree.com Bangalore, Karnataka +91-888*******

Exchange Synch Integration

A central synchronization service run on the server, check user Mailboxes in Exchange and CRM for modifications and synchronize the two systems. This synchronization affects:

CRM Appointments (two ways) as Exchange Appointments

CRM Phone Calls (two ways) as Exchange Appointments

CRM Infos (one way: from CRM to Exchange) as Exchange Tasks

CRM Contacts (one way: from CRM To Exchange) as Exchange Contacts Key Advantages: To overcome the below disadvantage’s from the Standard CRM Outlook Client.

Outlook might experience a high load during synchronization

Outlook must run to synchronize the activities

Not all activity types are synchronized

Project 2 – Business Intelligence – Power BI

Duration: June 2018 – Present

Software / Special Tools: Power BI, SQL, Excel, JSON BI@ACO supports in Finance Controllers to produce meaningful reports. Responsibilities:

• Workings as an BI Developer and BI Architect for designing and developing the Reports using technologies like POWER BI, SQL, LucaNet,Excel and JSON

• Design database and architecture of application

• Designed the Data Model using Power BI.

• Preparing and presenting project status weekly and Monthly with Customers.

• Discussion with Functional team on data quality and data clean up.

• Used Git for maintaining version

• We used SCRUM methodology in this project. Creating sprint of two weeks and following the target

Key Deliverable’s:

ACO Holding Report

Delivered Report to ACO Group of Controllers to see below measures across ACO World.

Profit & Lost

Indirect Cost Graph

Sales, Result before Tax.

ACO Nordic BI

Delivered Report to ACO Nordic Finance Controller to see 11 ACO Companies performance under Nordic Region. Below Key measures covered

Cost of Good Sales.

Sales Margin

Profit & Lost

Indirect Costs.

P R O F E S S I O N A L E X P E R I E N C E

adcipx@r.postjobfree.com Bangalore, Karnataka +91-888******* Project 3: Application Development

Duration: Oct 2017 – Present

Software / Special Tools: .Net, Angular, SQL, Excel, JSON Application Development @ACO supports in Open Source Development, Cross Domain Applications, Configurations, Production Planners. Responsibilities:

• Workings as an Project Lead & Delivery Manger for Requirement Gathering

,designing and developing the applications using technologies like .Net, Angular, SQL, Excel, JSON

• Design database and architecture of application.

• Plan Deliverables.

• Facing Customer on Queries and Deliverables.

• Preparing and presenting project status weekly and Monthly with Customers.

• Discussion with Functional team on requirements.

• Resource Handling.

• Used Git for maintaining version

• We used SCRUM methodology in this project. Creating sprint of two weeks and following the target

Key Deliverable’s:

Polymer Production Planner

Application Developed in Open source (VueJS) to be helpful for Site Engineer at Polymer production Plant to Track the Status of Items to be produce. Used by ACO Australia.

Shower Drain Configurator

Application Developed in Open source (VueJS) to be helpful for ACO users who can configure Shower Drain with ACO products online. Used by ACO France

Production Planning Software – Iron Casting

Application Developed in open Source (Angular JS) to be helpful for Field Engineer and Production planner to Plan IRON casting in advance by checking on demand and stock. Used by ACO Germany

Trench Selection Tool

Application Developed in open source (VueJS) to be helpful for sales to select which Trench is suitable and able to download as PDF file. Used by ACO USA.

Dealer Finder

Application Developed in Open Source to be helpful to find out the Dealers in that region. Used by ACO Austria.

Qlickview Report Dashboard Application

Application Developed in .Net to see the Dashboard /Reports, which are available in Qlickview. Used By ACO CZ.

P R O F E S S I O N A L E X P E R I E N C E

adcipx@r.postjobfree.com Bangalore, Karnataka +91-888******* 2. Capgemini Solutions Pvt Ltd. Bengaluru.

June 2010 – Feb 2017

Project 1: THOR – ASTRA Migration & Maintenance

Duration: 1 Year & 5 Months

Software / Special Tools: MS Dynamics CRM 2015, Salesforce, SQL 2008 R2 & BizTalk, Java Script, SQL

THOR (The Heart of Relationships) is a salesforce CRM tool for Capgemini Sales, which serves as Customer Relationship Management for Capgemini Organization.

ASTRA (Accelerating Sales Transformation for Revenue Acquisition) CRM is internal intelligence project for IGATE.

Since Capgemini Acquired IGATE in 2015,This project designed and Executed for migrating ASTRA (IGATE CRM Application tool) Data and Interfaces to THOR

(Capgemini CRM Application Tool)

Project Handled in Two modules parallel

1) Data Migration ( Migrating IGATE Sales users data into THOR) 2) THOR- IGATE Legacy System Interfaces (Routing Data from THOR

(In place of ASTRA) to IGATE Legacy systems.

Responsibilities:

Played Manager role to deliver both modules from IGATE technical team

Preparing and presenting project status weekly and Monthly with GLOBAL Heads.

Evaluated the both applications to prepare best methodology for migration and Interfaces module

Design the migration plan to provide the data to THOR in prescribed formats.

Lead the team for preparing data ready queries for migration in SQL and applied THOR business principles before providing data to THOR.

Discussion with Functional team on data quality and data clean up.

Meeting with IGATE legacy system technical and functional owners regarding change in new business process.

Attended workshops with THOR technical, functional and IGATE Legacy technical and functional teams to conclude the solutions.

Architect solutions finalized in Workshops for establish Interface between THOR an IGATE legacy applications.

Leading Stabilization phase for interfaces.

Preparing documentation on each implementation.

P R O F E S S I O N A L E X P E R I E N C E

adcipx@r.postjobfree.com Bangalore, Karnataka +91-888******* Project 2: ASTRA IMPLEMENTATION & MAINTENANCE, CRM EVALUATION Duration: 2 Year & 6 Months

Software / Special Tools: MS Dynamics CRM 2013/2015 online, SQL server 2008 R2, XRM Tool box, MS Dynamics Development Tool Kit( SDK 2013/ 2015), Plugin Registration Tool, C#, Java Script, SQL

ASTRA (Accelerating Sales Transformation for Revenue Acquisition) CRM is internal intelligence project for IGATE.

A paradigm Shift: Opportunity Tracking System -> Full-scale Sales Force Automation platform.

Built on the foundation of the sales processes.

Promotes the culture of collaboration and communication – easy to share updates, transferable insights, connections and success stories.

Institutionalizes Sales Group knowledge, relationships and interactions as a company asset – retains customer information within the organization.

Enhances productivity – offline access to the CRM, outlook integration and mobility features support on-the-go usage.

Responsibilities:

Lead & Architect Role in ASTRA – THOR migration and Interfaces.

Played Project Lead role in stabilization period, Enhancing new features and implement new business requirements.

Meetings with Functional team for new requirements and design and explains to technical teams how to achieve or implement this solution.

Preparing and Presenting WSR (Weekly Status Report) to BU Heads

Working on Sales Module, Sales process, Opportunity lifecycle, Out of Box Workflows, Dashboards Email triggers etc.

Lead Role in Data Migration from Siebel CRM to MS Dynamics CRM.

Developed inbound / outbound Workflows for automation of Sales related processes and integrating with the external systems.

Involved in Administration activities migrating the repository from development to testing environment, and assisting the production support team during deployment activities.

Performance Dashboard, worked on Performance management module where in system configured in a way to represent Target V/s Achievement data for each Sales User P R O F E S S I O N A L E X P E R I E N C E

adcipx@r.postjobfree.com Bangalore, Karnataka +91-888******* Project 3: IGATE-PATNI CRM MIGRATION, CASPER UPGRADE Duration: 3 Year & 6 Months

Software / Special Tools: SIEBEL 7.8,8.1.xTools, SIEBEL 7.8 (SEA),SIEBEL 8.1.x Enterprise Edition(SIA), SQL Server 2005,SQL Server 2008 R2, SIEBEL eScript, Java Script, SQL

CASPER (Customer Acquisition and Sales Process for Enhancing Relationship) is internal project, which serves as Customer Relation Management (CRM) for iGATE - Patni Organization.

Built on the foundation of the sales processes.

It manages information regarding clients, projects and sales functionality of iGATE Corporation in IT Industry Sector. Institutionalizes Sales Group knowledge, relationships and interactions as a company asset – retains customer information within the organization.

The project servers Organization Heads by providing statistics of Business in terms of revenue (it includes Forecast and Actuals) on daily basis Responsibilities:

Lead Role in Data Migration from PeopleSoft CRM (IGATE CRM) to CASPER (Patni CRM).

Develop reusable components in Application, Following standard principals of SIEBEL to maintain low complexity and follow best practices of industry and technological standards in maintaining quality of code.

Lead Role in SIEBEL Upgrade from 7.9 to 8.1.1.11

Did the SIEBEL administration by Installing SIEBEL servers and upgrade to new version.

Siebel Administrator role-played post upgrade for all new released patch upgrades.

Groom programmers new to industry in understanding business requirements, develop software product, unit testing, documentation and in providing Quality Assurance and follow best industry standards/specifics.

Convert functional requirement is to develop suitable suite of SIEBEL Integration/ Workflows/EIM’s/Business Service, which meets requirements that is accessible, usable, efficient, re-usable, cost effective, maintainable and reliable.

Contact this candidate