SUMMARY

• Experienced in system design, data architecture and modeling - relational for OLTP systems and multi-dimensional for data warehouses, data governance, master data and metadata management, operational and BI reporting solutions for Confidential 500 IT, banking, insurance and governmental clients.
• Involved in implementing Big Data technologies including Hadoop ecosystem, Enterprise Data Lakes, MPP Databases, and NoSQL storage architecture for semi-structured, and unstructured data.
• Experienced in designing migration and integration solutions for data from disparate sources.
• Developed proprietary methods for metadata management, Data Quality Assurance/Quality Control, Governance policies for governmental clients.
• Experienced in enhancing complex enterprise data models, accurately representing the logical and DB nuances in physical data models.
• Designed data models (ER and dimensional) for database platforms such as Oracle, SQL Server, and DB2.
• Experienced in metadata preparation using modeling and DB tools and validation with respective stakeholders.
• Prepared documentation and conducted walkthroughs on data lineage, system specific data flows, UML Diagrams, conceptual and logical data models for project stakeholders at various levels in the organization.
• Supported Physical data model implementation for relational databases as well as data warehouses, ETL, reporting, and MDM processes.
• Familiar with the concepts of TOGAF and Zachman enterprise architecture frameworks, application development, object-oriented modeling and graph data modeling and data management approaches to Big Data, NoSQL databases, columnar databases, and data lakes and data mining techniques.
• Experienced in business process modeling.
• Exceptional ability to learn and master in new technologies and work under tight timelines.

TECHNICAL SKILLS

• Erwin, ER/Studio, Infosphere Data Architect, XML, UML
• TOGAF 9.0 and Zachman
• Sparx Enterprise Architect.
• Tableau, SAS, Business Objects, SSRS
• Oracle, SQL Server, DB2, Greenplum, NoSQL, Hadoop
• Informatica Data Quality, Informatica MDM
• Informatica PowerCenter, ODI, SSIS
• MS Team Foundation Server, MS Project
• C, C++, Core Java, Python, MATLAB
• ESRI ArcGIS, LP 360
• Visio, ARIS, Bizagi

PROFESSIONAL EXPERIENCE

Data Architect/Modeler

Confidential

Responsibilities:

• Derive data requirements and support solution design and development estimation efforts.
• Profile source systems using SQL queries and Informatica Data Quality to determine data types, data lengths and relationships.
• Determine data security and compliance requirements; data archival and purge policies, data quality and integrity constraints etc.
• Collaborate with architects to review candidate architecture for projects in Enterprise Architect.
• Assess system impacts due to data migration from legacy databases to enterprise data warehouse.
• Involve in architecting data migration and delivery solutions surrounding Hadoop implementation.
• Develop and/or Implement data matching process for attributes to be mastered in Informatica MDM.
• Identify, validate and leverage sources and target database schemas, ensuring conformity and reusability.
• Involve in data lineage and Informatica ETL mapping development, complying with data quality and governance standards.
• Create and enhance future-friendly logical data models and conduct design walkthroughs with internal teams and end users.
• Generate physical data models and DDL scripts for database objects, incorporating enterprise standards and industry best practices for the target database.
• Create and administer database objects such as tables, sequences, history triggers, stored procedures etc., in sandbox environments for preliminary development and testing.
• Support database implementations, performance tuning such as query execution plan, data distribution and partitioning, issue resolution and clean-up efforts.
• Develop VB based ER/Studio modeling tool macros to improve productivity in customizing COTS data models such as Guidewire Policy Center, Claim Center etc.
• Research and develop data management and modeling standards for platforms that support unstructured data such as Hadoop.
• Coordinate with offshore ETL development and testing and reporting teams.
• Document and track data model changes involved in production defect fixes to retrofit database structures across development environments.
• Validate that semantics of data elements being reported align with business requirements.
• Capture, validate and publish metadata in accordance with enterprise data governance policies and MDM taxonomies.
• Perform data model repository check-in and enterprise metadata releases to the corporate portal, MetaCenter.
• Identify confidential and PII data elements and involve in enforcing appropriate protective measures such as tokenizing, masking, redacting etc. for data in flight and at rest.

Data Analyst/Modeler

Confidential

Responsibilities:

• Researched academic and industry literature; evaluated and reported the best processes for QA/QC of spatial data.
• Developed source-specific data quality metrics for GIS data acquisition initiatives from data vendors.
• Developed data requirement matrix surrounding data quality levels for cost-benefit analysis.
• Profiled data using GIS tools as well as SQL for quality assessment and reported on data quality dimensions such as conformity across multiple data subsets, completeness, accuracy etc.
• Involved in developing a proprietary data matching and duplicate record clean-up process using GIS tools, MATLAB programming.
• Cleansed, standardized and integrated data across multiple sources to achieve a single source of truth.
• Involved in developing an in-house MDM capability using ArcGIS and Oracle database.
• Involved in database and ETL mapping enhancements to cross-reference and integrate multi-source datasets under an experimental multi-granular data fusion project.
• Supported database tuning to optimize ArcGIS web service data delivery performance.
• Evaluated and determined the best techniques to derive spatial data products such as digital elevation models, break lines etc., for mapping purposes.
• Developed proprietary data quality control functionality into ArcGIS Python models and plugin scripts to ensure the quality of produced GIS derivatives.

Data Modeler/Analyst

Confidential

Responsibilities:

• Performed logical and physical data modeling using ERwin for Operational systems and Enterprise Data Warehouse, for projects such as Know Your Customer that focused on analyzing clients’ transaction habits.
• Analyzed legacy system; reverse engineered and refined existing data source models by standardizing naming of database objects such as table prefix/suffixes, indexes and relationship names etc.
• Involved incapturing data lineage, table and column data definitions, reference data, valid values, and other relevant information in the data models.
• Applied Data Governance rules (Class words, Abbreviations, Data Domains, Data Definitions, and Metadata Information).
• Identified the affected business processes, the facts & dimensions; grain of fact, aggregate tables as part of data mart design.
• Identified and implemented missing business rules in the database using check constraints & triggers to verify transaction commit rules in coordination with DBAs.
• Migrated data from legacy data management system to Agile PLM system.
• Involved in complete SQL Server Integration Services (SSIS) life cycle in building and deploying packages in Development and Production environments to import and export data to/from spreadsheets, SQL Server tables and flat files.
• Configured daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting issues and handling events and errors using SSIS.
• Coordinated in Performance Tuning (SQL Tuning, Application/ETL Tuning).
• Written SQL queries for data retrieval and testing in development databases prior to migration.
• Used various transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Developed reports such as Parameterized reports, ad-hoc reports, Drill Down, Drill through, Cross tab reports in SSRS.

Business Data Analyst

Confidential

Responsibilities:

• Depicted and documented process flows for several banking products using BPMN 1.1 notation.
• Maintained process models and flows on Sharepoint with versioning.
• Assisted Data Stewards for Account, Party and Reference data in Interviewing data owners and custodians to understand the various data attributes and design the corresponding context diagrams.
• Documented processes and served as an SME for different source systems/core banking products such as Mutual funds, Sanctions, Transaction monitoring, Wires, Loans, Deposits, ACH, Custody etc.
• Assisted MDM architects and solution architects in understanding the relationships among different data domains and data flows into the MDM system.
• Identified, validated and documented critical data elements and their definitions to be published in Corporate glossary.