Giovanni Modica Resume

• Lead a team of professionals in implementing and deliver a successful Salesforce solution for the most important tourism company in Spain. I was the Team Leader and Technical Architect for the project. The project was a complex one, implementing the latest state of the art for Service and Sales solutions, with more than 20 integrations with different on-premise and cloud solutions, and used by +3500 users in Europe. By delivering this solution on time with a very high success we allowed the customer to save millions of euros in licenses for the old system.
• Helped close our biggest enterprise project for the most important insurance company in Spain, a 3 million € project plus yearly maintenance contract, by doing the presales for the project. I developed a prototype system showing functionality key to the business, and presented it to stake holders. The system (Claims) is now deployed to 4 business units, servicing a total of 4000+ users (internal & external). I also designed and developed the core system modules, and was directly responsible for integrating it with several core legacy systems, developing a real-time integration middle tier managing a total of 60000+ messages per day.
• Reduced our integration development efforts by a factor of 75% (approximately 11 hours per integration point) by the development of an integration tool for SOA systems. This resulted in considerable reduction in costs and development time and an improvement in the quality of the delivered product. This tool also allows us to write a typical CRUD integrations in a matter of minutes. The tool has been deployed in several CRM projects to integrate the CRM with other SOA systems. For our last project, the estimated time to integrate 23 web services was 350 hours, and with this tool the integration was developed in approximately 100 hours.
• Improvement of the SLA (Service Level Agreement) by reducing the average resolution time of platform incidents to 80% (from 1+ hours to a few minutes), and positively changing the perception of system stability by the development of an Application Performance Manager (APM) tool for the CRM platform. The tool monitors the system for any possible incident (e.g. baseline threshold reached) notifying support reps and allowing administrators to solve the incident even before it was noticed by end users.
• Reduced the “warranty time” (non-billed time spent fixing issues covered by our warranty) of CRM projects developed by our Professional Services unit by 35% (a total of 150 hours per month) by the implementation of an internal Application Lifecycle Management (ALM) process, using standard software engineering practices (software metrics, continuous integration, automated tools, testing, etc.), applied to the stages of development, testing, deployment and support. Also, reduced deployments attempts by 50%, going from an average of 3 deployments per environment per month to an average of 1.5.
• Helped diversify the Professional Services offering and increase 5% (120K € per year) the forecasted business revenue by leading the Professional Services unit in charge of the Salesforce CRM projects. I was responsible for learning the Force.com platform and to prepare our internal personnel (technical, business and sales roles) to embrace the new technology. I got certified as Salesforce Administrator, Developer and Advanced Developer in just 4 months’ time, becoming an expert in Force.com cloud development.

Solutions Architect specializing system architecture, design, integrations and development, using platforms such as Microsoft .Net and Pivotal CRM.

Responsibilities

• Design, architect and develop solutions to integrate CRM/ERP/Legacy heterogeneous systems using a broad range of technologies (middleware, ETLs, custom development, etc.)
• Account manager for strategic Customers located offshore (USA)
• Assist support agents in troubleshooting and solving complex and hard business scenarios

Solutions Architect specializing system architecture, design, integrations and development, using the Salesforce and Force.com platforms, and Microsoft .Net. Worked on more than 30 successful projects for VIP customers in various industries.

Responsibilities

• Attend and conduct BPR (Business Process Review) meetings with C-Level stakeholders.
• Translate high-level business requirements to technical requirements
• Evaluate and design the architecture for the solution
• Present and demo solutions prototypes and develop proof of concepts
• Design, architect and develop integrations solutions between heterogenous systems using a broad range of technologies (middleware, ETLs, custom development, etc.)
• In the case of big projects, work as a Developer Team Leader to coordinate the team members

Software Architect for different enterprise projects in the areas of Insurance, Banking, eCommerce, Manufacturing, etc. Performing different roles such as Business Analyst, Lead Developer, DevOps, IT and Support Manager. Managing teams of up to 8 persons.

Responsibilities

• Design and decide on the system architecture and implementation of technology for existing and new projects
• Design and architect solutions to integrate CRM/ERP/Legacy heterogeneous systems using a broad range of technologies (middleware, ETLs, custom development, etc.)
• Risk management of the technical aspects of the solutions especially on early stages of a project
• Presales activities including development of demos, prototypes and proof of concepts, and presentation to high level executives
• Selling of consulting engagements including estimation, scoping and statement of work to set expectations and limit risks
• Implementation of development techniques and best practices in software architecture and development
• Development and maintenance of integration solutions for the Client’s Legacy systems
• Evaluation, implementation and adaptation of new technologies in the field in order to drive the internal development standards for the company
• Responsible for the technical Service Level Agreement for systems that are in production
• Regional Manager for the Consulting department between 2005-2007

