EXPERIENCE SUMMARY:

• Having 7.5 years of IT experience in fields of business process analysis, Data Analyst, ETL & Teradata Development, Production Support and Software Quality Assurance with strong background of data warehousing.
• Over 5 years of Domain expertise in HR, Expense, Customer, Travel.
• Extensiveexperience in Data Warehouse techniques and practices with good knowledge of database designing, BI Methodologies with strong understanding of Dimensional Modeling, Star and SnowflakeSchemas, OLAP, Relational and Multi - Dimensional Databases.
• Played a key role in implementation of the Teradata 13.10 upgrade in Dev, Stage and Production environment.
• Coordinate end to end Enterprise Infrastructure Releases in operations.
• Experience in Performance tuning with in-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks with the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI, USI, NUSI and JI).
• Strong technical skill in Teradata SQL including processing high data volumes, BI Reporting.
• Used BTEQ, Fast Load, Multi Load, and Fast Export utilities to load and export from target database.
• Worked on Informatica power Center 8.1, 8.6, 9.1, 9.5 ETL tool, Mapping Designer, Transformations, Repository Manager, and Workflow Monitor.
• Implement SCD type 2 and type1 by using Informatica ETL tool and TD SQL assistant.
• Experience in integration of various data sources with Multiple Relational Databases like Teradata, Oracle, and SQLServer.
• Used extensively Derived and Volatile Tables in many of the BTEQ scripts.
• Proficient using in RDBMS like Oracle, SQL Server, Teradata, PL/SQL, SQL *PLUS, SQL *Loader and TOAD.
• Operation Reviewer of Change Control Review Board for EDW and played a major part in implementing standards and ensuring high quality.
• Worked 7 years on the Global Delivery Model (Onsite - Offshore) with proven Customer People Management skills.
• Actively involved in gap analysis, business refinement process and risk assessment.
• Strong in Business requirement analysis and functional specification design and documentation.
• Excellent understanding of the Software Development Life Cycle & Production Support.
• Pro-Active to production Issues, proficient in meeting deadlines.
• Having strong communication skills and capability of handling P1/P2 issues.
• Extensive Experience in drawing Data Flow Diagrams/Process Diagrams.
• Proficient in Quality Centre Tool, Data-driven testing and writing SQL queries for database manipulations, preparing test plan, test cases, test procedure, test scripts, test summary reports and for automated and manual testing based on user requirements and functional specifications of the system.
• Achieved Excellence Award from CISCO and many client appreciation emails for outstanding work.
• Involved in all the phases of the software development life cycle.
• Strong analytical, logical and problem solving skills and ability to quickly adapt to new technologies by self-learning.
• Able to work independently and collaborate proactively & cross functionally within a team.
• Fast learner and Ability to grasp new technologies.

TECHNICAL SKILLS:

Languages: C, C++, PL/SQL, UNIX

Test Tools: Quality Center 9.x

ETL Tool: Informatica Power Center Teradata Utilities(BTEQ, Fast export, Fast load, TPUMP)

Database: Teradata, Oracle 11g,10g/9i, SQL Server 2005, MS Access

Database Tools: SQL*PLUS, SQL Assistant, TOAD, MS Analysis, Teradata SQL Assistant

Domain: HR, Expense, Travel, Customer, Partner

Operating System: Windows XP/Vista, UNIX, MS DOS

Others: Dollar Universe, Kintana, PVCS, Remedy Alliance Tool

PROFESSIONAL WORK EXPERIENCE:

Data Analyst

Confidential, San Jose, CA

Responsibilities:

• Gathering information from different data sources and provides detailed data analysis.
• Identify opportunities to reduce data redundancy.
• Used data analysis techniques to validate business rules and apply the short term and long term fixes to resolve the issues according to the priorities.
• Review data to determine operational impacts and needed actions.
• Conducted GAP analysis to analyze the variance between the system capabilities and business requirement.
• Extensively designed data mapping and filtering, consolidation, cleansing, integration, ETLs and customization of data mart.
• Worked with project team representatives to ensure that LDM, PDM and ETLs were developed in line with corporate standards and guidelines.
• Provide advanced analytical support for business operations in following areas: Expense, HR, Travel, Customer, Party, Partner, and Shipment.
• Develop reports and deliverables for management.
• Extract, load, model and reconcile large amounts of data across multiple systems.
• Work hands on with Informatica Admin, Oracle and Teradata DBAs to optimize systems scalability and performance.
• Defined the Achieved and Purged mechanism to optimize system without impacting data quality.
• Perform data quality profiling on various source systems for better understanding of data and surface data quality opportunities while working with SME and data stewards.

Environment: Teradata 13.10, Oracle 11g, Toad, UNIX, Informatica 9.5.1, Windows, Kintana, $U, PVCS

OPS Project Lead

Confidential, San Jose, CA

Responsibilities:

• Interact with Teradata Support Team, DBA, Admins to understand the list of their activities and interdependency on their deployment.
• Prepare High Level Execution Plan (HLEP) and instruct each team when to start their activity and take confirmation after completion and sanity check.
• Prepare the power point presentations to share the plan, risks, impact and mitigation to senior management and end users and take their approvals.
• Work with 35+ application teams subscribing data from EDW TD system for their impact analysis and sign off.
• Periodically send the wider communication to all the EDW stake holders with the latest updates and issues.
• Align EDW Operations team on holding and releasing all the refreshes in the period of 20 hours.
• Closely monitor the progress and deployment of each task.
• Responsible for the system testing after completion of the upgrade and bring all the end users back to TDPROD machine from TDPROD2.
• Provide 24 hour support to complete the upgrade.

Environment: Teradata 13.10, Oracle, Toad, UNIX, Informatica, Windows, Kintana, $U, PVCS

