We provide IT Staff Augmentation Services!

Sr. Data Architect Resume

Memphis, TN

SUMMARY:

  • 9+ years of ETL and data modeling experience in developing ETL mappings, architecture, development, implementation and scripting with multi - terabyte data warehouses and high availability transaction processing systems.
  • Successfully delivered 25 Data Warehouse/ Business Intelligence projects with 15 clients in Pharmaceutical, Financial, Banking, Retail, Mortgage, Health Care, Logistic, Telecommunication and Insurance Industry.
  • Expert Enterprise Data Modeler with a deep understanding of developing transactional enterprise data models that strictly meet normalization rules, as well as enterprise data warehouses using Kimball and Inmon data warehouse methodologies.
  • Experience defining enterprise data location architectures for EDW, Datamart, and ODS data.
  • Experience defining ETL and system integration architectures combining data from disparate source systems and disparate data formats.
  • Proven ability to interface and coordinate with cross functional teams and cultures, analyze existing systems, wants and needs, design and implement database solutions.
  • Large-scale logical and physical data modeling using Erwin, Powder Designer and ER Studio; Analysis, design, and development of data Extraction, Transformation, and Loading (ETL) using Informatica, and OLAP reporting applications using Cognos.
  • Recognized project management expertise including leading JAD sessions, facilitation, problem resolution, planning, scheduling, and achievement of end-item objectives.
  • Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement.
  • Experience in List, Sub and Cross-Tab reports using Impromptu and distributed Catalog to users for Ad-Hoc reporting and analysis.
  • Extensive experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
  • Experienced in developing UNIX Shell and Perl Scripts for automation of ETL process.
  • Experience in performance tuning of Informatica Sources, Targets, Mappings, Transformations & Sessions.
  • Experienced in Star-Schema data modeling, Normalization, Data Profiling, Data Cleansing, Logical and Physical data model design process
  • Experience in integration of various data sources like Oracle, SQL server 2005/2008 and Teradata into staging area.
  • Extensive experience in conducting requirements analysis and architecture design of OLTP (On-line Transactional Processing) and DSS (Decision Support Systems).
  • Expertise in canonical, conceptual, logical and physical data modeling using ERWin, ER/Studio and Power Designer.
  • Performed source system analysis, data profiling, data cleansing, metadata creation and management, and data integration of ODS & Data Warehouse systems.
  • Experience in dimensional modeling and ETL design.
  • Implemented standards & guidelines for Enterprise Data Architecture (data models, tools & databases).

TECHNICAL SKILLS:

ETL: Informatica Power Center 9.2/9.0/8.x/7.x/6.2, SSIS, MDM

Reporting Tools: Cognos 8.4/8.0, Brio, Tableau

Programming Languages: MS.NET, HTML, Perl, Unix Script, XML, XSD

Database: Oracle 9i/10g/11g, SQL Server 2008/2005/2000 , NoSQL, Teradata, Hadoop

Data Modeling: ERwin, ER Studio, Sybase Power Designer

Operating Systems: Sun Solaris 8, Win XP/2000 and UNIX

Code Control Tools: SVN, Rational Clear case, TFS

PROFESSIONAL EXPERIENCE:

Confidential, Memphis, TN

Sr. Data Architect

Environment: ER/Studio 11.0, Visio, Oracle 11g, PL/SQL, DB2, Metadata Hub.

Responsibilities:

  • Led business and functional requirements gathering with SMEs (Subject Matter Experts), business users and senior management in Confidential .
  • Dissecting problems and suggesting solutions, including complex systems process analysis, design, and simulation.
  • Interview customers to identify system needs
  • Perform usability studies to recommend user interface and reporting changes
  • Leverage knowledge of IS solutions and business support improvements as well as industry requirements to identify, propose, and influence customer business solutions
  • Document user needs identify systems impacted by necessary changes
  • Participate in continuous review and update to ensure that processes meet changing business unit conditions
  • Developed Business Data Model (conceptual & logical data model) to support the current & strategic business needs.
  • Created the Enterprise Business Data Dictionary and associated metadata.
  • Defined conformed dimensions, bus matrix for the EDW.
  • Designed the EDW Model for multiple subject areas; Shipment, Customer, Geographic, Facility, Route, Conveyance, Sales etc using Kimball’s Methodology.
  • Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
  • Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.

