PROFESSIONAL EXPERIENCE:

Confidential, Bethesda, MD

Senior Data Architect

Responsibilities:

• Co - led (with actuary department staff member) “Data Analytics” strategic project to overhaul the enterprise data analytics capability.
• Was responsible for database administration, database design, data security, data quality, business intelligence (BI).
• Led team of 3 on-site and 2 off-site, data warehousing and BI specialists.
• Conducted extensive data cleanup, profiling and documentation exercise of enterprise data assets.
• Designed integrations between systems (Data warehouse / Legacy claims-policy / New claims- policy / Salesforce).
• Created ideal data model for future claims-policy system.

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.
• Developed POC using Hive, Polybase and HDInsight to read text files.
• 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, MDX, 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 leadership and 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.
• 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.
• Built numerous data integrations between Dynamics CRM, Dynamics GP and Azure SQL databases (DaaS).
• Provided solutions to Master Data Management, Data Quality and Data Governance problems.

Confidential

.NET Architect

Responsibilities:

• Performed initial overall design of “SBIC Web”. The application allows Small Business Investment Companies (licensed venture capitalists) to report financial activity and the Small Business Administration to perform financial analysis.
• Defined software architecture.
• Met with client to gather business requirements.
• Designed database.
• Designed and developed user interface wire frames.

Confidential

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, Embarcadero, Microsoft Project, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), 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 COTS web 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 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

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.

Confidential, Beltsville, MD

Senior Systems Analyst

Responsibilities:

• Regularly performed duties including requirements analysis, database design, program design,programming, testing, documentation, database administration, data manipulation, maintenance and troubleshooting.
• Acquired experience in using a wide range of technologies, including Visual Basic, Visual InterDev, SQL Server/T-SQL, Data Transformation Services (DTS), ASP, HTML, CSS, ADO, VBScript, JavaScript, VBA, Access, Microsoft Office, Windows, and Crystal Reports.
• Designed and implemented programs in a several industries, including: