We provide IT Staff Augmentation Services!

Data Modeler/senior Database Management Specialist/data Architect Resume

Green Bay, WI

SkillsTechnical Skills

Experience

  • Extensive experience as a DBA, to include production support as well as development environments
  • Experience working in a data warehouse environment
  • Experience as a Data Modeler
  • Previous and recent experience using various tools such as Erwin, ER Studio to design logical and physical Database Architecture
  • Experience with data acquisitions, data availability, data backup archiving and recovery
  • Previous experience developing source to target mappings (STTM)and developing ETL mappings using at least one ETL tool, such as Informatica
  • Experience with the design of normalized relational databases
  • Experience with de-normalized data warehouse design and how to convert relational designs to multi-dimensional designs
  • Experience with the Analysis of Data, SQL and PL/SQL
  • Experience with Business Intelligence (BI) and BI tools, such as Business Objects, Cognos, Microstrategy, etc.
  • Experience planning and implementing the Data Architecture goals of a project

Employment H Confidential ory:

Confidential, Green Bay, WI

Data Modeler/Senior Database Management Special Confidential /Data Architect

Responsibilities:

  • OLAP design and constructions, pers Confidential ence and business logic layer development extraction/transformation/Loading (ETL) Design and implementation, report development, database system trouble shooting and performance tuning.
  • Worked closely with business analyst to identify users and gather requirements and planning and implementing the Data Architecture to determine the goals of a project and finalize scope.
  • Strong understanding of Data Modeling in data warehouse environment such as schema.
  • Member of architect team and involved in development of Application Data model, logical data model, Physical data model and artifacts. Prepared Apex application for mapping of data model and different interfaces.
  • Had well versed in Normalization and De-normalization data warehouse techniques for optimum performance in relational to multi-dimensional database environments.
  • Had experience with data acquisitions, data availability, data backup archiving and recovery.
  • Experienced in Translate data models into normalized relational database designs.
  • Experience building reports using Crystal Reports, Business Objects, Cognos, and MicroStrategy.
  • Provided ass Confidential ance in logical and physical database architecture using Erwin and ER Studio.
  • Created the dimensional logical model with approximately 28 facts, 100 dimensions using Confidential Info-sphere IDA.
  • Created source to target mapping (STTM) document and worked on ETL mapping, session and workflow coding, ETL architecture, and provided data quality analysis to determine cleansing requirements.
  • Created analysis of Data tools with SQL, PL/SQL, and Oracle 10g.
  • Worked with DBA to create the physical model and tables.
  • Scheduled multiple brains storming sessions with DBAs and production support and development environment for the team to discuss about views, partitioning and indexing schemes case by case for the facts and dimensions.
  • Transformed logical model into physical and tuned DDL & Oracle Database
  • Developed Data Dictionaries, Encoded Reference System and Mapping System
  • Participated in team to implement steps of Agile Methodology

Environment: JAVA, JavaScript, COBOL, HLI, Assembler, FORTRAN, Data Analysis, SQL, PL/SQL, SQL*PLUS, Oracle Designer 6i, Oracle Forms 4.5/5.0/6i/9i, Oracle Report 2.5/3.0/6i/9i, Oracle JDeveloper, MS Visio, MS X Windows, Dream Viewer, Oracle Discoverer, Actuate report 6.0, MS Project 2000, Unix, ODBC, JDBC, Erwin, ER Studio, Crystal Report 9, Toad, Dynamic SQL, Pro *C, PVCS, Visual Basic, MS Access, Ms Excel, MS PowerPoint, Oracle 9iAs, FTP, Data Warehouse, Visual Source Safe, WEBQL, Business objects 6.5, Cognos 8.3, Apache, Secured client Shell, Confidential Info Sphere Data Architect, Oracle Apex, Informatica, Oracle 11g/10g.

Confidential, Baltimore, MD

Senior Database Developer/Data Modeler

