Data Modeler/technical Designer Resume
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.
