Nardip Singh
Oracle HCM
- Role
- Data Analyst at 飞利浦
- Location
- Fresno, CA, US
- LinkedIn followers
- 500 followers
About Nardip Singh
Proficient knowledge in Statistics, Mathematics, and Analytics.
Experience
Data Analyst
Jul 2020 — Present · Cleveland, OH, US
Involved in data gathering and data analysis framework involving data cleaning, processing, analysis, and visualization.· Analyzed ETL jobs to pull data from the source system to staging and then a warehouse.· Responsible for developing specifications for user interfaces and workflows and resolving any conflicts with requirements between business and technology.· Conducted JAD sessions helping System Analysts to develop detailed solutions and verify the app development process follows quality standards laid out.· Created UAT plans with several test cases for each production release to ensure that system runs smoothly after the proposed enhancements or changes have been made.· Documented Source to Target Mapping documents with data transformation logic.· Designated Snowflake schemas with a very good understanding of FACT and dimensional tables for Data Warehouse, ODS architecture by using Erwin.· Performed reverse engineering using Erwin to redefine entities, attributes, and relationships existing database.· Developed SQL scripts to validate the data loaded into Data warehouse and Data Mart tables using ETL Informatica.· Enforced referential integrity in the OLTP data model for the consistent relationship between tables and efficient database design.· Used Data Stage Manager for importing metadata from the repository, new job categories and creating new data elements.· Built OLAP cubes using SSAS to fetch data mart to automate regulatory reporting.· Created OLAP cubes, identifying required Dimensions, FACTS, Attributes, Hierarchies, and calculating Measures for reporting using Erwin.· Resolve user queries on the data present in Data Warehouse and AWS Cloud and help the users in providing the definitions and data usage.· Used matchups, fuzzy lookups, and different transform in SSIS to match and load data from Flat files to the SQL databases.
Education
Panjab University,Chandigarh
Master's degree
Johnson & Wales University
Master of Science - MS
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.