Responsibilities:

  • Reviewed the logical model with Business users, ETL Team, DBA’s and testing team to provide information about the data model and business requirements.
  • Participated in requirement gathering session with business users and sponsors to understand and document the business requirements as well as implementing the Data Architecture goals of a project.
  • Strong understanding of Data Modeling in data warehouse environment such as schema.
  • Reversed engineered the oracle databases by using VISIO.
  • Provided ass Confidential ance in logical and physical database architecture using Erwin and ER Studio.
  • Experienced in Translate data models into normalized relational database designs.
  • Had well versed in Normalization and De-normalization data warehouse techniques for optimum performance in relational to multi-dimensional database environments.
  • Had experience with data acquisitions, data availability, data backup archiving and recovery.
  • Created source to target mapping (STTM) document and worked on ETL mapping, session and workflow coding, ETL architecture, and provided data quality analysis to determine cleansing requirements.
  • Experience building reports using Crystal Reports, Business Objects, Cognos, and MicroStrategy.
  • Created analysis of Data tools with SQL, PL/SQL, and Oracle 10g.
  • Worked with DBA to create the physical model and tables.
  • Scheduled multiple brains storming sessions with DBAs and production support and development environment for the team to discuss about views, partitioning and indexing schemes case by case for the facts and dimensions.
  • Developed and tested multiple Business Objects reports.
  • Designed the Conceptual, logical and Physical data model for NFGS Studies
  • Used Rapid Development Methodology for application development life cycle
  • Involved in Writing triggers, function, Procedure and Packages.
  • Converted FDA Legacy Data into SDTM Specification

Environment: JAVA, JavaScript, COBOL, HLI, Assembler, FORTRAN, Data Analysis, SQL, PL/SQL, SQL*PLUS, Oracle Designer 6i, Oracle Forms 4.5/5.0/6i/9i, Oracle Report 2.5/3.0/6i/9i, Oracle JDeveloper, MS Visio, MS X Windows, Dream Viewer, Oracle Discoverer, Actuate report 6.0, MS Project 2000, Unix, ODBC, JDBC, Erwin, ER Studio, Crystal Report 9, Toad, Dynamic SQL, Pro *C, PVCS, Visual Basic, MS Access, Ms Excel, MS PowerPoint, Oracle 9iAs, FTP, Data Warehouse, Visual Source Safe, WEBQL, Business objects 6.5, Cognos 8.3, Apache, Secured client Shell, Confidential Info Sphere Data Architect, Oracle Apex, Informatica, Oracle 9i/10g/11g.

Confidential, Rockwell, MD

Data Architect/DBA/ Data Modeler

Responsibilities:

  • Did reverse engineering for Oracle database to understand the logical and physical data model (ERWIN, VISIO).
  • Worked closely with business analyst to identify users and gather requirements and planning and implementing the Data Architecture to determine the goals of a project and finalize scope.
  • Translated business requirements into dimensional data model using ERWIN.
  • Strong understanding of Data Modeling in data warehouse environment such as schema.
  • Experience building reports using Crystal Reports, Business Objects, Cognos, and MicroStrategy.
  • Provided ass Confidential ance in logical and physical database architecture using Erwin and ER Studio.
  • Participated as leading role to enhance, design and implement a medical research Data Warehouse and business intelligence system utilizing Oracle 10g architecture and Business Objects and COGNOS Suite reporting tools.
  • Had experience with data acquisitions, data availability, data backup archiving and recovery.
  • Responsible to create Universe and publishing of Frame work Manager.
  • Experienced in Translate data models into normalized relational database designs.
  • Worked with DBA to create the physical model and tables.
  • Scheduled multiple brains storming sessions with DBAs and production support and development environment for the team to discuss about views, partitioning and indexing schemes case by case for the facts and dimensions.
  • Involved in DBA functions as Creation of Database, RMAN script for Backup,
  • Import/Export. Tuning and security.
  • Had well versed in Normalization and De-normalization data warehouse techniques for optimum performance in relational to multi-dimensional database environments.
  • Helped to identify issues and opportunities, define outcomes, explore possibilities, find out what works well, create solutions and action plan, workout strategies, create result and learn from differences.
  • Created source to target mapping (STTM) document and worked on ETL mapping, session and workflow coding, ETL architecture, and provided data quality analysis to determine cleansing requirements.
  • Created analysis of Data tools with SQL, PL/SQL, and Oracle 10g.
  • Implemented Functions, procedure and packages IN PL/SQL Environment
  • Wrote Complex SQL to extract data from ORACLE 10g and SYBASE database and. Performed SQL Tuning using explain plan, SQL trace and Optimizer hints.
  • Installed COGNOS reporting software on SOLARIS10 OS by using oracle application server and LDAP for security. Used VI editor for UNIX scripts. Diagnosed and resolved performance issues with COGNOS
  • Involved in requirements Gathering and Technical design engagement with medical research team
  • Modified Grant applications forms (HHS) by using Oracle forms 9i
  • Wrote SQL*LOADER control files for uploading legacy data to interface table
  • Coordinated day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance.
  • Got training of capability Maturity Model Integration(CMMI)
  • Team comprised of six members

