We provide IT Staff Augmentation Services!

Data Architect Resume

DE

SUMMARY

  • 15 years of professional IT experience in all aspects of System Development Life Cycle (SDLC) System Analysis, Design, Data Modeling, Implementation and Support of various applications in OLTP, Data Warehousing, and OLAP applications.
  • Experience in Data Modeling including Object Oriented Data Modeling using Oracle ADF and OA framework
  • Assisting with all phases of the application development lifecycle (requirements gathering/definition, design, development, and deployment)
  • Communicate with project management team regarding the status of assigned tasks, estimates of proposed tasks, and actual time spent on, completion of project tasks.
  • Acting as “technical data expert” and mentors less experienced colleagues in addressing data - related problems of systems integration and compatibility
  • Extensive Experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams with all related entities and relationship with each entity based on the rules provided by the business manager using ERWIN
  • More than 8 years of experience in Data Modeling, Designing, Developing and Maintaining database related applications.
  • Experienced in working on Distributed Oracle database servers 7.x/8.0/8i/9i/10g
  • Experience in Dimensional Modeling, ETL Design and Informatica Transformation
  • Extensive experience in developing and maintaining various database objects like Tables, Views, Materialized views, synonyms, sequences, Indexes, Constraints, roles, Privileges, etc., Developed Complex triggers using PL/SQL for data integrity and enforcing business rules.
  • Experienced in SQL*Loader, Import, Export, DB Links, UTL FILE.
  • Experienced with Oracle Financials module, Distributions module and CRM
  • Designed database Schema including tables and fields using ER diagrams and database normalization principals.
  • Strong understanding of the principals of Data warehousing using Fact Tables, Dimension Tables, star and snowflake schema modeling & OLTP system Data normalizations
  • Strong programming and debugging skills in PL/SQL, SQL, Pro*C, Unix shell scripting and Perl
  • Experience in working with Waterfall and Agile Methodology
  • Extensive experiences in SQL query optimization using Explain Plan, TKPROF, DBMS STATS etc.
  • Managed a heavy workload in a complex, demanding and rapidly changing environment and a keen interest in business operations and change impact
  • Excellent inter-personal communication skills and a versatile team player.
  • Knowledge of Teradata as Training provided in Barclays.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Pro*C, Java, HTML, JavaScript, UNIX Shell Scripting, PERL, SQR

RDBMS: Oracle 11g/10g/9i/8i/8/7.3, SQL Server, Teradata 13.0

Operating Systems: HP-UNIX, Windows NT/XP/2000, Sun Solaris, Linux

GUI/Reporting Tools: Oracle Forms, Oracle Reports, Oracle Jdeveloper, Oracle Discoverer 4.0, Cognos, Brio

ETL Tools: Informatica Power Center / Power Mart 7.1, 8.6 (Designer, Server Manager, Workflow Manager, Workflow Monitor, Repository Manager Etc.), SSISERP Tools Oracle E-Business 11.5.8 (AR, AP, GL, PO, OM, INV)

Tools: Toad, SQL Navigator, SQL*Loader, Autosys, Ctrl+M, Teradata Sql Asst, BTEQ tools

Version Control: Microsoft Visual source Safe, Serena, Wincvs

Case Tools: Erwin 4.0, 7.2, 8.0

PROFESSIONAL EXPERIENCE

Data Architect

Confidential, DE

Responsibilities:

  • Leading the team of 3 data modeler and 2 data analyst involved in discussion with business and Enterprise Architecture team for designing and architecture of various project in finance, market, CRM and BPM verticals.
  • Extensively involved in design Logical/Physical data models, OLTP and dimensional database design (Star schema, Snowflake Schema in data ware house).
  • Involved in discussion with business user, ETL team, enterprise architect team, database engineering team
  • Used Erwin 7.2, 8.0 for Designing the data Model, reverse Engineering as well as Forward Engineering.
  • Applied standard domain name, metadata in Erwin for enterprise wise naming Standard.
  • Designed the Data profiling tools in SQL/PLSQL to analyze the data
  • Daily meeting with project teams to resolve issue and understanding the requirement and organizing the integration activities from enterprise architecture point.
  • Worked with release management team and config change management team during production release and emergency change release.
  • Support database development including stored procedures, advanced SQL and performance tuning
  • Project TEMPhas been executed Under Agile implementation methodology

