SUMMARY:

• Solution - oriented Enterprise Data Architect / Data Modeler / BI Architect with a proven track record of leading, directing, and implementing very large Data Governance, Data Quality, Data Integration, Metadata Management, MDM, BI, Data Warehousing, and CRM projects in Investment Banking, Insurance, and Telecommunication services industry.
• Well-developed interpersonal communication skills and a team player. Experienced in consulting and Self-motivated, quick learner with analytical and problem solving skills, which is persistent when faced with difficult challenges. Skilled at envisioning changes and harnessing the energy of others to bring about company objectives.
• Metadata Management, Business Glossary, Data Quality, MDM, Data Governance, Data Management, Data Security, Data Modelling, Data Integration, Data Conversion, Data Migration, and BI Architect / Modelling (dashboards & reports).
• Metadata Management (better governance - single truth) Data Profiling (better understanding), Data Classification (better security), Data Cleansing (data quality), Data Mapping (better stewardship), and relating data to Business Capability Model (BCM) are my strong area of expertise.
• Hands-on experience of Relational, Dimensional, Object, Semantic, Canonical, Conceptual / Logical, Physical Data Modeling, Business / Technical documentation, SQL Server, ORACLE, Teradata following Agile / Scrum, and RUP SDLC. Have done at Confidential, Confidential, Manulife, Markel Insurance, Dominion General Insurance, Allianz Insurance, Fidelity Investments, BMO Nesbitburns.
• Led, contributed, and participated in studying, analyzing, modeling, designing, and implementing enterprise level Architect of Data Warehouse, OLAP / BI, OLTP, ETL processes, Business Processes Management (BPM) processes, and multi-tiered Client/Server, SOA Architecture, WEB Services, Performance Tuning, and QA testing (UNIT/SIT/Regression/Stress).
• Excellent ability to plan, time, execute, control & monitor and close projects. Skilled in high volume workflow, inter-department coordination, and time management.

TECHNICAL SKILLS:

Modeling: ERWin, PowerDesigner, Visual Paradigm, UML, BPM (Lombardi), Designer 2000, Easy Case Plus, Visio

BI/OLAP: Microstrategy, Business Objects, COGNOS (Imprompto, PowerPlay), ORACLE Discovery

Databases: ORACLE, SQL Server, Teradata, Progress, Sybase, PostgreSQL, INFORMIX

ETLINFORMATICA: (PowerCenter), IDQ, IDE, DataStage, PL/SQL

Coding / Language: PL/SQL, T-SQL, SQL, Pro *C, C, UNIX Shell Script, XML, PHP, HTML, VBasic PHP, .NET, ORACLE Forms 6i, dBase V

Reports Writer: JaseperSoft, Crystal Reports, ORACLE ReportWriter

Tools: MetaManager, ReqPro, ClearCase, ClearQuest, TestDirector, MS Project, SQL Loader, TOAD, PL/SQL Developer, SQL Navigator, DBA Artisen, Visual Source Safe, iMobile Data Synchronization

OS: UNIX (Sun Solaris, HP), Windows Terminal Server, Windows, System/36, DOS

ERP: SAP FI/CO, BW, Business One

Package: Eagle PACE, Maximis, Lawson, Bloomberg (POMS), Charles River, Findur, GuideWire

Framework: SID, OCDM, CLDM, FSDM, FS-LDM, ACORD, TOGAF, ZACHMAN, PMLC, Agile, Scrum, RUP, BPMN, SOA, SSDM, CMM, Six Sigma, ITIL, FIX, ISO, HL7

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Data Architect

Responsibilities:

• Working on Data Strategy and Roadmap to have business oriented / practical Data Governance program and implement MDM, Data Quality, BI/Analytics, Metadata Management, Data Security and Data Integration based on best practices are more practical and useful to Confidential .
• Preparing current resources, models, and structures to be ready to migrate SAP ECC/6 to HANA S/4 in future.
• Working on data migration, B2B integration, data modeling projects for a Healthcare facility in Germany, converting and integrating market data and in-house built data into single reporting platform.
• Converting legacy systems to new industry best practices and canonical data models, adding MDM, Big Data, HL7 aspects too - merging distributed / isolated master data into single MDM view and implementing (single truth) business glossary.
• In last 2 years worked remotely on many project-based assignments for healthcare related international client projects (like SueCos for 4 months, Prestige Medical for 3 weeks, Borns Medical for 7 months, Batz for 3 months, …)
• Did data classification for better data security and aligning their business models and data models with Europe GDPR (General Data Protection Regulation). Wrote many Data Governance roadmaps, best practices, guidelines, and check points many other documents.
• Did data profiling to highlight data quality (could be) issues proactively, missing or incorrect data possible corrections for better reporting and saving money.
• Worked on healthcare HL7 data compliance, data classification, data discovery, cleansing, data quality, and business process modeling for their cloud base EHR system.