Environment: JAVA, JavaScript, Cobol, HLI, Assembler, Fortran, Data Analysis, SQL, PL/SQL, SQL*PLUS, Oracle Designer 6i, Oracle Forms 4.5/5.0/6i/9i, Oracle Report 2.5/3.0/6i/9i, Oracle JDeveloper, MS Visio, MS X Windows, Dream Viewer, Oracle Discoverer, Actuate report 6.0, MS Project 2000, Unix, ODBC, JDBC, Erwin, ER Studio, Crystal Report, Toad, Dynamic SQL, Pro *C, PVCS, Visual Basic, MS Access, Ms Excel, MS PowerPoint, Oracle 9iAs, FTP, Data Warehouse, Visual Source Safe, WEBQL, Business objects 6.5,Cognos 8.3, Apache, Secured client Shell, Confidential Info Sphere Data Architect, Oracle Apex, Informatica, Oracle 7.3.

Confidential, Baltimore, MD

Senior Data Architect/Data Modeler

Responsibilities:

  • Participated in project and planning, budgeting, and implementing the Data Architecture goals of a project.
  • Documented functional and technical specifications.
  • Worked with database team to understand application, logical and physical data model.
  • Produced Project Status report, led the team and resolved day to day issues with emphasis on SLDC.
  • Had experience with data acquisitions, data availability, data backup archiving and recovery.
  • Implemented the system using stored procedures, Functions, packages and UNIX shell scripts. Extensively used REF Cursors, Dynamic SQL, DBMS Packages and oracle application context.
  • Worked closely with team members to perform SQL Tuning and recommended tools to improve performance
  • Used ERWIN and TOAD to review Physical data model of PICA database (OLTP), Constraints, Foreign keys and indexing of tables.
  • Created analysis of Data tools with SQL, PL/SQL, and Oracle.
  • Provided ass Confidential ance in logical and physical database architecture using Erwin and ER Studio.
  • Had well versed in Normalization and De-normalization data warehouse techniques for optimum performance in relational to multi-dimensional database environments.
  • Experienced in Translate data models into normalized relational database designs.
  • Experience building reports using Crystal Reports, Business Objects, Cognos, and MicroStrategy.
  • Created source to target mapping (STTM) document and worked on ETL mapping, session and workflow coding, ETL architecture, and provided data quality analysis to determine cleansing requirements.
  • Extract information from database by using packages and pass it to Epiphany application through TIBCO
  • Wrote PL/SQL standards for packages and reviewed every package before to submit.
  • Created Materialized View and simple views and embedded them in SQL
  • Got training of Kean project management and SLDC and applied the same for project. Used Rapid Development Methodology (RAD) for this project
  • Team Cons Confidential of Five members

