We provide IT Staff Augmentation Services!

Sr. Data Architect / Data Modeler / Data Analyst Resume

4.00/5 (Submit Your Rating)

SUMMARY:

  • Strong experience as a hands - on Project Leader, Architect, and Developer.
  • Heavy experience in full life cycle of OLAP / Business Intelligence / Big Data / MDM / Reference Data / ODS / Data Warehousing System development.
  • Extensive experience in Financial Industry in Capital Markets, Investment Banking, Fixed Income, Credit Card Banking, Mortgage Banking, and Commercial Banking.
  • Big Data and Hadoop ecosystem.
  • NoSQL and MongoDB.
  • MDM and Reference Data model and architecture design.
  • OLTP and Data Warehousing System architecture and design.
  • OLAP, Query and Reporting Tools administration and programming.
  • ETL and Staging Tools administration and programming.
  • Enterprise Master Data Management (MDM) and Reference Data strategy
  • Data Profiling, Data Quality, Data Governance and Data Stewardship.
  • Enterprise common Metadata modeling and repository.
  • Trouble shooting and Performance Tuning for Database and SQL.
  • Enterprise Data Distribution including SOA service architecture.
  • RAD and prototyping of Data Warehouse and Data Mart.
  • Entity-Relational Modeling, Dimensional Modeling, Data Vault, and UML Object-Oriented.
  • Marketing campaign application development.
  • OLAP and Business Intelligence (B.I.) Methodology.
  • Artificial Intelligence (A.I.) and Machine Learning Methodology.
  • Data Mining tools administration and programming.
  • Methodology of full cycle application development including Agile environment.

TECHNICAL SKILLS:

Language: C, C++, JAVA, XML, HTML, COM, DCOM, Perl, ASP, MDX, SAS, Splus, SPSS, VBScript, Visual Basic, Unix Shell script, MOTIF, VAX DCL, JCL, CLIST.

Big Data & Hadoop: MongoDB. MongoVUE, NoSQL.

Database: ORACLE, SYBASE, Microsoft SQL Server, DB2, UDB, Teradata, INFORMIX XPS, Microsoft ACCESS, IDMS, INQUIRE.

Modeling Tool: ERStudio, IBM Data Architect, ERWin, RationalRose, SAP PowerDesigner.

(R) OLAP & BI Tool: Hyperion EssBase, MicroStrategy DSS Suite, Cognos Impromtu, Power Play, BusinessObjects Supervisor, Designer, WebIntelligence Broadcast, Seagate Crystal Report, Crystal Info, Holos, Microsoft SSAS,SSRS, Excel.

Meta Data: Platinum Repository, IBM Business Glossary, Microsoft Repository, Oracle Designer2000, ERWin, SAS Warehouse Administrator.

ETL Tool: Informatica PowerCenter, PowerMart, PowerConnect, IBM Websphere DataStage, MS SQL Server DTS, SSIS.

Data Mining: SAS Enterprise Mining, BusinessObjects Business Miner.

Platform and Server: UNIX (and derivatives), Linux, MS Windows Server, MVS/TSO, VAX/VMS, OpenVMS, CMS, Apache, BEA Weblogic Server Enterprise, Microsoft IIS, Site Server.

Middleware & Integration Tool: IBM MQSeries, MQSeries Java API, MQSeries Integrator, TIBCO, Microsoft SOAP Toolkit, Microsoft Message Queuing, Biztalk, Informatica PowerCenter Data Integration Hub. IBM Websphere DataStage.

Data Quality: Trillium, SSA, SAS, DataStage.

ERP & CRM: PeopleSoft, Siebel.

Hardware: SUN, HP, IBM Mainframe, IBM RS, DEC VAX, DEC Alpha, Intel.

POFESSIONAL EXPERIENCE:

Confidential

Sr. Data Architect / Data Modeler / Data Analyst

Responsibilities:

  • Designed and architected Confidential enterprise risk / compliance reporting system to support DFAST, CCAR, PPNR with NoSQL and MongoDB in Hadoop ecosystem.
  • Designed and architected integrated eGRC system based on IBM Open Pages, Cognos, and Qlikviews to support government audit and compliance requirement.
  • Developed OFSAA (Oracle Financial Services Analytical Applications) based Risk Reporting System.
  • Designed and architected Confidential MRMS (Model Risk Management System) including Validation Planning, Eligibility Assessment, Technical Validation, Functional Validation, Exception Management, Performance Management, Review Management, Model Change Management, Model Inventory Maintenance and Reporting.

