SUMMARY:

• Around 9 years of IT experience in design, development and implementation of projects in Data Warehousing.
• Extensive experience in working on databases like Netezza, Teradata and Oracle.
• Strong knowledge in UNIX Shell Scripting and scheduling using CRONTAB.
• Expertise in Netezza Architecture and database concepts like NZSQL, NZLoad, Zone Maps, CBT.
• Good knowledge on Teradata architecture, SQL and data load/export utilities like BTEQ, Multi Load and Fast Export.
• Completed the certification and obtained the title “TERADATA 12 CERTIFIED PROFESSIONAL” on the Basics of Teradata Architecture.
• Involved in understanding and translating the business requirements to High Level and Low level design for implementation.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Extensive experience in various projects across the Telecommunication domain.
• Experience in performance tuning of SQL queries in Netezza and Teradata.
• Multi environment working experience across platforms like UNIX and Windows.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and Denormalization Concepts.
• Completed Organization level certifications on .NET and Operating System (UNIX).
• An excellent team player and team leader with an ability to perform individually with strong verbal, interpersonal, leadership and written communication skills.
• Competent in the Global delivery model with effective co - ordination of the team to meet deadlines and deliverables on time.

TECHNICAL SKILLS:

Databases: Netezza, Teradata, Oracle 9i/10g

Tools: SQL*PLUS, TOAD, WinSQL, MS Office, Secure CRT, Putty, TIDAL,Quality Center, CITRIX, MS Visio, BMC Change/Remedy Management

Languages: C, C++, SQL, UNIX Shell Scripting

Versioning Tools: Tortoise SVN, WinCVS, SharePoint Server

Operating Systems: Windows 7/Vista/XP, UNIX

ETL: Informatica Power Center 9.x

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

ETL Development Lead

Responsibilities:

• Developed and Implemented stored procedures to get the usage flat files to the Teradata environment and perform the data quality checks on the data.
• Developed and Implemented the Viewership Fact and Several Dimensional tables using Hive and HDFS.
• Exploring and understanding the use TALEND as a tool for creating and automating the run of Hive queries over Spark to load data.
• Working closely to provide solutions to the day to day adhoc requests from business which help in their varied analytics on viewership data.
• Performed Unit Testing and created Unit Test Case documents.
• Managed the co-ordination and utilization of offshore developers.

Environment: Teradata, Hive, HDFS, WinSCP, UNIX, One Automation, SVN, HP ALM.

Confidential, Charlotte, NC

ETL Development Lead

Responsibilities:

• Developed and implemented the automated data extracts over Legacy Confidential system for the Product Intelligence Team.
• Developed and implemented the automated data extracts over the Legacy Bright House Networks system for the Product Intelligence Team.
• Delivered adhoc requests for ETL changes on the Legacy Confidential data on the XBI Layer.
• Performed Unit Testing and created Unit Test Case documents.
• Managed the co-ordination and utilization of offshore developers.

Environment: Teradata, Netezza, Oracle, Toad for Oracle, WinSQL, UNIX, TIDAL, SVN, HP Quality Center.

Confidential, Charlotte, NC

ETL Development Lead/Technical Business Analyst

Responsibilities:

• Subject Matter Expert contributing to the analysis and design sessions with business analysts to identify the requirement, design and specifications for the re-platforming of Digital Phone Project from Oracle to Netezza.
• Prepared ETL design specification documents with information on implementation of business logic.
• Created SQL’s to get usage data into the Netezza warehouse and perform reconciliation.
• Created UNIX shell scripts to get history data from Source (Oracle) to Netezza (Target).
• Improved performance of the Netezza SQL through review and query optimization.
• Performed Unit Testing and created Unit Test Case documents
• Automated the jobs using TIDAL Scheduler to handle daily volume.
• Managed the co-ordination and utilization of offshore developers.

Environment: Netezza, Oracle, Toad for Oracle, WinSQL, UNIX, TIDAL, WinSQL, SVN, HP Quality Center.

Confidential, Charlotte, NC

ETL Development Lead/Technical Business Analyst

Responsibilities:

• Subject Matter Expert contributing to the analysis and technical design sessions with business analysts to identify the requirement, design and specifications for the patch.
• Prepared ETL design specification documents with information on implementation of business logic.
• Created Netezza SQL’s to apply the business logics and handle varied scenarios in which the data had been corrupted.
• Created UNIX shell scripts to get data from Source (Oracle) to Netezza (Target).
• Created wrapper scripts in UNIX to run the patch in batches.
• Improved performance of the Netezza SQL through review and query optimization.
• Performed Unit Testing and created Unit Test Case documents.
• Responsible for designing, developing and implementing the automation of the patch, full load and disaster recovery.
• Automated the jobs using TIDAL Scheduler to handle daily volume.
• Managed the co-ordination and utilization of offshore developers.

Environment: Netezza, Oracle, Toad for Oracle, WinSQL, UNIX, TIDAL, WinSQL, SVN, HP Quality Center.

Confidential

ETL Development Lead

Responsibilities:

• Worked closely with various levels of individuals to coordinate and prioritize tasks. Estimate, schedule and track the day to day achievements.
• Responsible for communication with the client and the management the offshore effort.
• Creation of seeded records and loading the seeded records to the tables through specific scripts.
• Develop and optimize the SQL queries based on the requirements.
• Enhancements to the existing UNIX scripts and SQL’s.
• Unit testing of the newly created SQL’s through scripts.
• Creation of UTP’s, Test Results, Run book and Release Manuals for every development/enhancement.
• Migration of the baselined scripts to Win CVS and Support for QA Testing

Environment: Netezza, Oracle, Toad for Oracle, WinSQL, UNIX, TIDAL, WinSQL, SVN, HP Quality Center.

Confidential

ETL Development Lead

Responsibilities:

• Communication with the Client and Management of effort at offshore.
• Creating the various design and flow documents.
• Design and Review of developed UNIX shell scripts.
• Creating DM Express Jobs for loading tables.
• Unit testing and system integration of newly created scripts.

Environment: DM Express, Teradata, UNIX