Narayan Reddy G Email & Phone Number

Greater Chicago Area

• Reviewed requirements together with QA Manager, ETL leads to enhancing the data warehouse for the originations systems and servicing systems.• Performed GAP analysis of business rules, business and system process flows, requirements and developed Requirement Traceability Matrix to ensure current project requirements are met and their timely update.• Overseen data quality management activities including data profiling, data validation, and assessing data relevancy to further improve information reliability.• Enhanced some of the existing excel based charts to much more interactive Tableau based charts. Built project specific dashboards in the Tableau.• Performed data merging, reconciliation and validation to produce more reliable metrics data for analysis. Used python scripting via ‘pandas’ and ‘numpy’ libraries for cleaning, reconciling, transforming and modeling data to ensure and improve accuracy of metrics calculations.• Performed EDA in python using ‘matplotlib’ and ‘seaborn’ for huge datasets.• Created visualizations and dashboards from excel graphs to HTML front end for outlook mail generation and distribution.• Generated and analyzed weekly software metrics, charts, and reports to support decision-making.• Created fully fledged Source to Target Mapping documents (S2T), documented businessand transformation rules.

Hyderabad Area, India

• Worked with identified business users to define data requirements.• Defined corporate metadata definitions for all Enterprise Data supported databases (operational source systems, data stores and data marts).• Performed Data Analysis, Data Profiling & Validity, Data cleansing rules etc.• Developed mapping spreadsheets that will provide the Data Warehouse Development (ETL) team with source to target data mapping.• Took a leadership role when working with the Data Warehouse Development (ETL) team to research and define existing source to target mapping for the corporate Data Warehouse.• Developed logical and physical data models that document source data from multiple sources (Client's internal data systems, external source data systems, 3rd Party Data, Prospect Lists, etc.).• Defined and developed designs to support departmental and functional data marts. Provided input to data modeling and physical database development standards with the Data Modeling Team. Assisted in the review of database structures of proposed business application purchases.

Hyderbad

Bachelor'S Degree, Electrical And Electronics Engineering

Master'S Degree, Management Information Systems, General