SUMMARY:

I am seeking a challenging opportunity in the field of data analysis and data warehousing where I can fully utilize my skills in analysis, design and development to implement highly complex projects offering over 10 years of experience in data management.

AREAS OF EXPERTISE:

• Data warehousing concept and techniques.
• Data migration from legacy systems to new systems.
• Extract/Transform/Load (ETL) using INFORMATICA PowerCenter.
• Business Intelligence using SAS WRS, Oracle BI, and SAP BO.
• Data Quality using INFORMATICA Data Profile and IDQ.
• Metadata using INFORMATICA Metadata Manger.
• Database modeling using ERWIN.
• Systems data integration.
• Systems and Business Analysis.
• Data analysis, data reconciliation and control.
• Data governance policies and procedures.

WORK EXPERIENCE:

Confidential

Responsibilities:

• Gather business requirements and identify required reports and analytics.
• Perform system analysis that includes the data model, functionality and integration with other systems.
• Design target data model in EDW (as of date / from date, to date).
• Design required data marts that show the benchmark figures.
• Determine the frequency and loading mode (update/insert, delete/insert) according to the nature of the data (transactional, demographic, lookups).
• Determine the selection criteria from source that identify the delta (changed records).
• Develop detailed ETL technical specifications.
• Thoroughly test ETL flows and perform the user acceptance testing (UAT).
• Review raw data received in various formats from various sources and standardize its processing
• Support operation and expansion of data warehouse and reporting environment.
• Monitor performance and reliability of loading processes.
• Debug and trace of reports defects, production incidents as well as performance issues, diagnosing the root causes and recommending corrective actions.
• Maintain and implement the data governance policies agreed upon by the bank.
• Develop and implement data auditing strategies and processes to ensure data accuracy and integrity.
• Identify data quality issues and their causes through profiling reviews and root cause analysis
• Collaborate with key users and operational groups to identify business needs, data usage requirements, and validation metrics.
• Develop and maintain efficient reconciliation and validation processes to ensure accurate information is delivered to users.
• Identify opportunities in processes, system capabilities and deliver methodologies for continuous improvement as applicable

Data Steward / Data Warehouse Specialist

Confidential

Responsibilities:

• Extracts, manipulates, analyzes, and reports data to stakeholders; prepares and maintains data files; verifies data to ensure data integrity; determines data to be collected and data to be used; establishes data collection quality standards and ensures they are met.
• Develops and implements processes for linking and analyzing data from a variety of sources; applies statistical techniques to analyze trends.
• Acquires, manipulates, archives, and maintains historical data sets, verifying accuracy and consistency over time; determines data lifecycle to understand what and when data should become obsolete.
• Designs, develops and prepares standardized operational, management, and ad hoc reports; works with user base to understand reporting and analysis needs and consistently meets delivery deadlines.
• Establishes, implements and enforces correct data collection policies and procedures; documents procedures for data management processes; develops methodologies for data collection and evaluation relevant to each project; performs analysis to determine adequacy of data collection and evaluation processes; ensures data management system is compliant with all relevant laws and regulations; evaluates data management system to improve operational procedures.

Confidential

Systems Integration Specialist

Responsibilities:

• Participate in end to end solutions of multiple concurrent projects on EDW.
• Work with key stakeholders on defining the requirements to support new opportunities.
• Investigate, Analyze and understand data contents of source data systems.
• Define data quality requirements including business rules/controls, metrics and targets.
• Design target data model in EDW as well as the data marts
• Develop detailed ETL technical specifications and develop ETL programs.
• Thoroughly test ETL flows and perform the user acceptance testing (UAT).
• Design and develop exception handling, data cleansing and standardization procedures.
• Provide post - implementation support by performing problem analysis and resolution as needed.
• Create and maintain metadata for the data warehouse, including which data is trendable, which data is related, and which fields are in common among a disparate set of data.
• Define data sets needed for specific use cases and identifying data gaps

Confidential

Systems Integration Specialist

Responsibilities:

• Design and implement end to end solution of Enterprise Resource Planning (ERP) systems.
• Develop Oracle PL/SQL stored procedures and functions within packages, triggers and libraries, Views, Shell Scripting, Data Modeling, Oracle forms and reports.
• Perform technical root-cause analysis and troubleshooting long-running reports, performance bottlenecks, data inaccuracies, in-efficient workflows and data inconsistencies in applications and reports.
• Performs impact analysis of proposed ERP software customizations, which includes reading through the software code to determine the feasibility of the customization and determining the impact of upgrades on these proposed customizations.
• Performs application level performance tuning and debugging to optimize efficiency, which may include making recommendations to improve database performance.
• Assists with the integration of ERP software with other information systems; implements routine upgrades and customizations of the ERP software package.
• Actively participate in testing to validate if the implemented features meet requirements.

Confidential

Software Engineer

• Design and implement many web applications projects using PHP and MySQL.