| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Address: Parsippany, NJEmail: EMAIL AVAILABLEPROFESSIONAL SUMMARY:Have total 5+ years of experience in Data analysis and testing.-Proficient in agile methodology, followed agile principles for delivery efficiency.-Analyzed and prepared data requirements documents aligning to business needs.-Collaborated with data stewards, business analysts, and data modelers to clarify and confirm data requirements, fostering effective communication and collaboration.-Developed ETL jobs to seamlessly ingest flat files into RDBMS systems such as PostgreSQL and MySQL, enhancing data accessibility and usability.-Leveraged advanced SQL knowledge for query authoring and data analysis, providing valuable insights to support decision-making.-Assisted in data preparation and cleaning, ensuring data quality and consistency.-Conducted root cause analysis on data and scripts, enabling the identification of business-specific issues and opportunities for process enhancement.-Built comprehensive unit test cases and executed testing for ETL jobs, ensuring data quality and correctness.-Demonstrated expertise in AWS, including S3, EC2, and PostgreSQL, to facilitate data management activities in cloud environments.Before getting into IT industry, Worked in Finance industry as Credit Analyst with following responsibilities.-Interpretation of Credit Bureau Report, Assessment of Income, Analysis of Bank Statements, Assessing eligibility of hubs and service centers-Cash flow method of assessment of NRI Loans, Ability to assess a Self-Employed Loan-Managed process for Commercial and Individual finance project approval, loan sanctioning, Disbursement-Leverage LMS (Lead management system) for potential customer interaction, Tracking, Feedback etc.INTERESTSListening to music, Making different dishes, Regional HistoryLove to travel places of natural and scenic significanceTECHNICAL SKILLS:Database: PostgreSQL, MySQLAnalytics Platform: SAS Platform Administration, DatabricksCloud: AWSDuration: Dec 2017 Dec 2019Role: Systems/Data AnalystEmployer: Matrix-Collaborated with data stewards, business analysts, and data modelers to clarify and confirm data requirements, ensuring alignment with business objectives.-Developed and implemented ETL jobs to efficiently ingest flat files into RDBMS systems such as PostgreSQL and MySQL, improving data accessibility and usability.-Utilized SQL for query authoring and performed data analysis to answer specific business questions, identify opportunities for improvement, and enhance decision-making.-Conducted root cause analysis on data and scripts, diagnosing issues, and implementing solutions to enhance data quality and correctness.-Prepared comprehensive test plans based on functional and technical requirements, ensuring rigorous testing processes.-Built unit test cases and executed testing for ETL jobs, focusing on data quality and correctness.-Applied expertise in AWS, including S3, EC2, and RDS (PostgreSQL), to perform similar data management activities, optimizing cloud-based solutions.-Managed the installation, upgrade, and day-to-day administration of SAS and related components on SAS Unix Server and Windows machines.-Efficiently handled SAS BI administration tasks, ensuring the smooth operation of SAS environments.-Demonstrated proficiency in troubleshooting basic SAS server issues, capacity management, and archive backup planning.Duration: Dec 2014 April 2015Role: Credit AssociateClient: Kotak Mahindra Bank Ltd. (INDIA)-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.-Cash flow method of assessment of NRI Loans, Ability to assess a Self Employed Loan-Supervision and performance management of all team membersSupervision 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 Updation for Disbursement, Resolving Legal Queries, and Fixing of Disbursement, Technical Updation, and Disbursement Fixing.-Project Approval Creation of Property No, Query Resolving, Builder Appointment, Project ApprovalDuration: Jun 2012 May 2013Role: Credit AnalystClient: HDFC BANK (INDIA)-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 membersSupervision 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 Updation for Disbursement, Resolving Legal Queries, and Fixing of Disbursement, Technical Updation, and Disbursement Fixing.-Project Approval Creation of Property No, Query Resolving, Builder Appointment, Project Approval-LMS Timely Updation of Leads into LMS, Proper Follow-up on the next scheduled action date, Auditing of Leads, feedback & status. |
