We provide IT Staff Augmentation Services!

Teradata Developer/data Warehousing Specialist Resume

2.00 Rating

Lexington Park, MD

SUMMARY:

An accomplished IT professional with 13 years of experience who provided data warehousing, business, technical and training solutions.

TECHNICAL EXPERTISE:

Skills: Project Management, Business Analyst, Systems Analyst, Data Warehousing, Application Development, OO Development, Data Modeling, Data Analysis, Document Management

Languages: Visual Basic, VBScript, SQL, Java, JavaScript, Visual FoxPro, FTP, FoxPro, FoxPro for Windows, HTML, Clipper, Batch Files, Cobol, JCL, dBase IV

Databases: Teradata, DB2, MS Access, SQL Server 2000, Dbase IV, Oracle

Operating Systems: Microsoft Windows 95, 98, NT, 2000, XP, UNIX, Novell 4.X, 5.X, Bull/Honeywell

Hardware: IBM PCs and Compatibles, Bull/Honeywell, AS/400

Software: Microsoft Office Suite 97, 2000, 2003, 2007, MS Project 98/2000, Lotus Notes, Remedy, Visio, SQL Assistant, Visual Source Safe, Endevor, BI Query, FTP, Harvest, CA7, G - Link, Crystal Reports, Starteam, COGNOS, Citrix, Toad, SQL Developer

DOD Systems: Global Decision Support Systems, Core Automated Maintenance System, MICAP Automated Sourcing System, Standard Base Supply System, Priority Monitor Report (D18), Daily Document Register (D04) and Due-out Validation Listing (M30), D043 Master Item Identification Control System (MIICS), D071 Stock Number User Directory (SNUD)

EXPERIENCE:

Confidential, Lexington Park, MD

Teradata Developer/Data Warehousing Specialist

Responsibilities:

  • Execute database modifications and processes on Teradata using MultiLoad, FastLoad, FastExport, Tpump, and BTEQ utilities to support NAVAIR programming requirements as described in interface management documents (IMD). Apply SQL to design, test, evaluate, and implement complex processes to Extract, Transform, and Load (ETL)/Extract, Load and Transform (ELT) data from a number of silo source systems using Korn shell scripting.
  • Use Toad and SQL Developer to access Oracle source systems to verify data is being pulled correctly and use COGNOS Query and Report studios to validate data was transformed correctly.
  • Work closely with Navy Personal, Civil Servants, and Civilian Contractors to validate data on the DECKPLATE Data Warehouse, investigate inaccuracies, and resolve any data issues as they arise.
  • Develop Acceptance Test Documentation which includes creating and executing test cases and assisting NAVAIR with Customer Acceptance Testing.

Confidential, Lansing, MI

Teradata/Data Warehousing Specialist

Responsibilities:

  • In-depth knowledge and experience in full database life-cycle including data architecture, logical and physical database design, data modeling and implementation efforts.
  • Perform specialized database management functions in support of the Confidential Enterprise Data Warehouse (Teradata). Apply SQL to design, test, evaluate, and implement complex processes and stored procedures to Extract, Transform, and Load (ETL) data from a Bull mainframe via UNIX and other data sources such as Oracle and MS Access in a Windows Client/Server environment.
  • Work with other application developers to implement database modifications and processes on Teradata using RDBMS utilities (MultiLoad, FastLoad, FastExport, and BTEQ) written in SQL to support user requirements.
  • Work closely with both the business users and clients to validate data on the Enterprise Data Warehouse, investigate inaccuracies, and resolve any data issues as they arise. Interview and consult with business users, managers, technical leads concerning desirable enhancements and modifications to the EDW.
  • Facilitates and participates in Joint Application Development sessions.
  • Create generic work plan documentation and initial assessment for project initiations.
  • Perform comprehensive analysis and validation of the clients’ needs to develop business-process diagrams, entity-relationship diagrams, and basic use cases documentation.
  • Generate generalized, conceptual-design documents and detailed system designs, definitions, flowcharts, and procedures.
  • Design and apply crosschecks and auditing (audit-trail) procedures to assure accuracy of the process and data loaded into the EDW.

Confidential, Kalamazoo, MI

Technical Business Analyst

Responsibilities:

  • Conferred with project managers, program managers, teams, subject-manner experts, quality managers, and stakeholders in the retirement, deployment, and transfer of validated and non-validated systems.
  • Work closely with application developers and the software engineering teams to design, develop, test, and implement procedures and SQL processes and scripts to transfer data from legacy systems to a data repository for FDA auditing purposes.
  • Gathered requirements, perform analysis and documented findings of established procedures to complete assignments.
  • Prepared data-collection surveys, develop business-process flows and reports on schedule and effort variances linked to the schedule and resource plan.
  • Produced detailed, accurate project status to ensure that key stakeholders have up-to-date, fact-based information on which to base project decisions.

Confidential, Lansing, MI

Systems Analyst / Data Warehousing Specialist

