Senior Solution Architect Resume
2.00/5 (Submit Your Rating)
SUMMARY:
- Confidential has over 30 years of experience supporting information - driven initiatives for large enterprises.
- He has extensive experience in a variety of front-end development tools, as well as relational database design and administration, and is extremely effective in leadership roles.
- Confidential is a recognized thought leader in data quality, data governance, and master data management, along with enterprise data warehouse architecture and Big Data/Cloud/IoT technology.
- Confidential specializes in translating the needs of business into effective technology solutions.
- Led Data Governance and Technical assessments focusing on tactical improvement and strategic vision in the financial, media, and government industries
- Developed and maintained data integration solutions for major retailers and a major commercial real estate company
- Led effort to design and implement a financial capital attribution model that saved significant staff time and increased accuracy of the solution for a major insurer
- Designed Human Resources, Financial, and CRM data warehouses and data marts to present data in the most efficient way to end users for major insurers, mortgage lenders, and computer manufacturers
- Led design and implementation team in general financial BI solution that efficiently processed over 30 million rows per month for a major mortgage lender
- Led several development teams in successfully implementing CRM solutions under tight deadlines in pharmaceuticals, customer service, and enterprise software fields
TECHNICAL SKILLS:
- Oracle
- SQL Server
- Teradata
- MySQL
- SQL
- HTML
- PHP
- XML/RDF
- Python
- Java, JavaScript
- SAS DM Studio
- IBM Ascential
- Informatica
- ERWin
- Business Objects
- Microstrategy
- Talend
- HP - UX
- Red Hat Linux
- Windows Server
- Mac OS X
- Informatica PowerCenter
- Teradata 13
- MicroStrategy
- Microsoft Windows Server
- DataFlux DM Studio 2.1
- Microsoft SQL Server 2008 R2
- DataFlux DM Studio 2.1
- AIX v5.3
- Ascential DataStage
- Teradata V13
- Ascential DataStage
- Teradata SQL Administrator
- SUSE Linux
- Teradata V12
- Teradata SQL Administrator
- Talend Profiler
PROFESSIONAL EXPERIENCE:
Confidential
Senior Solution Architect
Responsibilities:
- Provided pre-sales support to several Master Data Management opportunities.
- Assisted in completion of Request for Proposal documents for sales prospects.
Confidential
Data Management Consultant
Responsibilities:
- Participated in an analysis of Data Governance and Master Data Management issues in relation to the integration of Business Entity information for the North Carolina Government Data Analytics Center.
- Interviews of major stakeholders were conducted, common themes were organized, and requirements for implementing a Master Data Management system and supporting Data Governance program were delivered to the client.
- Conducted and documented interviews with system stakeholders
- Produced Data Governance documentation
- Produced requirements for Master Data Management system
Confidential
Data Management ConsultantResponsibilities:
- Conducted and documented interviews with system stakeholders
- Produced Data Governance documentation
- Produced requirements for Master Data Management system
Confidential
Data Management ConsultantResponsibilities:
- Participated in an analysis of Data Governance issues in relation to the collection of vehicle taxes for the Confidential, Colombia.
- Interviews of major stakeholders were conducted, common themes were organized, and a roadmap for implementing a Data Governance program was delivered to the client.
- Conducted and documented fifteen interviews with system stakeholders
- Organized observations and interviews into themes and a roadmap for Data Governance program execution
- Documented and presented findings to the client team
Confidential
Integration Programmer
Responsibilities:
- Participated in the implementation of the Data Governance program that was specified in the previous Data Governance Roadmap engagement, described below.
- Conducted and documented follow-up interviews with key players
- Participated in creation of Data Governance Charter, Operating Manual, Organizational Structure, Operating Policies, and Metrics, in concert with Confidential Bank Enterprise Data Governance group
- Provided training materials to key players
- Assisted in installing SAS Data Quality Advanced in a Microsoft Server 2008 Virtual Machine environment.
- Provided guidance during installation process
- Provided an installation run book for future installations
Confidential
Integration ProgrammerResponsibilities:
- Major stakeholders were interviewed for their perceptions of the current state of the solution as well as visions for the future.
- Recommendations were formulated based on these conversations.
- Conducted and documented sixteen interviews with system stakeholders
- Performed fit/gap analysis against industry best practices
- Formulated recommendations based on areas of improvement
- Documented and presented findings to the client team
Confidential
Integration ProgrammerResponsibilities:
- Participated in an analysis of Data Governance issues in relation to an existing SAS Modeling installation for the Marketing Analytics division of the bank.
- Interviews of major stakeholders were conducted, common themes were organized, and a roadmap for implementing a Data Governance program in conjunction with modernizing the modeling environment was delivered to the client.
- Conducted and documented sixteen interviews with system stakeholders
- Organized observations and interviews into themes and a roadmap for Data Governance program execution
- Documented and presented findings to the client team
- Profiled two multi-million record data sets for data quality and unfound matched records
- Integrated a third data set to demonstrate MDM concepts
- Documented and presented findings to the client team
Confidential
Project Leader
Responsibilities:
- Designed, coded, and maintained solutions for On-Demand, Migration, and Real-Time processes
- Educated client on concepts of data quality and data integration
- Assisted in environment configuration and instance migration
- Prepared test data set with random errors introduced to test product effectiveness in handling bad data
- Assisted in producing and gathering results from test cases and vendor questionnaires
- Facilitated vendor presentations
Confidential
Project LeaderResponsibilities:
- Determination of production job scheduling and load order
- Loading of initial data audit data set into Test and Production databases
- Coordination of development standardization activities as result of initial data load
- Documentation of operational metadata, load procedures and development best practices
- Data analysis, profiling, and provisioning using best practice techniques
- Data integration code creation, testing, and implementation
- Assisted in tailoring and implementing project methodology
- Interviewed over 20 business and technology staff members to get a complete picture of the client’s business intelligence infrastructure
- Participated in the preparation of a thorough presentation with the findings of the interviews, fit/gap with industry best practices, and recommendations for further action
- Presented findings to key stakeholders
Environment: s:
- Business Objects
- Oracle 10g
- Solaris OS
