Michael Castaneda Email & Phone Number

New York, NY, US

New York, New York, United States

Project manager and a solution developer building packaged solutions for internal auditors. I conduct and lead scrum meetings with stakeholders from requirement gathering i.e., BRD, data sourcing, building and presenting proof of concepts or mock drafts, to coordinating UAT, creating necessary documentations including user guides, technical designs, and.

Long Island City, New York And Jersey City, New Jersey

• Created, implemented, and managed 12 large scale projects utilizing Access databases, Excel workbooks, SQL, VBA programming, and standard PC applications as End User Computing tools to streamline and automate Client.
• Managed software development life cycle (SDLC) of all 12 projects using Agile methodology. Identifying further innovations or enhancements in the Risk and Regulatory framework e.g. add/change controls, dependencies.
• Designed data models, developed and implemented Access Database applications in a multi-user environment. Per Audit policies, included entitlements for accountability, audit trail, intelligent user interfaces utilizing.
• Identified and articulated problems or inconsistencies for Audit and Compliance. Analyzed data, designed and generated Business Intelligence reports on periodic and ad hoc basis for senior management translating raw.
• Built workflow databases with VBA macros and scripts, and implemented them as desktop applications globally across business units and set up predesigned reports allowing users to run management reports independently.

• Wrote VBA scripts to automate the data flow feeding one database to another, used daily since 2004 by several business units including users from APAC and EMEA to enhance client experience.
• Interacted regularly with stakeholders, SMEs, Risk, Compliance and Legal to define and gather requirements and gain consensus on workflow solutions, process improvements, data reporting and delivery.
• Integrated Access, Excel, and Outlook using VBA scripts to create artificial intelligence that automated and streamlined email responses with Business Intelligence content or attachments.
• Created and implemented a system to remediate the generation of regulatory letters and HTML emails (with embedded branding) to send communications to Private Bank clients, including version control, queuing system with.
• Designed, developed and implemented APIs with on demand and scheduled tasks to run ETLs (extract-transform-load) from different sources onto a data warehouse. Extracting large and complex data sets and creating new.

• Created and implemented a number of encrypted Access databases approved by Business Information Security Officers to serve as a data warehouse of client demographics, account, and tax information, a vital tool to.
• Created and maintained a ‘data scraping’ scheme to further reduce keystrokes in capturing information from dynamic web pages of an intranet application. With a few clicks, VBA scripts will systematically extract.

New York, New York, United States

• Solely responsible for the development life cycle of the Vendor Database for Risk and Compliance to monitor vendor performances and projects. It includes entitlements, user-friendly forms, data entry validation.
• Created an intranet version of the Access forms using ASP with the Vendor Database as the back-end server.

New York City Metropolitan Area

• Worked as an independent contractor responsible for the design, development, implementation, training of personnel, and maintenance of the company’s Clientele Database.
• Developed in Microsoft Access, the database gives the sales people the ability to search “preferred” employees. It matches a job order with the candidate's skills, availability, and salary range to fulfill the job.

Costa Mesa, California, United States

• Team lead in Data Procurement Center streamlining workflows and RFP processes by writing VBA modules to import data into Access with minimal mouse clicks. Created Excel templates with VBA scripts for electronic.
• Solely responsible for the design, development, implementation and maintenance of the company’s on-line notes system in ASP. This internet application is utilized by managers and account representatives to log their.
• Acted as technical consultant in Excel, Access, and VBA programming for other departments.

Makati, Manila

• Taught logic formulation, flowcharting, writing and debugging programs in COBOL 74/85, Dbase, and Foxpro
• Developed lesson plans and examinations for the school's instructional materials.

Bs In Business Management

Computer Programming