Application developer for various departments in MSU, using Java EE programming technology. Teaching assistant for the Laboratory of Computer Science III (3 lab sections).

Responsibilities. Development of the following systems/applications:

• Web Conference Management System.
• Visual Query Engine for tree structures.
• Object-Oriented extension to XML (XML++).
• Different web crawlers and ontology creation tool for eCommerce web sites.
• News Management System for the Poultry Science department.
• Library Information System for the English department.
• Data Warehouse View Materialization system.
• Web Survey System for the department of Electrical & Computer Engineering.

Leader developer in charge of the pre-sale, deployment, administration, customization and post-sale support for the Customer Relationship Management (CRM) software PIVOTAL Relationship and related technologies including MS SQL Server, MS Exchange Server, etc.

Responsibilities

• Development of CRM systems for the three most important companies in the area of Insurance, Telecommunications and Banking in Venezuela.
• Development of the localized version of the CRM software for Latin-American markets.

Responsibilities

• Responsible for the internal Software & Hardware infrastructure. Administration, configuration and support of the internal network, database, and messaging infrastructure
• Implementation of the Data Warehouse system for the billing and order processing system, providing a centralized view of the overall business to the company
• Configuration of the internal Intranet
• Transformation of the hard-to-use legacy system front ends to easy to use web oriented applications
• Configuration and administration of the first modern database infrastructure for the Caracas branch

Project participation:

• I have worked in a project to integrate Salesforce with Microsoft Azure using Azure functions written in .Net. Experience with Salesforce APEX call outs and Azure Functions. My role in this project was as a software architects
• I have worked in a project to migrate data from Dynamics CRM to Salesforce. Experience with low level Salesforce object data structures. Experience with Salesforce Data Loader, Bulk API and SOAP. My role in this project was as a software architect.
• I have worked in a project for a bidirectional integration between Salesforce and a Legacy (on-premise) system. Experience developing triggers, APEX classes to do callout using HTTP and consuming SOAP and REST web services. Experience creating custom applications to expose REST and SOAP services in Salesforce. This project allowed me to gain great experience with Salesforce integration techniques. My role in this project was as a software architect.
• I have worked in a project to create a Salesforce application for the AppExchange. This application is for the area of Insurance. This project allowed me to master different aspects of APEX and Visualforce programming. My role in this project required both functional and technical skills.
• I have worked as a presales engineer for different projects. I was responsible for gathering the initial requirements and then create prototypes which I had to demo to high level stake holders, including technical and non-technical people.
• More than 10 years working in various successful implementations of complex CRM systems for enterprise clients in different industry areas. During this time I have played different roles, excelling as a Software Architect and Lead Developer.

Technical Knowledge

• Knowledge of APEX development (advanced)
• Knowledge of Visualforce development (advanced)
• Knowledge of Lightning Development
• Knowledge of integration capabilities exposing and consuming SOAP/REST services. Knowledge of OAuth authentication mechanisms (advanced)
• Knowledge of advanced development techniques including APEX metadata (advanced)
• Experience working with web development using HTML, CSS and Javascript (advanced). Knowledge of Salesforce Javascript remoting
• Experience working with Salesforce best practices for performance and optimization. Knowledge of the various governor limits and its way around them
• Knowledge of design and development for Salesforce1 applications

Client: Telecommunications Company

Project Description: Implement the CRM system in Salesforce for sales force automation (creation of opportunities, quotes and forecasts) and integration with ERP. Total project time: 2 weeks.

Roles for the project:

• Technical Project Leader
• Development Leader

Activities performed and technologies used

• Customization of Salesforce CRM to adapt to business requirements
• Develop the integration layer to integrate the CRM with the ERP, creation of triggers and custom classes and pages, using Force.com APEX and Visualforce
• Develop a web service layer to synchronize the ERP and the CRM, using Microsoft .Net WCF, Microsoft Entity Framework, Microsoft SQL Server

Client: Consulting Company

Project Description: Development of integration solutions for the Pivotal CRM Platform that allow the integration of the CRM with heterogeneous data sources such as SOAP, REST and ADO.Net. Development of monitoring solutions for IT departments that need to administer Pivotal CRM systems. Total project time: 6 months.

Roles for the project:

• Technical Project Leader, directing a total 1 resource for IT
• Development Leader, directing a total of 1 developer

