SUMMARY:

• 5.7 years of total IT experience in the business requirements analysis, application design, dimensional data modelling, designing, development, testing and implementation of business applications with RDBMS,Data Warehouse,ETL and client/server environment applications for financial and retail domains.
• Strong experience in creating the Design Documents for loading data into Data warehouse tables.
• Strong understanding of Data warehouse concepts,ETL,Star Schema,Snowflake,Business Process
• Analysis, Dimensional Data modelling,FACT& dimensions tables, physical & logical data modelling.
• Good programming experience in SQL.
• Experience in working with RDBMS including Oracle 11i/9i.
• Strong expertise on the various data design models like Star Schema and Snowflake models.
• Exceptional analytical and problem solving skills. Team Player with the ability to communicate effectively at all levels of the development process.
• Technological forte are Ab - initio ETL tools, Netezza and Pentaho.
• Handled data extraction from multiple source platforms.
• Performed several data quality checks.
• Extensive experience in end to end testing of Data warehousing ETL routines, which includes creating test cases, data quality testing and value checking.
• Have substantial trouble-shooting experience.
• Worked on the Quality Analysis of the products, responsible for the Defect tracking and Classification.
• Worked on Conduct>It and developed plans.

TECHNICAL SKILLS:

Development Technologies: Ab Initio GDE 1.15/Co>Op 2.15,Ab Initio GDE 3.0.2/Co>Op 3.0.2,Ab Initio GDE 3.1.5/Co>Op 3.1.5 Pentaho (an open source ETL tool) 4.2,Netezza, Conduct>It

Language : Shell Script, SQL, C, C++

Operating Systems : Windows 98/XP/7, Linux, Unix

Databases : Oracle,

Tools : Ab initio, Conduct>It, Pentaho (an open source ETL tool) 4.2,Netezza

PROFESSIONAL EXPERIENCE:

Technical Leader &SME

Confidential, Phoenix, AZ

Responsibilities

• Designed and developed plan and graphs to populate tables used by reporting tool as part of Business.
• Worked in Agile methodology.
• Intelligence module.
• Involved in Design and Development of the Interface module.
• Communicated with Business users and other team in gathering the requirements and developing the module.
• Developed ETL graphs as per the design.
• Created Teradata Queries.
• Performed several data quality checks and found potential issues.
• Involved in Unit and System testing.

Environment: Ab-Initio, UNIX, SQL, TERADATA

Module Leader & SME

Confidential, Chicago, IL

Responsibilities

• Designed and developed plan and graphs to populate tables used by reporting tool as part of Business
• Intelligence module.
• Involved in Design and Development of the Interface module.
• Communicated with Business users and other team in gathering the requirements and developing the module.
• Developed ETL graphs as per the design.
• Created Netezza Queries.
• Performed several data quality checks and found potential issues.
• Worked on Conduct>IT.
• Involved in Unit and System testing.

Environment: Ab-Initio, UNIX, SQL, NETEZZA, Conduct>It.

Senior Software Developer

Confidential

Responsibilities

• Involved in Design and Development of the Interface module.
• Interacted with Business users and other team in gathering the requirements and developing the module.
• Developed ETL graphs as per the design.
• Created Perl Scripts for calling the graphs.
• Performed several data quality checks and found potential issues.
• Involved in Unit, System, Integration and Regression testing.
• Code reviewed for the other developers and made performance improvements.

Environment: Ab-Initio, UNIX, SQL,Conduct>It

Software Developer & SME

Confidential

Responsibilities

• Involved in Design and Development of the Interface module.
• Communicated with Business users and other team in gathering the requirements and developing the module.
• Developed ETL jobs and transformations as per the design.
• Created Unix Shell Scripts for file level validation and other activities.
• Designed Pentaho Reports using Report Designer and Metadata Editor.
• Performed several data quality checks and found potential issues.
• Involved in Unit, System, Integration and Regression testing.
• Code reviewed for the other developers and made performance improvements.

Environment: Pentaho(an open source ETL tool) Developer, UNIX, POSTGRESQL, Windows XP Professional

Developer & QA

Confidential - New York, NY

Responsibilities

• Enhanced AI graphs as per the requirement.
• Performed NYSE QA activities.
• Wrote UNIX Shell Scripts for required activities.
• Worked with various FTS releases.
• Analyzed AI graphs to fulfill the release requirement.
• Designed graphs to generate test files as per QA requirement.
• Wrote several Shell scripts for Project maintenance (to remove old/unused files and move raw logs to the archives)

Environment: Ab-Initio, UNIX, COBOL, SQL.

Software Developer

Confidential

Responsibilities

• Involved in the Functional design of the project.
• To understand the functional requirement and preparing HLD and LLD document.
• Involved in Coding and unit testing.
• Migrating from one relational source to another relational database.
• Worked on System testing for the whole project.

Environment: Ab-initio, UNIX, C++, Windows XP professional