SUMMARY

• Over 11+ years of experience in IT Industry, of which 6 Years’ Experience in Data Warehouse experience in managing and Delivering projects using Teradata and Informatica Power center, Hadoop in modules likes Quoting, Ordering and Bookings.
• Extensive Experience in Develop, execute and manage projects within the defined scope, timeline
• Proficient in understanding business processes/ Functional requirements and translating them into technical requirements.
• Functional knowledge on Quoting and Ordering and Bookings, Oracle Apps.
• In - depth knowledge of the Informatica, Teradata, Oracle.
• Hands on Experience in Usage of Hive queries.
• Hands on experience in Designing and Developing Informatica ETLs (workflows, Pushdown Optimization techniques, Performance tuning)
• Proven technical skill set that has been demonstrated in the development of enterprise data warehouse
• Have very good experience in trouble-shooting techniques, tuning SQL statements, Query Optimization, Join Indexes.
• Hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, Multi Load)
• Hands on experience on Oracle, SQL, PL/SQL, Functions, Stored Procedures.
• Basic Knowledge on Unix.
• Having Experience in Version Tools like PVCS, SVN, Clear Case.
• Having Experience in Scheduling Tools like Dollar, Tidal, WLM.
• Strong time management skills and multitasking abilities
• Efficient Communicator, highly creative, motivated and result oriented.
• Combining proven investigative skills with analytical mind, identifying opportunities and working out strategies to realize it.
• A result oriented approach with a good proven track record with excellent interpersonal and good communication skills with proactive attitude and leadership qualities
• Exceptional ability to learn new technologies and to deliver outputs in short deadlines.
• Excellent interpersonal skills, ability to work well with others, in both supervisory or development.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9x and Big Data Edition

Tools: and Utilities: BTEQ, Fast Load, MultiLoad, Toad, $Universe, SVN

Languages: Teradata SQL Assistant, SQL, PL/SQL, Oracle Apps, HIVE

Reporting Tools: Crystal Reports 8.5

Web Development Technologies: HTML, JavaScript, ASP.Net, VB.Net

Database: Teradata 14 and Oracle 11g

Operating Systems: Windows and Unix

Versioning Tools: PVCS, SVN, Clear Case

Scheduling Tools: DollarU, WLM.

PROFESSIONAL EXPERIENCE

Systems Analyst

Confidential, Sunnyvale, California

Responsibilities:

• Requirements analysis, data assessment, business process reengineering.
• Interacted with business-users and business analysts to identify and develop business requirements and transform it into technical requirements and ultimately will be responsible for delivering the solution.
• Actively involved in analyzing, designing and development of the project.
• Proficient in understands Teradata EXPLAIN plans, Collect Stats option, Secondary Indexes (USI, NUSI), Partition Primary Index (PPI), Volatile, global temporary, derived tables etc.
• Used Load utilities (BTEQ, Mload, and Fast Load) to load the data into Teradata.
• Developed and scheduled Workflows using workflow designer, in Workflow manager and monitored the results in Workflow monitor.
• Autosys to setup the Job Schedules.
• SVN portal for version control.
• Unix Scripts to check the File Validations.

Senior Systems Analyst

Confidential, Richmond, Virginia

Responsibilities:

• Requirements analysis, data assessment, business process reengineering.
• Interacted with business-users and business analysts to identify and develop business requirements and transform it into technical requirements and ultimately will be responsible for delivering the solution.
• Actively involved in analyzing, designing and development of the project.
• Proficient in understands Teradata EXPLAIN plans, Collect Stats option, Secondary Indexes (USI, NUSI), Partition Primary Index (PPI), Volatile, global temporary, derived tables etc.
• Used Load utilities (BTEQ, Mload, and Fast Load) to load the data into Teradata.
• Developed and scheduled Workflows using workflow designer, in Workflow manager and monitored the results in Workflow monitor.
• WLM to setup the Job Schedules.
• Clear Case portal for version control.
• Unix Scripts to check the File Validations.

Technical Lead

Confidential, San Jose, California

Responsibilities:

• Requirements analysis, data assessment, business process reengineering.
• Involved in complete SDLC (System Development Life Cycle).
• Researched Sources and identified necessary Business Components for Analysis.
• Interacted with business-users and business analysts to identify and develop business requirements and transform it into technical requirements and ultimately will be responsible for delivering the solution.
• Actively involved in analyzing, designing and development of the project.
• Tuned SQL statements, Query Optimization and analysis in query performance issues in Teradata
• Proficient in understands Teradata EXPLAIN plans, Collect Stats option, Secondary Indexes (USI, NUSI), Partition Primary Index (PPI), Volatile, global temporary, derived tables etc.
• Used Load utilities (BTEQ, Mload, Fast Load) to load the data into Teradata.
• Designed and developed Informatica Mappings and Sessions, Workflows based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Developed and scheduled Workflows using workflow designer, in Workflow manager and monitored the results in Workflow monitor.
• Designed, developed and documented the ETL processes using Informatica for extracting the data and data transformations.
• Created mappings and applied transformations on the tables and created sessions for running the processes in Informatica.
• $U design and development, Kintana, PVCS
• Dollar Universe tool as scheduling tool which calls the Informatica workflows through Unix shell scripting
• QA Support and deployment support

Team Lead

Confidential

Responsibilities:

• Researched Sources and identified necessary Business Components for Analysis.
• Interacted with business-users and business analysts to identify and develop business requirements and transform it into technical requirements and ultimately will be responsible for delivering the solution.
• Actively involved in analyzing, designing and development of the project.
• Tuned SQL statements, Query Optimization and analysis in query performance issues in Teradata
• Proficient in understands Teradata EXPLAIN plans, Collect Stats option, Secondary Indexes (USI, NUSI), Partition Primary Index (PPI), Volatile, global temporary, derived tables etc.
• Used Load utilities (BTEQ, Mload, Fast Load) to load the data into Teradata.
• Designed and developed Informatica Mappings and Sessions, Workflows based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Developed and scheduled Workflows using workflow designer, in Workflow manager and monitored the results in Workflow monitor.
• Designed, developed and documented the ETL processes using Informatica for extracting the data and data transformations.
• Created mappings and applied transformations on the tables and created sessions for running the processes in Informatica.
• $U design and development, Kintana, PVCS
• Dollar Universe tool as scheduling tool which calls the Informatica workflows through Unix shell scripting
• QA Support and deployment support

Confidential

Team Lead

Responsibilities:

• Analyzing & Generating MIS Reports.
• Automation of day to day activities using PLSQL Procedures and schedulers.
• Analysis and design catering to the requirements. It involves High Level Design documentation.
• Development and Bug Fixes: Using PLSQL and ASP.
• Develop the queries in PL/SQL for the data retrieval for reporting process of management.
• Estimation of the work based on the requirement.
• Working as a Team Lead for MIS and Operations and giving Technical Support.
• Managing Central OSS and Operations teams and providing technical support.

Confidential

Senior Software Engineer

Responsibilities:

• Involved in Maintenance.
• Resolving issues and Modifications for new enhancements.
• Development and Bug Fixes: Using DOTNET and VB.
• Develop the queries and Stored Procedures in SQL Server 2000 data retrieval for reporting process of management.
• Developed reporting using Crystal Reports 8.5.

Confidential

Senior Executive

Responsibilities:

• Requirement analysis.
• Involved in coding.
• Development and Bug Fixes: Using PLSQL and ASP.
• Generating reports

Confidential

Senior Executive

Responsibilities:

• Requirement analysis.
• Involved in coding.
• Development and Bug Fixes: Using PLSQL and ASP.
• Generating reports