Deepa Sachdev

Data analysis professional with 9+ years of total IT experience and expertise in data modeling for data warehouse/data mart development, Data Analysis, SQL and developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems. Hands-on experience with MMIS, ACA, HIX, HIPAA, and HL7 processes. Worked closely with EDI 820 Payment Order/Remittance Advice and EDI 834 Benefit Enrollment and Maintenance. Implement client EDI 834, 835, 837 Standard and Data mapping EDI files. Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer. Excellent knowledge of complete data warehouse life cycle, testing methodologies, OLAP and OLTP. Well versed in Normalization and DeNormalization techniques for optimum performance in relational and dimensional database environments and have performed normalization up to 3NF. Worked on one complete ERP implementation project. Hands on experience in using MapReduce programming model for Batch processing of data stored in HDFS. Experience in Converting multiple reports from Excel, Tableau and BO to Spotfire. Experienced in finding trends from the data using predictive modelling techniques such as Linear Regression, K-Means clustering, PCA, Decision Trees, Random Forests, KNN and Logistic Regression. Implemented Machine-Learning to predict the future trends with p-value and this feature had huge impact on the finding the result in this project. Made predictions based on the data patterns and calculated ROC. Data analysis techniques to validate business rules and identify low quality missing data in the existing data. Experienced with most of software deployments methodologies(SDLC) like Water Fall, Iteration, Agile and Rapid Application Development (RAD). Experienced in Business requirements conformation, data analysis, data modeling, logical and physical database design and implementation. Familiarity with Crystal Reports and SSRS - Query, Reporting, Analysis and Enterprise Information Management, MongoDB. Experienced in Normalization and Demoralization processes, Logical and Physical data modeling techniques. Installed and configured Cassandra. In depth knowledge about Cassandra architecture, query, read and write path. Experienced in Integrating high – level business rules (constraints, triggers and indexes) with the code. Proven knowledge in capturing data lineage, table and column data definitions, valid values and others necessary information in the data models. Strong Experience in ER & Dimensional Data Modeling to deliver Normalized & STAR/SNOWFLAKE schemas using Erwin r7.2 Erwin 9.6/8.2/7.0, Power Designer 15, Embarcadero E-R Studio and Microsoft Visio and ER Studio 9.1.x. Experience in Data Scrubbing/Cleansing, Data Quality, Data Mapping, Data Profiling, Data Validation in ETL. Experience in designing star schema, Snowflake schema for Data Warehouse, ODS architecture. Excellent communicative, interpersonal, intuitive, analysis, leadership skills, quick starter with ability to master and apply new concepts.