Confidential, Lee’s Summit, MO

Sr. Enterprise Data Architect

Environment: Erwin, Visio, Oracle 10g, PL/SQL, SVN, Hadoop, NoSQL Cassandra.

Responsibilities:

  • Understand and translate business needs into data models supporting long-term solutions.
  • Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
  • Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
  • Optimize and update logical and physical data models to support new and existing projects.
  • Maintain conceptual, logical and physical data models along with corresponding metadata.

Confidential, Madison, WI

Lead Data Modeler/Architect

Environment: Sybase Power Designer, Visio, Oracle 11g, PL/SQL, Teradata, MongoDB.

Responsiblities:

  • Understand and translate business needs into data models supporting long-term solutions.
  • Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
  • Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
  • Maintain conceptual, logical and physical data models along with corresponding metadata.
  • Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
  • Evaluate data models and physical databases for variances and discrepancies.

Confidential, Northbrook, IL

Lead Data Modeler/Architect

Environment: Erwin, Visio, Oracle 11g, PL/SQL, Teradata, BigData, Informatica.

Responsibilities:

  • Worked with Business Analyst and business users to clarify requirements and translate the requirement into technical specifications.
  • Reviewed and documented policies on PK, FK, related indexing, naming conventions, data typing, defaulting and the consistency of their implementations.
  • Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
  • Developed a detailed conceptual model for the company's sales and marketing using Erwin; modeling sources included existing reports, data structures, and XML schemas.
  • Rescheduling specific ETL processes when there is one such requirement, Work with System Administration on backups/image copies.

Confidential, Seattle, WA

Sr. Data Modeler

Environment: ER/Studio, Visio, Oracle 11g, SQL Server 2012, PL/SQL, Cognos.

Responsiblities:

  • Lead and direct enterprise-level strategic engagements for GHC healthcare payer clients; a typical strategic engagement will catalog the current state of the customer’s vendor and product portfolio, gather future state requirements for this customer.
  • Lead and direct tactical engagements, which will require expertise in detailed design and implementation of database and business intelligence technology components and oversight through all phases of the SDLC
  • Design and create a vision for a solution and then translate the solution into a logical and physical data model culminating in end-state solutions
  • Evaluated and made recommendations on various data warehousing tools and components.
  • Collaborated with Network Services and others on the selection of hardware, software and storage products.
  • Coordinated the development, integration, administration and evolution of the data warehouse and data marts with other GHC teams and customers/users across the institution.
  • Served as the general Data Architect on the GHC Architecture Working Group (AWG) helping build strategic artifacts, reviewing products, and conducting design peer reviews as requested.
  • Mentored other GHC staff in best practices to support the strategic information architecture as appropriate.
  • Monitored the performance of published BI tools (dashboards, scorecards, etc.), and responded to user needs and questions.
  • Deliver quality work on time despite multiple, competing priorities

Confidential, Woodland Hills, CA

Sr. Data Modeler

Environment: Erwin 9, Visio, Oracle 11g, SQL Server 2012, NoSQL, Hadoop.

Responsiblities:

  • Created a robust, sustainable architecture that supports requirements and provides for scalability within budgetary constraints and availability of data and skilled resources.
  • Interact with Business Analysts & end users to get the functional requirements & business intelligence needs.
  • Conduct interviews, brain storming discussions with project team to get additional requirements.
  • Perform in-depth source data analysis and data quality
  • Design the Logical Dimensional Data Model for Claims, Providers, Products, Member/ Group Enrollment, Customer Service & Billing subject areas using Kimball’s Methodology.
  • Developed metadata definitions and models and maintains appropriate data dictionaries.