Responsibilities:

  • Lead SQL developer in the modification, development, design, and implementation of the State’s of Michigan Teradata Medicaid Data Warehouse processes assigned to the Department of Information Technology.
  • Experience in full database life-cycle including data architecture, logical and physical database design, data modeling and implementation facilitated the Confidential development efforts interface and conversion teams and management concerning desirable maintenance modifications.
  • Identified additional data requirements to be added to the data warehouse and created SQL routines to load the data.
  • Created SQL routines to pull 5 years of claims data from the Data Warehouse. Modified data validation SQL routines to reject claims based on specified criteria from the clients. Apply SQL to design, test, evaluate, and implement ETL (Extract, Transform, and Load) processes on Teradata using RDBMS utilities such as MultiLoad, FastLoad, FastExport, and BTEQ from the Bull mainframe via UNIX and other data sources such as Oracle and MS Access in a Windows Client/Server environment to update the Teradata Medicaid Data Warehouse.
  • Interviewed and consulted with business users, managers, technical leads concerning desirable enhancements and modifications to the EDW.
  • Created generic work plan documentation and initial assessment for project initiation.
  • Performed comprehensive analysis and validation of the clients’ needs to create a technical solution.
  • Developed business-process diagrams, entity-relationship diagrams, and basic use cases documentation to document the user’s needs.
  • Generated generalized, conceptual-design documents and detailed system designs, definitions, flowcharts, and procedures.
  • Designed and applied crosschecks and auditing (audit-trail) procedures to assure accuracy of data loaded into the EDW.

Confidential, Livonia, MI

Senior Consultant

Responsibilities:

  • Performed specialized systems-analysis functions to provide agency management with high-level technical assistance in the development, analysis, modification, testing, and installation of comprehensive, wholesale check imaging and account processing systems utilizing Microsoft SQL Server in a Client/Server and also a peer-to-peer environment utilizing Visual FoxPro. Updated electronic-data interchange scripts including the modification of mainframe jobs using JCL, CA-7, and Endevor from SuperTracs to direct IBM File Transfer Protocol (FTP).
  • Performed data administration duties during the software upgrade and conversion from Visual Fox Pro to Microsoft SQL server, created logical and physical database design and data models, and implemented backup and recovery processes to support the new system implementation.

Confidential, Springfield, IL

Procurement Specialist

Responsibilities:

  • Organized, planned, executed, controlled, and evaluated bid specifications and solicitations for purchases of highly complex Information Technology (IT) supplies, equipment, and services for 26 State of Illinois agencies.
  • Assisted agencies in conducting performance-characteristics research, determined items to be procured, and prepared specifications of IT supplies, equipment, and services. Reviewed, approved, and denied agencies’ procurement business cases and Requests for Information, Requests for Proposals, and Invitations for Bids through Remedy (Procurement Tracking System).

Confidential, Springfield, IL

Information Systems Analyst

Responsibilities:

  • Served as staff specialist and lead programmer. Planned, directed, and reviewed the activities of programmer analysts in system development, analysis, modification, and installation of comprehensive information systems in a client/server environment using Visual Basic (VB), VB Source Safe, Standard Query Language (SQL), Crystal Reports, DB2, MS Access, FoxPro, dBase, DOS, and Batch Files.
  • Analyzed and evaluated specific phases of operational standards, procedures, and techniques used to create, convert, or improve existing financial, accounting, vouchering, investigative, audit, case tracking, telecom, cash books, return bank items, tax assessments, and other Confidential - related systems.
  • Interviewed and consulted with clients concerning desirable changes and performed comprehensive studies and analysis of clients needs to develop business-process diagrams and entity-relationship diagrams. Developed generalized, conceptual-design documents and detailed system designs, definitions, flowcharts, and procedures. Designed and applied crosschecks and auditing (audit-trail) procedures to assure accuracy and reliable practices.
  • Created physical database models for DB2, MS Access, and FoxPro, which included creating tables and columns, normalizing relationships, identifying constraints, and developing indexes and views. Scheduled and monitored assignments to attain project time frames. Coordinated programming activities for fellow programmers and system analysts using Microsoft Project 2000.
  • Lead programmer for several complex systems. Coordinated analytical and programming functions required to adapt and convert existing systems and develop new applications using VB, VB Source Safe, SQL, Crystal Reports, MS Access, DB2, FoxPro, and dBase IV.
  • Provided leadership to several application programmers in major projects utilizing VB and SQL. Directed the preparation, review, and revision of program procedures, methods, and manuals in accordance with Confidential standards. Served on the Infrastructure Planning Committee to provide upper management with short- and long-term infrastructure goals.
  • Performed application programming assignments, maintenance, and modification of department applications.
  • Applied technical analysis and evaluation standards, techniques, and Confidential operational procedures to assess the feasibility of converting areas to computer-based information systems.
  • Assisted in the continued revision and installation of new and improved application systems and procedures, which included designing, coding, testing and documenting application programs.
  • Prepared test data and assisted information system analysts in documenting program information systems, functions, and data requirements. Monitored production systems and aided users and operations staff to analyze system performance.

We'd love your feedback!