Confidential

Data Architect

Responsibilities:

• Worked as a Data Architect on Enterprise Canonical / Conceptual Data Model based on SID, IBM TelcoPack, and CableLabs, using Visual Paradigm modeling tool. Added more extensions and did the message modeling XML data mapping for their major “Darwin” project - switching to NetCraker solutions.
• Created Enterprise level business glossary and data dictionaries. Worked with Business and Technology owners to Collect, Understand and then define business terms and definitions for Enterprise level.
• Assisted solution architects and subject matter experts to use metadata and do the data impact analysis and data profiling on Enterprise level.
• Stitched / Linked Confidential data to Enterprise data dictionaries for better lineage, impact analysis, and single truth.
• Provided strategy and approach to do data classification / taxonomy and how to conform data security and privacy standards, guidelines, and best practices on data attribute level. Provided data controls to be placed, executed, and must be documented for better data access, security, and audit purpose.

Confidential

Sr. Data Architect

Responsibilities:

• Worked as a Sr. Data Architect / Modeler on EDM (Enterprise Data Model) and Subject Areas in aligning and matching with OCDM (Oracle Communication Data Model) entities - Worked on conceptual / logical data models
• Worked on data migration from Teradata to Oracle OBIE environment.
• Worked as a freelancer for different international clients - mainly MDM, data modelling, cleansing, discovery, and data mining projects / tasks.

Confidential

Sr. Data / BI Architect

Responsibilities:

• Worked on EDM (Enterprise Data Model) and Subject Areas in aligning and matching with Teradata CLDM (Communication Standard Logical Data Model) entities
• Worked on Metadata Data Management and Data Management (RDM) strategy, framework, data model, and process management.
• Designed and provided data lineage reports using Informatica tool.
• Designed and Model BI (dashboards and reports) and Data Warehouse metadata models
• Wrote Standards and Guidelines (best practices) for the collecting, consolidating, and publishing business glossary, business metadata, data dictionary, technical metadata, and operational Metadata.
• Build Business Process for better Data Governance and sustainable data management program.
• Provided data policies, standards, and processes based on industry best practices and the company resources and needs to apply standards and better governance.
• Created and Consolidated Subject Area Data Models
• Collected (via interviews) and discovering (via code reverse engineering) metadata / business rules
• Helped in establishing business and technical data steward - their role, responsibility, and their data touch points
• Created high level data context diagrams for the better data lineage and linking.
• Provided MDM (Master Data Management) strategy, roadmap/approach, best practices, and guidelines how to merger parties (customer, suppliers, employees, subscribers, …), locations, and products data?

Environment: / Tools - ErWin, Teradata, Oracle, SQL Server, DB2, Microstrategy, Cognos, Infromatica (PC, IDQ, MetaManager)

Confidential

Enterprise Data Architect

Responsibilities:

• Worked on enterprise level client, broker, and product Master Data Management (MDM) strategy, framework, and data model - merged Europe, Canada, and US data.
• Defined, collect, consolidate, and published business, technical, and operational Metadata.
• Build Data Quality validation, verification, reconciliation, and publishing business rules
• Worked on enterprise data warehouse and other data model consolidation, data dictionary, and business glossary
• Created/Updated EDM (Enterprise Data Model), using Sybase PowerDesigner

Confidential

Enterprise Data Consultant

Responsibilities:

• Worked on B2B and B2C Web data integration project, with an emphasis on data analysis, data architecture, and data quality
• Defined ETL data mapping, classification, and data cleansing rules
• Built data quality test plan and test cases
• Created BPM (Business Process Model), using BPMN notation
• Created ERD, data context diagrams, and data flow diagrams
• Created data dictionary and enterprise level business glossary

Confidential

Enterprise Data Architect / Modeler

Responsibilities:

