Guillermo Arellano

Angular Consultant

Chicago, IL, USA
I am a front-end developer seeking to improve the organization's access to technology and end-user experience through easy-to-use applications that are also fun.

Work Experience

McGraw-Hill

Sr Software Engineer

McGraw Hill is an American learning company and one of the "big three" educational publishers that provides customized educational content, software, and services for pre-K through postgraduate education. The company also provides reference and trade publications for the medical, business, and engineering professions.

Responsibilities:
* Add Accessibility features to the Open Learning Platform to meet US state regulatory requirements.
* Write effective code and review code base for any optimizations or improvements.
* Provide senior level direction for application architecture and development.
* Leverage Angular version 13 and NgRx to develop performant web components and features.
* Ensure code quality via unit testing using Karma and Jasmine.
* Generate confidence by producing stable integration and functional tests using Protractor.
* Create documentation for best practices to help onboard new members.
January 2022 - Present Illinois, United States

The Nomad Programmer LLC

Angular Consultant

The Nomad Programmer is a consulting company that helps developers accelerate their user interface (UI) development efforts on web applications. It teaches design consistency for web application development efforts through reusable web UI libraries and tools. Its specialization is training developers on using the AG Grid data table library in the Angular framework for web application development.

Responsibilities:
● Create AG Grid training content for enterprise developers.
● Generate content marketing with a focus on AG Grid solutions within the Angular framework.
● Help enterprise developers with their AG Grid questions and issues in developer communities.
● Build reusable styles and components to bring up to a 75% reduction in development costs for companies.
● Institute automated tests and processes to set guardrails for project quality and developer productivity.
November 2018 - Present Illinois, United States

CVS Health Corporation

Sr Software Engineer – Angular

CVS Health (previously CVS Corporation and CVS Caremark Corporation) is an American healthcare company that owns CVS Pharmacy, a retail pharmacy chain; CVS Caremark, a pharmacy benefits manager; Aetna, a health insurance provider, among many other brands. The company headquarters is in Woonsocket, Rhode Island.

Responsibilities:
● Build reusable components leveraging Angular version 9.
● Guide team on leveraging NgRx for state management on the front end.
● Enforce product quality by incorporating unit tests using Karma and Jasmine.
● Validate functional requirements by creating end-to-end tests using Protractor.
● Deliver large amounts of data onto user interfaces through the use of AG Grid.
● Mentored and trained developers on client-side development using Angular.
● Build APIs in a microservices architecture using Java Spring Boot.
October 2020 - June 2021 Illinois, United States

StoneX Group

Lead Software Engineer

StoneX (formerly known as INTL FCStone) is an institutional-grade financial services network that connects companies, organizations, traders, and investors to the global markets ecosystem through a unique blend of digital platforms, end-to-end clearing and execution services, high-touch service, and deep expertise.

The Mono project, which I led, was a company initiative to migrate a web portal hosted on SalesForce to a new internal micro frontend architecture platform. The estimated savings from this project totaled $500,000 per year. I helped guide the project from inception using best practices for UI library development and design conversion of a web portal to React.js.

Responsibilities:
● Build reusable styles and components that conform to company style guide standards.
● Set direction for a team of 4 developers.
● Perform code reviews and architecture design.
● Institute automated tests and processes to set guardrails for project quality and developer productivity.
● Define user stories and groom backlog for on-shore and off-shore developers.
● Troubleshoot client-side code to solve difficult bugs.
● Mentor and train developers on client-side development.
July 2020 - October 2020 Illinois, United States

Donnelley Financial Solutions

Lead Software Engineer

Donnelley Financial Solutions (DFIN) is a global financial compliance company based in Chicago, Illinois, United States. The company provides software as a service (SaaS) products, software-enabled services (SeS), print, and reporting solutions to public and private companies in the global capital and investment markets.

I helped convert a SilverLight web application to a modern application. The application was a crucial product for the organization that generates $50 million in annual revenue. I guided the project team regarding UI principles, front end web application design, coding standards, and best practices.

Responsibilities:
● Implemented custom design system for essential web product that generates $50 million in annual revenue.
● Led implementation of best practices for the frontend on a project using Angular 8+.
● Enhanced communication between developers and designers by implementing Storybook.js.
● Leveraged ag-Grid for new application data grid features and presentation.
● Incorporated Unit and End-to-End automated testing into the CI/CD process for a web application.
● Refined user stories and features for a web project.
● Reviewed designs and code for quality and correct implementation.
● Mentored junior team members.
June 2019 - December 2019 Illinois, United States

Northwestern University

Angular Frontend Developer

Northwestern is one of the U.S.A.’s premier research universities, combining innovative teaching and pioneering research in a highly collaborative, multidisciplinary, and diverse environment. Northwestern provides opportunities for intellectual, personal, and professional growth in two campuses located on Lake Michigan in the state of Illinois in Evanston, minutes north of Chicago, and a 25-acre campus in downtown Chicago. A third campus in Doha, Qatar was founded in 2008.

