JOHN AGUSTIN

***** ****** ****** • Carson, California 90745

+1-562-***-**** • acwqx6@r.postjobfree.com • https://www.linkedin.com/in/agustinjohn

SENIOR BUSINESS INTELLIGENCE ANALYST

Skilled Business Intelligence Analyst having 10 years of hands on experience in database design, data integration, reporting and analytics, specializing in Microsoft SQL Server Business Intelligence Suite (SSRS, SSIS, SSAS). Proven project management skills supported by a strong knowledge of Agile methodologies. Ability to rapidly and accurately deliver BI projects from initialization till planning, development, monitoring and closing.

CORE COMPETENCIES

SQL Database Design • Integration Services (SSIS) • Reporting Services (SSRS) • Analysis Services (SSAS) • Hadoop MapReduce • Data Modeling • Project Management & Planning • Agile, Waterfall & Iteration Methodologies • Quality Assurance • Requirements Gathering • Testing • Process Improvement

Databases

Microsoft SQL Server 2002 / 2005 / 2008 / 2008R2 / 2012

Business Intelligence

Microsoft SQL Reporting Services (SSRS), Microsoft SQL Integration Services (SSIS), Microsoft SQL Analysis Services (SSAS), ETL, MDX, DAX, Microsoft SQL Profiler, Business Objects Crystal Reports, Power BI, Cubeware, R Project, Hadoop

Data Interchange

Webservices, JSON

Languages

C#.NET, Java

Web

C#.NET, JSP, Java Server Faces

Tools

Atlassian Suite (Jira, Confluence), JIRA, Red Gate (SQL Compare, Data Compare, Version Control), Microsoft Team Foundation Server, Microsoft Visual Source Safe, Rational Clear Quest, Remedy, Bloomberg Data License & Terminal, Platts Market Data, Tortoise SVN

SDLC

Agile Scrum, Waterfall, Iterative, Prototype

Platforms

Amazon Cloud Computing, Microsoft Server 2008 R2

PROFESSIONAL EXPERIENCE

CAREER NOTE: Completed on-campus studies and currently taking distance education courses to complete a Master's Degree in Computer Science (Available for full-time, W-2 employment).

COMPANY: OLDENDORFF CARRIERS SINGAPORE PTE LTD, Singapore • Dec 5, 2011 – Oct 5, 2015

Global dry bulk shipping company with over 500 chartered and 40 owned vessels.

IT Project Manager / Business Intelligence Analyst

Performed role of business intelligence analyst, gathering requirements from users and subject matter experts. Developed and designed databases, dashboards, data loading interfaces, SSRS reports, Excel database connected reports, Power BI reports, SSIS packages/ETL, TSQL scripts, MDX, DAX, SSAS Cubes, and stored procedures. Project managed team of 3 personnel and collaborated with project team in Germany. Oversaw all aspects of project planning including configuration management, risk management, quality assurance, requirements gathering, estimate and schedule, training, and resource planning. Gathered and prepared strategic, functional and technical project requirements. Developed project deliverables schedule plan, templates and process guidelines. Managed database maintenance including backup, restoration, retention, re-indexing, batch jobs, logs, server status and SQL Server health checks.

Acted as key contact person with vendors that included Bloomberg, Platts McGraw Hill Financial, Invest Intech, Monson, AXS Marine, and Baltic Exchange.

Assessed and made successful proposals for new software that included Able2Extract, Excel2012, and EEX data mart for internal and enterprise use.

Led data integration with Bloomberg Data License, Platts McGraw Hill Financial, and AXS Marine web service, and Baltic Exchange FTP using C#.Net, SSIS, and TSQL.

Created and maintained SQL scripts, stored procedures, functions, views, reports, triggers and SSIS/ETL packages.

Worked in Germany on a key project for total of 4 Months.

IT Project Manager / Business Intelligence Analyst Continued:

Major Projects:

Research Data Management System: Developed databases, analytic reporting tool and data processing automation for the Research Department with data gathered from over 200 diverse sources including Bloomberg, Baltic Exchange, shipping companies, port agents, government bodies and banks.

Finance Settlement DWH and Reports: Created databases and reports for Finance Department. Migrated data source from Reuters to Bloomberg. Used more than 3000 financial instruments ranging from foreign exchange rates, FX forward rates, interest rates, deposit rates, precious metals, and oil fair value curves.

Platts Bunker Price Reports: Created databases and reports used by key users from Finance, Commercial, Marine Accounting, and Bunker Department. The historical data and daily feeds from the FTP server of Platts McGraw Hill are loaded automatically into the company’s database on a daily basis having different schedule depending on when the market for the bunker prices becomes open and available.

Technical Environment: C#.NET, Microsoft SQL Server 2008R2 and 2012, Microsoft SQL Reporting Services, Microsoft SQL Integration Services, Microsoft SQL Analysis Services, MDX, DAX, MS SQL Profiler, Cubeware, Red Gate, Bloomberg Data License & Terminal, Platts Market Data, Tortoise SVN, Microsoft Server 2008 R2

COMPANY: SHELL INFOTECH PTE LTD, Singapore • Jan 10, 2011 – Nov 30, 2011

Senior ETL Consultant / Contract

Deployed to Shell client, Global Blue, a tax refund and financial company. Collaborated closely with teams from IT and business analysts. Delivered functional and technical designs for database, DB re-organization and schema, data warehouses. Developed SSRS reports and SSIS packages/ ETL. Delivered integration with Reuter’s market data.

Global Blue Data Warehouse and Report Dashboards: Developed dashboards (Tax Free Shopping, Foreign Currency Concept, TRXN) for tax refund data analysis and forecast modeled data for use by the merchants and customers.

