Professional Summary:

• 8 years of professional IT experience with specialization in Data Warehouse and Business Intelligence.
• Extensive experience in development and maintenance of Data Warehouse and Business Intelligence applications involving terabytes of data using Oracle SQL, PL/SQL 9i, 10g and 11g high available, distributed RAC system , Netezza Mustang and Twinfin and UNIX Solaris/LINUX as solution environments. Also have expertise in UI development using Oracle Forms6i and Reports6i.
• Hands on experience in ETL and ELT processes and in applying Data Warehouse concepts star and snowflake data model schemas, dimensions and facts
• Have experience in all the phases of Software Development Life cycle SDLC : Analysis, Requirements, Design, Coding, Testing and Maintenance/Production Support primarily in waterfall and agile development processes.
• Possess excellent problem solving, troubleshooting, communication and team building skills with the ability to learn and adapt to unfamiliar software environment quickly.
• Expertise in designing and implementing data warehouse solution for business requirements using oracle PL/SQL packages, procedures, functions and triggers for both OLAP and OLTP systems.
• Identifying performance bottlenecks using Explain Plan and tune long running queries in Oracle by creating indexes, using hints and other techniques depending on the application and query being tuned.
• Well experienced in UNIX and LINUX shell scripting. Contributed in building the standard framework, common for all data warehouse applications.
• Skillful in developing business intelligence and analytics applications in Netezza Mustang and Twinfin using nzload and nzsql integrated in LINUX shell scripts.
• Accomplished quantifiable performance in long running queries in Netezza by engaging methodical approach using NPS and Netezza Query Plan.
• Developed Netezza Performance Tool in MS excel that connects to Netezza and provides the statistics on Netezza performance and the long running queries based on user provided parameters like application and run date.
• Extensive knowledge in Netezza data warehouse appliance architecture, Asymmetric Massive Parallel Processing AMPP concepts and the way Netezza differs from other RDBMS.
• In depth knowledge in Quality Assurance. Performed unit testing, regression testing, integration testing and User Acceptance. Assisted Quality Assurance team with software quality testing.
• Implemented best practices in the project by introducing predefined documentation of standard test cases for critical applications and common test case templates for all applications.
• Expert in automating jobs using autosys and cronjob.
• Thorough understanding and knowledge of Software Configuration Management through use of version control tools like Subversion, Clearcase and MS VSS.
• Have worked in onshore offshore software delivery model. Have played the role of an onsite coordinator equally comfortable in a tech lead role.

Technical Skills:

• Operating Systems : Windows 2000/XP/Vista/7, UNIX, Linux
• Languages : Oracle SQL, PL/SQL, Netezza SQL nzsql
• Scripting Languages : Linux and Unix Shell Scripting korn, bash, C
• Database : ORACLE 9i, 10g, 11g and Netezza Mustang and Twinfin
• Tools :SQL Plus, SQL Developer, PL/SQL Developer, TOAD Developer, Mercury
• Quality Centre, BMC Remedy, Aginity Netezza Workbench, Putty, DbVisualizer
• Configuration Management Tools: Tortoise Subversion, Clearcase and Microsoft Visual Source Safe
• ETL Tools : IBM InfoSphere DataStage
• Job Scheduling Tools : ControlM, Autosys and Cron-job
• File Transfer utilities : ftp, sftp, scp

Accomplishments:

• Received Star of the Quarter award from The Nielsen Company TNC for Q3 2011.
• Received TCS's highest performance rating in three consecutive years 2009 - 2011
• Received client appreciation from TNC for developing the Netezza Performance Tool - Jan 2010

Professional Experience:

Confidential

Software Engineer

Responsibilities:

