Deputy Manager
Deloitte Touche Tohmatsu
Total years of experience :6 years, 1 Months
• Gathered and analyzed business requirement and optimized data models and databases to perform ETL processes, develop reports using BI tools, and conduct data analysis for insights.
• Created technical documentation, including data schemas, relationships, and process flows diagrams and KPI and SOP’s for BRD and TRD document and Test Cases, Test Script and Test Plan to facilitate effective communication and knowledge sharing among team members and stakeholders.
• Designed and implemented data modeling standards, optimize data storage and retrieval, ensure data integrity and security, collaborate with stakeholders to understand data requirements, and provide guidance for data-related projects in the given Sprints.
• Developed and maintained data pipelines and ETL processes for BIG Data technologies from various sources, monitor and optimize data performance, implement data quality and governance practices, and integrate data from multiple systems for analysis and reporting.
• Designed, implemented, and managed data solutions using Azure data services and develop ETL/ELT processes and automate data pipelines and optimize data models and schemas, ensuring data quality and security.
• Experienced in working an agile delivery environment such as user stories, backlog grooming, sprints and skilled at presenting, data storytelling.
• Worked as a Data Engineer for Production Team in designing, creating, testing, and maintaining the complete data management & processing systems and taking care of the complete ETL process.
• Responsible to manage data coming from different sources and develop and maintain data governance practices, ensuring data quality, security, and compliance across all stages of data processing and storage.
• Experienced in Importing and Exporting data into HDFS and Hive using Apache Spark and Stores the data from HDFS to respective Hive tables for further analysis to identify the Trends in data.
• Developed Hive queries to process the data for visualizing as well as collaborating with various team & management to understand the requirement & design the complete system.
Extracted data from primary and secondary sources, leveraging Big Data technologies such as Hadoop, Teradata, and Spark. Reorganized the data into a format easily readable by clients and transformed raw data using ETL (Extract, Transform, Load) processes.
• Created optimized schemas in Hive with performance optimization techniques such as bucketing and partitioning. Developed Hive queries to transform data for further downstream processing, utilizing SQL skills and expertise in data modeling.
• Utilized SAS for dataset analysis, performing statistical techniques and data manipulation to meet business requirements. Identified, analyzed, and interpreted trends and patterns in complex data sets, applying data analytics and business intelligence techniques.
• Collaborated with cross-functional teams including risk analysts, data scientists, and business stakeholders, utilizing strong communication and collaborative skills. Participated actively in meetings and discussions, providing data-driven insights, and contributing to the alignment of data strategies with business objectives.
• Collaborated with network, server, and DBA teams to resolve issues and ensure smooth functioning of applications, while maintaining records of configuration changes and scheduling application updates.
• Implemented data optimization techniques such as performance tuning, partitioning, and indexing to improve data processing efficiency, ensuring high performance and scalability.
• Executed SQL and PL/SQL queries on application databases to retrieve data and provide daily reports to clients. Perform SOD queries on servers and troubleshoot any issues with application servers.
• Retrieved inward and outward cheque images from Putty sessions and provide remote application support to all PAN India locations. Offer technical assistance and monitoring for application servers in production and disaster recovery environments.
• Collaborated closely with development, testing, documentation, and product management teams to deliver high-quality products and services in a fast-paced environment. Maintain records of configuration changes and schedule application updates.
• Ensured effective front-end and back-end functionality of applications, consulting with the software development team, internal users, and clients to improve application performance.
• Executed PL/SQL queries and stored procedures for data retrieval and created comprehensive Test Plans, Test Cases, and scripts for UI testing.
• Researched, diagnosed, troubleshooted, and identified potential solutions for resolving issues promptly.
• Enhanced strong experience in analyzing software application functionality and suggesting improvements and excellent problem-solving and troubleshooting skills, with the ability to prioritize and resolve multiple issues.
Successfully completed my Master degree in Big Data and Cloud Computing.
Successfully completed bachelor degree in Database management System and programming.
