Aparna C Email & Phone Number

Dallas-Fort Worth, Texas, Us

My responsibilities include designing and implementing large-scale data storage and processing systems, developing and maintaining data pipelines, analyzing and interpreting complex data sets, creating and implementing data models, and working with cross-functional teams to identify and solve business problems using data. Developing and implementing data storage solutions, such as data warehouses and data lakes, to store and organize large amounts of data from various sources. Creating and maintaining ETL (extract, transform, load) processes to clean, transform, and integrate data from different systems and sources. Designing and implementing data security and privacy measures to ensure the protection of sensitive customer and operational data. Building and maintaining data pipelines to enable real-time data processing and analytics. Collaborating with data scientists and other team members to design and implement data models and algorithms that support business decision-making. Optimizing the performance and scalability of the data infrastructure to handle large amounts of data and high traffic loads.

Charlotte, North Carolina, Us

My responsibility is to use real-time streaming data from various sources, such as financial transactions, customer data, and social media, to detect patterns and anomalies in financial transactions. By analyzing this data in real-time, the I can identify potential fraud and suspicious activity as it happens, allowing Truist Financial to take immediate action to prevent losses and protect assets.Creating Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards. Writing a Data Bricks code and ADF pipeline with fully parameterized for efficient code management. Developed Databricks Python notebooks to Join, filter, pre-aggregate, and process the files stored in Azure data lake storage. Used SQL Server Integrations Services (SSIS) for extraction, transformation, and loading data into target system from multiple sources. Designed both 3NF data models for OLTP systems and dimensional data models using star and snowflake Schemas. Performed all necessary day-to-day GIT support for different projects, Responsible for design and maintenance of the GIT Repositories, and the access control strategies.

Atlanta, Ga, Us

•Involved in transforming data from Mainframe tables to HDFS, and HBase tables using Sqoop.•Visualized the results using Tableau dashboards and the Python Seaborn libraries were used for Data interpretation in deployment.•Used Rest API to Access HBase data to perform analytics.•Created and maintained technical documentation for launching Hadoop Clusters and for executing Pig Scripts.•Worked with NoSQL databases like HBase in making HBase tables to load expansive arrangements of semi structured data.•Involved in data ingestion into HDFS using Sqoop for full load and Flume for incremental load on variety of sources like web server, RDBMS, and Data API’s.

Hyderabad, Andhra Pradesh, In

•The custom File System plugin allows Hadoop MapReduce programs, HBase, Pig and Hive to work unmodified and access files directly.•Extensive use of Expressions, Variables, Row Count in SSIS packages•jobs in java for data cleaning and pre-processing.•Importing and exporting data into HDFS from Oracle Database and vice versa using Sqoop.•Deploying and scheduling reports using SSRS to generate daily, weekly, monthly, and quarterly reports.•Data validation and cleansing of staged input records was performed before loading into Data Warehouse