• Involved in defining the scope of the New Billing System project by analyzing the existing system and providing insights to management on the enhancements required.
• Gathered requirements and created a prototype of the new GUI the users from the accounting department envisioned. The new GUI will be developed as part of phase 2, though .
• Involved in the development of a framework for the new billing system. The framework has utilities to generalize the code in UNIX by parsing parameters from XML, running the shell scripts, creating debug files and providing rerun capabilities to the code. It also has common utilities for oracle code loading table, finding first and last business days of the month and rate calculator etc
• Documented business rules and processing rules for some of the fees from fee schedule by meeting with business users and accounting department.
• In order to streamline input data for IBS, developed new outbound interfaces on the membership system database for loading in Data Warehouse system and then into billing system. Developed inbound interfaces for the same.
• Created Requirements Specification, Design Plan, Test Plan and Implementation Plan for the components assigned.
• Developed Oracle PL/SQL packages, procedures and functions in accordance with the internal software standards.
• Developed UNIX shell scripts and XML files with parameters.
• Performed unit testing, integration testing and regression testing in Assurance environment.
• Performance tuned long running Oracle SQL queries and achieved quantifiable performance improvement in run/load time of trade and order tables.
• Created ControlM drafts for job scheduling.
• Participated in monthly billing statement generation support.

Environment: Oracle 11g SQL, PL/SQL, UNIX, ControlM, JAVA, Pentaho reports

Confidential

Software Engineer

Responsibilities:

• Involved in brain storming sessions during a project's kick off phase to discuss the possible solutions to a given business requirement in data warehouse.
• Worked with the database architects closely to discuss the application dependencies before finalizing the solution.
• Created Project Charters with the key features and benefits of the project for the management to review and approve the project.
• Created Requirements Specification, Design Plan, Test Plan and Implementation Plan for Real Time Replication and Data Warehouse development/enhancement projects.
• Developed Oracle PL/SQL packages, procedures and functions in accordance with the internal software standards.
• Developed UNIX shell scripts to call the Oracle PL/SQL packages.
• Exposure to working with huge volume of data in Oracle RAC environment.
• Performed unit testing, integration testing and regression testing in Assurance environment.
• Performance tuned long running Oracle SQL queries and achieved quantifiable performance improvement in run/load time of trade history and order tables.
• Created ControlM drafts for job scheduling.
• Participated in rotational on call production support for data warehouse applications.

Environment: Oracle 11g SQL, PL/SQL, UNIX, ControlM, JAVA, Pentaho reports

Confidential

Lead Developer

Responsibilities:

• Tech Lead for the dimension sourcing development team for AOD loyalty card dimension for one of Nielsen's new clients. Loaded data from multiple sources including oracle into Netezza.
• Created High Level designs, Low Level designs and Test cases for client requirements. Divide the coding tasks among the team and also coded high complex components.
• As a Tech Lead of the project, participated in client meetings involving Sr. Project Manager, Data Architect and Business Analyst.
• Developed Oracle PL/SQL packages, procedures, functions and triggers as part of daily development activities.
• Developed complex analytical queries in Oracle and Netezza SQL and performance tuned as necessary.
• Created Oracle tables, views, materialized views, synonyms, indexes and partitions.
• Used Netezza nzsql and nzload in day to day activities. Monitor Netezza data distribution across SPUs/ S-Blades.
• Single Point of Contact for the client regarding questions on status, progress and subject matter.

Environment: UNIX Solaris, Netezza Twinfin, Oracle 10g, Composite, Cognos, Java, Adobe Flex, Subversion

Confidential

Developer

Responsibilities:

• Developed complex analytical queries in Oracle and Netezza SQL and performance tuned as necessary.
• Created UNIX shell scripts, nzsql, nzload scripts and autosys jobs to automate the loads for preprocessing the data, feed the data for modeling, post processing the modeled data and data verification.
• Generalized the code to be able to handle multiple clients.
• Used Netezza nzsql and nzload in day to day activities. Monitor Netezza data distribution across SPUs/ S-Blades
• Performed minor enhancements and bug fixes in Oracle PL/SQL packages and procedures.
• Performance tuned long running queries in Oracle SQL as required.
• Created UNIX shell scripts to perform ad-hoc tasks.
• Documented best practices to help support team load data on time with minimal data quality issues.
• Clarified questions from clients on application data.
• Worked with the frontend application team to help resolve issues involving AlphaBlox, Oracle and Netezza.
• As the Subject Matter Expert in business drivers application, groomed the new team members on it by conducting training sessions.
• Used nzsql and nzload to perform Netezza.
• Used Oracle PL/SQL to support the application that extracts and load data into staging database which is a source for Netezza load.

Environment: UNIX Solaris, Netezza Twinfin, Oracle 10g, AlphaBlox, Adobe Flex, Subversion