Confidential, Princeton, NJ

EDW Architect

Environment: Erwin 9, SVN, Visio, Oracle 11g, ODI 11g, SQL Server 2012, XML.

Responsibilities:

  • Participated in requirement gathering session with business users and sponsors to understand and document the business requirements as well as the goals of the project.
  • Analyzed monthly/weekly billing data to determine accuracy of chassis pool usage billing
  • Analyzed existing logical data model (LDM) and made appropriate changes to make it compatible with business requirements.
  • Understand the project proposal and assist the team in analyzing how the new system or functionality can be integrated in the environment, identifying existing systems, concepts, possible data sources and issues.
  • Developed Business Data Model (logical & physical data model) to support the current & strategic business needs.
  • Provide support in database architecture of the organization through database design, modeling and implementation
  • Partner with all other teams (database management team, software development team, designers) and users to provide best solutions by maintaining the best standards of practice
  • Analyzed the source system to understand the source data and table structure along with deeper understanding of business rules and data integration checks.
  • Identified various facts and dimensions from the source system and business requirements to be used for the data warehouse.
  • Maintain and prepare documentation of the data architectural process and progress
  • Implemented thorough testing of all programming to identify and correct errors.
  • Ensured data cleaning and layout met defined parameters.
  • Ensured data accuracy across application interfaces by documenting ETL job process flow and communicating necessary application recovery procedures to team members and members of interfacing IT staffs.
  • Created Excel charts and pivot tables that provided management with critical line status information.

Confidential, West Chester, PA

Sr. Data Modeler

Environment: Sybase Power Designer 16.2, Informatica 9.2, Visio, Netezza, Oracle 11g, AQT, XSD, ESB.

Responsibilities:

  • Analyzed existing logical data model (LDM) and made appropriate changes to make it compatible with business requirements.
  • Developed and implemented strategies, policies and standards for data architecture in the enterprise.
  • Work closely with business users and SME to understand information requirements. Performdata analysis for source system data. Translate business requirements into functional and technical specifications to enable the design process.
  • Participate in evaluating requirements, working with developers, business analysts, business stakeholders, and product managers to provide solutions to end users.
  • Understand complex data flows, data dependencies and relations, and develop a database design which can support business needs
  • Developed strategies for warehouse implementation, data acquisition, and archive recovery. Established and documented data standards and policies.
  • Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines
  • Resolved data issues and assisted in data cleansing.
  • Designed and integrated new features into existing database sub-systems.
  • Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems.
  • Developed approaches and frameworks for the enhancement of data quality and integrity
  • Identified the high level data cleansing requirements that informed the teams as to the steps that will have to be made to facilitate the enterprise-wide solution, developed the migration plans from development to test to production.

Confidential, Columbus, OH

Enterprise Data Warehouse Architect

Environment: Erwin r8, Visio, Teradata v12, Oracle 11g, TFS, Control M, SQL Server2010.

Responsibilities:

  • Developed Business Data Model (conceptual & logical data model) to support the current & strategic business needs.
  • Created the Enterprise Business Data Dictionary and associated metadata.
  • Developed and delivered classes in beginning, intermediate, and advanced logical and physical data modeling and the use of the ERwin modeling tool.
  • Eliminated errors in ERwin models through the implementation of Model Mart (a companion tool to ERwin that controls the versioning of models).
  • Defined conformed dimensions, bus matrix for the EDW.
  • Managed data model revisions through change control process.
  • Worked with various business units to confirm that the data warehouse would provide the enterprise wide view that was expected.
  • Helped to plan and implement data quality using said data profiling and data cleansing tools
  • Designed, Developed and test Strategies for Environment.
  • Managed database and application integration points to ensure product integrity.
  • Maintained and enhanced metadata QA methods and identify and track issues to resolution when found.
  • Assist the organization in performing data compiling, mining and analysis required to evaluate the given data.
  • Maintain the research database, update and upgrade it from time to time and ensure safe storage of data.
  • Prepare analysis reports and be responsible to answer any queries, complaints or suggestion in this regard.
  • Collect data in form of reports from different departments of the organization and compile them together to prepare a summarized report.

