Nardip Singh Email & Phone Number

Cleveland, Ohio, United States

· 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.

Sunnyvale, California, United States

· Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks· Worked on claims data and extracted data from various sources such as flat files, Oracle, and Mainframes.· Worked with data investigation, discovery, and mapping tools to scan every single data record from many sources.· Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.· Written several shell scripts using UNIX Korn shell for file transfers, error logging, data archiving, checking the log files and clean-up process.· Metrics reporting, data mining and trends in helpdesk environment using Access· Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, Toad, MS Access, Excel and SQL· Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.· Involved in extensive DATA validation by writing several complex SQL queries and involved in back-end testing and worked with data quality issues.· Worked with end users to gain an understanding of information and core data concepts behind their business.· Assisted in defining business requirements for the IT team and created BRD and functional specifications documents along with mapping documents to assist the developers in their coding.

Atlanta, Georgia, United States

Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database.· Created a conceptual design based on the interaction with the functional and technical team.· Analyze ed the existing data model and incorporate new additions for the advancement data into the data model identifying the cardinality of the new tables to the existing tables and ensuring proper referential integrity of the system.· Analyzed, created, and formatted the Reports as per Business Requirements.· Analyzed and created various adhoc Reports for users based on User Requirements.· Created both list and drill down reports identifying the data hierarchy.· Performed report validation writing SQL queries using TOAD on an Oracle database.· Created process documents, reporting specs and templates, training material, and slideshow presentations for the application development teams and managements.· Analysis of the data identifying source of data and data mappings of BHC.· Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.· Interact with the SMEs to analyze the data extracts from Legacy Systems (Mainframes and COBOL Files) and determine the element source, format, and its integrity within the system.· Transformation of requirements into data structures which can be used to efficiently store, manipulate, and retrieve information.· Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.· Ensure that models conform to established best practices (including normalization rules) and accommodate change in a cost-effective and timely manner.

Master Of Science - Ms

Master'S Degree, Mathematics