Jamie D. Email & Phone Number

Usa

Senior member of the Business Intelligence ETL team dedicated to the implementation of a first generation enterprise data warehouse project.Roles:ETL architecture designerLoad automation strategist and developerProject team database administratorSkill Sets:SQL Server 2008 R2/2012, SSIS, SSMS, TSQL, BIxPress, Task Factory, Subversion, TFS, Erwin• Develop and support ETL load process for enterprise data warehouse that encompasses 250+ SSIS packages.• Performance tuning responsibilities include code modification and indexing. Reduced execution time of a 7 hour load to 15 minutes and a 10 hour load to 40 minutes.• Led conversion effort of ETL development environment from SQL Server 2008 R2 to 2012, including SSIS packages, auditing framework and code versioning tools.• Analyze, design and implement an incremental load strategy to extract changed data from external vendor’s source database.• Prototyped development environments for replication and change data capture.• Developed ETL solutions to provide reporting data sourced from several third party practice management systems (Allscripts, Flowcast and Groupcast).• Maintained and extended the data model for several projects’ databases using Erwin.

Usa

Primary SQL Developer responsible for design, development, and support of database integration points for third party and internally built applications.Roles:BI Developer – ETL (Informatica, SSIS), Reports (SSRS)Data and Business AnalystJr. Database AdministratorSkill Sets:SQL Server 2000/2005/2008/2012, SSIS, SSRS, SSMS, Informatica, TSQL, DTS, Crystal Reports, MDS, TFSThird Party Applications Supported:Epicor, PAM, Strategy, WallStreet Office, Yardi, Hyperion, Integrat, Saleslogix• Designed, built, and supported ETL processes that addressed data integration needs across all company organization units.• Planned and implemented extensions to the databases used by source systems, operational data stores, the enterprise data warehouse, and data marts. Architecture decisions were made under the mentorship of a Senior Data Warehouse Architect. • Designed, developed, implemented and maintained database objects, including tables, stored procedures, views, functions, triggers and indexes.• Created, maintained, monitored (24/7), and troubleshot SQL jobs and Informatica workflows.• Researched operational issues reported by users, either independently or in conjunction with a business analyst.• Coordinated and managed complex solutions that spanned systems and involved changes to database structures, ETL development, report development, and historical data conversion.• Effective either in independent or team based work efforts. Often filled the roles of business analyst, database developer, ETL developer, database administrator, and system tester on the same project. • Established strong, positive working relationships with user base and provided high level of responsiveness to user concerns.• Performed general database administration functions, such as create, restore, backup, and drop databases; administered server and database permissions; researched blocking issues; created linked servers; and managed and performed production environment deployments.

Usa

Led collaboration efforts between business users and developers to define and implement solutions to address users’ technical needs. Roles:Business and Data AnalysisTechnical Specification WriterQuality Assurance TesterSkill Sets:MS Access, MS Excel, MS Word, MS PowerPoint, MS Visio, VSSThird Party Applications Supported:WallStreet Office, Strategy• Identified and documented business process flows, objectives, and business requirements.• Performed analysis to create functional, reporting, integration, and user interface design specifications.• Executed system testing and facilitated user acceptance testing.• Led user training classes and provided production support.

Bachelor Of Business Administration (B.B.A.), Accounting And Finance

Data Modeling Training Course