Confidential, Dublin, OH

Sr. Data Architect/Modeler

Environment: Sybase Power Designer 15.2, Informatica 9.0, Visio, MDM, Teradata, Oracle 11g.

Responsibilities:

  • Created a robust, sustainable architecture that supports requirements and provides for scalability within budgetary constraints and availability of data and skilled resources.
  • Worked on Requirements Traceability Matrix to trace the business requirements back to logical model.
  • Interacted with Business Analysts & end users to get the functional requirements & business intelligence needs.
  • Conducted interviews, brain storming discussions with project team to get additional requirements.
  • Performed in-depth source data analysis and data quality
  • Discovered, adviced, advocated closing significant model quality gaps between logical data models and physical data models.
  • Designed the EDW Model for multiple subject areas; Performance Facts, Sales, Enterprise Product Costing, etc using Kimball’s Methodology.
  • Designed the Logical and Physical Dimensional Data Model for Providers, Products, Invoice and Billing subject areas using Kimball’s Methodology.
  • Developed metadata definitions and models and maintains appropriate data dictionaries.
  • Developed and architected customized strategies for ETL environment like Restart Strategy, Reload Strategy, Recover Strategy, Load Strategy etc.
  • Designed the ETL Standard Process using the concept of Runtime Column Propagation and Multiple instances created re-usable common components and standardized the code implementation.
  • Designed overall data quality, including the design of ETL strategies to source, match, and merge from various disparate systems.
  • Established and maintain best practices for ETL source code control and metadata access.
  • Developed technical designs and build workflows, mappings, shell scripts, stored procedures, clearly documenting the process to set as the bench mark for the ETL & Data Team.
  • Developed ETL processes, queries, reports, schedules and work processes
  • Implemented proper backup and recovery processes and maintenance procedures.
  • Initiated and implemented a meta-data project and repository that provided a single point of reference for information about data resources of projects both implemented and under development. Resulted in better understanding of the data available, encouraged data consistency, data reuse, and attempted to reduce data redundancy.
  • Defined the enterprise metadata requirements and enterprise data strategy including defining, clarifying, and set the standards for implementing the Enterprise Data Architecture, Data Strategy, Definitions, Business Architecture, and Security Architecture.
  • Defined data management strategies and standards; addressed issues of data ownership and governance and MDM process design for data import to MDM as well as supervise design, configuration.

Confidential, Portland, ME

Enterprise Data Warehouse Architect

Environment: Erwin, Teradata, Informatica 8.0, SQL Server 2008, Windows 7, Visio, Putty, ESB.

Responsibilities:

  • Responsible for the Claim Data Model, the Enterprise Client/Server Case Tool, CASE methods and procedures, development of data models and reverse engineering of production systems.
  • Provided a data architecture designed to eliminate discrepancies in managerial and legal results.
  • Provided Current Process Workflow analysis, Business Function/System Matrix, Data Inventory and Data/System Matrix.
  • Designed Metadata Repository providing mappings between all logical models, physical models, databases, processes and activities.
  • Provided data models and data maps (extract, transform and load analysis) of the datamarts and feeder systems in the aggregation effort.
  • Logical and physical database design for an OLTP internet business to business communications and information system designed to help Claim and Leave management data model.
  • Developed and architected customized strategies for ETL environment like Restart Strategy, Reload Strategy, Recover Strategy, Load Strategy etc.
  • Designed the ETL Standard Process using the concept of Runtime Column Propagation and Multiple instances created re-usable common components and standardized the code implementation.
  • Designed overall data quality, including the design of ETL strategies to source, match, and merge from various disparate systems.
  • Establish and maintain best practices for ETL source code control and metadata access.
  • Developed technical designs and build workflows, mappings, shell scripts, stored procedures, clearly documenting the process to set as the bench mark for the ETL & Data Team.
  • Developed strategy for Data Validation, Errors and Exceptions Handling.
  • Performed analysis of the given data and draw accurate inferences, in accord with the objectives of the analysis
  • Determined the methodologies and procedures for carrying out effective data analysis. Provide training to the staff members on the new systems implemented
  • Evaluated the given problem, situation and crisis; investigate for solutions using data analysis practices and prepare analysis reports
  • Resolved data issues and assisted in data cleansing.
  • Developed approaches and frameworks for the enhancement of data quality and integrity
  • Identified the high level data cleansing requirements that informed the teams as to the steps that will have to be made to facilitate the enterprise-wide solution, developed the migration plans from development to test to production.