Environment: JAVA, JavaScript, Cobol, HLI, Assembler, Fortran, Data Analysis, SQL, PL/SQL, SQL*PLUS, Oracle Designer 6i, Oracle Forms 4.5/5.0/6i/9i, Oracle Report 2.5/3.0/6i/9i, Oracle JDeveloper, MS Visio, MS X Windows, Dream Viewer, Oracle Discoverer, Actuate report 6.0, MS Project 2000, Unix, ODBC, JDBC, Erwin, ER Studio, Crystal Report 9, Toad, Dynamic SQL, Pro *C, PVCS, Visual Basic, MS Access, Ms Excel, MS PowerPoint, Oracle 9iAs, FTP, Data Warehouse, Visual Source Safe, WEBQL, Business objects, Cognos, Apache, Secured client Shell, Confidential Info Sphere Data Architect, Oracle Apex, Informatica, Oracle.

Confidential, Gaithersburg, MD

Database Developer

Responsibilities:

  • Data Warehouse design for the medical tools information such as description, size and availability in market. Developed searching strategies and extracted data from different websites using WEBQL tool.
  • Strong understanding of Data Modeling in data warehouse environment such as schema.
  • Modify logical data model and physical data model according to need of user.
  • Had experience with data acquisitions, data availability, data backup archiving and recovery.
  • Developed different Forms Using forms 9i and deployed to Oracle application server (Web).
  • Worked on oracle Financials 11i forms and placed back on oracle application server
  • Wrote packages, functions, procedure and triggers.
  • Performed DBA functions such as import, export, database tuning, enrolling users and maintaining system security.
  • Developed Search engine to fix and match dirty description of items against database by using PL/SQL and regular expression.
  • Created analysis of Data tools with SQL, PL/SQL, and Oracle.
  • Migrated data and code from cache web based system to oracle
  • Team contains 3 members

Environment: Java, JavaScript, Cobol, HLI, Assembler, Fortran, Data Analysis, SQL, PL/SQL, SQL*PLUS, Oracle Designer, Oracle Forms, Oracle Report, Oracle JDeveloper, MS Visio, MS X Windows, Dream Viewer, Oracle Discoverer, Actuate report, MS Project 2000, Unix, ODBC, JDBC, Erwin, Crystal Report, Toad, Dynamic SQL, Pro *C, PVCS, Visual Basic, MS Access, Ms Excel, MS PowerPoint, FTP, Data Warehouse, Visual Source Safe, WEBQL, Business objects, Cognos, Apache, Secured client Shell, Confidential Info Sphere Data Architect, Oracle Apex, Informatica, Oracle.

Confidential, Linthicum, MD

Data Architect/Database Developer/ Data Modeler

Responsibilities:

  • Supported Confidential staff in efforts to improve business technology and processes
  • Created ER diagram & forms through Designer 2000. Used reverse engineering concept to create ER diagram from database.
  • Conducted activities related to database and systems planning, development, and deployment.
  • Had experience with data acquisitions, data availability, data backup archiving and recovery
  • Responsible for the establishment of policies and procedure pertaining to their management security, maintenance and utilization , including database and system configuration, setup, maintenance, performance tuning , user access, backup, and recovery procedure.
  • Gathered business requirements, designed data structures and loading strategy, developed oracle data warehouse to analyze production data for decision support services and reporting. Used Star schema concept to design data model.
  • Developed Forms and reports by using oracle forms & report 6i. Used oracle 9i UNIX based as back-end tool. Familiar with JINITIATOR on Netscape.
  • Created project plans for development work and documentation, which allowed other programmers to understand related process and tools.
  • Used Change Control processes to make any changes to production environments.

Environment: Java, JavaScript, Cobol, HLI, Assembler, Fortran, Data Analysis, PL/SQL, SQL*PLUS, Oracle Designer, Oracle Forms, Oracle Report, Oracle JDeveloper, MS Visio, MS X Windows, Dream Viewer, PVCS, MS Access, Ms Excel, MS PowerPoint, FTP, Data Warehouse, Business objects, Cognos, Apache, Secured client Shell, Confidential Info Sphere Data Architect, Oracle Apex, Informatica, Oracle.

