PROFESSIONAL SUMMARY:

• Data Warehouse ETL solution Architect with over 13+ years IT experience in Analysis, Design, development and Implementation of in diversified projects in the domain of banking, Telecom, Retail and ePayments.
• Teradata Certified Master V2R5 with core expertise in Teradata Architecture, Application administration, database design, ETL Architecture, Physical data modeling, Teradata utilities and performance optimization.
• 8 years of experience in Teradata DWH technology providing solution towards databases ranging from Terabyte to Petabytes.
• 5 plus years of experience in design & development of complex ETL solutions using Informatica.
• Expertise in configuration and administration of Castiron application Integration.
• Excellent track record of solving complex business problems using advanced technology solutions.
• Demonstrated strong leadership skills in managing & delivery complex projects.
• Have a proven track record of successes in team development and customer relationship management.
• Well versed in Software Development Life Cycle, software engineering, data analysis, programming and software design skills.
• A talented strategist, communicator, project leader and maintains customer relationship. Trusted advisor to management. Areas of expertise include:
• Project Planning and estimation, schedule control, execution, implementation phases
• Problem Identification & Resolution
• Process improvements
• Technical Documentation and Change Implementation
• Having a strong foundation of proven methodologies, best practices, and architecture and guidelines on enterprise application Integration

TECHNICAL SKILLS:

ETL Process Tools: Informatics Power Center 9.1, Teradata Utilities, Abinitio, Data Stage

Data base: Teradata V2R5/ V2R6/ Teradata 12/ 13.10/ 14.0, Oracle 10G, MSSQL Server 2000

Programming Languages: Java,, C++, C, XML, PL/SQL, Unix shell programming

Operating Systems: AIX, Sun Solaris, Mac OSX, Windows, Linux

Data Modeling Tools: Erwin 4.0, Sybase Power Designer

Other Tools: Salesfore.com, Xactly and Castiron (EAI integration)

Monitoring Tools: Viewpoint, Teradata Manager, PDCR, PerfWeb

Big Data: Hadoop, HBase and Map Reduce - (beginner)

PROFESSIONAL EXPERIENCE:

Teradata Application DBA/Physical Data Modeler

Confidential, Austin, TX

Environment: Teradata, Linux, Castiron, Informatica and Micro strategy

Responsibilities:

• Involved in the design review meetingswith ETL development teamsand designed Physical model for ETL projects and suggested for improvement areas for EDW BI space.
• Review and convert LDM model into high performing physical model.
• Proactivelykeeps the system Usage under Control by finding new opportunities to improve existing jobs as part of Platform management
• Provide support to multiple Teradata systems, understanding the client’s Business goals, IT plans and articulated linkage to the data warehouse architecture and application design
• Designed and executed Benchmarking for Resource consumption and workload analysis on Teradata Software new versions (TD 13.10 v/s TD 14.xx.x), TASM Setting for (SLES10 v/s SLES11) and Hard ware Configuration (3+1 clique +2+1 Clique).
• Performance Tuning of batch& user queries and recommend better ways of writing code for optimal usage of the system resources and spool.
• Implemented at MVC on EDW huge tables and Block Level Compression analysis/implementation,PI revision/Implementation, PPI extension, Join Index implementation and table rebuilds as year-end activities. Analyze Query Log on Table and Column Vector usage and identify new Secondary Index and Join Index
• Identify the opportunities for CPU savings by redesign EDW tables and optimize the Teradata batch workloads and TD user queries for Better performance and CPU savings.
• Implemented User and Business Unit level CPU limit program which looks up resource consumption metrics and re-classifies user accounts profiles

Confidential, San Jose CA

ETL Architect-Operations Support Lead.

Responsibilities:

• Develop of proof of concepts and provide suggestions to the development teams for better performance of ETL process. Also tune the ETL jobs for better performance tune.
• Automate the manual processes and developed scripts to generate operational metrics for higher management.
• Proactively figure out delay in extracts or application performance impacting the SLA, do a follow up with DBAs and raise SEV calls to resolve the issues.
• Send checkpoints as expected on a regular basis. Develop an in-depth understanding of the business processes supported by the system.
• Reviews and approves solution designs, technical specifications, and ETL processing designs. And suggest for improvement areas for EDW operations space.
• Provide day-to-day technical support in maintaining the information system, including responsibility for ensuring batch processes and reports error-free.
• Acting as onsite lead and coordinate with team to make sure the batch process complete without any issues. Works with on/off shore teams to insure ‘best practice’ standards and process.

Confidential, San Jose CA

ETL Architect - Project lead

Responsibilities:

• Involve in the requirement meetings along with Business analysts.
• Design and Architect the ETL process.
• Prepare the Technical specification documents
• Day-to-day planning and management of engagement activities
• Manage and execute the project and ensure quality process maintenance.
• Work closely with business users in understanding the Business requirements and deliver the client expectations.
• Prepare weekly status reports and communicate with all project stakeholders
• Conduct project assessments and estimation.
• Track the progress on all projects
• Analyze and Escalate risks in timely manner
• Provided technical leadership to execution team like Design and solution approach
• Implement End to End Deliverables

Confidential, Cupertino, CA

Environment: Oracle 10G Unica, JCM, XTSNAP, UNIX.

ETL Tech Lead

Responsibilities:

• Understanding customer specific business rules and practices, user requirements and preparing specifications, design document and Implementation document.
• Analyze, identifythe coding and extracting data from different database sources and extract data into the flat files, which will be input for the applications.
• Design and develop ETL process using tools JCM and XTSNAP (Internal ETL Tools).
• Design the Automate process that reports are running manually and implemented.
• Design and develop aggregate tables and Performance tunin