Architect/developer Resume
NY
SUMMARY:
- 30+ years of professional experience of designing/building data - centric products and data processing systems/frameworks, for Database/ETL software vendors, financial institutions, Government Agencies…as a
- Software engineer, architect, developer or team lead
- Dataarchitect/developer and/or analyst/modeler
- Motivated, Self-disciplined, Can work independently or within a team, Analytical, Detail oriented, Creative yet focused, Out-of-the-box thinker yet standards-driven, Fast learner, Articulate.
- Architect/Develop Data Integration solutions
- Architect/Develop distibuted, parallel Big Data solutions
- Architect/Develop Metadata driven solutions, for Governance purposes and/or SDLC automation
- Re-engineering: Analyze existing system, evaluate new technologies and plan migration
- Data Integration and sharing techniques: Event driven, batch, cache systems, message driven…
- Data processing and management techniques: Streaming, ETL, data warehousing, data mining…
- Big Data, Distributed Computing and Parallel Processing techniques
- Data Governance and modeling, including logical/physical design. Data migration & mapping
- Metadata Management techniques: Metadata collection, integration, modeling and analysis
- Service (SOA) and Message Oriented Architecture design (MOA, Message Queue)
- Analysis and modeling of many types of data: Large number of financial products, accounts, organizations, customers, trades, market data, campaign data, contracts & loans, foreign exchange, demographics etc.
- Requirements analysis and architecture design
- API design & Integration of components into existing or new systems
- Object oriented, and algorithm design, implementation and maintenance of software systems
- Model Driven or MDA based code generation techniques
- Tool and Technology Evaluation and Selection
- Open Source: Talend, Hadoop, Tomcat, ServiceMix, MySql, Hibernate, ActiveMQ…
TECHNICAL SKILLS:
Programming: Extensive Java and good knowledge of J2SE/J2EE APIs, Extensive C/C++, UNIX system API, including IPC, Signals, IO, threads, XML based technologies such as JAXB, JAXP, XSLT
Scripting languages : UNIX-shell,Python, JSP, PIG…
Database: Extensive knowledge of SQL and no-SQL Database Management Systems
Middleware: SOA, ESB, Messaging, REST
Modeling: ER Modeling, OO Modeling, UML, XML Schema, Relational, hierarchichal, columnar
Data Formats: Tabular, XML, Avro, Parquet, ORC, Key-Value, RDF, JSON, COBOL
Software Products &Tools: Database
Hbase, Sybase, DB2, Oracle, MySql, Redshift, PostgreSQL, Informix, Sql Server,Sybase IQ, Hibernate, XML Databases, RDF Stores, ADABAS, FOCUS…: Integration
Hadoop, Talend, ETI, Informatica, CloverETL,SSIS, ActiveMQ, MQSeries,ServiceMix, Mule, EHCache, Apache JCS (Java Caching System)...: EBIS
Business Objects, Cognos, FOCUS, Eagle PACE, Esbasse, Crystal, Jaspersoft...: Application
Jboss, Websphere, Tomcat, Spring, Liferay…: Productivity
UML design tools, Erwin,ER Studio, Visio, XML-Spy, MS Office, MS Project …: Development
Eclipse, CVS, SVN, Antl, Maven, Make, Continuus, Cmvc…: Other
Jena, Joseki, TDB, Pellet, Protégé, Wordpress, Alfresco, Xwiki…: Operating Systems
UNIX/Linux: CentOS,Debian, Fedora,SunOS, Solaris, AIX, HP-UX, DG/UX, Dynix, SCO, Sinix, …
Other: MS Windows, Some exposure to MVS environment
PROFESSIONAL EXPERIENCE:
Confidential, NY
Architect/Developer
Technologies: Java, Python, Talend, Hadoop, Spark, Redshift,EMR, AWS
Responsibilities:
- Schema-on-read enabled: Metadata is collected from external repositories, the Data Feeds, specified/augmented using Excel spreadsheets, or other mechanisms
- Leverages the Spark framework, as the underlying Data Engine
- Leverages Spark UDFs,and Business Rules developed either in Java or specified using Excel Spreadsheets
- A library of standard Spark UDFs and Map Functions to facilitate the aboove mentioned tasks
Confidential
Responsibilities:
- Configurable, metadata driven and extensible
- EnablesBusiness Analysts to specify Data Quality rules
- Supports Incremental Load for updatesin the source metadata documents
- Performs Versioning on the target database
- Detailed Transformation Lineage and Exception Handling
Technologies: Java, Talend, MySql, non-structered data, metadata, REST, Visio
Confidential, NY
Architect/Developer
Responsibilities:
- A high level Reference Architecture: Layers & Dataflows
- Specification and definition of standard, re-usable Data Operations and Services
- Specification and definition of re-uable Architectural Patterns and Components
- Metdata requirements for a Schema-On-Read Data Lake
- A Programming Model and DSL to standardize and facilitate the development of Data Pipelines
- A prototype implementation leveraging Apache Hadoop components
Technologies: Java, Big Data, Hadoop. Tez, Spark, Scala, Kafka, NiFi, Cascading, Talend, RDBMS, no-SQL, metadata, Data Governance, REST, Messaging, Cloud
Confidential, NY
Principal Architect
Responsibilities:
- Enable new analytical techniques, such as Predictive Analytics
- Enable new technologies, such Big Data and Unstructured Data
- Enhance the existing AML monitoring process and Case Management
- Enhance the Data Quality and Exception Management
- Streamline the existing Data Architecture
- In order to accurately analyze the Current Sttate and facilitate the Governance of the Future State, design and develop a toolset to build and analyze the Data Lineage, based on metadata gathered from a variety of products, including Informatica, ER Studio, Business Objects and several DBMS systems.
- Review and enhance the existing Data Model
- Collaborate to the design of the architecture of the Future State
Technologies: Java, metadata,Data Governance, MetaCenter,Informatica, ER Studio, Business Objects, Big Data, Talend, Apache Hadoop, RDBMS, no-SQL, REST, Messaging, Cloud, AI, NLP, Machine Learning
Confidential, NY
Principal Architect/Developer
Responsibilities:
- Automatic generation of the ETL Mappings from business specifications and Database Metadata
- Extensible Data Feeds with variable layout, as different Systems/Countries/Business Lines collected different data
- Different Business Rules for each Systems/Business Lines/Countries
- Support for different Processing Modes, such as Incremental, Batch, Real Time
- Referential Integrity of the target Data Source, as it is a Transactional System
- Global project covering several Business Lines and types of Securities, including Derivatives, Banking, Fixed Income, Credit Cards, Transfers, Institutional etc.
- Source specific processing customizable by Business Analysts, with no additional development effort
- Data Partitioning to fully leverage the available hardware resources
- Comprehensive Data Quality checks and Exception reporting
- Resilience: Exceptions Management & Recovery from failure
- A Meta-Model to support the Data Migration Framework
- A Meta-Model to capture and version the Data Requirements of the Citi KYC Application
- A process to programmatically generate the required changes to the Data Model
- A process to programmatically generate artifacts necessary to map Legacy Data
- A process to programmatically generate the Data Dictionary
- A process to populate a Metadata Repository used by the Data Migration Framework
- Implement a uniform approach for Primary Keys and Referential Integrity
- Rationalize the Subject Areas and standardize the Naming Convention
- Put in place a process to ensure the conformity of the deployed DDL to the Data Model
- Put in place a process to ensure and assess the coverage of the Requirements by the Model
Technologies: OO Design, Agile Methodology, Parallel Computing, metadata, Data Governance, Big Data, Java, Talend,Apache Hadoop, IBM Infosphere, Message Queue, Hadoop, Spark, Storm, Kafka, REST, no-SQL, Cloud
Confidential, NY
Architect/Developer
Responsibilities:
- Natural language processing and Text Mining
- An Event Processing framework
- Integration with external vendor data and Web Stream
- Integration with Social Networks
Technologies: Java, OO Design, Esper, Talend ESB, MySql, No-Sql, MongoDB, Big Data, Apache UIMA, Lingpipe, Hadoop, Storm, Web Services,Sentiment Analysis, Machine Learning, No-Sql,REST, XML, Message Queue, Cloud
Confidential, NY
Principal Architect/Developer
Responsibilities:
- Process transaction data from 228 different Product Processors, from around the world
- Reconcile with similar results, independently producedby existing processes
- Generate Exception Reports, and facilitate the investigation of potential Breaks
- The Business Rules could be Product Processor specific
- The layout of the Data Feeds, both input and output, could be Product Processor specific
- The resource requirements could be Product Processor specific, as some Product Processors generate a couple of thousand daily transactions, while others more than 10M
- The number and nature of auxiliary or reference data, could be Product Processor specific
- Global project covering several Business Lines and types of Securities, including Derivatives, Banking, Fixed Income, Credit Cards, Transfers, Institutional etc.
- Customization of data feeds, field patterns, and data mapping
- Customization of the Business Rules processing
- Adaptive and/or customizable utilization of system resources: Memory, processors
- Data Partitioning, to guarantee a predictable and optimal usage of system resources
- Multi-processing and Multi-threading
Technologies: OO Design, Agile, metadata, Parallel Computing, Big Data, Java, Talend, Oracle, Linux, Visio
Confidential, NY
Architect/Modeler
Responsibilities:
- Order data collected from all the different SORs: Order creation/modification, Route, Cancel…
- Reports submitted to regulatory organizations: OTS, OATS, DPTR
- Project covering several types of Securities, including Common Stocks, Derivatives, Fixed Income etc.
Technologies: OO Design, ER Studio, SQL, Sybase IQ, SSIS 2008, Visio, MS Office, Microstrategy, Reference Data
Confidential, NY
Architect/Modeler/Developer
Responsibilities:
- A Web interface, topresentthe viewer a uniform navigation of the integrated data
- A Search sub-system, based on Lucene/Solr
- A Data Integration sub-system, to collect and integrate the heterogeneous data
Technologies: OO Design, Agile Methodology, J2EE, Java, Talend, SQL, Pentaho/Kettle, Hibernate, Spring, Orcale, Caching, Together J, Visio, Microsoft Office, Reference Data, Data Integration, Solr
Confidential
Architect/Modeler, New York
Responsibilities:
- The goal of this project was to assess and enhance the performance of a Confidential Data Feed Processing platform
Technologies:OO Design, Agile Methodology, Parallel/Grid Computing, Big Data, Virtualization, J2EE, Java, Linux/MS Windows, JBoss, Spring, Hibernate, Oracle, InfraRED, Java,EHCache, SQL, UML, SOA, ESB, Messaging, Real Time Data
