Uploaded File
add photo
Nipa
sarkn@hotmail.com
973-723-3439
Parsippany Troy Hills, NJ 07054
Data Consultant
25 years experience W2
0
Recommendations
Average rating
20
Profile views
Summary

Result Oriented Professional with strong analytical and hands-on technical skills in the data management domain combining with Excellent Communication, Dynamic People Management and Organizational Process Implementation skills. Work closely with Business leadership and IT Executive Management to deliver critical business valued projects on time and on budget. Expertise includes: -AWS Technologies, Redshift, Google Cloud Platform, Big Query, Python, Unix Scripting -Data Integration, Data Migration (ETL/ELT) -Master Data Management (MDM) HUB Architecture & Data Governance -Data Analytics, Business Intelligence (BI) solutions & Building Key Performance Indicator's -Data Modeling, SQL/NoSQL, Data Analysis, Data Profiling and Data Quality -Micro Services Architecture -Onsite Offshore Vendor Interface -SDLC and Agile Methodologies, Team management SIGNIFICANT ACHIEVEMENTS

  • Built smother and faster data pipelines for the Govt. Data from Solicitations and Bidding web sites into Redshift real time. Seamless impact to the frequently changing variety of Govt. Formats, which required web scrapping, scaling, performance tuning and monitoring of the data loads.
  • As member of Data Analytics & Insight team at Wiley, Developed and Implemented Master Data Strategy (MDM & DG).
  • As a hands-on Technical Lead, Designed and Delivered Customer Data Warehouse (CDW) & BI solutions.
  • Prepared Technical Solution or Architecture for data migration on-prem to AWS cloud.
  • Act as Senior Architect and Subject Matter Expert for Data warehouse (DW) and BI Solution designs, including Data Modeling and Data Architecture.
  • Delivered critical customer data to CRM applications like SFDC, SAP & CSR.
  • Implemented data services for digital initiatives with MDM SIF, custom APIs & DQ services.

Experience
Data Consultant - Science4Data
Nov 2020 - present
in Big Query on Google Cloud Platform. * Automate data processing pipelines to reduce the cost and improve the performance. Nipa Saraiya (sarkn@hotmail.com) 2 of 5
No skills were added
Remove Skill
Director of Data Engineering, Data Analytics & Insight
Information Technology
Oct 2019 - Oct 2020
Randolph, NJ
Fulfilling of more government solicitations means bringing in more business, was achieved by speeding up the business processes to complete into hours instead of days, and making clean data available to internal users for decision making, through Development and Execution of Data Strategy, which included:
  • Implementing smoother and faster Data pipelines: Built and dynamically updated the ETL/ELT data pipelines with seamless impact of frequently changing Govt. Data Formats using Python, Unix Scripting & ETL Tool.
  • Data Investigation, Discovery and Analytics using Mongo DB, Python & Neo4j.
  • Data Management & Data Quality Improvements for Vendor, Customer and Product data
  • Data Modeling and setting up analytical platform on Redshift, plus Building of Data Lake/Cloud Data Warehouse on AWS
  • Ingestion of Third party and Government data real time for Data Analytics & Insights. TECHNOLOGY & PLATFORMS USED: AWS Cloud Services: S3, Redshift, AWS Glue, Database Migration Services, CloudFormation, CloudWatch. Mongo DB, ETLWorks, Bash (UNIX) scripting, Python2, Python3, Neo4j, Pyramid Analytics, Agile development & CI/CD using Gitlab, Confluence, JIRA
Agile Methodology AWS AWS CloudFormation AWS S3 Cloudwatch Continuous Deployment Data Engineering Data Modeling Data Warehousing ETL MongoDB Project Management Python Scripting Continuous Integration Data Lakes Data Management JIRA UNIX
Remove Skill
Sr. MDM Analyst
Mar 2017 - Jan 2019
No skills were added
Remove Skill
Aug 2016 - Sep 2016
Hoboken, NJ
Roles & Responsibilities:
  • Investigated and Performed current, future state assessments and built POC
  • Analyze business data and coordinate with DG team to optimize the data requirement
  • Design data model and technical data ingestion solution by working with Architects
  • Developed ETL/DQ/MDM code
  • Work with data management teams and identify data gaps to ensure alignment, harmonization and best practices. Enforce coding best practices and code reusability
  • Configure & implement match merge rules, survivorship criteria and data stewardship workflows.
  • Analytics Tools Evaluation: SAP Cloud Analytics, Power BI Projects:
  • Implemented Data Quality Improvements for Customer Data Master (CDM)
  • Investigated and Refined Match & Merge Rules and 3rd party data integration for CDM
  • PLM (Product Lifecycle Management) Vendor and tool selection for Wiley products
  • Customer Linking using SOLR/Lucene libraries, ML (Machine Learning) & Analytics
  • D&B Integration with SFDC & CDM using Informatica SIF APIs
  • GDPR & Privacy By Design empowerment in Wiley working with Arch. Team
  • Netezza to Snowflake migration to build data lake. Used Python with SnowSQL. Nipa Saraiya (sarkn@hotmail.com) 3 of 5 TECHNOLOGY & PLATFORMS USED: Informatica MDM v10.x, Data Profiling, IDQ, ETL, TIBCO, Qlik View v13.x, Qlik Sense v4.0, Oracle SQL, Netezza 5.x, SAP FI & OTC modules, SFDC, Neo4j 3.1, Java Script, D3.js, SOLR, Lucene, Microsoft office tools, Lucid charts, SnagIt, Python, Snowflake
  • SnowSQL, Trifacta, Talend