Confidential, Albany, NY

Data Architect/Modeler

Environment: Erwin, Oracle 10g, PL/SQL, SQL Developer, Windows NT, Visio.

Responsibilities:

  • Participated in requirement gathering session with business users and sponsors to understand and document the business requirements as well as the goals of the project.
  • Created and reviewed the conceptual model for the EDW (Enterprise Data Warehouse) with business users.
  • Worked with cross-functional teams and prepared detailed design documents for production phase of current customer database application.
  • Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model.
  • Reviewed the logical model with application developers, Rhapsody Team, DBAs and testing team to provide information about the data model and business requirements.
  • Published Data model in model mart, created naming convention files, co-coordinated with DBAs to apply the data model changes.
  • Designed and implemented the logical and physical data models, lead development efforts of stored procedures, triggers, and SQL queries.
  • Led development effort of the logical and physical data models to meet the needs for The HAvBED and UPHN business requirements.
  • Defined system and software architectures to support business requirements.
  • Responsible for the development, care, and maintenance of logical and physical ERwin data models, along with corresponding metadata, to support DOH Online Applications.
  • Facilitated information gathering and modeling sessions with subject matter experts to validate and enhance the models
  • Reviewed corporate standards and models, as well as logical and physical data models and definitions of existing and proposed applications
  • Wrote standards for logical modeling and the deployment of the ERWin data modeling tool

Confidential, Charlotte, NC

Data Warehouse Consultant

Environment: Informatica 7.1, Teradata, Oracle 10g, PL/SQL, SQL Developer, Windows NT, TOAD, Sybase Power Designer 15.0.

Responsibilities:

  • Prepared Scope document and Software Requirement Specifications (SRS) document.
  • Making Use Cases using UML methodology, Rational Requisite Pro and Rational Rose as well as conceptual and detailed design documents.
  • Eliciting requirements through various techniques like JAD sessions, Introspection, Interviews, Protocol analysis, Prototyping and reviewing existing documents.
  • Responsible for developing Software Development Plan as described by the RUP methodology.
  • Understanding business and existing IT applications and designing a road map for further software development.
  • Assisting internal business partners and technical teams to define and refine business strategy and supporting operational processes.
  • Mapping business requirements for process enhancements and translating these requirements into functional specifications.
  • Managed the ETL Onsite Design Team & Offshore Development Team
  • Reviewed design and development work from offshore including code reviews
  • Implemented Pre-processing, Post processing, Reject, Reload, Monitoring & Balancing Strategies
  • Implemented Error Handling, Data validation strategies across all the ETL Processes.
  • Performed end to end analysis of business rules, functional design and technical design of terabyte-scale data warehouse applications.
  • Developed Business Data Model (conceptual & logical data model) to support the current & strategic business needs.
  • Created the Enterprise Business Data Dictionary and associated metadata.
  • Developed and delivered classes in beginning, intermediate, and advanced logical and physical data modeling and the use of the power designer modeling tool
  • Defined conformed dimensions, bus matrix for the EDW.
  • Worked with project team representatives to ensure that logical and physical Erwin data models were developed in line with corporate standards and guidelines

Hire Now