Biju Augustine Email & Phone Number

US

Evaluate existing data architecture. Model existing data structures and recommend suggestions for improvements.

St Paul, MN, US

• Worked as the sole Database Engineer for a major product development project at Patterson Companies.
• Created Database Architecture for Multi-Tenant scalable databases.
• Implemented Development and QA Database Services in Microsoft’s Azure Cloud.
• Created conceptual, logical and physical data models for the project.
• Developed and managed tables in Azure SQL Server.
• Worked with SQL Server Data Tools in Visual Studio for managing Database Scripts.

St Ann, Missouri, US

• Identified Master data that was shared by Corporate and Retail applications at Save-A-Lot that would reduce data replication and data inconsistencies.
• Created Entity Relationship (ER) diagrams in ERwin for the master data.
• Collaborated with Application Architects and Business Analysts to create a Data dictionary.
• Introduced Naming standards for database objects which include tables, views, indexes, constraints, triggers and functions.
• Designed and implemented a common database in SQL Server for the master data shared by different applications.
• Created an ETL process in Informatica to populate the new database in a timely manner.

Chesterfield, MO, US

• Performed the role of a Data Architect/Application DBA at Managed Services client AT&T’s Ordering and Wholesale division. Worked on data modeling, database design and SQL development for their data warehouse.
• Provided significant contributions to the success of the projects that integrated Bellsouth’s reporting data warehouse into AT&T's reporting data warehouse.
• Worked on enhancing AT&T's Star schema Data Warehouse repository used by Service Centers for reporting.
• Collaborated with AT&T’s Business Managers to identify and define requirements for Business Intelligent applications.
• Translated business requirements into logical relational database models and implemented the logical designs into database objects
• Provided pager support for Oracle databases and automated data loads into the warehouse.

Dallas, TX, US

• Designed and developed Oracle databases for company wide applications.
• Created and maintained tables, indices, views, triggers, functions, procedures and packages.
• Allocated disk storage space as needed to accommodate database growth.
• Implemented PL/SQL programs for back-end processing of Web applications.
• Wrote and scheduled Unix Shell scripts for batch data load processes into Oracle tables.
• Provided 24x7 pager support for the databases and cron jobs.

Dayton, OH, US

• Designed and developed Oracle databases for Woolpert's clients, mainly local government offices.
• Implemented a data warehouse involving the creation of data extraction and cleansing routines to extract information from the original legacy systems, reformat data for ease of querying, and placement onto the data.
• Created a custom data scrubbing tool using PL/SQL for the address fields in a Geographical Information System application.
• Implemented multiple applications using Oracle Forms for a Facilities Management Application.
• Provided information technology support to Woolpert's engineers and survey crew.
• Created and managed Oracle instances on a Windows NT server for the Geographical Information Systems applications.

Master'S Degree, Computer Science

Bachelor'S Degree, Electrical And Electronics Engineering