Akmal K Email and Phone Number

• Managing solution to build Data Lake architecture for advanced analytics • Design data pipelines to extract data from different data sources using AWS Cloud, and cloud-native technologies • Building a data model to get relevant insights from data, operational efficiency, and other essential performance metrics • Design and manage inbound and outbound data processes and monitoring. Work with the data provider to bring in new feed into our data eco-system • Building AWS data-warehouse model to provide scalable solution • Documenting business, functional and technical requirements related to data, ETL requirements, data lineage and quality • Maintain documents related to data flows, source to target mapping, conversion logic, business definitions etc. and gain appropriate approvals. • Lead full spectrum data analysis against the requirements • Work with the Application Engineering team, DBA, Infrastructure and Project Management • Analyze existing systems (including legacy) and data sets to help Business Analysts establish the functional and non-functional requirements. • Worked with internal architects and assisted in the development of current and target state enterprise data architectures. • Involve in data migrations and creation of data marts for reporting • Performing data validations and test case documents. • Meet with users, assist with data-related technical issues, and support their data infrastructure needs • Generate design, development, test plans, detailed functional specifications documents, user interface design, and process flow charts for execution of programming. • Develop data pipelines using Python, SQL, Py-Spark and AWS Methods. • Use an analytical, data-driven approach to drive a deep understanding of fast changing business. • Cloud integration with AWS using Simple Storage Service (S3), EC2, AWS Athena. • Involve in data integration, data wrangling and Data management.

• Involved in gathering the requirements from BSA and involved in the meetings held with BSS for the design approach. • Involved in Data Migration from Oracle Legacy to SQL using SQL Navigator and SQL Management Studio. • Involved in Analysis, profiling and cleansing of legacy data and hence making the data available for further use. Engage user to gather software requirements rules and ensure alignment with development teams. • Created STTM documentation for data mart integrating different source systems. Involved in documentation of Data Mapping & ETL specifications for development from source to target and implemented the change Data Capture (CDC) while integrating the enterprise data sources. • Created Indexes and Partitions to optimize the performance. Assisting ETL Team, BI team and end users to understand the data model. • Assisted to build analytic tools to manage data and streamline data analyses using Python and SQL. • Complex incoming data cleaning and formatting using Python. Ensured data accuracy through the creation and implementation of data integrity queries. • Provided technical assistance for development and execution of test plans and cases as per client requirements. • Developed queries to build a new database in SQL using SSIS and migrated the data from the legacy. Created batch files that execute the ETL scripts which invokes SSIS packages. • Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated. • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data ware house by using BIDS.

• Gathering the requirements from the Business users and understanding the functionality of the business. • Preparing required functional design documents and technical designed documents • Worked on the thorough Data analysis to make sure that all the sensitive data has been identified • Involve in data integration, data wrangling and Data management. • Working knowledge of data migration and creation of data marts for reporting • Performing data validations and written test case documents. • Performed data analysis and data profiling using complex SQL on various sources systems. • Created SQL scripts to find data quality issues • Work with developers in data transformation and data validation • Prepared Test Plan to ensure QA and Development phases are in parallel • Knowledge of working with Proof of Concepts (PoC's) and gap analysis and gathered necessary data for analysis from different sources. • Experience in writing stored procedures and complex SQL queries using relational databases like Oracle, SQL Server, and MySQL. • Experience in Extraction, Transformation and Loading (ETL) of data from multiple sources like Flat files, XML files, and Databases. • Supported various reporting teams and experience with data visualization tool Tableau. • Written and executed Test Cases and reviewed with Business & Development Teams. • Implemented Defect Tracking process using JIRA tool by assigning bugs to Development Team • Experienced in working with spark ecosystem using Spark SQL and Scala queries on different formats like text file, CSV file. • Experienced in designing both time driven and data driven automated workflows. • Proficiency in SQL across several dialects (MySQL, PostgreSQL, AWS Athena, SQL Server, and Oracle). • Performed data analysis and data profiling using complex SQL on various sources systems. • Created SQL scripts to find data quality issues • Updated and managed existing products to increase the performance of the product

• Analyze database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions. • Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation. • Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy Sybase systems. • Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter. • Implemented the standard naming conventions for the fact and dimension entities and attributes of logical and physical model. • Used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges. • Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement. • Developed the required data warehouse model using Star schema for the generalized model. • Extracted data from the databases (Sybase and SQL Server, FLAT FILES) using Informatica to load it into a single data warehouse repository. • Developed ETL files to get data from staging tables and batch files, transform that data and load into the fact tables and data marts to populate parallel and attribute changes reports. • Define and document ETL process and data flow and scheduling capabilities. • Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT). • Created Triggers to capture the Data manipulation transactions on the Fact tables and Fact history tables. • Utilized SQL to develop new and debug existing Ad-Hoc reports. • Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.

• Understanding the specification and analyzed data according to the client requirement. • Conducting requirement gathering sessions with Mortgage Banking Report Owners/SMEs to understand the current process flow of report generation and identifying the Risk Data elements. • Back-tracking of Risk Data elements to its source system and capturing all the calculation/derivation logic involved in underlying SQL codes. • Mapping the Risk Data elements to the Authoritative Data Source and documenting the Schema, Database, Table details for data modeling purpose. • Performed Risk Data aggregation i.e., defining, gathering and processing risk data to enable SIFIs (Significantly Important Financial Institutions) to measure performance against internal tolerance criteria. This includes ability to sort, align, merge and analyze multiple sets of data across the enterprise. • Participated in DRB Sessions with the reviewer by presenting the designed data models and explained how we followed the standards while designing the models. • Prepared Conceptual Model Use Cases for representing the various dimensions and measures involved in recreation of Mortgage Banking reports. • Interact with the customer and the SME(s) to identify the relationship between the data element and the business rule to document the data • Capturing data elements - definitions and characteristics for information requirements • Mapping data to the authoritative source field and table name as part of the data migration analysis activity • Worked as a part of Migration Testing Project where the duties were to writing SQL queries and executive the queries to match with the data in the target. Analysis the logic written by the developer and testing it with our own developed queries to check the migration of data accuracy. • Working on Application lifecycle management tool for uploading the test cases, raising the defects and managing the defects.