Xavier Vila Email & Phone Number

New York, Ny, Us

New York, Ny, Us

New York, Ny, Us

• Managed a team of developers to create a web based application that automated the data mapping, cleansing, validating and reporting processes in an attempt to automate portfolio pricing reports for business analysts.• Oversaw the evaluation, deployment and administration of all analytic software and databases.• Removed duplicate records from SalesForce by creating custom matching criteria with Python.• Built and maintained multiple SalesForce organizations supporting $34 Billion in transactions for 2016. • Trained new employees and interns on how to use SalesForce and Microsoft Excel.

New York, Ny, Us

• Developed robust data loading templates for high volume processing, eectively reducing average data processing times by 90%.• Created a custom sync between MailChimp and SalesForce databases providing users with an intuitive solution to manage contacts and mailing list subscriptions with Python.• Created business intelligence applications using QlikView and SalesForce to track progress on loan portfolio sales.• Created single click report exports from SalesForce using Conga Composer, increasing business analyst’s productivity.• Provided training for data analysts located in New York and Texas oces.

New York, Ny, Us

Metis is a selective 12 week intensive data science bootcamp. The curriculum has an emphasis on developing skills in programming, data acquisition, data cleansing, and machine learning. See project section for more details.The Shape of Stories• Visualized the shapes of stories using sentiment analysis focusing on Stephen King novels in an attempt to prove Kurt Vonnegut's thesis which stated that these shapes could be easily created by computers.Twitter Support Analysis• Used NLP and Sentiment Analysis to compare customer support best practices to actual data consisting of 3 million tweets.

Southborough, Ma, Us

Client - Bank of Nova Scotia• Collaborating in creation of client onboarding solution via SharePoint and SQL server securing compliance with FACTA regulations • Using SQL, VBA coding and client feedback, developed and automated World Check compliance reports • Developed Access database to track KYC information for over 30,000 customers as remediation of federal audit findingsClient - WestLB -- User Management Team• Serving as senior member of team providing application access and troubleshooting support to users in New York, Germany and London for over 30 applications • Conferring with stakeholders, to create and run test plans/scripts to asses value of Testing Information Security tools in order to determine whether they meet business standards• Liaison between IT technical support teams and end users in order to resolve IT related issues• Supporting the Project Lifecycle with creation of Project Plans, Project Charters and Business Cases• Performing Quarterly Recertification across New York applications, ensuring appropriate user access and compliance with organization access standards • Creating documentation detailing administrative procedures for New York applications, instructing all UMT members on the methods for creating and altering access for NY systems• Conducting Juniper remote access training sessions for NY based users• Worked directly with the Audit department in order to analyze and remedy audit findings regarding Information Technology controls. Virtusa• Analyzing current billing needs in order to develop a new customized solution for future tracking• Creating Access database to track all consultant payroll data, streamlining client billing• Automating monthly import of consultant time tracking using a combination of VBA and SQL allowing for quicker and effortless data analysis

London, London, Gb

• Created monthly performance tracking reports Gas Dispatch and Emergency Response for Vice President of Gas• Created data and work process flow diagrams for Gas Distribution to facilitate future streamlining using Visio• Worked with all levels of management in order to consolidate reporting processes throughout the East Coast• Served as Record Retention Coordinator

Us

• Maintained and updated PMO website using PHP and HTML coding• Created a database to assist with monthly project status report tracking using Access• Applied knowledge of pivot tables, macros and queries to analyze IT project budgets, status and timelines using Excel and Access• Conducted training on Microsoft SharePoint for all NYC project managers with hands on sessions• Created instructional technical documents regarding use of Microsoft SharePoint• Assisted with merger processes by collecting and consolidating bi-weekly merger status reports for the PMO Director• Managed project business cases for project prioritization and selection process using UMT Project Portfolio Management software• Provided technical support for users of MS SharePoint in both the U.S and U.K.

Us

• Performed daily data entry regarding medical claims information• Maintained physical medical claims files• Transported files between different departments

Grapevine, Texas, Us

• Performed supervisory work, such as handling shipments and reports• Provided customers with information regarding products and issues• Met weekly goals of game subscription and reservation sales• Maintained store appearance