SUMMARY:

• Teradata Certified Professional(Teradata12) with IT experience in the Business Analysis, Design, Implementation and Testing of Applications using wide range of Technologies including Data Warehousing, Database and reporting systems for Energy, Sales & Distribution, Telecom Industries and banking
• Creating and modifying MULTI LOADS for Informatica using UNIX and Loading data into EDW.
• Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD, TPT and Informatica.
• Worked on analysis and implementation of new features of Teradata 14.10 like block size increase to 1MB,
• Performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35 - 40% in some situations.
• Participated in Capacity planning discussions with management and computed CPU/IO utilization for different time frames
• Experience in creating in automated scripts through shell script /BTEQ to send alert for top cpu queries,space utilization etc
• Created and supported Tableau dashboards
• Creation and Management of Data labs
• 24/7 on call DBA support. Actively involved in all software and hardware Teradata Upgrades like SLES10 to SLES11 upgrade.
• Performed data copy/archive/backup through arc scripts and data mover
• Expert experience with TASM settings.
• With the in-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI and USI and NUSI and JI etc) etc. In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance.
• Day to day DBA activities like managing the databases, users, roles, profiles & access in both Live & DEV including 24 * 7 DBA support.
• Highly self-motivated with an ability to drive similar behavior from team. Focused on grooming junior team members and with emphasis on succession planning.
• Strong management abilities while leading technology teams on large projects. Successful in intense and demanding environments experiencing rapid change through internal growth, acquisition, and revitalization.

Data Integration Tool: Informatica 9.5, Castiron 5.6,SAS DIReporting & Analytics Tools OBIEE, Micro strategy 9.0

Databases: Oracle R12, Teradata(version 14.10)

Data Modeling: Erwin

Productivity Tool: Office Professional (Word, Visio, Excel, PowerPoint, Access, Outlook), Atana suite, visual explain,

Other technical proficiencies: UNIX shell scripting, Teradata SQL, Teradata utilities, Tableau (BTEQ,MLOAD,FLOAD,FASTEXPORT) PL/SQL,SOQL,APEX, Apex data loader, Data Mover, Teradata View point, Tara Gui

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Teradata DBA

Responsibilities:

• Responsible for development and implementation of new features of Teradata 14.10 like 1 MB block size increase, stats manager, TIM analysis and Virtual partitioning in TASM
• Expert in identifying and tuning queries consuming more CPU and skewed queries and modify the queries accordingly to avoid the skew and less CPU.
• Representing in the document review meetings and signing off the Impact analysis, study & design documents from a DBA perspective & also Data warehousing solution perspective.
• Performing the data warehousing space, capacity planning & Analyzing the CPU and IO requirements with the management.
• Checking the tables for which MVC (multi value compression) can be implemented an effective way of saving the warehouse space through Atana Suite.
• Performed data copy/archive/recovery using arcmain scripts and data mover.
• Troubleshooting and Problem Identification & rectification for the batch process and assisting business User community with Teradata queries.
• Providing the consultancy for data warehousing related issues like physical implementations strategy in Teradata for new features etc.
• TASM: Created new workloads (Tactical, SLG Tier and Timeshare), defined exceptions to fine tune the performance of workloads. Performed extensive analysis with virtual partitioning on how the system behaves with partition.
• Adjust DBS control settings in order to accommodate the implementation of TD new features like stats manager and block size increase.
• Creation and management of Data labs, users, access, profiles etc.
• Created automated scripts using shell script and BTEQ to send top CPU/IO consuming queries to DBA team .
• Created automated scripts to send alert of DBA team on space utilization in HTML format.
• Created snipper scripts to abort queries consuming more CPU when other tactical queries are running.
• On call DBA 24/7 support . Actively worked with Teradata GSC when system is down or system experience slowness due to network issue.

Confidential, San Ramon, CA

Teradata DBA

Responsibilties:

