Nirmal K Email and Phone Number
I am a Senior Data Analyst with over 8 years of experience in data recording, interpretation, and analysis. My expertise includes expanding data collection platforms, advanced data warehousing, data marts, metadata, and data modeling on RDBMS databases. Skilled in PL/SQL, Oracle, Python, Power BI, SQL, SSIS, SSRS, and Excel.I excel in designing and implementing data structures, data lineage correction, and data modeling for OLTP and OLAP systems. My experience spans market research, data analyses, profiling, gap analyses, risk management, and data migration. I have a strong foundation in data visualization, ensuring data accuracy and accessibility.Proficient in Teradata SQL coding, UNIX shell scripting, and using Informatica for ETL processes, I maintain database integrity and compliance with regulatory requirements. Experienced in performance tuning, system specification documentation, OLTP/OLAP systems, and MS SQL Server suite products.I thrive in Agile environments and the full SDLC, bringing innovation, efficiency, and strong debugging skills. Excellent at collaborating with stakeholders, I am committed to staying current with the latest technologies.
Santander Bank, N.A.
View- Website:
- santanderbank.com
- Employees:
- 11664
-
Sr. Data AnalystSantander Bank, N.A. Mar 2023 - PresentLawrenceville, New Jersey, United StatesAt Santander Bank, I gather and document business and system requirements, analyze client data, and collaborate with the Analytics team to inspect, cleanse, transform, and model data. I use visualization tools like Tableau, Spotfire, and SharePoint to provide insights.I implement multidimensional and tabular cubes, configure Azure platform offerings (Power BI, Azure Data Factory), and design ETL processes using SQL Server Integration Services (SSIS). I create and publish data models using Erwin and assist with SQL database mining for presentations.My responsibilities include data profiling on Oracle and Teradata systems, developing workflow analysis, managing data governance, and creating dashboards in Excel and Power BI. I build reporting infrastructures using Power BI and SQL, facilitate UAT and PPV, and maintain metadata and data dictionaries.Additionally, I am involved in data modeling for the QRM Mortgage Application migration to Teradata, create complex SQL queries for reporting, and conduct data cleaning and analysis using SAS tools.
-
Sr. Data AnalystNationwide Dec 2021 - Feb 2023Columbus, Ohio, United StatesAt Nationwide Insurance, I performed daily validation of business data reports, gathered business requirements, and analyzed functional and non-functional data elements. I worked with claims data from various sources, including flat files, Oracle, and Mainframes, and optimized complex queries for data retrieval.I led data correction and validation processes, conducted root cause analysis of data discrepancies, and performed extensive data mining and profiling. I created Power BI reports, conducted quality control with SAS, and managed data aspects of multiple projects through various stages. I was involved in User Acceptance Testing (UAT) and regression testing, documented custom and system modifications, and supported deployment and business user activities during UAT. -
Data AnalystVoya Financial Jul 2020 - Nov 2021New York, New York, United StatesAt Voya Financial, I was responsible for gathering data migration requirements and identifying problematic areas to correct data issues. I analyzed data reports for duplicates and errors, monitored data elements for accuracy, and identified trends in complex data sets. I developed logical and physical data models using Erwin and was involved in data mapping and cleanup.I ensured a smooth transition from legacy to newer systems, archived old data, and maintained SAS programs. I created technical design documents, unit test cases, and reviewed PL/SQL migration scripts. Additionally, I planned project activities, created user guidance documentation, and developed reconciliation reports to validate migrated data. -
Data AnalystGentiva Dec 2018 - Jun 2020At Gentiva Health, I analyzed business and functional requirements to understand the business process and defined key facts and dimensions to support business needs. I created draft data models and resolved data-related issues such as data quality assessment and data consolidation. I performed metadata analysis and acted as a data steward to maintain quality metrics continuously.My role involved data migration, cleansing, and manipulation using Excel, Access, and SQL. I developed new statistical models to extract insights from large volumes of data, conducted goodness-of-fit tests, and emphasized data quality management. I developed logical and physical data models using Erwin, enforced naming standards, and conducted data mapping and cleanup.I facilitated a smooth transition from legacy to newer systems, archived old data, maintained SAS programs, and coded PL/SQL packages for application security and batch job scheduling. Additionally, I created reconciliation reports for validating migrated data. -
Data AnalystSun Life Jun 2016 - Nov 2018Boston, Massachusetts, United StatesAt Sun Life Financials, I focused on understanding logical and physical data models using Erwin and rebuilding BI reports from Cognos to Crystal Reports. I wrote complex SQL queries for data validation and verified ETL mapping rules. My responsibilities included creating sessions and workflows for data loading into the Data Warehouse using Informatica Workflow Manager.I utilized Master Data Management (MDM) tools to ensure consistent and accurate master lists and handled data import/export between Microsoft Access, Excel, text files, and SQL. I extensively tested reports for data accuracy and errors, validated data using SQL and PL/SQL, and participated in user training and UAT (User Acceptance Testing). I also wrote data conversion and migration scripts for ETL processes and used various tools for data validation and reporting.
Nirmal K Education Details
Frequently Asked Questions about Nirmal K
What company does Nirmal K work for?
Nirmal K works for Santander Bank, N.a.
What is Nirmal K's role at the current company?
Nirmal K's current role is Senior Data Analyst | 8+ Years in Data Warehousing, Modeling, and Analysis | Expertise in Banking, Financial & Insurance domains | Proficient in Python, SQL, Power BI, Tableau..
What schools did Nirmal K attend?
Nirmal K attended Tribhuvan University.
Who are Nirmal K's colleagues?
Nirmal K's colleagues are Mattheus Emanuel, Michael Papaleo, Jamile Watson, Lisa Hill, Monica Bell, Akash P, Paul Timmins.
Not the Nirmal K you were looking for?
-
-
Nirmal K., CFA., FRM
Business Strategy | Head Of Global Fp&A : Strategic Planning| Pe Investments | Debt Facility Raising| Ipo Preparation| Kpi Development And Margin Improvement| Rfp Pricing And Commercial NegotiationDallas, Tx -
Nirmal Kumar K
Vandalia, Oh -
Free Chrome Extension
Find emails, phones & company data instantly
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial