Julius C. Yagin

[email protected] • +65 9146 9735

PROFESSIONAL SUMMARY

• I have more than 22 years of experience in Software analysis, design, development, integration, deployment, customization, testing, and support as a Business Intelligence/Database/ Reports developer. • Worked on all phases of data warehouse development lifecycle, from gathering requirements to design, testing, implementation, and support. • 22 years of experience in ETL tools, including Azure Data Factory, Azure Databricks, SQL Server Integration Services (SSIS), Data Transformation Services (DTS). • Strong leader with experience in leading global operations and development efforts and has experience in training teams/developers. • I worked as a Data Architect and Lead developer. • Team player with excellent communication and problem-solving skills. • Microsoft Certified Professional • I am a graduate of Bachelor of Science in Electronics and Communications Engineering.

WORK EXPERIENCE

Senior Application Consultant – MS BI
08/2017 - Present
Anglo American Marketing Limited Singapore Branch , Singapore
• Responsible for Design, Build and Test, Deployment and Support of ETL components, Database and SSAS objects, and Reporting Tools
• Work closely with Clients, end users and Stake holders to gather requirements and ensure deliverables are within the expectations. Involved in Technical decisions for Business requirements and interaction main stakeholders and end users.
• Train and develop junior members of the team
Senior Application Consultant – MS BI
03/2016 - 08/2017
Light Stream Analytics
• Responsible for Design, Build and Test of ETL components, Database and SSAS objects.
• Work closely with Clients, end users and Stake holders to gather requirements and ensure deliverables are within the expectations. Involved in Technical decisions for Business requirements and interaction main stakeholders and end users.
• Train and develop junior members of the team
Lead Database Developer/Business Analyst 4
06/2010 - 03/2016
Barclays Capital
• Responsible for Design, Build and Test of ETL components (SSIS, Stored Procedures, and Autosys jobs) for new data feeds and Credit Risk and Fed reports
• Work closely with Clients, end users and Stake holders to gather requirements and ensure deliverables are within the expectations. Involved in Technical decisions for Business requirements and interaction main stakeholders and end users.
• SQL database tuning – identify performance issues and implement solutions to the issues
• Create Release plans and Change Requests and Coordinate with release teams
• Work with DBAs in planning Database Maintenance, patching, forecasting and releases
• Work with Testers for UAT and SIT tests
• Train and assist Junior developers
• Provide 3rd line Support, and work with the Production support team to resolve issues in production.
Data Architect and Senior SQL Developer
11/2009 - 06/2010
Accenture /Avanade –Manila Delivery Center , Manila
• Responsible for Database Design and Architecture of the Upsized application.
• Responsible for Design, Build and Test of ETL components (SSIS and Stored Procedures)
• Responsible for Design, Build, test of Store Procedure to be used in Application Reports.
SQL and Business Intelligence Developer
07/2009 - 11/2009
Accenture /Avanade –Manila Delivery Center , Manila
• Responsible for Build and test and optimization of SQL stored procedures, SSAS Cubes and SSRS reports.
• Perform Reports Validation and troubleshooting of SSAS and SSRS reports and SQL stored procedures.
Primary Data Architect / Lead Developer
03/2009 - 12/2009
Accenture /Avanade –Manila Delivery Center , Manila
• Design, document, and maintain logical and physical data models for all new CIO application development
• Provide database architecture assistance on new application development and application re-engineering / re-plat-forming efforts
• Perform SQL tuning reviews for all new application development and existing applications that have been identified as needing improvement
• Perform database access (SQL statement) reviews for all new application development and major application releases
• Establish, enforce, and educate application designers and developers regarding standards and best practices for data storage and access for all CIO-supported applications
• Worked as a SQL Designer and Developer responsible for analysis and design and development of the application.
• Involved in preparing the Functional Requirements Documents and design documents.
• Designed the conceptual, logical and Physical data model for the application
• Designed the overall process flow for the applications.
• Developed the SSIS packages used in the ETL of the data to be used in the reports.
SQL Developer / Optimization Team
01/2009 - 02/2009
Accenture /Avanade –Manila Delivery Center , Manila
• Optimized existing codes that have slow performance
• Write code based on detailed designs, applying coding standards and best practices
• Write test scripts and develop common test data
• Perform testing for assigned modules
• Escalate issues and resolving those assigned to them
• Conduct impact analysis for proposed changes to the application
• Work with other programmers, designers, and architects to make sure that the configuration and custom components meet application requirements and performance goals.
• Follow good security coding practices to ensure the application is free of the most common coding vulnerabilities.
• Participate in code reviews.
• Inform the technical architect and project manager of any issues that may affect any other areas of the project.
• Participate in transitions of the application or technical architecture components to the testers.
• Fix any defects and performance problems discovered in testing.
• Document the application to facilitate maintenance.
• Adhere to the project's processes and standards
Global Operations Lead / Lead SQL and Business Intelligence Developer and Programming Supervisor
03/2004 - 01/2009
Accenture /Avanade –Manila Delivery Center , Manila
• Global operations lead for Decision Support.
• Responsible for the day-to-day operations of all data warehousing and reporting applications across all sites. (Manila, Madrid, and Bangalore)
• Ensures that operations tasks are delegated and scheduled across sites and workload is transitioned properly.
• Creates metrics for operations tasks.
• I worked as a SQL Designer/Data Architect and Developer responsible for analysis and design and development of the Data warehousing and reporting applications.
• Involved in preparing the Functional Requirements Documents and design documents.
• Designed data models for new applications, created overall process flow for new applications.
• Involved in developing the SQL stored procedures, DTS, SSIS packages used in the ETL of the data to be used in the reports.
• Involved in configuration of Webtrends tool.
• Involved in the requirements gathering phase and has good customer communication skills.
• Trained several developers and supervised developers across sites.
• SQA project manager
• Software Configuration Manager

EDUCATION

Bachelor’s Degree on Electronics and Communications Engineering
Technological University of the Philippines

SKILLS

CERTIFICATIONS

MCP-070-228 Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition
MCP -070-229 Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition
Registered Electronics Communications Engineer

Similar Resumes

MUHAMMAD ASIF High School Teacher House #38 Cnanal Breez Ali Town Raiwind Road Lahore, Punjab, Pakistan ASHOK Yennam, Venkata Krishna Reddy Project Manager Aachen,DE JASMEET ARORA SEO Intern Noida ANYI LISETH HOYOS TAPIERO Bogotá D.C. · Colombia