Pedro Lima Email & Phone Number

Arvada, CO, US

• Oversees project direction for the data and analytics team.
• Conducts resource review and allocations, performs analyses of approaches to meet different departmental data and analysis needs.
• Oversees the design and delivery of reports and insights that analyze business functions and key operations and performance metrics.
• Manages and optimizes processes for data intake, validation, mining and engineering as well as modeling, visualization and communication deliverables.
• Examines, interprets and reports results of analytical initiatives to partner across all city departments.
• Oversees the data/report requests process: tracking requests submitted, prioritization, approval, and outcome.

Arvada, CO, US

• Lead efforts within the city to identify potential for analytics and Business intelligence applications
• Work with the business partners to identify data needs, including integrations and visualizations
• Manage priorities, resources and timelines for implementation of data artifacts
• Design, develop and deploy data solutions across the organization

Brighton, CO, US

• Interact with customers to understand and refine Business Processes
• Define Architecture and Infrastructure for Applications to fulfill customer requirements
• Develop applications, reports and data processes
• Technologies include C#, SQL Server, SSIS, Oracle, goAnywhere, Azure DevOps

Denver, CO, US

• Study and Refine data structures
• Design data model and ETL Processes to create Reporting database instances
• Create data extracts and SSRS Reports
• SQL Server and MS BI Stack

Denver, CO, US

• Perform ETL on large sets of data
• Design data processes to create meaningful data models for analysis
• Analyze data models to create extracts for analytic modelling and design BI reports
• MS BI Stack, including MS SQL Server, SSIS, SSRS, SSAS, BIDS, Microsoft Excel. BIRST as a BI Tool

Pittsburgh, PA, US

Integrate with Business teams to create reports, ETL processes and Database mechanisms for several Enterprise applications.Develop, test and deploy SSRS Reports and SSIS Packages for several Applications and business needs.Develop, test and deploy Salesforce reports.Utilize the Microsoft BI Stack, including Microsoft SQL Server, SSIS, SSRS, BIDS, Microsoft.

Broomfield, Colorado, US

Work with the Business team to develop and create business metrics and reports for the Company’s Change Management department, Latin America and UK Business unitsDevelop reports and pivots based on metricsProvide information support for Change Management, Latin America and UKUtilize the Microsoft BI Stack, including Microsoft SQL Server, SSIS, SSRS, SSAS.

Indianapolis, IN, US

Develop, Design, Deploy and Migrate Patch Management applications for Nonstop EnvironmentsDocument Infrastructure and Functional requirements for Patch Management applicationsCreate and execute test casesProvide application support for Enterprise Patch management tools.Utilize ASP (Classic and.Net), Visual Basic (6.0 and.Net), Java, Struts, JSP and.

Jaguariuna, SP, BR

System Analysis using Visual Basic, Access/VBA and SQL Server for CIC, a Greeley, CO based IT Company.

Brasília, DF, BR

Duties include System administration and Support for BrasilTelecom, one of Brazil’s largest telecommunication companies, using Visual Basic, VBA, Oracle and PL/SQL and modeling languages and technologies.System Analysis and Development for the Brazilian National Healthcare Agency, using Visual Basic, ASP, Oracle and UML.Understanding and documenting.

Jaguariuna, SP, BR

Duties include developing application to generate outgoing and process incoming Batch files related to banking Computer System, using Microsoft Visual Basic 6.0, COM+, Java (Swing) and Microsoft SQL Server 2000. Create reports on analytical data to support business decision making processes

Curitiba, Paraná, BR

Developed and Analyzed Information Systems for the National Health Foundation (FUNASA)Create data reports, perform data mining on large database to support National Health ServicesUsing Visual Basic 6.0, VBA, ASP, AJAX, JavaScript and Oracle 10g Databases, Microsoft SQL Server 2005, VB.Net and C#.

Sao Paulo, SP, BR

Developed System for the Brazilian National Telecommunication Agency (ANATEL)Documented and developed from Business Use CasesUsing Visual Basic, COM+, ASP, AJAX, JavaScript, Microsoft SQL Server 2000 and RUP/UML

Paris, Ile De France, FR

Planned, developed and analyzed an Information System for the Library and Publications department of UNESCOUsing ASP, VBA, AJAX, JavaScript, Oracle and Microsoft SQL Server 2000.

System and Component Development for the Brazilian Association of State Banks (ASBACE), Using Image and Document Processing, using Microsoft Visual Basic 6.0, COM+, Crystal Reports and Microsoft SQL Server 2000

Development of Brazilian Political Information PortalMaintained and supported Client-Server Political Information System Technology: Visual Basic, VBA, ASP, JavaScript and Microsoft SQL Server 7.0 and 2000, Delphi 3.0 and 5.0.

Brasília, DF, BR

Developed and maintained General System Technology: Microsoft Visual Basic 4.0 and 6.0, VBA, Crystal Reports and Microsoft SQL Server 6.5

Developed Client-Server System and Applications and Internet ApplicationsTechnology: Delphi, Microsoft SQL Server 6.5 and 7.0, Oracle 7 and 8, ASP and Microsoft SQL Server 6.5 and 7.0