Technical Environment: C#.NET, Microsoft SQL Server 2005 and 2008, Microsoft SQL Reporting Services, Microsoft SQL Integration Services, Microsoft SQL Analysis Services, Microsoft SQL Profiler, Microsoft Visual Source Safe, Tortoise SVN, Amazon Cloud Computing, Microsoft Server 2008

COMPANY: BLUE STAR INFOSTACK SOLUTIONS PTE LTD, Singapore • Jun 7, 2010 – Jan 7, 2011

System Analyst / Contract

Deployed to Infostack client, Comfort Delgro. Gathered information for pre-design stage from users. Delivered functional and technical designs for database, DB re-organization & schema & data warehouse and created detailed design documents for reports, SSIS packages/ETL, and stored procedures. Tested and produced data patches and a structural planned update on database and data.

ComfortDelgro Fleet Analytics, Customer Analytics and HR Analytics: Oversaw successful data integration focused on migrating data from SAP, workshops/users, and existing database. Via the historical data, different dimensional models for budget planning, forecasting, and fleet demand insight are produced.

Technical Environment: C#.NET, Microsoft SQL Server (2002, 2005, 2008), Microsoft SQL Reporting Services, Microsoft SQL Integration Services, Microsoft SQL Analysis Services, Microsoft SQL Profiler, Microsoft Visual Source Safe, Tortoise SVN, Microsoft Server 2008

COMPANY: JOBLINE RESOURCES PTE LTD, Singapore • Jan 11, 2010 – Jun 5, 2010

Senior Analyst, Application & Integration, Solution Developer / Contract

Deployed to Jobline client, Avanade and deployed by Avanade to a sub client, Keppel Gas. Gathered information from users and business analyst. Produced detailed design documents, created web pages using C#.Net. Planned and implemented testing. Delivered user guide and manual.

Keppel Gas Management System: Created webpage written in C#.Net that rendered SSRS reports that read parameters from C#.Net components and display company’s transactional summary report, profit & loss reports, and overruns reports relating to gas industry data throughout Singapore.

Technical Environment: C#.NET, Microsoft SQL Server 2008, Microsoft SQL Reporting Services, Microsoft SQL Integration Services, Microsoft SQL Analysis Services, Microsoft SQL Profiler, Microsoft Team Foundation Server, Microsoft Server 2005

COMPANY: COMTEL SOLUTIONS PTE LTD, Singapore • Nov 26, 2008 – Nov 25, 2009

System Analyst / Contract

Deployed to Comtel client, Levis Strauss and Co, and collaborated with the IT project manager, users and vendors. Gathered information from users and business analyst, developed functional and technical designs, and created detailed design documents for reports, SSIS packages/ETL, and stored procedures. Planned and executed testing, developed data patches and structural planned update on database and data, and oversaw database maintenance. Used SQL Profiler for monitoring, execution plan for performance tuning.

Levis Strauss and Co - Demand Forecasting and Assortment Planning: Delivered SSIS packages scheduled for the new data warehouse. Data is loaded from SAP Inventory and Sales Order legacy system to the new assortment and forecasting system that contains various levels of transactional data.

Technical Environment: C#.NET, Microsoft SQL Server 2005, Microsoft SQL Reporting Services, Microsoft SQL Integration Services, Microsoft SQL Analysis Services, Tortoise SVN, Microsoft Server 2005

COMPANY: ACCENTURE DELIVERY CENTER, Manila, Philippines • Aug 2005 – Nov 2008

Senior Analyst

Deployed to partner, Avanade. For more details, please visit https://www.linkedin.com/in/agustinjohn

EDUCATION

Master of Science in Computer Science

(In progress via distance education; expected completion June 2017)

Maharishi University of Management, Fairfield, Iowa

Key Courses: Database Management Systems, Web Application Programming, Big Data Analytics, Web Apps: Architecture and Frameworks, Advanced Software Development, Big Data (Hadoop)

Bachelor of Science in Computer Science

Mapua Institute of Technology, Makati, Philippines

TRAINING

TDWI Project Management for Business Intelligence

TDWI Requirements Gathering: Getting Correct and Complete Requirements for BI Systems

Extreme Scoping: An Agile Approach to Enterprise-Class Data Warehousing

Evolving Your Requirements Approach to Advanced Analytics with Decision Management

Secrets of Analytical Leaders: Insights from Information Insiders

The New Analytical Ecosystem: Bridging the Worlds of BI and Big Data

Leadership & Presentation

SQL Bits 2012 / Cubeware

Bloomberg Data License (FTP & Webservice) / Bloomberg Terminal Training

PROFESSIONAL MEMBERSHIPS:

Microsoft Certified Professional Community - Since 2006

The Data Warehouse Institute Member - Since 2014

ACADEMIC PROJECTS

Check-in/Checkout Framework and Application, Maharishi University of Management: A framework developed in Java that can be used in a library, car rental, hotel check-in/checkout and any systems that do a lending or rental. Applied Template Method, Strategy, Command, Singleton, Factory, Observer, Façade, Decorator and Bridge design pattern. Technologies used: Java 8, Java FX Sean builder, NetBeans IDE.

Web Mail, Maharishi University of Management: A web application enabling users to register using their Gmail account and perform basic email services. Technologies used: JavaServer Faces, EJB, PrimeFaces, and RichFaces. Applied MVC architecture. Collaborated with 4 members to integrate the modules.

Hotel Recommendation System, Maharishi University of Management: A system that recommends hotel clusters to users based on their past hotel booking and on similar user clusters behavior. Technology: R Project.

Contact this candidate