Senior Business Intelligence Developer

• Dec 2014 - Present

• Model/map and execute the integration of data across various sources into a unified view • Responsible for the monitoring of data flow between databases • Identify and implement the most suitable DI architecture for the organization’s needs • Work with project manager and Sr developers to ensure that data entry, retrieval, change and delete functions meet business requirements for project completion • Lead in company data integrations with various systems that are utilized • Identify data entry, retrieval, change, and delete issues, and ensure high level of data availability • Coordinate and work with other technical staff to develop relational and secondary databases • Identify inefficiencies in current databases and leverage solutions • Diagnose and resolve database access and performance issues • Analyze user requirements and design functional specifications for client/server databases and applications Show less

Business Intelligence Developer

• Jun 2014 - Dec 2014

• Designing, creating, editing reports using SQL Server (SSMS, SSRS, and SSIS) • Managing multiple databases on development, QA, production and backup servers • Writing stored procedures, queries, and reporting processes in SQL and T-SQL • Creating, editing and maintaining Sharepoint pages on corporate intranet • Writing and editing VBA macros to parse and manipulate data in Microsoft Excel • Expert in Business Intelligence concepts and Data Warehouse design • Designing, creating, editing reports using SQL Server (SSMS, SSRS, and SSIS) • Managing multiple databases on development, QA, production and backup servers • Writing stored procedures, queries, and reporting processes in SQL and T-SQL • Creating, editing and maintaining Sharepoint pages on corporate intranet • Writing and editing VBA macros to parse and manipulate data in Microsoft Excel • Expert in Business Intelligence concepts and Data Warehouse design

Business Intelligence Developer

• Jun 2013 - Feb 2014

• Designing, creating, maintaining and editing reports using Logi Info and Logi Studio • Converting and Optimizing SQL Server SSRS Reports into Logi Info Reports • Writing Logi functions, processes and actions using HTML, CSS and Javascript • Writing SQL Queries in PL/SQL, ANSI SQL, T-SQL and MySQL • Developing ETL processes between SQL Server, Oracle and MySQL databases • Database Design, Maintenance and Management using SQL Server and MySQL Workbench • Expert in Business Intelligence concepts and Data Warehouse design Show less

Database Developer

• Jun 2010 - Jun 2013

• Strong SQL, T-SQL, Visual Studio, BI Technology (SSRS, SSAS, and SSIS), and XML • Database development and administration of SQL Server 2000/2008 databases • Data warehousing, data mart design, dimensional modeling and implementation • SQL, VBA and XML coding, compiling and publishing business reports and web applications • Working directly with CEOs and senior executives to translate requirements into data models • Compiling and publishing reports with Visual Studio 2008 and .NET Framework 3.5 • Proven experience with database performance optimization and server maintenance Show less

Database Designer

• Feb 2009 - May 2010

• Planning, developing, implementing and maintaining student financial database systems • Designing and creating Access 2007 database forms, fields, tables, records and reports with VBA • Creating customized financial reports summarizing raw data extracted from multiple sources • Converting Access 2003 databases to Access 2007, upgrading and rewriting ETL processes • Creating custom templates in Excel 2007 and designing VBA macros to interact with Access 2007 • Designing ETL processes to transfer data between Access, SQL Server, Oracle and SharePoint • Writing complex conversion macros using Visual Basic, SQL, Excel 2007 and Access 2007 Show less

E-Learning Designer

• Jun 2007 - Jan 2009

• Creating and implementing interactive instructional database systems in Access, SQL and VBA • Designing and creating custom templates in Word, Excel and PowerPoint, designing VB macros • Creating Instructional Design documentation templates with custom VBA code • Writing complex conversion macros using Visual Basic, importing forms into consolidated reports • Designing and creating databases and interactive Excel spreadsheets with VBA and SQL queries • Creating, formatting and editing management training materials for print and online distribution • Designing and creating interactive forms in Microsoft Word, linking to other programs Show less

Research Operations Specialist

• Jun 2005 - Mar 2007

Presentation Specialist

• Jun 2004 - Jun 2005