Data Architect Resume
SUMMARY:
- Highly experienced (30 years) Solution Architect / Data Architect with thorough knowledge of all aspects of implementing Data Management solutions such as DWH, ODS, Data Marts, Data Quality, MDM, Data Profiling, Data Mining, Metadata Management, Big Data, Data Modeling, (3NF, dimensional, Data Object Oriented and NoSQL).
- Competent in all stages of the project lifecycle, from business analysis and data modeling to ETL architectures, performance tuning and analytic applications.
- Experienced in both on - premises and cloud solutions.
- Good balance of technical and management skills, with proven ability to lead complex, globally distributed teams and deliver projects on time and on budget.
- Has been a key player in many projects as Project Manager, Data Warehouse Architect, ETL Architect, Data Modeler, taking care of the architecture and coordinating the activities inside the project team while working hands-on on the most critical aspects of the project.
- Specialized in delivering Data Layer Platform designs and solutions.
- Deliver bottom-line results through designing, developing, and implementing systems to provide improved user efficacy and productivity.
- Consistently completing assigned tasks and projects in a timely and effective manner
- Frequently deployed as turnaround lead on projects experiencing difficulties.
- Respected proven and innovative problem solving skills and ongoing passion for going the extra mile to exceed client and corporate objectives and expectations.
- Well-regarded for mentoring style of team leadership and training. Experienced in both Agile and Waterfall project methodologies.
- Technical expertise in a wide range of operating systems including UNIX, Linux, Windows
- SME proficiency in Oracle Pl/SQL, NoSQL, Perl, Python and Unix utilities programming, MySQL
- Intermediate experience in AWS
- Intermediate experience: Hadoop / Big Data, Hive, HBase, NoSQL, Memcached, Pentaho, CloverETL
- Exceptional communication and team leadership skills in the directing of teams and implementation of business systems.
CORE MANAGEMENT COMPETENCIES:
- Process Improvement
- Staff Technical Development & Performance
- Team Leadership
- Business Analysis / Management
- Mentoring management style
- Project Management & Development
- Project Management
- Effective Communication Skills
CORE TECHNICAL COMPETENCIES:
- Database Architect
- Relational databases (Oracle, NoSQL, MySQL, PostgreSQL)
- Data Warehouse (3NF, OLAP, Data Vault)
- Big Data (Hortonworks Certified )
- Data Modeling (3NF, ODS, Dimensional, NoSQL, OO)
- Business Intelligence
- Data Governance
- Data Profiling
- Data Mining
- Data Management
- MDM
- RDM
- AWS Aurora, RDS, REDSHIFT
- AWS S3, Kinesis, Athena, Glue
- Data Migration and Integration
- EalstiCache, Redis, memcached
- Unix Scripting
- Pre-sales Engineer
T ECHNICAL SKILLS:
Languages: Oracle Pl/SQL, Java, Vision, Perl, Unix programming utilities, Informix RDBMS suite, .NET, C#, SQL/SERVER
Hardware: Unix/Linux platforms (Sun/Sparc, Fuji, HP, IBM), IBM Mainframe, Windows platform
Operating Systems: UNIX, SUN Solaris, AIX, Linux. Windows
Applications: Financial, Investment, Insurance, Banking, Accounting, Project Management, Electronic Funds Transfer (EFT), Inventory Control, Asset Management, Ecommerce, Intranet/Internet.
Database: Oracle, Informix, MySQL, MS-SQL Vision
PC Tools / IDEs: , MS Office, Visio, PowerDesigner, Business Objects, Webgain VisualCafe, IBM VisualAge,, MS PowerPoint
Microsoft Development Tools: MS Project.. MS Visual Studio
I nternet: HTML, Java, JSP, Servlets, Applets, Perl / CGI.
UNIX: Perl, Awk, Ksh, sh, bash., ACE Certified System administrator and System Administration instructor
Web /Graphic Packages: DreamWeaver, Adobe Photoshop, Corel
PROFESSIONAL EXPERIENCE:
Confidential
Data Architect
Responsibilities:
- Design and deploy
- Design Data Architecture Roadmap for international divisions
- Designed GDPR architecture solution for the WEM region
- Architectural oversight of the international data projects.
- Lead for the team of Regional Data Architects for WEM, India, Thailand, Chile, and Andino region
- Design of SSOT/EDW and Data Marts for WEM
- Canonical EDW model
- RDM and MDM
- Design for vehicle policies database for Thailand
- Led effort for implementing Cortex data analytics platform for WEM
- BI Solution Architect
Confidential
Principal Data Architect
Responsibilities:
- Design and deploy
- Design and deploy Enterprise Data Warehouse (AWS RDS / Redis)
- Design and deploy the User Management, and Client Call Data migration
- Executive Dashboard Data Mart
- Design of PII, CCPA, and GDPR compliant encryption implementation
- BI platform Application Architect
Confidential
Santander Bank BI / Data Architect
Responsibilities:
- Design Customer Analytics Research Data Mart
- Sales and Performance Data Mart
- Investments reporting Data Mart
- SparkBeyond and ClickFox Data Science Repositories
Confidential
Lead Architect
Responsibilities:
- Redesign the Retail Data Warehouse and Analytics data marts
- Technical point of contact for the Data Scientist team.
- Designed Sqoop processes for bi-directional data exchange with the Hadoop platform.
- Data Architect and technical overview
- MDM POC Project
- Metadata Repository Project
Confidential
Enterprise / Database Architect
Responsibilities:
- Designing and lead for the Enterprise Data Hub project (Hadoop)
- Spearheading the bank’s Hadoop pilot projects
- Designed the technical solution and database layer for TCPA
- Reviewed database designs for architectural approval
- Technical project manager for all projects and initiatives related to inbound and outbound BDP (Customer Database) data.
- Designed the solution to remedy “dirty/incomplete” data for BDP using MDM processes in conjunction with multiple data vendors
- Redesigned the synchronization and reconciliation processes between BDP (Customer Database) and Legacy Customer systems
- Database Architect - Designed Database Layer for a cloud hosted special education system.
Confidential
Database Architect
Responsibilities:
- Designed A.B.C. and E.E.E. model
- Redesigned Enterprise reporting Data Mart
Confidential
Database Architect
Responsibilities:
- Database architect on Compliance Project. Analysis and redesign of multiple applications database models into a single consolidated database model.
- Designed the Data Landscape repository, designed and executed the ETL processes required to integrate and distill the data 3 separate metadata repositories.
Confidential
Database Architect / project Manager
Responsibilities:
- Database architect overseeing vendor custom Data Warehouse development.
- Managed 8 SA/BA/QA resources
Confidential
Database Architect
Responsibilities:
- Database architect on MDM projects
- Designed and built a configuration driven process to transformer, standardize, partition or pivot a very heterogeneous range of incoming feed files of all expected types regardless of character or code sets, file formats or layouts, to produce a common input format for ETL consumption.
- Designed and built DWH solutions and Datamarts for Commercial and financial company clients.
- Appointed to the position to recover a project which was a year late and over budget.
- Development lead of the Compensation Data Warehouse project mentoring 9 direct reports.
- Conducted JAD sessions with business partners.
- Implemented and enforced Programming standards and Best practices
- Personally oversaw all code reviews and enforced test plans.
- Redesigned the Java Framework of the Java / Oracle architecture.
- Oversaw and participated in Database tuning
- Performed the more complex Unix scripting.
- Contributed to the documentation effort both with content and editing.
Confidential
Project Architect / Project Manager / Tech lead
Responsibilities:
- Project Manager of interactions between local IT, offshore development, production support and the Warehouse vendor.
- Project Manager: Co-ordinated the UAT process for 11 business groups
- Designed the technical UAT parallel solution.
- Core legacy systems migration and (custom) MDM integration.
- DB Warehouse migration: Designed and wrote the file validation toolkit, metrics aggregation and reporting application ( intranet ) for the database migration replacing 3 existing applications.
- Technical lead of the IT development team
- Manager of the UAT issue resolution team
Confidential
Business System Analyst
Responsibilities:
- Health Care Spend compliance: Analyze current state and design future state and migration to 3rd party hosted solution.
Confidential
System Analyst
Responsibilities:
- Unix specialist: Solaris -Linux Migration analysis and implementation.
Confidential
Database Architect / System Analyst / Project Manager
Responsibilities:
- Project manager for the on-boarding of a large Government contract consisting of ~50k provider contracts and the implementation of interfaces into the corporate claims systems and the demographics database.
- User liaison to the business group to analyze and design the solution for loading crosswalk interface data.
- Modeled the solution, designed and managed the implementation of a test plan.
- Worked with the reporting team leading several projects for performance tuning. (Oracle 11g)
- Liaison between internal departments onshore and the offshore team for the integration testing phase.
- Liaison to the offshore team for ETL tasks and the implementation of test plans.
- Business System Analyst / Project manager / Team Lead for the implementation of a CRM On-Demand application
- Led the business analysis phase to gather the business requirements
- Modeled the solution, designed and managed the project.
- Designed and implemented SalesForce to Oracle CRM migration
Confidential
Business System Analyst
Responsibilities:
- Modeled the solution.
- Designed and implemented SalesForce to Oracle CRM migration
Confidential, Cambridge, MA
Systems Analyst / Data Architect
Responsibilities:
- Conducted database evaluation (Sybase, MS-SQL, Informix, Oracle) for satellite fleet monitoring application.
- Gathered the requirements, designed and modeled the database for the FIS application. ( Oracle 11g )
- The system was designed to monitor, aggregated and report satellite data of fleet movements. The target client base was primarily small island countries in the Pacific with neighboring maritime territories where fishing fleets are licensed and billed in units of fishing days.
Confidential, Merrimack, NH
Systems Analyst / Data Architect / Team lead developer
Responsibilities:
- Gather requirements from the users, produce DataMart Model and the business systems analysis and design documents
- Responsibilities: Lead architect for the team of 4 Data Analysts and 5 developers for The Borrowed Fully Paid, Securities Lending projects and Database Migration projects
- Design, model and prototype a Securities Data Prospecting Datamart
- Re-engineer Profit & Loss reporting for performance
- Project responsibility included the mentoring of junior DAs as well as managing the off-shore development team
Technologies: Oracle PL-SQL (10g) Powerdesigner, Toad, Unix, Crystal Reports
Confidential
System Analyst / Lead developer
Responsibilities:
- Gathered requirements from the users and authored the Business Specification Design and Technical Design Specification documents
- Conducted the business and system analysis in partnership with both internal departments and the third-party vendor to produce the systems analysis and design specifications.
- Designed and implemented the database model and application
- Led the team of 6 developers (both on and off-shore) from concept through successful implementation and User training ~50 PM project
Technologies: Oracle PL-SQL (10g) / Java (webservices)/ / XPresso XML middle-layer / Informatica ETL / Unix scripting and Control-M scheduler
Confidential
Lead Developer
Responsibilities:
- Gathered requirements and produced the Business Specification Design and Technical Design Specification documents
- Performed the System and Database design as well as being the lead developer for the project, partnered with the GUI development team for a successful implementation of this 4 person - 12 PM project.
Technologies: Oracle PL/SQL (10g) / UNIX scripting / XPresso XML middle-layer and Control-M scheduler
Confidential
Lead Developer
Responsibilities:
- Team lead and mentor for this 6 PM Confidential enhancement project
Technologies: Oracle PL-SQL / Informatica ETL / XPresso XML middle-layer / Unix scripting and Control-M scheduler
Confidential, Boston, MA
Oracle developer / Unix Specialist / Vision DBA Tech lead & Developer
Responsibilities:
- Designed and developed Oracle SQL and PL/SQL projects and inter-database data feeds
- PL/SQL developer on migration / merge of two equity trading applications
- Business specification, design and development of a Java front-end GUI / Unix / Oracle backend application to query and retrieve MBS data from a vendor’s data site and populate Oracle tables.
- Supported Quantitative analysts with the design and development of new requirements.
- Designed, scripted and implemented disaster recovery plan for the Vision databases and servers
- C# / SQL/Server developer
- Developer on a MQA vendor SQL-SERVER principal database importing and update process
- Designed and developed DTS packages on SQL/SERVER for the QF.NET / MQA application.
- Developer on Quant Platform replacement application
- Developed C# interface to Vision ( OO ) database among other utilities and applications.
- Unix Specialist: designed Perl, Ksh scripting solutions for application and system processes and monitoring, data validation and manipulation and for database imports and EDI.
- Wrote the loading and integration interfaces for multiple pricing, rating, scoring and ranking feeds from financial data vendor providers like Bloomberg, Moody’s, Lipper, S&P, Libor, MorningStar, Thomson Reuters, Factset etc.
- Automated many data feed processes to mission critical database.
- Performed DBA and off-hours and weekend on-call support for the Vision Production system, and was the DBA responsible for the production and Development servers.
- Worked with Quantitative Analysts to design and develop database applications. Tech lead of the DBA team responsible for maintaining and enhancing the data feeds, integrity and security of the mission critical database servicing the Quantitative Analysts and Portfolio Managers research teams.
- In this role undertook most of the complex UNIX scripting solutions, Oracle PL/SQL development and Vision programming.
- Developed ongoing relationships with users and management and conducted business systems analysis for new high visibility projects and initiatives.
- Functioned as team liaison with department managers and vendors to measure systems performance and negotiate escalation support procedures.
Confidential, Andover, MA
DBA Tech lead / Unix Specialist / Vision DBA & Developer / Java/Web developer
Responsibilities:
- Automated many data feed processes to mission critical database. Wrote the loading and integration interfaces for multiple rating, scoring and ranking feeds from financial data vendor providers e,g Bloomberg, Moody, Lipper, S&P, Libor, MorningStar, Thomson Reuters, Factset etc.
- Developed scripting for process and load balancing queues for the resource-intensive month-end processing of Performance Attribution reporting. Subsequently created an Intranet front-end that automated 99% of this intensive manual process.
- Performed DBA and off-hours and weekend on-call support for the Production system, and was the DBA for responsible for a Development/QA server.
- Originated and developed the Vision database server to server copy process that removed the requirement for ~4 hours unavailability / downtime on the originating production server.
- Designed and built several intranet web sites ( Project Management, Performance Attribution, Quant Analysis and Vision System Support) - Java, Html, Perl/CGI, MySQL.
- Instrumental in initiating cross-functional team efforts with department managers and external vendors in supporting systems and implementing best practices to improve the efficiency and timeliness of data feeds and mission critical database updating.
- Developer on SOAP / XML webhouse project to provide seamless access from web-based, client-side GUI applications to, and between, multiple database back-ends (Vision and Fame databases) thereby integrating market and portfolio data for equity and fixed income universes.
- Developed Vision code to support the server-side Soap Server requests
- Streamlined legacy Vision database queries to web-acceptable access response times. Response time improvements typically between 300% and 15000%
- Developed Servlet, JSP and Applet based applications for Valuations and Recommendations, Equity and Convertibles research and Returns reporting
- Developed SOAP/XML modules and the Vision database interface access module.
- Developed SOAP based cross-database access functions to enable seamless access of FAME database data directly from within and integrated as part of Vision database queries.
- Tech lead of the DBA team responsible for maintaining and enhancing the data feeds, integrity and security of the mission critical database servicing the Quantitative Analysts and Portfolio Managers research teams. In this role undertook most of the complex UNIX scripting solutions
- Lead developer on a Java SOAP/XML service accessing the Vision database as part of a corporate Data Webhouse project.
- Designed and developed several intranet based systems to provide MIS reporting, Project management, database related system monitoring, inter-user communication, a user-driven month end processing of Portfolio Performance Attribution.
- Developed ongoing relationships with users and management and conducted business systems analysis for new high visibility project and initiatives.
- Functioned as team liaison with department managers and vendors to measure systems performance and negotiate escalation support procedures.
Confidential, Burlington, MA
Senior Consultant
Responsibilities:
- Developed new training courses and course materials for Transact - Confidential ’s E-commerce Back-Office product.
- Developed training materials for the Data Warehousing product - Oracle database.
- Used TCL/Expect to automate testing and installation processes of the Data Warehousing suite.
- Provided Unix technical support to the Installations team
- Conducted Train the Trainer and client training
Confidential, Billerica, MA
Senior Consultant / Technical team lead
Responsibilities:
- Designed and wrote customized solutions to supplement the Peritus Confidential Renovation software product for clients.
- Developed parsing scripts for and processed Confidential evaluation of INFORMIX database and 4gl and the associated ETL feeds
- Applications: Municipality Titles and Registrations Database (Online), Law Firm (Informix SE)
- Unix specialist and tech lead for a team performing Confidential renovation of Cobol applications (5 programmers)
- Applications: Investment banking, Life Insurance, Banking, ERP, Accounting applications
- Trained clients in the use of the Peritus Confidential Renovation suite.