Brian Sharma Email & Phone Number

Greater Pittsburgh Area

• 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

Greater Pittsburgh Area

• 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

Greater Pittsburgh Area

• 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

Greater Pittsburgh Area

• 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

Greater Pittsburgh Area

• 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

Greater Pittsburgh Area

• 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

Bachelor Of Science (B.S.), Business Administration And Management

Microsoft Certified Solutions Associate, Microsoft Sql Server 2012

• MCSA: Querying Microsoft SQL Server 2012 • MCSA: Administering Microsoft SQL Server 2012 Databases • MCSA: Implementing a Data Warehouse.

Logi Info Developer Training

• Logi Info • Logi Studio • Logi Server