Environment: Oracle 11g/10g, Teradata 13.0, Erwin 7.2, 8.0, wincvs, Iplan SDLC tool for project Management and Release management, IBM banking data model, Unix, Ctrl+M, Teradata Sql asst

Oracle/Database Architect

Confidential, Annarbor, MI

Responsibilities:

  • Design Data Model in Oracle, for OLTP ACCESS for Products store and customer accounts, Security Access Model and storing the Content and Media the Data
  • Extensively involved in design Logical/Physical data models, OLTP database design.
  • Used oracle Designer for Designing the data Model
  • Design the Data Model To link Confidential Digital Library to Google Library
  • Design numbers of Screen in ADF and java for customer service to support customers/libraries
  • Leading teams one at onsite ( Ann arbor), UK ( Cambridge), India with 8 members .
  • Daily meeting with different teams to resolve issue and understanding the Requirement and organizing the integration activities between three different applications and team.
  • Performance tuning in oracle and data mapping in WebMethods for migrations of legacy data to new systems.
  • Working with production support team, define production release requirements
  • Support database development including stored procedures, advanced SQL and performance tuning
  • Project TEMPhas been executed Under Agile implementation methodology
  • Leading Projects with Two team and 8 members at onsite/offshore model

Environment: Oracle 11g, 10g, SQL, PL/SQL, Unix Shell Scripts, JAVA, XML, ADF, Oracle Designer, WebMethods Jdeveloper 10g, Scrum works Pro

Sr. Developer / ETL Architect

Confidential, MI

Responsibilities:

  • Extensively interacted with user & Business Analyst involved in requirement gathering,
  • Designed the relational data model for operational data store and staging areas, Designed Dimension & Fact tables for data marts
  • Integrated Bureau Data ( fico score, Teletrack Data ) into Behavior Score Model
  • Based on the Business logic and Model Loaded past 21 months data in multi threading by reducing data load time to 10 days
  • Develops detailed ETL design documents, ETL specifications and data mappings based on requirements, and maintains appropriate repositories of data model and dataflow diagrams relating to the data warehouse
  • Define/design the ETL components (e.g., ETL processes, staging database, metadata management, data quality)
  • Developed complex mapping using various transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Stored procedure Transformations, Expressions and Sequence Generator for loading the data into target Data Mart using Informatica Tool
  • Performance tuning in loading fact tables, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms and Sequences.
  • Working with production support team, define production release requirements
  • Support database development including stored procedures and advanced SQL
  • Helping QA team in defining the Testing strategy to test the Huge data.
  • Project TEMPhas been executed Under Agile Implementation Methodology
  • Leading Projects with Four Team Members

Environment: Oracle 10g/9i, SQL, PL/SQL, Unix Shell Scripts, Autosys, Serena, SQL Navigator, Microsoft Access, Informatica Power Center

Sr. Developer / ETL Architect

Confidential, MI

Responsibilities:

  • Extensively interacted with user & Business Analyst involved in requirement gathering,
  • Designed the relational data model for operational data store and staging areas, Designed Dimension & Fact tables for data marts
  • Implemented Partition and Parallelism for Bulk Data Load and improving Performance
  • Used SSIS (SQL Server Package) to load data from Microsoft Access into temporary staging tables for further matching and processing. performance tuning in loading fact tables, making Cubes in Cognos using power play
  • Project TEMPhas been executed Under Agile Implementation Methodology
  • Leading Projects with Three team Members

Environment: Oracle 10g/9i, SQL, PL/SQL, Unix Shell Scripts, Autosys, Serena, SQL Navigator, Microsoft Access, SQL SERVER ( SSIS Package ), Cognos

