Quality Assurance Social Media

Phone: 510-***-****

*******@*****.***

Daljit (Dal) Atwal

Hayward, CA

http://www.linkedin.com/in/dalatwal

Objective

Application Developer.

Summary of Qualifications

Experience in the social media, financial transactions, Loan/banking, health, telecommunication, transportation industries, designing, developing, experience with large data sets, quality assurance, dev ops application support, and implemented software solutions to support strategic business objectives for UNIX environments, and enterprise applications.

Outstanding work ethic and effective interactions with all stakeholders.

Knowledge of Software Development Life Cycle, from identifying requirements, design, developing, testing, quality assurance, integration, implementation, and continual support.

Technical Knowledge

Languages: COBOL II, COBOL 74, SQL, SnowSQL, PL/SQL, (Explain Plan, Data Mapping (source to target), DDL, DML), ETL tool Ab initio Data profiler, UNIX/Linux scripting, Familiar with Python

Development Tools: Endevor, Control-M, VS Code, SFTP, Cleartool / ClearQuest, Aqua Data Studio, Toad, Network Data Mover (NDM), ISPF, JCL, QMF, SPUFI, Syncsort, File Aid, REXX, JIRA, SAS EG 6.1, Hadoop, ServiceNow, Tableau, Unisys ECL

Environment Used

Systems: IBM 360/390, HP3000, z/OS Linux on Z Systems, Unisys 2200, UNIX/LINUX, (AIX on MPP System, Solaris)

Databases: DB/2, Snowflake, Teradata, Oracle 11g, Microsoft SQL Server 17.1 IBM UDB, DMS 1100

Work Experience

Accenture, San Jose Office, CA March 2021 to January 2024

Software Data Practitioner

Data Engineer - Major social media company

Used technical skills to resolve data pipeline processing issues, and maintain the SLA for each product group using internal analysis software to triage root cause analysis, delay findings, failures, backfill ( reload) data, and debug pipelines, maintained SLA

Implemented source code modifications using SQL, VS Code, pipelines with python, pyspark, presto written queries.

Analyzed pipelines for query efficiencies, modify, and test to see possible overall system cost savings pre task.

Software Developer – Spectrum Communications Inc.

Developed code to take Teradata DB, and embedded Python code with SQL queries application for Available and Sold Advertisement Inventory migrate over to SnowSQL, with AWS S3 storage

Using agile methodology on a direct six-member team, met daily, for scrum discussions

Collaborated with Business and Data Architects on design of databases.

Conducted Quality Assurance on all Linux coded scripts, using Testrail to build Test Cases, and Test Runs

Data ETL Consultant - Citigroup Inc.

Document the entire process of COBOL processing that is consumed by ETL Ab initio code processing used in various global applications.

Assist in detailing out the migration option approaches that Citigroup could invest in

Consult with Citigroup System Analysts on complex processes within the applications.

ATR International, Santa Clara, CA July 2019 to December 2020

Client: Wells Fargo Bank, (Fremont, CA)

Senior Data Analyst

Created Linux (Korn shell) scripts using Teradata/SQL Server Databases for data driven decisions

Researched data on the customer account journey, create regression analysis reports on digital transactions, brainstorm with Business Consultants on main metrics that need to be captured, and reported on

Documented enhancements to overall code and/or visualization reports in consultation with end users

Developed reports using SQL, SAS, Tableau, Excel, and Power Point decks

Created trend analysis reports, that showed how microservices were performing

Monitored via scripts current status of the 75 jobs that process analyzed data, maintain the code

Created mockup reports, currently doing a tread analysis report for various microservice applications

Insight Global., San Francisco, CA October 2016 to October 2018

Client: Kaiser Permanente, (Pleasanton, CA)

Data Systems Analyst

Updated membership records using SQL in the source or staging system to correctly load the record into the

target database

Wrote multi-join, and function-based PL/SQL queries using SQL Developer to analyze the Integrity of the overall Membership Data Warehouse. Spent 80% of the day on these tasks

Used Oracle 11g, PL/SQL and SAS Enterprise 6.1 for checking overall record relationships

Analyzed the data content using SQL to fully understand the table data models in terms of the data trends,

and, the parent and child relationships when incidents occurred.

Documented the incident findings using Excel, attached these to ServiceNow system

Run full table scans and regression, at the field level for integrity checks on major production issues

Maintained daily the Excel incident report, tracked action items to resolve the incident to full satisfaction

of end user

Wrote test cases using data model, and data mapping specifications, wrote test summaries,

validated results

Conducted UAT testing cycles of releases throughout fiscal year.

Worked with Erwin to check on data entity graphs for logical and physical database models

Triaged defects with other resources to fully correct issues using root cause analysis

Worked with Data Governance Team to provide input to set policies

Created and maintained job function documentation, and train new analysts

Insight Global., San Francisco, CA January 2016 to July 2016

Client: Wells Fargo Bank, (Concord)

Data Analyst

Used Oracle DB, PL/SQL, SQL Developer, Toad, SAS, and UNIX to gather loan consumer customer

data to build a Marketable Customer Loan Data Mart

Develop Unix scripts to automate execution of multiple PL/SQL queries

Analyzed new scoring models for response, and approval of Loan marketing customer data

Write Unix scripts to exact data into files, loaded files into test schemas

Validate data fields that are used in different kinds of marketing campaigns using Excel spreadsheets

Conduct parallel tests with market strategist

Visa, Inc., Foster City, CA July 1998 to September 2015

Senior Software Developer

Design, developed, implemented, documented multiyear projects using ETL tool Ab initio, Unix commands, Scripting, COBOL II, DB/2, UDB, SQL (Many of these projects resulted in millions of dollars in savings)

Lead Developer on a multiyear project to convert extract applications from MVS/COBOL II to Unix/Ab initio

Developed ETL applications that consumed Big Data files with over 180+ million large record data sets.

Developed and maintained Visa Fraud Application both on Mainframe, and ETL systems.

Developed and maintained a multi-terabyte BI data warehouse that housed over 150 tables in support of approximately 15 applications.

Developed and maintained Visa Fraud Application both on Mainframe, and ETL systems.

Maintained Visa internal data (UMF) format parser written in C++ and Ab initio custom component.

Conducted in-depth research on field mismatches with transaction services team, and business analysts.

Wrote extract Ab initio graph where risk tag-based data was extracted into Hadoop HDFS file system.

Designed, coded, tested to efficiently manage storage of 3000 big data files produced daily

( Resulted in overall terabytes in savings pre server node)

Thoroughly researched very complex transactional issues and questions for business clients

Conducted performance tests of the Ab initio written code, this allowed the code to be optimized.

Conducted end to end application testing for downstream applications, with internal and offshore teams.

Collaborated with operations on production support issues.

Conducted end to end application testing for downstream applications.

Conducted numerous application benchmark performance tests

Trained operational and support staff on applications.

United Airlines Inc., San Bruno, CA April 1991 to July 1998

Senior Programmer Analyst

Migrated applications written in COBOL I / Unisys/ECL that was using DMS 1100 Database to COBOL II for DB2

Created data dictionary in conjunction with business analysts, and DBA as part of migration project

( This resulted in overall savings in millions of dollars, and cut the processing time by 50%)

Production Support 7 by 24 hour on call assistance to operation staff in Chicago and San Francisco with production issues

Conducted numerous joint application implementations with team in Chicago

Education

California State University East Bay, Hayward, CA

BS - Computer Information Systems

Chabot College, Hayward, CA

AA – Computer Information Systems

Awards / Interests

Refresher course In COBOL II / MVS, November 2023

Advanced Unix Shell Scripting

Contact this candidate