Respected Data Architect with history of creating system architectures that reduce costs and streamline operations. Ready to create design plans from whole cloth or tackle revamps of disparate networks full of outdated systems. Uses emerging and nascent technologies to create stress-free operations both on site and via remote locations and online.
Hi, I’m
DAVID JAMES
Data Architect
Carlisle,PA
Summary
Overview
27
years of professional experience
Work History
Wipro Limited, Marathon Petroleum
Application Architect
07.2022 - 09.2022
Job overview
- Define and understand current state solutions and identify improvements, options & tradeoffs to define target state solutions
- Clearly articulate and sell architectural targets, recommendations and reusable patterns and accordingly propose investment roadmaps
- Brought knowledge of automation in applications by embracing Agile and Dev-ops principles to reduce manual parts
- Developed application architecture strategy to specifically align with enterprise business goals.
- Implemented robust security measures to protect sensitive data from unauthorized access or disclosure while maintaining compliance with regulations.
- Presented roadmap and technology infrastructure to customers, demonstrating deep familiarity with APIs, platform infrastructure, security and integration capabilities.
- Designed and developed analytical data structures.
Larsen & Toubro InfoTech, LTI
Senior Data Engineer
02.2022 - 04.2022
Job overview
- Define and create data model, tables, views, queries etc
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability
- Acted as trusted advisor for clients by providing thought leadership on best practices in data engineering, ensuring their systems were optimized for performance and scalability.
- Ensured data quality through rigorous testing, validation, and monitoring of all data assets, minimizing inaccuracies and inconsistencies.
- Designed compliance frameworks for multi-site data warehousing efforts to verify conformity with state and federal data security guidelines.
- Analyzed large datasets to identify trends and patterns in customer behaviors.
- Developed polished visualizations to share results of data analyses.
- Enhanced system performance by designing and implementing scalable data solutions for high-traffic applications.
Accenture, LLP
Senior Data Architect
09.2017 - 09.2019
Job overview
- Develop statements of work and/or client proposals
- Provide subject matter expertise to aid in decision making related to Data Governance Frameworks
- Advise clients on industry regulations, standards and leading practices
- Demonstrate strong client and stakeholder management to achieve project objectives
- Championed best practices in data warehousing methodologies, driving consistency across multiple development initiatives.
- Implemented robust backup and recovery strategies, safeguarding critical business information from potential loss or damage.
- Created sets of pre-fabricated systems architecture models for deployment at multiple facilities across enterprise-class organizations.
- Streamlined data storage and retrieval processes for improved productivity with optimized database structures.
- Established and secured enterprise-wide data analytics structures.
- Managed identification, protection and use of data assets.
- Led migration of legacy systems to modern platforms, minimizing downtime and ensuring smooth transitions for end-users.
- Managed multiple complex projects simultaneously, delivering high-quality results within established timelines and budgets.
- Designed internal process improvements to automate repetitive tasks, shortening data delivery times.
- Employed Software-as-a-Service (SaaS) and Platform-as-a-Service ( PaaS) products to reduce initial outlay in systems purchasing 28%.
PHH CORPORATION
Data Governance Architect
03.2016 - 06.2017
Job overview
- Designed and implemented RDM and MDM solutions
- Defined and maintained: match rules, data cleansing rules, hierarchies and affiliations, 'golden' records, managed changes to reference and master data
- Defined corporate data architecture and related standards: data integration architecture, data warehouse and business intelligence architecture, taxonomies and namespaces, data modeling tools and standards, and metadata standards and requirements
- Developed and implemented comprehensive data quality program: established data stewardship structure across business units and IT, profile, analyzed and assessed data quality problems, determined root cause of data quality issues, design and execute remediation plans, defined data quality metrics and business rules, continuously measured and monitored data quality, cleaned and corrected systemic data quality defects
- Provided detailed data modeling and design for all data-oriented development projects: designed logical and physical data models and maintained documentation, conducted source to target data mapping, and created and updated data dictionaries
- Defined corporate data architecture and related standards: data integration architecture, data warehouse and business intelligence architecture, taxonomies and namespace, data modeling tools and standards, and metadata standards and requirements
- Implemented data management controls: developed and monitored conformance to data standards, policies and procedures, managed and resolved data related issues, monitored and ensured regulatory compliance, establish and monitor documentation standards and repositories
- Established and secured enterprise-wide data analytics structures
- Created multi-site system architecture plans to reduce redundancy across entire organization.
- Developed polished visualizations to share results of data analyses.
- Modeled predictions with feature selection algorithms.
- Implemented predictive analytics solutions that drove informed decision-making across the organization.
DEUTSCHE BANK / AFFUSION INC
Senior Business Analyst
03.2016 - 06.2017
Job overview
- Created Functional Requirements documentation that aligned to respective Business Requirements and worked with business and technical management to obtain acceptance of such documents
- Performed all data gap analysis between identified data source Data Models, Internal and External Transactional, Referential, and Market Data Sources, and all Surveillance Model Data Requirements
- Facilitated on-going Actimize Surveillance models' data gap review sessions with global Compliance Directors in order to continually mitigate potential implementation risks
- Developed Trade Surveillance Actimize Model fixes due to documented user issues
- Collaborated with stakeholders to define project objectives and criteria
- Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement
- Conducted interviews with key business users to collect information on business processes and user requirements
- Analyzed key aspects of business to evaluate factors driving results and summarized into presentations.
FULTON FINANCIAL CORPORATION
Director of Data Engineering
09.2014 - 07.2015
Job overview
- Defined corporate data architecture and related standards: data integration architecture, data warehouse and business intelligence architecture, taxonomies and namespace, data modeling tools and standards, and metadata standards and requirements
- Provided regular advice, direction and support to Lead Data Analysts and Data Analysts with hands-on demonstrations of proper techniques and disciplines across all functions
- Delivered Data Governance functions with leading industry practices with thorough understanding of full systems development lifecycle
- Worked closely with organizational leadership and board of directors to guide operational strategy
- Evaluated company documentation to verify alignment with regulatory requirements
- Drafted and distributed reports to assist board members with critical business decisions.
- Championed adoption of cutting-edge technologies, keeping team at forefront of industry trends.
- Optimized data processing by implementing advanced ETL techniques and streamlining data pipelines.
- Enhanced data reliability through rigorous testing and monitoring of data engineering solutions.
- Identified and resolved data-handling errors and hardware conflicts to maintain organizational IMS infrastructure.
- Promoted culture of innovation and experimentation, encouraging team members to explore new ideas and approaches to problem-solving.
- Collaborated with cross-functional teams for seamless integration of new data sources into existing systems.
- Developed customized visualization tools to help stakeholders better understand complex datasets.
BARCLAYS
Senior Data Manager
11.2012 - 09.2014
Job overview
- Developed and maintained strategic partnerships with enterprise-wide data initiatives and business units
- Managed compliance-wide data initiative, consolidating all sourced reference data (i.e., accounts, customers, trading books, market data, aggregation units) data into 1-common and strategic data warehouse
- Provided compliance data subject matter expertise acquired through extensive experience within industry and applied to Barclays' global compliance-owned systems data quality and integrity control
- Spearheaded initiatives to modernize legacy systems in line with evolving organizational requirements and industry best practices.
- Implemented security measures to protect vital business data.
- Played integral role in successful delivery of multiple projects, showcasing exceptional multitasking abilities within fast-paced work environment.
- Optimized storage solutions through capacity planning exercises, reducing overhead costs while accommodating future growth needs.
- Contributed significantly towards meeting organizational KPIs by providing timely analyses of data trends and patterns.
- Set up and controlled user access levels across databases to protect important data.
- Ensured compliance with industry regulations, maintaining strict adherence to data security standards and protocols.
- Collaborated with cross-functional teams to integrate disparate data sources, providing unified view for analysis purposes.
- Improved data accuracy by implementing rigorous quality control measures and data validation processes.
- Designed and developed analytical data structures.
CITIGROUP
Senior Data Architect
04.2010 - 11.2012
Job overview
- Product Owner for U.S Regulatory and Legal ad hoc reporting system
- Provided oversight of all system security controls such as user entitlements to all components of application, deciding on proper system upgrades across various aspects of system architecture, and creating and maintaining system's technology roadmap that outlined 1-year, 3-year, and 5-year system technology future states
- Managed Data Integration efforts for Global Oracle Mantas Surveillance scenario programs and projects Data Integration Team comprised of 15 Data Analysts located globally (U.S., India and China)
- Worked closely with Legal and Compliance Senior Management in creating, tracking and reporting of important technical milestones according to documented program and project plans.
- Collaborated with business stakeholders to translate requirements into actionable data architecture plans.
- Actively participated in regular code reviews helping improve overall code quality across team.
- Evaluated emerging technologies in field of data management, recommending strategic investments for long-term benefits.
- Integrated disparate data sources into cohesive and well-structured data warehouse for advanced analytics capabilities.
- Drafted conceptual and logical data models for high-level system planning tasks, optimizing each model to customers' needs and budgets.
- Enhanced data integrity by designing and implementing robust data models and schemas.
- Unified disparate data structures and operating environments during revamps of processing facilities, data centers and more.
SOCIÉTÉ GÉNÉRALE AMERICAS SECURITIES, LLC
Data Engineer
03.2007 - 04.2010
Job overview
- Performed start-to-finish data analysis and integration between several Transactional, Referential and external Market Data sources
- Developed U.S Global Compliance Data Model, supporting U.S Compliance as well as London and Paris compliance applications Model based upon several factors: Surveillance Model Data Requirements, Existing Data Source structures, ETL Interface capabilities, and use of existing European Compliance Data Model
- Worked closely with Project Management, U.S Compliance Director, and Chief Compliance Officer in creating, tracking and reporting of important technical milestones
- Verified compliance with data retention requirements by managing document catalogues for long-term archival of data associated with contract closeouts
- Troubleshot data-related problems and coordinated maintenance or modifications to correct defects
- Facilitated review and selection of data acquisition citations and applicable standards
- Designed compliance frameworks for multi-site data warehousing efforts to verify conformity with state and federal data security guidelines.
- Developed database architectural strategies at modeling, design, and implementation stages to address business or industry requirements.
- .Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
- Optimized data processing by implementing efficient ETL pipelines and streamlining database design.
- Increased efficiency of data-driven decision making by creating user-friendly dashboards that enable quick access to key metrics.
BEAR STEARNS
QA Leader
03.2006 - 03.2007
Job overview
FINANCIAL INDUSTRY REGULATORY AUTHORITY, FINRA
Technical Project Lead
05.2005 - 09.2006
Job overview
ELECTRONIC DATA SYSTEMS, EDS
Information Systems Analyst
01.1996 - 10.2004
Job overview
Education
Bloomsburg University of Pennsylvania
Bachelor of Science from Business Economics
01.1994
University Overview
Skills
- Rapid Prototyping Integration
- Software Quality Assurance
- Stakeholder Management
- Systems design
- Data Visualization Tools
- Big Data Management
- Data warehousing expertise
- Data Mining
- Business Intelligence
- Data Integration Techniques
- Data modeling expertise
- Data Migration Strategies
- Master Data Management
- Data Architecture Patterns
- Microservices Architecture
- Data Pipeline Design
- Data Quality Management
- DevOps Practices
- Big Data Analytics
Websites
Professional References
Professional References
- Bob Koppenhaveer, (717) 877-4995, bobkoppenhaver@yahoo.com
- Kwon Lee, (202) 340-9494, Kwon.lee1@gmail.com
- Ray McGlew, (484) 824-4604, raymcglew@gmail.com
Quote
Success is walking from failure to failure with no loss of enthusiasm.
Availability
See my work availability
Not Available
Available
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Work Preference
Work Type
Full TimeContract WorkWork Location
On-SiteRemoteHybridImportant To Me
Company CulturePersonal development programsWork-life balanceCareer advancementTimeline
Application Architect
Wipro Limited, Marathon Petroleum
07.2022 - 09.2022
Senior Data Engineer
Larsen & Toubro InfoTech, LTI
02.2022 - 04.2022
Senior Data Architect
Accenture, LLP
09.2017 - 09.2019
Data Governance Architect
PHH CORPORATION
03.2016 - 06.2017
Senior Business Analyst
DEUTSCHE BANK / AFFUSION INC
03.2016 - 06.2017
Director of Data Engineering
FULTON FINANCIAL CORPORATION
09.2014 - 07.2015
Senior Data Manager
BARCLAYS
11.2012 - 09.2014
Senior Data Architect
CITIGROUP
04.2010 - 11.2012
Data Engineer
SOCIÉTÉ GÉNÉRALE AMERICAS SECURITIES, LLC
03.2007 - 04.2010
QA Leader
BEAR STEARNS
03.2006 - 03.2007
Technical Project Lead
FINANCIAL INDUSTRY REGULATORY AUTHORITY, FINRA
05.2005 - 09.2006
Information Systems Analyst
ELECTRONIC DATA SYSTEMS, EDS
01.1996 - 10.2004
Bloomsburg University of Pennsylvania
Bachelor of Science from Business Economics
Similar Profiles
DAVID H. JAMESDAVID H. JAMES
Application Architect at Wipro Limited, Marathon PetroleumApplication Architect at Wipro Limited, Marathon Petroleum
Rajashekhar SarabuddulaRajashekhar Sarabuddula
Power Platform Developer at Wipro Limited (Client - British Petroleum)Power Platform Developer at Wipro Limited (Client - British Petroleum)
Rajashekhar SarabuddulaRajashekhar Sarabuddula
Power Platform Developer at Wipro Limited (Client - British Petroleum)Power Platform Developer at Wipro Limited (Client - British Petroleum)
Austin ShattoAustin Shatto
Landscape Worker at Ben Souders Lawncare and LandscapeLandscape Worker at Ben Souders Lawncare and Landscape
Christyanna M. RhoadesChristyanna M. Rhoades
Processing Specialist- LSP at MOHELAProcessing Specialist- LSP at MOHELA