Confidential, Richmond, VA

Senior Consultant

Responsibilities:

  • Designed & developed thirty complex reports using Reports 6i. The project was completed in the time frame requested.
  • Prepared detailed analysis report based on user’s requirement
  • Involved in development of different type of Tabular and stat Confidential ical and cross tab reports

Environment: Java, JavaScript, Cobol, HLI, Assembler, Fortran, Data Analysis, PL/SQL, Oracle Designer, Oracle Forms, Oracle Report 6i, Oracle JDeveloper, MS X Windows, Dream Viewer, PVCS, MS Access, Ms Excel, MS PowerPoint, FTP, Data Warehouse, Business objects, Cognos, Apache, Secured client Shell, Data Architect, Oracle Apex, Informatica, Oracle.

Confidential, Palatka, FL

Technical Project Manager/Data Modeler

Responsibilities:

  • Determined activities of project and priorities and performed proper resource utilization. Prioritized work in favor of initiatives that were most aligned with business direction.
  • Directed plan execution and completed project ahead of schedule and within assigned budget. Used Microsoft Project to prepare project schedule.
  • Strong understanding of Data Modeling in data warehouse environment.
  • Responsible for analysis, design, data modeling of system and used Oracle Designer 2000 for data modeling and change management.
  • Used Rapid Development Methodology for application development and submitted deliverables needed for project.
  • Managed meetings with different group of users to understand process and prepare business rules, prototypes and detailed analysis report.
  • Involved in creating, defining, developing of Data warehouse based on FLORIDA state meteorological data. 40 million transactions are inserted through SQL*LOADER process
  • Trained, mentored and introduced data warehousing concept to achieve better result of query time
  • Created ER diagram (OLTP) using Designer 2000 by using surrogate key Concept. Transformed logical to physical model using designer 2000. Led the initiative of a Data Warehouse Project that sources information from five operating transactional systems.
  • Performed system monitoring. Trouble shooting and PL/SQL code writing SQL Loader Scripts and database load task. Introduced Data warehouse concept to get better performance.
  • Performed DBA functions such as indexing, bitmap indexing, creation of views and materialized views, import and export utility, and creation of table space on tables
  • Created database triggers and stored procedures
  • Performed Software development life cycle steps like requirements gathering, analysis, and designing, and development using case tools, data flow diagram system and program specification for business application need.
  • Designed and developed intranet application using HTML, Java Script, Dreamweaver, Java, Java beans and Oracle9i AS. Prepared reports through Actuate (5.0) software
  • Created Business Areas using Oracle Discoverer Admin for changed & new reports
  • Wrote Unix Shell scripts & pearl scripts to handle functions on Unix box
  • Designed test methodology and wrote scripts of unit, regression and system test
  • Prepared documentation, including user and system manual for application.
  • Team Cons Confidential of 10 members

Environment: Java, JavaScript, Cobol, HLI, Assembler, FORTRAN, Data Analysis, PL/SQL, MS X Windows, Dream Viewer, PVCS, MS Access, Ms Excel, MS PowerPoint, FTP, Data Warehouse, Apache, Secured client Shell, Confidential Info Sphere Data Architect, Oracle Apex, Oracle.

Confidential, Richmond, VA

Consultant

Responsibilities:

  • Team lead and hands-on application support for Vision System
  • Created packages that interface with Oracle forms and reports
  • Worked on vision application designed to keep patients and their claim information.
  • Trouble shot performance issues and bugs within packages, forms, and reports using DBMS-Output, forms debugger, explain plan and TKPROF
  • Designed and developed forms and reports. Used Designer 2000 to generate forms
  • Used PVCS tool as configuration management.
  • Involved in process to create data warehouse, Conducted data cleaning by removing orphan and duplicate records.
  • Prepared inventory of software & hardware with their versions and support information
  • Prepared test plans for unit, system, stress and regression test by using CACI methodology
  • Developed, designed and implemented a relational database system using MS ACCESS for software version.

Hire Now