• Reported to VP of System/Data Architecture. Worked on Data Management Center of Excellence project, which included enterprise data modelling, data governance, data quality, and business process modeling.
• Developed Enterprise Data Standards (including data development, data integration, and metadata).
• Created Data Models (Canonical, Symantec, Logical), Business Process diagram, used BPMN guidelines.
• Worked on XML data models generating XSD, DTD, and XDR files.
• Worked on Policy and Claims data conversion from legacy to Guidewire, studied legacy data and Guidewire data models, draw process diagrams to present as is and to be state.
• Created enterprise level data dictionary and business glossary for underwriting, claims, billing, and finance department users.
• Stitch Underwriting, Claim, and Billing data for complete data lineage and impact analysis
• Used XMeta DB Datastage Repository to collect ETL metadata, including ETL jobs schedule, mapping, transformation rules, source and target data structures.
• Reported to VP of Architecture and mostly worked on strategic projects, such as the Data Management Program that included data modelling, data governance, data quality, MDM, and metadata management functions on priority.
• Worked towards Master Data Management (MDM), an authoritative, reliable foundation for data used across many applications with the goal to provide a single view of the data term and its definition no matter where it is used and/or sourced.
• Worked as data modeler / data architect for various Capital Market asset classes (bonds, equities, real estate, and mortgage), data integration, data quality, pricing, benchmarking, and BI projects. Modeled DW using dimensional schema (star schema, snowflake schema) methodologies. Created semantic, logical, physical, and canonical data models.
• Prepared and maintained system context diagrams, data flow diagrams, entity relationship diagrams, metadata, data mapping, data profiling, data dictionary, and data for Eagle PACE, Bloomberg POMS, E LMS, Lawson, Maximis, Findur, DealGen, and SS&C (reconciliation) systems.
• Analyzed, Architect, and Designed Enterprise DW ETL Model, Source and Target data structures, Data mapping, Data Profiling, Transformation Rules, Data Security rules, and ETL job scheduling.

Environment: / Tools - ERWin, Power Designer, BOXI, IBM Business Process Manager, INFORMATICA (PC, IDQ, IDE), MS DTS, Rapid SQL, ORACLE, SQL Server, Sybase, and Progress

Confidential

Data Architect / Consultant

Responsibilities:

• Worked on enterprise optimization, data conversion, data migration, and cleansing project. Completed data analysis, data integration requirement, profiling, and data mapping for DW ETL processes. Used ER Studio to model existing data model
• Wrote B2B integration GAP analysis, business requirements, data model, and system spec for JAVA WEB based applications.

Confidential

Sr. Systems / Business Analyst

Responsibilities:

• Worked on overnight as well as on-line jobs to settle Fixed Income / Equity trades via ADP BPS (Brokerage Processing System), and Mutual Fund via Spectra ROM-MF
• Worked on RIS (Retail Information System), which Confidential backend Securities Trading system
• Led in analyzing, designing and testing “Qualified Intermediary” project which allowed for meeting the Confidential provisions. Authored business requirement and technical documentation
• Authored “Fee Based Accounts Holdings” report, an electronic file sent to concerned departments quarterly
• Analyzed, designed Sudden Impact Mutual Fund Order on-line verification package, used object oriented methodologies, wrote technical and user documentation.
• Wrote data profiling scripts using ORACLE SQL and PL/SQL.
• Worked with WEB development team to access required information via PL/SQL package.
• Worked on US Tax Withholding and Canada Group RRSP application.

Confidential

Senior Programmer Analyst

Responsibilities:

• Designed, Modelled, and Worked on Data Warehousing, Claims Data Mart, and DSS project. Turned a large volume of data into valuable, actionable business information, built integrated Data Marts for surfacing and retrieving information, used Designer 2000, Developer 2000, ERwin, ReportWriter, COGNOS, ORACLE Discovery
• Worked on Enterprise Data Conversion and Data Migration from legacy systems to ORACLE database using ORACLE PL/SQL
• Analyzed and wrote modular ETL scripts to download main frame Claims data into ORACLE platform, formalizing transformation rules with the help of Business Analysts and users, used SQL Loader, PL/SQL
• Provided quality assurance across the development cycle management commitment, comprehensive standards, continuous review, improved accuracy, increased productivity with the less timeframe
• Worked with DBAs to come up with better performance