Data warehouse Analyst

Confidential, San Jose, CA

Responsibilities:

• Analyze source systems in response to new functionality requests to Enterprise Data Warehouse and summarize the findings to business and downstream application team.
• Designed and develop extract-transform-load (ETL) modules, data quality rules, exception management workflows.
• Implement the slowly changing dimensions - Type 1 and Type II in dimension tables.
• Created and modified PPI, Indexes, Statistics, character sets, Materialized tables etc.
• Tunes the existing SQL and achieved increased performance for faster user query performance.
• Write complex SQL queries for data analysis.
• Work closely with logical and physical data modelling team for the new changes and get it approved.
• Prepare the functional, technical and ETL design document.
• Create the audit scripts and reports to check the data quality and share the results to management at the same time.
• Perform impact analysis to assess impact of source changes to the Enterprise Data warehouse.
• Prepare the communication template and inform all the stake holders about the impact to EDW and their respective applications due to Enterprise Infra Release.
• Troubleshoot and resolve common operational issues and escalate if required.
• Implement 100+ change requests including ECR to resolve the code, data and ETL scheduling issues.
• Coordinate Scheduled outages for the appropriate reporting and extract application teams.
• Lead a team of 6 offshore leads and managed their activities through daily/weekly calls and status report.
• Provide 24*7 problem management supports to the end users and downstream application.

Environment: Teradata 13.0, Oracle 10g, Toad, UNIX, Informatica 9.1.0, Windows, Kintana, $U, PVCS

Informatica Teradata Developer

Confidential, San Jose, CA

Responsibilities:

• Understand the Biz requirement and prepare Functional Specification and Technical Specification Documents (BRD and TSD) and communicated with the cross functional team about the changes and timelines.
• Design the ETL strategy for both history and Incremental loads.
• Participated in the Logical and Physical Data Model (LDM, PDM) session for the changes in target system.
• Loaded the data into the Teradata database using Load utilities like (Fast Load and Tpump).
• Create the de-normalized materialized tables by joining required 3NF tables for faster data retrieval.
• Use the Fast export to publish the data to downstream through Published views created on 3nf and MT tables.
• Design and develop Informatica mappings, sessions, workflows and identify areas of optimization to improve the ETL performance.
• Use the BTEQ Scripts for history data fix.
• Worked with data modeler for Dimensional Data Modeling, E-R Modeling, Multi-Dimensional Database Schemas like Star Schema and Snowflake Schema (Fact and Dimensional Table).
• Store data both in Slowly Changing Dimension Type I and Type II.
• Effectively handle large data volume while addressing out of spool conditions.
• Used in - depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks, skewed redistribution, join order, physical design considerations (PI, NUPI, UPI, USI, PPI).
• Worked on Informatica Powercentre 8.X designer, workflow manager, workflow monitor, repository manager.
• Review of all offshore deliverable and artifacts (ETL Code review, Technical Design Review, Deployment Plan, Unit Test cases and Results).
• Providing post implementation support to the production support team(s).
• Manage offshore resources and ensure quality code is delivered to the client on time.
• Involved in production deployment and post deployment support.

Environment: Teradata, Oracle, Toad, UNIX, Informatica, Windows, Kintana, $U, PVCS

Confidential

Support Lead

Responsibilities:

• Understand the new project requirement going to deploy in PROD.
• Document the service level agreement which is sign off by subscriber, application team and EDW managers.
• Quickly identify the issue and apply the fix after getting approval from Data Analyst.
• Execution of Batch jobs, monitoring, prepare the plan for holding and releasing the list of jobs at the time of database downtime due to infra release.
• Understanding of Relational, Dimensional data Model for different subject area.
• Write complex SQL to validate the data.
• Resolve the jobs aborts in very short time and complete the refresh in the SLA time.
• Tune the ETL for better performance.
• Load the huge volume of data with in SLA time.
• Review the change requests deploy by the development team.
• Identify the bottleneck in the system and provide the solution to resolve it.
• Draft the daily status email with start and end time of data refreshes, job issues, performance issues and key call outs.
• Work in different shifts to provide 24*7 support.

Environment: Oracle, Toad, UNIX, Informatica, Windows, Kintana, $U, PVCS

Confidential

Developer

Responsibilities:

• Develop and maintain technical and functional design documents.
• Worked with relevant Subject Matter Experts (SME) to perform detailed source system analysis.
• Define the key attributes for each interface and mapping.
• Created Dimension and Fact Tables as per the Data warehouse design.
• Developed reusable transformations and Mapplets to use in multiple mappings.
• Integrated various sources into the staging area in Data warehouse to integrate and for cleansing data.
• Implemented views, synonyms, hints, partitioning of tables, clustered and non-clustered indexing.
• Migrate the ETLs from Dev environment to QA and Production environment at the time of code deployment.
• Maintained a close and strong working relationship with team mates and management staff to achieve expected results.
• Worked with the users to do the User Acceptance Testing.
• Hands on QA Analyst, responsible for coordinating and performing functional testing.

Environment: Oracle, Toad, UNIX, Informatica, Windows, $U.

Confidential

Quality Analyst

Responsibilities:

• Involved in Integration, Functionality, Regression, Installation and Configuration testing.
• Expertise in testing the complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Tested connected and unconnected Lookup transformations to look up the data from the source and target tables.
• Executed SQL scripts to test if the data was populated correctly into the target tables.
• Worked very closely with Biz Analyst and Developers to show the testing results and understand their requirements and to analyze with every test case that project has been developed as per the requirement or not.
• Involved in creating the Test plan, test strategy and testing of end-to-end scenarios.
• Manually tested the functionality of the client application.

Environment: Quality Center 9.0, Oracle, Toad, UNIX, Informatica, Windows.