We provide IT Staff Augmentation Services!

Data Modeler/technical Designer Resume

2.00/5 (Submit Your Rating)

Charlotte, NC

SUMMARY

  • Over 7 years of career reflecting experience and high performance in Data Modeling, System Analysis, Design, Development and Implementation in Relational Database and Data Warehouse.
  • Involved in all the stages of Software Development Life Cycle (SDLC).
  • Expertise in data modeling using ERwin.
  • Experience in database migration (from Teradata to Vertica)
  • Teradata 12 Certified Solution Developer
  • Experienced in Data Warehousing, Application Development and Production Support.
  • Extensive experiences in UNIX shell scripting and IBM Mainframe.
  • Excellent knowledge of different RDBMS like Teradata V2R5, V2R6, 12.0, 13.0 and HP Vertica
  • Extensive knowledge in Teradata and HP Vertica Architecture, Teradata application development and Teradata tools and utilities, HP Vertica Development.
  • Teradata and Vertica performance tuning, identifying and resolving performance bottlenecks.
  • Experience in SQL Performance Tuning, table structure and index design for better query performance.
  • Experience in application development using HP Vertica Database.
  • Extensive experience in Teradata tools like BTEQ, FastLoad, MLOAD, TPUMP and FastExport.
  • Good experience in Verica VSQL.
  • Extensively involved and experienced in business Analysis, requirements gathering, logical modeling, physical modeling, ETL (Extraction, Transformation and Load) and Data Integration.
  • Experience in Datastage
  • Excellent technical and communication skills.
  • Ability to meet deadlines and handle pressure coordinating multiple tasks
  • Able to play a key role in analyzing problems and come up with creative solutions
  • A quick learner who can absorb new ideas and can communicate clearly and effectively
  • Good aptitude for problem solving and logical analysis. Excellent coordination skills as a team leader and work experience as a team member.

TECHNICAL SKILLS

Databases: NCR Teradata, HP Vertica.

Development/Productivity Tools: Adobe Acrobat, MS Office, MS Project, Unix Shell scripts, Visio, Teradata parallel Transporter ( TPT ), Teradata Fast export, Teradata FastLoad, Teradata MLoad, Teradata Tpump, Teradata procedures and Teradata utilities, Data Movement utilities (DMU).

Functional Areas: Banking, Customer Relationship Management

Programming Languages: SQL Programming, C, C++

Environment: Windows 7, AIX UNIX, LINUX, IBM - Mainframe

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Data Modeler/Technical Designer

Responsibilities:

  • Working as a Data Modeler and Technical Designer for new applications
  • Created logical and physical data model using CA ERWin Data Modeler
  • Worked with HP Vertica expects to understand the capabilities of Vertica
  • Re-design new Physical data model for Teradata semantic views
  • Database Space forecasting
  • Created access control metrics for Teradata and Vertica
  • Was part of team to decide class words and naming conventions
  • Created highlevel design documents and was also working with technical team on low level designs
  • Working as Subject Matter Expert for Customer and Relationship Applications
  • Bridge between business team and technical team
  • Leading multiple development teams and validating performance of each process.
  • Guiding development teams and reviewing project deliverables
  • Performance optimization suggestions in UAT.
  • Post production data validation and performance monitoring during post warranty support

Environment: HP Vertica, NCR Teradata, Teradata SQL Assistant, TeradataUtilities (Multiload, FastLoad,TPT and FastExport) scripts, Linux, Autosys, NDM, MS Office. MS Visio, Maximo

Confidential

Technical Designer

Responsibilities:

  • Worked as a Technical Designer for multiple projects.
  • Was mainly responsible for writing low level design of multiple initiatives.
  • Leading the technical teams and making sure all bank standards are met.
  • Created project details technical overview for all initiatives.
  • Created best practices document for team on Teradata and enforce it within team.
  • Leading multiple development teams and validating performance and data quality of each process.
  • Guiding development team and reviewing all project deliverables
  • Performance optimization suggestions to development team.
  • Post production data validation and performance monitoring during post warranty support

Environment: NCR Teradata, Teradata SQL Assistant, TeradataUtilities (Multiload and FastExport) scripts, AIX - UNIX, Mainframes, CA7, Autosys, NDM, MS Office. MS Visio, Maximo

Confidential

Technical Developer

Responsibilities:

  • Worked as a Technical Lead to build the new house holding application using Trillium.
  • Worked with business users to gather requirements.
  • Involved in preparing the low level and highlevel design documents for the project.
  • Leading offshore team and was managing end to end delivery of the project.
  • Guiding offshore team and reviewing all project deliverables
  • Created code dump using Trillium Control Center and used it for the process.
  • Performance optimizations of UNIX file processing scripts.
  • Worked on production certification and post warranty support after implementation
  • Documentation of development projects and production support turnover

Environment: Trillium Control Center, SyncSort, AIX - UNIX, NCR Teradata, Teradata SQL Assistant, TeradataUtilities (Multiload and FastExport) scripts, Autosys, NDM, MS Office.

Confidential

Technical Developer

Responsibilities:

  • Worked as an ETL Technical Developer to build the End-to-End Development to create the new Value Added Processes (VAPs).
  • Involved in preparing the low level design document to create the new sub-applications.
  • Working as developer and peer reviewer during coding
  • Developed code using Mainframe and Teradata tools and utilizes (MLOAD, FASTLOAD, TPUMP, FASTEXPORT) to process the source data into Teradata tables.
  • Responsible for system integration testing and user acceptance testing.
  • Involved in the future projects design reviews.
  • Created detailed task plan (DTS) before production installs
  • Worked in production certification and post warranty support after implementation
  • Documentation of development projects and production support turnover
  • Created best practices documents on Teradata and Mainframe for the team.

Environment: IBM - Mainframe, NCR Teradata, Teradata SQL Assistant, TeradataUtilities (BTEQ, FastLoad, Multiload and FastExport) scripts,CA7, NDM, COBOL, SAR, FileAid, MS Office,HP Quality Center.

Confidential

Production Support Analyst

Responsibilities:

  • Job monitoring, temporary bug fix, root cause analysis and permanent fix.
  • Proving solution downstream applications and business users on Incident management tickets.
  • Enhancements to the existing Service Management System as specified by the customer using JCL, Teradata, and CA7 scheduling.
  • Preparing and conducting peer reviews of process documents and control plans.
  • Maintaining the project Metadata
  • Determine workarounds for known issues, where a root cause solution will not be available quickly
  • Determine tactical actions to reduce the likelihood of the reoccurrence of an issue.
  • Automation of processes to reduce manual effort
  • Working on process improvement and cost saving

Environment: IBM - Mainframe, NCR Teradata, Teradata SQL Assistant, TeradataUtilities (BTEQ, FastLoad, Multiload and FastExport) scripts,CA7, NDM, COBOL, SAR, FileAid, MS Office,Peregrine Service Center.

We'd love your feedback!