Data Integration D3.js Apache SOLR Data Lakes Data Management Java JavaScript MS Power BI SQL TIBCO Snowflake
Remove Skill
Manager/Tech Lead MDM
Jan 2012 - Aug 2016
Following MDM and Redshift work was to Support Wyndham's Strategy for Cloud Migration. MDM for Wyndham Hotel Property & Guest Master on AWS cloud:
  • Prepared Technical Solution and Execution Approach for Hotel Guest data migration to MDM cloud
  • Developed Data Model to store Guest profile, preferences, demographic data, and transition on premises to cloud.
  • Performed Data Sampling and Profiling from different sources to help set up IDQ cleanse, address validation rules, plus used Guest profiled data to set up MDM Match Merge for the best performance and addressing of duplicate and inconsistent master data from different sources.
  • Designed and configured MDM Guest Master with IDD (Informatica Data Director)
  • Developed ETL as well as utilized MDM SIF (Service Integration Framework) as rest point services to extract data from MDM and update Sales Force for Hotel opening business workflow. Implemented as SOA. Wyndham Reservations Reference Data Master on AWS cloud:
  • Aligned Data Model with Enterprise reference data to integrate with OTA (Open Travel Alliance) and Sabre HTNG (Hotel Technology Next Generation) spec.
  • Configured MDM for Reservations dimensional data like, Rate plan, Room type, Channel, Tax codes, Corporate and Travel Agent Profile etc.
  • Implemented Data Governance process for Reservation Channel data related BPM and Workflows using IDD & ActiveVOS. Analytical platform on Redshift on AWS cloud for Wyndham Reservation Data:
  • Participated in designing and building of Analytical platform on Redshift as SME for Wyndham Guest Reservations and Stay data
  • Designed ETL processes to extract from MDM and loading to Redshift Data Warehouse and BI related projects:
  • Analyzed, designed and built Enterprise data warehouse solutions and delivered Business Intelligence KPIs to business. TECHNOLOGY & PLATFORMS USED: Informatica MDM, ETL/ELT, Data Profiling, IDQ, Trillium, Microstrategy, Oracle EBS, DB2, Nipa Saraiya (sarkn@hotmail.com) 4 of 5 Oracle PL/SQL, UNIX OS and scripting, JAVA, SOA, Salesforce, AWS Cloud Technologies (S3, Kinesis, DynamoDB etc.), Redshift, Postgres, XML, JSON Technical Project Manager for Data Warehouse, BI & Hotel Guest Rewards Program
Business Intelligence Data Governance Data Warehousing Program Management Project Management AWS JSON Java SQL XML REST Data Migration
Remove Skill
Technical Lead
Jan 2002 - Jan 2008
Data Integration
  • Worked on establishing the proper Hotel Guest Stay data related specifications between Property Management System Vendor and Cendant. Loading Guest Hotel Stay data to Data Warehouse using ETL. Integrated Data Quality and Guest record match merge workflows using Trillium.
  • Vendor Data Feed integration with Data Warehouse: Bloomberg, InfoUSA, Acxiom, Exact Target etc.
  • Merger and Acquisition
  • Enhanced application processes to support business for Ramada International, Wyndham, Amerihost and Microtel Hotel Brands TECHNOLOGY & PLATFORMS USED: Informatica ETL, Data Profiling, Trillium, Power Exchange (Informatica BI tool), Informix, DB2, Oracle PL/SQL, Perl, UNIX OS and scripting, TIBCO, XML, C++
Data Integration Data Warehousing SQL TIBCO XML UNIX Oracle
Remove Skill
Consultant - Senior System Analyst and Programmer
Information Technology
Jan 1999 - Jan 2001
Chicago, IL
System Analysis
Remove Skill
Software Engineer
Information Technology
Jan 1996 - Jan 1999
Chicago, IL
Software Engineer
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
of 5
Electronics and Computer Technologies, Indiana State University
Electronics and Computer Engineering, India
Electronics and Computer Technologies, Indiana State University
Informatica
not provided
Certifications
Oracle Certified SQL, PL/SQL, Program Units Developer
Informix Certified Database Specialist
Skills
Data Warehousing
2020
11
SQL
2016
10
XML
2016
10
UNIX
2020
7
Data Integration
2016
6
Oracle
2008
6
TIBCO
2016
6
AWS
2020
5
Project Management
2020
5
Business Intelligence
2016
4
Data Governance
2016
4
Data Migration
2016
4
Java
2016
4
JSON
2016
4
Program Management
2016
4
REST
2016
4
Software Engineer
1999
3
System Analysis
2001
2
Agile Methodology
2020
1
AWS CloudFormation
2020
1
AWS S3
2020
1
Cloudwatch
2020
1
Continuous Deployment
2020
1
Continuous Integration
2020
1
Data Engineering
2020
1
Data Lakes
2020
1
Data Management
2020
1
Data Modeling
2020
1
ETL
2020
1
JIRA
2020
1
MongoDB
2020
1
Python
2020
1
Scripting
2020
1
Apache SOLR
2016
1
CRM
0
1
D3.js
2016
1
Data Analysis
0
1
Data Architecture
0
1
Data Profiling
0
1
Data Services
0
1
JavaScript
2016
1
Microsoft Excel
0
1
MS Power BI
2016
1
SAP
0
1
Snowflake
2016
1
Solutions Architecture
0
1