Malcolm John Tamang Email & Phone Number

Nepal

Kathmandu, Bāgmatī, Nepal

● Developed robust ETL pipelines using Python, DBT, and Snowflake for processing data forthe company's products.● Created extraction scripts to pull data from FTP servers, ensuring timely and accurate dataretrieval.● Developed preprocessing scripts to clean and map flat files for data integration.● Performed data analysis and profiling by extracting data from clients' FTP servers to alanding zone (S3) and then to Snowflake using SQL.● Onboarded multiple US retailers onto the company's data analytics SaaS platform bycollaborating with stakeholders to understand data requirements and business objectives,ensuring data solutions aligned with strategic goals.● Created Snowflake stored procedures to generate data summary reports as requested byclients.● Developed data quality control scripts to validate various metrics and KPIs.● Implemented CI/CD processes to build and deploy pipeline code in ECR and process itusing ECS: Fargate.● Designed and implemented a client onboarding template that streamlined processes andreduced workload by 30%, improving efficiency and client satisfaction● Contributed to growing the client base, including securing partnerships with 10+ multi-billiondollar companies● Defined, documented, and implemented the overall data pipeline architecture for a highlyscalable analytics platform● Provided technical guidance and mentorship to junior team members, supporting theirprofessional growth and development in data engineering.

Kathmandu, Bāgmatī, Nepal

● Collaborate with the data analytics team to define project objectives, data requirements, andanalytical approaches.● Assist in managing and mentoring a team of data analysts, guiding their work, and providingsupport and feedback● Resolved production issues in ETL pipeline by analyzing data and implementing hotfixes,ensuring smooth data flow and minimizing downtime● Leveraged AWS services including Redshift , S3, and MS Excel to perform data analysisand profiling, and prepared comprehensive reports for clients● Data Import, Data modeling, PHI Data De-identification and Data mapping.● Implementing ETL process (Data Extract, data profiling and cleansing, enforcing data qualityand maintaining consistent standards

Kathmandu, Nepal

● Created Oracle Data Integrator (ODI) mappings to support ETL workflows and streamlinedata integration tasks.● Integrated JOB scheduling for optimizing redundancy in PL/SQL scripts, automating andstreamlining data processing tasks for improved efficiency and performance.● Led the transformation of complex PL/SQL data scrubbing scripts into streamlined ETL(Extract, Transform, Load) processes using Oracle Data Integrator (ODI).● Writing Modifying complex SQL subqueries, PL/SQL blocks, stored procedure functions, triggers● Developed PL/SQL scripts to perform Extract, Transform, and Load (ETL) processes,importing data from clients' SFTP server to Oracle database.● Designed and implemented data transformations within the PL/SQL scripts to ensure dataintegrity and compatibility.● Developed Integration Testing PL/SQL package to tests all the test cases during ETL work● Conducted raw data analysis using SQL to identify trends, patterns, and anomalies,contributing to data quality assurance efforts and leading to a 95% improvement in datacompleteness and accuracy by performing data gap analysis and requirement analysis frombusiness users● Conducted data ingestion, validation, profiling, and migration of US Healthcare data,ensuring a 98% data accuracy rate and a seamless transition to the new system● Resolved defects during QA testing, pre-production, production and post-release patches.● Performed integration testing on various tickets, verifying the accuracy and completeness ofdata transformations and loading operations.● Worked with US Health Care Data from insurance brokers and vendors of US in HealthAnalytics Sector● Provided training to new members offshore and onshore on ODI (Oracle Data Integrator),including knowledge sharing, briefing on project-specific logic, and debugging assistanceduring development.

Kathmandu, Nepal

● Completed training on PL/SQL, Shell Scripting, Java, SQL server● Database design and DataWarehousing

Lalitpur District, Nepal

Create and develop web application using Python and Django and create Restful API