Confidential

Sr. Data Architect / Data Modeler / Data Analyst

Responsibilities:

  • Designed and developed the bitemporal enabled Data Warehousing system to integrate data across different sources including IBM Open Pages, PAWS, RADAR, and Enterprise Master Data (MDM).
  • Designed a NoSQL/MongoDB system to support Compliance Issue Review and Management System.
  • Designed an integrated Enterprise Data Warehouse (eGRC) system to support Confidential ’s requirement for Governance, Risk, and Compliance.
  • Designed and developed IBM BDW based generic structures for storing Classifications, Taxonomies and Ontologies of variable depth and structure with capability to support Bitemporal requirements.
  • Designed and developed a reference hub structure to integrate Confidential enterprise Metadata, Data Dictionary, Business Glossary, and Reference Data including Geographic Locations, Organization Structures, Legal Entity (LEI) Hierarchies, and HR data.
  • Performed Data Analysis and Data Model Validations against Confidential Enterprise Data Model.
  • Designed and developed Reporting Data Models to support OLAP Business Intelligence reporting system.
  • Performed Data Analysis, Data Profiling, and Data Quality checking to support Data Model Validations.
  • Designed and configured systems based on IBM Business Glossary and IBM RDM system to support Metadata management, Reference Data Management, Source to Target Data Mapping, and Impact Analysis.
  • Designed and developed rules and processes to support the best practice of Data Governance and Data Steward.
  • Conducted day to day Database performance tuning and trouble shootings.

Environment: Unix (all flavors including Linux), Windows, ERWin, IBM IDA, SAP PowerDesigner, Oracle, DB2, Sybase, Hadoop, MongoDB, SQL and PL/SQL, IBM BDW, IBM Business Glossary, IBM RDM, Oracle GoldenGate, QlikView, SAS, Informatica, DataStage, Business Objects, Cognos.

Confidential

Sr. Data Architect / Data Modeler / Data Analyst

Responsibilities:

  • Developed enterprise master data (MDM) integration strategy based on business requirement and system integration requirement.
  • Lead Data Modeling team to work with Citi Chief Data Office on developing the Citi Reference Data Model (CRDM), Citi’s enterprise data model and data dictionary, based on IBM’s Banking Data Warehouse (BDW).
  • Performed data analysis and data model validations to support data model integrations with IBM BDW based CRDM system including subject areas of Involved Party (IP), Classification (CL), Arrangement (AR), Event (EV), Location (LO), Resource Item (RI), Product (PD), Business Direction (BD), Condition (CD) etc.
  • Designed and developed MongoDB based system to support document management and data distribution.
  • Analyzed and translated business and technical requirements into an architectural blueprint to achieve complex business objectives.
  • Designed and developed enterprise data architecture layer for enterprise data integration.
  • Designed and developed conceptual, logical, and physical data model for several MDMs for enterprise master reference data repository.
  • Established MDM data governance and steward process framework complied with Confidential Enterprise Data Governance Policies and Regulatory Compliances including DoddFrank, KYC, EDD, FINMA, FRA, FED etc.
  • Designed data model architecture to support Credit Risk Group (CRGID), Credit Approval Group (CAGID), Counterparty Risk and Credit etc.
  • Provided MDM based portfolio integration architecture to support CCAR and Basel III requirements.
  • Lead and chaired MDM data steward meetings on weekly basis.
  • Developed MDM data central to support various kind of client on-boarding process.
  • Designed and implemented database structure and ETL processing to integrate external data from various sources including Bloomberg, S&P, Fitch Ratings, Thomson Reuters, AVOX, Broadridge, Omego, Oasys, GFMA LEI (Legal Entity Identifier).
  • Trouble shooting and performance tuning for database design, SQL, ETL, and OLAP reporting.
  • Designed and developed data distribution architecture including SOA based data services.
  • Designed and developed MDM canonical data model to support SOA based data distribution architecture.
  • Designed and developed ODS and reporting data mart to support downstream application consumers.
  • Analyzed source data across various systems using data profile tools.
  • Developed ETL data mapping and loading logic for MDM loading from internal and external sources.
  • Participated in data steward committee reviewing process to develop data matching, data cleansing procedure.
  • Developed MDM data governess process based on developed rules for MDM systems.
  • Developed Global Data Standardization process for enterprise application integration via SOA.
  • Developed MDM meta data dictionary and naming convention across enterprise.
  • Conducted day to day Database performance tuning and trouble shootings.

