We provide IT Staff Augmentation Services!

Data Warehouse Architect Resume

Cheverly, MD

PROFESSIONAL EXPERIENCE:

Confidential, Cheverly, MD

Data Warehouse Architect

Responsibilities:

  • Investigated available commercial products for healthcare data warehouses.
  • Investigated current state of the art development/efficiency tools for Hadoop, ETL and BI.
  • Performed build versus buy analysis.
  • Created data model for data warehouse to support clinical and financial operations.
  • Produced proposed high level architecture for overall analytics/reporting solution.

Confidential, Bowie, MD

Technical Lead

Responsibilities:

  • Designed and built a database driven automation framework to process medical data.
  • Designed and built a database to describe projects and tasks. Database was designed to integrate with the SSISDB catalog.
  • Used BIML, Entity Framework, C#, Linq, SQL Server 2014 and Visual Studio 2013 to dynamically build SSIS packages from the database.
  • Developed SSRS reports to display processing performance.
  • Met extensively with business users to gather rules and requirements.
  • Lead 1 other developer.

Confidential, Columbia, MD

Business Systems Developer - Database

Responsibilities:

  • Initiated, designed, built and maintained a data warehouse, based on the Kimball method, to service Pandora in the Americas.
  • Approx. 2TB of data across 20 fact tables.
  • Used SQL Server 2012, SSIS, SSAS, SS Data Tools, SSRS, Azure Table Storage, TFS, MS Build automated deployments.
  • Lead team of 4 other developers (1 employee, plus 3 contractors).
  • Met extensively with business users to gather rules and requirements.
  • Developed a meta-data based data warehouse documentation tool.
  • Designed and lead development of QA/reconciliation reports.
  • Designed, built and maintained data marts and numerous complex reports and scorecards, before development of the data warehouse.
  • Designed, built and maintained methods to receive, store and analyze sales, inventory and traffic count data from retail stores. Data was transmitted in various forms (multiple XML formats, CSV, Tab delimited, Azure table storage, relational databases.)
  • Developed database designs for transactional systems.
  • Acted as de-facto database administrator/architect/gatekeeper.
  • Developed database designs for transactional systems.
  • Built numerous data integrations between Dynamics CRM, Dynamics GP and Azure SQL database.
  • Provided solutions to data quality and data governance problems.

Confidential, Silver Spring, MD

.NET Architect

Responsibilities:

  • Defined software architecture.
  • Met with client to gather business requirements.
  • Designed database.
  • Designed and developed user interface wire frames.

Confidential, Washington, DC

Application Architect/Project Lead

Responsibilities:

  • Architect and project lead on multiple projects using: VB.NET, C#, ASP.NET, HTML, CSS, JavaScript, AJAX, third-party controls (Infragistics, FarPoint), Crystal Reports, SQL Server 2005, SQL Server reporting services, Visual Studio 2005, Visual Studio 2008, CSLA (component-based scalable logical architecture), Agile methodology (SCRUM), Codesmith code generator, Visual Source Safe, Microsoft Team Suite. Projects were delivered on time and within budget.
  • Led teams of business analyst, quality assurance, database administrator, and developers (varying from 3-7).
  • Set software architecture and coding standards.
  • Created project plans, estimates and schedules.
  • Gathered and documented business and functional requirements.
  • Transformed requirements into application designs.
  • Designed databases.
  • Designed prototypes and UIs.
  • Developed code for presentation, business and database layers.
  • Designed and developed data migration from legacy systems.
  • Coordinated testing and deployment.
  • Assisted/mentored team members.
  • Application involved many complex rules and 9 different user roles in a complex work flow.
  • Used fully object oriented architecture based on the CSLA framework.
  • The business layer was developed using Codesmith templates to greatly increase productivity, quality, and standardization.
  • User interface developed using ASP.NET 3.5, Visual Studio 2008 and Infragistics controls.

Confidential, Washington, DC

Senior Application Developer

Responsibilities:

  • Using HTML, ASP, JavaScript, VBScript, ADO and SQL Server, ASP.NET, XML, Web Services and WSE2.0, maintained and added new features to a “shrink wrapped” legal matter management application.
  • Performed major object oriented redesign of the legal matter management application and produced prototypes and proofs of concept in Visual Studio 2005 using ComponentArt controls, AJAX and the Component Based Scalable Logical (CSLA.NET) framework.
  • Completed intensive training course on the CSLA.NET framework.

Confidential, Washington, DC

Senior Application Developer

Responsibilities:

  • Using ASP, JavaScript, VBScript, ADO and SQL Server 2000 maintained and added new features to an application that verified the age and identity of requestors. Application dynamically created a series of searches against very large databases of government and commercial records (such as voter rolls and credit records) and returned results to calling web sites in XML format.
  • Redesigned query generation method so that it improved performance and was more generic and so could query against a large number of different international data sources.
  • Designed databases of international identification information.

Confidential, Rockville, MD

Senior Application Developer

Responsibilities:

  • Optimized the method used to search and page through data used in a financial application, by modifying table structure and indexes and optimizing T-SQL code. Improved time for search from over 3 minutes to 3 seconds.
  • Designed and implemented a new data import method used to routinely import 3.5 million records of financial data. Worked closely with business analysts and vendors of data to modify structure of data. Modified indexes, developed stored procedures and DTS packages. Greatly increased the flexibility and ease of maintenance of the import method while decreasing processing time from 2 days to 40 minutes.
  • Designed and coded a new module to monitor entertainment and gifts received and given by employees of financial institutions. Implemented a complex and flexible rules engine in T-SQL. Developed the front end using HTML, ASP, JavaScript, VBScript, ADO and Visual Basic 6.

Confidential, Beltsville, MD

Contractor - Application Developer

Responsibilities:

  • Tested, debugged and integrated code developed by other programmers.
  • Performed structural database changes and data conversion.
  • Implemented new security model.
  • Liaised with client regarding application specifications.

Confidential, Bethesda, MD

Senior Programmer

Responsibilities:

  • Served as senior programmer on a four-member team to develop a system to manage financial transactions for capital investment firm.
  • Liaised with client to understand work process.
  • Designed database and user interface, and developed code for Web and Windows based cash receipts and accounts receivable modules.
  • Used ASP.NET, VB.NET, ADO.NET, Web Services, SQL Server 2000/T-SQL, JavaScript, XML, CSS, Crystal Reports, and Infragistics controls.

Hire Now