Activities performed and technologies used

• Develop a system to integrate Pivotal CRM with heterogeneous data sources (DBConnection ):
  • Systems with SOA endpoints based on SOAP
  • Systems with a ADO.Net access point (OLEDB, ODBC, .Net)
  • Systems with a REST endpoint
• Develop a system to synchronize database data for SQLServer and Oracle databases
• Create a Monitoring Tool to proactively monitor Pivotal CRM systems (MonitoringIT )
• Develop a tool to integrate Pivotal CRM systems with Windows Active Directory (Pivotal AD Sync )

Client: Insurance Company

Project Description: Development and implementation of a Claim Management System for the Business and Contact Center areas. Integrate disparate/heterogeneous Legacy systems and provide unified profiles for clients (contact and companies), policies/risks, claims, incidences, among others. Creation of claims and incidences reported by clients and communication to legacy systems. Project developed using Pivotal CRM Platform . Total project time: 2 years.

Roles for the project:

• Technical Project Leader, directing a total 2 resources for IT
• Development Leader, directing a total of 6 developers

Activities performed and technologies used

• Design and implement the technical infrastructure for the project. A total of 6 environments (development, integration, tests, training, preproduction and production) and more than 25 application servers based in Microsoft Windows Server 2003 and 5 Oracle 11g R2 databases.
• Installation and administration of Microsoft Internet Information Services (used by the application layer) and Microsoft SharePoint Server (used by the application portals)
• Design the load balancing strategy using both hardware load balancing based on Cisco F5 and Microsoft Network Load Balancing.
• Provide a Source Control System for development based on Microsoft Team Foundation Server 2010. Provide best practices (branching, versioning, continuous integration, etc.) for the development team.
• Design the deployment path to go from development to production. Development of an internal tool called Scripter to automate the deployments. This tool was developed in Microsoft Visual Studio 2008 using C# (.Net 3.5), ADO.Net and XML.
• Coordinate the deployment of the application to client machines using installation packages to be deployed using Microsoft System Center.
• Coordinate the health monitoring of the system using Microsoft System Center Operation Manager
• Design and test the fail-over and disaster recovery solutions for the system
• Design and implement the whole security infrastructure for the project based in SSL certificates using Microsoft Certificate Services.
• Provide Advanced Technical Training to the Client’s IT department

Client: Insurance Company

Project Description: Design a performance test plan stress test the Claims Management System. Create a tool to automate stress tests and tests cases simulating virtual users .Total project time: 4 months.

Roles for the project:

• Development Leader, directing a total of 1 developer

Activities performed and technologies used

• Design and implement a Performance Test Plan that would need to be executed on each phase of the project. The plan had to guarantee that application performance conforms to the established baseline
• Execute the plan on different environments (integration, preproduction, production) and different locations including California, Arizona and Massachusetts.
• A tool called Pivotal Performance Simulator (PPS) was developed to simulate load and test the performance of the application. The tool was developed using Microsoft Visual Studio 2008 using C# (.Net 3.5)
• Communication with the application server is done using a SOA architecture based on services published via HTTP based on a native XML protocol
• The application simulates virtual uses making requests to the application. The tool leverages .Net to manipulate and spawn multiple threads.
• The tool uses Microsoft SQL Server to store results of all the tests. Tests results are then processed using Microsoft Integration Services and presented in Excel Pivot Tables driven by Microsoft Analysis Services

Client: Insurance Company

Project Description: Development and implementation of a Billing system for that consolidates all the concepts related with the emission of new insurance policies. The system consolidates and creates bills for more than 200.000 concepts monthly. Total project time: 1 year.

Roles for the project:

• Technical Project Leader, directing a total 1 resource for IT
• Development Leader, directing a total of 3 developers

Activities performed and technologies used (similar to the Claims system. Only different activities are listed)

• Development of the main modules of the application using .Net C# with Microsoft Visual Studio 2008 on the Pivotal CRM platform.
• Create installation packages based on ActiveX components for Microsoft Internet Explorer.
• Plan remote access to the application using Microsoft Terminal Services and Citrix Servers
• Integrate the Billing system with the ERP and SAP using a middle tier. A middle tier was designed to orchestrate the integration between Pivotal CRM and ERP/SAP using different strategies based on Microsoft MSMQ, XML Services, and ADO.Net.

Client: Different Clients in Venezuela, Colombia, USA and Spain

Roles for the project:

• Development Leader
• Technical IT Leader

Activities performed and technologies used

