PROFESSIONAL SUMMARY:

• 14+ years of overall IT experience in software development, testing, implementation and production support
• 9+ years of experience focusing on Data warehousing, Data modeling, Data integration, Data migration, ETL process and Business Intelligence
• Experience working with Agile, Kanban and Waterfall methodologies Domain experience in building Mortgage, Finance and Securities Trading systems
• Extensive experience delivering Data warehousing implementations, Data migration and ETL processes to integrate data across multiple sources using Informatica PowerCenter, Informatica Cloud Services and Informatica Cloud Real Time
• Experience working with APIs written based on REST/JSON technologies Efficacy with relational databases like Oracle, SQL Server,GreenPlum, Netezza and Hadoop Extensive experience working on Informatica Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Normalizer, Update Strategy, Aggregator, Sorter, Sequence Generator, Intelligent Structure Designer, and Structure Parser
• Experience working with Slowly Changing Dimensions
• Excellent Data Processing skills including designing and implementing Data Mart applications Expertise in Data Warehousing Concepts such as Star Schema, Snow Flake Schema, Fact Table and Dimension Table
• Expertise in designing and developing Workflows, Sessions and tasks using Informatica Workflow manager tools, Task Developer, Workflow and Worklet Designer to handle different load scenarios
• Understanding of Informatica Master Data Management(MDM), Informatica Data Quality(IDQ), Informatica PowerExchange Developed Unix scripts for Backend testing and executed system processes for business validation, perform data consistency check
• Excellent debugging, problem solving skills with ability to acclimatize to new teams, assimilate new technologies
• Proactively communicate status and issues/risks with project stakeholders that include Business stakeholders, IT Leads and VP's Proficient in using various delivery tools including Rational ClearQuest, ClearCase, DOORS, ALM for Test Reporting and Defect/Change management
• As core member of CoE (Center of Excellence), involved in various process improvements for building datamart
• Manage intake of project pipeline, work with program leads to provide level of effort and develop resource plans
• Experience in conducting interviews with cross functional teams and document requirements using IV&V (Independent Verification and Validation) methodology

SKILL:

Databases: Oracle, MS SQL Server, Hadoop, GreenPlum, Netezza, Sybase

ETL: Informatica Cloud Services, Informatica Cloud Real Time, Informatica PowerCenter, SAP Data Services (BODS)

Requirements Tools: DOORS, Rational RequisitePro, StarTeam

App/Web Servers: WebLogic, WebSphere, Tomcat, Apache, IIS Server

Packages/Tools: MS Office, SharePoint, Autosys, Exceed, Putty, Toad, SQL Developer

Reporting Tools: OBIEE, Tableau, QlikSense

Change Management Tools: Rational ClearQuest, ClearCase, Remedy, Merant Tracker

Operating Systems: Windows, UNIX, Linux

Languages: SQL, PL/SQL, T - SQL, TSL, SAS, JavaScript, Java, XML, Apple MDT

EXPERIENCE:

Confidential, Dulles, VA

Informatica Cloud - IPaaS Developer

Responsibilities:

• Created several workflows for the emerging applications
• Maintained and monitored the jobs on a daily basis
• Helped IT reduce the cost of maintaining the on - campus Informatica PowerCenter servers by migrated the code to Informatica Cloud Services
• Designed several Processes on Informatica Cloud and exposed them as RESTful API services to publish data to external systems.
• Experience in writing Python and Shell scripts
• Expertise in parsing and handing structured and unstructured data like json,no-sql
• Created several APIs based on JSON technolog
• Created mappings to extract the data from the external APIs
• Migrated reports from OBIEE to QlikSense

Confidential, Alexandria, VA

ETL Developer

Responsibilities:

• Developed ETL programs for Confidential 's Enterprise Data Warehouse using SAP Business Objects Data Services 4.2
• Modified existing data flows for better performance
• Added new fields to the existing Dimension and Fact tables based on the new business needs
• Helped in identifying the fallouts on the Business Objects Reports
• Updated the Source to Target mappings based on the new business rules
• Involved in Unit testing the modified Jobs and Workflows

Confidential, Herndon, VA

ETL Developer

Responsibilities:

• Developed ETL programs for Confidential 's Enterprise Data Warehouse using Informatica PowerCenter 9.5
• Created new ETL Design Specs and standards for new development work
• Responsible for developing, support and maintain the ETL processes using Informatica PowerCenter Integrate sources of mortgage data, real estate attributes, securities created from the repackaging of loans into Confidential 's data warehouse.
• Extracted data from various data sources such as Oracle, SQL Server, Flat files and transformed and loaded into targets using Informatica.
• Created Mappings and used transformations like Source Qualifier, Filter, Update Strategy, Lookup, Expression, Router, Joiner, Normalizer, Aggregator Sequence Generator and Address validator.
• Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.
• Created Source and Target definitions, reusable transformations, mapplets and worklets.
• Developed Autosys jobs to schedule batch processes.
• Used Informatica debugger to analyze the mappings and used session log files, bad files to trace errors.
• Implemented Error Handling, Performance tuning and validation rules.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.