Work as an Angular frontend developer for the Flipped-French project in the Weinberg College Media and Design Studio. I am responsible for developing the core features for an application which acts as adaptive courseware to help guide, teach, and test foreign-language learners of French. My job is to help organize the feature requirements and implement them using the Angular 6 framework.

Achievements:
• Lead the development of a courseware application for students learning French.
• Validate the requirements with the IT Director of Weinberg College Media and Design Studio.
• Convert the features into User Stories to track in an Agile Kanban board living on GitHub.
• Implement the features using Angular 6 code using TypeScript and Angular CLI with Visual Studio Code IDE.
• Generate Unit Tests for all the code that is delivered to the team.
July 2018 - October 2018 Evanston, Illinois, United States

Sabbatical

Sabbatical - Living abroad in Europe

I lived in Germany learning about a different culture and people. In addition, I also used the time to develop myself professionally by strengthening my web developer skills, worked on my professional brand, and learned the German language.
January 2018 - April 2018 Berlin, Germany

Solstice Consulting

Technical Consultant

Solstice Consulting, LLC is a digital consulting group that is responsible for helping companies to the innovate and improve their product offerings. They provide strategists and engineers to digitally transform businesses and help them stay ahead of the competition.

The Repairs project for which I was a part of involved adding a wizard feature for the eCommerce site of our client, Rockwell Automation. I was responsible for validating the UI requirements and web features that our strategists and UX designers agreed to with the client stakeholders. In addition, I was also responsible to building the front-end, back-end, and maintaining other developers and leads aware of the technical design and implementation aspects of the project.

Achievements:
• Led the development of a web wizard interface allowing hundreds of users to submit Repairs Quotes requests online in a responsive web application.
• Built System and Experience level APIs for new eCommerce portal using Mulesoft Anypoint Platform.
• Led the design and implementation of eCommerce MS SQL back-end leveraging .NET and Entity Framework.
• Performed front end development using Angular 2+ for a large web application.
• Served as Tech Lead for 2 developers working out of Buenos Aires, Argentina.
• Participated in design and code reviews to ensure best practices and high-quality code.
• Recommended best practices around source control, deployment, and issue tracking.
• Gained technical knowledge of software, hardware, and open source technology stacks.
August 2017 - November 2017 Chicago, Illinois, United States

Visa

Sr. Software Engineer

Northwestern is one of the USA’s premier research universities, combining innovative teaching and pioneering research in a highly collaborative, multidisciplinary, and diverse environment. Northwestern provides opportunities for intellectual, personal, and professional growth in two campuses located on Lake Michigan in the state of Illinois in Evanston, minutes north of Chicago, and a 25-acre campus in downtown Chicago. A third campus in Doha, Qatar, was founded in 2008.

I worked as an Angular frontend developer for the Flipped-French project in the Weinberg College Media and Design Studio. I was responsible for developing the core features for an application that acts as adaptive courseware to help guide, teach, and test foreign-language learners of French. My job was to help organize the feature requirements and implement them using the Angular 6 framework.

Achievements:
● Collaborated with Lead Developer to clarify business requirements for frontend development.
● Converted five major features into User Stories to track in an Agile Kanban board hosted on GitHub.
● Implemented the features using Angular 6 using TypeScript, versioned in Git, and deployed to Netlify.
● Produced Unit Tests using Jasmine and Karma to automate code quality checks.
● Created End-to-End tests using Protractor to validate user experience with the application automatically.
● Defined the endpoints and JSON responses for the backend API that would serve questions and answers.
● Implemented animations using Angular’s declarative domain-specific language using the Web Animations API.
● Incorporated sound streaming using MediaElement.js library to string multiple files together dynamically.
● Progressively refactored over 2,000 lines to make existing code easier to follow and maintain.
● Enhanced 13 HTML templates to make them more semantic and accessible for keyboard use.
May 2005 - May 2017 Texas, United States

Visa

Sr. SharePoint Solutions Specialist

Visa Inc. is an American multinational financial services corporation headquartered in Foster City, California, United States. They are responsible for providing card payment services for major banks all around the world. Visa connects people every day through innovative payment solutions.

As a SharePoint Solutions Specialist, my main role was to deliver training, support, and process improves to the organization for the Microsoft SharePoint platform. I served the role of an internal consultant, helping business teams leverage SharePoint for improved collaboration and process automation.

