Sabina Sheikh Email & Phone Number

Greater Philadelphia Area

Greater Philadelphia Area

• Developed ETL for Mortgage Data Warehouse (MDW) that combined data from COF’s Loan Origination application and Salesforce.com, enabling a side-by-side analysis of leads and applicants and determining the conversion rate
• Stream real time feeds for Cogent application enabling decision makers to underwrite loans, examine reject reasons, detect fraud applications and predict backlog for loans in progress
• Profile data for data modelers which eliminated production defects and reduced production support time
• Design the ETL strategy and create reusable components to minimize development effort
• Actively identify poorly performing jobs, and develop process to pre-compute results for faster reporting thereby optimizing IT infrastructure
• Generate ad hoc reports to meet business requirements and convert them into automated jobs to ensure data needs are fulfilled quickly

Greater Philadelphia Area

• As a Change Management Lead, role involved overseeing Management Information System (MIC) used by the Finance & Business Organization for their day to day reporting
• Received requirements from users, created design documents and data flow diagrams, delegated tasks to offshore team, reviewed test cases and implemented the changes successfully in Production
• Performed Data Modelling activities to implement Data Model change requests to enhance functionality of the application
• Implemented pushdown optimization for gaining significant improvement in performance
• Resolved data defects to provide accurate reporting to business
• Apart from development, also supported day to day production loads in the MIC application

Raleigh-Durham, North Carolina Area

• As a Developer in the PRM(Professional Relation Management System) team, actively participated in the modeling sessions to map new data elements and measure the effectiveness of marketing programs
• Also improvised the ETL strategy to reduce data redundancy and bring down storage cost
• Developed mappings to load vendor data and perform computations to check the cost and benefits of marketing campaigns.
• Hands on experience in writing Teradata ETL scripts using BTEQ. Also experienced in writing, testing, and implementation of Stored Procedures and Triggers in Teradata.
• Used pmcmd commands to run the Informatica mappings in the UNIX Scripts.
• Performed production run/support, troubleshooting and debugging code errors.

Mumbai Area, India

Partnered with different Teradata client’s business teams & SME’s to understand existing processes and requirements to migrate applications from operational data mart to new Data warehouse built on TeradataDiGi (Kuala Lumpur) is Malaysia's leading voice and data service provider. We used Informatica to consolidate large amount of customer-related data from.

Mumbai Area, India

Designed and developed an Agent Tracking System (AMS) with some of the built-in features that included evaluating recorded calls for Quality Assurance Team, issue status, resolution time, Daily/Weekly/Monthly issues handled and Average handling time per callThe system also allowed Team Leads to assess the time spent on inbound calls, outbound calls and.