Environment: Unix (all flavors including Linux), Windows, ERWin, IBM IDA, IBM BDW, Oracle, Teradata, DB2, MongoDB, MongoVUE, Sybase, Tibco, PL/SQL, Transac-SQL, SAS, Trillium, Informatica, DataStage, Ab Initio, Talend, SQL DTS Packages / SQL Server SSIS, Crystal Report, Business Objects, Cognos.

Confidential

Sr. Enterprise Data Architect / Data Modeler / Data Analyst

Responsibilities:

  • Analyzed the Business Logic and implemented the Conceptual model and Physical Data Model using ERWin.
  • Developed Global Data Standardization process for enterprise application integration via SOA.
  • Designed data profiling strategy to optimize the data extraction and data cleansing process.
  • Designed and built both Data Warehouse and ODS with OLAP system. Dimensional Modeling.
  • Established the best practice in Data Architecture, MDM, CDH, Data Governance, Stewardship, Data Quality/Cleansing, Data Migration, SOA and Business Process Design.
  • Designed and implemented client reference data based on-boarding system.
  • Performed as tech lead on several client data warehousing projects.
  • Managed and successfully delivered several project at different scale level.
  • Responsible for the strategic direction of the technical environment, analyzing data requirements, logical and physical modeling, and analyzing the relationship of the data to the business.
  • Worked as a Business Analyst in the First Phase of the Project.
  • Interfaced with business users and stake holders to collect user requirements.
  • Analyzed data warehouse business requirement to come up with KPIs.
  • Presented Data Warehouse solutions to various clients and executive managers.
  • Designed and implemented Enterprise Data Warehouse with Microstrategy DSS, Cognos, and Business Objects OLAP tools.
  • Designed and developed ETL process using Informatica Power Center, SQL Server DTS Packages, and PL/SQL and T-SQL.
  • Performance tuning of the Data Warehouses, including ETL loading, OLAP reporting, and Databases.
  • Lead DBA team to support Data Warehouse projects from development to production.

Environment: Solaris 2.6, Windows NT, ERWin, Oracle, DB2, Teradata, SQL Server, PL/SQL, Transac-SQL, SAS, Informatica, DataStage, SQL Server DTS Packages / SSIS, Microstrategy, Business Objects, Cognos.

Confidential

Sr. Enterprise Data Warehouse Architect / Data Architect

Responsibilities:

  • Analyzed the Business Logic and implemented the Conceptual model and Physical Data Model using data modeling tools including PowerDesigner, IDA, and Erwin.
  • Identified key Dimension and Fact data elements based on business requirement for customer segmentation and optimization.
  • Developed Global Data Standardization process for enterprise application integration.
  • Developed ETL data mapping and loading logic for data warehouse loading from Internal and external sources including Plan related data, HIPAA compliance data sources, medical records, and pharmacy data coded with ICD9, MedDRA, WHODRUG etc
  • Designed data profiling strategy to optimize the data extraction and data cleansing process.
  • Designed and built both Data Warehouse and ODS with OLAP system. Dimensional Modeling.
  • Established the best practice in Data Architecture, MDM, CDH, Data Governance, Stewardship, Data Quality/Cleansing, Data Migration, Integration and Business Process Design.
  • Responsible for the strategic direction of the technical environment, analyzing data requirements, logical and physical modeling, and analyzing the relationship of the data to the business.
  • Worked as a Business Analyst in the First Phase of the Project.
  • Interfaced with business users and stake holders to collect user requirements.
  • Analyzed data warehouse business requirement to come up with KPIs.
  • Designed and implemented Enterprise Data Warehouse with Microstrategy DSS, Cognos, and Business Objects OLAP tools.
  • Performance tuning of the Data Warehouses, including ETL loading, OLAP reporting, and Databases.
  • Lead DBA team to support Data Warehouse projects from development to production.

Environment: Solaris 2.6, Windows NT, PowerDesigner, ERWin, Sybase, Oracle, DB2, Teradata, SQL Server, PL/SQL, Transac-SQL, SAS, Informatica, DataStage, SQL DTS Packages, Microstrategy, Business Objects, Cognos.

