Pedro F.

Data Analyst

Programmer Analyst
8/2/2008 - Present

Gained expertise in data collection and analysis, mastering database modeling techniques for efficient data storage and retrieval. Leveraged advanced VBA programming to automate workflows and enhance productivity. Excelled in developing sophisticated Excel spreadsheets for data manipulation, reporting, and visualization.

Programmer
2/2/2008 - 6/2/2008

Developed proficiency in Visual Basic 6.0, focusing on the creation and enhancement of an Icon System. Leveraged extensive knowledge in VBA for automation and application macros. Gained expertise in designing and implementing GUI components, ensuring intuitive and user-friendly interfaces. Utilized array and string manipulation techniques to manage and streamline large datasets effectively. Employed COM components to facilitate seamless application integration and communication. Achieved significant performance optimizations through debugging and code refactoring. Demonstrated proficiency in version control tools including SVN and Git for managing code repositories collaboratively. Familiarity with Microsoft Access and SQL Server for backend database management and query optimization. Applied problem-solving skills to troubleshoot and resolve system bugs, ensuring stable and efficient operations.

Analyst Programmer
1/2/2005 - 6/2/2005

Developed expertise in requirements gathering, facilitating in-depth understanding of project needs and translating them into actionable objectives. Mastered screen prototyping to visually convey project concepts and interface designs, ensuring stakeholder alignment and user-friendly solutions. Demonstrated proficiency in proposing comprehensive solutions that align with business objectives and technical constraints. Acquired advanced skills in database modeling, enabling the design and implementation of efficient, scalable database architectures. Utilized UML modeling to create detailed, standardized visualizations of system designs, promoting clear communication and collaboration among development teams.

Analyst Programmer
1/2/2004 - 1/2/2005

Developed proficiency in data modeling and UML modeling, facilitating the creation of clear and comprehensive system designs. Applied advanced skills in requirements analysis to translate business needs into technical specifications, ensuring alignment with project goals and stakeholder expectations.

Project Development Coordinator
7/2/2002 - 10/2/2002

Developed proficiency in planning and specifying development work, ensuring clear guidelines and objectives for project execution. Monitored the execution of development tasks to maintain timeline adherence and resource allocation. Organized and facilitated regular meetings to report on the overall progress of development work, ensuring transparent communication and alignment with project stakeholders.

Analyst Programmer
1/2/2002 - 7/2/2002

Developed proficiency in database modeling, with a focus on designing and maintaining complex relational database systems. Gained extensive experience in programming using Visual Basic to create robust and efficient applications. Demonstrated technical expertise in data normalization, indexing, and optimizing SQL queries for improved database performance. Utilized tools and frameworks such as Microsoft SQL Server Management Studio (SSMS) and Visual Studio to streamline the development and deployment processes. Contributed to projects that required seamless integration of database systems with various applications, ensuring data integrity and security. Showcased collaborative skills in a team environment to deliver high-quality software solutions on time and within budget.

Analyst Programmer
3/2/2001 - 8/2/2001

Developed proficiency in data modeling techniques, specifically using UML (Unified Modeling Language) to create comprehensive and clear representations of data structures. This involved the design and optimization of databases by diagramming relationships and entities to ensure efficient data management and retrieval. Utilized tools such as ER/Studio, PowerDesigner, and Microsoft Visio to construct detailed visual models supporting various projects. Showcased strong analytical thinking and problem-solving skills by translating complex business requirements into accurate and actionable data models. Collaborated effectively with cross-functional teams to ensure alignment and understanding of data architecture, fostering better communication and project outcomes.

Analyst Programmer
1/2/2000 - 11/2/2000

Developed proficiency in Visual Basic programming, focusing on creating and optimizing stored procedures to enhance database performance. Demonstrated expertise in UML modeling, facilitating clear and effective communication of system designs and processes. Excelled in database modeling, ensuring robust and scalable database architectures. Mastered data flow, systems, and process modeling, contributing to efficient system workflows and streamlined operations.

Analyst Programmer
9/2/1998 - 8/2/1999

Achieved proficiency in Visual Basic programming, with extensive experience in designing and implementing robust software solutions. Developed and optimized stored procedures to enhance database performance and integrity. Demonstrated advanced skills in creating efficient and clean code, leveraging Visual Basic's capabilities for automation and user interface development. Utilized SQL Server to manage and manipulate database systems, employing stored procedure programming for complex data retrieval and processing tasks. Applied meticulous debugging and problem-solving techniques to ensure seamless operations and system reliability. Ensured code versioning and collaborative teamwork through the proficient use of Git.

