Professional Summary:

• 8 years of professional IT experience in developing data warehouse and business intelligence applications, with the ability to learn and adapt to unfamiliar software environment quickly.
• Extensive experience in ETL development in a netezza environment using Oracle PL/SQL, UNIX, and Datastage.
• 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.
• Thorough knowledge in database architecture, SQL, RDBMS fundamentals, Data Warehouse and Business Intelligence concepts.
• Expertise in designing and implementing software solution for business requirements using oracle PL/SQL packages, procedures, functions and triggers for data warehouse applications.
• Identifying performance bottlenecks in applications 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.
• Seasoned support analyst with proven track record of leading the Fact Sourcing team in delivering/loading the analytical data in Netezza on or before weekend SLA.
• 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 and MS VSS.
• Possess excellent problem solving, troubleshooting, communication and team building skills.
• Undergone training in .Net and C .
• Have worked in onshore offshore software delivery model. Have played the role of an onsite coordinator.

Netezza Highlights:

• Extensive knowledge in Netezza data warehouse appliance architecture, AMPP concepts and the way Netezza differs from other RDBMS.
• Accomplished quantifiable performance in long running queries in Netezza by engaging methodical approach using NPS and Netezza Query Plan.
• Developed Netteza 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.
• Skillful in developing business intelligence and analytics application in Netezza Mustang and Twinfin using nzload and nzsql integrated in LINUX shell scripts.

Technical Skills:

• Operating Systems : Windows 2000/XP/Vista/7, UNIX, Linux
• Languages : SQL, PL/SQL, Pro C
• Scripting Languages : Linux and Unix Shell Scripting korn, bash, C , Python, awk, Pro C
• Database : ORACLE 9i and 10g, Netezza
• Tools : SQL Plus, SQL Developer, PL/SQL Developer, TOAD Developer,
• Mercury Quality Centre, Aginity Netezza Workbench, Putty, DbVisualizer
• Configuration Management Tools: Tortoise Subversion, Microsoft Visual Source Safe
• ETL Tools : Ab-Initio, Datastage
• Job Scheduling Tools : Autosys, Cron-job, Tibco Ops Console

Accomplishments:

• 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

Lead Developer

Responsibilities:

• Enhanced and altered the store, segment and loyalty dimension jobs to support more than one client.
• Orchestrated the Dimension Sourcing jobs in entirety for all dimensions using Tibco Ops console.
• Successfully implemented Dimension Sourcing for a new retail client.
• Involved in brainstorming sessions with architects during the design phase of the project.
• Working on Data Cubes, a new concept which facilitates loading the input file from clients directly into Dimension tables rather than the conventional way of loading through ODS.
• Tracked, resolved and documented QC defects and their resolution.
• Developed complex analytical queries in Oracle and Netezza SQL and performance tuned as necessary.
• Used Netezza nzsql and nzload in day to day activities. Monitor Netezza data distribution across SPUs/ S-Blades
• Documented best practices to help support team understand and execute the jobs.

Environment: UNIX Solaris, Netezza Twinfin, Oracle 11g, Datastage, Composite, Ascent, Java, Adobe Flex, Subversion

Confidential

Support Analyst

Responsibilities:

• Led the fact sourcing support team for AOD. Loaded data from multiple sources including oracle into Netezza.
• Developed complex analytical queries in Oracle and Netezza SQL and performance tuned as necessary.
• Used Netezza nzsql and nzload in day to day activities. Monitor Netezza data distribution across SPUs/ S-Blades
• Led the team responsible for loading all fact tables for all of AOD's clients. Required to meet weekend SLAs to deliver data.
• Supported the Answers On Demand AOD application by fixing any issues that may arise during data load. Ensured data quality by verifying work by team intermittently.
• 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 adhoc tasks.
• Documented best practices to help support team load data on time with minimal data quality issues.
• Clarified questions from clients on fact sourcing data.
• Worked with the frontend application team to help resolve issues involving Cognos, Composite, Oracle and Netezza.
• Acted as a single point of contact for all fact sourcing related questions and Netezza performance tuning.
• As the Subject Matter Expert in Fact Sourcing, groomed the offshore resources on it by conducting tele conf trainings.
• 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, Composite, Cognos, Java, Javascripts, Adobe Flex, Subversion

Confidential

Lead Developer

Responsibilities:

• Led the fact sourcing development team for AOD. 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 based high complex components.
• As a Lead Developer 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 at offshore for all client questions on status, progress and subject matter.

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

Confidential

Developer

Responsibilities:

• Created Low Level Design and developed oracle PL/SQL packages and procedures according to the provided High Level Design document.
• Discuss technical difficulties with the client Data Architect in implementing the solutions.
• 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
• Worked with the test team to get the deliverable pass all quality processes and test criteria
• Reported the status of the project to Sr. Project Manager on a timely basis.
• Responsible for tuning long running queries in both Netezza and oracle.

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

Confidential

Software Developer

Responsibilities:

• Created Low level design document in accordance with the High level design.
• Developed Oracle PL/SQL packages, procedures, functions and triggers as part of daily development activities.
• Developed complex analytical queries in Oracle SQL and performance tuned as necessary.
• Created Oracle tables, views, materialized views, synonyms, indexes and partitions.
• Presented status in weekly project status meeting with clients.
• Worked on a tight timeline to finish the project.
• Conducted training sessions on Oracle SQL and PL/SQL

Environment: Redhat Linux, Oracle 10g, Oracle PL/SQL, Informatica, Pro C, Mercury Quality Center, Java, Autosys

Confidential

Developer

Responsibilities:

• Developed Oracle PL/SQL packages, procedures, functions and triggers as part of daily development activities.
• Developed complex analytical queries in Oracle SQL and performance tuned as necessary.
• Created Oracle tables, views, materialized views, synonyms, indexes and partitions.
• Coded in Ab-Initio to extract, transform and load data into data warehouse tables.
• Part of weekly teleconf with clients briefing the status of project components under development.
• Worked on a tight timeline to finish the project.

Environment: UNIX, Oracle 10g, Oracle SQL, PL/SQL, Ab-Initio, Autosys