Confidential

Sr. Enterprise Data Architect / Data Modeler / Data Analyst

Responsibilities:

  • Responsible for the strategic direction of the technical environment, analyzing data requirements, logical and physical modeling, and analyzing the relationship of the data to the business.
  • Worked as a Business Analyst in the First Phase of the Project.
  • Analyzed the Business Logic and implemented the Conceptual model and Physical Data Model using ERWin.
  • Designed and implemented Enterprise Metadata Repository used as enterprise standard.
  • Supervised data quality team to implement data profiling and data measurement strategy.
  • Designed and built both Data Warehouse and ODS with OLAP system. Dimensional Modeling.
  • Designed and implemented Enterprise Data Warehouse with Microstrategy DSS, Cognos, and Business Objects OLAP tools.
  • Designed and developed ETL process using Informatica Power Center, SQL Server DTS Packages, and PL/SQL and T-SQL.
  • Performance tuning of the Data Warehouses, including ETL loading, OLAP reporting, and Databases.
  • Lead DBA team to support Data Warehouse projects from development to production.
  • Designed and implemented Enterprise Data warehouse which support multi-languages.
  • Designed and developed Security Strategy for Enterprise Data warehouse and OLAP applications to support worldwide user access.
  • Conducted performance tuning for databases, data warehouse backend as well as front end OLAP reports.
  • Designed and implemented database backup and disaster recovery strategy.

Environment: Solaris 2.6, Windows NT, ERWin, Oracle8/9i, DB2, SQL Server 2000/2005, PL/SQL, Transac-SQL, SAS, Informatica, Trillium, SQL DTS Packages, Microstrategy, Business Objects, Cognos, and Brio.

Confidential

Sr. Enterprise Data Architect / Data Modeler / Data Analyst

Responsibilities:

  • Identify the key business Metrics.
  • Working closely with different departmental business users and understanding the gaps in there process.
  • Understanding the transactional process flow and drawing high-level BI execution plan.
  • Conducting user interviews, gathering requirements, analyzing the requirements.
  • Identifying the source system, analyzing the source system and tying different source system together for conformed dimensionality.
  • Setting up the cleansing rules for the source system.
  • Developing and standardizing the business Codebook.
  • Developing logical and Physical Star Schema.
  • Developing Data Mapping documents.
  • Analyzing and developing the ETL transformation logic.
  • Designed, developed, tested, and tuned standard ETL for data warehouse, data mart and data integration applications
  • Designed and developed the data transformations for source system data extraction; data staging, movement and aggregation; information and analytics delivery; and data quality handling
  • Assisted in gathering source system investigations. Identifying and interpreting source business subject area information, data hygiene and conformity, and system coding schemes. Analysis of business process workflows.
  • Assisted in stage and data warehouse design to support general requirements of reporting needs.
  • RDBMS installation, configuration and tuning
  • Designed, developed ETL procedures for moving data from source to target systems - Teradata, oracle to SQL Server
  • Designed, developed and performed Unit testing procedures for adequately testing per design specifications.
  • Assisted in the development and performance of system test procedures for adequately testing general workflows of ETL procedures to ensure quality.
  • Guided client in a structured evaluation of business rules and gather metadata for data warehouse.
  • Worked with Ascential DATASTAGE(Designer, Manager, Director)
  • Worked with Ascential Server jobs, parallel jobs, dynamic partition, job sequences, containers, shared containers, transformer, aggregator, universe and all kinds of stages.
  • Worked with Ascential Realtime Data Integration
  • Worked with Ascential Parallel Execution engine and Meta data Management, XML Pack, Click Pack
  • For DW and DSS using Informatica and PL/SQL and extract Data, Cleansing, Loading and security strategy for DM and DSS.
  • Worked with Designer, Informatica Server, Meta Data Reporter, Repository Server, Repository Manager, Tranformation Language, Workflow Manager
  • Worked with Source Qualifier, Mappings, Transformation, Mapplets, Session, Batches, worklets and Work flow in Informatica.
  • Worked with Expression, Aggregation, Lookup, Rank, Sequence generator and Store procedure to analysis and develop data loading techniques.
  • Establish auditing procedures to ensure continued data integrity.
  • Assist in post implementation improvement efforts to have performance and increased functionality.
  • Designed MOLAP cubes for multidimensional analysis.
  • Leading the Data Warehouse development effort team.
  • Developed slowly changing dimension attributes.
  • Business Objects universe development.
  • Implemented web interfaces to distribute Business Objects reports.

