Karimunnisha Shawkath ali
Chennai
Summary
Has 8+ years of experience playing various roles like Data Engineer, Data Analyst, Production Issues fixing and support, ETL Testing, Stake holders communication in the domains of automobiles, banking, finance, retail, and Human Resource. Possess skills in effective problem solving through efficient thinking, taking the ownership and accountability for the tasks, and working accordingly with good communication skills. Working with a growth mindset, teamwork and delivering the best quality and productivity which improvise the business and individual capability.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Virtusa Pvt Ltd -
Senior Data Analyst - City National Bank
11.2024 - Current
- As per the first step, connect with business analysts to get the business requirements, problem statement, expected outcome, duration of the project, stakeholders list, and allocation details.
- Creating ADO stories as per the tasks, sprints, epic of the project, and acceptance criteria.
- Analysing the data structures, dimensions, and facts in the data lake in the landing and staging areas in hierarchy.
- Creating necessary documents like the Data Requirement Document, STTM, Business Understanding Document, and Tables to Column Mapping Documents, etc.
- Analysing the flow completely between source and target environments, along with the workflows and data flows.
- Consolidation of data level mismatches through row-level and column-level analysis.
- Identifying the list of columns and the amount of data dependencies on downstream applications.
- Project Environment : oracle, SAP, IICS
Senior Data Analyst for Astrazeneca
Virtusa Pvt Ltd
09.2023 - 10.2024
- As per the first step, connect with business analysts to get the business requirements, problem statement, expected outcome, duration of the project, stakeholders list, and allocation details.
- Creating Jira stories in accordance with the tasks and sprints, along with the project's epic and acceptance criteria.
- Communicating with the right POCs for data modelling (including CDM, PDM, LDM, S2T, bus matrix, data flow diagrams, and details and access for source systems).
- Once the DEV environment data is ready with the right privileges, complete data validation will be carried out – data quality checks, data completeness, along with it.
- Maintaining all versions of discussions, codes, and analyses in the shared path.
- CTCM – Clinical Trial and Clinical Management.
- The purpose of this project is to build two sets of reports: Data Quality Monitoring and Data Visibility Reporting.
- WFPR – Work Force Planning and Workforce Reporting.
- Building an app for calculating the current and forecast budget of the workforce, with actuals, planned and open positions, type of workers, location, headcount, full-time, or part-time workers, etc. for better cost management.
- Project environment: snowflake, unix, power BI
Virtusa Pvt Ltd -
Anthology International Pvt Ltd
05.2023 - 09.2023
- The current Product Telemetry API component of Blackboard Data is using a legacy approach to the AWS cloud environment and capabilities.
- Building a new Snowflake infrastructure for Product Telemetry API events, enabling dataflows into Snowflake Staging and CDM databases, measuring performance, and sharing data with clients from single-tenant databases.
- Project Environment: Snowflake (streams, tasks), Python, Visual Studio, SQL, Shell commands, AWS (Iac, CloudFormation, SNS, SQS, S3, SSI, CloudWatch).
Senior Software Engineer
Tiger Analytics - Pacific Life insurance
02.2023 - 04.2023
- Worked on the data validation between two source systems, where the data is migrated from the SQL server to Snowflake.
- Worked on creating Excel reports for the elements, logic confirmation, and data quality check.
- Performed frequent checks whenever the table was updated, and interacted with the client.
- Pacific Life Insurance Company is an American insurance company providing life insurance products, annuities, and mutual funds.
- Project Environment: GCP, SQL
Senior Software Engineer
Tiger Analytics - Prologis
09.2022 - 02.2023
- The overall purpose of these dashboards is to assist the Prologis team in tracking and analysing the number of employees coming to the offices, and tracing the contact of employees within an office in case of an infection.
- The scope of the project includes analysing, validating, and using Prisma Access data, Netskope data, Armis data, Resource List, and Subnet Mapping data to create both the Tableau and Sigma dashboards.
- Prologis is a real estate investment trust headquartered in San Francisco, California, that invests in logistics facilities.
- Project Environment: Snowflake, and Tableau.
Senior Software Engineer
Tiger Analytics - Prologis
06.2022 - 09.2022
- The overall purpose of these dashboards is to assist the Prologis team in tracking and analysing the data completeness percentage for the new CARE pilot fields for each pilot market after their respective go-live date.
- This will help them understand if Prologis customers are filling in the CARE pilot fields after each CARE visit.
- Prologis is a real estate investment trust headquartered in San Francisco, California, that invests in logistics facilities.
- Project Environment: Denodo, DBeaver, Tableau, and AWS workspace.
Senior Software Engineer
Tiger Analytics - Prologis
07.2021 - 05.2022
- The overall purpose of these dashboards is to assist the Prologis Customer Experience team in tracking and analysing the pertinent KPIs on a real-time basis for the Top 25 Customers, in a single, centralised location.
- This will help them in understanding how their customers are performing with respect to other customers, and help them in creating their Quarterly Business Review reports.
- Prologis is a real estate investment trust headquartered in San Francisco, California, that invests in logistics facilities.
- Resolved Jira tickets with comprehensive bug fixes.
- Project Environment: Denodo, DBeaver, and Tableau.
Software Engineer
Sysvine Technologies - NPD
02.2021 - 06.2021
- Planned migration flow, time, and schedule for assigned frequency tickets.
- Scheduled the source job and target job to migrate the data to the destination.
- Ran the queries in Sybase for module enabling, job information check, schema details, and for end-to-end analysis.
- Ran automation in the NAV portal with template Excel sheets to pull the errors in the data.
- NPD measures how consumers shop across all channels, sourcing data from both retailers and consumers to quantify sales, share, distribution, and velocity.
- Project Environment: Sybase, DBeaver, NAV portal, JCA, and Putty.
Software Engineer
Systech Solutions - Walmart
03.2020 - 01.2021
- Worked with the client to gather the business requirements, analyse the requirements, and produce specification documents for new project requests.
- Worked on performing a transformation on a CSV file and saving data into an Excel file for feed reports using SQL script.
- Automate the same process for generating the reports on a daily, weekly, and monthly basis.
- Worked on some enhancement tasks, such as adding new columns in existing reports and tables.
- Developed an ETL process for loading data from Oracle to GCP.
- Optimised the query to run faster and avoid the query failing due to insufficient space.
- Wal-Mart Stores, Inc. is an American multinational retail corporation that operates a chain of discount department stores and warehouse stores.
- Project Environment: Teradata, GCP (Google Cloud Platform), BigQuery, Putty, Oracle, WinSCP, and Tableau.
Software Engineer
Systech Solutions - CNH
10.2019 - 03.2020
- Actively participated in project meetings for requirement gathering, and worked closely with business users and stakeholders.
- Involved in the full project life cycle implementation (requirement gathering to production) of Qlik Sense dashboards.
- Designing a Data Mart, a Data Warehouse, and the implementation of Qlik Sense for BI reporting solutions.
- Involved in designing the data models, extracting and transforming the data from heterogeneous data sources such as QVD files, Excel, SQL Server, Oracle, and text files to create the Qlik Sense dashboards.
- Performed ETL tasks such as data cleansing, joins, and aggregation tables using Qlik Sense.
- Performed the complete lifecycle implementation of Business Intelligence with Star and Snowflake schemas, fact and dimensional tables.
- Extensively worked with Qlik Sense functions such as Sub, Load, apply map, Peek, Concatenate, Cross Table, Match/No Match, and objects, Set Analysis, and Variables to generate schema and tables.
- CNH Industrial N.V. It is one of the world's largest capital goods companies, registered in the Netherlands, with corporate offices in London.
- Project Environment: Qlik Sense tool, which is used for both ETL and reporting.
Software Engineer
Systech Solutions - Tillys
03.2018 - 10.2019
- Developed codes that required the dimensions and facts using the sales data mart in SQL Server.
- Created stored procedures and functions, and generated reports using HTML language.
- Automated reports have been sent to the client with scheduled email jobs in SQL Server.
- Maintained the assumptions and issues faced in separate documents, such as the Issue Log and the Assumption Log.
- Tilly's is an American retail clothing company that sells action sports-branded clothing, accessories, shoes, and equipment.
- Project Environment: MS SQL Server 2008 R2.
Software Engineer
Systech Solutions - Wash Laundry
09.2017 - 01.2018
- Developed mapping for all the dimensions and facts for developing the sales data mart with Informatica.
- Created workflows for running the sequential and concurrent sessions.
- Created test scripts for the project and documented the same for service calls data mart.
- Maintained the assumptions and issues faced in separate documents, such as the Issue Log and the Assumption Log.
- Formerly known as Web Service Company, WASH Multifamily Laundry Systems has been in continuous operation since 1947. WASH provides laundry facilities management services for apartment properties, college and university residence halls, military bases, and other multi-housing locations.
- Project Environment: MS SQL Server 2008 R2, Informatica 9.6.1, Tableau
Education
MBA - Finance and HR
Madras University
01-2019
B. Tech - IT
C. Abdul Hakeem College of Engineering and Technology
01-2015
Skills
SQL and PL/SQL
Snowflake, Snowpipe, Streams, and Tasks
Data Warehousing Concepts
ETL Development and Data Analytics
Informatica PowerCenter and IICS
AWS cloud services, GCP
Power BI and Tableau basics
Domains worked
- Retail
- HR
- Finance
- Real estate
- Banking
- Automobiles
- Commercial
- Health Care
Certification
- Snow Pro Certified - snowflake
- Simulation project in SQL and informatica
Timeline
Virtusa Pvt Ltd -
Senior Data Analyst - City National Bank
11.2024 - Current
Senior Data Analyst for Astrazeneca
Virtusa Pvt Ltd
09.2023 - 10.2024
Virtusa Pvt Ltd -
Anthology International Pvt Ltd
05.2023 - 09.2023
Senior Software Engineer
Tiger Analytics - Pacific Life insurance
02.2023 - 04.2023
Senior Software Engineer
Tiger Analytics - Prologis
09.2022 - 02.2023
Senior Software Engineer
Tiger Analytics - Prologis
06.2022 - 09.2022
Senior Software Engineer
Tiger Analytics - Prologis
07.2021 - 05.2022
Software Engineer
Sysvine Technologies - NPD
02.2021 - 06.2021
Software Engineer
Systech Solutions - Walmart
03.2020 - 01.2021
Software Engineer
Systech Solutions - CNH
10.2019 - 03.2020
Software Engineer
Systech Solutions - Tillys
03.2018 - 10.2019
Software Engineer
Systech Solutions - Wash Laundry
09.2017 - 01.2018
MBA - Finance and HR
Madras University
B. Tech - IT
C. Abdul Hakeem College of Engineering and Technology