We provide IT Staff Augmentation Services!

Information Architect (tcs Consultant) Treasury Department Resume

Charlotte, NC

SUMMARY

  • Specialized in data analysis, modeling and database system implementation with a strong working knowledge of traditional transaction - based (OLTP) systems.
  • Extensive knowledge of data modeling techniques and CASE tools for Entity Relationship (IE) modeling.
  • Expertise includes: Data Modeling, business rules analysis, database coding, implementation, data collection, analysis, and reporting from a variety of sources including mainframe files, and vendor extracts.

TECHNICAL SKILLS

  • Oracle Designer
  • Visual Basic 6.0
  • Crystal Reports
  • MySQL 4.1/5.0
  • Oracle 11g Database
  • DB2 i Series Database
  • PL/SQL
  • CA Erwin 9.8 Group wise
  • MS SQL Server 2008
  • SQL Navigator
  • Excel 2007 VBA
  • Toad for Oracle
  • Toad for SQL Server 2008
  • Perl V
  • SSIS 2008
  • Confidential IDA 9.2

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Information Architect (TCS Consultant) Treasury Department

Responsibilities:

  • Maintain project data mapping specification and data models (Logical and Physical) in Power Designer.
  • Ensure the project models are align with the entire collection of models and databases.
  • Created mapping specification for ACH, Federal Reserve Reporting and Sanctions projects.
  • Created Views, mapping specification for Real Time Payments (RTP) messages.
  • Created Indexes for (RTP) in NoSQL Elastic Search Fast Path API Jason.

Confidential, New York, NY

Senior Data Modeler (EEI Consultant)

Responsibilities:

  • Maintain data standards, definitions, and data models (Logical and Physical) in Power Designer. e.g. Data Dictionary, Business glossary and Domains.
  • Experience in developing, validating, publishing and maintaining Conceptional, Logical and Physical data models in DB2.
  • Analyze existing database schema DDL/instance layout and determine impacts migrating to new target schema/instance environment.
  • Experience with normalized data modeling as well as experience implementing Bi-Temporal data models.
  • Ensure that all models align with the entire collection of models and databases.
  • Maintaining all Wealth Management databases.

Confidential, Greensboro, NC

Senior Data Modeler (Open System Consultant)

Responsibilities:

  • Maintain data standards, definitions, and data models (Logical and Physical) in Info Sphere Data Architect . e.g. Data Dictionary Business glossary and Domains.
  • Experience in developing, validating, publishing and maintaining Conceptional, Logical and Physical data models in DB2, Oracle and SQL Server environments.
  • Analyze existing database schema DDL/instance layout and determine impacts migrating to new target schema/instance environment.
  • Meet with stakeholders and other technical team members to gather and analyze application requirements.
  • Work with Business Analysts, Information Architects, Software Developers, DBAs, Data Governance to achieve project objectives under the Agile project management methodology.
  • Partner with Data Quality and Data Governance processes.

Confidential, Winston-Salem, NC

Data Modeler

Responsibilities:

  • Created meta data system for the current data warehouse. Design and created a front-end using Qilk View.
  • Created and maintain data standards, definitions, and data model in Erwin. (e.g. data dictionary, organizational data model) for MGA (Managed Agencies) data marts.
  • Created a Sales Quote data mart in Erwin for Sales Team and Management.
  • Developed SSIS ETL Projects from (Excel Files and Databases).

Confidential, Charlotte, NC

Data Modeler/Database Developer

Responsibilities:

  • Review the quality of data entry, loads, transformations, extractions, merges, or other production jobs (e.g. Excel, SQL Server 2008 databases, including the establishment and monitoring of communication protocols between data suppliers.
  • Participate in cross-functional teams, development and improvement task forces.
  • Maintain data standards, definitions, and data models. (e.g. data dictionary, organizational data model)
  • Developed SSIS ETL Projects from (Excel Files, Share Point and Databases).
  • Developed advance VBA Excel spreadsheets between MS-SQL.
  • Provide reports for Business partners.

Confidential . Charlotte, NC

Senior Financial Data System Analyst/Data Modeler

Responsibilities:

  • Responsible for creating and maintaining Enterprise Reports.
  • Created Management reports using Excel 2007 and Share point.
  • Automated all cost journal entries into PeopleSoft, accomplished by developing and building a data mart.
  • Extracted data from various ACN's Oracle and MS SQL server Confidential databases.
  • Created data mart in Oracle 11g which represented monthly customers, service providers and the costs charged by vendors to ACN.
  • Developed and implemented Oracle PL/SQL packages, stored procedures, triggers and custom utilities
  • Used Erwin 7.3 to create the logical and physical models.

Confidential, Charlotte, NC

Data Modeler (Matrix Consultant)

Responsibilities:

  • Performed data analysis to determine information requirements.
  • Analyzed data models to ascertain functionality.
  • Assisted with development and ongoing maintenance of data modeling environment.
  • Participated in development of data warehouses/marts models on Netezza and Oracle platform.
  • Worked with application developers to map process models to data models.
  • Performed logical and physical OLAP/OLTP schema designs.
  • Developed capacity plans for new and existing system in CA Erwin.
  • Achieved reuse of existing structures and models.

Confidential, Winston-Salem, NC

Lead Data Modeler (CRG Consultant)

Responsibilities:

  • Applied Oracle 10g theory of database modeling using Oracle designer.
  • Assisted with development and ongoing maintenance of data modeling environment.
  • Created logical business models and transformed into a physical data model instances.
  • Maintained all Oracle Confidential databases, data dictionaries and schemas.

Hire Now