Dennis C. Email & Phone Number

Boston, Massachusetts, United States

Greater Boston Area

● Leading Pharmaceutical Company, Cambridge, MA – Architect, Contract Manufacturing Organization Expansion- Conducted discovery workshops and interviews; Documented and refined information requirements and system capabilities; Identified gaps and areas of improvement; Created a 3-year roadmap, information specs, and conceptual architecture diagrams● Leading Pharmaceutical Company, Cambridge, MA – Architect, IT Discovery Assessment for Commercial Launch- Conducted IT launch assessments with all business department leads; Created IT/Data conceptual architecture, proposing future-state IT landscape; Created an overall budgetary cost range and estimated time for IT launch roadmap● Duck Creek Technologies, Boston, MA – Data Architect, Enterprise Data & Analytics- Point of contact and trusted team member for all data, ETL, and data warehouse related initiatives● Calliditas Therapeutics, New York City, NY – IT PMO, Commercial Launch- Successfully launched company’s first drug in the US; Reported to CIO; Key member of creating and managing IT budget, strategic plan, IT roadmap, project portfolio, and data governance processes● argenx, Boston, MA – Data Architect, Commercial Launch- Oversaw all data related initiatives in Mastered HCP/HCO/Patient, Medical Affairs, Sales, Marketing, Patient Services, and Compliance; Managed external vendors; Defined and maintain a corporate-wide data dictionary and mappings; Designed and maintain a corporate-wide data flow diagram● Biogen, Cambridge, MA – Data Modeler/Senior Data Engineer- Led a 3-developer team; Point of contact of supporting Commercial Data Warehouse; Provided performance tuning analysis/recommendations for Patient Services

Greater New York City Area

- Oversaw full implementation of a global data warehouse for client’s new accounting system from design, development, testing, through support- Technical point of contact for project planning, architectural planning, data modeling, data profiling, and data analysis- BI/ETL architect managing staff of 10; Responsible for ETL(SSIS) strategy and development, Cognos metadata modeling/report design, and QA- Facilitator/presenter for client’s global meetings and design/training workshops with audience ranging from management to business users- Key contributor to the design of client’s global source control process (git/TFS) and daily operational model orchestrating via Redwood Cronacle

Burlington, Ma

Data warehouse development and support, ETL development and support: SSIS and Datastage, T-SQL, Oracle PL/SQL, data modeling, reporting on SQL Server 2005 and Oracle 9i, MS Access/VBA development

- Trusted contributor of data strategic discussions providing recommendations to project plans and data related topics- Influenced management and technical teams to embrace data profiling and SSIS to improve efficiency and accuracy- Led full lifecycle data migration including data analysis, SSIS/SSRS development, testing, and go-live implementation- Designed data migration SSIS template and trained client’s technical leads to maintain and customize for future projects

Greater Boston Area

Data warehouse development and support, ETL development and support: SSIS and Datastage, T-SQL, Oracle PL/SQL, data modeling, reporting on SQL Server 2005 and Oracle 9i, MS Access/VBA development

Greater Boston Area

- Led full cycle implementation projects from team formation (3 person team), strategic discussions with steering committee, delivery, to support- Led project planning, requirement analysis, data modeling, ETL(SSIS on Azure), report design(Power BI), code review, and implementation- Established team collaboration processes using Bitbucket/SourceTree; performed training for all project teams

Greater Boston Area

- Technical focal point interfacing with the client and providing status communications to multiple levels of management- Led all corporate-level data related tasks including strategic planning, estimates, design, support and training for data warehouses, ETL, and data integration feeds using SSIS/SSRS and DataStage on SQL Server, Oracle, and MS Access- Subject matter expert (SME) for multiple reporting areas with proven business and management skills to meet challenging reporting needs- Developed strong client relationships with senior management, business and technical teams- Led, mentored, and trained remote resources and client teams alike to complete project tasks and knowledge transfer

Greater Boston Area

Data warehouse support, ETL development and support: SSIS and Datastage, T-SQL, Oracle PL/SQL, data modeling, reporting on SQL Server 2005 and Oracle 9i, MS Access/VBA development

● SAP AFS, Apparel and Footwear system- Key member in Project Management Office participating in strategic discussions from blueprint to post go-live support- Maintained project plans; conducted requirement analysis, use case analysis, workflow design; - Facilitated planning and tracking for Unit Testing, Integration Testing, and User Acceptance Testing- Managed and tracked defects and change requests; translated business requirements into system enhancements- Performed data conversion to migrate historical data from legacy system to SAP by using MS Access and SQL Server● Enovia MatrixOne, Product Lifecycle Management system (PLM)- System/Business Administrator for both Production and Development sites responsible for system configuration (JAVA) and ETL processes- Led requirement analysis, information exchange analysis, and testing for PLM SAP interface design- Analyzed, designed, and maintained a costing report & negotiation Access database for Global Sourcing Department- Designed training materials and performed system training sessions for the entire company● RWD uPerform, Training and Performance Support tool- Performed daily routine and maintenance, including account management, troubleshooting, and server monitoring- Designed materials and performed training of the system for all departments● SharePoint, Social Network and Collaboration tool- System/Business Administrator for both internal company sites and external Vendor Connections- Managed multiple project sites to create better knowledge sharing environment and tracking ability

In conjunction with year-long Management Consulting Teams MBA capstone course● Researched and analyzed “content” archiving services and users ● Developed a generalized conclusion through interviews and focus groups using the Healthcare industry as a model● Presented analyses and recommendations to senior management regarding similarities and differences of archiving needs across various industry sectors

● Consolidated company-wide project information in order to create a system for greater efficiency in tracking project lifecycle● Aggregated technology solutions; researched and analyzed best practices in categorizing and tracking product technology solutions● Programmed and implemented the design of SharePoint features to more efficiently manage project repository and technology architecture● Managed SharePoint sites for the Compliance & Legal Department

In conjunction with year-long Business Process Management MBA capstone course● Mapped and analyzed the current IT project costing for tracing and controlling the budget allocation● Presented to senior management with recommendations regarding changes in the documentation process and standardized project procedure to optimize the budget and product performance

Master, Mba - Elkin B. Mccallum Graduate School Of Business

Activities and Societies: VP of Technology, Graduate Information Technology Management Association (GITMA)

Master, Information Technology