Environment: Solaris 2.6, Windows NT, SQL Server 2000, Sybase 11.9, Oracle8i, 9i, DB2, Informatica, Ascential DataStage, Cognos, Business Objects 6.0, PL/SQL, Transact-SQL, SQL, ERWIN, Visio and Rational Rose.

Confidential

Sr. Data Architect / Data Modeler / Data Analyst

Responsibilities:

  • Lead system architect and database/data warehouse design for Marketing Management.
  • Provided strategic technology directions for internal/external clients.
  • Designed and implemented data profiling and data quality checking procedures.
  • Designed and developed several Data Warehouses using Oracle, DB2, Teradata, SQL Server, Informatica Power Center, Ab Initio, Microstrategy, Hyperion Essbase, Cognos, Business Objects, PL/SQL, ERWin.
  • Performed project management of a prospect customer management data warehouse project.

Environment: IBM P690, SUN 10000, NT, Teradata, DB2, Oracle8/9i, SQL Server 2000, Trillium, Informatica, BusinessObjects, MicroStrategy, SAS.

Confidential

Sr. Enterprise Data Architect / Data Modeler

Responsibilities:

  • Architected enterprise data warehousing and global application integration architecture.
  • Designed and implemented data integration system with zero-latency technology.
  • Designed and developed enterprise data warehouse and business intelligence systems.
  • Designed and implemented administration and operations procedures for global deployment featuring dimensional replication, dimension change notification, surrogate key administration, and international consistency.
  • Deployed enterprise meta-data management system across the corporation.
  • Conducted project management and database design review on multiple projects.
  • Performed day-to-day management of a DBA team (12 people) and a DA team (6 people).

Environment: Compaq, HP, Oracle, Taradata, DB2, Sybase, SQL Server 6.5/7/2000, Siebel, Informatica, MSMQ, BizTalk, SOAP, BusinessObjects, Cognos, Brio, Trillium, SAS.

Confidential

Lead Data Architect / Data Modeler / Data Analyst

Responsibilities:

  • Architected and implemented a real-time marketing campaign system to support multi-channel marketing campaign.
  • Designed and developed campaign system backend structure to support customer profiling, clustering, segmentation, real-time campaign response tracking, cross-channel campaign offer optimization, close-loop customer touch point, cross-channel campaign media optimization.
  • Helped client to set up the Data Warehouse team by conducting technical interview on candidates for team lead and developer positions.
  • Provided technical guidance on building the Data Warehousing system with business intelligence.
  • Designed and developed ETL process to support data integration from multiple sources.

Environment: SUN, NT, Oracle, Teradata, Sybase, J2EE, SAS, Informatica, Microstrategy, BusinessObjects.

Confidential

Lead Data Architect

Responsibilities:

  • In charge of the Corporate Data Warehouse initiative.
  • Conducted project scope analysis and user requirements analysis.
  • Designed and implemented warehouse structure integrated with Enterprise Portal.
  • Developed dimensional models and aggregation strategy for DSS.
  • Designed and deployed a WEB OLAP reporting system which allow customer personalization.
  • Conducted performance tuning for the warehousing system.

Environment: SUN, NT, Oracle, Teradata. Sybase, Informatica, JavaScript, Perl, SAS, Cognos, Microstrategy.

Confidential

Sr. Data Architect / Data Modeler / Data Analyst

Responsibilities:

  • Architected the ETL process and architecture for a global data warehouse project.
  • Performed technical lead role in the logical and physical design of the data warehouse.
  • Designed and developed the distributed data warehousing system based on warehouse bus concept with conformed dimension and standard facts across enterprise-wide data marts.
  • Designed and developed Informatica mapping and incremental updating/aggregation strategies featuring dimensional replication, dimension change notification, surrogate key administration, and international consistency.
  • Implemented shared Metadata repository using ERWin and Informatica.
  • Designed and implemented database replication strategies for real-time data transformation.

Environment: Mainframe, AIX, HP, NT, Oracle, DB2, Teradata, Sybase, SAS, Informatica, BusinessObjects, MQSeries, Java.

We'd love your feedback!