Achievements:
• Generated hundreds of thousands of dollars in efficiency savings by implementing an attestation solution for JP Morgan Chase data for the Risk Management Team
• Delivered web-based request forms for the Enterprise Business Intelligence (EBI) organization
• Coordinated feedback and design reviews for EBI forms with business team in Singapore
• Collaborated closely with Corporate Communications to enhance an Intranet Company Alert system
• Generated estimates and executed development work for an online sign-up system for technology support
• Provided 3rd level support for existing SharePoint sites delivered by the technology team
• Prioritized and completed a conference booking system for One Market Center facility in San Francisco
• Organized the fixes and testing of a CMS Admin automated workflow in multiple work environments
• Frequently shared lessons-learned and technical tips during group show-and-tell sessions
• Worked effectively and independently to complete daily activities
• Generated documentation on wiki platform on delivered solutions for ongoing maintenance and support
May 2014 - May 2015 Texas, United States

Northern Trust Corp.

SharePoint Analyst

• Gathered business requirements in order to translate them into input for Technical Architect and Developers to develop business solutions
• Performed requirements analysis and helped with system design using a waterfall software development lifecycle
• Supported business clients in understanding SharePoint technology and its benefits to process improvement
• Provided regular project status updates and helped maintain project plan for new and potential projects
• Juggled multiple high visibility projects simultaneously
January 2014 - April 2014 Illinois, United States

Visa

Sr. SharePoint Solutions Specialist

Visa Inc. is an American multinational financial services corporation headquartered in Foster City, California, United States. They are responsible for providing card payment services for major banks all around the world. Visa connects people every day through innovative payment solutions.

As a SharePoint Solutions Specialist, my main role was to deliver training, support, and process improves to the organization for the Microsoft SharePoint platform. I served the role of an internal consultant, helping business teams leverage SharePoint for improved collaboration and process automation.

Achievements:
• Delivered a record management SharePoint solution for Legal Department that replaced custom web application
• Developed a request system for Citrix virtual desktops using custom workflows to automate provision process for the entire organization
• Created executive blog template for migration of content from SharePoint 2010 to 2013 intranet
• Trained SharePoint 2010 site owners and users on new 2013 capabilities and features as part of migration project
• Managed migration to SharePoint 2013 of 10 critical sites by testing, resolving issues, training, and coordinating communications
• Resolved technical issue causing electronic forms to not authenticate properly during content migration to new SharePoint 2013 platform
• Implemented cost-saving process to track and validate wireless mobile device licenses with custom solution on SharePoint 2013 for BYOD program
• Designed and implemented web form questionnaire that tracked mobile development projects inside Visa
• Designed and documented best-practices for internal solutions team
• Wrote internal tips and tricks blog articles for power-users of SharePoint, Nintex, and InfoPath technologies
• Generated support best practices and documentation for system maintenance
June 2013 - January 2014 Texas, United States

Kraft Foods

Collaboration Solutions Specialist

Kraft Foods Inc. was an American multinational confectionery, food and beverage conglomerate. It marketed many brands in more than 170 countries. Twelve of its brands annually earned more than $1 billion worldwide: Cadbury, Jacobs, Kraft, LU, Maxwell House, Milka, Nabisco, Oreo, Oscar Mayer, Philadelphia, Trident, Tang. In 2015, it merged with the Heinz company to become the Kraft Heinz Co.

As a Collaborations Solutions Specialist, I served the role of an internal consultant. This entirely new position entailed that I work with multiple internal business units to provide web and portal solutions to improve collaboration and automation leveraging the Microsoft SharePoint platform. I also provided coaching, training, and technical support.

Achievements:
● Migrated Kraft Foods enterprise content to Microsoft SharePoint 2010 technology platform.
● Facilitated in the deployment of internal corporate Intranet to 78,000 employees.
● Eliminated paper forms used for server monitoring process in South Africa by converting them to InfoPath 2010 forms.
● Recognized by Microsoft in 2012 for implementing Corporate Intranet hosting on the SharePoint 2010 platform.
● Delivered external partner site that generated $140,000 in reduced material costs and improved efficiency.
● Realized over $100,000 in cost and productivity savings in 2011 by leveraging existing collaboration technology.
● Designed and deployed hundreds of websites that drove best-in-class collaboration and sharing among enterprise business units.
● Educated internal and external employees/partners with the use of technology for productivity and collaboration.
● Facilitated large-scale technology training sessions in North America and Latin America, and Europe.
August 2004 - September 2012 Illinois, United States

Education

Ohio State University

Bachelor of Science in Computer Information Systems

My courses included core computer science concept courses on algorithms, operating systems, computer graphics, networks, and databases. Various math courses were also taken such as statistics, algebra, and calculus. As part of the Science and Math department, I was required to take art elective courses to make me a more well-rounded individual. Took courses on philosophy, art, history, and science.
August 1999 - June 2004 Columbus, Ohio, United States

Languages

Spanish (Fluent),
English (Fluent),

Skills

Angular 2, Atlassian Jira, Boostrap 3, CSS3, Git, Gulp, HTML5, JavaScript, Node.js, Office 365, SharePoint, Visual Studio Code,