Sr. Developer / ETL Architect

Confidential, MI

Responsibilities:

  • Extensively interacted with user & Business Analyst involved in requirement gathering, prototyping and prepared various documents like Interface Requirement Document, Customer Requirement document, Data base design document etc.
  • Designed the relational data model for operational data store and staging areas, Designed Dimension & Fact tables for data marts
  • Extensively involved in design Logical/Physical Data Models, Dimensional database design.
  • Conducted data modeling sessions for different user groups, facilitated common data models between different applications, participated in requirement sessions to identify logical entities
  • Designed the ETL strategy including basic structure and flow (reusable templates) for all PL/SQL procedures to be developed.
  • Extensively developed SQL*Loader control files and run SQL*Loader to load data from excel files into temporary staging tables for further matching and processing.
  • Performance tuning in loading fact tables, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms and Sequences.
  • Working with production support team, define production release requirements
  • Support database development including stored procedures and advanced SQL and SQR
  • Leading Production Support & Maintenance Team with 4 Teams Members

Environment: Designer 2000, Oracle 10g/9i, Oracle E-business (11.5.10), SQL, PL/SQL, Unix Shell Scripts, SQL*Loader, Autosys, Serena, SQL Navigator, SQR Reports, Oracle Reports

Sr. Oracle Consultant

Confidential

Responsibilities:

  • As an Analyst and ETL / Discoverer Designer extensively involved in creating the Data mart for Financial ( AP, AR, GL ) and Sales & Distribution ( PO, OM, RCV, INV ) for Panasonic all the Data Mart TEMPhas been Created by Using PL/Sql and used Informatica ETL tool for data Transformation
  • Designed the ETL strategy including basic structure and flow (reusable templates) for all PL/SQL procedures to be developed. All the procedures has been developed taking these templates as the base.
  • Incorporated Slowly Changing Dimensions (Type-2) & Contras and Corrections logic dat TEMPhas been carried forward in all the relevant procedures.
  • Designed the ETL Metadata framework and Developed Reports using Oracle Discoverer 10g, Created ETL Design documentation.
  • Developed Source to Intermediate (Initial load & Incremental load -Change Data Capture implementation) and Intermediate to Data mart PL/SQL procedures.
  • Extensively interacted with user and involved in requirement gathering, prototyping and prepared various documents like Interface Requirement Document, Customer Requirement document, Data base design document etc.
  • Designed the relational data model for operational data store and staging areas, Designed Dimension & Fact tables for data marts
  • Extensively used Erwin to design Logical/Physical Data Models, relational database design.
  • Conducted data modeling sessions for different user groups, facilitated common data models between different applications, participated in requirement sessions to identify logical entities
  • Worked in Objects Oriented Data Modeling using ADF and OA Framework
  • Extensively developed PL/SQL scripts to identify incorrect or missing packing data, missing Item by scanning data in staging tables and comparing them with Apps data, Classified incorrect cases into several scenarios, worked out a solution for each scenario and wrote and run PL/SQL scripts to fix these data.
  • Extensively developed SQL*Loader control files and run SQL*Loader to load Sales & Distribution and Packing data of Warehouse data in excel files into temporary staging tables for further matching and processing.
  • Carried out Impact Analysis and feasibility study of preproduction enhancements, troubleshooting of user queries with quick response time, On-time bugs fixing and delivery of post production enhancements.
  • Project TEMPhas been implemented using Waterfall methodology

Environment: Oracle E-Business (11.5.10), Oracle 10g/9i, SQL, PL/SQL, Unix Shell Scripts, SQL*Loader, Informatica 7.1, Discoverer 10g, Sun Unix, Erwin

Data Analyst/ Sr. Developer

Confidential