Confidential, Rockville, MD

ETL Developer

Responsibilities:

• Participated in JAD sessions with business users and SME's for better understanding of the reporting requirements.
• Analyzed the Technical Specification Document for all mappings and clarified the issues with Data Architects
• Designed the ETL processes using Informatica tool to load data from Oracle, GreenPlum, Netezza, Hadoop, Excel and flat files into the target Oracle database.
• Created source and Target Definitions, Reusable transformations, mapplets and worklets.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Lookup, Filter, Router, Sequence Generator, Sorter, Joiner, and Update Strategy.
• Used Workflow manager for Workflow and Session Management, database connection management and scheduling of jobs to be run in the batch process. Implemented slowly changing dimensions Type 2 using ETL Informatica tool.
• Developed Informatica mappings and tuning them when necessary.
• Optimized Query Performance, Session Performance.
• Unit tested the developed mappings and compared the Test Results and prepared Unit Test Reports.

Confidential, Herndon, VA

Systems Analyst

Responsibilities:

• Conducted IV&V with Business and Functional teams to gather requirements for several applications
• Created the Business and System Requirements
• Documents Created Solution Specification
• Documents that helped the developers and testers
• Worked in Agile environment with 3 week sprints Worked with Agile team to create/execute
• Regression suite Manage Defects and track them to closure using the HP Quality Center
• Support business teams with system validation during implementation
• Participate in daily scrum meetings and sprint retrospective Provide testing updates, issue/risks at standup project meetings

Confidential, Herndon, VA

Sr. ETL Tester

Responsibilities:

• Involved in full SDLC/STLC, Designing software architecture, detailed design, data design, coding, testing and creation of functional and technical documentation. Worked closely with all team members (developers, test manager, business analysts, end users)
• Developed ETL and Reporting Test Plan and Test Strategies.
• Prepared Test environment and Identified/Prepared Test data before starting testing.
• Developed several Test Cases & Test scenarios for ETL Data Validation, Report testing.
• Worked as ETL Tester responsible for the requirements/ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Performed Data Analysis to understand requirements and business flow.
• Extensively used SQL queries for Database testing and Validation.
• Experienced in writing complex SQL queries for extracting data from multiple tables and implementing business rules.
• Reported bugs to the developer and maintained in Quality center.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using HP Quality Center.
• Developed regression test scripts for the application.
• Tested the data and data integrity among various sources and targets.
• Tested the Reports and validated the data on the Reports.
• Tested report functionalities/Non - functionalities.
• Written several complex SQL queries for validating Reports.

Confidential, Rockville, MD

ETL Test Lead

Responsibilities:

• Led several merger related projects for Confidential 's UAT Groups related to their market regulation, member regulation, enforcement and arbitration operations
• Led testing and implementation efforts for the WIAT (Web Integrated Audit Trail), ADS (Advanced Detection System), ADT (Analyst Desk Top) and PROCTOR (PROfessional Certification Testing Organization) applications
• Responsible for requirements analysis, approval and review with project teams including development, business leads, test teams and senior management
• Created Data Flow Diagrams for several Data Marts from source to target
• Designed Test scripts to test the Extract Transform and Load process for those Data Marts
• Defining procedures for software quality control
• Extensively used SQL queries for Database testing and Validation
• Experienced in writing complex SQL queries for extracting data from multiple tables to validate the business requirements.
• Reported bugs to the developer and maintained in Quality center
• Led project efforts for preparation/approval of test plans, test scripts testing matrices and all project documentation
• Reviewed project requirements to ensure completeness and testability
• Reported Project status to senior management
• Estimated work efforts for new projects coming through pipeline
• Reduced testing inefficiencies and redundancy through multi group test coordination which also shortened test periods for projects
• Managed project scheduling, environment readiness and issue escalation

Confidential, Germantown, MD

Business Analyst

Responsibilities:

• Work with the Users to discuss the definition of attributes and entities is the scope of the project
• Work with the technology team to create functional requirements Involve in the entire testing lifecycle, including design, development and execution of the test plans, test strategies and test cases
• Participate in the Peer reviews providing feedback on the code, test plans, and test cases
• Perform Test Readiness including various stakeholders to ensure the Test environments are ready and appropriate support is available from various groups
• Create test cases for back end testing using Unix shell scripting Verify defects in Rational ClearQuest are all closed and verified before the prod implementation
• Perform User Acceptance Testing (UAT) Planning and delegate tasks to team members and check status regularly to ensure that tasks/deliverables are completed in time
• Attend project meetings to discuss release plans, provide updates and test summary reports