Gerardo Zapata

Gerardo Zapata Email and Phone Number

IT Senior Development Analyst @ UL Standards & Engagement
Gerardo Zapata's Location
Mundelein, Illinois, United States, United States
Gerardo Zapata's Contact Details

Gerardo Zapata work email

Gerardo Zapata phone numbers

About Gerardo Zapata

• IT Senior Business Lead with experience in the e-commerce sector and team lead with technical background in the data warehouse area. Currently accountable of leading a marketing campaign content process collaborating in a high-profile e-commerce project involved as a Senior Business Analyst managing Agile related project activities. • Leader in technical projects along with ITIL experience service management in a global, multi-source environment.

Gerardo Zapata's Current Company Details
UL Standards & Engagement

Ul Standards & Engagement

View
IT Senior Development Analyst
Gerardo Zapata Work Experience Details
  • Ul Standards & Engagement
    It Senior Development Analyst
    Ul Standards & Engagement Jul 2023 - Present
    Northbrook, Illinois, Us
    IT Senior Development Analyst supports the analysis, development, modification, testing and maintenance of systems software for UL Standards & Engagement (ULSE). IT Senior Development Analyst supports IT leadership and senior development professionals in the analysis of software and hardware system needs, options, risks, costs, and impact on business process and goals. Evaluates supplied software products and applications. Independently analyzes and isolates application issues and performs problem resolution.
  • Capgemini
    Senior Business Analyst / Lead
    Capgemini Jul 2018 - Jul 2023
    Paris, France, Fr
    • Accountable for delivering the e-commerce marketing campaign with a team of Business Analysts, QA analysts and other stakeholders and interacting with product owners and other third-party teams. • Face to face interaction with the client on a regular basis as the lead, provided regular status and support for the different applications owned.• As a senior Business Technical Analyst, refined technical solutions into EPICs and stories using integrated Agile framework model while working closely with the client product owner to perform strategies, analyze and capture the business requirements into functional requirements.• Collaborated with the technical architect team by grooming user stories for the payments and ordering capability team, discussed EPIC requirements, and provided acceptance criteria in stories based on EPICs.• Participated in the API design for the payment capability team for the global Mobile application delivering EPICS and stories to the development team and created Visio flows to demo functional requirements into stories. • Tracking issues to resolution and providing status to upper management and other stakeholders leveraging tools as JIRA/Confluence, fiddler, JSON, API Postman, Adobe Experience Manager. • Collaborated with architect leads to solution client requirements and facilitated session meetings between different teams to integrate solutions. • Provided solution to enterprise application issues leveraging tools and technologies like Confluence, JIRA, MS Visio, Fiddler, JSON and API postman, Adobe Experience Manager.• Experience handling data setup using AWS tools and manage configurations for the global mobile application for the testing team to be able to deliver their releases on a regular basis. Set up virtual stores using S3 leveraging AWS.• Created the Testing and Validation plan for the QA offshore team to deliver projects and tasks assigned to meet release roadmap setup by stakeholders.
  • Abbvie
    Sr. Systems Analyst/Business Analyst
    Abbvie Apr 2012 - Mar 2018
    North Chicago, Illinois, Us
    •Served as a primary contact throughout the project lifecycle and effectively lead and assisted in the design and implementation of application solutions from Java based, .NET, SaaS salesforce and SharePoint technologies.•As a technical team lead, successfully implemented a new web service feature to a heavily used application, this new interface helped the scientific community to order their chemical needs from one application instead of logging to two different applications. •Provided governance and assumed the technical leadership role and managed a team of onsite and offshore resources while coordinating implementation of projects within the application development team; conversely, communicating progress during the different project lifecycle phases leveraging the waterfall and agile methodologies utilizing tools such as Service Now (ITSM). •Participated in technical architecture, code reviews during the project lifecycle to ensure the company standards, security best practices, release and deployment into production were performed successfully.•Acted as a point of escalation for issues related to Java, .NET and SaaS CRM salesforce solutions, and interacted with third-party vendors to facilitate resolution to application incidents, adhoc requests, and enhancements. •Collaborated in the gathering of business requirements and transformed them into technical specifications by interacting closely with the business users to determine their application business logic requirements, became the bridge between the client and the development team to deliver the required solutions.•Assisted in the creation of functional test cases and ensured the UAT was conducted and validated by engaging the business solution owners, utilized tools such as TOAD and SQL developer to execute SQL queries to retrieve data for modeling and analysis when gathering requirements on a day to day basis.
  • Tcs-Cna
    Sql Developer
    Tcs-Cna Sep 2011 - Dec 2011
    Worked on a project related to surety insurance systems. Gather information from the client about the project's requirements, created the low level detailed design, developed the oracle DML scripts, added additional code required for this project to existing Oracle PL/SQL and Korn shell scripts to include data for new outside clients and developed the code for the conversion of insurance data from one database to another.
  • Walgreens
    Oracle Developer
    Walgreens Jan 2007 - Sep 2011
    Deerfield, Il, Us
    My involvement as a PL/SQL developer was to develop and maintain oracle PL/SQL code for existing PBM applications software.A business analyst would provide me the High level design, I would then develop the Low level design, after that phase, the coding and development would start, the projects basically consisted in created delimited files that contained benefit and pharmacy related data, these files were sent to either inside or outside clients.Shell scripts were developed to call the Oracle PL/SQL stored procedures based on the business requirements. The Korn shell scripting code that was developed contained the declaration of the profile information, declaration of variables needed, calling of oracle stored procedures, removing of old files , file transfer of files produced to other network servers and archiving of files.Once coding was complete and unit testing was performed on the code, prepared documentation for the integration testing by the QA team, I was also responsible to provide the hand-off and deployment documents for the final phase of the project which consisted in the delivery of the code to production.The production support responsibilities included the running of ad-hoc requests by the internal client utilizing a ticket (JIRA) generated system.To deliver certain requests, SQL queries were created and executed to provide pharmacy related reports in either text or excel format files, for some requests, a process needed to be followed, for example, the execution of shell scripts, loading of data into temporary tables and finally execution of existing oracle scripts were performed in order to provide a deliverable to the business.Utilized Oracle ETL utilities such as SQL loader utility to load data from flat delimited files into tables.Exposed to data warehousing activities such as the creation, updating, deleting of tables, indexes, SQL tuning and other database activities.
  • Siebel Analytics
    Developer
    Siebel Analytics Jan 2006 - Aug 2006
    Developed and customized repositories at the 3 Siebel Analytics layers.The reports included charts, pivot tables, data related to manufactured goods.Created the business models using star schemas, developed dimension tables, its hierarchies, and custom aggregation rules.
  • Accenture
    Java Programmer
    Accenture Apr 2005 - Nov 2005
    Dublin 2, Ie
    Gained valuable experience in the development of java applications, HTML development, JSP and servlets.
  • Capgemini
    Pl/Sql Developer
    Capgemini May 2001 - Jan 2005
    Paris, France, Fr
    My primary role on this engagement was to develop and maintain PL/SQL stored procedures in addition with Korn shell scripts based on the clients' requirements. Worked in a team environment to provide solutions to different client requests by developing application software related to the telecommunications field.
  • Capgemini
    Production Support Analyst
    Capgemini Jan 2001 - May 2002
    Paris, France, Fr
    Responsible for maintaining six telecommunication applications in a team environment. These applications were distributed to different oracle databases.
  • Starsight Inc
    Lansa Programmer
    Starsight Inc Jun 1999 - Aug 2000
    Worked as a LANSA programmer developing different applications such as: Accounts Payable/Receivable, General Ledger, Order Entry.

