SUMMARY:

• Ms. Ghadi has spent her career developing innovative information management solutions with a focus on delivering business value to her clients.
• She has more than six (6) years of experience in IT industry.
• Currently, she is an ETL Developer utilizing Informatica PowerCenter.
• She also has been trained within the areas of Data Warehouse, Agile development, ETL, and Data Analysis.
• She is also a SQL developer and has experience developing within Teradata, MS SQL Server, and Oracle databases. Experience in creating SQL queries for back - end testing and validation.
• Experience developing Test Strategies, writing Test Cases and developing Test Scenarios along with test cases, Documenting Test Procedure according to the Business Requirements.
• Knowledge and experience in Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) processes.
• She has strong analytical and problem solving skills and has good communication and team collaboration skills.
• Flexible and versatile in adapting to new environments and working on any tasks/projects assigned.
• Currently hold US Citizenship and doesn't require work visa sponsorship.

TECHNICAL SKILLS:

Operating Systems: Windows XP & 2000/NT, UNIX

Languages: SQL, C

ETL Tools: Informatica 10.0, Microsoft SSIS

Databases: Teradata 14.0, Oracle 10g, MS SQL Server, MySQL, DB2 UDB 7.1, MS Access

Testing Tools: HP Quality Center 11.0, Application Lifecycle Management (ALM) 11.0, Microsoft Team Foundation Server (TFS)

Web Technologies: HTML, DHTML, XHTML, CSS, JavaScript, VB-Script, XML, ASP, Macromedia Cold Fusion, Macromedia Dream Weaver, Microsoft FrontPage

Certifications: Informatica Power Center Data Integration 9.x Developer Specialist (April 2016)

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Developer

• Setup multiple JAD sessions with NetJets SMEs to understand existing processes and to document Source to Target Mappings (STTM) for new Informatica jobs.
• Based on requirements, developed technical specification document for each MQ with detailed design and process flow. Document also included details like predecessor/successor jobs and source/target layouts.
• With the help design and technical requirements, developed Informatica mappings and workflows.
• Oracle's GoldenGate ECR (Enterprise Change Repository) was used as source to pull flight related data and transformed into XML and JSON messages. This was accomplished by using Informatica's XML generator and Java transformations. Later these messages were posted to Message Queues (MQ) for further processing.
• Developed reusable user defined function in Informatica to convert date/time to Zulu time format.
• Prepared test cases and performed unit testing to ensure jobs were developed to meet technical specifications and business requirements.
• Involved in QA and integration support.

Environment: Informatica 10.0, Oracle 10g, Oracle SQL Developer, UNIX, WinSCP, IBM Message Queue, XML, JSON, Hermes

Confidential

Informatica Developer

• Actively involved in gathering business requirements and understanding source system data.
• Worked with business analyst to convert requirements into source to target mappings. Analyzed source data to understand relationship between tables and document correct transformation/ standardization rules.
• Built Informatica jobs based on technical specifications documented by Technical Lead. Informatica mappings were developed using transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Normalizer, Filter, Update Strategy and Joiner transformations.
• Implemented slowly changing dimensions (SCD) - type I & type II in various mappings as per the technical requirements. Worked with different kinds of source databases involving SQL Server and flat files as UPD (User Provided Data).
• SQL Queries were built to validate data in both source and target databases for reconciliation process.
• Prepared test cases and performed unit testing to ensure jobs were developed to meet technical specifications and business requirements. All test results were documented in excel and uploaded on Share Point site for future reference.
• Job performance issues were resolved by understanding bottleneck and adding database indexes or Informatica partitions as appropriate.
• Involved in QA and integration testing. Also, provided UAT support by troubleshooting and fixing defects.

Environment: Informatica 9.6, SQL Server 2008, Windows.

Confidential

Informatica Developer

• Profiled source system data (Teradata) to understand data quality, table structures, content and their relationships.
• Team up with business users to create source to target mapping document along with the business/ transformation rules.
• Developed ETL design and created technical specifications document for each target table.
• Complex SQLs were developed using Teradata SQL Assistant and used inside Informatica's source qualifier to improve overall job performance.
• Provided support to QA team in job executions and their depedencies.
• Involved in integration testing, production implementation and post implementation support.

Environment: Informatica 9.6, Teradata 14.0, UNIX, WinSCP.

Confidential

QA Analyst

• Reviewed/analyzed Business requirements for correctness, completeness, testability & consistency.
• Involved in Scrum/Standup meetings, story card walk-through and sprint planning for agile methodology.
• Developed test cases by referring to functional requirement document and source to target mapping spreadsheet.
• Executed test cases and documented results in Quality Center
• Defects found were documented and tracked in Quality Center.
• Both Initial and Incremental loads were tested using ETL jobs and SQL scripts.
• Conducted Integration, System, Regression testing.
• Generated Traceability matrix to ensure coverage.
• Updated Regression Test suite after every Iteration.
• Validated UAT data before passing it to the business for their UAT.

Environment: HP Quality Center 11.0, Windows 7, Oracle 10g, TOAD, UNIX, Informatica 9.1

Confidential

QA Analyst

• Analyzed Business requirements for correctness, completeness, testability & consistency.
• Involved in Scrum/Standup meetings, story card walk-through and sprint planning for agile methodology.
• Participated in Test planning and designing Test scenarios and Test cases.
• Created test cases for various testing stages like compatibility testing, content testing, links testing, session testing, cookie testing, security testing, usability testing, functionality testing, interface testing and performance testing.
• Defects found were documented and tracked in Quality Center.
• Generated Traceability matrix to ensure coverage.
• Update Regression Test suite after every Iteration.
• Coordinate User Acceptance Testing.

Environment: HP Quality Center 9.2, Windows 7, Informatica 9, ASP.Net, SQL Server 2008, MS Office.

Confidential

QA Analyst

• Reviewed/analyzed Business requirements for correctness, completeness, testability & consistency.
• Developed test cases by referring to functional requirement document and source to target mapping spreadsheet.
• Executed test cases and documented results in Excel.
• Defects found were documented and tracked in Quality Center.
• Both Initial and Incremental loads were tested using ETL jobs and SQL scripts.
• Conducted Integration, System, Regression testing.
• Generated Traceability matrix to ensure coverage.
• Updated Regression Test suite after every Iteration.
• Validated UAT data before passing it to the business for their UAT.

Environment: HP Quality Center 9.2, Windows 7, Oracle 10g, TOAD, UNIX, Informatica 9.1

Confidential

ETL Architect / Developer

• A dimensional model (star schema) was created for Adventure Works Datamart based on few business questions. A designed Datamart consist of Customer, Product, Location and Calendar as dimensions and a fact table for sales transactions.
• DDL’s (Data Definitions Language) were generated and target tables were created with primary and foreign key relationship in SQL Server Database.
• Analyzed 12 tables from source system (OLTP) and created source to target mapping document along with the business rules.
• Designed and created ETL technical specifications document.
• Completed development using Microsoft SQL Server Integration Services (SSIS).
• All the ETL jobs were executed and data was loaded into all target tables.