Analyst Programmer
5/2/1998 - 9/2/1998

Developed proficiency in Visual Basic, focusing on creating efficient and user-friendly software applications. Gained extensive experience in using Visual Studio for development tasks, implementing SQL Server for robust relational database management, and leveraging Microsoft Access for database creation and manipulation. Demonstrated expertise in designing and developing complex forms, reports, and queries. Utilized source control tools such as TFS and Git to ensure smooth and collaborative code maintenance. Established best practices for debugging and optimization to enhance application performance and maintainability. Delivered projects on time and adhered to critical deadlines, while continuously updating skills to keep pace with new developments in technology and tools.

Analyst Programmer
10/2/1997 - 11/2/1997

Gained extensive experience in developing and maintaining enterprise-level COBOL applications. Acquired in-depth knowledge of key COBOL programming concepts and applied them in creating efficient and reliable code. Mastered the use of JCL (Job Control Language) for managing and automating mainframe batch jobs. Worked extensively with CICS (Customer Information Control System) for online transaction processing, ensuring seamless interaction between users and mainframe systems. Demonstrated strong skills in using VSAM (Virtual Storage Access Method) for managing and accessing data files.

Developed expertise in debugging and optimizing COBOL programs to enhance performance and reduce resource consumption. Utilized IBM DB2 for structured database management and demonstrated proficiency in writing complex SQL queries to interact with the database. Managed and deployed code changes using version control systems like CA Endevor. Conducted thorough unit testing and system integration testing to ensure the integrity and reliability of the applications.

Collaborated with cross-functional teams to analyze business requirements and translate them into technical specifications. Employed Agile and Waterfall methodologies in project management to meet development deadlines and deliver robust software solutions. Enhanced legacy systems by implementing new features and ensuring compliance with industry standards and regulations.

Analyst Programmer
10/2/1997 - 11/2/1997

Developed proficiency in Visual Basic programming, focusing on creating and maintaining applications to streamline business operations. Gained extensive experience working with VBScript, enhancing functionality in existing systems and developing new features. Demonstrated skills in integrating Visual Basic applications with Microsoft Access and SQL Server databases, ensuring robust data management and seamless user experiences. Utilized tools such as Microsoft Visual Studio to manage and debug code efficiently. Worked collaboratively on version control using TFS (Team Foundation Server) to ensure synchronized development and deployment processes. Acquired an in-depth understanding of object-oriented programming principles and implemented them to write optimized and maintainable code. Developed multiple custom software solutions tailored to meet specific client requirements, significantly improving overall process efficiency.

Analyst Programmer
5/2/1997 - 9/2/1997

Demonstrated expertise in Visual Basic programming, contributing to the development of robust and efficient software solutions. Acquired advanced skills in database modeling, ensuring the creation of well-structured and optimized database schemas. Successfully integrated Visual Basic applications with various database management systems, enhancing data retrieval and processing efficiency. Showcased proficiency in debugging, code optimization, and user interface design within Visual Basic. Utilized best practices in software development to deliver scalable and maintainable code. Engaged in collaborative projects, employing version control systems such as Git to coordinate changes and maintain code integrity.

Programmer
6/2/1995 - 5/2/1997

Excelled in programming using Visual Basic 3.0, developing robust applications with a focus on user interface design and database connectivity. Demonstrated expertise in creating user-friendly forms, handling events, and implementing error handling. Proficient in integrating Visual Basic with databases through ADO and DAO, optimizing data retrieval and manipulation. Developed strong debugging skills using step-through execution, breakpoints, and Immediate Window. Utilized best practices for code modularization and reusability, ensuring maintainable and scalable software solutions.

Data Processing Technology at FATEC - SP
1993 - 1996

Big Data Fundamentals 3.0 at DATA SCIENCE ACADEMY
11/1/2022

Other Courses at LinkedIn, PrimeCursos
10/1/2022

Scrum at Udemy
10/1/2022

POWER BI - From Basic to Advanced at Udemy
10/1/2022

Critical Thinking at Linkedin Learning
10/1/2022

Introduction to Data Science - Telling Stories with Data at Linked Learning
10/1/2022

Introduction to Data Science - Basic Concepts at Linkedin Learning
10/1/2022

Strategic Business Planning at IPED - Instituto Politecnico de Ensino a Distância
6/1/2018

Foundations in ITIL at Boucinhas & Campos Talentos Humanos
4/1/2007

Workshop Empretec at SEBRAE
8/1/2001

Construction of Java Applications at Centro de Computação da Universidade Estadual de Campinas
6/1/2000

Microsoft Windows DNA at Fast Training Centro Educacional
4/1/2000