Gerardo Zapata Skills

Oracle Pl/sql Data Warehousing Sql Sdlc Business Analysis Software Development Life Cycle Visio Databases Java Unix Etl Jsp Data Modeling Shell Scripting Sharepoint Sql*plus Unix Shell Scripting Data Migration Toad Java Enterprise Edition Management

Gerardo Zapata Education Details

  • University Of Illinois Springfield
    University Of Illinois Springfield
    General
  • Governors State University,  		University Park Ill
    Governors State University, University Park Ill
    Computer Science
  • South Suburban College
    South Suburban College
    Information Systems
  • Accenture Technology Solutions
    Accenture Technology Solutions

Frequently Asked Questions about Gerardo Zapata

What company does Gerardo Zapata work for?

Gerardo Zapata works for Ul Standards & Engagement

What is Gerardo Zapata's role at the current company?

Gerardo Zapata's current role is IT Senior Development Analyst.

What is Gerardo Zapata's email address?

Gerardo Zapata's email address is te****@****ail.com

What is Gerardo Zapata's direct phone number?

Gerardo Zapata's direct phone number is (847) 932*****

What schools did Gerardo Zapata attend?

Gerardo Zapata attended University Of Illinois Springfield, Governors State University, University Park Ill, South Suburban College, Accenture Technology Solutions.

What skills is Gerardo Zapata known for?

Gerardo Zapata has skills like Oracle, Pl/sql, Data Warehousing, Sql, Sdlc, Business Analysis, Software Development Life Cycle, Visio, Databases, Java, Unix, Etl.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.