SUMMARY

• Software consultant with more than 14 years of experience in IT Industry, of which 10 Years’ Experience in Data Warehouse experience in managing and Delivering projects using Teradata, Informatica Cloud and Power Center, Hadoop in modules likes Billing, Quoting, Ordering and Bookings, Internet Solutions, Retail and Marketing.
• 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 Retail, Internet, Quoting and Ordering and Bookings.
• Experienced in working with Teradata ETL utilities like Fast Load, Multi Load, Tpump and Fast Export. Also, worked extensively on Teradata Query Submitting and processing tools like BTEQ and Teradata SQL Assistant.
• In - depth knowledge of the Informatica Power Center, IICS, Teradata, Oracle, Postgress
• 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.
• Basic working experience and Knowledge on Unix
• Having Experience in Version Tools like PVCS, SVN, Clear Case, GITHUB.
• Having Experience in Scheduling Tools like Dollar, Tidal, WLM, UC4.
• Strong time management skills and multitasking abilities
• 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 and worked in onshore and offshore model.

TECHNICAL SKILLS

• TD Utilities: TD SQL Assistant, BTEQ, Tpump, Fastload, FastExport, MultiLoad
• ETL Tools: Informatica Power Center 10x, Cloud and Big Data Edition
• 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 16 and Oracle 11g, Postgress
• Operating Systems: Windows and Unix
• Versioning Tools: PVCS, SVN, Clear Case, GITHUB
• Scheduling Tools: DollarU, WLM, and UC4, GITHUB, SVN

PROFESSIONAL EXPERIENCE

Confidential

Teradata Developer

Responsibilities:

• Used Load utilities (BTEQ, Mload, Fast Load,TPT) to load the data into Teradata
• Tuned SQL statements, Query Optimization and analysis in query performance issues in Teradata
• Ingesting data from different sources, SQL SERVER, POSTGRES into Teradata.
• Proficient in understands Teradata EXPLAIN plans, Collect Stats option, Secondary Indexes (USI, NUSI), Partition Primary Index (PPI), Volatile, global temporary, derived tables etc.
• Unix Scripts to check the File Validations.
• 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.

Confidential

Senior ETL Developer

Technologies: Teradata, Informatica Power center, IICS, Big Data, UNIX, GITHUB.

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.
• UC4 to setup the Job Schedules. GITHUB portal for version control.
• Unix Scripts to check the File Validations.

Confidential

Systems Analyst

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.

Confidential

Senior Systems Analyst

Technologies: Teradata, Informatica Power center, IICS, Big Data, UNIX, GITHUB.

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.

Confidential

Technical Lead

Technologies: Teradata, Informatica, UNIX, DollarU, SVN.

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, and 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.
• Requirement analysis.
• Involved in coding. Development and Bug Fixes: Using PLSQL and ASP. Generating reports.