Leonard Rocha Email and Phone Number

• Technical ownership of Business Intelligence Tool (Qlik Sense)• Data Engineering hands on work with Python and SnowFlake on AWS, using CloudFormation, DynamoDB, Lambda, S3, Glue and Matilion.• Guide on the effective use of SaaS and Cloud services in order to achieve outcomes in alignment with business requirements and the overall Enterprise Architecture. Providing progressive oversight and strategy towards solution architecture, proposing new patterns and assessing vendor capabilities.• Design new platform components using a variety of data and digital technologies and integration mechanisms.• Collaborate with Architects and Developers for successful delivery of capability upgrade programs and individual projects, as well as, ensuring that solution architecture is in alignment with the overall Enterprise Architecture and digital strategy.• Continually expand knowledge over IT systems and processes – share and foster knowledge transfer across business functions and keep abreast of trends in technology and industry – identifying opportunities in relation to technology or industry changes.

• Manage and review relationship with managed services partners, including responsibilities, controls and contract negotiation. Evaluated and vetoed assigned professionals from partner organizations to guarantee required skillset is presents and services delivered from day 1• Manage and deliver product enhancements and improvements promoting platform uplift• Develop and main technical documentation with respect to system design and integration• Plan and execute merge of siloed, on premise BI environment into enterprise cloud platform, while maintaining high level of privacy and implementing integration with enterprise identity provider (OKTA)

• Delivery of proof of concepts, respond to RFQs, pre-sales and client engagements across various BI projects, including travels outside of the state• Responsible for managing a team of consultants and mentoring junior consultants• Thought leadership in enabling innovation, developing standards, frameworks, and best practices• Delivery of complex high profile projects, including an integration of a scalable row-level secured QlikSense report into SalesForce with OKTA as identity provider for internal and external facing customers. From RFQ to execution, project and knowledge transfer was delivered within 12 months, involving Web Development, Managed Services and Business Intelligence teams• Hands on delivery of BI projects in various team compositions and sizes and acting as in different capacities, from Analyst to Project Manager and Technical Leader, in wide range of industries such as Financial Services, Insurance and Retail

• Design, implement and deliver state-wide financial reporting suite for internal and external stakeholders• Maintenance and support of QlikView platform to assure platform stability and meet agreed SLAs• Demonstrations, workshops and users training• Implementation of Qlikview applications integrated with a .NET, adding write back capability to Qlikview• Planning and Execution of automated tests using jMeter

Coordinate the development and the maintenance of an educational system focused in content deliveryDeveloping, documenting, and maintaining a QlikView Applications working with a range of data sources such as Oracle, MySQL, MSSQL and CSV filesDeveloping in SQL Server a data warehouse to maintain and process operational data of +2500 franchisees

Analyse, define, and document business, systems and data requirementsAutomate and speed up the execution of rebate and sales processesMoving manual processes and spread sheets to automated Oracle PL/SQL processing

Worked as a consultant, mostly allocated at the client’s office, covering all phases of the software development lifecycle. Was responsible for delivering a GIS (Geographic Information System) developed in Delphi and Oracle PL/SQL for major energy and utilities companies in Brazil

Worked as a developer, allocated to the University’s ERP development. I was involved in all the software development lifecycle and working mostly in the financial, CRM and projects modules.