Work Experience

  • Connected - Consultant
    January 2020 - June 2020

    Worked on an audio devices management (speakers, headphones, soundbars) and audio streaming app (Spotify, SiriusXM, TuneIn) for an USA client

  • Worked on their core mobile banking application.

    Implemented a chat like feature.

    Carry out requirements reviews, design reviews and code reviews.

    Refactored some functionalities through the application.

  • Ensure proper architectural principals, coding standards, code builds and continuous integration process are followed.

    Ensure defect free programming by testing and debugging using available/appropriate tools.

    Carry out requirements reviews, design reviews and code reviews.

    Mentor team members to improve their technical skills and application knowledge.

    Identify and communicate technical issues and risks to the project manager and work with developerse

  • Architect scalable iOS health care application

    Collect, organize, and analyze data to summarize findings and develop conclusions and recommendations

    Optimize access to local data

    Build application from scratch

    Lead small team of developers

    Perform code analysis, unit testing, code optimization and integrate any code changes

  • Develop Retail iPad application

    Perform code analysis, unit testing, code optimization and integrate any code changes

    Troubleshoot and debug software to determine the cause of errors and action plans to address them

    Conduct research and do proof of concepts

    Analyze and identify system issues and recommend system enhancements or fixes

    Manage and participate in the life cycle of our product system releases and system enhancements

    Participate in new feature requirement discussions and requirement creation

  • Created iPad version of iPhone application

    Executed re-branding of existing apps for future releases

    Refactored some elements of current iPhone application

  • Customized a couple of iPad applications to use different languages and configurations (Ford’s sales assistant iPad application and Honda’s training iPad app)

    Created generic app to received notifications using Xtify

  • Troubleshooting of SOCAN's iOS application.

    Performed analysis of business requirements for new or existing reports (MicroStrategy, Crystal Reports, Oracle Discoverer)

    Investigated and resolved data quality issues and enhancement - periodically reconcile data to ensure accuracy and integrity in data warehouse

    Gathered, analyzed and documented requirements

    Prepare functional and technical documentation for Data Warehouse and Operational Data Store

    Documented, developed, coded, tested, debugged and implemented new software or enhancements to an in-house application

    Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing

    Assisted with user acceptance testing to resolve development issues resulting from the testing

    Design and implement Operational Data Store database structures

    Develop Data Warehouse and Operational Data Store process models, including sourcing, loading, transformation, and extraction

  • Ispire Technology
    Aug 2010 - Feb 2011

    Maintenance of Wellness Java Web Application

    Developed a timer control tickets module for Ispire in Visual Studio 2010 - SQL Server 2008 (stored procedures, functions, queries)

    Management and development of reports in SQL Reporting Services

    Maintenance of Manufacturing application in Visual Studio 2003

  • Analyzed, designed and implemented new features for Pension Plan Management System (PENSION 2000) in a highly dynamic environment

    Gathered, analyzed and documented business requirements for new functionalities, interfaces, and reports

    Programmed, tested and deployed of the solution

    Performed maintenance programming and correction of identified defects

    Modified existing database according with the business needs

    Designed database packages, procedures and functions

    Performance optimization of dynamic SQL, stored procedures, functions and triggers

    Wrote/tuned data ingestion procedures from external sources using PL/SQL, SQL Loader, Toad Import/Export

  • Analyzed, designed and implemented new features. Developed new enhancements and modifications to the following systems: Total Production Management, Finance/Accounting, Human Resources and Supply Chain Management

    Analyzed, reviewed, and developed programming modifications to adapt to new requirements

    Developed physical data models and database designs

    Modified existing databases, as user needs changed

    Modified applications to correct errors

    Reviewed and tuned SQL and PL/SQL code

    Reviewed, evaluated, designed, implemented and maintained reports

    Provided technical support to applications

  • Developed new enhancements and modifications to Total Production Management System (TPM). These features were requested by several clients that had bought TPM

    Customer support

  • Worked in a pilot project, as part of a team, analyzed, designed and implemented a new system: “Chip Debit Card”, integrated with an outsourced system

    Analyzed, designed and developed new enhancements and modifications to the Debit Accounts Management System

    Customer support and fixing bugs in the systems

© 2016 Zianny Galeano - All Rights Reserved