• Developed BTEQ,MLOAD, FASTLOAD,FAST EXPORT scripts on UNIX plat form to move data from one database to another.
• Developed complex shell script incorporating BTEQ,MLOAD scripts to automate few reports like moving space from one database to another and Stats collection in Teradata and also send email to DBA group in HTML format.
• Performed data copy over through data mover and arc scripts to copy data from one database to another.
• Done source system analysis and end to end coding with ETL Mapping / Source to Target mapping, BTEQ scripts, Fast Export, shell scripting as per the Business requirements.
• Implementing and managing the Security solutions using TDWM and roles.
• Interacted with business users and BO Reporting and understood the performance issues. Suggested modifications in the Universe and Teradata Database macros (Bteq scripts) for performance improvement.
• Worked on the Teradata database (Teradata 14.10) and implemented Table partitions and Teradata best practices for the Teradata performance improvement.
• Created De-Normalized aggregate tables to improvement the performance on the BO reports.
• Interacted with ETL team and suggested improvement on the control table, and the ETL macros enhancement, best practices which improved the ETL performance. With the induction of the Control Table in ETL Code, the ETL Loading window time reduced drastically from 13 hrs to 5 hrs.
• Created new workloads and defined exceptions in TASM to fine tune the performance of the workload.
• Fine-tuned the Teradata SQL queries / BTEQ scripts for the performance improvement. This is applicable for BO generated Bteq scripts and ETL macros.
• Responsible for preparing production support documentation and provide 24/7 ops support for any data related issues.
• Good knowledge of DBS control file settings.
• Developed complex shell scripting for automation of 172 file generation process to validate the data file and trigger file for any format issues.
• Interacted with the Business teams and understand the requirements and work on the Logical (FSLDM) to Physical Data Modeling (PDM).
• Closely interacted with business and DBA to come up with the DATA model for the Teradata Data warehouse environment.
• As part of Teradata DBA group created Roles, Profiles, Users and granted access the required roles and profiles

Confidential, San Jose, CA

Teradata Architect

Responsibilities:

• As Teradata Lead extensively worked on Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc
• Over 8 years of experience on Teradata development and OLAP operation with Teradata database
• Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, FastExport, Tpump, Visual Explain, Query man, TPT).
• Loaded the data into the Teradata database using Load utilities like (Fast Export, Fast Load, MultiLoad, and TPT).
• Expertise in performance tuning the user queries. execution of frequently used SQL operations and improve the performance
• Extensive experience in EDW data modeling, preparing for Logical and physical data modeling sessions, ETL Architecting, Spec writing and developing ETL mapping.
• Led BI development team with onsite, offshore developers. Responsibilities include business user engagement to gather requirements, data modeling, architecture, timelines for tasks, technical solutions for data movement, development progress monitoring, QA and support transition
• End to End project execution from requirement gathering to delivery of the code
• Onsite Delivery Lead - Managed the requirements analysis, Design, SIT and Delivery phases. Close interaction with Business Analysts, Business Users and Client POC’S and IT Project Manager
• Interfaced with business users - to drive requirement gathering and with source systems - achieve cross platform System Integration.
• Good experience in writing SQL Queries, performance tuning of SQL queries, creating adhoc reports, on demand SQL data reports, identifying the problem and troubleshooting. Experience in ability to work across Microsoft and UNIX platforms.
• As a Technical Project Lead, responsible for delivery ownership involving
• Business Requirement Gathering and Analysis
• Play a progressively larger role in managing delivery of the onsite and off-shore model projects
• Build System Architecture, high Level and low level design
• Help other members of the business intelligence team and execute work with reference to ETL

Confidential, San Jose, CA

Member of Technical Staff

Responsibilities:

• Project executions using Agile Methodology since Jan 2012.
• Proficiency in SFDC Administrative tasks like creating Profiles, Roles, Users, Page Layouts, Email Services, Approvals, Workflows, Reports, Dashboards, Tasks and Events
• Extensive experience in analyzing business requirements, entity relationships and converting to Salesforce custom objects, lookup relationships, junction objects, master-detail relationships
• Experience in migrating data from legacy systems to Salesforce using Apex Data Loader.
• Extensive experience in data migration and integration using Data Loader
• Responsible for end to end data migration from Salesforce.com to EDW and EDW to Salesforce using ETL tools like Informatica/Castiron.
• EDW data modeling, preparing physical data models, ETL Architecting, Spec writing and developing ETL mapping.
• Led BI development team with onsite, offshore developers. Responsibilities include business user engagement to gather requirements, data modeling, architecture, timelines for tasks, technical solutions for data movement, development progress monitoring, agile processes for application development, QA and support transition
• Architected and developed data marts (POS - Point of Sale Dashboard, PET - Product Experience Tracker, C2.0 - Confidential webpage re-design) to capture metrics about customer adoption of new features, average response time of clicks, API calls made etc., Leveraged expertise in Teradata Cost Based Optimizer (collect statistics) and Explain Plan to identify potential bottlenecks with queries including skewed redistributions, join order and defined indexing strategies (primary, secondary and aggregate). Recognized for delivery in complex projects through Excellence awards.
• Physical data modeling deliverables for complex data marts (POS, PET, C2.0) using Castiron and Informatica (staging, work and target structures)
• Data movement solutions from Flat /CSV/XML files using BTEQ, FastExport, Multiload, FastLoad utilities, TPT (Teradata Parallel Transporter); Oracle database using Golden Gate; Informatica push down optimization techniques.
• Best practices on application delivery including development standards, code reviews, support management, jobs monitoring (debug and resolve failures through support tickets process), test case (unit, integration, user acceptance) development and knowledge sharing with offshore team.
• Performance tuning - More than 1 million CPU seconds savings by tuning various queries related to web logs (Cal and Omniture), 0.6 million CPU seconds/week on P1 queries (using Join indexes), and overall query performance improvement by 40% in multiple situations.
• Created the data model using for each subject area and accommodate the model with EDW data model.
• Designed the Informatica mapping guidelines to handle the huge volume of data. Performance tuning of source query and Informatica mapping.
• Worked with Business Users to analyze the business process and made necessary changes to schema objects to cater their reporting needs.
• Lead the 15 member team combined onsite and off-shore and aggressively managed personnel across all departments

Environment: Informatica, Castiron, Teradata, Unix, Erwin, Agile/iterative Apex data loader, Unix shell scripting,Apex

Confidential, San Jose, CA

Sr. Software engineer

Responsibilities:

• Onsite consultant for client ( Confidential )
• Extracted source data using SQL query to analyzed the different APD products data based on the requirement and defined the system integration specifications.
• Prepared the requirement document, mock up reports and test plan for the functional testing
• Interfaced with business users - to drive requirement gathering and with source systems - achieve cross platform System Integration.
• Acted as liaison for offshore delivery, responsible for driving resource planning, work allocation and issue resolution and effort estimation for projects in the pipeline.
• Reviewed various BRD, SRS and Technical design document.
• Designed and implemented ETL framework to run the SQL program dynamically.

Environment: Informatica, Castiron, Unix, Erwin

Confidential, San Jose, CA

Sr. Software engineer

Responsibilities:

• Responsible for technical and system integration support for delivery of multiple data marts and reports. Monitored various ETL jobs, performed DB operation as application DBA.
• Performed as Data warehouse and ERP programmer analyst, delivering high performance technical solutions.
• Gathered end user requirements for ERP customizations, prepared functional specifications, analyzed logical data models, generated technical design documents, created physical objects, developed ETL, performed code migration, test plans and job scheduling activities.
• Oracle ERP (11i) implementation customizations to support Quote to Cash functionalities such as customer data and order imports, customer validation (scrubbing using 3rd party software)
• Led onsite project implementation team of 5.
• Delivery of data mart to support web log information analysis from Clickstream including data movement using Informatica transformations (router, joiner, sequence generator, expression, lookups), maplets/mappings/workflows, analytical reporting using OBIEE, testing with Test Director, code migration with Kintana and performance optimizations using Tkprof and Explain Plan.
• Implemented Star schema design to support the aggregated call center data and build the cube for analysis.
• Design and implemented survey scoring model data mart and integrated with call center data.
• Drove system performance turning, effort estimation for future initiatives. Standardized production support processes to streamline maintenance activity.
• Implemented multiple releases in quick succession; addressed existing performance issues.

Environment: Informatica 8.1, Oracle, PL/SQL, OBIEE, SDLC

Confidential

Software Engineer

Responsibilities:

• Worked for clients including Spel, Micropack
• Provided consulting services on Oracle ERP and data mart implementations. Responsible for end to end coordination and interaction with business users to implement customizations
• Work activities included writing technical documents and test plans, designing and developing custom objects, testing and supporting.
• Performed Oracle ERP customizations using Stored Procedures, Oracle Forms and Oracle Reports
• Delivered Status reports to steering committee
• Developed and implemented projects using Informatica and Oracle