TERADATA SENIOR ASSOCIATE CONSULTANT Summary Highly dependable Teradata Database Engineer successful troubleshooting debugging. Supportive enthusiastic team player dedicated streamlining processes efficiently resolving project issues. Highlights Teradata BTEQ,Fast Load,PL/SQL Oracle Basic Unix Autosys Job Scheduler using JIL SQL Query writing SQL Performance Tuning BTEQ Accomplishments Developed custom database designs used strong fast analytical report wider audience across organization. Experience Teradata Senior Associate Consultant Dec 2014 Current Company Name － City State Project Description iOS Mobile Application Business Analytics Reporting This project aims developing Oracle Teradata layers pushing data iOS Mobile Application. Responsibilities: Performed data analysis gathered columns metadata source systems understanding requirement feasibility analysis. Worked optimizing tuning Teradata Oracle views SQL's improve performance batch response time data users Implement code changes change management tools. Worked closely business users come detailed solution approach design documents. Used Teradata utilities like Bteq build Teradata procedures. Provided initial capacity growth forecast terms Space, CPU applications gathering details volumes expected Business. Prepared low level technical design document participated build/ review BTEQ Scripts. Provided support system test, Product Integration Testing UAT. Coordination offshore development onsite assigning job till code delivery signoff. Verified implementation done expected. Done impact assessment terms schedule changes, dependency impact, code changes various change requests existing Data Warehouse applications running Production environment. Provided quick production fixes proactively involved fixing production support issues. Liaised different implementation groups (Both source target systems) monitored implementation activities. Analyze business requirements, designs write technical specifications design/ redesign solutions. Coordinate Configuration management team code deployments. Environment: Teradata14, Oracle PL/SQL, BTEQ, Basic Unix Senior Associate Consultant Mar 2012 Dec 2014 Company Name － City State Project Description Development maintenance semantic/downstream layer data warehouse Business user reporting. This project aims building maintaining data mart Enterprise Data warehouse, order increase efficiency reporting, support business users performing, robust analytical reporting decision making capability. Responsibilities Performed data analysis gathered columns meta data source systems understanding requirement feasibility analysis. Worked optimizing tuning Teradata views SQL's improve performance batch response time data users Implement code changes change management tools. Worked closely subject matter experts come detailed solution approach design documents. Used Teradata utilities like Bteq export/import Fast Load load data into/out Teradata database. Provided initial capacity growth forecast terms Space, CPU applications gathering details volumes expected Business. Prepared low level technical design document participated build/ review BTEQ Scripts, Reviewed Unit Test Plans System Test cases. Provided support system test, Product Integration Testing UAT. Coordination offshore development onsite assigning job till code delivery signoff. Verified implementation done expected. Done impact assessment terms schedule changes, dependency impact, code changes various change requests existing Data Warehouse applications running Production environment. Provided quick production fixes pro-actively involved fixing production support issues. Liaised different implementation groups (Both source target systems) monitored implementation activities. Analyze business requirements, designs write technical specifications design/ redesign solutions. Involved complete software development life­cycle(SDLC) including requirements gathering, analysis, design, development, testing, implementation deployment. Developed technical design documents (HLD LLD) based functional requirements Coordinate Configuration management team code deployments. Implemented AGILE methodology formal delivery. Environment: Teradata14, BTEQ, Basic Unix, Oracle. ­ Software Engineer Jan 2009 Mar 2012 Company Name － City State Project Description Data Warehousing Services. Description: Data Warehousing Services (DWS) manages platform infrastructure hosting data Group's operational systems providing capability users operational systems query extract information required. DWS manages whole end end change service lifecycle including build, schedule infrastructure support, service desk, risk compliance service finance management. The goals Warehouse to: ­ Provide single version truth ­ Empower users find new information business ­ Provide integrated database model common definitions regardless source data. Data various source systems fed EDW (Enterprise Data Warehouse). Responsibilities: Actively involved enhancing Data Warehousing Application wherein small, Teradata, Prepared high level design document developers participated review build BTEQ, Scripts, Fast loads, Multi load JCLs, Prepared/Reviewed Unit Test Plans System Test cases Worked closely Business Users analysts. Worked BTEQ, Fast load, Fast export loading data Oracle Teradata. Responsible overseeing Quality procedures related project Involved code reviews strictly followed best practices. Design, develop, test complex Teradata BTEQ Scripts Involved complete software development life­cycle(SDLC) Performed unit testing source code. Used interact testing team ensure appropriate testing performed Configuration team code deployments technical writers ensure manuals Synch developed software Environment: Teradata, Main Frame, BTEQ, Fast Load, Fast Export. Education Bachelor Technology Computer Science Engineering JNTU Bachelor Technology Computer Science Engineering, India JNTU Percentage: 71.68 Skills Data Warehouse knowledge, Database design, Oracle SQL, SDLC, Teradata,SQL Testing, Unit Testing, Business Requirements Gathering, Change Management planning, Configuration Management planning, Data Analysis, Data Mart Development, Code Deployment, Feasibility Analysis, Integration Testing, Application Maintenance,Meta data Analysis,Teradata PL/SQL,Teradata BTEQ,Teradata Fastload,Requirements Gathering, Semantic database design, Technical Design, Technical Specifications documents, UAT,Basic UNIX