• Development of a System Monitoring application for the Pivotal infrastructure, using Microsoft SQL Server, XML and XSL and using SOA architecture. Currently being migrated to Microsoft Communication Foundation (WCF) and Microsoft Presentation Foundation (WPF).
• Design of a development methodology for Pivotal CRM projects based on Visual Studio Extensibility points (Templates, Wizards, etc.) Pivotal Templates for Visual Studio
• Development of a CTI integration solution based on TAPI using Microsoft Visual C++ 6.0

Features

• Shows Apex code coverage using an intuitive bar charts with percentages
• Shows the code coverage for a class in the IDE status bar
• Shows which test classes contribute to the coverage of a specific class

Features

• Register the good deeds accomplished by each kid, and see how they accumulate points. Each kid has its own balance of points
• Once a kid has accumulated enough balance, reward him/her with a wish, exchanging points
• You can use the already predefined deeds and wishes, our you can easily create and customize new deeds and wishes to better adapt to your specific needs

Features

• Register all your cloud storages in Cumulo. Registration is easy, all you need is activate the cloud storage with your account and Cumulo takes care of the rest
• Cumulo will present a unified view, identifying files and folder with an icon describing the cloud where the file is stored. If a folder is present in all your clouds, you only see one instance
• Cumulo allows you to search for files across all your registered cloud storage services. No need to do separate searches on each cloud

Features

• Connects with the Outlook session automatically
• Customizable panels: you can select which panels (Emails, Tasks, Calendar) to show
• Customizable UI: you can select font, color and size to display the items in your desktop
• Totally transparent

Features

• Creates automatic metadata constants based on the BM
• Takes care of the boilerplate code for server and client tasks
• Presents a simplified metadata model
• Includes improvements for code analysis and code metrics

Salesforce Certifications

• Salesforce Certified Business Analyst.
• Salesforce Certified B2C Solution Architect.
• Salesforce Certified B2B Solution Architect.
• Salesforce Certified Marketing Cloud Email Specialist.
• Salesforce Certified Heroku Architect.
• Salesforce Certified JavaScript Developer I.
• Salesforce Certified Community Cloud Consultant.
• Salesforce Certified Service Cloud Consultant.
• Salesforce Certified Sales Cloud Consultant.
• Salesforce Certified Application Architect.
• Salesforce Certified Sharing & Visibility Designer.
• Salesforce Certified Advanced Administrator.
• Salesforce Certified Data Architecture & Management Desginer.
• Salesforce Certified System Architect.
• Salesforce Certified Identity & Access Management Designer.
• Salesforce Certified Development Lifecycle & Deployment Designer.
• Salesforce Certified Integration Architecture Designer.
• Salesforce Certified App Builder.
• Salesforce Certified Platform Developer I.
• Salesforce Certified Platform Developer II.
• Salesforce Certified Administrator.
• Salesforce Certified Advanced Developer.
• Salesforce Certified Developer.

Microsoft Certifications

• Microsoft Certified Professional Developer (MCPD)
• Microsoft Certified System Engineer (MCSE)
• Microsoft Certified Database Administrator (MCDBA)
• Microsoft Certified Professional + Internet (MCP+I)

Pivotal CRM Certifications

• PIVOTAL Relationship Customization Master
• PIVOTAL Relationship Administrator

Mississippi State University – Starkville MS, USA December, 2002. GPA: 4.0/4.0

Simón Bolivar University – Caracas, Venezuela November, 1997. GPA: 4.26/5.0. Rank: 3rd.