Responsibilities:

  • Involved in all phases of SDLC from requirement, design, development, testing, pilot, training and rollout to the field user and support for production environment.
  • Consulted with application development business analysts to translate business requirements into data design requirements used for driving innovative data designs dat meet business objectives. Expertise in relational data design and modeling, system study and development by applying Ralph Kimball methodology of dimensional modeling.
  • Extensively used ERwin to design Logical/Physical Data Models, relational database design, forward/reverse engineering, publishing data model to acrobat files, created ERWIN reports
  • Performed data modeling both at an application level and at an enterprise level.
  • Performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms and Sequences.
  • Interacting with Business User and Preparation of Technical Specification
  • Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query
  • Supported both data warehousing client projects and operational systems development projects.
  • Developed complex mapping using various transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Stored procedure Transformations, Expressions and Sequence Generator for loading the data into target Data Mart using Informatica Tool
  • Partnered with Database Administrators to coordinate logical and physical data design.
  • Preparation of Unix Shell Script and Job Scheduling

Environment: Erwin, Oracle 9i, Oracle SQL, XML, PL/SQL, Unix Shell Scripts, SQL*Loader, Hp- Unix., Java, Perl, Erwin, Informatica 7.1

Data Analyst/ System Analyst

Confidential

Responsibilities:

  • Conversion of whole project from Oracle forms 3.0 to Developer 6i and deployment in intranet.
  • Conversion of ALL User Exit into Package & Procedure & Enhancement of the different Module as well as developed new Module which was java Based
  • Preparation of Technical Specification for New Development
  • System Integration with Oracle APPs ( Financial ) 11i and Procurement third Party Software (Maximo)
  • Created new interface tables following project requirements.
  • Extensively used PL/SQL Advanced Feature, Analytical Functions to improve the Query Performance
  • Modified Pro*C programs as required to interface with the existing systems.
  • Migration Of Data from Oracle 7.3 to Oracle 8i and subsequently to oracle 9i
  • Performance tuning and new development in Oracle 9i
  • Performed DBA activities during the application development
  • Wrote Unix Shell Scripts and SQL*Loader control files to load data into interface tables
  • Performed unit, application and system integration testing, wrote all testing related docs, testing logs, defects logs, testing cases and testing scripts.
  • Conducted Training for User to facilitate the easy uses of new systems from Old system

Environment: Oracle 7.3, 8i, 9i, SQL, PL/SQL, Unix Shell Scripts, SQL*Loader, Oracle Developer 6i (Forms, Reports), Pro*C, Sun Unix, Java, Java Script, Oracle Jdeveloper

Oracle Consultant/ System Analyst

Confidential

Responsibilities:

  • Discussed with HR users to identify their new requirements, completed technical documentation of impact analysis, requirement specifications and design specifications.
  • Developed, designed and provided Enhancement Support for the Application in areas of Oracle Forms 4.5/2000, Reports 2.5
  • Created database Schema Objects using ER diagrams and database normalization principals.
  • Developed Complex trigger using PL/SQL for data integrity and enforcing business rules.
  • Wrote Pro*C programs as required to interface with the existing systems in place.
  • Used PL/SQL built in package UTL FILE to read and write into Text files.
  • Debugged existing source code and fixed program bugs, some of which had seriously affected the operations of some applications.
  • Cooperated with LTA IT staffs to build a new Internet based E-Training application using Java.

Environment: Oracle 8i, Forms 4.5, Reports 2.5, SQL, PL/SQL, Java, Pro*C, Sun Solaris, Windows NT

System Analyst

Confidential

Responsibilities:

  • Designing & programming of the Plant Activities, entire system study at plant,
  • Designed Application error handling and fine-tune SQL & PL/SQL code.
  • Extensively involved in coding using SQL, PL/SQL, forms, reports
  • Integration testing with corporate Activity and depot Activity and leading the team during implementation phase.
  • Unit Testing, Integration Testing, preparing test case Scenario, Code Review
  • Production Support, Bug fixing, Enhancement
  • Documentation of fixes and logged problems, Monthly Review, Team Meeting

Environment: Oracle 8i, Forms 4.5, Reports 2.5, SQL, PL/SQL, Java, Pro*C, Sun Solaris, Windows NT

Hire Now