Data Analyst Engineering

Ruparani Dash

Email: ***********@*****.***

Ph#: 973-***-****

Professional Summary:

Around 4 years of experience in Data Engineering, Analysis.

• Proficient in designing and optimizing ETL pipelines and data ingestion processes using Python, SQL, and cloud technologies.

• Skilled in Agile methodologies, ensuring efficient project delivery and alignment with business objectives.

• Strong collaboration with data stewards, business analysts, and data modelers to define data requirements and finalize data dictionaries.

• Experienced in building ETL jobs to ingest flat files into PostgreSQL, MySQL, and Databricks Hive, ensuring smooth data flow and transformation.

• Expertise in query authoring and data analysis to provide actionable insights for business decision- making.

• Conducted root cause analysis on data issues and scripts, identifying opportunities for process improvement and optimization.

• Assisted in data preparation and cleaning, ensuring high-quality, consistent datasets for analysis and reporting.

• Developed and executed comprehensive unit tests for ETL jobs, ensuring data quality and pipeline accuracy.

• Hands-on experience with AWS services (S3, EC2, RDS) to manage cloud-based data workflows and enhance pipeline scalability.

Technical Skills:

Languages Python, SQL

Data Platform Databricks

Databases MySQL, PostgreSQL, Hive

Operating Systems UNIX, Windows

Cloud AWS, S3, EC2, RDS (Postgres)

Duration: Dec 2017 – Dec 2019

Role: Systems/Data Analyst

Employer: Hired by Matrix

• Analyzed data requirements and developed functional documentation outlining data sources, data models, and dependencies.

• Collaborated with stakeholders including data stewards, business analysts, and data modelers to clarify, confirm, and align data requirements.

• Designed and implemented ETL pipelines to ingest flat files into systems such as PostgreSQL, MySQL, and Hive using Python and Databricks.

• Proficient in relational databases and SQL query authoring for data manipulation and extraction.

• Conducted root cause analysis on data issues and scripts to address specific business queries and identify opportunities for optimization.

• Investigated customer inquiries related to derived data sources, ensuring accurate and timely delivery of data to clients.

• Developed and executed unit test cases to validate ETL jobs, ensuring data quality and accuracy.

• Gained hands-on experience with AWS services including S3, EC2, and PostgreSQL during the migration from on-premises systems to the AWS cloud environment.

• Managed the installation and upgrade of SAS and associated components on UNIX and Windows servers.

• Oversaw day-to-day SAS BI administration tasks to ensure optimal system performance and availability.

• Provided troubleshooting support for SAS server issues, including capacity management and archive backup planning.

Duration: Dec 2014 – April 2015

Role: Credit Analyst

Kotak Mahindra Bank Ltd. (INDIA)

• Was responsible Collect and consolidated disbursement data from multiple spoke locations, ingesting the data into a central database table using SQL.

• Generate reports from the ingested data and communicated insights to the central team, ensuring timely and accurate data delivery for analysis and decision-making

• Analyzed and interpreted Credit Bureau Reports, assessed income levels, analyzed bank statements, and evaluated eligibility for hubs and service centers.

• Interacted directly with customers to understand their needs and provided solutions within the available product range, ensuring customer satisfaction.

• Calculated Net Present Values (NPV) of maturing assets using Excel, providing accurate financial assessments for investment decisions.

• Demonstrated technical understanding of the fundamentals involved in home acquisition, supporting customers through the process.

• Assessed NRI Loans using the cash flow method and evaluated self-employed loan applications based on financial viability.

• Managed the disbursement process by following up with customers and sales team post-sanction, resolving legal queries, and ensuring technical updates and disbursement fixes were completed promptly.

• Ensured timely and accurate updating of leads in the LMS, followed up on scheduled actions, and performed auditing, feedback, and status updates to maintain lead management efficiency. Duration: Jun 2012 – May 2013

Role: Credit Associate

Client: HDFC BANK (INDIA)

• Was responsible for managing and maintaining regional commercial loan, customer profile data by ingesting those to central database leveraging SQL.

• Review and correction of loan data on centralized database based on the final agreement and audit requirements.

• Interpretation of Credit Bureau Report, Assessment of Income, Analysis of Bank Statements, Assessing eligibility of hubs and service centers

• Customer Interaction to understand needs, finds solutions within product range available.

• Calculation of Net Present Values of maturing assets using excel sheets.

• Knowledge of basic legal documentation involved in an acquisition of a home.

• Knowledge of technical fundamentals involved in an acquisition of a home.

• Cash flow method of assessment of NRI Loans, Ability to assess a Self-Employed Loan

• Supervision and performance management of all team members

• Supervision of all the activities done by non-sales Staff / coordinators: -

• Sanctioning: - File processing by coordinator within the time, Customer Calling, Query resolving, File login at HDFC, Faster Sanction, keeping a check on TAT for Login & Sanction., Checking the Quality of Calls to Customers & Processing by coordinators.

• Disbursement: - Customer calling after Sanction of Case, Disbursement Follow-up with Customer & Sales force, and Technical Updating for Disbursement, Resolving Legal Queries, and Fixing of Disbursement, Technical Updating, and Disbursement Fixing. Education: Master in finance

Contact this candidate