• Programming Languages: .Net Languages and Framework (C#, VB.Net) Apex C/C++ Visual Basic Java Perl
• Web: HTML/DHTML JavaScript XML/XSL CSS VBScript Knockout Angular
• Mobile/Device Development: Windows RT/Windows Phone (C#, XAML) Xamarin iOS (Objective-C)
• Databases: Microsoft SQL Server Admin and Development (MS Transact-SQL) Micrsoft SSIS BI (Analysis Service) Reporting Services Oracle Administration and Development (Oracle PL/SQL)
• OS Administration: Administration of Windows family of Servers (2003, 2008, 2012)
• Cloud: Microsoft Azure Force.com
• CRM: Salesforce Pivotal CRM
• Methodologies: Agile SCRUM Waterfall
• Other: Presentation and demonstration skills Public speaking Customer service and relationship

• Spanish (native)
• English (high)
• Italian (native)
• French (intermediate)

Abstract: If your Salesforce implementation has to deal with millions of records, there’s a big chance you will end up considering Heroku and Salesforce Connect to offload some data. These technologies are great, but they come up with some considerations. In this session I will talk about the lessons I learned from a successful Salesforce-Heroku implementation. I will explain what those considerations are and how to overcome them, and mention some tips and tricks that will help you build great solutions. If your next project involves Heroku, you better know this stuff

Abstract: If your Salesforce implementation has to deal with millions of records, there’s a big chance you will end up considering Heroku and Salesforce Connect to offload some data. These technologies are great, but they come up with some considerations. In this session I will talk about the lessons I learned from a successful Salesforce-Heroku implementation. I will explain what those considerations are and how to overcome them, and mention some tips and tricks that will help you build great solutions. If your next project involves Heroku, you better know this stuff

• Microsoft Virtual Academy profile. Download MVA Transcript
• Code School report card
• Salesforce Trailhead Profile

• Scrum Development Professional. 20 hours. December 2014. Madrid, Spain.
• Team Work. 7 hours. April 2008. Madrid, Spain.
• Advanced Negotiation Techniques. 16 hours. July 2008. Madrid, Spain.

Blog

• Articles on Salesforce Development & Integration.
• Articles on Cross Platform Development.
• Articles on Pivotal CRM Development.

Journals

• Avigdor Gal, Giovanni A. Modica, Hasan M. Jamil, Ami Eyal. Automatic Ontology Matching Using Application Semantics. AI Magazine 26(1): 21-32. November, 2005.

Conferences

• Avigdor Gal, Giovanni A. Modica, Hasan M. Jamil. OntoBuilder: Fully Automatic Extraction and Consolidation of Ontologies from Web Sources. In Proceedings of the 20th International Conference on Data Engineering (ICDE 2004). April, 2004. Boston, USA.
• Giovanni A. Modica, and Hasan M. Jamil. Enhancing Reuse Via Inheritance using XML. Poster presentation in the 11th ACM International World Wide Web Conference (WWW2002). May, 2002. Honolulu, Hawaii.
• Giovanni A. Modica, and Hasan M. Jamil. An Object-Oriented Extension of XML for Autonomous Web Applications. In Proceedings of the 11th International Conference on Information and Knowledge Management (CIKM 2002). November, 2002. Virginia, USA.
• Giovanni A. Modica, and Hasan M. Jamil. Laveraging Dynamic Inheritance in Complex Ontology Representation. Poster presentation in the Proceedings of the 10th International Conference on Cooperative Information Systems (CoopIS 2002). November, 2002. California, USA.
• Giovanni A. Modica, Hasan M. Jamil, and Maria A. Teran. Querying Phylogenies Visually. In Proceedings of the Second IEEE International Symposium on Bioinformatics and Bioengineering (BIBE 2001). November, 2001, Bethesda, USA.
• Giovanni A. Modica, Hasan M. Jamil, and Maria A. Teran. Towards a Visual Query Interface for Phylogenetic Databases on the Web. In Proceedings of the 10th International Conference on Information and Knowledge Management (CIKM 2001). November, 2001. Atlanta, USA.
• Giovanni A. Modica, Avigdor Gal, and Hasan M. Jamil. The Use of Machine-Generated Ontologies in Dynamic Information Seeking. In Proceedings of the 9th International Conference on Cooperative Information Systems (CoopIS 2001). September, 2001. Trento, Italy.
• Giovanni A. Modica, and Hasan M. Jamil. A View Selection Tool for Multidimensional Databases. In Proceedings of the 14th International Conference on Industrial and & Engineering Applications of Artificial Intelligence and Expert Systems (IEA/AIE 2001). June, 2001. Budapest, Hungary.

• Nominated Microsoft Active Professional 2014. April 2014. Madrid, Spain.
• Winner of the 1st place in the Windows 8 Megathon in Madrid with Cumulo. September 2012. Madrid, Spain.
• Nominated as Mississippi State Research Assistant of the Year 2001-2002 by the Computer Science Department. April 2002. Mississippi State, USA.
• Winner of the 2001 Tri-State Student Paper Contest. Giovanni Modica. An Incremental Algorithm for Attribute Clustering in Cooperative Databases. June, 2001. Destin, USA.

Upsilon Pi Epsilon – USA 2001.

PADI Certified Open Water Diver – Spain 2009.

I love my family and I like my time with them. On my personal time I like to do different activities such as practicing sports (running, swimming, soccer, etc.), watching movies, reading books, learning, and hanging out with friends. I like challenges, puzzles and difficult things. I enjoy good food, especially to try out new stuff.